File upload/handling script (PHP/MySQL)
This project was awarded to sisindia for $180 USD.Get free quotes for a project like this
Project Budget$100 - $500 USD
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: [url removed, login to view]) 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/[url removed, login to view] 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.
Browse Related Skills
Other things people do on Freelancer
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online