connect_error) {
die("Connection failed: ".$conn->connect_error);
}
// Query the table
$sql = "SELECT * FROM Person";
$result = $conn->query($sql);
$Grade = 'U';
// Display the results
if ($result->num_rows > 0) {
echo "Person Table
| ID | Name | Grade |
|---|
";
while ($row = $result->fetch_assoc()) {
if ($row["Grade"]>=80)
{
$Grade = 'A';
}elseif ($row["Grade"]>=70) {
$Grade = 'B';
}elseif ($row["Grade"]>=60) {
$Grade = 'C';
}elseif ($row["Grade"]>=50) {
$Grade = 'D';
}elseif ($row["Grade"]>=40) {
$Grade = 'E';
}else {
$Grade = 'F';
}
echo "| ".$row["ID"]." | ".$row["Name"]." | ".$Grade." |
";
}
echo "
";
} else {
echo "No records found.";
}
$conn->close();
?>