我想应该是这里错了~~ $sql="select * from".$DQPI_DBTABLE["dqpi"]["user"]."where xuehao='$user_id' and password='$password')"; 得到的结果大概是这样的~select * fromXXXwhere xuehao='$user_id' and password='$password')注意XXX 那里~~还有后面的")"应该改成:$sql="select * from ".$DQPI_DBTABLE["dqpi"]["user"]." where xuehao='$user_id' and password='$password'";just try it~~
to hodat(华帝) 谢谢你的细心,我改过了!但结果与当初一样!唉!
<?php session_start(); require_once("common.inc.php"); if ($number!=$_SESSION[login_check_num])//此处为验证码 echo "验证码错误,请正确输入验证码"; if ($user_id==""||$password==""){ msginfo("错误","请输入学号或密码"); $user_id=trim($sx_xuehao); $password=password(trim($password),$user_id); // 核对会员登陆 $sql="select * from ".$DQPI_DBTABLE["dqpi"]["user"]." where xuehao='$user_id' and password='$password'"; $result = $DbLink->query($sql); $member_data = $DbLink->fetch_array($result); // 当成功登陆时生成SESSION,然后跳转页面 if($member_data) { /*第二版将对此做升级,自动登录模块 if($auto_login) { makedqpiSessionID($member_data[no]); } */ // 4.0xSESSION处理 $dqpi_logged_id = $member_data[xuehao]; $dqpi_logged_name=$member_data[username]; $dqpi_logged_password=$member_data[password]; $dqpi_logged_time = time(); $dqpi_logged_ip = $_SERVER['REMOTE_ADDR']; //注册SESSION变量 session_register("dqpi_logged_id"); session_register("dqpi_logged_name"); session_register("dqpi_logged_password"); session_register("dqpi_logged_time"); session_register("dqpi_logged_ip"); //写入在线学生数据表 $sql = "SELECT * FROM ".$DQPI_DBTABLE["dqpi"]["online"]." WHERE userid = '$dqpi_logged_id'"; $result=$DbLink->query($sql);
if ($result){ //学生不正常退出处理 $sql = "UPDATE ".$DQPI_DBTABLE['dqpi']['online']." SET userid='$dqpi_logged_id',shenfeng='student',username='$dqpi_logged_name',time='".time()."',page='".$PHP_SELF."' WHERE userid='$dqpi_logged_id'"; }else { $sql = "INSERT INTO ".$DQPI_DBTABLE["dqpi"]["online"]." (userid,shenfen,username,ip,time,page) VALUES ('$dqpi_logged_id','student','$dqpi_logged_name','$dqpi_logged_ip','".time()."','".$_SERVER['PHP_SELF']."')"; } $DbLink->query($sql); $sql = 'DELETE FROM ". $DQPI_DBTABLE['dqpi']['online']." WHERE ABS('.time().'-time)>600'; $DbLink->query($sql); // 登陆后跳转页面 header("location:viewsys.php"); } }else{ echo "<script>history.go(-2);</script>"; } ?>你看看这样行不行~~
<?php session_start(); require_once("common.inc.php"); if ($number!=$_SESSION[login_check_num]){//此处为验证码 echo "验证码错误,请正确输入验证码"; echo "<script>history.go(-2);</script>"; exit; }else{ if ($user_id==""||$password==""){ msginfo("错误","请输入学号或密码"); }else{ $user_id=trim($sx_xuehao); $password=password(trim($password),$user_id);
我把注册session的地方改在
session_register("dqpi");
$_SESSION['dqpi'][logged_id]=$dqpi_logged_id;
....
但还是不行啊:(
嗨!我现在还郁闷呢!!
得到的结果大概是这样的~select * fromXXXwhere xuehao='$user_id' and password='$password')注意XXX 那里~~还有后面的")"应该改成:$sql="select * from ".$DQPI_DBTABLE["dqpi"]["user"]." where xuehao='$user_id' and password='$password'";just try it~~
谢谢你的细心,我改过了!但结果与当初一样!唉!
session_start();
require_once("common.inc.php");
if ($number!=$_SESSION[login_check_num])//此处为验证码
echo "验证码错误,请正确输入验证码";
if ($user_id==""||$password==""){
msginfo("错误","请输入学号或密码");
$user_id=trim($sx_xuehao);
$password=password(trim($password),$user_id); // 核对会员登陆
$sql="select * from ".$DQPI_DBTABLE["dqpi"]["user"]." where xuehao='$user_id' and password='$password'";
$result = $DbLink->query($sql);
$member_data = $DbLink->fetch_array($result);
// 当成功登陆时生成SESSION,然后跳转页面
if($member_data) {
/*第二版将对此做升级,自动登录模块
if($auto_login) {
makedqpiSessionID($member_data[no]); }
*/
// 4.0xSESSION处理
$dqpi_logged_id = $member_data[xuehao];
$dqpi_logged_name=$member_data[username];
$dqpi_logged_password=$member_data[password];
$dqpi_logged_time = time();
$dqpi_logged_ip = $_SERVER['REMOTE_ADDR'];
//注册SESSION变量
session_register("dqpi_logged_id");
session_register("dqpi_logged_name");
session_register("dqpi_logged_password");
session_register("dqpi_logged_time");
session_register("dqpi_logged_ip");
//写入在线学生数据表
$sql = "SELECT * FROM ".$DQPI_DBTABLE["dqpi"]["online"]." WHERE userid = '$dqpi_logged_id'";
$result=$DbLink->query($sql);
if ($result){ //学生不正常退出处理
$sql = "UPDATE ".$DQPI_DBTABLE['dqpi']['online']." SET userid='$dqpi_logged_id',shenfeng='student',username='$dqpi_logged_name',time='".time()."',page='".$PHP_SELF."' WHERE userid='$dqpi_logged_id'";
}else {
$sql = "INSERT INTO ".$DQPI_DBTABLE["dqpi"]["online"]." (userid,shenfen,username,ip,time,page) VALUES ('$dqpi_logged_id','student','$dqpi_logged_name','$dqpi_logged_ip','".time()."','".$_SERVER['PHP_SELF']."')";
}
$DbLink->query($sql);
$sql = 'DELETE FROM ". $DQPI_DBTABLE['dqpi']['online']." WHERE ABS('.time().'-time)>600';
$DbLink->query($sql);
// 登陆后跳转页面
header("location:viewsys.php");
}
}else{
echo "<script>history.go(-2);</script>";
}
?>你看看这样行不行~~
session_start();
require_once("common.inc.php");
if ($number!=$_SESSION[login_check_num]){//此处为验证码
echo "验证码错误,请正确输入验证码";
echo "<script>history.go(-2);</script>";
exit;
}else{
if ($user_id==""||$password==""){
msginfo("错误","请输入学号或密码");
}else{
$user_id=trim($sx_xuehao);
$password=password(trim($password),$user_id);
// 核对会员登陆
$sql="select * from ".$DQPI_DBTABLE["dqpi"]["user"]." where xuehao='$user_id' and password='$password'";
$result = $DbLink->query($sql);
$member_data = $DbLink->fetch_array($result);
// 当成功登陆时生成SESSION,然后跳转页面
if($member_data) {
/*第二版将对此做升级,自动登录模块
if($auto_login) {
makedqpiSessionID($member_data[no]); }
*/
// 4.0xSESSION处理
$dqpi_logged_id = $member_data[xuehao];
$dqpi_logged_name=$member_data[username];
$dqpi_logged_password=$member_data[password];
$dqpi_logged_time = time();
$dqpi_logged_ip = $_SERVER['REMOTE_ADDR'];
//注册SESSION变量
session_register("dqpi_logged_id");
session_register("dqpi_logged_name");
session_register("dqpi_logged_password");
session_register("dqpi_logged_time");
session_register("dqpi_logged_ip");
//写入在线学生数据表
$sql = "SELECT * FROM ".$DQPI_DBTABLE["dqpi"]["online"]." WHERE userid = '$dqpi_logged_id'";
$result=$DbLink->query($sql);
if ($result){ //学生不正常退出处理
$sql = "UPDATE ".$DQPI_DBTABLE['dqpi']['online']." SET userid='$dqpi_logged_id',shenfeng='student',username='$dqpi_logged_name',time='".time()."',page='".$PHP_SELF."' WHERE userid='$dqpi_logged_id'";
}else {
$sql = "INSERT INTO ".$DQPI_DBTABLE["dqpi"]["online"]." (userid,shenfen,username,ip,time,page) VALUES ('$dqpi_logged_id','student','$dqpi_logged_name','$dqpi_logged_ip','".time()."','".$_SERVER['PHP_SELF']."')";
}
$DbLink->query($sql);
$sql = 'DELETE FROM ". $DQPI_DBTABLE['dqpi']['online']." WHERE ABS('.time().'-time)>600';
$DbLink->query($sql);
// 登陆后跳转页面
header("location:viewsys.php");
}
}
}
?>
代码:http://218.8.220.207/faqsys/code1.php