Code: Select all
<!DOCTYPE HTML PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1-traditional.dtd">
<?php
$Stud_Name = $_POST['Stud_Name'];
$Stud_ID = $_POST['Stud_ID'];
$Gender = $_POST['Gender'];
$Course_Code = $_POST['Course_Code'];
$Occupation = $_POST['Occupation'];
$Year_of_Admission = $_POST['Year_of_Admission'];
$Year_of_Grad = $_POST['Year_of_Grad'];
$conn = mysqli_connect("localhost", "xxx", "xxxx", "xxxxx");
if (mysqli_connect_errno())
{
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if ($Stud_Name) {
$query1 = mysqli_query($conn, "Select * FROM Student WHERE Stud_Name LIKE '%$Stud_Name%'");
print "<table border=2>";
print "<TR><TH>Student ID</TH><TH>Student Name</TH><TH>Date Of Birth</TH><TH>Gender</TH><TH>Address</TH><TH>Office Contact</TH><TH>Mobile Contact</TH><TH>Home Contact</TH><TH>Email</TH><TH>Occupation</TH><TH>Course Of Study</TH><TH>Year of Admission</TH><TH>Year of Graduate</TH></TR>";
print "<TR>";
while ($result1 = mysqli_fetch_array($query1))
{
$Stud_ID=$result1["Stud_ID"];
$Stud_Name=$result1["Stud_Name"];
$DOB=$result1["DOB"];
$Gender=$result1["Gender"];
$Address=$result1["Address"];
$Stud_OContact=$result1["Stud_OContact"];
$Stud_HPContact=$result1["Stud_HPContact"];
$Stud_HContact=$result1["Stud_HContact"];
$Email=$result1["Email"];
$Occupation=$result1["Occupation"];
$Course_Code=$result1["Course_Code"];
$Year_of_Admission=$result1["Year_of_Admission"];
$Year_of_Grad=$result1["Year_of_Grad"];
print "<td>$Stud_ID</td>";
print "<td>$Stud_Name</td>";
print "<td>$DOB</td>";
print "<td>$Gender</td>";
print "<td>$Address</td>";
print "<td>$Stud_OContact</td>";
print "<td>$Stud_HPContact</td>";
print "<td>$Stud_HCOntact</td>";
print "<td>$Email</td>";
print "<td>$Occupation</td>";
print "<td>$Course_Code</td>";
print "<td>$Year_of_Admission</td>";
print "<td>$Year_of_Grad</td>";
print "</TR>";
};
print "</table>";
$num_results = @mysqli_num_rows($query1);
printf("%d student(s) found.\n", $num_results);
}
else if ($Gender) {
$query2 = mysqli_query($conn, "Select * FROM Student WHERE Gender = '$Gender'");
print "<table border=2>";
print "<TR><TH>Student ID</TH><TH>Student Name</TH><TH>Date Of Birth</TH><TH>Gender</TH><TH>Address</TH><TH>Office Contact</TH><TH>Mobile Contact</TH><TH>Home Contact</TH><TH>Email</TH><TH>Occupation</TH><TH>Course Of Study</TH><TH>Year of Admission</TH><TH>Year of Graduate</TH></TR>";
print "<TR>";
while ($result2 = mysqli_fetch_array($query2))
{
$Stud_ID=$result2["Stud_ID"];
$Stud_Name=$result2["Stud_Name"];
$DOB=$result2["DOB"];
$Gender=$result2["Gender"];
$Address=$result2["Address"];
$Stud_OContact=$result2["Stud_OContact"];
$Stud_HPContact=$result2["Stud_HPContact"];
$Stud_HContact=$result2["Stud_HContact"];
$Email=$result2["Email"];
$Occupation=$result2["Occupation"];
$Course_Code=$result2["Course_Code"];
$Year_of_Admission=$result2["Year_of_Admission"];
$Year_of_Grad=$result2["Year_of_Grad"];
print "<td>$Stud_ID</td>";
print "<td>$Stud_Name</td>";
print "<td>$DOB</td>";
print "<td>$Gender</td>";
print "<td>$Address</td>";
print "<td>$Stud_OContact</td>";
print "<td>$Stud_HPContact</td>";
print "<td>$Stud_HCOntact</td>";
print "<td>$Email</td>";
print "<td>$Occupation</td>";
print "<td>$Course_Code</td>";
print "<td>$Year_of_Admission</td>";
print "<td>$Year_of_Grad</td>";
print "</TR>";
};
print "</table>";
$num_results = @mysqli_num_rows($query2);
printf("%d student(s) found.\n", $num_results);
}
.
.
.
.
.
.
Anyone could help me with the coding???