Loading

Export Data From PHP/MySQL to Microsoft Excel

Submitted by: 
argie
Wednesday, July 11, 2012 - 11:29
Language: 
PHP
Visitors have accessed this post 6890 times.


This code will help you on how to export data from mysql database using PHP to Microsoft Excel. The feature of this code is it export data from mysql to ms excel readable format. Download and try this code and if you have question, just leave comment and i will answer all your question.

database name: data



Download Code
Tags: 
export data from php to excel
argie's picture

Article by argie

argie has submitted 68 source code / articles.

If you like this post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted by Anonymous on Tue, 10/02/2012 - 15:31

download option is not working

Submitted by Anonymous on Fri, 11/16/2012 - 16:29

hello,i try to download this file and i tried to run them and i found this error"Notice: Undefined index: from in C:\xampp\htdocs\export\index.php on line 57

Notice: Undefined index: to in C:\xampp\htdocs\export\index.php on line 58"but are occur before entered item number.
- next i tried to use that print button and it doesn't work for exporting those data to the Microsoft excel.

Submitted by Anonymous on Fri, 01/11/2013 - 00:34

Hi, this not working on Chrome :( help me please

Submitted by Anonymous on Wed, 02/13/2013 - 15:35

It is very useful...
and
how to insert excel data into php/mysql...

Submitted by Anonymous on Tue, 02/26/2013 - 21:26

Hey its not working.. Please reply

Add new comment

More information about text formats

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.