Advertisement
Guest User

Untitled

a guest
May 24th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. <?php
  2.  
  3. $userInput = $_POST["searchInput"];
  4.  
  5. if (isset($_POST['submit'])) {
  6.  
  7. $dbhost = "localhost";
  8. $dbuser = "root";
  9. $dbpass = "";
  10. $dbname = "lobster";
  11.  
  12. $db = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
  13.  
  14. if(mysqli_connect_errno()) {
  15. die("Database connection failed: " .
  16. mysqli_connect_error() .
  17. " (" . mysqli_connect_errno() . ")"
  18. );
  19. }
  20.  
  21. $query = "SELECT * FROM me_business WHERE zip LIKE " . $userInput;
  22. $result = mysqli_query($db, $query);
  23. if (!$result) {
  24. die("No results found.");
  25. }
  26.  
  27. while($rows = mysqli_fetch_row($result)) {
  28. $row = $rows;
  29. }
  30. echo $row;
  31. die();
  32.  
  33. mysqli_free_result($result);
  34. mysqli_close($db);
  35. }
  36.  
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement