I managed to export whole table using following code. Now I want to export data to excel using from and to date or using any date picker.
Expand|Select|Wrap|Line Numbers
- <?php
- //include 'connectdb.php';
- mysql_connect("localhost", "root", "123") or die(mysql_error());
- mysql_select_db("nadaehsan") or die(mysql_error());
- $count = 0;
- $sqlquery = "select * from main" ;
- $result = mysql_query($sqlquery) or die(mysql_error());
- $count = mysql_num_fields($result);
- $header = '';
- $data ='';
- for ($i = 0; $i < $count; $i++) {
- $header .= mysql_field_name($result, $i)."\t";
- }
- while($row = mysql_fetch_row($result)) {
- $line = '';
- foreach($row as $value) {
- if(!isset($value) || $value == "") {
- $value = "\t";
- } else {
- # important to escape any quotes to preserve them in the data.
- $value = str_replace('"', '""', $value);
- # needed to encapsulate data in quotes because some data might be multi line.
- # the good news is that numbers remain numbers in Excel even though quoted.
- $value = '"' . $value . '"' . "\t";
- }
- $line .= $value;
- }
- $data .= trim($line)."\n";
- }
- # this line is needed because returns embedded in the data have "\r"
- # and this looks like a "box character" in Excel
- $data = str_replace("\r", "", $data);
- # Nice to let someone know that the search came up empty.
- # Otherwise only the column name headers will be output to Excel.
- if ($data == "") {
- $data = "\no matching records found\n";
- }
- $count = mysql_num_fields($result);
- # This line will stream the file to the user rather than spray it across the screen
- header("Content-type: application/octet-stream");
- //header("Content-type: text/plain");
- # replace excelfile.xls with whatever you want the filename to default to
- header("Content-Disposition: attachment; filename=excelfile.xls");
- header("Pragma: no-cache");
- header("Expires: 0");
- //echo $header."\n".$data;
- echo $header."\n".$data."\n";
- ?>
I am new in PHP and mysql so please help out me..Thanks