1--TEST-- 2sqlite: sqlite_fetch_object 3--INI-- 4sqlite.assoc_case=0 5--SKIPIF-- 6<?php # vim:ft=php 7if (!extension_loaded("sqlite")) print "skip"; ?> 8--FILE-- 9<?php 10include "blankdb.inc"; 11 12class class24 { 13 function __construct() { 14 echo __METHOD__ . "\n"; 15 } 16} 17 18$data = array( 19 "one", 20 "two", 21 "three" 22 ); 23 24sqlite_query($db, "CREATE TABLE strings(a)"); 25 26foreach ($data as $str) { 27 sqlite_query($db, "INSERT INTO strings VALUES('$str')"); 28} 29 30echo "====class24====\n"; 31$res = sqlite_query($db, "SELECT a FROM strings", SQLITE_ASSOC); 32while (sqlite_valid($res)) { 33 var_dump(sqlite_fetch_object($res, 'class24')); 34} 35 36echo "====stdclass====\n"; 37$res = sqlite_query($db, "SELECT a FROM strings", SQLITE_ASSOC); 38while (sqlite_valid($res)) { 39 var_dump(sqlite_fetch_object($res)); 40} 41 42sqlite_close($db); 43 44echo "====DONE!====\n"; 45?> 46--EXPECTF-- 47====class24==== 48class24::__construct 49object(class24)#%d (1) { 50 ["a"]=> 51 string(3) "one" 52} 53class24::__construct 54object(class24)#%d (1) { 55 ["a"]=> 56 string(3) "two" 57} 58class24::__construct 59object(class24)#%d (1) { 60 ["a"]=> 61 string(5) "three" 62} 63====stdclass==== 64object(stdClass)#%d (1) { 65 ["a"]=> 66 string(3) "one" 67} 68object(stdClass)#%d (1) { 69 ["a"]=> 70 string(3) "two" 71} 72object(stdClass)#%d (1) { 73 ["a"]=> 74 string(5) "three" 75} 76====DONE!==== 77
