Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <body>
- <?php
- $host = "localhost";
- $username = "X33170489";
- $password = "X33170489";
- $dbname = "X33170489";
- $dbc = mysqli_connect($host, $username, $password, $dbname);
- $qStudentID = $_GET['qStudentID'];
- $qFirstName = $_GET['qFirstName'];
- $qLastName = $_GET['qLastName'];
- if (mysqli_connect_errno()) {
- echo "Failed to connect to MySQL"
- . mysqli_connect_error();
- }
- $query = "SELECT * FROM Student WHERE StudentID = '$qStudentID' OR FirstName = '$qFirstName' OR LastName = '$qLastName'";
- $result = mysqli_query($dbc, $query);
- if (mysqli_num_rows($result) > 0)
- {
- while($row=mysqli_fetch_array($result, MYSQLI_ASSOC))
- {
- echo "Student ID: " . $row["StudentID"]. " | Name: " . $row["FirstName"]. " " . $row["LastName"] . " | Units: " . $row["Unit1"] . ", " . $row["Unit2"] . ", " . $row["Unit3"] . ", " . $row["Unit4"] . "<br>";
- }
- }
- else
- {
- echo "No results found for the entered query!";
- }
- mysqli_free_result($result);
- mysqli_close($dbc);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement