Advertisement
joris

PDO

Aug 17th, 2012
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.52 KB | None | 0 0
  1. $sql = "select * from tbl_data e where e.id=:id";
  2.  
  3. try {
  4.     $dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); 
  5.     $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  6.     $stmt = $dbh->prepare($sql);  
  7.     $stmt->bindParam("id", $_GET[id]);
  8.     $stmt->execute();
  9.     $DataKeluar = $stmt->fetchObject();
  10.     $dbh = null;
  11.     $item->desk = html_entity_decode($item->desk, ENT_QUOTES);
  12.     echo '{"item":'. json_encode($DataKeluar) .'}';
  13. } catch(PDOException $e) {
  14.     echo '{"error":{"text":'. $e->getMessage() .'}}';
  15. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement