Internet CD 2004 November/MICD_2004_11.iso/Warsztat_PHP/sqlite.php

PHP Script | 2004-10-04 | 354 b | 9 lines

<?
$sqlite = new SQLiteDatabase("jakasbaza.sqlite");
$sqlite->query('CREATE TABLE jakastabela (id INTEGER PRIMARY KEY, a, b);
    INSERT INTO jakastabela (a,b) VALUES ("abcd", "1.43")');
echo 'Ostatnio dodany ID: '.$sqlite->lastInsertRowid();

$array = $sqlite->arrayQuery('SELECT * FROM jakastabela WHERE id = 1', SQLITE_ASSOC);
print_r($array);
?>