- CREATE A NEW TABLE IN A .db FILE:
<pre> $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); </pre>