$db->pln($db->a2sSelect($iArray), "select");
// old test case
$sql = $db->qbSelect("books", ['where' => "id <3"]);
$db->pln($sql, "sql");
echo "<p />Samples use object _call dbFetch";
$db->pln($db->row2Array($sql), "row2array-num");
$db->pln($db->row2Array($sql, "assoc"), "row2array-assoc");
$db->pln($db->dbFetchAssoc($db->query($sql)), "dbFetchAssoc");
echo "<br />Samples use static __callStatic dbFetch: ";
$db->pln(PdoLite::dbFetchRow(PdoLite::query($sql)), "row");
$arr = PdoLite::dbFetchArray(PdoLite::query($sql));
$db->pln($arr, "both");
$db->pln(array_values($arr), "value");
$sql = $db->qbSelect("books", ['where' => "id <3"]);
echo "<p />dbFetch obj: ";
$res = $db->query($sql);
while ($row = $db->dbFetch($res, "obj")) {
$db->prt($row->id, "id");
}
echo "<br />dbFetch lazy: ";
$res = $db->query($sql);
while ($row = $db->dbFetch($res, "lazy")) {
$db->prt($row->id, "id");
}
foreach ($db->query($sql) as $row) {
$db->pln($row, "foreach obj");
$db->prt($row['id'], "id");
}
$sql = "SELECT * FROM books where id =1";
$db->pln($db->findRow($sql, "lazy"), "findRow lazy");
$db->pln($db->findRow($sql), "findRow obj");
