<?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; ?>
Wednesday, 18 November 2015
PHP CSV File Export
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment