1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
<?php header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=file.csv"); header("Pragma: no-cache"); header("Expires: 0"); mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("mydatabase") or die(mysql_error()); $query = "SELECT * FROM mypanels ORDER BY id"; $select_c = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($select_c, MYSQL_ASSOC)) { //echo "Name,age,gender,cost"; // echo "\n"; $result.="{$row['name']},"; $result.="{$row['age']},"; $result.="{$row['gender']},"; $result.="{$row['cost']},"; $result.="\n";//next line echo $result; } ?> |
