Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class DataBaseQuery{
- function connect(){
- $db = "something_de";
- $db_host = "something.de.mysql";
- $db_user = "something_de";
- $db_pass = "secret";
- $charset = "utf8";
- try {
- $DB = new PDO("mysql:host=".$db_host.";dbname=".$db.";charset=".$charset.";", $db_user, $db_pass,array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
- } catch (PDOException $e) {
- die("MySQL Verbindungsfehler.".$e->getMessage());
- }
- return $DB;
- }
- function doQuery($sql){
- $db = $this->connect();
- $result = $db->query($sql);
- return $result;
- }
- function escape($string){
- $db = $this->connect();
- $string = $db->quote($string);
- return $string;
- }
- function fetch($result){
- $db = $this->connect();
- if ($result != false) {
- $row = $result->fetch(PDO::FETCH_ASSOC);
- } else {
- // die("Fehlschlag.");
- $row = null;
- }
- return $row;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement