In Progress

424594 PHP - Export MySql to Excel

I need a PHP script to export data from a MySql database to XLS (excel) format.

Right now I can export the data from the table (table A) I need to. But have a few problems (what needs to be done is below)

- In Table A is the ID of the company (company_id). You will need to get the name for that company in another table (table B). So when exporting the data it will show the company name not the company ID.

Example format of table A:

company_id / about


125 / Company is great

521 / We are a great company

456 / This company is big

Example format of table B:

company_id / name


125 / ABC Warehouse

521 / Google

456 / Big Store

- Only export data if the ID is found for that user (table C). The table lists the user ID and the company ID they can export. So before exporting all the companies it would first check to see what companies to export from table C.

Example format of table c:

user_id / company_id


3 / 125

4 / 521

4 / 456

5 / 782

Recap: I have three tables in the same database. I need to be able to pull and check information from all them when exporting data.

Please let me know if you have any questions. This shouldn't take longer than 15 min. I will go through the code and change the database and table names later. I just need a functioning code.

Please PM questions or sample code

Skills: Anything Goes, Excel, MySQL, PHP

See more: php mysql excel, php to excel export, abc warehouse, abc company, google xls, big 4 companies, need to get excel, export, export mysql, export from excel, export data, database to excel, database in excel format, php code sample code, mysql excel export, export excel data mysql, php script mysql export, need excel format, php mysql big data, php show information mysql, check table mysql script, mysql export excel, php google mysql, export mysql script, database warehouse

About the Employer:
( 60 reviews )

Project ID: #2170464

Awarded to:


Clear with Requirement. Ready to get started. Quality work Assured. Thanks.

$10 USD in 0 days
(616 Reviews)