就弄了三个页面:
(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> |