CIT Final Project Planning Document
Part A Requirements and Tasks
Part A of the final project is this planning document.
Part B Requirements and Tasks
Create two tutorials from four possible subjects. 1. Selecting data from a database. 2. Inserting data into a database. 3. Updating data in a database. or 4. Deleting data from a database.
The content from these tutorials should be stored in a database and dynamically requested and manipulated by the user.
| Field Name | Data Type | Specification | Description |
|---|---|---|---|
| cont_id | int | auto Incrament | primary Key |
| cont_title | varchar | 1000 char | |
| cont_content | varchar | 5000 char |
I will need to create a page that interacts with this table in my database and displays the content being requested by the user by appending a name value pair, when selected the user will see one of two tutorials.
This document will need the following:
A connection to the database
Set a session once they login to post a comment in part C
Get values if any from the session
Check for submission
Validate all imputs
Check for errors
display a succss message upon submission of a comment.
Part C Requirements and Tasks
Create a feedback mechanism were users can post comments relating to the tutorials in part B. The requirements are as followed. 1. The user must be logged in to your website in order to post a comment. 2. The form only asks the user for a title and a comment about the content on the page. 3. When the information has been submitted and posted to the page it should display the title of the comment, the comment its self, the date and time of the comment, and a modified version of the users name.
| Field Name | Data Type | Specification | Description |
|---|---|---|---|
| id | int (10) | auto Incrament | primary Key |
| titles | varchar | 100 char | |
| message | varchar | 5000 char | |
| date | timestamp | CURRENT_TIMESTAMP |
Now with the table ready to go I need to create a form with two fields, one for a title and the other for the users comment. The form must only be accessible to users who are logged in, therefore I will need to create a session and only display the form when the session exist.
Once the title and comment are inserted and stored into the database I will need to query the database and post the title, message, date, and modified name of the user in a message area at the bottom of the tutorial page that is visible to anyone.
Then I will need the functionality of when the user finishes the tutorial and see the comments that they can click a login to comment link, login and be redirected back to the tutorial page but now the form is visible and they can post their comment.
