Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

What is the dream?

Answered: 1 week ago