note 116874 deleted from pdo.prepared-statements by cmb
| From: | cmb@php.net | Date: | Tue, 08 Sep 2015 22:20:32 +0000 |
| Subject: | note 116874 deleted from pdo.prepared-statements by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-203745@lists.php.net to get a copy of this message | ||
Note Submitter: mdhaval_patel at yahoo dot com
----
$query="{CALL test1(@ID=:ID,@name=:name,@statement=:statement)}";
$stmt = $dbh->prepare($query);
$id="4";
$name="pp";
$statement="Select";
$stmt->bindParam(':ID', $id);
$stmt->bindParam(':statement', $statement);
$stmt->bindParam(':name', $name);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
var_dump($row);
}
when i not pass name para not getting any output, becuse name is not needed here