Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
query("SELECT * FROM queries ORDER BY submitted_at DESC");
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=all_queries_' . date('Y-m-d') . '.csv');
$output = fopen('php://output', 'w');
// Excel headers
fputcsv($output, [
'ID',
'Full Name',
'Email',
'Phone',
'Date of Birth',
'Enquiry',
'Status',
'Submitted At'
]);
// Data rows
while ($row = $result->fetch_assoc()) {
fputcsv($output, [
$row['id'],
$row['full_name'],
$row['email'],
$row['telephone'],
$row['date_of_birth'],
$row['enquiry'],
$row['status'],
$row['submitted_at']
]);
}
fclose($output);
$conn->close();
exit;
}
// Handle delete request
if (isset($_POST['delete_id'])) {
$conn = getDBConnection();
$deleteId = intval($_POST['delete_id']);
$stmt = $conn->prepare("DELETE FROM queries WHERE id = ?");
$stmt->bind_param("i", $deleteId);
$stmt->execute();
$stmt->close();
$conn->close();
header('Location: query.php');
exit;
}
// Handle mark as read
if (isset($_POST['mark_read_id'])) {
$conn = getDBConnection();
$readId = intval($_POST['mark_read_id']);
$stmt = $conn->prepare("UPDATE queries SET status = 'read' WHERE id = ?");
$stmt->bind_param("i", $readId);
$stmt->execute();
$stmt->close();
$conn->close();
header('Location: query.php?filter=read');
exit;
}
// Fetch all queries
$conn = getDBConnection();
$result = $conn->query("SELECT * FROM queries ORDER BY submitted_at DESC");
?>
Query Management
Query Management
Manage customer queries and inquiries
num_rows;
$newQueries = $conn->query("SELECT COUNT(*) as count FROM queries WHERE status = 'new'")->fetch_assoc()['count'];
$readQueries = $conn->query("SELECT COUNT(*) as count FROM queries WHERE status = 'read'")->fetch_assoc()['count'];
?>