预定义常量

下列常量由此扩展定义，且仅在此扩展编译入 PHP 或在运行时动态载入时可用。

在 PHP 4.3.0 以后的版本中，允许在 mysql_connect() 函数和 mysql_pconnect() 函数中指定更多的客户端标记。下面列出所定义的常量：

**MySQL 客户端常量**
常量	说明
`MYSQL_CLIENT_COMPRESS`	使用压缩的通讯协议
`MYSQL_CLIENT_IGNORE_SPACE`	允许在函数名后留空格位
`MYSQL_CLIENT_INTERACTIVE`	允许设置断开连接之前所空闲等候的 interactive_timeout 时间（代替 wait_timeout）。
`MYSQL_CLIENT_SSL`	使用 SSL 加密。本标志仅在 MySQL 客户端库版本为 4.x 或更高版本时可用。在 PHP 4 和 Windows 版的 PHP 5 安装包中绑定的都是 3.23.x。

mysql_fetch_array() 函数使用一个常量来表示所返回数组的类型。下面是常量的定义：

**MySQL fetch 常量**
常量	说明
`MYSQL_ASSOC`	返回的数据列使用字段名作为数组的索引名。
`MYSQL_BOTH`	返回的数据列使用字段名及数字索引作为数组的索引名。
`MYSQL_NUM`	返回的数据列使用数字索引作为数组的索引名。索引从 0 开始，表示返回结果的第一个字段。

User Contributed Notes

frak at gingerhq dot net 30-Jun-2011 11:06


If you're using stored procedures and mysql_error() returns "PROCEDURE storedProcedureName can't return a result set in the given context", you need to pass an additional flag (CLIENT_MULTI_RESULTS) to mysql_connect() as such:

mysql_connect($hostname, $username, $password, true, 131072);



Some other sources say that you should use 65536. 65536 is actually the flag to allow multiple statements in a single mysql_query(), and is a security issue. The reason it allows you to receive results from stored procedures is because it implies 131072. To be safe, use 131072 over 65536.

pcdinh at phpvietnam dot net 13-Feb-2010 12:54


Other client flags extracted from MySQL client source



#define CLIENT_LONG_PASSWORD 1 /* new more secure passwords */

#define CLIENT_FOUND_ROWS 2 /* Found instead of affected rows */

#define CLIENT_LONG_FLAG 4 /* Get all column flags */

#define CLIENT_CONNECT_WITH_DB 8 /* One can specify db on connect */

#define CLIENT_NO_SCHEMA 16 /* Don't allow database.table.column */

#define CLIENT_COMPRESS 32 /* Can use compression protocol */

#define CLIENT_ODBC 64 /* Odbc client */

#define CLIENT_LOCAL_FILES 128 /* Can use LOAD DATA LOCAL */

#define CLIENT_IGNORE_SPACE 256 /* Ignore spaces before '(' */

#define CLIENT_PROTOCOL_41 512 /* New 4.1 protocol */

#define CLIENT_INTERACTIVE 1024 /* This is an interactive client */

#define CLIENT_SSL 2048 /* Switch to SSL after handshake */

#define CLIENT_IGNORE_SIGPIPE 4096 /* IGNORE sigpipes */

#define CLIENT_TRANSACTIONS 8192 /* Client knows about transactions */

#define CLIENT_RESERVED 16384 /* Old flag for 4.1 protocol */

#define CLIENT_SECURE_CONNECTION 32768 /* New 4.1 authentication */

#define CLIENT_MULTI_STATEMENTS 65536 /* Enable/disable multi-stmt support */

#define CLIENT_MULTI_RESULTS 131072 /* Enable/disable multi-results */

#define CLIENT_REMEMBER_OPTIONS (((ulong) 1) << 31)

Contact at LinuxIntro dot com 27-Oct-2008 09: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);