Export MYSQL data for specific date into Excel/CSV via php

[huda89]

Hi,

I would like to export mysql data into excel/CSV for specific date.
For example i would like to generate data from 01-11-2012 to 31-12-2012, how do i perform this process?
I had done export mysql data into excel/CSV file for whole data in database but now the problem is i would like to generate data in date range. Can anyone help me. Thank You =)

[Rabbit]

Show us how you did it for a whole table.

[huda89]

I find this code from internet then i edit a little bit and apply it to my code.

<?php
/*
 * PHP code to export MySQL data to CSV
 * http://911-need-code-help.blogspot.com/2009/07/export-mysql-data-to-csv-using-php.html
 *
 * Sends the result of a MySQL query as a CSV file for download
 */
 
/*
 * establish database connection
 */
 
$conn = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('SLA1', $conn) or die(mysql_error($conn));
 
/*
 * execute sql query
 */
 
$query = sprintf('SELECT * FROM report1');
$result = mysql_query($query, $conn) or die(mysql_error($conn));
 
/*
 * send response headers to the browser
 * following headers instruct the browser to treat the data as a csv file called export.csv
 */
 
header('Content-Type: text/csv');
header('Content-Disposition: attachment;filename=export.csv');
 
/*
 * output header row (if atleast one row exists)
 */
 
$row = mysql_fetch_assoc($result);
if ($row) {
    echocsv(array_keys($row));
}
 
/*
 * output data rows (if atleast one row exists)
 */
 
while ($row) {
    echocsv($row);
    $row = mysql_fetch_assoc($result);
}
 
/*
 * echo the input array as csv data maintaining consistency with most CSV implementations
 * - uses double-quotes as enclosure when necessary
 * - uses double double-quotes to escape double-quotes 
 * - uses CRLF as a line separator
 */
 
function echocsv($fields)
{
    $separator = '';
    foreach ($fields as $field) {
        if (preg_match('/\\r|\\n|,|"/', $field)) {
            $field = '"' . str_replace('"', '""', $field) . '"';
        }
        echo $separator . $field;
        $separator = ',';
    }
    echo "\r\n";
}
?>

[Rabbit]

You just need to change the sql query to filter for those dates.