Created
February 24, 2016 11:24
-
-
Save Foxy79/1852a75fc7315eda58ad to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
class db { | |
public $isConnected; | |
protected $datab; | |
public function __construct($username, $password, $host, $dbname, $options=array()){ | |
$this->isConnected = true; | |
try { | |
$this->datab = new PDO("mysql:host={$host};dbname={$dbname};charset=utf8", $username, $password, $options); | |
$this->datab->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | |
$this->datab->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); | |
} | |
catch(PDOException $e) { | |
$this->isConnected = false; | |
throw new Exception($e->getMessage()); | |
} | |
} | |
public function Disconnect(){ | |
$this->datab = null; | |
$this->isConnected = false; | |
} | |
public function getRow($query, $params=array()){ | |
try{ | |
$stmt = $this->datab->prepare($query); | |
$stmt->execute($params); | |
return $stmt->fetch(); | |
}catch(PDOException $e){ | |
throw new Exception($e->getMessage()); | |
} | |
} | |
public function getRows($query, $params=array()){ | |
try { | |
$stmt = $this->datab->prepare($query); | |
$stmt->execute($params); | |
return $stmt->fetchAll(); | |
} catch(PDOException $e){ | |
throw new Exception($e->getMessage()); | |
} | |
} | |
public function insertRow($query, $params){ | |
try{ | |
$stmt = $this->datab->prepare($query); | |
$stmt->execute($params); | |
return $this->datab->lastInsertId(); | |
} catch(PDOException $e){ | |
throw new Exception($e->getMessage()); | |
} | |
} | |
public function updateRow($query, $params){ | |
return $this->insertRow($query, $params); | |
} | |
public function deleteRow($query, $params){ | |
return $this->insertRow($query, $params); | |
} | |
} | |
//USAGE | |
/* | |
Connecting to DataBase | |
$db = new db("root", "", "localhost", "database", array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8')); | |
Getting row | |
$getrow = $db->getRow("SELECT email, username FROM users WHERE username =?", array("yusaf")); | |
Getting multiple rows | |
$getrows = $db->getRows("SELECT id, username FROM users"); | |
inserting a row | |
$insertrow = $db ->insertRow("INSERT INTO users (username, email) VALUES (?, ?)", array("yusaf", "yusaf@email.com")); | |
updating existing row | |
$updaterow = $db->updateRow("UPDATE users SET username = ?, email = ? WHERE id = ?", array("yusafk", "yusafk@email.com", "1")); | |
delete a row | |
$deleterow = $db->deleteRow("DELETE FROM users WHERE id = ?", array("1")); | |
disconnecting from database | |
$db->Disconnect(); | |
checking if database is connected | |
if($db->isConnected){ | |
echo "you are connected to the database"; | |
}else{ | |
echo "you are not connected to the database"; | |
} | |
*/ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment