php读取sqlite入门实例

<?php 
//打开sqlite数据库 
//$db = @sqlite_open("MM.sqlite", 0666, $error); // 不支持 
//$db = new PDO('sqlite:MM.sqlite'); 
//异常处理 
if (!$db) die("Connection Sqlite failed.\n"); 

//添加一个叫做foo的数据库 
//@sqlite_query($db, "CREATE TABLE foo (bar varchar(10))"); 
//插入一条记录 
//@sqlite_query($db, "INSERT INTO foo VALUES ('fnord')"); 

//检索所有记录 
$result = $db->query('select BottleEncryptUsrName from BottleTable4'); 

//打印获取的结果 
foreach($result as $row){ 
    echo $row[0]; 
    echo "<br>"; 
} 
?>