MYSQL to CSV in excel template

[chaturvedi]

Hello,

 

        What i want to do is get the data from mysql into the sheet i am attaching. I could make a simple csv file with relevant data. But i couldn't get the format as shown in the figure. Could someone please help me as this is very urgent and am not so good at PHP. I got a deadline to meet.. Please.. Thanks in advance..

 

There the following is my code for simple csv file...

<?

session_start();

include("SessionCheck.php");

include("Connection.php");


     $stdt1=$_GET['sdate']; 

   	 $enddt1=$_GET['edate'];

 $empid=$_GET['eid'];



$s1="Select * from emp_master where emp_no='$empid'";

$r1=mysql_query($s1);

$row=mysql_fetch_row($r1);

$empnm=$row[1];



?>


<?



  $host = 'localhost';   
    $csv_terminated = "\n";
    $csv_separator = ",";
    $csv_enclosed = '"';
    $csv_escaped = "\\";	

$result = mysql_query("Select * from timeshiftentry_master where emp_no='$empid' and dt>='$stdt1' and dt<='$enddt1'");
$fields_cnt = mysql_num_fields($result);

    $schema_insert = '';

    for ($i = 0; $i < $fields_cnt; $i++)
    {
        $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
            stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
        $schema_insert .= $l;
        $schema_insert .= $csv_separator;          
   	
    } // end for

   
    $out = trim(substr($schema_insert, 0, -1));
    $out .= $csv_terminated;


    // Format the data
    while ($row = mysql_fetch_array($result))
    {
        $schema_insert = '';
        for ($j = 0; $j < $fields_cnt; $j++)
        {
            if ($row[$j] == '0' || $row[$j] != '')
            {
                
                if ($csv_enclosed == '')
                {
                    $schema_insert .= $row[$j];
                } else				
                {
                    $schema_insert .= $csv_enclosed . 
				str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;

                }
            } else
            {
                $schema_insert .= '';
            }

            if ($j < $fields_cnt - 1)
            {
                $schema_insert .= $csv_separator;
            }
        } // end for

        $out .= $schema_insert;
        $out .= $csv_terminated;

    } // end while





$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $out;
exit;

?>

 

 

 

 

Thanks but how do i include it in my code? am absolutely clueless...pls help..

 

[attachment deleted by admin]

[trq]

You might want to post your problematic code.

[Adam]

I'd definitely use PEAR's "Spreadsheet_Excel_Writer" if you can. This seems like a good tutorial.

[chaturvedi]

Can u tell me how to use the Spreadsheet_excel_writer?

[Mark Baker]

I'd definitely use PEAR's "Spreadsheet_Excel_Writer" if you can. This seems like a good tutorial.

Or other Excel libraries for PHP such as PHPExcel that are still supported, and indeed still being improved