Javascript and PHP export data to file

Question

I have a button. By clicking the button, I want to export some data shown on the webpage to a file for downloading.

I am doing this in this way: I have a export.php. I send the data as the parameter to PHP file (another parameter is filename), and PHP server create a file and write the data, and then send file. Code is like:

$filename = $_GET['filename'] . '.csv';
$export = $_GET['export'];
$writer = fopen($filename, 'w') or die('cannot create');
fwrite($writer, $export . "\n");
fclose($writer);

header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename='.basename($filename));
readfile($filename);
unlink($filename);

exit();

For cases that the data are short, it works fine. But if the data are long, since the data are passed as part of the URL, I will get "Request-URI Too Large" error.

Is there any alternative way to do that? Is it possible to directly write data using JavaScript?

@alfasin The problem is: there is no existing file. I need to create this file first on the server, and I need to pass the data to the server. — DrXCheng
– DrXCheng, Commented Jul 19, 2012 at 21:58
so replace the while-loop that contains: $buffer = fread($fd, 2048); with reading from the source you want. — Nir Alfasi
– Nir Alfasi, Commented Jul 19, 2012 at 22:42

Aaron Dougherty · Accepted Answer · 2012-07-19 21:59:10Z

4

It sounds like you are sending to export.php with a GET, when you should be using a POST. GET is limited to 2048 characters, while a POST is not limited.

answered Jul 19, 2012 at 21:59

Aaron Dougherty

7256 silver badges9 bronze badges

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

1 Comment

Nir Alfasi Over a year ago

POST sends unlimited information on the HTTP request BODY. He's trying to pass it as a parameter...

Community · Accepted Answer · 2017-05-23 10:34:51Z

2

You'll need to POST the data to the server. Change the METHOD in your FORM tag to POST (in your html not your php code).

Each browser limits the size of the query string / length of the URL and the limit is browser dependent. You can POST a very large amount of data to the server however. The only limit is how fast is the user's upstream bandwidth and their patience.

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Jul 19, 2012 at 22:02

Andy Jones

6,2804 gold badges33 silver badges47 bronze badges

Comments

aron.duby · Accepted Answer · 2012-07-19 22:03:56Z

1

Instead of passing the data as a query string, use javascript to create an iframe and build a form which then posts to the php file.

IF your using jquery there's a good tutorial http://tutorialzine.com/2011/05/generating-files-javascript-php/

answered Jul 19, 2012 at 22:03

aron.duby

2,3222 gold badges17 silver badges25 bronze badges

Collectives™ on Stack Overflow

Javascript and PHP export data to file

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related