dean_tick_a.php

<?php

/*This PHP file is for if faculty approves ticket */
$student_id = $_POST['student_id'];
$teacher_id = $_POST['faculty_id'];
$course_id = $_POST['course_id'];
$dean_id = 9;

$db_connection = mysqli_connect('localhost', 'root', '', 'university_database');
// Check The Connection
if (!$db_connection) {
    die("Connection Failed: " . mysqli_connect_error());
}
mysqli_select_db($db_connection, "crp");

$q_update_table = "UPDATE ticket_table
SET Current_Status='approved'
WHERE student_id = $student_id AND faculty_id = $teacher_id AND course_number='$course_id'";

$query_run = mysqli_query($db_connection, $q_update_table);
if (!$query_run) {
    echo "Error: " . mysqli_error($db_connection);;
    exit();
}
$q_insert_en = "INSERT INTO enrolls (id, courseid) VALUES ($student_id,'$course_id'/*Course id goes here*/);";
$query_run1 = mysqli_query($db_connection, $q_insert_en);
if (!$query_run1) {
    echo "Error: " . mysqli_error($db_connection);;
    exit();
}
if ($query_run and $query_run1) {
    echo "ticket approved successfully";
}
mysqli_close($db_connection);


?>