Save database query results to Excel_PHP tutorial

Excel can process data very conveniently. If the data in the database can be read into an excel file, it will be processed very conveniently.

Implement the conversion class excel.php from database data to Excel

<?php
class 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> 
<?php
while($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 just a few lines:

// 包含类文件
include_once("excel.php");
// 创建excel类的对象
$Excel=new Excel();
// 调用对象 $Excel 的 start()方法
$Excel->start();
// 调用对象的 save() 声称 excel 文件。
$Excel->save("Excel/data.xls");

http://www.bkjia.com/PHPjc/752580.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/752580.htmlTechArticleExcel can process data very conveniently. If the data in the database can be read into an excel file, it will be very convenient. deal with. Implement the conversion class excel.php from database data to Excel?phpcla...