Last updated: Fri, 20 Nov 2009

Predefined Constants

The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime.

Since PHP 4.3.0 it is possible to specify additional client flags for the mysql_connect() and mysql_pconnect() functions. The following constants are defined:

**MySQL client constants**
Constant	Description
`MYSQL_CLIENT_COMPRESS`	Use compression protocol
`MYSQL_CLIENT_IGNORE_SPACE`	Allow space after function names
`MYSQL_CLIENT_INTERACTIVE`	Allow interactive_timeout seconds (instead of wait_timeout) of inactivity before closing the connection.
`MYSQL_CLIENT_SSL`	Use SSL encryption. This flag is only available with version 4.x of the MySQL client library or newer. Version 3.23.x is bundled both with PHP 4 and Windows binaries of PHP 5.

The function mysql_fetch_array() uses a constant for the different types of result arrays. The following constants are defined:

**MySQL fetch constants**
Constant	Description
`MYSQL_ASSOC`	Columns are returned into the array having the fieldname as the array index.
`MYSQL_BOTH`	Columns are returned into the array having both a numerical index and the fieldname as the array index.
`MYSQL_NUM`	Columns are returned into the array having a numerical index to the fields. This index starts with 0, the first field in the result.

add a note User Contributed Notes
Predefined Constants

Contact at LinuxIntro dot com
28-Oct-2008 03:33


When you connect and expect to use a stored procedure,you must pass a special flag to MySQL via the connect command, otherwise you will not get the results returned, and it will result in this error:

PROCEDURE AlexGrim.GetStats_ForumCategories can't return a result set in the given context



To fix this, change you connection string, adding ",false,65536" as the last 2 fields:

$this->con = mysql_connect($this->h,$this->u,$this->p,false,65536);

add a note

Examples

Resource Types

Last updated: Fri, 20 Nov 2009