/** * Fetch data from database * @param string $query * @param bool $replica Allow reading data from db replica * @return array */ public function fetch($query, $replica = false) { $this->connect(); Debugger::prepareDBLine(); $result = $this->realFetch($query, $replica); Debugger::addDBLine('MySQL', $query); $this->queries++; return $result; }
/** * Fetch single column * @param string $query * @param array $parameters * @param int $column_number * @return array|bool */ public function fetchColumn($query, $parameters = [], $column_number = 0) { Debugger::prepareDBLine(); $sth = $this->prepare($query); $sth->execute($parameters); $data = []; while (($row = $sth->fetchColumn($column_number)) !== false) { $data[] = $row; } Debugger::addDBLine('DB', $query); return $data; }