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 aprogram 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"). Thedescription of the database is in module 3 page "The 4 Table

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!