4. Write a PHP script task4.php that connects to the database and displays the results of the query in Task 1 as an ordered list. 5. Write another PHP script named task5.php to show in a table the results of the query in Task 2. 6. Create a PHP script named task6.php that retrieves details of each user, i.e. the user ID, full name and student status. The output page should contain an HTML form which has a drop-down list input and a submit button. The drop-down list input should contain the results retrieved from the database. When a specific user is selected from the drop-down list, the user ID is submitted via the GET method to another PHP script named task7.php (to be created in Task 7). 7. Create a PHP script named task7.php that accepts the user ID submitted from task6.php and then displays the information about the given user in an appropriate format. You should make use of the queries in Tasks 3 to do the following two tasks: For only each class booked by the given user, itshould show the class (i) ID and course, the instructor and start time of each timeslot and the reservation. (ii) and the user's total number of reservations on each class as well. Only if the given user is a student, it should also show the class ID
4. Write a PHP script task4.php that connects to the database and displays the results of the query in Task 1 as an ordered list. 5. Write another PHP script named task5.php to show in a table the results of the query in Task 2. 6. Create a PHP script named task6.php that retrieves details of each user, i.e. the user ID, full name and student status. The output page should contain an HTML form which has a drop-down list input and a submit button. The drop-down list input should contain the results retrieved from the database. When a specific user is selected from the drop-down list, the user ID is submitted via the GET method to another PHP script named task7.php (to be created in Task 7). 7. Create a PHP script named task7.php that accepts the user ID submitted from task6.php and then displays the information about the given user in an appropriate format. You should make use of the queries in Tasks 3 to do the following two tasks: For only each class booked by the given user, itshould show the class (i) ID and course, the instructor and start time of each timeslot and the reservation. (ii) and the user's total number of reservations on each class as well. Only if the given user is a student, it should also show the class ID
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Transcribed Image Text:4. Write a PHP script task4.php that connects to the database and displays the
results of the query in Task 1 as an ordered list.
5. Write another PHP script named task5.php to show in a table the results of the
query in Task 2.
6. Create a PHP script named task6.php that retrieves details of each user, i.e. the
user ID, full name and student status. The output page should contain an HTML form
which has a drop-down list input and a submit button. The drop-down list input should
contain the results retrieved from the database. When a specific user is selected from
the drop-down list, the user ID is submitted via the GET method to
another PHP script named task7.php (to be created in Task 7).
7. Create a PHP script named task7.php that accepts the user ID submitted from
task6.php and then displays the information about the given user in an appropriate
format. You should make use of the queries in Tasks 3 to do the following two tasks:
For only each class booked by the given user, itshould show the class
(i)
ID and course, the instructor and start time of each timeslot and the reservation.
(ii)
and the user's total number of reservations on each class as well.
Only if the given user is a student, it should also show the class ID
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY