We need nelp with creating a PHP/MySQL file upload/handling script.
> We need the work to be completed within 3 days of awarding the project
> After work completion (or during development, if any questions shoud arise) you will have to make a fully functional example available to us online so that we can test the functionality of the script.
> Full payment will be kept in the escrow account and transferred the same day as the completed work has been reviewed and approved by us.
The script will be used in addition to a web based facility booking system handled by the staff of a concert hall here in Sweden.
When a booking is recieved, the staff enters all info into the booking system. However, they also want to associate a PDF-file (containing info from the customer) to each booking. The booking system does not allow this, so we have decided to go for a simple solution to the problem: An external (web based, of course) file upload utility that produces a simple URL to a page that presents each uploaded file. The URL is then pasted into the description field of the booking in the booking system.
EXAMPLE OF USAGE
The user logs into the file upload utility. On the first page, a list of already uploaded files is displayed, together with "view entry"- and "delete entry" buttons. More on this later.
He clicks on "Upload new file" (button located at top of page, somewhere), and is taken to the file upload page. (This doesn't have to be on a separate page I guess. Any recommendations are welcome).
Here, the user can browse for a file to upload, add a short description (text field, max 60 characters) and click "Upload file". The file should now be uploaded onto a directory on the server, and a row in the MySQL-database's table created (storing the entry ID, the filename, and the description). If the filename already exists on the server, the user should be asked to rename the file. Overwriting files should NOT be an option. Both the file- and the description fields are mandatory. Clicking "Upload file" without choosing a file or filling in the description field should result in a prompt telling the user fill in the required fields.
Now, the user should be taken to the "View entry" page, where the following is displayed:
> Entry number (the first uploaded file gets number 1, the second file gets number 2, etc.)
> Entry description
> Link to the file
> The URL to this very page (for example: http://www.site.com/fileupload/viewentry.php?id=1) that can easily be copied and then pasted into the booking system (mentioned above). PLEASE NOTE that you don't have to worry about making the URL SEO-friendly. We will take care of that.
> A link back to the home page of the util.
THE HOME PAGE
On the home page, a list of entries (uploaded files) should be displayed. Preferably, pagination links should be used, displaying no more than 20 entries on each page. Sorting order should be descending (newest entries first). Each entry in the list should contain the following:
> Entry ID
> Entry description
> Link/button: View entry
> Link/button: Delete entry
Clicking the "View entry" link should take the user to the detail page of that very entry.
Clicking the "Delete entry" link should bring up a "Do you really want to delete this? Yes - No"-window. If "Yes" is clicked, the entry should be deleted from the database, and the file should be deleted from the server.
The home page should also, of course, either contain the file upload form or include a link to a separate file upload page.
The file upload utilty will be hosted on a Linux server running Apache/2.0.54 and MySQL 4.1.13.
Any ideas and suggestions are more than welcome, but the above is a scenario of how it might look. Please PM us with any further questions.