Advertisement
Guest User

sisraArf

a guest
Apr 19th, 2018
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. <?php
  2. header("Access-Control-Allow-Origin: *");
  3. //****PREPARATION CONNEXION BDD******
  4. $serveur="localhost";
  5. $user="tsnbase";
  6. $pass="Remote18,";
  7. $base = "popup";
  8.  
  9. //*****CONNEXION BDD*********
  10. try
  11. {
  12. $dbh = new PDO('mysql:dbname='.$base.';host='.$serveur, $user,$pass);
  13. }
  14. catch (Exception $e)
  15. {
  16. die("Impossible de se connecter: " . $e->getMessage());
  17. }
  18.  
  19. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  20. $reqInsert = $dbh->prepare("INSERT INTO statistiquesMonsisra (satisfaction,avis-messagerie,avis-imprimante,avis-demandeavis,avis-enregistrement,avis-visio,avis-delegation,avis-portail,avis-dossier,avis-mobile,avis-messagerie_comm,avis-imprimante_comm,avis-demandeavis_comm,avis-enregistrement_comm,avis-visio_comm,avis-delegation_comm,avis-portail_comm,avis-dossier_comm,avis-mobile_comm,user_message) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  21. $reqInsert->bindParam(1, $1);
  22. $reqInsert->bindParam(2, $2);
  23. $reqInsert->bindParam(3, $3);
  24. $reqInsert->bindParam(4, $4);
  25. $reqInsert->bindParam(5, $5);
  26. $reqInsert->bindParam(6, $6);
  27. $reqInsert->bindParam(7, $7);
  28. $reqInsert->bindParam(8, $8);
  29. $reqInsert->bindParam(9, $9);
  30. $reqInsert->bindParam(10, $10);
  31. $reqInsert->bindParam(11, $11);
  32. $reqInsert->bindParam(12, $12);
  33. $reqInsert->bindParam(13, $13);
  34. $reqInsert->bindParam(14, $14);
  35. $reqInsert->bindParam(15, $15);
  36. $reqInsert->bindParam(16, $16);
  37. $reqInsert->bindParam(17, $17);
  38. $reqInsert->bindParam(18, $18);
  39. $reqInsert->bindParam(19, $19);
  40. $reqInsert->bindParam(20, $20);
  41. $1=$_POST['satisfaction'];
  42. $2=$_POST['avis-messagerie'];
  43. $3=$_POST['avis-imprimante'];
  44. $4=$_POST['avis-demandeavis'];
  45. $5=$_POST['avis-enregistrement'];
  46. $6=$_POST['avis-visio'];
  47. $7=$_POST['avis-delegation'];
  48. $8=$_POST['avis-portail'];
  49. $9=$_POST['avis-dossier'];
  50. $10=$_POST['avis-mobile'];
  51. $11=$_POST['avis-messagerie_comm'];
  52. $12=$_POST['avis-imprimante_comm'];
  53. $13=$_POST['avis-demandeavis_comm'];
  54. $14=$_POST['avis-enregistrement_comm'];
  55. $15=$_POST['avis-visio_comm'];
  56. $16=$_POST['avis-delegation_comm'];
  57. $17=$_POST['avis-portail_comm'];
  58. $18=$_POST['avis-dossier_comm'];
  59. $19=$_POST['avis-mobile_comm'];
  60. $20=$_POST['user_message'];
  61. $reqInsert->execute();
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement