Vous n'êtes pas identifié(e).
L'icône rouge permet de télécharger chaque page du wiki visitée au format PDF et la grise au format ODT →
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente Prochaine révision Les deux révisions suivantes | ||
utilisateurs:hypathie:tutos:php_connexion_mysql [08/07/2021 16:50] Hypathie [Objet PDO] |
utilisateurs:hypathie:tutos:php_connexion_mysql [08/07/2021 16:57] Hypathie [Objet PDO] |
||
---|---|---|---|
Ligne 157: | Ligne 157: | ||
<code php> | <code php> | ||
+ | <?php | ||
+ | |||
+ | require 'MysqlSingleton.php'; | ||
+ | |||
+ | class GestionPDO extends MysqlSingleton | ||
+ | { | ||
+ | private $PDO_connexion = null; | ||
+ | private $callingBy = null; | ||
+ | public function __construct($callingBy) | ||
+ | { | ||
+ | $this->PDO_connexion = parent::firstConnexion(); | ||
+ | $this->callingBy = $callingBy; | ||
+ | echo " <br/>Constructeur GestionPDO.php calling by " . $callingBy . ". "; | ||
+ | } | ||
+ | |||
+ | /*public function queryFetch($query) | ||
+ | { | ||
+ | return $this->securConnexion()->query($query)->fetch(); | ||
+ | }*/ | ||
+ | public function logSqlErreur() | ||
+ | { | ||
+ | } | ||
+ | |||
+ | public function securConnexion() | ||
+ | { | ||
+ | if(is_null($this->PDO_connexion)) | ||
+ | $this->getConnexion(); | ||
+ | return $this->PDO_connexion; | ||
+ | } | ||
+ | private function getConnexion() | ||
+ | { | ||
+ | if(!$this->getStatus()) | ||
+ | $this->PDO_connexion = parent::firstConnexion(); | ||
+ | return $this->PDO_connexion; | ||
+ | } | ||
+ | public function getErreurMessage() | ||
+ | { | ||
+ | return parent::getErreurMessage(); | ||
+ | } | ||
+ | public function getStatus() | ||
+ | { | ||
+ | return parent::getStatus(); | ||
+ | } | ||
+ | public function getCallingBy() | ||
+ | { | ||
+ | return $this->createBy ; | ||
+ | } | ||
+ | public function disconnectMysql() | ||
+ | { | ||
+ | parent::disconnectMysql(); | ||
+ | } | ||
+ | public function __destruct(){ | ||
+ | echo " <br/> Destructeur de gestionnairePDO "; | ||
+ | } | ||
+ | } | ||
</code> | </code> | ||
- | === data_users.php === | + | === data_tree.php === |
<code php> | <code php> | ||
+ | <?php | ||
+ | require_once 'gestionnairePDO.php'; | ||
+ | |||
+ | |||
+ | class DAO_dataTree | ||
+ | { | ||
+ | const F_NAME = __FILE__; | ||
+ | private $gestionPDO; | ||
+ | |||
+ | public function __construct() | ||
+ | { | ||
+ | $this->gestionPDO = new GestionPDO(self::F_NAME); | ||
+ | echo " <br/>Constructeur DAO_dataTree.php "; | ||
+ | } | ||
+ | |||
+ | public function getDataTreeCountryStateCity() | ||
+ | { | ||
+ | $q = "SELECT name FROM tree_country_state_city where id=1;"; | ||
+ | $result = $this->gestionPDO->securConnexion()->query($q)->fetch(); | ||
+ | |||
+ | //ou | ||
+ | //$result = $this->gestionPDO->queryFetch($q); | ||
+ | return $result; | ||
+ | |||
+ | } | ||
+ | |||
+ | } | ||
</code> | </code> | ||
- | === data_tree.php === | + | |
+ | === data_users.php === | ||
<code php> | <code php> | ||
+ | <?php | ||
+ | require_once 'gestionnairePDO.php'; | ||
+ | |||
+ | |||
+ | class DAO_dataUsers | ||
+ | { | ||
+ | |||
+ | const F_NAME = __FILE__; | ||
+ | private $gestionPDO; | ||
+ | |||
+ | public function __construct() | ||
+ | { | ||
+ | $this->gestionPDO = new GestionPDO(self::F_NAME); | ||
+ | echo " <br/>Constructeur DAO_dataUsers.php "; | ||
+ | } | ||
+ | |||
+ | public function getNomfromId($id) | ||
+ | { | ||
+ | $q = "SELECT name FROM users where id=" . $id . ";"; | ||
+ | $result = $this->gestionPDO->securConnexion()->query($q)->fetch(); | ||
+ | |||
+ | //ou | ||
+ | //$result = $this->gestionPDO->queryFetch($q); | ||
+ | return $result; | ||
+ | |||
+ | } | ||
+ | } | ||
</code> | </code> | ||
Ligne 175: | Ligne 285: | ||
<code php> | <code php> | ||
+ | <?php | ||
+ | |||
+ | require 'data_tree.php'; | ||
+ | require 'data_users.php'; | ||
+ | |||
+ | $dataTree = new DAO_dataTree('index.php'); | ||
+ | |||
+ | $state = $dataTree->getDataTreeCountryStateCity(); | ||
+ | var_dump($state); | ||
+ | $dataUser = new DAO_dataUsers('index.php'); | ||
+ | |||
+ | $name = $dataUser->getNomfromId(1); | ||
+ | var_dump($name); | ||
+ | |||
+ | ?> | ||
</code> | </code> |