Main Menu

PHP Tools
PHP Help Request
PHP Editors Newsletter
Editor Search
Reviewed PHP Editors
Latest News
Submit News
PHP Tutorials
PHP Book Reviews
Online Book Chapters
PHP Games

Forums

PHP Desktop Editors
Other PHP Tools
PHP Contests
PHP Programming Help
Linux Help
Apache Help
MySQL Help
PHP Games
PHP Jobs
PHP Forums Home

Programming Contest

PHP Contests
PHP Contests Archive

Documentation

PHP Manual
PEAR Manual
PHP-GTK Manual
Smarty Manual
PostgreSQL Manual
CSS 2 Reference
Redhat Linux 9
HTML 4.01
Apache 2 Manual

Partner Sites

Ajax Tutorials
Webmaster Resources
Web Templates
PHP Scripts
PHP Code Examples
Learn PHP playing Trivia
PHP & MySQL Forums
Web Development Index
web site templates

MDB_Common::getAll()

MDB_Common::getAll() -- Fetch all rows

Synopsis

require_once 'MDB.php';

array &getAll (string $query, array [$types = NULL], array [$params = array()], array [$param_types = NULL], integer [$fetchmode = MDB_FETCHMODE_DEFAULT])

Description

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.

Parameter

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

Throws

Table 33-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`MDB_ERROR_INVALID`	`NULL`	SQL statment for preparing is not valid.	See the prepareQuery() documentation, if you want to use a SQL statemt using wildcards.
`MDB_ERROR_NEED_MORE_DATA`	`NULL`	To less data for filling the prepared SQL statment.	Check the number of wild cards given in the SQL statment prepareQuery() . Check the count of entries in the array for `$params`. The count of entries have to be equal to the number of wild cards.
`MDB_ERROR_NO_DB_SELECTED`	`NULL`	No database was choosen.	Check the DSN in connect() .
every other error code		Database specific error	Check the database related section of PHP-Manual to detect the reason for this error. In the most cases a misformed SQL statment. Ie. using LIMIT in a SQL-Statment for an Oracle database.

Note

This function can not be called statically.

See

query() , limitQuery() , prepareQuery() executeQuery() , getCol() , getRow() , getAssoc() , getOne()

Prev	Home	Next
MDB_Common::freeResult()	Up	MDB_Common::getAssoc()