Oct

How to convert SQL to Excel in Php?

Arpi

PHP, Tips

Many a times while developing a project we want to send the query data to the user or we want to have the query data for any other reason like analysis or report etc.

So to convert the SQL query data into the excel sheet form is many a times useful for developers.

You can do it using following code,

<?      $sql = "select * from wp_db";
	$result = mysql_query($sql);
	$arr_data = array();

	while($data = mysql_fetch_assoc($result)){
                   $arr_data[] = $data;

	$sep = "\t"; //tabbed character
	$fp = fopen('report.xls', "w");
	$schema_insert = "";
	$schema_insert_rows = ""; 

	$schema_insert_rows.= "\t Query Result in Excel \n"; 

	$schema_insert_rows.="Insert Headings here for each fields\t";
	$schema_insert_rows.="\n";
	fwrite($fp, $schema_insert_rows);

	foreach($arr_data as $k=>$v){
	$schema_insert .= implode("\t",$v)."\n";
	}

	fwrite($fp, $schema_insert);
	fclose($fp);

?>

save your file and run the code.

You will find one excel sheet saved in the same folder

as your file containing this code is residing.

Arpi

hiii friends… i am doing msc in computer application and information technology. we are here to share our knowledge and idea on shareprogrammingtips.com.