PHP export from MySQL DB to Excel/CVS file

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 ([url removed, login to view]) this has a lot of formatting capability but it is complex. Another option is: Package for generating Excel spreadsheets (.xls) ([url removed, login to view]) if you have experience with either of these packages it is a big plus for ongoing work with me.

Færdigheder: Excel, MySQL, PHP

Se mere: php cvs, what is packages in sql, spreadsheet to web application, php to excel export, php code to create report, php and mysql connection, mysql db, mysql data access, me excel, ftp engine, excel to application, create php code, php export cvs, php mysql excel, php create function, who provide the work excel, web to excel, turn page app, to excel, report from excel, pear, option to accept, openxml, mysql report, format excel

Om arbejdsgiveren:
( 1 bedømmelse ) Beaverton, United States

Projekt-ID: #927256

Tildelt til:


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

$30 USD in 0 dage
(1 bedømmelse)

7 freelancers are bidding on average $71 for this job


Hi, Please see PMB.

$50 USD på 1 dag
(161 bedømmelser)

please check your inbox,thanks

$100 USD på 1 dag
(204 bedømmelser)

Lets start! Waiting for your reply.

$35 USD in 0 dage
(43 bedømmelser)

hi, please check pm

$80 USD på 1 dag
(13 bedømmelser)

i have a ready function. thank you.

$100 USD in 0 dage
(67 bedømmelser)

Hello, I can do this. Check PM.

$100 USD på 1 dag
(44 bedømmelser)