Guest User

Untitled

a guest
Dec 14th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.71 KB | None | 0 0
  1. <?php
  2. $dbhost = 'mityfencesystems.netfirmsmysql.com';
  3. $dbuser = 'webadmin';
  4. $dbpass = 'XQF[g11(';
  5. $db = 'customers';
  6.  
  7. $db = new mysqli($dbhost, $dbuser, $dbpass, $db);
  8.  
  9. if ($db->connect_errno) {
  10.     die('Connection Error on db: ' . $db->connect_errno);
  11. }
  12.  
  13. if (isset($_POST['name']) === true && empty($_POST['name']) === false) {
  14.     $name = $_POST['name'];
  15.     if ($prep = $db->prepare('SELECT DealerEmail FROM `dealers` WHERE `DealerName`=?')) {
  16.         $prep->bind_param('s', $name);
  17.         $prep->execute();
  18.         $prep->bind_result($DealerEmail);
  19.         $prep->fetch();
  20.         echo ($DealerEmail != null) ? $DealerEmail : 'No email';
  21.         $prep-close();
  22.     }
  23. } else {
  24.     echo 'There was a problem preparing the statement';
  25. }
  26. $sql->close();
  27. ?>
Add Comment
Please, Sign In to add comment