New to our community ?

Discover a world of possibilities! Join us and explore a vibrant community where ideas flourish and connections thrive.

One of Our Valued Members

Thank you for being part of our community. Your presence enriches our shared experiences. Let's continue this journey together!

Home php codes How to Export Mysql table in CSV format.?

How to Export Mysql table in CSV format.?

0

In the  previous post you see  how to Import an Excel file in Mysql database . Now In this tutorial, we will see how to Export or Download Mysql table in Excel Sheet form.
The CSV  stands for comma separated values. You often use the CSV file format to exchange data between applications such as Microsoft Excel, Google Docs, etc.

In previous post we create a mysql table excel_sheet . in  the table excel_sheet we create two coloums (category and website).

The following query selects website and category from the  excel_sheet table and put all records into list.csv file.

Also Read :
PHP Login Script With Remember me.
Change password using javascript, php and mysqli.
Password and Confirm Password Validation Using JavaScript
Check Email is Already Registered in Database using Ajax and JavaScript.
How to hide extension of html and php file.?

download.php

in download.php page we make a database connection. and inserting the data of mysql table (excel_sheet) into a file.

<?php
$db = mysqli_connect("localhost", "root", "", "test_excel");

$result = mysqli_query($db, "SELECT * from excel_sheet";);

header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=\"list.csv\"");
header("Content-Transfer-Encoding: binary");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false);

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

    fputcsv($output, array('website','category'));

while ($row = mysqli_fetch_assoc($result))
    {
    fputcsv($output, $row);
    }

fclose($output);
mysqli_free_result($result);
mysqli_close($db);
?>

Keep Learning…