I want to save or backup data from my database to excel file using php.

How It Works

Get an answer in three easy steps. Here's how it works...

1. Ask Your Question

Enter your PHP question at the top of this page and click Get An Answer.

2. Pick Your Priority

Tell us how quickly you want your PHP question answered.

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Get An Answer

Answer

Customer

I want to save or backup data from my database to excel file using php.

Posted 3/13/2011

Albert Shohez

Programmer

There are many ways to achieve this with PHP.

The simplest way & my suggestions to get data into a format that can be used with Excel is simply to write a .csv text file, or comma separated file, and then open this in excel.

This will split the data into columns based on where the commas are, so you will need to ensure that your data is well formatted to make this value, and so this means that the comma only appears as a separator for instance and if it appears elsewhere it is escaped.

Posted 3/14/2011

Customer

Thanks, Great idea.

Posted 3/15/2011

Get An Answer

Testimonials

Featured Programmer

Byron Narciso
Programmer

Byron has over 15 years of Technical Support Experience with expertise on Windows, Apple devices , Android, Virus Removal, Cloud Computing, Email Configuration, Smartphones, Facebook, Instagram, Kindle, Twitter,Dropbox, Linkedin, Printer configurations and Networking. He has worked for some of the top computer manufacturers in the world and has served as a Subject Matter Expert for Level 1 and 2 technicians providing assistance in resolving advance technical issues. Byron holds a degree in Electronics and Communications Engineering with a DSCE and CCNA certification.

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

Get An Answer

I want to save or backup data from my database to excel file using php.

How It Works

Get an answer in three easy steps. Here's how it works...

1. Ask Your Question

2. Pick Your Priority

3. Get An Answer

Answer

Testimonials

Featured Programmer

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

More PHP Questions...

Ask Your PHP Question & Get An Answer Now!