Question: Create a table in a database Create two forms Create separate header and footer files Create a separate style sheet Create a separate connection script

Create a table in a database

Create two forms

Create separate header and footer files

Create a separate style sheet

Create a separate connection script

Form 1: Input form

Form 1 inputs data into the table you created.

Form 1 must contain at least four input fields. It may contain more.

At least one of those input fields must be a dropdown box with at least three choices.

All other input fields must have form handling validation. At the very least you must check to see that fields are neither empty nor null. Users should not be able to submit a form with empty or null fields. More sophisticated validation is optional.

Form 1 must have a header and footer. These files must be called separately.

Form 1 must call a separate database connection script.

Form 1 must be formatted via a separate style sheet.

Form 2: Output form

Form 2 outputs all data from the table you created.

Form 2 must output at least four database fields. It may output more.

Form 2 must have a header and footer. These files must be called separately.

Form 2 must call a separate database connection script.

Form 2 must be formatted via a separate style sheet.

Attachment (Extra Credit!) For extra credit add this functionality to Forms 1 and 2

Table: Include a column that will receive either an attached document or an image.

Form 1: Allow the user to upload either a document or an image into the table you created.

Form 2: Output the attachment.

Optional: Intermediate Webpage

If you chose to process either of your forms through an intermediate webpage, that page must also call header and footer files separately. This page must also be formatted via a separate style sheet.

Not Optional: These Forms MUST work

Your forms must work. They must be functional. I have to be able to see form 1 enter data into a database. Subsequently, I have to see form 2 retrieve that same data from the database, format it and present it on a webpage

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!