class SQLite
{
function __construct($file)
{
try
{
$this->connection=new PDO('sqlite:'.$file);
}
catch(PDOException $e)
{
try
{
$this->connection=new PDO('sqlite2:'.$file);
}
catch(PDOException $e)
{
exit('error!');
}
}
}
function __destruct()
{
$this->connection=null;
}
function query($sql) //直接运行SQL，可用于更新、删除数据
{
return $this->connection->query($sql);
}
function getlist($sql) //取得记录列表
{
$recordlist=array();
foreach($this->query($sql) as $rstmp)
{
$recordlist[]=$rstmp;
}
return $recordlist;
}
function Execute($sql)
{
return $this->query($sql)->fetch();
}
function RecordArray($sql)
{
return $this->query($sql)->fetchAll();
}
function RecordCount($sql)
{
return count($this->RecordArray($sql));
}
function RecordLastID()
{
return $this->connection->lastInsertId();
}
}
$sql='select * from tb_log where id=5';
$sqlite=new SQLite('/trinovo/firewall/conf/firewall.db');
//$sqlite=new SQLite('/trinovo/firewall/firewall.db');
$rows=$sqlite->Execute($sql);
print_r($rows);
$addsql="INSERT INTOtb_log VALUES('5','1','2','2','system','login','test','admin','3232235944','1529592650','account','test','1','1','1')";
$sqlite->query($addsql);
echo $sqlite->RecordLastID();
$uptsql="update tb_logmessage='test by luu' whereid=5";
$sqlite->query($uptsql);
