Annotation of embedaddon/php/ext/sqlite/tests/sqlite_oo_021.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: sqlite-oo: single query
! 3: --SKIPIF--
! 4: <?php # vim:ft=php
! 5: if (!extension_loaded("sqlite")) print "skip"; ?>
! 6: --FILE--
! 7: <?php
! 8: include "blankdb_oo.inc";
! 9:
! 10: $db->query("CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )");
! 11: for ($i = 0; $i < 10; $i++) {
! 12: $db->query("INSERT INTO test_db (data) VALUES('{$i}data')");
! 13: }
! 14: $db->query("INSERT INTO test_db (data) VALUES(NULL)");
! 15:
! 16: var_dump($db->singleQuery("SELECT id FROM test_db WHERE id=5"));
! 17: var_dump($db->singleQuery("SELECT * FROM test_db WHERE id=4"));
! 18: var_dump($db->singleQuery("SELECT data FROM test_db WHERE id=6"));
! 19: var_dump($db->singleQuery("SELECT * FROM test_db WHERE id < 5"));
! 20: var_dump($db->singleQuery("SELECT * FROM test db WHERE id < 4"));
! 21: var_dump($db->singleQuery("SELECT * FROM test_db WHERE id=999999"));
! 22: var_dump($db->singleQuery("SELECT id FROM test_db WHERE id=5", FALSE));
! 23:
! 24: echo "DONE!\n";
! 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: SQLiteDatabase::singleQuery(): no such table: test in %s on line %d
! 42: bool(false)
! 43: NULL
! 44: array(1) {
! 45: [0]=>
! 46: string(1) "5"
! 47: }
! 48: DONE!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>