How to get stored procedure return values via PDO?
| From: | Richard Davey | Date: | Thu, 26 Jul 2007 12:51:32 +0000 |
| Subject: | How to get stored procedure return values via PDO? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-259561@lists.php.net to get a copy of this message | ||
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"