note 116874 added to pdo.prepared-statements

From: 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

« previous php.notes (#201936) next »