note 101993 deleted from pdo.prepared-statements by salathe
| From: | salathe@php.net | Date: | Tue, 02 Aug 2016 12:13:29 +0000 |
| Subject: | note 101993 deleted from pdo.prepared-statements by salathe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-206185@lists.php.net to get a copy of this message | ||
Note Submitter: oldmoscow dot mail dot ru
----
Note for MySQL: to use input/output parameters for stored procedures with PDO use PDO.Query()
statement.
For example:
<?php
$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:
<?php
$stmt = $dbh->prepare("CAST SomeStoredProcedure(?, ?)");
$stmt ->execute(array($someInParameter1, $someInParameter2));
?>