《php用法指定编码导出mysql数据到csv文件的方法_.docx》由会员分享,可在线阅读,更多相关《php用法指定编码导出mysql数据到csv文件的方法_.docx(4页珍藏版)》请在三一文库上搜索。
1、php用法指定编码导出mysql数据到csv文件的方法_ 本文实例讲解并描述了php用法指定编码导出mysql数据到csv文件的方法。分享给大家供大家参考。具体实现方法如下: ?php /* * PHP code to export MySQL data to CSV * * Sends the result of a MySQL query as a CSV file for download * Easy to convert to UTF-8. */ /* * establish database connection */ $conn = mysql_connect(localhost
2、, login, pass) or die(mysql_error(); mysql_select_db(database_name, $conn) or die(mysql_error($conn); mysql_query(SET NAMES CP1252); /* * execute sql query */ $query = sprintf(SELECT field1,field2 FROM table_name); $result = mysql_query($query, $conn) or die(mysql_error($conn); /* * send response he
3、aders to the browser * following headers instruct the browser to treat the data as a csv file called export.csv */ header(Content-Type: text/csv; charset=cp1252); header(Content-Disposition: attachment;filename=output.csv); /* * output header row (if atleast one row exists) */ $row = mysql_fetch_ass
4、oc($result); if ($row) echocsv(array_keys($row); /* * output data rows (if atleast one row exists) */ while ($row) echocsv($row); $row = mysql_fetch_assoc($result); /* * echo the input array as csv data maintaining consistency with most CSV implementations * - uses double-quotes as enclosure when ne
5、cessary * - uses double double-quotes to escape double-quotes * - uses CRLF as a line separator */ function echocsv($fields) $separator = ; foreach ($fields as $field) if (preg_match(/r|n|,|/, $field) $field = . str_replace(, , $field) . ; echo $separator . $field; $separator = ,; echo rn; ? 更多信息请查看IT技术专栏 .