PHP编写学校网站上新生注册登陆程序的实例分享

(编辑：jimmy 日期: 2024/10/1 浏览：2)
就弄了三个页面：
（1）、新生信息注册模块(register.php)：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
  <head>
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  <title>班级注册表</title>
  </head>
  <body background="image/bg3.jpg">
    <center><img src="/UploadFiles/2021-04-02/school_1.jpg">



（2）、信息查询登录模块(mysql_stu.php)：



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新生登陆系统</title>
</head>
 
<body background="image/bg1.jpg">
  <"与数据库连接失败！";
      die('Could not connect: ' .mysql_error());
    }
    $createdb="create database if not exists mis_stu";
    $result=mysql_query($createdb)
      or die("<br>数据库创建失败：".mysql_error());
    $result=mysql_select_db(mis_stu)
      or die('选择mis_stu数据库失败:'.mysql_error());
    $createtable="create table if not exists stu_reg (stu_name varchar(30) not null,stu_sex char(2),stu_age int,stu_class varchar(30),stu_id varchar(18),stu_tele varchar(20),stu_email varchar(30))";
    $result=mysql_query($createtable)
      or die('<br>数据表创建失败：'.mysql_error());
    //选择数据库
    mysql_select_db(mis_stu);
    if(!empty($_POST['reg_name']))
    {
      $name=$_POST['reg_name'];
      $sex=$_POST['reg_sex'];
      $age=$_POST['reg_age'];
      $class=$_POST['reg_class'];
      $id=$_POST['reg_id'];
      $tele=$_POST['reg_tele'];
      $email=$_POST['reg_email'];
      //定义插入数据到stu_reg表中的SQL字符串
      mysql_query("set names gb2312");
      $SQL="insert into stu_reg(stu_name,stu_sex,stu_age,stu_class,stu_id,stu_tele,stu_email) values ('$name','$sex','$age','$class','$id','$tele','$email')";
      mysql_query($SQL);
      mysql_query("COMMIT");
      echo "<center><font color='blue' size='10'><b>恭喜您，注册成功！<br>输入以下内容登陆系统查询注册信息</b></font></center>";
    }
    mysql_close($link);
  "#FFFF00">登录前请先<a href="register.php">注册</a></font>
  <p><center><font color="red" size="6"><b>信息查询登录</b></font></center></p>
    <form action="stu_info.php" method="post" name="log_stu">
    <table align="center" cellspacing="0" bordercolor="#FFFFFF" width="60%" bordercolorlight="#FFFFFF" border="1" cellpadding="3">
      <tr bgcolor="#CCCCCF">
        <td width="100%" align="center" valign="bottom" height="19" colspan="2">
        <font face="隶书" size="4" color="#000000">请输入姓名和身份证号</font></td>
      </tr>
      <tr>
        <td width="50%" align="right" height="19" >请输入姓名：</td>
        <td width="70%"><input type="text" name="log_name" size="20"></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">请输入身份证号：</td>
        <td width="70%"><input type="text" name="log_id" size="20"></td>
      <tr>
        <td width="100%" align="center" colspan="2"><input type="submit" value="登录">
        <input type="reset" value="清空"></td>
      </tr>
    </table>
    </form
    <center>
    <p><font face="隶书" size="5" color=red>新生入学需知：<br></font></p>
    <p><font face="隶书" size="5" color="#0033FF"><marquee behavior="scroll" direction="up" height="200" bgcolor="#FFFFCC" width="60%">
    请各位同学先到各个学院完善注册信息，<br>做好报道注册工作，<br>同时按要求完善电子档案信息。
    <br><br>希望广大同学尽快适应新环境，<br>认识新朋友，尽快投入到学习工作当中！<br><br>教务处电话：12345678<br>保卫科电话：87654321</marquee></p></font>
    </center>
</body>
</html>




（3）、查询信息显示模块(stu_info.php)


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>基本信息</title>
</head>
 
<body background="image/bg6.jpg">
  <"<center><font color='blue' size='8'><b>姓名不能为空！请重新输入!<br></b></font></center>";
      echo "<center><font size='6'><a href='mysql_stu.php'>重新登录</font></center>";
    }
    else
    { 
      $link = mysql_connect('localhost','root','Dongsheng');
      if(!$link)
      {
        echo "与数据库连接失败！";
        die('Could not connect: ' .mysql_error());
      }
      $result=mysql_select_db(mis_stu)
        or die('选择mis_stu数据库失败:'.mysql_error());
      mysql_query("set names gb2312");
      $slt=mysql_query("select * from stu_reg");
      $arr=mysql_fetch_assoc($slt);
      $flag=0;
      while($arr)
      {
        if($_POST['log_name']==$arr['stu_name'])
        {
          $flag=1;
          if($_POST['log_id']==$arr['stu_id'])
          {
            echo "<font color='red' size='8'><b>登录成功，您的基本信息为：<br></b></font></center><br>";
            echo "<font size='6'>姓名：".$arr['stu_name']."<br>";
            echo "<font size='6'>性别：".$arr['stu_sex']."<br>";
            echo "<font size='6'>年龄：".$arr['stu_age']."<br>";
            echo "<font size='6'>班级：".$arr['stu_class']."<br>";
            echo "<font size='6'>身份证号：".$arr['stu_id']."<br>";
            echo "<font size='6'>联系电话：".$arr['stu_tele']."<br>";
            echo "<font size='6'>电子邮件：".$arr['stu_email']."<br>";
            break;
          }
          else
          {
            echo "<center><font color='blue' size='8'><b>密码错误！请<a href='mysql_stu.php'>重新输入。<br></b></font></center>";
            break;
          }
        }
        $arr=mysql_fetch_assoc($slt);
      }
      if($flag==0)
        echo "<center><font color='blue' size='8'><b>对不起！您查询的用户不存在，请先返回<a href='register.php'>注册</a><br></b></font></center>";
      mysql_close($link);
      echo "<center><font color='blue' size='6'><a href='mysql_stu.php'>切换用户</a><br></b></font></center>";
    }
     
  "2016321152251020.jpg (1281×703)" src="/UploadFiles/2021-04-02/2016321152251020.jpg">
上一篇：PHP的Laravel框架结合MySQL与Redis数据库的使用部署
下一篇：调用WordPress函数统计文章访问量及PHP原生计数器的实现