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 as long as the csv file is used, it is OK to separate the files, next, I want to export the data in the mysql database to execel for use due to work needs. 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.
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
Else, separate them and then OK. below I...