WordPress - Export table as csv using jQuery/Ajax

Question

Question:: I am developing a plugin. This plugins creates a custom table in WP database. How can I export the data from this table using Ajax?

Where I am?: I have created the hook and the handler. I can actually grab the data. Please see my code below.

add_action ( 'wp_ajax_nopriv_exportcsv', 'exprot_to_csv' );
add_action ( 'wp_ajax_exportcsv', 'exprot_to_csv' );    

<script type="text/javascript">
 jQuery("#export-csv").on("click",function(e){
        jQuery.ajax({
            type: "POST",
            url: ajaxurl,
            data: {"action":"exportcsv"},
            success: function(response){alert(response);}
            })
        });</script>        


function exprot_to_csv(){

global $wpdb;
$table_prefix = $wpdb->prefix;
$table = $table_prefix.'my_custom_table';

$result = $wpdb->get_results("SELECT * FROM ".$table."");
    foreach ($result as $row) {

        $output .="\n";
        $output .='"'.$row->post_id.'",';
        }
        $output .="\n";
        $file = "custom_table";
        $filename = $file."_".date("Y-m-d_H-i",time());
        header("Content-type: application/vnd.ms-excel");
        header("Content-disposition: csv" . date("Y-m-d") . ".csv");
        header( "Content-disposition: filename=".$filename.".csv");

        echo $output;
        exit;

}

In the alert box, I am getting comma separated post IDs as expected. But I am not sure how to move on from here. I mean how to handle this response and prompt the user to save/download the file.

Any help?

Can you check with your FTP to see if in the root of the wp folder you have a .csv file? — dingo_d
– dingo_d, Commented Mar 22, 2016 at 11:17
@dingo_d, I did have checked that. But he is getting a file created in the server but can't show the download dialogue box. While my file isn't actually being created. — Awais Umar
– Awais Umar, Commented Mar 22, 2016 at 11:29
How not? Just put the contents of your function exprot_to_csv() to exprot_to_csv.php, and call that file on click ;) Should be working :) — dingo_d
– dingo_d, Commented Mar 22, 2016 at 11:30

Christian Žagarskas · Accepted Answer · 2019-05-22 19:30:49Z

2

You are close...! I ran into same problem, tried a similar solution.

Check this question out: Download file through an ajax call php

And THIS specific answer: https://stackoverflow.com/a/11452917 Make sure to look at Dario's answer

Summary -

AJAX is not for streaming downloads.
The solution here is to make an iFrame
Load a PHP file into that iFrame using jQuery

Serve up your file with a File Transfer

'header('Content-Description: File Transfer');'

This works in WordPress. Use Admin-Ajax. Cheers

answered May 22, 2019 at 19:30

Christian Žagarskas

1,25714 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BSMP · Accepted Answer · 2021-09-20 05:19:25Z

0

Hopefully this will solve your problem.

In jQuery:

 window.location = response->in success

Action ajax:

Please remove all headers

echo admin_url($filename);
die;

edited Sep 20, 2021 at 5:19

BSMP

4,8808 gold badges36 silver badges46 bronze badges

answered Sep 19, 2021 at 7:28

user9611567

113 bronze badges

Collectives™ on Stack Overflow

WordPress - Export table as csv using jQuery/Ajax

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related