Hi all.
I need a objective evaluation on this.
How long time would it take you to create the following assignment? What is realistic in days/hours - with a maximum working day on 8 hours. All basic php files for the project are created before hand and ready to work on. All CSS and HTML are also created. So it is solarly PHP and MYSQL. However, you would not be allowed to use the internet or any “virtuel” notes, meaning that you could only use printed notes or books. So it would not be possible to copy and paste any codes.
In your evaluation please consider and state your “level”, (beginner, trained, pro, or something) as a programmer.
Below is the case and the assignments.
Hope you will take a look at it 
CASE:
You have to develop a basic content management system (CMS) for the fictitious company Skive Toys. Skive Toys only sells in their shop, but wishes to have an online catalogue of their products that can be updated according to the new arrivals and their inventory.
The company’s website administrator has to be able to add categories, add products, and update product information (pictures, price, product description). The administrator also has to be able to delete comments added to the Guestbook, as well as to retrieve and update information from the registered customers.
The CMS and Customer Areas have to be secured by means of Sessions and/or Cookies.
Skive Toys also wishes to give their customers the opportunity to communicate with the company through a Guestbook and a Contact Form. Only registered users will be allowed to post messages on the guestbook, but all visitors can use the Contact Form.
TASKS:
- DATABASE
a. Create a database with the following settings:
i. Database name: mp3_studentnumber – replace studentnumber with your own student number
ii. Username: exammp3_studentnumber – replace studentnumber with your own student number
iii. Password: exammp3
iv. Host: localhost
b. Create a connection script, save it as db.php inside the folder called includes.
c. Using the information given to you in the case, plan and generate the necessary tables for the CMS. The tables have to be generated and populated using PHP files, not through PHPMyAdmin. All files have to be included on the USB Memory Stick at root level.
d. Create a backup file of your database on .sql format, and save it as dbstudentnumber.sql in your USB Memory Stick at root level.
- CUSTOMER-AREA
a. Add the necessary scripting (PHP) to the file called frontend/registration.php. Make sure that your passwords are secured using a combination of salts and MD5 encryption, that the password validates (is identical in both fields), and that the username is unique.
b. Add the necessary scripting (PHP) to the file called frontend/customerlogin.php, for it to allow registered customers to login and be redirected to the page called frontend/guestbookentry.php.
c. Create a Guestbook (frontend/guestbookentry.php) where the users can add comments. The username of the customer has to appear on the entries.
- CMS (ADMINISTRATOR AREA)
a. Create an administrator user with the following information:
i. Username: admin
ii. Password: passadmin
b. Add the necessary scripting (PHP) to the file called cms/adminlogin.php for it to allow the administrator to login and be redirected to the private section of the website.
c. Create the necessary files for the administrator to be able to add categories and products to the database. The products have to be linked to a specific category, and have to allow the user to upload pictures.
d. Create the following pages with the enlisted functionalities:
i. cms/cmscategory.php – Allows for the administrator to add or edit categories
ii. cms/addproduct.php – Allows for the administrator to add or edit products
iii. cms/viewcustomers.php – Displays a list of registered customers and allows for its update.
iv. cms/editguestbook.php – Allows for the administrator to edit Guestbook entries, and to publish them on the Front End.
- FRONT END (PUBLIC SITE)
a. Create the necessary files for the following pages with the enlisted characteristics:
i. frontend/products.php – Displays a list of categories and products based on the category selected by the user
ii. frontend/guestbook.php – Display the guestbook entries approved by the administrator
iii. frontend/contact.php – Sends an e-mail to the website’s administrator with comments from the visitor. Has to validate the e-mail address field before sending it.
