MDB_Common::getAll() -- Fetch all rows


Fetch the entire result set of a query and return it into a nested array. The function takes care of doing the query and freeing the results when finished.


string $query

the SQL query

array $types

if supplied, the types of the columns in the result set will be set for fetching

array $params

if supplied, prepareQuery()/ executeQuery() will be used with this array as execute parameters

array $param_types

if supplied, the values in $param will automatically set to the passed datatypes

integer $fetchmode

the fetch mode to use, default is MDB_FETCHMODE_DEFAULT

Return value

  • array - an nested array or a MDB_Error, if fail


This function can not be called statically.

© Copyright 2003-2014 The ultimate PHP Editor and PHP IDE site.