|
Server IP : 103.191.208.227 / Your IP : 3.139.237.50 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 (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- Export link -->
<div class="col-md-12 head">
<div class="float-right">
<a href="exportData.php" class="btn btn-success"><i class="dwn"></i> Export</a>
</div>
</div>
<?php
// Load the database configuration file
include 'db.php';
$query = $conn->query("SELECT * FROM form_data WHERE img_id='$img_id' AND user_id='$log_id'");
$result = $conn->query($stmt);
$sr=1;
if($query->num_rows > 0){
$delimiter = ",";
$filename = "Forms-data_" . date('Y-m-d') . ".csv";
// Create a file pointer
$f = fopen('php://memory', 'w');
// Set column headers
$fields = array('id','sl_no', 'pa_fname', 'pa_lname','pa_address','pa_email');
fputcsv($f, $fields, $delimiter);
// Output each row of the data, format line as csv and write to file pointer
while($row = $query->fetch_assoc()){
//$status = ($row['status'] == 1)?'Active':'Inactive';
$lineData = array($row['id'], $row['sl_no'], $row['pa_fname'], $row['pa_lname'], $row['pa_email'], $row['pa_address']);
fputcsv($f, $lineData, $delimiter);
}
// Move back to beginning of file
fseek($f, 0);
// Set headers to download file rather than displayed
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="' . $filename . '";');
//output all remaining data on a file pointer
fpassthru($f);
}
exit;
?>