前言:
现时朋友们对“phpsqlite操作类”大致比较珍视,你们都想要剖析一些“phpsqlite操作类”的相关资讯。那么小编在网上收集了一些关于“phpsqlite操作类””的相关文章,希望你们能喜欢,兄弟们快快来了解一下吧!突如其来的代码!!!
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);
结束!
喜欢请点击关注哦,更多精彩内容请看下集!
标签: #phpsqlite操作类