I need a set of PHP scripts to read/write MS Excel files into mySQL db.
script1: form to upload Excel file and take data into SQL table (new records).
script2: form to upload Excel file and update fields in SQL table (existing records with index field).
script3: page to put SLQ data into formatted Excel file for download.
Details:
- The SQL structure and Excel files will be pre-set (no need to create fields dynamically and can ignore additional fields).
- Need to be able to specify which fields (in the script or form page on the server)
- Would like confirmation of # records read in/out.
- Need error notice of invalid data (and record ID#)
- Data will be selected based upon a project # (script will only be run if valid user based on session login so no need to validate user)
- Support MS Excel 2003 and newer?
- Open to suggestions if any of these details make a large difference in cost or time.