Question: PLEASE HELP SOLVE IN PHP CODE THANK YOU Overview: Write a program to allow the user to select a course from the database, and then





PLEASE HELP SOLVE IN PHP CODE THANK YOU
Overview: Write a program to allow the user to select a course from the database, and then print a list of students and grades from that course. The connect string for the database is: mysqli("localhost", "student", "password", "university"). The description of the database is in module 3 page "The 4 Table University Database", and the summary image is posted below, as well as a general outline. The input should be generated by PHP, from the university database: The output should be printed the right,after the user selects a course: Homework 4 BIS 1733 BIS 1523 BIS 2523 BIS 4513 ACC 2013 ACC 3203 ACC 3003 BQA 2113 BQA 3123 FIN 3113 FIN 3123 FIN 4423 MKT 3013 MKT 3933 MKT 4033 MGT 3114 MGT 3213 MGT 3513 Outline: input type='submit' form --right hand column read in radio button (course) build a query, to list all student names, and grades, (2 table query) where taken_course =$ course loop through all students print in table ?> Database Format: DB Layout Keys: - Department table's primary key is dept_code - Student table's primary key is student_id, it has a foreign key (major) that references department. - Courses primary key is course_id, it has a foreign key (dept) that references department - Courses_taken primary key is taken_id, it has 2 foreign keys. Taken_course references coruses, and taken_student references student
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
