note 102018 added to pdo.prepared-statements
| From: | Anonymous at osu1 dot php dot net | Date: | Sun, 23 Jan 2011 12:26:00 +0000 |
| Subject: | note 102018 added to pdo.prepared-statements | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-176022@lists.php.net to get a copy of this message | ||
Note for MySQL: to use input/output parameters for stored procedures with PDO use PDO.Query()
statement.
For example:
$dbh->query("CAST SomeStoredProcedure($someInParameter1, $someInParameter2,
@someOutParameter)");
$dbh->query("SELECT @someOutParameter");
Or, if you want very much to use PDO.Prepare(), insert "SELECT @someOutParameter" in your
stored procedure and then use:
$stmt = $dbh->prepare("CAST SomeStoredProcedure(?, ?)");
$stmt ->execute(array($someInParameter1, $someInParameter2));
----
Server IP: 69.147.83.197
Probable Submitter: 94.29.108.230
----
Manual Page -- http://www.php.net/manual/en/pdo.prepared-statements.php
Edit -- https://master.php.net/note/edit/102018
Del: integrated -- https://master.php.net/note/delete/102018/integrated
Del: useless -- https://master.php.net/note/delete/102018/useless
Del: bad code -- https://master.php.net/note/delete/102018/bad+code
Del: spam -- https://master.php.net/note/delete/102018/spam
Del: non-english -- https://master.php.net/note/delete/102018/non-english
Del: in docs -- https://master.php.net/note/delete/102018/in+docs
Del: other reasons-- https://master.php.net/note/delete/102018
Reject -- https://master.php.net/note/reject/102018
Search -- https://master.php.net/manage/user-notes.php