- CREATE A NEW TABLE IN A .db FILE:
$dbfile = 'foo.db';
"
"
if (!$db = sqlite_open($dbfile, 0666, $err) ) { die($err); }
"
"
$create='CREATE TABLE CONTACTS(
"
"
name VARCHAR(32),
"
"
precall VARCHAR(5),
"
"
number VARCHAR(30)
"
"
)';
"
"
$sql = sqlite_query($db,$create);
"
"
sqlite_query($db, " INSERT INTO CONTACTS
"
"
VALUES ('PETER','089','4711')");
"
"
sqlite_query($db, " INSERT INTO CONTACTS
"
"
VALUES ('ANNA','040','1122')");
"
"
sqlite_query($db, " INSERT INTO CONTACTS
"
"
VALUES ('Maxi','089','9876')");
"
"
sqlite_close($db);
"
"