How to call MySQL stored procedure from php?

[nish123]

i have to call Mysql Procedure from Php... I dnt know how it is work..!!

Waiting for positive reply..!! :)

[pritaeas]

maybe this will help

http://www.macronimous.com/resources/using_stored_procedure_with_mySQL_and_PHP.asp

[nish123]

maybe this will help

http://www.macronimous.com/resources/using_stored_procedure_with_mySQL_and_PHP.asp

Well that is helpful...
i have read somewhere that for running store procedure.. we need mysqli functions..!!! how much that are useful..?

[pritaeas]

The example in the link also uses mysql functions, not mysqli.

[sysel]

Well, I am trying to response to all:

the communication between PHP and MySQL expects a single query and single (or none) response. While calling the stored procedure, the query and also the response is more complex, what you must announce at opening the connection: $link = mysql_connect("server", 'usr', 'pass', false, [B]196608[/B]) where the number 196608 = 131072 + 65536 what can be decoded according the following table:

/** All constants from MySQL 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     [B]65536[/B] /* Enable/disable multi-stmt support */
#define CLIENT_MULTI_RESULTS       [B]131072[/B] /* Enable/disable multi-results */

as it is described for example here

[pritaeas]

After some searching online, I think you may be right. Mysqli is recommended when using stored procs, so you may need to switch.

[nikesh.yadav]

its nice to read people start store procedure in mysql

[monny7]

Hi, I find tht solution in this link:
http://codeigniter.com/forums/viewthread/71141/

You should be use mysqli for to work with stored procedures

[Atli]

Hey.

The old MySQL extension was written for MySQL 3, and while it is compatible with MySQL 4 and above, it doesn't support most of the new functionality, like Stored Procedures.

If you are using MySQL 4 or higher, you should really be using the MySQLI extension, and, if only for the sake of security, be using Predefined Statements. (See the examples here)

But if you don't like that, using MySQLI can be almost identical to using MySQL. A minor difference in the connect functions aside, you can pretty much just replace the "mysql" in the function calls with "mysqli".