I have a php/mysql site in which I am trying to download a comma delimited file (CSV). The csv file I create contains comma delimited data (name, address, city, state). I create the csv file ok and place it in the site's /downloads directory. So far so good. I have been looking on line and the code to trigger the browser's download prompt that I see the most often is:
$path = $_SERVER['DOCUMENT_ROOT'];
$exportfile = "emailclientaddresses.csv";
$fullpath = "downloads/" . $exportfile;
header("Content-type: text/plain");
header("Content-Length: ".filesize($exportfile));
header("Content-Disposition: attachment; filename=" . $fullpath);
The $exportfile is the csv file that my code created. It's ok. What this does is:
OK, I have tried a lot of things and nothing has worked. So, if anyone can help me I would appreciate it. Thank you.
ed Cohen
Answer. The download prompt indicates that the website content is trying to run a PHP version not installed on the server. You can determine what versions of PHP are available for the server by running the following command: /usr/local/cpanel/bin/rebuild_phpconf --current.
HTML: Use the anchor element download attribute to prompt the user to download a resource. The download attribute on an anchor tag pops up a Save dialog to download the resource, instead of navigating to it. e.g. Using an attribute value, such as download="cat-1.
Step 2: Choose the Customize and control Google Chrome button at the top-right of the window. Step 3: Select the Settings option. Step 4: Scroll down and choose the Advanced option. Step 5: Scroll to the Downloads section and click the button to the right of Ask where to save each file before downloading.
The PHP documentation provides a nice example:
<?php
$file = 'monkey.gif';
if (file_exists($file)) {
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename='.basename($file));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($file));
ob_clean();
flush();
readfile($file);
exit;
}
?>
EDIT (Response to comment, explanation)
header('Content-Description: File Transfer');
Do not display in the browser, but transfer the file.
header('Content-Type: application/octet-stream');
header('Content-Transfer-Encoding: binary');
File is a binary file.
Browsers generally download binary files, unless they can display them.
header('Content-Disposition: attachment; filename='.basename($file));
Make the download dialog show the proper file name.
Note: You can use any file name.
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
File should not be cached by the browser.
Cache could cause trouble in case of dynamic content.
header('Content-Length: ' . filesize($file));
Send the correct file size to the browser,
otherwise the browser is unable to estimate the transfer-time.
ob_clean();
flush();
Make sure the headers are send to the browser before the download starts.
readfile($file);
Send the file to the browser.
exit;
Done :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With