note 102018 modified in pdo.prepared-statements by danbrown
| From: | danbrown@php.net | Date: | Sun, 23 Jan 2011 17:43:37 +0000 |
| Subject: | note 102018 modified in pdo.prepared-statements by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-176226@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:
<?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));
?>
--was--
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));
http://php.net/manual/en/pdo.prepared-statements.php