connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Hello ISI 490 from Nor Malak Mezroud
";
echo "Products from Database
";
$sql = "SELECT * FROM products";
$result = $conn->query($sql);
if ($result && $result->num_rows > 0) {
echo "";
echo "
| ID |
Name |
Quantity |
Price |
";
while($row = $result->fetch_assoc()) {
echo "";
echo "| " . $row["id"] . " | ";
echo "" . $row["name"] . " | ";
echo "" . $row["quantity"] . " | ";
echo "" . $row["price"] . " | ";
echo "
";
}
echo "
";
} else {
echo "No records found";
}
$conn->close();
?>