474471 PHP Upload HTML table and load to MySQL table

This project is now closed with a project budget of N/A.

Get free quotes for a project like this
Project Budget
Project Description


I need a web app to do the following:

1) User has text file containing HTML table (file's content starts with "<TABLE" and ends with "</TABLE>" (see [url removed, login to view] attached here)

2) User uploads file using form

3) App displays uploaded data as HTML table and CSV (using <PRE> tag) for user to verify

3) App uses uploaded table to replace existing data in MySQL table



2) Keep UI simple -- optionally use very simple JQuery or javascript at most

3) HTML table content might include commas, quotes, and other tricky characters like smart quotes and the like

4) First row of HTML table has field names

5) HTML table might have extra fields or missing fields

6) File might come from Mac or Windows system

7) MySQL table columns expect either data, integer, float, string data

6) Web app and MySQL DB are on different servers (you'll need to use "LOCAL" keyword in your MySQL LOAD statement)

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