$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");