1--TEST-- 2SQLite3::prepare number of rows 3--SKIPIF-- 4<?php require_once(dirname(__FILE__) . '/skipif.inc'); 5// Create an instance of the ReflectionMethod class 6try { 7 $method = new ReflectionMethod('sqlite3result', 'numRows'); 8} catch (ReflectionException $e) { 9 die("skip"); 10} 11?> 12--FILE-- 13<?php 14 15require_once(dirname(__FILE__) . '/new_db.inc'); 16define('TIMENOW', time()); 17 18echo "Creating Table\n"; 19var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 20 21echo "INSERT into table\n"; 22var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')")); 23var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 24 25echo "SELECTING results\n"; 26$results = $db->query("SELECT * FROM test ORDER BY id ASC"); 27echo "Number of rows\n"; 28var_dump($results->numRows()); 29$results->finalize(); 30 31echo "Closing database\n"; 32var_dump($db->close()); 33echo "Done\n"; 34?> 35--EXPECTF-- 36Creating Table 37bool(true) 38INSERT into table 39bool(true) 40bool(true) 41SELECTING results 42Number of rows 43int(2) 44Closing database 45bool(true) 46Done 47