query($deleteSql) === TRUE) {
echo "";
echo "";
exit();
} else {
echo "";
echo "";
exit();
}
}
?>
Feedback | UITM BAZAAR
| Report ID |
Renter ID |
Department |
Feedback |
Action |
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$search = isset($_GET['search']) ? $conn->real_escape_string($_GET['search']) : '';
$sql = "SELECT Report_ID, Renter_ID, Department, Feedback FROM report";
if ($search) {
$sql .= " WHERE Department LIKE '%$search%'";
}
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "";
echo "| " . $row["Report_ID"] . " | ";
echo "" . $row["Renter_ID"] . " | ";
echo "" . $row["Department"] . " | ";
echo "" . $row["Feedback"] . " | ";
echo "
| ";
echo "
";
}
} else {
echo "| No results found |
";
}
$conn->close();
?>