export data into CSV format and store the csv file in the server

Question

how to save a csv file in server itself containing the data fetching form mysql dtatbase? i want to download a database in csv format.I am able to download the contants directly, but I need to save all the fetched data into server itself and provide the user a link to download the data into xls or csv format. I am new to this field and I really don't have any idea how to save the CSV file in server itself.

Can't you simply write your CSV content in a new file ? – Clément Malet Jun 27 '14 at 11:21 — Clément Malet, Jun 27 '14 at 11:21

score 1 · Answer 1 · edited May 23 '17 at 12:06

1

You can first query the database with required conditions and write the contents into a CSV file on your application server & later on provide a link to this file in your application. You may check the following link on how to obtain data, convert to CSV & write to file :

PHP code to convert a MySQL query to CSV

edited May 23 '17 at 12:06

Community

1
1

answered Jun 27 '14 at 11:40

Deepak Vn

112
1
11

score 0 · Answer 2 · answered Jun 27 '14 at 11:31

0

Create file using CSV separator i.e ;
Create downloading page, you have to set some headers
Download All.

answered Jun 27 '14 at 11:31

turson

421
2
9

score 0 · Answer 3 · answered Jun 27 '14 at 11:42

0

You can write fetched data in a file and then can save this file your server.

There are many php libraries for this job. I Personally use PHPExcel. You can download it from: https://phpexcel.codeplex.com/

answered Jun 27 '14 at 11:42

Umair Hamid

3,509
3
23
25

export data into CSV format and store the csv file in the server

3 Answers3