note 116874 added to pdo.prepared-statements
| From: | mdhaval_patel at yahoo dot com | Date: | Fri, 13 Mar 2015 13:15:48 +0000 |
| Subject: | note 116874 added to pdo.prepared-statements | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-201936@lists.php.net to get a copy of this message | ||
$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
----
Server IP: 72.52.91.14
Probable Submitter: 103.240.160.242
----
Manual Page -- http://php.net/manual/en/pdo.prepared-statements.php
Edit -- https://master.php.net/note/edit/116874
Del: integrated -- https://master.php.net/note/delete/116874/integrated
Del: useless -- https://master.php.net/note/delete/116874/useless
Del: bad code -- https://master.php.net/note/delete/116874/bad+code
Del: spam -- https://master.php.net/note/delete/116874/spam
Del: non-english -- https://master.php.net/note/delete/116874/non-english
Del: in docs -- https://master.php.net/note/delete/116874/in+docs
Del: other reasons-- https://master.php.net/note/delete/116874
Reject -- https://master.php.net/note/reject/116874
Search -- https://master.php.net/manage/user-notes.php