Devam Ediyor

474471 PHP Upload HTML table and load to MySQL table

Hi!

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

Requirements:

1) PHP/MySQL

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)

Beceriler: Her şey Kabul, HTML, Javascript, jQuery / Prototype, MySQL, PHP

Daha fazlasını görün: jquery load mysql, php mysql load table, php load table, sample system using php, php verify, php string to html, html 5 table, html 5 form tag, html 5 5 0, 9 to 5 mac, mysql ui, javascript and mysql, table of content, php mysql html, need php quotes, html table, html c c, html 5 app, float, php file upload form, php load html, php jquery file, mysql characters, php upload file csv, html form javascript load

İşveren Hakkında:
( 0 değerlendirme )

Proje NO: #2220375