|
Server IP : 103.191.208.227 / Your IP : 18.217.14.237 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/mhmsfzcs/vflyorions.com/admin/assets/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// Include database connection and start session if necessary
include 'db.php';
session_start();
// Function to sanitize data
function sanitize($data) {
return htmlspecialchars($data, ENT_QUOTES);
}
// Fetch data from database with distinct contact numbers
$que = "SELECT DISTINCT contact, name, email, message, date, id FROM enquiries ORDER BY id DESC";
$r = $conn->query($que);
// Create CSV file content
$csv_content = "Name,Email,Contact,Message,Date\n"; // CSV header row
$unique_contacts = []; // To store unique contact numbers
while ($row = $r->fetch_assoc()) {
// Check if the contact number is already encountered
if (!in_array($row['contact'], $unique_contacts)) {
// Add data to CSV content
$csv_content .= sanitize($row['name']) . "," . sanitize($row['email']) . "," . sanitize($row['contact']) . "," . sanitize($row['message']) . "," . sanitize($row['date']) . "\n";
// Add the contact number to the list of unique contacts
$unique_contacts[] = $row['contact'];
}
}
// Set CSV headers and force download
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="enquiries.csv"');
echo $csv_content;
// Close database connection
$conn->close();
?>