Guest User

Untitled

a guest
Nov 24th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.20 KB | None | 0 0
  1. <?php
  2. // NOTE : j'ai retiré les paramètres de base de données
  3.  
  4. // Setup development error reporting
  5. error_reporting(E_ALL & E_NOTICE);
  6.  
  7. try {
  8.     // Connect to MySQL Server
  9.     if (!mysql_connect($dbhost, $dbuser, $dbpass)) {
  10.         throw new RuntimeException(sprintf('Unable to connect to MySQL server : %s', mysql_error()));
  11.     }
  12.  
  13.     //Select Database
  14.     if (!mysql_select_db($dbname)) {
  15.         throw new RuntimeException('Unable to select database : %s', mysql_error());
  16.     }
  17.  
  18.     // Build query
  19.     $codepart = filter_input(INPUT_GET, 'codepart');
  20.     $query = sprintf("SELECT partMail FROM partenaires WHERE codePart = '%s'", mysql_real_escape_string($codepart));
  21.  
  22.     // Execute query
  23.     $result = mysql_query($query);
  24.  
  25.     // Fetch results
  26.     $result = mysql_query($query);
  27.     $mailpart = mysql_result($result, 0);
  28.  
  29.     // Release resources
  30.     mysql_free_result($result);
  31.     mysql_close($db);
  32.  
  33.     // Build response
  34.     if ($mailpart) {
  35.         echo $mailpart;
  36.     } else {
  37.         throw new InvalidArgumentException('Le code partenaire "%s" n\'existe pas', $codepart);
  38.     }
  39. } catch (InvalidArgumentException $e) {
  40.     header("HTTP/1.0 404 Not Found");
  41.     echo $e->getMessage();
  42. }
Add Comment
Please, Sign In to add comment