Export mysql results to CSV from PHP website

labhijitp · #1 (**permalink**) 04-26-11, 00:33

I have written a small (2line) query. I want to create link on my php site which on click will run this script automatically and export results to an excel or csv file. I dont want to create a page to view the results.

Any help to this new bie will be very useful. I am not well conversed with PHP

just know a little bit of mysql.

futurity · #2 (**permalink**) 04-29-11, 13:09

PHP Code:


			
<?php



// fetch data from database

$db = mysqli_connect();

$result = mysqli_query($db, 'select * from mytable');



// send http headers

header('Content-type: text/csv');

header('Content-Disposition: attachment; filename="example.csv"');



// get file pointer to stdout

$fp = fopen('php://output', 'wb');



//output header line and first row

$row = mysqli_fetch_assoc($result);

fputcsv($fp, array_keys($row));

fputcsv($fp, $row);



// output remaining rows

while ($row = mysqli_fetch_row($result)) {

    fputcsv($fp, $row);

}



fclose($fp);

Internet Services

Web Development

Digital Marketing

Consumer Tech