📄 login.php

📁 这是使用ＰＨＰ编程的虚拟社区ＭySQL的简易版
💻 PHP
字号:
<?
  include "config.inc.php";


//  密码验证
function ReadPassword($userid) {
  global $USER_TABLE;

  $SQL="SELECT password FROM $USER_TABLE WHERE userid='$userid'";

  $result=mysql_query($SQL) or die(mysql_error());
  $row=mysql_fetch_Array($result);

  return($row[password]);
}


//  更新在线资料
function AddOnline() {
  global $USER_ATTR_TABLE,$ONLINE_TABLE,$REMOTE_ADDR,$REFRESH_TIME;
  global $id,$userid,$nickname,$sex,$email,$sign,$old_time,$login_time,$login_ip;

  $login_time=time();
  $old_time=$login_time;

  $login_ip=$REMOTE_ADDR;

  $SQL="DELETE FROM $ONLINE_TABLE WHERE userid='$userid'";

  mysql_query($SQL) or die(mysql_error());

  $id=$login_time;

  $SQL="INSERT INTO $ONLINE_TABLE (
          id,userid,nickname,sex,email,sign,old_time,login_time,login_ip
        ) VALUES (
          '$id','$userid','$nickname','$sex','$email','$sign','$old_time','$login_time','$login_ip'
        )";

  mysql_query($SQL) or die(mysql_error());
}


function UpdateUserAttr() {
  global $USER_ATTR_TABLE,$LIFE_VALUE;
  global $id,$userid,$login_time,$login_ip;

  $SQL="SELECT * FROM $USER_ATTR_TABLE WHERE userid='$userid'";

  $result=mysql_query($SQL) or die(mysql_error());
  $row=mysql_fetch_Array($result);

  $count=$row[count];
  $exper_cent=$row[exper_cent];
  $act_cent=$row[act_cent];
  $life_cent=$row[life_cent];

  $status=1;                               //  当前状态 - 在线
  $count++;                                //  上站次数 +1
  $exper_cent++;                           //  经验值 +1
  $act_cent+=5;                            //  表现值 +5

  if ($exper_cent>=50) $level=1;
  if ($exper_cent>=200) $level=2;
  if ($exper_cent>=300) $level=3;
  if ($exper_cent>=600) $level=4;
  if ($exper_cent>=900) $level=5;
  if ($exper_cent>=1000) $level=6;

  if ($life_cent<$LIFE_VALUE) $life_cent++;        //  生命值低于300 则 +1

  if (!$row[last_time]) {
    $SQL="UPDATE $USER_ATTR_TABLE SET
            count='$count',level='$level',exper_cent='$exper_cent',
            act_cent='$act_cent',life_cent='$life_cent',
            last_time='$login_time',last_ip='$login_ip'
          WHERE userid='$userid'";
  } else {
    $SQL="UPDATE $USER_ATTR_TABLE SET
            count='$count',level='$level',exper_cent='$exper_cent',
            act_cent='$act_cent',life_cent='$life_cent'
          WHERE userid='$userid'";
  }

  $result=mysql_query($SQL) or die(mysql_error());
}


function CheckUserid($userid) {
  global $USER_TABLE;
  global $nickname,$sex,$email,$sign;

  $SQL="SELECT * FROM $USER_TABLE WHERE userid='$userid'";

  $result=mysql_query($SQL) or die(mysql_error());

  $row=mysql_fetch_Array($result);

  $nickname=$row[nickname];
  $sex=$row[sex];
  $email=$row[email];
  $sign=$row[sign];
  if (!$row[userid]) return "error!";
}


if (($Ok) or ($Pass)) {
  //  用 户 名 不 能 为 空
  if (!$userid) $err=0;

  //  用 户 名 不 存 在
  if ((!isset($err)) and CheckUserid($userid)) $err=7;

  if ($Ok) {  //  请 输 入 您 的 密 码
    if ((!isset($err)) and (!$password)) $err=3;

  //  密 码 不 正 确
    if (!isset($err)) {
      $p=ReadPassword($userid);
      if ($password!=$p) $err=8;
    }
  }

  if (!isset($err)) {
    //  更新在线资料
    if ($Ok) {
      AddOnline();
      UpdateUserAttr();
      header("Location: club.php?id=$id\n");
    } else header("Location: pass.php?userid=$userid\n");
  } else {
    //  失败页面
    header("Location: error.php?code=$err\n");
  }
  exit;
}

  include "header.inc.php";
  include "ad.php";
?>

<BODY leftmargin=0 topmargin=0>

<FORM METHOD="POST" ACTION="<? echo $PHP_SELF; ?>">
  <TABLE width=60% border=0 cellpadding=0 cellspacing=0 align=center bgcolor=<? echo $BODY_COLOR; ?>>
    <TR class=wdBlack bgcolor=<? echo $HEADER_COLOR; ?>>
      <TD height=20>&nbsp;</td>
    </TR>
    <TR class=wdBlack>
      <TD height=50 align=center>用户名：
        <INPUT type=text name=userid size=16 maxlength=16 class=wdBlack value="rain">
      </TD>
    </TR>
    <TR class=wdBlack>
      <TD height=30 width=18% align=center>密　码：
        <INPUT type=password name=password size=16 maxlength=16 class=wdBlack value="1234">
      </TD>
    </TR>
    <TR class=wdBlack>
      <TD height=50 align=center>
        <INPUT type=submit name=Ok value="登录" class=Black>
        <INPUT type=button name=Apply value="申请" class=Black onClick="JavaScript: location.href='apply.php'; return ture">
        <INPUT type=button name=Demo value="游客" class=Black onClick="JavaScript: location.href='club.php'; return ture">
        <INPUT type=submit name=Pass value="忘记密码" class=Black>
      </TD>
    </TR>
  </TABLE>
</FORM>

<DIV class=wdBlack align=center><? echo $COPYRIGHT; ?></DIV><BR>

</BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -