Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <?php
- $host = "localhost";
- $user = "yulia";
- $pass = "123456";
- $database = "databaseyulia";
- $connect = mysqli_connect($host, $user, $pass, $database)
- or die("Canβt connect."
- .mysqli_error($connect));
- $lastName = $_POST['lastname'];
- $query ="SELECT userPhoneNumber FROM userData WHERE userLastName='$lastName'";
- $result = mysqli_query($connect, $query);
- if($result)
- {
- if (mysqli_num_rows($result) <= 0)
- echo "There is no phone number for <strong> $lastName </strong>! <br><br> ";
- else{
- while ($row = mysqli_fetch_assoc($result)){
- echo "<strong> $lastName </strong> - $row[userPhoneNumber]<br><br>";
- }
- }
- mysqli_free_result($result);
- }
- mysqli_close($connect);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement