Logo

Admin Panel

Lead Management System

← Back to Website

Database Connection Error

Unable to connect to the database. Please check your MySQL credentials in db_connect.php.

'; if (!empty($db_error)) { echo '

Error: ' . htmlspecialchars($db_error) . '

'; echo '

Go to cPanel → MySQL Databases → Check your database name, username & password.

'; } echo '← Back to Website'; exit; } // Handle delete if (isset($_GET['delete']) && is_numeric($_GET['delete'])) { $stmt = $pdo->prepare('DELETE FROM leads WHERE id = :id'); $stmt->execute([':id' => (int)$_GET['delete']]); header('Location: view-leads.php?msg=deleted'); exit; } // Handle CSV export if (isset($_GET['export']) && $_GET['export'] === 'csv') { header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="leads_' . date('Y-m-d_His') . '.csv"'); $output = fopen('php://output', 'w'); fputcsv($output, ['ID', 'Name', 'Email', 'Phone', 'Service', 'Country', 'Message', 'Source Page', 'Date']); $results = $pdo->query('SELECT * FROM leads ORDER BY created_at DESC'); while ($row = $results->fetch()) { fputcsv($output, $row); } fclose($output); exit; } // Pagination & Search $per_page = 20; $page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1; $search = isset($_GET['search']) ? trim($_GET['search']) : ''; $offset = ($page - 1) * $per_page; // Count total if ($search) { $s = "%$search%"; $count_stmt = $pdo->prepare('SELECT COUNT(*) as total FROM leads WHERE name LIKE :s1 OR email LIKE :s2 OR phone LIKE :s3 OR service LIKE :s4'); $count_stmt->execute([':s1' => $s, ':s2' => $s, ':s3' => $s, ':s4' => $s]); $total = $count_stmt->fetch()['total']; } else { $total = $pdo->query('SELECT COUNT(*) as total FROM leads')->fetch()['total']; } $total_pages = max(1, ceil($total / $per_page)); // Fetch leads if ($search) { $stmt = $pdo->prepare('SELECT * FROM leads WHERE name LIKE :s1 OR email LIKE :s2 OR phone LIKE :s3 OR service LIKE :s4 ORDER BY created_at DESC LIMIT :lim OFFSET :off'); $stmt->bindValue(':s1', $s, PDO::PARAM_STR); $stmt->bindValue(':s2', $s, PDO::PARAM_STR); $stmt->bindValue(':s3', $s, PDO::PARAM_STR); $stmt->bindValue(':s4', $s, PDO::PARAM_STR); $stmt->bindValue(':lim', $per_page, PDO::PARAM_INT); $stmt->bindValue(':off', $offset, PDO::PARAM_INT); $stmt->execute(); } else { $stmt = $pdo->prepare('SELECT * FROM leads ORDER BY created_at DESC LIMIT :lim OFFSET :off'); $stmt->bindValue(':lim', $per_page, PDO::PARAM_INT); $stmt->bindValue(':off', $offset, PDO::PARAM_INT); $stmt->execute(); } $leads = $stmt->fetchAll(); ?> Lead Management - Admin Panel | Visa Solution Plus
Logo

Lead Management

View Site Logout
query("SELECT COUNT(*) as c FROM leads WHERE DATE(created_at) = CURDATE()")->fetch()['c']; $week_count = $pdo->query("SELECT COUNT(*) as c FROM leads WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)")->fetch()['c']; $month_count = $pdo->query("SELECT COUNT(*) as c FROM leads WHERE created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)")->fetch()['c']; ?>
Total Leads
Today
This Week
This Month
Export CSV

No Leads Found

#NameEmailPhoneServiceMessageSourceDateActions
1): ?>

Showing - of leads