How to get stored procedure return values via PDO?

From: 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"

« previous php.general (#259561) next »