Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. <?php
  2.  
  3. /**
  4. * Fonction connectDB()
  5. *Fonction générique qui créée une connexion sur la base
  6. *@return un objet de la classe PDO
  7.  
  8. **/
  9.  
  10. require_once("./config.inc.php");
  11.  
  12. function connectDB1()
  13. {
  14. $dsn = "mysql:host=localhost;dbname=salon";
  15. $user = "root";
  16. $password = "";
  17.  
  18. try
  19. {
  20.  
  21. $extraParams = array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
  22.  
  23. $cnx = new PDO($dsn, $user, $password, $extraParams);
  24. }
  25. catch(PDOexeption $e)
  26. {
  27. echo $e->getMessage;
  28. $cnx = NULL;
  29. }
  30. return $cnx;
  31. }
  32.  
  33. function connectDB2($dsn, $user, $password) //verison paramétrée
  34. {
  35.  
  36. try
  37. {
  38.  
  39. $extraParams = array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
  40.  
  41. $cnx = new PDO($dsn, $user, $password, $extraParams);
  42. }
  43. catch(PDOexeption $e)
  44. {
  45. echo $e->getMessage;
  46. $cnx = NULL;
  47. }
  48. return $cnx;
  49. }
  50.  
  51.  
  52. function connectDB3() //verison paramétrée
  53. {
  54.  
  55. try
  56. {
  57.  
  58. $extraParams = array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
  59.  
  60. $cnx = new PDO(DSN, DB_USER, DB_PASSWORD, $extraParams);
  61. }
  62. catch(PDOexeption $e)
  63. {
  64. echo $e->getMessage;
  65. $cnx = NULL;
  66. }
  67. return $cnx;
  68. }
  69. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement