genrating xlsheet with mysql but also contains html code in xl sheet need remove html code
- by pmms
following is the code for getting xlsheet from mysql
?php
if($_POST['Submit']=='Generatexml')
{
$tblname=$_GET['genratexml'];
//mysql_connect("localhost","root","");
//mysql_select_db("hitnrunf_db");
global $obj_mysql;
$result = mysql_query("SELECT * FROM tbl_js_login");
while($row = mysql_fetch_array($result)) {
$csv_output .= "$row[fld_id],$row[fld_fname],$row[fld_lname]";
$csv_output .="\015\012";
}
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv; filename= Student_Data_". date("Y-m-d") . ".csv");
print $csv_output;
exit;
}
include_once $path."includes/jobseeker_form.php";
?
following is the link error we are getting
http://www.eminosoft.com/screenshot/xlsheet.JPG
