Return to sqlite_019.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sqlite / tests

Annotation of embedaddon/php/ext/sqlite/tests/sqlite_019.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: sqlite: single query
                      3: --SKIPIF--
                      4: <?php # vim:ft=php
                      5: if (!extension_loaded("sqlite")) print "skip"; ?>
                      6: --FILE--
                      7: <?php
                      8: include "blankdb.inc";
                      9:        
                     10: sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )");
                     11: for ($i = 0; $i < 10; $i++) {
                     12:        sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')");
                     13: }
                     14: sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)");
                     15:                                                 
                     16: var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5"));
                     17: var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=4"));
                     18: var_dump(sqlite_single_query($db, "SELECT data FROM test_db WHERE id=6"));
                     19: var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id < 5"));
                     20: var_dump(sqlite_single_query($db, "SELECT * FROM test db WHERE id < 4"));
                     21: var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=999999"));
                     22: var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5", FALSE));
                     23: 
                     24: sqlite_close($db);
                     25: ?>
                     26: --EXPECTF--
                     27: string(1) "5"
                     28: string(1) "4"
                     29: string(5) "5data"
                     30: array(4) {
                     31:   [0]=>
                     32:   string(1) "1"
                     33:   [1]=>
                     34:   string(1) "2"
                     35:   [2]=>
                     36:   string(1) "3"
                     37:   [3]=>
                     38:   string(1) "4"
                     39: }
                     40: 
                     41: Warning: sqlite_single_query(): no such table: test in %s on line %d
                     42: bool(false)
                     43: NULL
                     44: array(1) {
                     45:   [0]=>
                     46:   string(1) "5"
                     47: }