* - Create a variable to hold the results and call retrieve().
* 2.) You can retrieve only results from one row.
* - Create a variable to hold results, call retrieve()
* and pass the row number (indexed 0-i).
* 3.) You can omit certain fields from the result.
* - Create an array of the columns you would like to omit.
* then call the ignore method with the array of omitted columns.
*
* To display results, create a variable to hold the result from the
* retrieve method. Next create a variable to hold the array of rows
* that is returned from the get rows method. Create a nested foreach
* loop, the inner loop will give access to the column name and its value.
*
*/
$db->setTable("test1");
$result = $db->retrieve();
/* Obtain all results from a table.
* Print all fields with thier value.
*/
$tableRows = $result->getRow();
// Gets all rows from table
foreach ($tableRows as $row) {
foreach ($row as $field => $value) {
echo $field . " => " . $value . "</br>";
}
}
/* Obtain results from certain row in table.
* Print all fields with thier value.
*/
$tableRow = $result->getRow(0);
// Get the first row from table
