1--TEST-- 2SQLite3::query SELECT with no results 3--SKIPIF-- 4<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> 5--FILE-- 6<?php 7 8require_once(dirname(__FILE__) . '/new_db.inc'); 9define('TIMENOW', time()); 10 11echo "Creating Table\n"; 12var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 13 14echo "SELECTING results\n"; 15$results = $db->query("SELECT * FROM test ORDER BY id ASC"); 16while ($result = $results->fetchArray(SQLITE3_NUM)) 17{ 18 var_dump($result); 19} 20$results->finalize(); 21 22echo "Closing database\n"; 23var_dump($db->close()); 24echo "Done\n"; 25?> 26--EXPECTF-- 27Creating Table 28bool(true) 29SELECTING results 30Closing database 31bool(true) 32Done 33