就弄了三个页面：
（1）、新生信息注册模块(register.php)：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<!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>
|
（2）、信息查询登录模块(mysql_stu.php)：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
<!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>
|
（3）、查询信息显示模块(stu_info.php)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<!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>
|
