PHP export with empty content -

PHP export with empty content -

i'm having problem here. wanted retrieve info mysql database , export it. however, exported csv file contains nothing. please help me.

if(isset($_post['export'])){ $filename = 'applicants '.date('m-d-y').'.csv'; $tablename="applicants"; $sql=mysql_query("select * applicants"); $num_rows=mysql_num_rows($sql); mysql_data_seek($sql, 0); $row = mysql_fetch_assoc($sql); $fp = fopen($filename,"w"); $seperator=""; $comma=""; $tablename="applicants"; foreach($row $name => $value) { if($name==""){ $name=" "; } $seperator .= $comma . '' .str_replace('','""','"'.$name.'"'); $comma = ","; } $seperator .="\n"; fputs($fp,$seperator); mysql_data_seek($sql, 0); while($row = mysql_fetch_assoc($sql)){ $seperator=""; $comma=""; foreach($row $name => $value) { $seperator .= $comma . '' .str_replace('','""','"'.$value.'"'); $comma = ","; } $seperator .="\n"; fputs($fp,$seperator); } header("content-disposition: attachment; filename=\"$filename\""); header("content-type: application/vnd.ms-excel"); fclose($fp); }

here simple methos ...make changes according you

// output headers file downloaded rather displayed header('content-type: text/csv; charset=utf-8'); header('content-disposition: attachment; filename=data.csv'); // create file pointer connected output stream $output = fopen('php://output', 'w'); // output column headings fputcsv($output, array('mysqlcolumnname1', 'mysqlcolumnname2', 'mysqlcolumnname3')); // fetch info mysql_connect('localhost', 'username', 'password'); mysql_select_db('database'); $rows = mysql_query('select field1,field2,field3 table'); // loop on rows, outputting them while ($row = mysql_fetch_assoc($rows)) fputcsv($output, $row);

php export-to-csv