$sql = 'SELECT * FROM user WHERE id = 123';
$user = $GLOBALS['dbi']->fetchSingleRow($sql);
produces
$user = array('id' => 123, 'name' => 'John Doe')
public fetchSingleRow ( string $query, string $type = 'ASSOC', object $link = null ) : array | boolean | ||
$query | string | The query to execute |
$type | string | NUM|ASSOC|BOTH returned array should either numeric associative or both |
$link | object | mysql link |
return | array | boolean | first row from result or false if result is empty |
/** * Returns the real row count for a table * * @return number */ function getRealRowCountTable() { // SQL query to get row count for a table. $result = $this->_dbi->fetchSingleRow(sprintf('SELECT COUNT(*) AS %s FROM %s.%s', Util::backquote('row_count'), Util::backquote($this->_db_name), Util::backquote($this->_name))); return $result['row_count']; }