* Below the returned $rs2 array is not referential. Because of that, the system * will use excesive memory. With large columns. */ $rs2 = $db->GetAll($sql); foreach ($rs2 as $value) { list($r1, $r2, $r3) = $value; echo "f1: {$r1}, f2: {$r2}, f3: {$r3}", $timer->isCli(1); } $timer->setMark('foreach'); /** * prepared statements * and array needs to be passed as an argument */ $rs = $db->PExecute('SELECT * FROM Country WHERE Continent = ?', 'Europe'); $out = array(); while ($rows = $db->Pquery($out)) { print_r($out); } $rs = $db->PExecute('UPDATE Country SET code=? WHERE Code="PRT"', 'PRT'); /** * Returns the number of rows affected by INSERT, UPDATE, or DELETE query. * an UPDATE prepared statement which contains the same data as that already * in the database returns 0 for affected_rows */ echo $db->getNumOfRowsAffected(), PHP_EOL; $timer->setMark('stmt'); echo $timer->isCli(1); # ------------------------------------------------------------------------------ echo PHP_EOL, str_repeat('-', 80), PHP_EOL; $timer->printMarks(); echo str_repeat('-', 80), PHP_EOL, 'Time: ', $timer->getPageLoadTime(), ' - Memory: ', $timer->getMemoryUsage(1), PHP_EOL, str_repeat('-', 80), PHP_EOL;