杏林同学录(五)

密码查询:class/querypsw.php

1<html>
2<head>
3<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
4<title>询问密码</title>
5</head>
6<body bgcolor="#FFFFFF">   

include "config.php";
//询问班级注册问题密码
if ($class){
$headers .= "Content-Type: text/html; charset=gb2312n"; // Mime type
$subject="询问班级注册问题密码 "; //主题
$message=nl2br($message);
$message="查询人:".$name."<br/>留言:<br/>".$message; //内容
mail($superemail,$subject,$message,$headers);
echo "恭喜您,您的请求已经向管理员发出,近期内请注意查收email。";
exit;
}
//询问个人注册密码
if ($member){
$result = mysql_query("SELECT * FROM user where user='$username'",$db);
if (mysql_num_rows($result)==0){ //若返回列的数目为0,说明无此资料
echo "我们的数据库中无此用户,请确认。注意大小写。<a href="javascript:history.back()">返回</a>";
exit;}
$myemail=mysql_result($result,0,"email");//读取user数据库中的email
if (!$myemail){ //如果还没有email,则返回
echo "我们的数据库中没有您的email,请再次填写。<a href="javascript:history.back()">返回</a>";
exit;
}
$psw=mysql_result($result,0,"psw"); //密码
$name=mysql_result($result,0,"name"); //姓名
$subject="询问个人注册密码";
$message=$name.",您好。您的用户名是".$username.",密码是".$psw."。<br/>-----------------------<br/><a href='".$url."'>".$sitename."</a>"; //信件内容
$headers .= "Content-Type: text/html; charset=gb2312n"; // Mime type
mail($myemail,$subject,$message,$headers);
echo "恭喜您,系统已经向您的信箱中发出了答复信件,请注意查收email。";
exit;
}

 1<table align="center" border="0" cellpadding="0" cellspacing="0" height="286" width="93%">
 2<tr>
 3<td colspan="2" height="75">
 4<div align="center">询问密码<br/>
 5</div>
 6</td>
 7</tr>
 8<tr>
 9<td height="75" width="47%">
10<form action="&lt;? echo $PHP_SELF;?&gt;" method="post" name="form1"><div align="center">询问班级注册问题答案<br/>   
11您的姓名   
12<input name="name" type="text"/>
13<br/>您的留言(写上能证实您身份的简短留言及email地址)   
14<textarea cols="50" name="message" rows="3"></textarea>
15<br/>   
16系统将向班级管理员发送您的请求,是否确认?<br/>
17<input name="class" type="submit" value="确认"/>
18<input name="cancel" type="reset" value="重填"/>
19<br/>
20</div></form>
21</td>
22<td height="75" width="53%">
23<div align="center">
24<form action="&lt;? echo $PHP_SELF;?&gt;" method="post" name="form2">   
25询问个人注册密码<br/>
26<br/>   
27您的用户名(不是姓名)<br/>
28<br/>
29<input name="username" type="text"/>
30<br/>
31<br/>
32<br/>   
33系统将会向您注册的信箱中发发送密码,是否确认?<br/>
34<input name="member" type="submit" value="确认"/>
35<input name="cancel2" type="reset" value="重填"/>
36</form>
37</div>
38</td>
39</tr>
40</table>
41</body>
42</html>

悄悄话:privatenote.php

请重新注册 ```
``` "; exit; } //删除留言 include "config.php"; if ($del=="1"){ mysql_query("delete from privatenote where id='$id'",$db); //以id为删除标志 echo "删除成功!"; } //添加留言 if ($Submit){ $id=time(); //以时间戳为记录号 $time=date("Y年m月d日 h:i:s A");//留言时间 $result = mysql_query("SELECT * FROM user where user='$userregister'",$db); $fromuser=mysql_result($result,0,'name'); //发消息人姓名 $result = mysql_query("SELECT * FROM user where name='$yname'",$db); $touser=mysql_result($result,0,'user'); ; //接受人用户名 $message=nl2br(strip_tags($ynote));//留言内容 mysql_query("INSERT INTO privatenote (id,fromuser,touser,time,message) values ('$id','$fromuser','$touser','$time','$message')",$db); //写入数据库 echo "留言成功!"; } ?> ```悄悄话

的悄悄话

```

$result = mysql_query("SELECT * FROM privatenote where touser='$userregister' ORDER BY time DESC",$db);
$row=mysql_num_rows($result); //悄悄话总数
$unlook=0;
if (!$row==0){
for ($i=0;$i&lt;$row;$i++){
$id=mysql_result($result,$i,'id');//留言id
$fromuser=mysql_result($result,$i,'fromuser');//留言人姓名
$time=mysql_result($result,$i,'time'); //留言时间
$message=mysql_result($result,$i,'message'); //留言内容
$look_s="已看过"; //注释
$look=mysql_result($result,$i,'look'); //是否看过
if ($look=="0"){$unlook++;$look_s="尚未看过";} //计算未看过的悄悄话数目,并改变注释
mysql_query("UPDATE privatenote SET look='1' where id='$id'",$db); //将悄悄话看过状态改为1
echo "第",$i+1,"条 发出人:",$fromuser," 留言时间:",$time,"<br/>";
echo " 留言内容:",$message,"<br/>------",$look_s;
echo "<a href="$PHP_SELF?del=1&amp;id=$id">删除</a><hr/>";
}
}
echo "悄悄话总数:",$row,".",$unlook,"条新悄悄话.";

 1</td>
 2</tr>
 3<tr>
 4<td class="black10" colspan="2">
 5<form action="```
 6 echo $PHP_SELF;
 7```" method="post">
 8<p align="center">您要给谁发悄悄话?   
 9  
10<select name="yname">
11<?   
12$result = mysql_query("SELECT * FROM user",$db);   
13$row=mysql_num_rows($result); //成员人数   
14for ($i=0;$i<=($row-1);$i++){   
15$name=mysql_result($result,$i,'name'); //姓名   
16echo "<option>",$name,"";   
17}   
18mysql_close($db);   
19?&gt;   
20</select>
21<br/>   
22留言内容:<br/>
23<textarea cols="60" name="ynote" rows="6"></textarea>
24<br/>
25<b>
26<input name="Submit" type="submit" value="确认"/>
27</b>
28<input name="cancel" type="reset" value="重写"/>
29</p>
30</form>
31</td>
32</tr>
33</table>
34</body>
35</html>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus