query() query(string $sql, array $vars = array(), string $className = 'stdClass') : array Perform an SQL query Parameters string $sql array $vars string $className Returns array — Returns an array of stdClass objects, or whatever class provided in $className
queryField() queryField(string $sql, array $vars = array()) : mixed Perform an SQL query, but only return the first field of the first row. Parameters string $sql array $vars Returns mixed
queryOne() queryOne(string $sql, array $vars = array(), string $className = 'stdClass') : mixed Select the first row in the result as an instance of $className Parameters string $sql array $vars string $className Returns mixed
exec() exec(string $sql, array $vars = array()) : boolean Execute a database statement Parameters string $sql array $vars Returns boolean