psubbiah93@gmail.com

Wednesday, 18 November 2015

PHP CSV File Export


<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("phppot_examples",$conn);

$query = "SELECT * FROM toy";
$result = mysql_query($query);

$num_column = mysql_num_fields($result);  

$csv_header = '';
for($i=0;$i<$num_column;$i++) {
 $csv_header .= '"' . mysql_field_name($result,$i) . '",';
} 
$csv_header .= "\n";

$csv_row ='';
while($row = mysql_fetch_row($result)) {
 for($i=0;$i<$num_column;$i++) {
  $csv_row .= '"' . $row[$i] . '",';
 }
 $csv_row .= "\n";
}
/* Download as CSV File */
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename=toy_csv.csv');
echo $csv_header . $csv_row;
exit;
?>

Download

Unknown Web Developer

Hello! I am Subbiah P and this is my web technologies blog. My specialities are PHP, Asp.net, jQuery, and CMS web application development. I do accept paid work. Write to me to start working on your dream project . I am Working as Web developer in Peace Soft Technologies

No comments:

Post a Comment