<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php'); 
include ($path.'include/class_display.php'); 
$CLASS['db']   = new db();
$CLASS['db']->connect(); 
$CLASS['disp']   = new display();
$db   = $CLASS['db']; 
$disp   = $CLASS['disp']; 

$user_login = $_REQUEST['user_login'];
$pass_login = $_REQUEST['pass_login'];
$tb_act_class = $_REQUEST['tb_act_class'];

$sql_chk = "SELECT * FROM tb_students INNER JOIN tb_rooms ON tb_students.tb_student_degree = tb_rooms.tb_room_id where tb_student_status='1' and  tb_student_code='".$user_login."' and tb_room_class='".$tb_act_class."' ";

$result_chk = $db->query($sql_chk);
$num_chk = $db->num_rows($result_chk);
if($num_chk <='0'){
?>
<script language="javascript">window.alert('Login Fail !!!');</script>
<script language="javascript">window.location.href = 'stu_login.php'</script>
<?php
}else{
session_start(); 

$rec = $db->fetch_array($result_chk);
$_SESSION['sessionuser_id'] = $rec['tb_student_id'];
$_SESSION['sessionuser_code'] = $rec['tb_student_code'];
$_SESSION['sessionuser_tname'] = $rec['tb_student_tname'];
$_SESSION['sessionuser_name'] = $rec['tb_student_name'];
$_SESSION['sessionuser_sname'] = $rec['tb_student_sname'];
$_SESSION['sessionuser_degree'] = $rec['tb_student_degree'];
$_SESSION['sessionuser_class'] = $_REQUEST['tb_act_class'];

?>
<script language="javascript">window.alert('Lgin Success');</script>
<script language="javascript">window.location.href = 'display_student.php'</script>
<?php
}
?>