Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a PHP webpage that lets the user select from these available reports to be run. On display of each report, the user should be

Create a PHP webpage that lets the user select from these available reports to be run. On display of each report, the user should be able to return to the main page to run another report.

-- Region Month Report: Let the user select a Region and a month/year. Show the total attendance by Chapter for each Chapter in the Region that month. (Total attendance should be the sum of columns "pr" through "others". It should not include groups 1, 2, 3.)

-- Chapter Report: Let the user select a Chapter. Show the total attendance for that Chapter each month/year available in the database.

(The Database is built from the following query)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

create table ch_attended ( seqnum int not null primary key, region int, month int, year int, chapter char(4), pr int, vp1 int, vp2 int, tr int, atr int, se int, ase int, cm1 int, cm2 int, cm3 int, cm4 int, cm5 int, cm6 int, cm7 int, cm8 int, others int, group1 int, group2 int, group3 int );

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

More Books

Students also viewed these Databases questions

Question

What are oxidation and reduction reactions? Explain with examples

Answered: 1 week ago