PHP DBHelper::dumpNext Exemples

Exemple #1

Fichier : test1.php Projet : jsan4christ/idrc-uganda-site

 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>';

Exemple #2

Fichier : getNextBoth.php Projet : jsan4christ/idrc-uganda-site

<?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__);