Closed

424594 PHP - Export MySql to Excel

This project was awarded to rajeshsonisl for $10 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project 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

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