[PHP-DB] Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

Hi. I'm just trying to get PHP to talk to a stored procedure which has IN, INOUT and OUT parameters. The procedure is really dumb as I'm just trying to get things to work. The procedure is (taken from NaviCat's DDL view of the procedure) ... CREATE DEFINER=`root`@`localhost` PROCEDURE

Re: [PHP-DB] Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

Hi Richard, For your mysql, found this link, which I'm sure you've probably found, but hth. http://php.net/manual/en/pdo.prepared-statements.php Googled: stored procedure with INOUT and OUT parameters mysqli For your bind statement, found this link, hth.

[PHP-DB] Re: Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

On Mon, 12 Sep 2011 21:18:34 +0100, Richard Quadling wrote: I'm just trying to get PHP to talk to a stored procedure which has IN, INOUT and OUT parameters. [...] You'll probably need to trick it into returning a row with your output params, like using this multi-statement query: CALL

[PHP-DB] #@__ appeared in the sql statements

Studying a cms recently ,got a sql statement like this : Select * From `#@__homepageset` i knew the '#@__' means the table prefix but how it like this ? Did defined in the mysql or in the php code .i could't find its definition at present.Any phper's comments thanks in advance . All you best