This job requires you to create a form and script that will allow users to submit a testimonial with a photo. I.e. the users will enter their feedback and other info, choose a photo, and click submit.
The form must have the following fields:
* Full Name ??" Text Field - Mandatory
* Email ??" Text Field - Mandatory
* Photo ??" File upload control - (to upload a photo to the server) ??" Mandatory
* Testimonial ??" Multi Line text field ??" Mandatory
* Permission ??" Check box ??" Mandatory (i.e. must be checked to submit).
* This script must be implemented using MySql and Php only.
* The form should only contain basic html. We can make it look different as required.
* The program must store photos in a designated folder on the server
* The photo file name must be based on the Full Name with a random number concatenated to the end. For example, if the name was john smith, the photo might be called john_smith_3454.jpg.
* There must be validation to ensure all mandatory fields are completed
* The script must store all fields on the form in a single MySql table called testimonials (one column for each field). It should also store the location of the related photo in an additional column
* It should be easy to change the database details in all scripts i.e. the username, password, and database name should be stored in variables in a separate file or at the top of the main file.
* Demo of form working (I can provide you with a web server login if required)
* All source code ??" Working and free of known bugs
* Table creation script ??" to setup the MySql database table
* Installation instructions - step-by-step instructions on how to install. These can be brief and in point form