Typy zasobów
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);
Stałe predefiniowane
Poniższe stałe są zdefiniowane w tym rozszerzeniu i stają się dostępne, gdy rozszerzenie jest dokompilowane do PHP, lub załadowane dynamicznie przy starcie.
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:
| 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:
| 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 NotesStałe predefiniowane
Contact at LinuxIntro dot com
28-Oct-2008 05:33
28-Oct-2008 05:33