Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Database.php
- class Database{
- public $isConn;
- protected $datab;
- // connect to db
- public function __construct(){
- $this->isConn = TRUE;
- try {
- $db_user = 'root_portal';
- $db_pass = 'Ebm69b#5';
- $this->datab = new PDO('mysql:dbname=db12354864-sd;host=localhost', $db_user, $db_pass);
- #$this->datab->setAttribute(PDO::ATRR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- # $this->datab->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
- } catch (PDOException $e) {
- throw new Exception($e->getMessage());
- }
- }
- // get row
- public function getRow($query, $params){
- try {
- $stmt = $this->datab->prepare($query);
- $stmt->execute($params);
- return $stmt->fetch();
- } catch (PDOException $e) {
- throw new Exception($e->getMessage());
- }
- }
- // get rows
- public function getRows($query){
- try {
- $stmt = $this->datab->prepare($query);
- $stmt->execute();
- return $stmt->fetchAll();
- } catch (PDOException $e) {
- throw new Exception($e->getMessage());
- }
- }
- // insert row
- public function insertRow($query, $params = array()){
- try {
- $stmt = $this->datab->prepare($query);
- $stmt->execute($params);
- return TRUE;
- } catch (PDOException $e) {
- throw new Exception($e->getMessage());
- }
- }
- // update row
- public function updateRow($query, $params = array()){
- $this->insertRow($query, $params);
- }
- // delete row
- public function deleteRow($query, $params = array()){
- $this->insertRow($query, $params);
- }
- // disconnect from db
- public function Disconnect(){
- $this->datab = NULL;
- $this->isConn = FALSE;
- }
- }
- // Ausgabe
- require_once 'database.php';
- function die_r($value){
- echo '<pre>';
- print_r($value);
- echo '</pre>';
- }
- $db = new Database();
- $getRow = $db->getRow("SELECT * FROM user WHERE id = ? AND username =?", array(91, 'demo'));
- $getRows = $db->getRows("SELECT * FROM user");
- #$insertRow = $db->insertRow("INSERT INTO users(username, password, email) VALUE(?, ?, ?)", ["Arthur", "102030", "arthur@localhost"]);
- #$updateRow = $db->updateRow("UPDATE users SET username = ?, password = ? WHERE id = ?", ["ArthurMann", "a123456", "7"]);
- #$deleteRow = $db->deleteRow("DELETE FROM users WHERE id = ?", [8]);
- die_r($getRows);
- $db->Disconnect();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement