PHP export from MySQL DB to Excel/CVS file

Končano Objavljeno Jan 26, 2011 Plačilo ob prevzemu
Končano Plačilo ob prevzemu

I need a function that will accept an SQL query and output the data into an Excel spreadsheet and/or CVS file depending on user selection. I have an existing PHP web application and I will integrate this function into that application. I want the user to be able to click a link of button on a page in the app to execute the export.

I will provide access via FTP to the mySQL database and and the webpages with the appropraite links. I will provide the sql query. An established connection to the database already exists. I only need the function. For someone who has done this and knows what they are doing this should take about 1/2 hour to complete. I need it done today.

I will have additional work if you can turn this around quickly. The next step will be to output to Excel in a specified format. I have to match an existing "report" done in Excel and match their formatting as close as possible. I use the PEAR libraries in my PHP code and have been looking at the PHPExcel - OpenXML - Create Excel2007 documents in PHP - Spreadsheet engine ([login to view URL]) this has a lot of formatting capability but it is complex. Another option is: Package for generating Excel spreadsheets (.xls) ([login to view URL]) if you have experience with either of these packages it is a big plus for ongoing work with me.

Excel MySQL PHP

ID projekta: #927256

Več o projektu

6 predlogov Oddaljen projekt Aktiven Jan 26, 2011

Dodeljeno:

why4500

I am ready to complete your function and as you said it will take about half hour or less

$30 USD v 0 dneh
(1 Ocena)
2.2

6 freelancerjev ponuja v povprečju za $69 na tem delu

zeee

Hi, Please see PMB.

$50 USD v 1 dnevu
(172 ocen)
7.8
agilesols

please check your inbox,thanks

$100 USD v 1 dnevu
(216 ocen)
7.5
halezabux

Lets start! Waiting for your reply.

$35 USD v 0 dneh
(50 ocen)
6.4
AdamsK

i have a ready function. thank you.

$100 USD v 0 dneh
(84 ocen)
5.7
PauloSam

Hello, I can do this. Check PM.

$100 USD v 1 dnevu
(43 ocen)
5.4