Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started