How To Create excel file with Mysql Data using php Code.

Hi friends, I have code for how to create a excel file with mysql data using php code.

Follow the below steps to retrieve the data from database

Config.php

<?php

$host="localhost"; // Host name

$username=""; // Mysql username

$password=""; // Mysql password

$db_name="test"; // Database name

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

?>

a.php

<?php

          include("config.php");

          $filename = "excelwork.xls";

          $exists = file_exists('excelwork.xls');

          if($exists)

          {

                   unlink($filename);

          }

                   $filename = "excelwork.xls";

                   $fp = fopen($filename, "wb");

                   $sql = "select * from product";

                   $result = mysql_query($sql);

                   $schema_insert = "";

                   $schema_insert_rows = "";

                   for ($i = 1; $i < mysql_num_fields($result); $i++)

                   {

                   $insert_rows .= mysql_field_name($result,$i) . "\t";

                   }

                   $insert_rows.="\n";

                   fwrite($fp, $insert_rows);

                   while($row = mysql_fetch_row($result))

                   {

$insert = $row[1]. "\t" .$row[2]. "\t".$row[3]. "\t".$row[4]. "\t".$row[5];

                   $insert .= "\n";               //       serialize($assoc)

                   fwrite($fp, $insert);

                   }

                   if (!is_resource($fp))

                   {

                             echo "cannot open excel file";

                   }

                   echo "success full export";

                   fclose($fp);

?>

This is the steps to create excel file with mysql data using php code.

Once u run a.php it create excelwork file.

Posted in: create,excel,mysql,PHP Code