lite_error_string(sqlite_last_error($handle)));
sqlite_query($handle, "INSERT INTO books (title, author) VALUES (''Three Men In A Boat'', ''Jerome K. Jerome'')") or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
sqlite_query($handle, "INSERT INTO books (title, author) VALUES (''A Study In Scarlet'', ''Arthur Conan Doyle'')") or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
sqlite_query($handle, "INSERT INTO books (title, author) VALUES (''Alice In Wonderland'', ''Lewis Carroll'')") or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
// print success message
echo "<i>Database successfully initialized!";
// all done
// close database file
sqlite_close($handle);
?>

或者在PHP 5中，你可以使用面向对象方法：

<?php
// set path of database file
$file =

SERVER[''DOCUMENT_ROOT'']."/../library3.db";
// create database object
$db = new SQLiteDatabase($file) or die("Could not open database");
// create database
$db->query("CREATE TABLE books (id INTEGER PRIMARY KEY, title VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL)") or die("Error in query");
// insert records
$db->query("INSERT INTO books (title, author) VALUES (''The Lord Of The Rings'', ''J.R.R. Tolkien'')") or die("Error in query");
$db->query("INSERT INTO books (title, author) VALUES (''The Murders In The Rue Morgue'', ''Edgar Allan Poe'')") or die("Error in query");
$db->query("INSERT INTO books (title, author) VALUES (''Three Men In A Boat'', ''Jerome K. Jerome'')") or die("Error in query");
$db->query("INSERT INTO books (title, author) VALUES (''A Study In Scarlet'', ''Arthur Conan Doyle'')") or die("Error in query");
$db->query("INSERT INTO books (title, author) VALUES (''Alice In Wonderland'', ''Lewis Carroll'')") or die("Error in query");
// print success message
echo "<i>Database successfully initialized!";
// all done
// destroy database object
unset($db);
?>

几个额外的工具 

最后，SQLite API也包括了一些辅助函数来向你提供关于SQLite版本、编码以及最后一次失败操作所产生的错误代码和错误消息的信息。下列例子演示了sqlite_libversion()和sqlite_libencoding()函数，该等函数分别返回版本号和连接的SQLite库的编码：

<?php
// version
echo "SQLite version: ".sqlite_libversion()."<br />";
// encoding
echo "SQLite encoding: ".sqlite_libencoding()."<br />";
?>
当发生错误时，请使用sqlite_last_error()函数，它返回SQLite返回的最后错误代码。当然，这个错误代码(一个数值)本身并不是非常有用;为了将其转变为一条人类可读取的消息，将其结合sqlite_error_string()函数一起使用。考虑下面的例子，该例子通过试图运行一条故意有错的查询来对其进行解释说明：

<?php
// set path of database file
$db =

SERVER[''DOCUMENT_ROOT'']."/../library.db";
// open database f