Examples of javascript Guestbook using a MySQL database

-- Example of PHP opening an SQLITE database.

This example uses a very old format. It works on my Goflex NAS.

<?php
    if ($db = sqlite3_open( './sqlDB' ) ) { 

        printf( "opi:".$db."\n" );
        $result = sqlite3_query($db, 'select * from GB ');

        // var_dump() serializes the variables and is useful debug

        while (  $row=sqlite3_fetch_array( $result )  ) { 
            printf(" ============ \n" );
            var_dump( $row ); 
        } 
    } else {
        printf( "err:".$db." ".$sqliteerror."\n" );
        die($sqliteerror);
    }
?>

-- Examples of javascript Guestbook using a SQLITE database.

-- A schema for SQLite3 data base:

-- sqlite3 gb.db ".dump" > gb.sql

-- Copy the following into gb.sql and import into a database:

-- sqlite3 gb.db ".read gb.sql"

BEGIN TRANSACTION;

CREATE TABLE GB(  
	name 	   TEXT ,
	email 	   TEXT ,
	postedOn   TEXT ,
	IPaddress  TEXT ,
	userfield1 TEXT ,
	userfield2 TEXT ,
	userfield3 TEXT ,
	userfield4 TEXT ,
	comments   TEXT
);

COMMIT;