sqlite_query()函数 

    你会记得，在本教程的开始，我就建议你用SQLite命令行程序初始化library.db数据库。但那并不是唯一的创建新的SQLite数据库的方法(你可以使用PHP自身通过sqlite_query()函数发出必要的CREATE TABLE和INSERT命令来创建)。下面是具体的做法：

<?php
// set path of database file 
$db = $_SERVER['DOCUMENT_ROOT']."/../library2.db";
// open database file 
$handle = sqlite_open($db) or die("Could not open database");
// create database 
sqlite_query($handle, "CREATE TABLE books 
  (id INTEGER PRIMARY KEY, title VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL)")
     or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
// insert records 
sqlite_query($handle, "INSERT INTO books (title, author) VALUES 
   ('The Lord Of The Rings', 'J.R.R. Tolkien')") or 
      die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
sqlite_query($handle, "INSERT INTO books (title, author) VALUES 
   ('The Murders In The Rue Morgue', 'Edgar Allan Poe')") or 
     die("Error in query: ".sqlite_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);
?>