*: CREATE A NEW TABLE IN A .db FILE:


$dbfile = 'foo.db';
"{linebreak}"
if (!$db = sqlite_open($dbfile, 0666, $err) ) { die($err); }
"{linebreak}"
$create='CREATE TABLE CONTACTS(
"{linebreak}"
name VARCHAR(32),
"{linebreak}"
precall VARCHAR(5),
"{linebreak}"
number VARCHAR(30)
"{linebreak}"
)';
"{linebreak}"
$sql = sqlite_query($db,$create);
"{linebreak}"

sqlite_query($db, " INSERT INTO CONTACTS
"{linebreak}"
VALUES ('PETER','089','4711')");
"{linebreak}"
sqlite_query($db, " INSERT INTO CONTACTS
"{linebreak}"
VALUES ('ANNA','040','1122')");
"{linebreak}"
sqlite_query($db, " INSERT INTO CONTACTS
"{linebreak}"
VALUES ('Maxi','089','9876')");
"{linebreak}"
sqlite_close($db);
"{linebreak}"
------------------------------------------