Save database query results to Excel_PHP tutorial-PHP Tutorial-php.cn

Save database query results to Excel_PHP tutorial

WBOY

Release： 2016-07-13 10:32:55

Original

962 people have browsed it

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);
    }
}
?>

Copy after login

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>

Copy after login

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");

Copy after login