Php exports csv or xls file programs

Due to work requirements, we need to export the data in the mysql database to execel for use today, and then I found it on the internet that it was so simple, because the csv file only needs ", "It's okay to separate them. Let's take a look at the instance.

<? Php
Include ("../inc/connect. php ");
$ Date = date ("Y-m-d ");
$ Filename = $ Date. ". csv ";
$ Table = isset ($ _ GET ['tid'])? $ _ GET ['tid']: '';
Header ("Content-type: application/vnd. ms-excel ");
Header ("Content-Disposition: filename =". $ Filename );
Echo "user name, real name, contact information, contact QQ, contact address, email address rn ";
$ SQL = "Select * from gx_member where datediff (m_time ,'". date ("Y-m-d H: I: s "). "') <= $ Table order by id desc ";
$ Result = mysql_query ($ SQL );
While ($ rs = mysql_fetch_array ($ Result )){
Echo $ rs ['m _ name']. ','. $ rs ['m _ realname']. ",". $ rs ['m _ tel ']. ",". $ rs ['m _ qq']. ",". $ rs ['m _ address']. ",". $ rs ['m _ mail']. "rn ";
}

?>

We used to export the csv file. There is another way to export the xls file. You just need to modify it.

Header ("Content-type: application/vnd. ms-excel ");
Header ("Content-Disposition: filename =". $ Filename );

It's almost done.

For original site reprinted, please indicate www.111cn.cn/phper/php.html