Main (PHP)

Home Forums PHP News PHP Tutorials Articles PHP Code Snippets Contact Us Sysadmin Resources Books Template Shop

3rd Party Streams

SlashDot PHPDeveloper.org PHP.Net

Resources

PHP Manual MySQL Manual Smarty Manual PEAR Manual PHP-GTK Manual Symfony Manual

Code Snippets

Authentication Database Graphics HTTP Miscellaneous Time/Date

Affiliates

Scripts TutorialMan TutorialGuide CodingForums.com PHP Scripts Cheap Web Hosting Affordable Web Hosting Dreamweaver Templates

MDB_Common::executeQuery()

PEAR Manual
Prev		Next

MDB_Common::executeQuery()

MDB_Common::executeQuery() -- executes a prepared SQL statment

Synopsis

require_once 'MDB.php';

mixed executeQuery (resource $stmt, array [$types = NULL])

Description

executeQuery() joins the prepared SQL statment from prepareQuery() with the data that was set using one of the setParam() methods and executes the SQL query.

Parameter

resource $stmt: query handle from prepareQuery()
array $types: if supplied, the types of the columns in the result set will be set for fetching

Return value

mixed - a resource id/MDB_OK or a MDB_Error, if fail

Throws

Table 26-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`MDB_ERROR_INVALID`	`NULL`	SQL statment handle is not valid.	Check correct processing of the SQL statment with prepareQuery() . Note that executeQuery() requires a handle to the statement returned by prepareQuery() , not the statment itself.
`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 for prepareQuery() . Check the count of entries in the array for `$data`. 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 Introduction - Execute for general using and an example.

See

prepareQuery() , executeMultiple()

Prev	Home	Next
MDB_Common::execute()	Up	MDB_Common::executeMultiple()

Print this page

Top Sponsor

$Symantec\'s Norton SystemWorks 2006$