CS 602 Server Side development hw5 please explain and comment the following php code Suresh Kalathur part 2 My Course Manager Course Manager Error

CS 602 Server Side development hw5 please explain and comment the following php code

// Get IDs $student_id = filter_input(INPUT_POST, 'student_id', FILTER_VALIDATE_INT); $course_id = filter_input(INPUT_POST, 'course_id');

// Delete the student from the database if ($student_id != false && $course_id != NULL) { $query = 'DELETE FROM sk_students WHERE studentID = :student_id'; $statement = $db->prepare($query); $statement->bindValue(':student_id', $student_id); $success = $statement->execute(); $statement->closeCursor(); }

// Display the Product List page include('index.php');

part 2

Course Manager

Error

© Suresh Kalathur

part 2

Course Manager

Error

© Suresh Kalathur

part 3

// Get all courses $query = 'SELECT * FROM sk_courses ORDER BY courseID'; $statement = $db->prepare($query); $statement->execute(); $courses = $statement->fetchAll(); $statement->closeCursor();

if (!isset($course_id)) {

// Get course ID $course_id = filter_input(INPUT_GET, 'course_id'); if ($course_id == NULL || $course_id == FALSE) { $course_id = $courses[0]['courseID']; } }

// Get name for selected course $queryCourse = 'SELECT * FROM sk_courses WHERE courseID = :course_id'; $statement1 = $db->prepare($queryCourse); $statement1->bindValue(':course_id', $course_id); $statement1->execute(); $course = $statement1->fetch(); $course_name = $course['courseName']; $statement1->closeCursor();

// Get students for selected course $queryStudents = 'SELECT * FROM sk_students WHERE courseID = :course_id ORDER BY studentID'; $statement3 = $db->prepare($queryStudents); $statement3->bindValue(':course_id', $course_id); $statement3->execute(); $students = $statement3->fetchAll(); $statement3->closeCursor(); ?>

Course Manager

Student List

Courses

• ">

First Name	Last Name	Email

Add Student

List Courses

© Suresh Kalathur