Web Guru...: Export excel sheet code in php

$query = "SELECT `name` , `dob` , `gender` , `email` ,

 `mobile` , `street` , `city` , `state` , `postalcode` , `country` ,

 `applied` , `appliedmonth` , `appliedyear` ,

 `tenthcourse` , `tenthpercent` , `twelvethcourse` , `twelvethpercent` , `graduationcourse` , `graduationpercent` ,

 `pgcourse` , `pgpercent` , `haveexperience` , `expinmonth` ,

 `currentemployer` , `currentdesig` , `durationinmonth` , `currentsalary` , `expectedsalary` ,

 `appliedposition` , `resume` FROM `applyonline` order by `id` DESC";

 $result = mysql_query($query) or die(mysql_error());

 $tsv = array();

 $html = array();

 //////////////////////////////top heading in excel file////////////////////////////////////////////

 //$tsv[] = "APPLIED CANDIDATES REPORT";

 //$html[] = "<tr>" ."<td>"."APPLIED CANDIDATES REPORT"."</td></tr>";



 $tsv[] = "Name";

 $html[] = "<tr>" ."<td>"."Name"."</td>";



 $tsv[] = "DOB";

 $html[] = "<td>"."DOB"."</td>";



 $tsv[] = "Gender";

 $html[] = "<td>"."Gender"."</td>";



/* $tsv[] = "City of work";

 $html[] = "<td>"."City of work"."</td>";

*/



 $tsv[] = "Email";

 $html[] = "<td>"."Email"."</td>";





 $tsv[] = "Mobile";

 $html[] = "<td>"."Mobile"."</td>";





 $tsv[] = "Street";

 $html[] = "<td>"."Street"."</td>";



 $tsv[] = "City";

 $html[] = "<td>"."City"."</td>";





 $tsv[] = "State";

 $html[] = "<td>"."State"."</td>";





 $tsv[] = "Postal Code";

 $html[] = "<td>"."Postal Code"."</td>";





 $tsv[] = "Country";

 $html[] = "<td>"."Country"."</td>";





 $tsv[] = "Applied";

 $html[] = "<td>"."Applied"."</td>";





 $tsv[] = "Applied Month";

 $html[] = "<td>"."Applied Month"."</td>";





 $tsv[] = "Applied Year";

 $html[] = "<td>"."Applied Year"."</td>";





 $tsv[] = "Xth Course";

 $html[] = "<td>"."Xth Course"."</td>";





 $tsv[] = "Xth Percent";

 $html[] = "<td>"."Xth Percent"."</td>";





 $tsv[] = "XIIth Course";

 $html[] = "<td>"."XIIth Course"."</td>";





 $tsv[] = "XIIth Percent";

 $html[] = "<td>"."XIIth Percent"."</td>";





 $tsv[] = "Graduation Course";

 $html[] = "<td>"."Graduation Course"."</td>";





 $tsv[] = "Graduation Percent";

 $html[] = "<td>"."Graduation Percent"."</td>";





 $tsv[] = "PG Course";

 $html[] = "<td>"."PG Course"."</td>";





 $tsv[] = "PG Percent";

 $html[] = "<td>"."PG Percent"."</td>";





 $tsv[] = "Have Experience";

 $html[] = "<td>"."Have Experience"."</td>";





 $tsv[] = "Exp. in Month";

 $html[] = "<td>"."Exp. in Month". "</td>";





 $tsv[] = "Current Employer";

 $html[] = "<td>"."Current Employer"."</td>";





 $tsv[] = "Current Designation";

 $html[] = "<td>"."Current Designation"."</td>";





 $tsv[] = "Duration in Month";

 $html[] = "<td>"."Duration in Month"."</td>";





 $tsv[] = "Current Salary";

 $html[] = "<td>"."Current Salary"."</td>";





 $tsv[] = "Expected Salary";

 $html[] = "<td>"."Expected Salary"."</td>";





 $tsv[] = "Applied Position";

 $html[] = "<td>"."Applied Position"."</td>";





 $tsv[] = "Resume";

 $html[] = "<td>"."Resume"."</td></tr>";







 ///////////////////////////////////////////////////////////////////////////////////////////////////

 while($row = mysql_fetch_array($result, MYSQL_NUM))

 {

 $tsv[] = implode("\t", $row);

 $html[] = "<tr><td>" .implode("</td><td>", $row) ."</td></tr>";

 }



 $tsv = implode("\r\n", $tsv);

 $html = "<table border=1>" . implode("\r\n", $html) . "</table>";



 $fileName = 'report.xls';

 header("Content-type: application/vnd.ms-excel");

 header("Content-Disposition: attachment; filename=$fileName");

 //echo $tsv;

 echo $html;

Web Guru...

Monday, June 3, 2013

Export excel sheet code in php

No comments:

Post a Comment

Popular Posts

Total Pageviews

Categories