Bastien Koert wrote:
On Mon, Jul 13, 2009 at 1:33 PM, Patrick Moloney<webpat52@xxxxxxxxx> wrote:
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
Is the multi_query call the correct one?
I did work with mysqli_multi_query also. The documentation seemed to
confuse the two. The only examples were like I have above.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
