杏林同学录(五)

include "config.php";

//询问班级注册问题密码

if ($class){

$headers .= "Content-Type: text/html; charset=gb2312n"; // Mime type

$subject="询问班级注册问题密码 ";//主题

$message=nl2br($message);

$message="查询人：".$name."
留言：
".$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 "我们的数据库中无此用户，请确认。注意大小写。返回";

exit;}

$myemail=mysql_result($result,0,"email");//读取user数据库中的email

if (!$myemail){//如果还没有email,则返回

echo "我们的数据库中没有您的email,请再次填写。返回";

exit;

}

$psw=mysql_result($result,0,"psw");//密码

$name=mysql_result($result,0,"name");//姓名

$subject="询问个人注册密码";

$message=$name."，您好。您的用户名是".$username."，密码是".$psw."。
-----------------------
".$sitename."";//信件内容

$headers .= "Content-Type: text/html; charset=gb2312n"; // Mime type

mail($myemail,$subject,$message,$headers);

echo "恭喜您，系统已经向您的信箱中发出了答复信件,请注意查收email。";

exit;

}

?>

悄悄话：privatenote.php

session_start(); // 开始session

if(!session_is_registered("userregister")||($userregister==""))//检查是否注册,如userregister未注册或session为空值，重新注册.

{

echo "请重新注册
";

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 user where user='$userregister'",$db); $name=mysql_result($result,0,"name");//姓名 echo $name; ?> 的悄悄话

$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<$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," "; echo " 留言内容:",$message," ------",$look_s; echo "删除 "; } } echo "悄悄话总数:",$row,".",$unlook,"条新悄悄话."; ?>

您要给谁发悄悄话？ <select name="yname"> $result = mysql_query("SELECT * FROM user",$db); $row=mysql_num_rows($result);//成员人数 for ($i=0;$i<=($row-1);$i++){ $name=mysql_result($result,$i,'name');//姓名 echo "",$name,""; } mysql_close($db); ?> 留言内容：