Advertisement
Guest User

Untitled

a guest
Oct 12th, 2018
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <body>
  4.  
  5. <?php
  6. $host = "localhost";
  7. $username = "X33170489";
  8. $password = "X33170489";
  9. $dbname = "X33170489";
  10.  
  11. $dbc = mysqli_connect($host, $username, $password, $dbname);
  12. $qStudentID = $_GET['qStudentID'];
  13. $qFirstName = $_GET['qFirstName'];
  14. $qLastName = $_GET['qLastName'];
  15.  
  16. if (mysqli_connect_errno()) {
  17. echo "Failed to connect to MySQL"
  18. . mysqli_connect_error();
  19. }
  20.  
  21. $query = "SELECT * FROM Student WHERE StudentID = '$qStudentID' OR FirstName = '$qFirstName' OR LastName = '$qLastName'";
  22. $result = mysqli_query($dbc, $query);
  23.  
  24. if (mysqli_num_rows($result) > 0)
  25. {
  26. while($row=mysqli_fetch_array($result, MYSQLI_ASSOC))
  27. {
  28. echo "Student ID: " . $row["StudentID"]. " | Name: " . $row["FirstName"]. " " . $row["LastName"] . " | Units: " . $row["Unit1"] . ", " . $row["Unit2"] . ", " . $row["Unit3"] . ", " . $row["Unit4"] . "<br>";
  29. }
  30. }
  31. else
  32. {
  33. echo "No results found for the entered query!";
  34. }
  35.  
  36. mysqli_free_result($result);
  37. mysqli_close($dbc);
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement