Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <html>
  2. <body>
  3. <?php
  4. $host = "localhost";
  5. $user = "yulia";
  6. $pass = "123456";
  7. $database = "databaseyulia";
  8.  
  9. $connect = mysqli_connect($host, $user, $pass, $database)
  10. or die("Can’t connect."
  11. .mysqli_error($connect));
  12.  
  13. $lastName = $_POST['lastname'];
  14. $query ="SELECT userPhoneNumber FROM userData WHERE userLastName='$lastName'";
  15. $result = mysqli_query($connect, $query);
  16.  
  17. if($result)
  18. {
  19. if (mysqli_num_rows($result) <= 0)
  20. echo "There is no phone number for <strong> $lastName </strong>! <br><br> ";
  21. else{
  22. while ($row = mysqli_fetch_assoc($result)){
  23. echo "<strong> $lastName </strong> - $row[userPhoneNumber]<br><br>";
  24. }
  25. }
  26. mysqli_free_result($result);
  27. }
  28. mysqli_close($connect);
  29. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement