Advertisement
Guest User

Untitled

a guest
Oct 11th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. <?php
  2.  
  3. function getData($dataSQL,$params){
  4.  
  5. $pdo_host = 'localhost';
  6. $pdo_user = 'root';
  7. $pdo_pass = '';
  8. $pdo_database = 'cs1a_pizza_db';
  9.  
  10. //--------------------------------------------------------
  11.  
  12. try {
  13. $pdo_dns = 'mysql:host='.$pdo_host.';dbname='.$pdo_database;
  14. $pdo_db = new PDO($pdo_dns, $pdo_user, $pdo_pass);
  15. $pdo_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  16.  
  17. //------------------------------------------------------------------------------
  18.  
  19. $pdo_sql = $pdo_db->prepare($dataSQL);
  20. $pdo_sql->execute($params);
  21. return $pdo_sql->fetchAll(PDO::FETCH_ASSOC);
  22. $pdo_db = null;
  23. echo "Connected successfully";
  24. }
  25. catch(PDOException $e)
  26. {
  27. echo "Connection failed: " . $e->getMessage();
  28. }
  29. }
  30.  
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement