PHP Export Data In CSV File |PHP CSV Tutorial

PHP Export Data In CSV File |PHP CSV Tutorial

Export CSV file in PHP mysql. Here you will learn how to export data into MySQL database in CSV file using PHP code.

Sometimes we need to export data into MySQL database. The best solution to exporting data into a MySQL database using the PHP script in In CSV file format.

This tutorial helps you an easy way to exporting data into the MySQL database table in CSV file using a PHP script.

Export CSV file in PHP MySQL

Just follow the few below steps and easily create registration form in PHP and MySQL with validation.

  • First Create a Database Connection File
  • Export MySQL Data to CSV file PHP Code

1. First Create a Database Connection File

In this step, you will create a file name db.php and update the below code into your file.

The below code is used to create a MySQL database connection in PHP. When we insert form data into MySQL database, there we will include this file:

<?php
	$servername='localhost';
	$username='root';
	$password='';
	$dbname = "my_db";
	$conn=mysqli_connect($servername,$username,$password,"$dbname");
	  if(!$conn){
		  die('Could not Connect MySql Server:' .mysql_error());
		}
?>

2. Export MySQL Data to CSV file PHP Code

In this step, you need to create one file name export.php and update the below code into your file.

The code below is used to get data from the MySQL database and export it to a CSV file or download it. The sample file name is users-sample.csv.

<?php

	// Database Connection
	require("db.php");

	// get users list
	$query = "SELECT * FROM users";
	if (!$result = mysqli_query($con, $query)) {
	    exit(mysqli_error($con));
	}

	$users = array();
	if (mysqli_num_rows($result) > 0) {
	    while ($row = mysqli_fetch_assoc($result)) {
	        $users[] = $row;
	    }
	}

	header('Content-Type: text/csv; charset=utf-8');
	header('Content-Disposition: attachment; filename=users-sample.csv');
	$output = fopen('php://output', 'w');
	fputcsv($output, array('No', 'Name', 'Mobile', 'Email'));

	if (count($users) > 0) {
	    foreach ($users as $row) {
	        fputcsv($output, $row);
	    }
	}
?>

Conclusion

In this tutorial, you have learned how to export data into the MySQL database in CSV using PHP code.

This is a very basic and easy example of exporting data into the MySQL database in CSV file using PHP code.

If you have any questions or thoughts to share, use the comment form below to reach us.

Leave a Reply

Your email address will not be published. Required fields are marked *