X. SQLite My Fire! (partea II)

<?php  
 
// check to see if the form was submitted with a new record  
if (isset($_POST['submit'])) {  
    // make sure both title and author are present  
if (!empty($_POST['title']) && !empty($_POST['author'])) {  
        // generate INSERT query  
        $insQuery = "INSERT INTO books (title, author) VALUES (\"".
        sqlite_escape_string        ($_POST['title'])."\", \"".
        sqlite_escape_string($_POST['author'])."\")";  
        
        // execute query  
        $insResult = sqlite_query($handle, $insQuery) or die
        ("Error in query: ".sqlite_error_string
        (sqlite_last_error($handle)));  
        
        // print success message  
        echo "<i>Record successfully inserted with ID "
        .sqlite_last_insert_rowid($handle)."!</i><p />";  
    }  
    else {  
        // missing data  
        // display error message  
        echo "<i>Incomplete form input. Record not inserted!</i><p />";  
    }  
}  
 
?>

<?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  
 
// 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);  
 
?>

<?php  
 
// version  
echo "SQLite version: ".sqlite_libversion()."<br />";  
// encoding  
echo "SQLite encoding: ".sqlite_libencoding()."<br />";  
 
?>

<?php  
 
// set path of database file  
$db = $_SERVER['DOCUMENT_ROOT']."/../library.db";  
 
// open database file  
$handle = sqlite_open($db) or die("Could not open database");  
 
// generate query string  
// query contains a deliberate error  
$query = "DELETE books WHERE id = 1";  
 
// execute query  
$result = sqlite_query($handle, $query) or die("Error in query: "
.sqlite_error_string(sqlite_last_error($handle)));  
 
// all done  
// close database file  
sqlite_close($handle);  
 
?>