<?php/***//應(yīng)用舉例require_once('cls_sqlite.php');//創(chuàng)建實(shí)例$DB=new SQLite('blog.db'); //這個(gè)數(shù)據(jù)庫文件名字任意//創(chuàng)建數(shù)據(jù)庫表。$DB->query("create table test(id integer primary key,title varchar(50))");//接下來添加數(shù)據(jù)$DB->query("insert into test(title) values('泡菜')");$DB->query("insert into test(title) values('藍(lán)雨')");$DB->query("insert into test(title) values('Ajan')");$DB->query("insert into test(title) values('傲雪藍(lán)天')");//讀取數(shù)據(jù)print_r($DB->getlist('select * from test order by id desc'));//更新數(shù)據(jù)$DB->query('update test set 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) //直接運(yùn)行SQL，可用于更新、刪除數(shù)據(jù) {  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(); }}?>

<?php$conn = sqlite_open('test.db');?>

;extension=php_sqlite.dll;extension=php_pdo.dll;extension=php_pdo_sqlite.dll