Php And Mysql Code For File Up
Code Required for File Upload Functionality:
Require:
1. Java script for PHP page AND
2. Corresponding MySQL code to put the file into existing database.
Attached diagram is rough outline of implementation:
Column “A” indicates that there will be several dynamically determined fields for users to check (to indicate the line item is included in the uploading file) – (from 0 to 10 of these)
There are also optional fields the user can populate to indicate that a user entered item is included in the uploading file – (from 0 to 10 of these)
At least one field (up to 20) from column A will be passed, along with the file and file name to the database. If there isn’t at least one field selected from A, an error should be returned. A file selected for column B is also requried or an error should be returned on selecting “Submit”.
Specific Requirements:
1. upload to occur in background (use of AJAX)
2. permit simultaneous (or qued) uploading capability
3. files to be stored in database itself (some have suggested use of BLOB?)
4. permit only .pdf files or image files
5. upload file size limit to 20MB
6. use “browse” function (similar to Elance file upload) to select file for upload
7. require file to have been selected to complete upload
8. require at least one field from column A (see attached diagram) to complete upload
9. verify that “client ID” from URL exists in table “One” from database
10. file upload section should reload after completeing successful upload
The intent is that we will propagate the code through our interface ourselves after reciept from the provider.
Please let me know if there are questions.