Advertisement
Guest User

Untitled

a guest
May 11th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. class DataBaseQuery{
  2.  
  3. function connect(){
  4. $db = "something_de";
  5. $db_host = "something.de.mysql";
  6. $db_user = "something_de";
  7. $db_pass = "secret";
  8. $charset = "utf8";
  9. try {
  10. $DB = new PDO("mysql:host=".$db_host.";dbname=".$db.";charset=".$charset.";", $db_user, $db_pass,array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
  11. } catch (PDOException $e) {
  12. die("MySQL Verbindungsfehler.".$e->getMessage());
  13. }
  14. return $DB;
  15. }
  16.  
  17. function doQuery($sql){
  18. $db = $this->connect();
  19. $result = $db->query($sql);
  20. return $result;
  21. }
  22.  
  23. function escape($string){
  24. $db = $this->connect();
  25. $string = $db->quote($string);
  26. return $string;
  27. }
  28.  
  29. function fetch($result){
  30. $db = $this->connect();
  31. if ($result != false) {
  32. $row = $result->fetch(PDO::FETCH_ASSOC);
  33. } else {
  34. // die("Fehlschlag.");
  35. $row = null;
  36. }
  37. return $row;
  38. }
  39.  
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement