I gang

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, php code create report, php mysql connection, mysql db, mysql data access, me excel, ftp engine, create php code, php export cvs, php mysql excel, php create function, provide work excel, turn page app, to excel, pear, option accept, openxml, mysql report, format excel, export, export php, export mysql, excel work today, excel report, excel function

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

Projekt-ID: #927256

Tildelt til:

why4500

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)
2.2

7 freelancere byder i gennemsnit $71 for dette job

zeee

Hi, Please see PMB.

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

please check your inbox,thanks

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

Lets start! Waiting for your reply.

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

hi, please check pm

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

i have a ready function. thank you.

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

Hello, I can do this. Check PM.

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