01.<?
02.$filName = "customer.txt";
03.$objWrite = fopen("customer.txt", "w");
04.
05.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
06.$objDB = mysql_select_db("mydatabase");
07.$strSQL = "SELECT * FROM customer";
08.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
09.
10.while($objResult = mysql_fetch_array($objQuery))
11.{
12. fwrite($objWrite, "\"$objResult[CustomerID]\",\"$objResult[Name]\",\"$objResult[Email]\",");
13. fwrite($objWrite, "\"$objResult[CountryCode]\",\"$objResult[Budget]\",\"$objResult[Used]\" \n");
14.}
15.fclose($objWrite);
16.echo "<br>Generate CSV Done.<br><a href=$filName>Download</a>";
17.?>
