datastores.php 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465
  1. <?php
  2. ini_set('display_errors', 1);
  3. ini_set('display_startup_errors', 1);
  4. error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
  5. function connect(){
  6. $link = mysql_connect('127.0.0.1','eligibilite','B3Kg7z6d') or die(mysql_error());
  7. mysql_select_db('eligibilite', $link) or die(mysql_error());
  8. }
  9. function executeQuery($requete) {
  10. $resultat = mysql_query($requete) or die(mysql_error());
  11. if(substr($requete, 0, 6) === 'SELECT'){
  12. while($donnees=mysql_fetch_array($resultat)){
  13. $resultats[]=$donnees;
  14. }
  15. if (!isset($resultats)) {
  16. return null;
  17. }
  18. }
  19. else if(substr($requete, 0, 6) === 'INSERT'){
  20. $resultats = mysql_insert_id();
  21. }
  22. else {
  23. $resultats = 'ok';
  24. }
  25. return $resultats;
  26. }
  27. connect();
  28. if(isset($_POST['query'])) {
  29. $resultat = executeQuery($_POST['query']);
  30. }
  31. if(isset($_POST['mail'])) {
  32. $email = 'ftth@manchenumerique.fr';
  33. $bcc = 'francoisbeaufils@zeno-labs.com';
  34. $headers = 'MIME-Version: 1.0' . "\r\n";
  35. $headers .= 'Content-type: text/html; charset=UTF-8' . "\r\n";
  36. $headers .= 'Bcc: '.$bcc."\r\n";
  37. if(isset($_POST['siteEmail'])) {
  38. $email = $_POST['siteEmail'];
  39. }
  40. // En-têtes additionnels
  41. $headers .= mb_encode_mimeheader('From: Manche Numérique <'.$email.'>' . "\r\n", "UTF-8");
  42. $subject = utf8_decode($$_POST['mail']['sujet']);
  43. $subject = mb_encode_mimeheader($subject
  44. // Envoi
  45. $to = $_POST['mail']['to'];
  46. $resultat = mail($to, $subject, $_POST['mail']['message'], $headers);
  47. }
  48. if(isset($resultat)){
  49. echo json_encode($resultat);
  50. }
  51. ?>