Dashboard Login | TrueQuoteZone

internal category value $category_map = [ "Auto Insurance" => "auto", "Accidental" => "accident", "Home Warranty" => "homewarranty", "Solar" => "solar", "Bathroom" => "bathroom", "Gutters" => "gutters", "Windows" => "window", "Roofing" => "roofing", "Contact" => "Contact" ]; // Filter logic $selected_display = $_GET['category'] ?? 'All'; if ($selected_display !== 'All') { $internal_cat = $category_map[$selected_display] ?? $selected_display; $stmt = $db->prepare("SELECT * FROM leads WHERE category = :category ORDER BY created_at DESC"); $stmt->execute([':category' => $internal_cat]); $leads = $stmt->fetchAll(); } else { $stmt = $db->query("SELECT * FROM leads ORDER BY created_at DESC"); $leads = $stmt->fetchAll(); } function formatLeadData($jsonData) { $data = json_decode($jsonData, true); if (!$data) return "No data available"; $output = '

'; foreach ($data as $key => $value) { if (in_array($key, ['category', 'email', 'phone'])) continue; // Skip redundant fields if (empty($value)) continue; $cleanKey = ucwords(str_replace(['_', '-'], ' ', $key)); $output .= '

'; $output .= '' . htmlspecialchars($cleanKey) . ': '; $output .= '' . htmlspecialchars($value) . ''; $output .= '

'; } $output .= '

'; return $output; } ?> Lead Dashboard | TrueQuoteZone

Leads

Managing entries for TrueQuoteZone

Total: entries

0): ?>

ID	Date	Contact Info	Form Details
#
No leads found in this category.

Admin Access

Leads