如何从php中进入sqlite,php读取sqlite入门实例

//打开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 "
";

}

?>