Copier le code ci-dessous puis le coller dans un fichier appelé « config.php ». le fichier config.php doit être inclus dans toutes vos pages qui manipuleront votre Base de Données.

[pastacode lang= »php » manual= »define(%22HOST%22%2C%20%22localhost%3A3306%22)%3B%20%2F%2F%20Adresse%20du%20Serveur%20MySQL%0Adefine(%22USER%22%2C%20%22root%22)%3B%20%20%20%20%2F%2F%20Nom%20d’utilisateur%20de%20notre%20DB.%20%0Adefine(%22PASSWORD%22%2C%20%22%22)%3B%20%20%20%20%2F%2F%20Mot%20de%20passe%20de%20notre%20DB.%20%0Adefine(%22DATABASE%22%2C%20%22clients%22)%3B%20%2F%2FNom%20de%20notre%20DB%0A%2F%2F%20CONNEXION%20AVEC%20MySQLi%0A%24mysqli%20%3D%20new%20mysqli(HOST%2C%20USER%2C%20PASSWORD%2C%20DATABASE)%3B%0Aif(%24mysqli-%3Econnect_errno%20%3E%200)%7B%0A%20%20%20%20die(‘IMPOSSIBLE%20DE%20SE%20CONNECTER%20AU%20SERVEUR’%20.%24mysqli-%3Econnect_error)%3B%0A%7D%0A%2F%2F%20CONNEXION%20AVEC%20PDO%0Afunction%20getDB()%7B%0A%24dbhost%3DHOST%3B%0A%24dbuser%3DUSER%3B%0A%24dbpass%3DPASSWORD%3B%0A%24dbname%3DDATABASE%3B%0A%09try%20%7B%0A%24dbConnection%20%3D%20new%20PDO(%22mysql%3Ahost%3D%24dbhost%3Bdbname%3D%24dbname%22%2C%20%24dbuser%2C%20%24dbpass)%3B%20%0A%24dbConnection-%3Eexec(%22set%20names%20utf8%22)%3B%0A%24dbConnection-%3EsetAttribute(PDO%3A%3AATTR_ERRMODE%2C%20PDO%3A%3AERRMODE_EXCEPTION)%3B%0Areturn%20%24dbConnection%3B%0A%09%09%7D%0Acatch%20(PDOException%20%24e)%20%7B%0Aecho%20’Connection%20failed%3A%20’%20.%20%24e-%3EgetMessage()%3B%0A%09%7D%0A%7D » message= »Fichier config.php » highlight= » » provider= »manual »/]

Avec ce Script, vous pouvez utliser en même temps PDO et MySQLi dans vos procédures d’INSERTION, RECUPERATION, MODIFICATION et SUPRESSION. Il arrive des moments avec PDO vous devez ecrire beaucoups de code pourtant avec MySQLi moins de code, ils ont tous le meme résultat.

Insertion avec MySQLi:

[pastacode lang= »php » manual= »%2F%2F%20Inclusion%20de%20notre%20script%20de%20connexion%20%C3%A0%20MySQL%0Ainclude(‘config.php’)%3B%0A%2F%2F%20Recuperation%20des%20donn%C3%A9es%20du%20formulaire%20POST%20ou%20GET%0Aextract(%24_POST)%3B%0A%2F%2F%20Insertion%20dans%20la%20DB%20avec%20MySQLi%0A%24sql%3D%24mysqli-%3Eprepare(%22INSERT%20INTO%20membre%20(nom%2Cprenoms%2Csexe%2Ccontact)%20VALUES%20(%3F%2C%3F%2C%3F%2C%3F)%22)%3B%0A%24sql-%3Ebind_param(‘sssi’%2C%24nom%2C%24prenoms%2C%24sexe%2C%24contact)%3B%0Aif(%24sql-%3Eexecute())%7B%20%0A%09echo%20’DONNEEE%20INSEREES’%3B%0A%09%7D%20else%7B%0A%09%09die(‘IMPOSSIBLE%20D%5C’INSERER%20LES%20DONNEES’.mysqli_error(%24mysqli)))%3B%0A%09%7D%0A » message= »insertion_mysqli.php » highlight= » » provider= »manual »/]

Insertion avec PDO

[pastacode lang= »php » manual= »%2F%2F%20Inclusion%20de%20notre%20script%20de%20connexion%20%C3%A0%20MySQL%0Ainclude(‘config.php’)%3B%0A%2F%2F%20Insertion%20avec%20PDO%0A%24stmt%20%3D%20%24db-%3Eprepare(%22INSERT%20INTO%20compte(username%2Cemail%2Cpassword%2Cnom%2Crole)%20VALUES%20(%3Ausername%2C%3Aemail%2C%3Ahash_password%2C%3Aname%2C%3Arole)%22)%3B%0A%24stmt-%3EbindParam(%22username%22%2C%20%24username%2CPDO%3A%3APARAM_STR)%20%3B%0A%24hash_password%3D%20hash(‘sha256’%2C%20%24password)%3B%20%2F%2FPassword%20encryption%0A%24stmt-%3EbindParam(%22email%22%2C%20%24email%2CPDO%3A%3APARAM_STR)%20%3B%0A%24stmt-%3EbindParam(%22hash_password%22%2C%20%24hash_password%2CPDO%3A%3APARAM_STR)%20%3B%0A%24stmt-%3EbindParam(%22name%22%2C%20%24name%2CPDO%3A%3APARAM_STR)%20%3B%0A%24stmt-%3EbindParam(%22role%22%2C%20%24role%2CPDO%3A%3APARAM_INT)%20%3B%0A%24stmt-%3Eexecute()%3B » message= »insertion_pdo.php » highlight= » » provider= »manual »/]

N’hésister à poster vos commentaires, si vous avez une incompréhension.