Question: Develop a simple Web application that generates, from the database shown in the appendix, a simplified student transcript given his user name and password. The


Develop a simple Web application that generates, from the database shown in the appendix, a simplified student transcript given his user name and password. The site consists of three (3) modules, you name: login.php, register.php and generate.php In the login.php you just validate that the student has entered a username and a password. If valid redirect the user to the generate.php by clicking on the link Generate Report Otherwise notify the user that the username and password are required. 2. n the generate.php, do the following Check whether the student is registered (use query Q1). If not, direct the student to register.php by clicking on Registration Page Otherwise: Generate the transcript using query Q2 Format the output in a table as shown in Figure 2. Compute the average gpa from the database, using the query Q3 Update the student's gpa n the table students setting it with the grade defined in query Q3 Query Q1: check (with un an pw) if the student who attempts to login is registered Query Q2: generate the transcript for the logged student from transcript where un xxx (where 'xxx' is the username of the logged student and grade is the output of query) Query Q4: update the logged student setting the gpa to grade login.php
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
