Php Code: Export MySQL to Excel

Export MySQL data records to an Excel file in one PHP file, simple and easily!

This tutorial require 1 PHP file and 1 table of mySQL database.

1. export_excel.php
2. Database "tutorial" and table "name_list" with 2 fields: id(auto_increment), name(varchar, 50) and put some records about 20 - 30 records into this table. (directly by phpMyAdmin)

<!-- This Script is from www.hawkee.com, found at www.phpfreecode.com--><br /><b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>159</b><br /><br /><b>Warning</b>: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>160</b><br /><br /><b>Warning</b>: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: A link to the server could not be established in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>160</b><br /><br /><b>Warning</b>: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>163</b><br /><br /><b>Warning</b>: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>163</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>185</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>186</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>187</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>188</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>189</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>190</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>191</b><br /><br /><b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm:6) in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>192</b><br /> ��� ����� ������� �List of car company. � ����� �No. � � ��� �Company<br /><b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/content/k/k/r/kkr152/html/phpfreecode/export_mysql_to_excel.htm</b> on line <b>210</b><br />���