PK ! W±óQ¿ ¿ index.phpnu „[µü¤ PK ! ècqÈ È submit_leave.phpnu ßú¥ÿ query("SELECT * FROM students WHERE user_id=$uid")->fetch_assoc();
$ip= isset($_POST['informed_parents'])?'Yes':'No';
$q="INSERT INTO leave_requests(student_id,student_name,standard,class,roll_no,phone,subject,reason,start_date,end_date,informed_parents,apply_date,status)
VALUES(
'{$s['student_id']}','{$s['name']}','{$s['standard']}','{$s['class']}','{$s['roll_no']}','{$s['phone']}',
'{$_POST['subject']}','{$_POST['reason']}','{$_POST['start_date']}','{$_POST['end_date']}','$ip','{$_POST['apply_date']}','Pending')";
$conn->query($q);
header("Location: dashboard.php");
?>PK ! Lv¯Ev v leave_form.phpnu ßú¥ÿ query("SELECT * FROM students WHERE user_id=$uid")->fetch_assoc();
?>
Leave Application
PK ! ã„Q
dashboard.phpnu ßú¥ÿ query("SELECT * FROM leave_requests WHERE student_id IN (SELECT student_id FROM students WHERE user_id=$user_id) ORDER BY id DESC");
?>