1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| class Db {
private $host = "sss";
private $name='nnn';
private $user="uuu";
private $pass=ppp;
function __construct($host=null,$name=null,$user=null,$pass=null){
if($host != null){
$this->host = $host;
$this->name = $name;
$this->user = $user;
$this->pass = $pass;
}
try{
$this->connexion = new PDO('mysql:host='.$this->host.';dbname='.$this->name,
$this->user,$this->pass,array(
PDO::MYSQL_ATTR_INIT_COMMAND =>'SET NAMES UTF8',
PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
}catch (PDOException $e){
echo 'Erreur : >>>>>Impossible de se connecter à la BD !';die();
}
}
//return last insert id
public function lastInsertId($name = NULL) {
if(!$this->connexion) {
return false;
}
return $this->connexion->lastInsertId($name);
}
public function beginTransaction()
{
return $this->connexion->beginTransaction();
}
public function commit()
{
return $this->connexion->commit();
}
public function query($sql , $data=array()){
$req = $this->connexion->prepare($sql);
$req->execute($data);
return $req->fetchAll(PDO::FETCH_OBJ);
}
public function insert($sql , $data=array()){
$req = $this->connexion->prepare($sql);
$req->execute($data);
}
} |
Partager