Download CSV file using “AJAX”

by

If you are forcing a download, you can redirect the current page to the download link. Since the link will generate a download dialog, the current page (and its state) will be kept in place.

Basic approach:

$('a#query_name').click(function(){
    $('#wait-animation').show();
    document.location.href="https://stackoverflow.com/php_scripts/utils/csv_export.php?query_name="+query_name;
    $('#wait-animation').hide();
});

More complicated:

$('a#query_name').click(function(){
    MyTimestamp = new Date().getTime(); // Meant to be global var
    $('#wait-animation').show();
    $.get('/php_scripts/utils/csv_export.php','timestamp='+MyTimestamp+'&query_name="query_name,function(){
        document.location.href = "https://stackoverflow.com/php_scripts/utils/csv_export.php?timestamp="+MyTimestamp+'&query_name="+query_name;
        $("#wait-animation').hide();
    });
});

At PHP script:

@header("Last-Modified: " . @gmdate("D, d M Y H:i:s",$_GET['timestamp']) . " GMT");
@header("Content-type: text/x-csv");
// If the file is NOT requested via AJAX, force-download
if(!isset($_SERVER['HTTP_X_REQUESTED_WITH']) || strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) != 'xmlhttprequest') {
    header("Content-Disposition: attachment; filename=search_results.csv");
}
//
//Generate csv
//
echo $csvOutput
exit();

The URL for both requests must be the same to trick the browser not to start a new download at document.location.href, but to save the copy at the cache. I’m not totally sure about it, but seems pretty promising.

More Related Contents:

  1. I want to use jquery nested sortable plugin with drag and drop in codeigniter using mysqli
  2. Calling a php script at the end of a js script
  3. How do I close a connection early?
  4. ajax and php to enter multiple forms input to database
  5. Basic PHP and AJAX
  6. Update data on a page without refreshing
  7. Passing JavaScript array to PHP through jQuery $.ajax
  8. How to show Ajax requests in URL?
  9. Login without HTTPS, how to secure?
  10. jQuery – Call ajax every 10 seconds
  11. Creating jQuery AJAX requests to a PHP function
  12. Send JSON data from Javascript to PHP?
  13. Send multiple checkbox data to PHP via jQuery ajax()
  14. php implode (101) with quotes
  15. PHP Array to CSV
  16. Scaling a chat app – short polling vs. long polling (AJAX, PHP)
  17. Redirect with PHP after ajax call
  18. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  19. Difference between php echo and return in terms of a jQuery ajax call [closed]
  20. jQuery $.ajax request of dataType json will not retrieve data from PHP script
  21. Using AJAX to pass variable to PHP and retrieve those using AJAX again
  22. How to pass an array using PHP & Ajax to Javascript?
  23. Remove trailing delimiting character from a delimited string
  24. How to use the CSV MIME-type?
  25. how do i parse a csv file to grab the column names first then the rows that relate to it?
  26. How can I pass variables from JavaScript to PHP?
  27. uploading a file via ajax with php
  28. Process very big csv file without timeout and memory error
  29. How to Load Ajax in WordPress
  30. How can you use php in a javascript function [duplicate]

Leave a Comment