/** * 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