public static function getInstance() { NULL self::$instance or self::$instance new self(); return self::$instance; }
public static function getInstance() { if (NULL === self::$instance) { self::$instance = new self(); } return self::$instance; }
Connexion_serveur::getInstance() -> query('SELECT nom FROM table') -> fetchObj() -> nom;
$db = Connexion_serveur::getInstance(); $db -> prepare('SELECT login, password FROM users WHERE login=:login LIMIT 1'); $db -> bindValue(':login', $_POST['login'], PDO::PARAM_STR); $db -> execute();
class Connexion_serveur extends PDO { public function __construct() { parent::__construct($dsn, $username, $password); } }
class connexion_serveur extends pdo { public function __construct() { parent::__construct($dsn, $username, $password); try { $this->PDOInstance = new PDO(DB_DSN, DB_USER, DB_PASSWORD); $this->PDOInstance->query("SET NAMES utf8");//FOR USING UTF-8 $this->PDOInstance->query("SET CHARACTER SET 'utf8'");//FOR USING UTF-8 } catch (PDOException $e){ echo 'Erreur : '.$e->getMessage().' '; die(); } } }
class PDO { /** * Instance de la classe PDO */ private $PDOInstance = null; /** * Instance de la classe SPDO */ private static $instance = null; private function __construct() { } /** * Crée et retourne l'objet SPDO */ public static function getInstance() { if(null === self::$instance OR !ISSET(self::$instance)) { self::$instance = new self(); } return self::$instance; } /** * Empeche la copie externe de l'instance */ private function __clone() { throw new Exception('Le clonage de SPDO n\'est pas autorisé'); } }
$db = connexion_serveur::getinstance(); $db -> prepare('select login, password from users where login=:login limit 1'); $db -> bindvalue(':login', $_post['login'], pdo::param_str); $db -> execute();
class pdo { public function __construct() { try { $this->PDOInstance = new PDO(DB_SESSIONS_DSN, DB_SESSIONS_USER, DB_SESSIONS_PASSWORD); $this->PDOInstance->query("SET NAMES utf8");//FOR USING UTF-8 $this->PDOInstance->query("SET CHARACTER SET 'utf8'");//FOR USING UTF-8 } catch (PDOException $e){ echo 'Erreur : '.$e->getMessage().' '; die(); } } } class Connexion_serveur extends pdo{ /** Instance de la classe SPDO */ private static $instance = null; private function __construct() { parent::__construct(); } /** Crée et retourne l'objet SPDO */ public static function getInstance() { if(null === self::$instance OR !ISSET(self::$instance)) { self::$instance = new self(); } return self::$instance; } /**Empeche la copie externe de l'instance */ private function __clone() { throw new Exception('Le clonage de SPDO n\'est pas autorisé'); } }
$db=Connexion_serveur::getInstance(); $insert = "INSERT INTO logs_erreurs (date_erreur, texte_erreur) VALUES (?, ?)"; $statement = $db->prepare($insert); $statement->bindParam(1, "test", PDO::PARAM_STR); $statement->bindParam(2, "texte", PDO::PARAM_STR); $statement->execute();
try {$this->PDOInstance = new PDO(DB_SESSIONS_DSN, DB_SESSIONS_USER, DB_SESSIONS_PASSWORD); $this->PDOInstance->query("SET NAMES utf8");//FOR USING UTF-8 $this->PDOInstance->query("SET CHARACTER SET 'utf8'");//FOR USING UTF-8 } catch (PDOException $e){ echo 'Erreur : '.$e->getMessage().' '; die(); }
public function __construct($dsn, $username, $password) { parent::__construct($dsn, $username, $password); $this -> query("SET NAMES utf8"); $this -> query("SET CHARACTER SET 'utf8'"); }
class SPDO { private $PDOInstance = null; private static $instance = null; const DEFAULT_SQL_USER = 'xxx'; const DEFAULT_SQL_HOST = 'xxx'; const DEFAULT_SQL_PASS = 'xxxx'; const DEFAULT_SQL_DTB = 'xxxx'; private function __construct(){ $this->PDOInstance = new PDO('mysql:dbname='.self::DEFAULT_SQL_DTB.';host='.self::DEFAULT_SQL_HOST,self::DEFAULT_SQL_USER ,self::DEFAULT_SQL_PASS); } public static function getInstance() { if(null === self::$instance OR !ISSET(self::$instance)) { // self::$instance = new Connexion_serveur(); self::$instance = new self(); } return self::$instance; } } $db=SPDO::getInstance(); $insert = "INSERT INTO logs_erreurs (date_erreur, texte_erreur) VALUES (?, ?)"; $statement = $db->prepare($insert);
class SPDO extends PDO { CONST dsn = 'mysql:host=localhost;dbname=database;port=3306'; CONST username = 'username'; CONST password = 'password'; private static $instance; public static function getInstance() { null self::$instance or self::$instance new self(); return self::$instance; } # On est obligé de laisser le constructeur public parce qu'on étend PDO dont le constructeur est public public function __construct() { parent::__construct(self::dsn, self::username, self::password); } }
class SPDO extends PDO { CONST dsn = DB_SESSIONS_DSN; CONST username = DB_SESSIONS_USER; CONST password = DB_SESSIONS_PASSWORD; private static $instance; public static function getInstance() { null self::$instance or self::$instance new self(); return self::$instance; } # On est obligé de laisser le constructeur public parce qu'on étend PDO dont le constructeur est public public function __construct() { parent::__construct(self::dsn, self::username, self::password); } } $req = SPDO::getInstance()->prepare("INSERT INTO logs_erreurs (date_erreur, texte_erreur) VALUES (?, ?)"); $author="jhj"; $title="hgjjh"; $req->bindParam(1, $author); $req->bindParam(2, $title);
class SPDO extends PDO { private static $instance; public function __construct() { } public static function getInstance() { if(!isset(self::$instance)or null === self::$instance) { self::$instance = new PDO(DB_SESSIONS_DSN, DB_SESSIONS_USER, DB_SESSIONS_PASSWORD); self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); } return self::$instance; } } $req = SPDO::getInstance()->prepare("INSERT INTO logs_erreurs (date_erreur, texte_erreur) VALUES (?, ?)"); $date_erreur="jsddhj"; $texte_erreur="hgsdsdjjh"; $req->bindParam(1, $date_erreur, PDO::PARAM_STR); $req->bindParam(2, $texte_erreur, PDO::PARAM_STR); $req->execute();
$date_erreur="jsddhj"; $texte_erreur="hgsdsdjjh"; $req->bindParam(1, $date_erreur, PDO::PARAM_STR); $req->bindParam(2, $texte_erreur, PDO::PARAM_STR);
$req->bindParam(1, 'test', PDO::PARAM_STR); $req->bindParam(2, 'texte', PDO::PARAM_STR);
$liste = array('mot1', 'mot2', 'mot3'); $mot = ''; $stmt = $db -> prepare("SELECT id, auteur FROM articles WHERE content LIKE '%:mot%'"); $stmt -> bindParam(':mot', $mot); foreach ($liste as $mot) { $stmt -> execute(); }