/** @return PDOStatement */ function query($start = null, $count = null) { $sql = $this->getSql($start, $count); $sql = preg_replace('/^SELECT /i', 'SELECT SQL_CALC_FOUND_ROWS ', $sql); $ret = $this->db->queryResultOnly($sql); $this->foundRows = $this->db->selectCell("SELECT FOUND_ROWS()"); return $ret; }
/** for debug usage only! */ function _dumpAll($whereAdd = null) { $q = $this->_db->queryResultOnly("SELECT * FROM {$this->_table} WHERE 1 {$where}"); while ($row = $this->_db->fetchRow($q)) { $rec = new $this->_recordClass(); $rec->fromRow($row); print (string) $rec; print "\n<br />\n"; } }