Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $conn = mysql_connect("localhost","root","");
- mysql_select_db("phppot_examples",$conn);
- $filename = "toy_csv.csv";
- $fp = fopen('php://output', 'w');
- $query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='phppot_examples' AND TABLE_NAME='toy'";
- $result = mysql_query($query);
- while ($row = mysql_fetch_row($result)) {
- $header[] = $row[0];
- }
- header('Content-type: application/csv');
- header('Content-Disposition: attachment; filename='.$filename);
- fputcsv($fp, $header);
- $query = "SELECT * FROM toy";
- $result = mysql_query($query);
- while($row = mysql_fetch_row($result)) {
- fputcsv($fp, $row);
- }
- exit;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement