note 117321 added to pdo.query
| From: | tgrl5000 | Date: | Thu, 21 May 2015 15:42:18 +0000 |
| Subject: | note 117321 added to pdo.query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202630@lists.php.net to get a copy of this message | ||
Connecting
==============================
<?php
try{
$db = new
PDO("dbtype:host=yourhost;dbname=yourdbname;charset=utf8","username","password");
/*Other Codes*/
}catch(PDOException $e ){
echo "Error: ".$e;
}
?>
Excute query with secure data
==============================
<?php
try{
$db = new
PDO("dbtype:host=yourhost;dbname=yourdbname;charset=utf8","username","password");
$mysecuredata=14;
$db->query("Select * from table where id=".$mysecuredata);
}catch(PDOException $e ){
echo "Error: ".$e;
}
?>
Excute query with insecure data
==============================
<?php
try{
$db = new
PDO("dbtype:host=yourhost;dbname=yourdbname;charset=utf8","username","password");
$myinsecuredata=$_GET["id"];
$query=$db->prepare("Select * from table where id=?");
$query->excute(array($myinsecuredata));
}catch(PDOException $e ){
echo "Error: ".$e;
}
?>
Getting Data in database
==============================
<?php
try{
$db = new
PDO("dbtype:host=yourhost;dbname=yourdbname;charset=utf8","username","password");
$myinsecuredata=$_GET["table"];
$query=$db->prepare("Select * from ?");
$query->excute(array($myinsecuredata));
while($row=$query->fetch(PDO::FETCH_OBJ)) {
/*its getting data in line.And its an object*/
echo $row->yourcolumnname;
}
}catch(PDOException $e ){
echo "Error: ".$e;
}
?>
Reference
==============================
http://gencbilgin.net/pdo-kullanimi-php-de-veritabani-islemleri.html
----
Server IP: 72.52.91.14
Probable Submitter: 95.10.110.178
----
Manual Page -- http://php.net/manual/en/pdo.query.php
Edit -- https://master.php.net/note/edit/117321
Del: integrated -- https://master.php.net/note/delete/117321/integrated
Del: useless -- https://master.php.net/note/delete/117321/useless
Del: bad code -- https://master.php.net/note/delete/117321/bad+code
Del: spam -- https://master.php.net/note/delete/117321/spam
Del: non-english -- https://master.php.net/note/delete/117321/non-english
Del: in docs -- https://master.php.net/note/delete/117321/in+docs
Del: other reasons-- https://master.php.net/note/delete/117321
Reject -- https://master.php.net/note/reject/117321
Search -- https://master.php.net/manage/user-notes.php