jayart

dont know this

BTW thanks for helping.. idk how to use mysqli or PDO as new in php my system is online enrollment system . and i dont know how to apply this code to my code..

sorry, i have code for this but i have an error with "Notice: Undefined index: position in C:\xampp\htdocs\svbm_ernolment_system\login.php on line 20" HERES THE CODE: <?php //Start session session_start(); //Connect to mysql server include('connect.php'); //Function to sanitize values received from the form. Prevents SQL injection function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $login = clean($_POST['id']); $password = clean($_POST['password']); $position = clean($_POST['position']); $result = mysql_query("SELECT * FROM user WHERE idnumber='$login' AND password='$password'"); while($row = mysql_fetch_array($result)) { $position = $row['position']; } if ($position=='admin') { //Create query $qry="SELECT * FROM admin WHERE idnum='$login' AND password='$password'"; $result=mysql_query($qry); //while($row = mysql_fetch_array($result)) // { // $level=$row['position']; // } //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) > 0) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION['SESS_MEMBER_ID'] = $member['id']; session_write_close(); //if ($level="admin"){ header("location: admin/index.php"); exit(); }else { //Login failed header("location: loginform.php"); exit(); } }else { die("Query failed"); } } $result = mysql_query("SELECT * FROM user WHERE idnumber='$login' AND password='$password'"); while($row = mysql_fetch_array($result)) { $position = $row['position']; } if ($position=='student') { //Create query $qry="SELECT * FROM prereg WHERE idnumber='$login' AND password='$password'"; $result=mysql_query($qry); //while($row = mysql_fetch_array($result)) // { // $level=$row['position']; // } //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) > 0) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION['SESS_MEMBER_ID'] = $member['id']; $_SESSION['SESS_FIRST_NAME'] = $member['idnumber']; session_write_close(); //if ($level="admin"){ header("location: student/profile.php"); exit(); }else { //Login failed header("location: loginform.php"); exit(); } }else { die("Query failed"); } } if ($position=='Casher') { //Create query $qry="SELECT * FROM casher WHERE idnumber='$login' AND password='$password'"; $result=mysql_query($qry); //while($row = mysql_fetch_array($result)) // { // $level=$row['position']; // } //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) > 0) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION['SESS_MEMBER_ID'] = $member['id']; $_SESSION['SESS_FIRST_NAME'] = $member['idnumber']; session_write_close(); //if ($level="admin"){ header("location: casher/index.php"); exit(); }else { //Login failed header("location: loginform.php"); exit(); } }else { die("Query failed"); } } if ($position=='teacher') { //Create query $qry="SELECT * FROM teacher WHERE idnumber='$login' AND password='$password'"; $result=mysql_query($qry); //while($row = mysql_fetch_array($result)) // { // $level=$row['position']; // } //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) > 0) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION['SESS_MEMBER_ID'] = $member['id']; $_SESSION['SESS_FIRST_NAME'] = $member['idnumber']; session_write_close(); //if ($level="admin"){ header("location: teacher/index.php"); exit(); }else { //Login failed header("location: loginform.php"); exit(); } }else { die("Query failed"); } } ?>

but how? i mean i need to redirect different page.. im new in php please can you explain?

i want to create login with multiple user level. i have 4 different user (admin,teacher,student,and cashier)/ please?