How to Export Data in .CSV File From Mysql Using PHP

Are you looking to export your mydal data in .csv file using simple PHP code, then please keep your close attention in this post How to Export Data in .CSV File From Mysql Using PHP. CSV (comma separated values) is most widely supported file format for using data between different applications.

PHP fputcsv() function which will accepts array parameter of database results to coverted into the CSV format and download in .csv file:

fputcsv($output, $row);

1	fputcsv($output, $row);

export-csv-file

Download Complete Script

Below code will ensure your browser offers to download the file instead of displaying in browser.

Example PHP Code To Export in .CSV File

<?php
/**
* Description: Export data from mysql table in .csv file
* @author: Prem Tiwari
*/

// database variables
$hostname = "localhost";
$user = "XXXXXXXXX";
$password = "XXXXXXXXX";
$database = "XXXXXXXXX";

// Database connection
mysql_connect($hostname, $user, $password)
or die('Could not connect: ' . mysql_error());
					
mysql_select_db($database)
or die ('Could not select database ' . mysql_error());


// define file format
header('Content-Type: text/csv; charset=utf-8');

// define your filename
header('Content-Disposition: attachment; filename=your-file-name.csv');

// create a output file stream
$output = fopen('php://output', 'w');

// output the column headings
fputcsv($output, array('Table Column 1', 'Table Column 2', 'Table Column 3', 'Table Column 4'));
$results = mysql_query('SELECT field1,field2,field3,field3 FROM table_name');

// loop over the rows, outputting them
while ($results = mysql_fetch_assoc($results)) :

fputcsv($output, $results);

endwhile;

?>

<?php

/**

* Description: Export data from mysql table in .csv file

* @author: Prem Tiwari

// database variables

$hostname = "localhost";

$user = "XXXXXXXXX";

$password = "XXXXXXXXX";

$database = "XXXXXXXXX";

// Database connection

mysql_connect($hostname, $user, $password)

or die('Could not connect: ' . mysql_error());

mysql_select_db($database)

or die ('Could not select database ' . mysql_error());

// define file format

header('Content-Type: text/csv; charset=utf-8');

// define your filename

header('Content-Disposition: attachment; filename=your-file-name.csv');

// create a output file stream

$output = fopen('php://output', 'w');

// output the column headings

fputcsv($output, array('Table Column 1', 'Table Column 2', 'Table Column 3', 'Table Column 4'));

$results = mysql_query('SELECT field1,field2,field3,field3 FROM table_name');

// loop over the rows, outputting them

while ($results = mysql_fetch_assoc($results)) :

fputcsv($output, $results);

endwhile;

Download Complete Script

Found this useful? Share it with your friends. Thank you for giving time on freewebmentor community. Please don’t forget to subscribe our newsletter or join us on Facebook to be the first to learn the next great thing from freewebmentor.

If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.

How to Export Data in .CSV File From Mysql Using PHP

Example PHP Code To Export in .CSV File

Recommended Posts:

webmentor