Skip to main content
Export Data from MySQL to CSV Using PHP

Export Data from MySQL to CSV Using PHP

Export MySQL data to CSV

A step-by-step guide to export data to CSV from MySQL using PHP

It is a basic task for any application that needs a reporting feature to CSV; here I am going to explain how to generate a CSV file from the MySQL records.

Let’s get started:

Step 1:

Create Database table with sample records, here I am going to use a users table, which is going to have users details, go ahead and use following SQL statements to create table and insert the records. (Note: you can skip this step if you have your existing database tables)

IMAGE : Users Table Structure
Users Table Structure

Existing records from mysql database
Existing Mysql Records to Export

Step 2:

Create Database configuration file, which is going help us to connect to MySQL from PHP file.

 

Step 3:

Create index.php file and list records.

index-file

Step 4: Export data with export.php

Create export.php file to export data from Mysql to CSV.

button-click

Click OK to export the data to CSV and your file get’s downloaded

file-get-donwloaded

 

If you check download file, you get records listed, as showing below:

Records from CSV files
Records from CSV files

We are done, you can download the complete source for reference use following links to download or checkout live demo.

Learn how to import data from CSV to MySQL  – Import Data from CSV File to MySQL Using PHP