Reference no: EM131028370

Introduction

We have covered some PHP database connectivity in class. This lab is designed to give you some experience with PHP and MySQL.

Database Design

Create a separate database called messageboard. Also, create a table in this table called messages with the following fields

Field Name Type Other

ID Int Not null autoincrement

Primary key

Subject Varchar(150)

Body text

Insert Messages Form

Design a form which looks like the figure below:

Display Messages Page

Write a php script which will display all messages posted to date. The page should look similar to the figure below:

Additional Functionality (Extra Credit)

1. Create a form to allow you to choose whether to add messages or display messages

2. Create a script to allow you to delete a message based upon the subject.