Guest User

Untitled

a guest
May 27th, 2016
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. error_reporting(-1);
  3. ini_set('display_errors', 1);
  4.  
  5. $dbHost = 'localhost';
  6. $dbUser = 'root';
  7. $dbPassword = 'password';
  8. $dbName= 'testDB';
  9. $dbCharset='utf8';
  10.  
  11. $dsn = sprintf('mysql:host=%s;dbname=%s;charset=%s',$dbHost,$dbName,$dbCharset);
  12. try{
  13.     $db = new PDO($dsn,$dbUser,$dbPassword);
  14.     $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  15.     $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ );
  16. }catch (PDOException $e){
  17.     die("Failed to connect to Database");
  18. }
  19.  
  20.  
  21. $sql = "SELECT field1,field2 FROM table WHERE something=:something";
  22.  
  23. $statement = $db->prepare($sql);
  24.  
  25. $parameters = [':something'=>$_GET['something']];
  26. try{
  27.     $statement->execute($parameters);  
  28. }catch (PDOException $e){
  29.     die("Failed to execute SQL");
  30. }
  31.  
  32.  
  33. $rows = $statement->fetchAll();
  34.  
  35. foreach($rows as $row){
  36.     echo $row->field1. ' - '.$row->field2.'<br/>';
  37. }
Add Comment
Please, Sign In to add comment