PHP PDO – Class prête à l’emploi

13 juin 2016

class Connexion {
	private $login;
	private $pass;
	private $connec;

	public function __construct($db, $login ='root', $pass=''){
		$this->login = $login;
		$this->pass = $pass;
		$this->db = $db;
		$this->connexion();
	}

	private function connexion(){
		try
		{
	         $bdd = new PDO(
                            'mysql:host=localhost;dbname='.$this->db.';charset=utf8mb4', 
                             $this->login, 
                             $this->pass
                 );
			$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
			$bdd->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
			$this->connec = $bdd;
		}
		catch (PDOException $e)
		{
			$msg = 'ERREUR PDO dans ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage();
			die($msg);
		}
	}

	public function q($sql,Array $cond = null){
		$stmt = $this->connec->prepare($sql);

		if($cond){
			foreach ($cond as $v) {
				$stmt->bindParam($v[0],$v[1],$v[2]);
			}
		}

		$stmt->execute();

		return $stmt->fetchAll();
		$stmt->closeCursor();
		$stmt=NULL;
	}


}

Utiliser la class

$r = new Connexion('autoformation');
// requete select simple
$r->q("SELECT * FROM client");
//requête select avec un where
$DB->q(
		"SELECT * FROM telephone WHERE number LIKE :num", 
		array(
			array('num','060%',PDO::PARAM_STR),
			)
		)
	);

Articles incontournables sur le web pour approfondir le sujet :