note 102018 deleted from pdo.prepared-statements by cmb
| From: | cmb@php.net | Date: | Tue, 08 Sep 2015 22:21:52 +0000 |
| Subject: | note 102018 deleted from pdo.prepared-statements by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-203748@lists.php.net to get a copy of this message | ||
Note Submitter: Anonymous
----
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));
?>