connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Filters
$where = "WHERE 1=1";
if (!empty($_GET['vehicle'])) {
$vehicle = $conn->real_escape_string($_GET['vehicle']);
$where .= " AND vehicle = '$vehicle'";
}
if (!empty($_GET['gender'])) {
$gender = $conn->real_escape_string($_GET['gender']);
$where .= " AND gender = '$gender'";
}
if (!empty($_GET['agegroup'])) {
$agegroup = $conn->real_escape_string($_GET['agegroup']);
$where .= " AND agegroup = '$agegroup'";
}
if (!empty($_GET['from']) && !empty($_GET['to'])) {
$from = $conn->real_escape_string($_GET['from']);
$to = $conn->real_escape_string($_GET['to']);
$where .= " AND submitted_at BETWEEN '$from' AND '$to'";
}
// Queries
$total_registered = $conn->query("SELECT COUNT(*) as total FROM xx_nissan_test_drive_vu WHERE status='Registered'")->fetch_assoc()['total'];
$total_started = $conn->query("SELECT COUNT(*) as total FROM xx_nissan_test_drive_vu WHERE start_date IS NOT NULL")->fetch_assoc()['total'];
$total_completed = $conn->query("SELECT COUNT(*) as total FROM xx_nissan_test_drive_vu WHERE status='Completed'")->fetch_assoc()['total'];
$avg_journey = $conn->query("SELECT AVG(journey_duration) as avg_j FROM xx_nissan_test_drive_vu WHERE journey_duration IS NOT NULL")->fetch_assoc()['avg_j'];
$avg_drive = $conn->query("SELECT AVG(test_drive_duration) as avg_d FROM xx_nissan_test_drive_vu WHERE test_drive_duration IS NOT NULL")->fetch_assoc()['avg_d'];
$data_result = $conn->query("SELECT * FROM xx_nissan_test_drive_vu $where ORDER BY submitted_at DESC");
$age_data = $conn->query("SELECT agegroup, COUNT(*) as count FROM xx_nissan_test_drive_vu $where GROUP BY agegroup");
$vehicle_data = $conn->query("SELECT vehicle, COUNT(*) as count FROM xx_nissan_test_drive_vu $where GROUP BY vehicle");
$gender_data = $conn->query("SELECT gender, COUNT(*) as count FROM xx_nissan_test_drive_vu $where GROUP BY gender");
$rating_data = $conn->query("SELECT experience_rating, COUNT(*) as count FROM xx_nissan_test_drive_vu WHERE experience_rating IS NOT NULL GROUP BY experience_rating");
?>
Nissan Petromin Test Drive Dashboard