2009/7/13 Patrick Moloney <webpat52@xxxxxxxxx>: > Bastien Koert wrote: >> >> On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney<webpat52@xxxxxxxxx> >> wrote: >>> >>> I've had no success trying to execute any stored procedure from php. >>> I'm just trying to follow the example for multi-query in the php manual, >>> and >>> have tried an example from Artfulsoftware.com. I have one input and one >>> output parameter. I've simplified the stored procedure to always output >>> one >>> value from one record, regardless of the value passed in. >>> The SP works in Mysql. Just cant run it from php. It returns False. >>> I look at the query log in mysql and it calls the stored procedure, and >>> shows the input value and output variable. No further information. I'm >>> not >>> familiar with that log so I don't know what it should look like. >>> The only thing I see looks like a brief reference to UTC8 - but I don't >>> think I am (intentionally) using that anywhere. I get no other error back >>> or >>> logged. I'm using root as the user, which is the only defined user. >>> Should >>> this work, or are stored procedures not working well? >>> >>> -- >>> PHP Database Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> >>> >> >> Can you show the php code? >> > > Below is the relevant code. The database connection is established, but the > query call returns False. The call is recorded in the mysql query log. No > error there or returned, but just False. Proc works in mysql and ignores > the value of the input parameter and returns 1 string. But I can't get it to > do that from php. > > > @$db = new mysqli('localhost', 'root', 'password', 'Sales'); > if (mysqli_connect_errno()) > { echo 'Error: could not connect to database. '; > exit; > } > > $brandrequest = 'x'; > $res = $db->multi_query( "CALL myproc($brandrequest, ModelID); " ); > if (!$res ) { > echo 'No Listings were found for this request.'; > echo mysql_error(); > exit; > } > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Isn't your SQL is broken? CALL myproc(x, ModelID) ? Surely ... CALL myproc('x', 'ModelID') -- ----- Richard Quadling Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 "Standing on the shoulders of some very clever giants!" ZOPA : http://uk.zopa.com/member/RQuadling -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
