Question: Hi, I am having trouble with my database project. I need to create a forum where users can log in, view categories, view and create

Hi, I am having trouble with my database project. I need to create a forum where users can log in, view categories, view and create topics and replies. I need to create and use an appropriate database to handle all of the data for the forum. Since this assignment will require the use of multiple files, I must use "includes"/"requires." I also need to use functions to handle repeated code. Styling can be minimal, but it must be functional, readable, and easy-to-use. In addition, I need to populate the forum/database with some initial data. Any data that goes to the database must be validated and sanitized.

Login Feature Requirements: Users must be able to log in to the forum. I need to create a user named test with a password of test," so that the forum can be accessed. Users must log in before they can add topics or replies. Non-logged in users should be able to see categories and topics, but not able to add topics or replies. User registration is not a requirement.

Category Requirements: The forum should have at least three categories. Users can view categories, but NOT create categories.

Topic Requirements: Topics will exist under categories. Anyone can view topics. Logged in users can create new topics. Topics should have a subject line and a message line. Topics should also have a date they were created/posted listed, as well as the author listed.

Replies Requirements: Replies will exist under topics. Anyone can view replies. Logged in users can reply to topics. Replies should have a message or comment. Replies should also have a date they were created/posted listed, as well as the author listed.

Use "MySQL Workbench" to create the database, including a model diagram. Use "includes" to store code that need to be used repeatedly, like database connection code. Use functions where appropriate to reuse code (perhaps it might make sense to also have a functions include). Provide at least a small amount of styling, so that the pages are readable and functional. Populate the forum/database with some initial data. Anything that hits the database needs to be sanitized/validated.

Include: text files for every PHP/HTML/CSS file, as well as a screenshot of the EER diagram of the database labeled appropriately.

(Above is all of the information given to me.)

Thank you so much, in advance!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!