Save the database query result to Excel

Excel can easily process data. If the database data can be read into an excel file, it can be easily processed.

Convert database data to Excel excel. php

<?phpclass excel{    function start()    {      ob_start();     }    function save($path)      {        $data = ob_get_contents();        ob_end_clean();        $this->wirtetoexcel($path,$data);     }   function wirtetoexcel ($fn,$data)     {       $fp=fopen($fn,"wb");       fwrite($fp,$data);       fclose($fp);    }}?>

Create an object of this class, and then call the method of this object to export database data to Excel.

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">  <link href="css/style.css" rel="stylesheet" type="text/css" />  <?php   include("conn.php");  $query=mysql_query("select * from map order by register_date desc") ;   $i=$perpagenum*($page-1)+1;   include_once("excel.php");$Excel=new Excel();$Excel->start();?><table width="600" border="0">  <tr>      <td align="center">companyname_cn</td>      <td align="center">companyname_en"</td>      <td align="center">name</td>      <td align="center">position</td>      <td align="center">tel</td>      <td align="center">fax</td>      <td align="center">email</td>      <td align="center">website</td>      <td align="center">product</td>    </tr> <?phpwhile($myrow = mysql_fetch_array($query)){   ?>    <tr>      <td align="center"><?php echo $myrow["companyname_cn"]; ?></td>      <td align="center"><?php echo $myrow["companyname_en"]; ?></td>      <td align="center"><?php echo $myrow["name"]; ?></td>      <td align="center"><?php echo $myrow["position"]; ?></td>      <td align="center"><?php echo $myrow["tel"]; ?></td>      <td align="center"><?php echo $myrow["fax"]; ?></td>      <td align="center"><?php echo $myrow["email"]; ?></td>      <td align="center"><?php echo $myrow["website"]; ?></td>      <td align="center"><?php echo $myrow["product"]; ?></td>    </tr>  <? }  ?>  </table>  <p>  <?php   $Excel->save("Excel/data.xls"); ?>  </p>

The key code is actually a few lines:

// Contains the class file include_once ("excel. php "); // create an excel Class Object $ Excel = new Excel (); // call the start () method of the object $ Excel-> start (); // call the save () file of the object to claim the excel file. $ Excel-> save ("Excel/data.xls ");