connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Fetch data for Bar Chart (order table)
$sql1 = "SELECT Category_Type, COUNT(Category_Type) as Quantity FROM orders GROUP BY Category_Type";
$result1 = $conn->query($sql1);
$labels1 = [];
$data1 = [];
if ($result1->num_rows > 0) {
while($row = $result1->fetch_assoc()) {
$labels1[] = $row["Category_Type"];
$data1[] = $row["Quantity"];
}
}
// Fetch data for Pie Chart (report table)
$sql2 = "SELECT Department, COUNT(Department) as Quantity FROM report GROUP BY Department";
$result2 = $conn->query($sql2);
$labels2 = [];
$data2 = [];
if ($result2->num_rows > 0) {
while($row = $result2->fetch_assoc()) {
$labels2[] = $row["Department"];
$data2[] = $row["Quantity"];
}
}
// Close MySQL connection
$conn->close();
?>
Report | UITM BAZAAR