Changeset 13
- Timestamp:
- 12/01/07 14:42:58 (1 year ago)
- Files:
-
- trunk/tests/sqlite3_02_create.phpt (modified) (1 diff)
- trunk/tests/sqlite3_03_insert.phpt (modified) (2 diffs)
- trunk/tests/sqlite3_04_update.phpt (added)
- trunk/tests/sqlite3_05_delete.phpt (added)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/tests/sqlite3_02_create.phpt
r2 r13 10 10 echo "Creating Table\n"; 11 11 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 12 12 13 echo "Creating Same Table Again\n"; 13 14 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 15 14 16 echo "Dropping database\n"; 15 17 var_dump($db->exec('DROP TABLE test')); 18 16 19 echo "Closing database\n"; 17 20 var_dump($db->close()); trunk/tests/sqlite3_03_insert.phpt
r10 r13 11 11 echo "Creating Table\n"; 12 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 13 13 14 echo "INSERT into table\n"; 14 15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')")); 15 16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 17 16 18 echo "SELECTING results\n"; 17 $result = $db->query("SELECT * FROM test ORDER BY id ASC"); 18 var_dump($result->fetch_array(SQLITE3_NUM)); 19 var_dump($result->fetch_array(SQLITE3_NUM)); 20 $result->finalize(); 19 $results = $db->query("SELECT * FROM test ORDER BY id ASC"); 20 while ($result = $results->fetch_array(SQLITE3_NUM)) 21 { 22 var_dump($result); 23 } 24 $results->finalize(); 25 26 echo "Closing database\n"; 27 var_dump($db->close()); 21 28 echo "Done\n"; 22 29 ?> … … 40 47 string(1) "b" 41 48 } 49 Closing database 50 bool(true) 42 51 Done
