Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = 'mityfencesystems.netfirmsmysql.com';
- $dbuser = 'webadmin';
- $dbpass = 'XQF[g11(';
- $db = 'customers';
- $db = new mysqli($dbhost, $dbuser, $dbpass, $db);
- if ($db->connect_errno) {
- die('Connection Error on db: ' . $db->connect_errno);
- }
- if (isset($_POST['name']) === true && empty($_POST['name']) === false) {
- $name = $_POST['name'];
- if ($prep = $db->prepare('SELECT DealerEmail FROM `dealers` WHERE `DealerName`=?')) {
- $prep->bind_param('s', $name);
- $prep->execute();
- $prep->bind_result($DealerEmail);
- $prep->fetch();
- echo ($DealerEmail != null) ? $DealerEmail : 'No email';
- $prep-close();
- }
- } else {
- echo 'There was a problem preparing the statement';
- }
- $sql->close();
- ?>
Add Comment
Please, Sign In to add comment