export data to csv in php
<?php
//store the data that you retrieve from DB in a varible, in my case its $keywords_analytics
if($keywords_analytics!=''){
$delimiter = ",";
$fileName = 'search_terms.csv';
// Create a file pointer
$f = fopen('php://memory', 'w');
// Set column headers
$fields = array('Date', 'Search Term', 'Total');
fputcsv($f, $fields, $delimiter);
foreach ($keywords_analytics as $ka){
$lineData = array($ka['dated'], $ka['keyword'], $ka['total']);
fputcsv($f, $lineData, $delimiter);
}
// Move back to beginning of file
fseek($f, 0);
// Set headers to download file rather than displayed
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="' . $fileName . '";');
//output all remaining data on a file pointer
fpassthru($f);
}
exit;
?>
0
8
<?php
/*
* iTech Empires: Export Data from MySQL to CSV Script
* Version: 1.0.0
* Page: Index
*/
// Database Connection
require("db_connection.php");
// List Users
$query = "SELECT * FROM users";
if (!$result = mysqli_query($con, $query)) {
exit(mysqli_error($con));
}
if (mysqli_num_rows($result) > 0) {
$number = 1;
$users = '<table class="table table-bordered">
<tr>
<th>No.</th>
<th>First Name</th>
<th>Last Name</th>
<th>Email</th>
</tr>
';
while ($row = mysqli_fetch_assoc($result)) {
$users .= '<tr>
<td>'.$number.'</td>
<td>'.$row['first_name'].'</td>
<td>'.$row['last_name'].'</td>
<td>'.$row['email'].'</td>
</tr>';
$number++;
}
$users .= '</table>';
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Export Data from MySQL to CSV Tutorial | iTech Empires</title>
<!-- Bootstrap CSS File -->
<link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css"/>
</head>
<body>
<div class="container">
<!-- Header -->
<div class="row">
<div class="col-md-12">
<h2>Export Data from MySQL to CSV</h2>
</div>
</div>
<!-- /Header -->
<!-- Content -->
<div class="form-group">
<?php echo $users ?>
</div>
<div class="form-group">
<button onclick="Export()" class="btn btn-primary">Export to CSV File</button>
</div>
<!-- /Content -->
<script>
function Export()
{
var conf = confirm("Export users to CSV?");
if(conf == true)
{
window.open("export.php", '_blank');
}
}
</script>
</div>
</body>
</html>
Thank you!
8
0
0
4.5
10
<?php
/*
* iTech Empires: Export Data from MySQL to CSV Script
* Version: 1.0.0
* Page: DB Connection
*/
// Connection variables
$host = "localhost"; // MySQL host name eg. localhost
$user = "root"; // MySQL user. eg. root ( if your on localserver)
$password = ""; // MySQL user password (if password is not set for your root user then keep it empty )
$database = "test"; // MySQL Database name
// Connect to MySQL Database
$con = new mysqli($host, $user, $password, $database);
// Check connection
if ($con->connect_error) {
die("Connection failed: " . $con->connect_error);
}
?>
Thank you!
10
4.5
(10 Votes)
0
Are there any code examples left?
New code examples in category PHP
Relative searches
export my sql data in csv php
php mysql to csv export
php convert csv to mysql
php data to csv
save all data in csv php
database insert csv file php
how to create csv file in php
export array data to csv in php
insert csv data to mysql php
php store data in csv file
save data in csv file php
insert csv file into mysql table php
how to insert data in csv file using php
export query to csv php
importing csv to mysql table using php
import csv file into mysql table php
export database data as csv or xml file using php
php export csv oop
upload csv to database php
write data to csv file in php
csv export sample php
create csv exporter php
export file csv php
create a cutom csv file for export php
php save html in database, csv export
php var to csv export
php record save csv file
how to convert data to csv php
save csv in php
php code to export sql to csv
php to csv
php data to csv library
import data from mysql table to csv file using php
php database csv export
import csv to mysql in php
how to export database to csv in php example
php export mysql table to csv
export php data to csv
import csv data to mysql in php
how to export table as csv php
how to export data to csv file using php and mysql
creating csv from mysql php
php mysql export to csv
php import csv file to mysql table
how to import csv to mysql php
how to import csv file save data in mysql database using php
format file csv export in php
import csv to mysql php
export csv from database table in php
php code to export data to csv file
php export data to csv file
php export csv #
php export to csv with header from mysql
php export to csv from mysql
php import csv to database
export table as csv php
mysql to csv database using php
export csv of table php
insert csv to mysql php script
saving csv data in database using php
how to export data to csv file in php without showing table
how to create csv file from data from database in php
export csv in php source
export csv file in php using column
export csv file in php using
Export CSV file in PHP MySQL ajax
Export CSV file in PHP MySQL
How to Export php to CSV
export in csv using php
php mysql import csv
upload csv to php mysql
export data to csv php mysql
php import csv to mysql
php insert csv into mysql
Import CSV file data into MySQL database using PHP
how to export as csv data in table php
how to export data to csv file in php
insert csv into mysql php
export to csv file in php
php mysql to csv
mysql to csv php
insert data from csv to mysql php
csv to mysql php
php csv to mysql
import csv data into mysql using php
export data to csv in php
import csv data to database php
php csv import to mysql
php save mysql query as csv
how to insert csv to database in php
php import to mysql from csv
export csv from html table php
php mysql export data as csv
php mysql export data to csv
import csv data to mysql php
php export table as csv
php export html table to csv
php export table to csv
export data to csv php
export data in csv file using php
export sql to csv php
export csv with the total in php
php export data to csv
export csv from table php
import csv in php mysql
mysql update php import csv
php export mysql to csv download
php export mysql to csv
save a csv in sql php
export as csv in php
PHP export database to CSV
php export mysql data to csv file function
php export mysql data to csv file
php upload csv file to mysql
how to import csv file in php mysql
php export csv example
php export csv
how to export to csv an html table in php
export csv in php
export mysql to csv using php and ajax
convert mysql to csv file php
how to export php mysql results to csv
export data in csv php
csv php export
csv export php
php script export mysql table to csv
php create csv file from mysql table
export to csv in php
import and export csv file in php
export as csv php
php export csv from mysql
export csv file in php
mysql to csv in php
export data from mysql table to csv file using php
export html table to csv using php
export data from database in csv file php
php export to csv
php export csv file
export mysql to csv in php
export mysql to csv using php
export data to csv file using php
how we export data to csv File using php
how we export file to csv in php
export csv table in php
csv file export in php
export csv php
export php table to csv
php csv export
how to import csv file to mysql using php
how to import csv into a table php
export to csv from php
php export to csv , instead of ;
php export to csv , insted of ;
how can be export csv in core php
php upload csv to mysql
export to csv php
csv file import to mysql database using php
how to import php mysql data to csv through php
how to import a csv file to my sql using php code
import csv file in mysql table using php
php export sql to csv
export data as csv in php
download csv file php mysql
export csv in php and mysql
export to csv php mysql
