程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 網頁編程 >> PHP編程 >> PHP綜合 >> PHP編寫學校網站上新生注冊登陸程序的實例分享

PHP編寫學校網站上新生注冊登陸程序的實例分享

編輯:PHP綜合

就弄了三個頁面:

(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="image/school_1.jpg" height="50%" width="60%">
    <marquee behavior="alternate" bgcolor="#FF0000"><b>河南理工大學真誠歡迎2012級新同學到校學習</b></marquee>
    </center>
    <p><center><font color="red" size="6"><b><blink>新生注冊系統</blink></b></font></center></p>
    <form action="mysql_stu.php" method="post" name="reg_stu">
    <table align="center" cellspacing="0" bordercolor="#FFFFFF" width="60%" bordercolorlight="#FFFFFF" border="1" cellpadding="3">
      <tr bgcolor="#CCCCCC">
        <td width="100%" align="center" valign="bottom" height="19" colspan="2">
        <font face="隸書" size="4" color="#000000">請仔細填寫以下內容</font></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19" >姓名:</td>
        <td width="70%"><input type="text" name="reg_name" size="10" maxlength="18" ></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">性別:</td>
        <td width="70%"><input type="radio" name="reg_sex" value="男" checked >男<input type="radio" name="sex" value="女">女</td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">年齡:</td>
        <td width="70%"><input type="text" name="reg_age" size="5" maxlength="15"></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">班級:</td>
        <td width="70%"><input type="text" name="reg_class" size="20"></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">身份證號:</td>
        <td width="70%"><input type="text" name="reg_id" size="20"></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">聯系電話:</td>
        <td width="70%"><input type="text" name="reg_tele" size="20"></td>
      </tr>
      <tr>
        <td width="30%" align="right" height="19">電子郵件:</td>
        <td width="70%"><input type="text" name="reg_email" size="20"></td>
      </tr>
      <tr>
        <td width="100%" align="center" colspan="2"><input type="submit" value="馬上注冊">
        <input type="reset" value="全部重寫"></td>
      </tr>
    </table>
    </form>
    <marquee behavior="scroll">
    <center><img src="image/school2.jpg" height="15%" width="15%">
    <img src="image/lake.jpg" height="15%" width="15%">
    <img src="image/flower.jpg" height="15%" width="15%">
    <img src="image/autumn.jpg"height="16%" width="16%">
    <img src="image/bridge.jpg" height="15%" width="15%">
    <img src="image/beauty.jpeg" height="15%" width="15%">  
    <img src="image/party1.jpeg" height="18%" width="17%">
    <img src="image/party2.jpeg" height="18%" width="18%">
    <img src="image/party3.jpeg" height="18%" width="17%">
    <img src="image/party4.jpeg" height="18%" width="17%">
    </center></marquee>
  </body>
</html>

2016321152141216.jpg (1281×703)

(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">
  <?php
    //連接數據庫;
    $link = mysql_connect('localhost','root','Dongsheng');
    if(!$link)
    {
      echo "與數據庫連接失敗!";
      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);
  ?>
  <font size='6' color="#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>

2016321152226105.jpg (1281×703)

(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">
  <?php
    if($_POST['log_name']=='')
    {
      echo "<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>";
    }
     
  ?>
</body>
</html>

2016321152251020.jpg (1281×703)

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved