session_start();
include("conn.php");
if($_GET["do"]=="login"){
if($_POST["name"]&&$_POST["passwd"]&&$_POST["type"]){
$username=$_POST["name"];
$password=$_POST["passwd"];
if($_POST["type"]==2){
$sql="select * from teacher where Tnum='$username'";
if((@mysql_num_rows($query=mysql_query($sql)))>0)
{
$arr=mysql_fetch_array($query);
$password1=$arr["Tpwd"];
if($password==$password1)
{
$_SESSION["type"]="teacher";
$_SESSION["Tname"]=$arr["Tname"];
$_SESSION["Tnum"]=$arr["Tnum"];
//print_r($_SESSION); exit();
echo "";
}else{
echo "";
exit();
}
}else{
echo "";
exit();
}
}else{
$sql="select * from student where Snum='$username'";
if((@mysql_num_rows($query=mysql_query($sql)))>0)
{
$arr=mysql_fetch_array($query);
$password1=$arr["Spwd"];
if($password==$password1)
{
$_SESSION["type"]="student";
foreach($arr as $k=>$v){
$_SESSION[$k]=$v;
}
print_r($_SESSION);
echo "";
}else{
echo "";
exit();
}
}else{
echo "";
exit();
}
}
}else{
echo "";
exit();
}
}
?>
登录用户名:
密 码:
身 份:
学生
教师
取消
?>
数据库已经连接上
展开