Advertisement
Guest User

Untitled

a guest
Feb 18th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.59 KB | None | 0 0
  1. Database.php
  2. class Database{
  3.     public $isConn;
  4.     protected $datab;
  5.    
  6.     // connect to db
  7.     public function __construct(){
  8.         $this->isConn = TRUE;
  9.         try {
  10.                     $db_user = 'root_portal';
  11.                         $db_pass = 'Ebm69b#5';
  12.             $this->datab = new PDO('mysql:dbname=db12354864-sd;host=localhost', $db_user, $db_pass);
  13.            
  14.             #$this->datab->setAttribute(PDO::ATRR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15.           # $this->datab->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
  16.        } catch (PDOException $e) {
  17.             throw new Exception($e->getMessage());
  18.         }
  19.        
  20.     }
  21.      
  22.     // get row
  23.     public function getRow($query, $params){
  24.         try {
  25.             $stmt = $this->datab->prepare($query);
  26.             $stmt->execute($params);
  27.             return $stmt->fetch();
  28.         } catch (PDOException $e) {
  29.             throw new Exception($e->getMessage());
  30.         }
  31.     }
  32.     // get rows
  33.     public function getRows($query){
  34.         try {
  35.             $stmt = $this->datab->prepare($query);
  36.             $stmt->execute();
  37.             return $stmt->fetchAll();
  38.         } catch (PDOException $e) {
  39.             throw new Exception($e->getMessage());
  40.         }
  41.     }
  42.     // insert row
  43.     public function insertRow($query, $params = array()){
  44.         try {
  45.             $stmt = $this->datab->prepare($query);
  46.             $stmt->execute($params);
  47.             return TRUE;
  48.         } catch (PDOException $e) {
  49.             throw new Exception($e->getMessage());
  50.         }
  51.     }
  52.     // update row
  53.     public function updateRow($query, $params = array()){
  54.         $this->insertRow($query, $params);
  55.     }
  56.     // delete row
  57.     public function deleteRow($query, $params = array()){
  58.         $this->insertRow($query, $params);
  59.     }
  60.          // disconnect from db
  61.     public function Disconnect(){
  62.         $this->datab = NULL;
  63.         $this->isConn = FALSE;
  64.     }
  65.        
  66. }
  67.  
  68. // Ausgabe
  69. require_once 'database.php';
  70.  
  71. function die_r($value){
  72.     echo '<pre>';
  73.     print_r($value);
  74.     echo '</pre>';
  75. }
  76.  
  77. $db = new Database();
  78.  
  79. $getRow = $db->getRow("SELECT * FROM user WHERE id = ? AND username =?", array(91, 'demo'));
  80. $getRows = $db->getRows("SELECT * FROM user");
  81. #$insertRow = $db->insertRow("INSERT INTO users(username, password, email) VALUE(?, ?, ?)", ["Arthur", "102030", "arthur@localhost"]);
  82. #$updateRow = $db->updateRow("UPDATE users SET username = ?, password = ? WHERE id = ?", ["ArthurMann", "a123456", "7"]);
  83. #$deleteRow = $db->deleteRow("DELETE FROM users WHERE id = ?", [8]);
  84.  
  85. die_r($getRows);
  86. $db->Disconnect();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement