Hi all we have a little web ordering system we would like to set up, as i am no PHP expert, first of all I would like to find out if it is possible to develop the system, how long it should take to build and how much would you expect to pay a compitent programmer for such a system?
Below is an outline of the project we would develop...
the system is for a photography website, the design would be handled by ourselves with most of the programming of the php/mysql database by you.
There are 2 main scenarios that will require similar functionality.
Scenario 1
The Client takes Digital photographs for used by actors for casting, he takes between 6 and 20 black and white digital photos in a session.
Part of the photographers package to clients, is the taking of 6 to 30 black and white Digital photographs of actors who use them for their portfolios and casting, the client then gets to go online and choose 3 photos that the photographer will retouch and have digital photographic prints made - this is all included in the price of his shoot.
Low resolution versions of these pics with thumbnails are uploaded to the web server in a directory using the clients name.
The client will then logon to the website and have some sort of simple logon script that asks their name, and is then forwarded to their page or directory where the uploaded images are.
On the page we need to have the images in the folder appear dynamically in some sort of table with a corresponding checkbox, the client is able to select the images he/she requires to be retouched and prints to be made for their portfolio.
The client then checks the checkboxes for the 3 pictures they want as part of the price and enters their email address to a form field.
The script will than need to read the image name/number of the selected images and add those names to the mysql database together with the client name and date and email address. The script will then also need to send an email to john with the same info so that he can process the order manually. also a confirmation email to the client with the selected photo numbers.
We will need to have some sort of check as to allow only 3 selections and then also a confirmation page showing the selected 3 images.
Scenario 2
the photographers clients may want to order extra prints, or extra photos to be retouched. these photos will not have been paid for like the the 3 images in scenario 1, the user will have the option of selecting as many images as they require as well as a quantity of prints and size of print for each selection. (we can use dropdowns for the sizes as there are about 4, that all have a different price)
There will have to be a confirmation of order page and a calculation of the total amount required.
The script will then have to sent the information to the database and email as before as well as forward the user on to a payment portal such as worldpay (still to be decided) where the user can pay for the extra prints.
Perhaps we can have an option at the top of the scenario page that links to the scenario1 page?
Admin
We would also need some sort of admin section where the photographer could log on and search names to check what pics had been ordered and dates ordered.
He would also have to be able to delete records or update records, and perhaps some way of backing up the database.
any ideas guys? let me know
mark@fairlane57.co.uk
