Re: How to get stored procedure return values via PDO?

["Bruce Cowin" <bdc@xxxxxxxxxxxxxxx>]

I had a similar problem using PDO on MS Sql Server where I was trying to
return the id of an inserted row.  I ended up giving up and doing a
second query to get @@IDENTITY.


Regards,

Bruce

>>> Richard Davey <rich@xxxxxxxxxxxxx> 27/07/2007 12:51 a.m. >>>
Hi,

I'm calling a MySQL Stored Procedure via PDO (PHP 5.2.3)

$stmt = $dbh->prepare('CALL forum_post(?, ?, ?, ?, ?, @status,
@thread_id, @message_id)');

At the moment in order to get the values of status, thread_id and
message_id I need to issue a second query:

$sql = "SELECT @status AS status, @thread_id AS thread_id, @message_id
AS message_id";

and then foreach my way through it:

foreach ($dbh->query($sql) as $row)
{
        $status = $row['status'];
        $thread_id = $row['thread_id'];
        $message_id = $row['message_id'];
}

Which seems a bit insane.. is there no way to do a bindValue at the
same time as I do my bindParams?

Now I write this I really can't remember why I am even putting that
second query into a foreach loop, even so it's still a step I'd like
to remove entirely if possible?

Cheers,

Rich
-- 
Zend Certified Engineer
http://www.corephp.co.uk 

"Never trust a computer you can't throw out of a window"

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php