/**
* Fetch all rows.
*
* @return array
*/
public function all($wheres = array(), $columns = array())
{
$columns = $this->grammar->buildSelectExpression($columns);
$statement = "SELECT * FROM {$this->table}";
$statement .= $this->grammar->buildWhereClause($wheres);
dd($columns, $statement);
$bindings = array();
return $this->pdo->fetchAll($statement, $bindings);
}
/**
* Returns an array containing all of the result set rows.
*
* Behaves like parent, but if limit()
* is used, the final result removes the extra column
* 'zend_db_rownum'
*
* @param int $style OPTIONAL Fetch mode.
* @param int $col OPTIONAL Column number, if fetch mode is by column.
* @return array Collection of rows, each in a format by the fetch mode.
* @throws \Zend\DB\Statement\Exception
*/
public function fetchAll($style = null, $col = null)
{
$data = parent::fetchAll($style, $col);
$results = array();
$remove = $this->_adapter->foldCase('ZEND_DB_ROWNUM');
foreach ($data as $row) {
if (is_array($row) && array_key_exists($remove, $row)) {
unset($row[$remove]);
}
$results[] = $row;
}
return $results;
}
<?php
$oDb = new PDO("sqlite:" . __DIR__ . "/cds.sqlite");
//$sQuery = "';DROP DATABASE testme;#'";
$sQuery = "pop";
if (isset($_GET['Genre'])) {
$sQuery = $_GET['Genre'];
}
$oDb->prepare("SELECT * FROM `cds` WHERE genre = :genre");
$oDb->bindParam("genre", $sQuery);
$oDb->execute();
$aResults = $oDb->fetchAll(PDO::FETCH_OBJ);
echo json_encode($aResults);
<?php
$db = new PDO('sqlite:/usr/local/data/sales.db');
$query = $db->query('SELECT region, start, end, amount FROM sales', PDO::FETCH_NUM);
$sales_data = $db->fetchAll();
$total = 0;
$column_headers = array('Region', 'Start Date', 'End Date', 'Amount');
// Decide what format to use
$format = $_GET['format'] == 'csv' ? 'csv' : 'html';
// Print format-appropriate beginning
if ($format == 'csv') {
$output = fopen('php://output', 'w') or die("Can't open php://output");
header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename="sales.csv"');
fputcsv($output, $column_headers);
} else {
echo '<table><tr><th>';
echo implode('</th><th>', $column_headers);
echo '</th></tr>';
}
foreach ($sales_data as $sales_line) {
// Print format-appropriate line
if ($format == 'csv') {
fputcsv($output, $sales_line);
} else {
echo '<tr><td>' . implode('</td><td>', $sales_line) . '</td></tr>';
}
$total += $sales_line[3];
}
$total_line = array('All Regions', '--', '--', $total);
// Print format-appropriate footer
