sqlite3封装类 php,php 超级实用的SQLite3类

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 INTO  tb_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_log  message='test by luu' where   id=5";

$sqlite->query($uptsql);