Closed

PHP: online CSV to DB upload + simple search form

This project was awarded to shimona for $90 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
25
Project Description

In short: online CSV file uploader with access restriction + online public search form to display a line from the uploaded content.

Details:
CSV file uploader:
----------------------
- upload a single CSV file at once.
- insert the data into given database.
(configuration file with: "database_name", "db_username","db_password". Only localhost)
- the input file contains 3 fields: prod_number, track_number, comp_number.
- In the database, there is 4 fields: prod_number, track_number, comp_number, date.
(*) "date" is automatically populated with insertion time.
- If the prod_number exists, overwrite it(and display all the overwritten lines afterwards), if not, create a new line.
- Check that all the fields contains only whole numbers, "-" or " " (space).
- access restriction (username/password) to upload.


Public search form:
------------------------
- Display a field to input "prod_number" and a search button.
- The form will search for the "prod_number" in the database and return the corresponding line (table with the 4 data).
- The form send the request to itself (same [url removed, login to view] file). If no result, display "No result".

Note: Both CSV file uploader & search form are on the same domain, "[url removed, login to view]" for the uploader, "[url removed, login to view]" for the search form.

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