424594 PHP - Export MySql to Excel

  • Status Closed
  • Budget N/A
  • Total Bids 1

Project Description

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

Get free quotes for a project like this
Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online