echo $db->error; echo '<br>'; echo DBHelper::dumpNext($db->getNext(ANYDB_RES_ASSOC), true); echo '<br>'; echo $db->error; echo '<hr>'; // get a row $query = "select * from {$table}"; $db->query($query); echo 'getNext(ANYDB_RES_BOTH): ' . $query; echo '<br>'; echo DBHelper::dumpNext($db->getNext(ANYDB_RES_BOTH), true); echo '<br>'; echo $db->error; echo '<br>'; echo DBHelper::dumpNext($db->getNext(ANYDB_RES_BOTH), true); echo '<br>'; echo $db->error; echo '<hr>'; // get a column $query = "select {$tableKey} from {$table} where {$tableKey}<10"; $db->query($query); echo 'getColumn(): ' . $query; echo '<br>'; echo DBHelper::dumpColumn($db->getColumn(), true); echo '<br>'; echo $db->error; echo '<hr>'; // show widget echo 'new PageWidget() :'; echo '<br>';
<?php require "connect.inc.php"; // get the next result set as a numeric array if ($db->query("SELECT name, email FROM users where id=2")) { $res = $db->getNext(ANYDB_RES_BOTH); echo DBHelper::dumpNext($res, true); } else { echo $db->error; } require "disconnect.inc.php"; //////////////////////////////////////////////////////////////////////// echo '<hr>'; highlight_file(__FILE__);