sqlite_019.phpt

来自「PHP v6.0 For Linux 运行环境：Win9X/ WinME/ Wi」· PHPT 代码 · 共 70 行

--TEST--
sqlite: single query
--SKIPIF--
<?php # vim:ft=php
if (!extension_loaded("sqlite")) print "skip"; ?>
--FILE--
<?php
include "blankdb.inc";
	
sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )");
for ($i = 0; $i < 10; $i++) {
	sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')");
}
sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)");
	                                         
var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5"));
var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=4"));
var_dump(sqlite_single_query($db, "SELECT data FROM test_db WHERE id=6"));
var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id < 5"));
var_dump(sqlite_single_query($db, "SELECT * FROM test db WHERE id < 4"));
var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=999999"));
var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5", FALSE));

sqlite_close($db);
?>
--EXPECTF--
string(1) "5"
string(1) "4"
string(5) "5data"
array(4) {
  [0]=>
  string(1) "1"
  [1]=>
  string(1) "2"
  [2]=>
  string(1) "3"
  [3]=>
  string(1) "4"
}

Warning: sqlite_single_query(): no such table: test in %s on line %d
bool(false)
NULL
array(1) {
  [0]=>
  string(1) "5"
}
--UEXPECTF--
unicode(1) "5"
unicode(1) "4"
unicode(5) "5data"
array(4) {
  [0]=>
  unicode(1) "1"
  [1]=>
  unicode(1) "2"
  [2]=>
  unicode(1) "3"
  [3]=>
  unicode(1) "4"
}

Warning: sqlite_single_query(): no such table: test in %s on line %d
bool(false)
NULL
array(1) {
  [0]=>
  unicode(1) "5"
}