当前位置: 首页 > 图文教程 > 网络编程 > PHP > 杏林同学录(七)

PHP
php面向对象全攻略 (十五) 多态的应用
php面向对象全攻略 (十六) 对象的串行化
php面向对象全攻略 (十七) 自动加载类
PHP parse_url 一个好用的函数
PHP 字符串分割和比较
全世界最小的php网页木马一枚 附PHP木马的防范方法
PHP 日期加减的类,很不错
PHP 日期时间函数的高级应用技巧
PHP获取163、gmail、126等邮箱联系人地址【已测试2009.10.10】
Ha0k 0.3 PHP 网页木马修改版
PHP iconv 函数转gb2312的bug解决方法
关于页面优化和伪静态
使用zend studio for eclipse不能激活代码提示功能的解决办法
PHP 身份验证方面的函数
基于OpenCV的PHP图像人脸识别技术
用mysql触发器自动更新memcache的实现代码
php 数学运算验证码实现代码
PHP网站开发方案实例
PHP教程:挖掘细节提升网站性能
搜索引擎技术核心揭密(PHP)

PHP 中的 杏林同学录(七)


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-12   浏览: 103 ::
收藏到网摘: n/a

留言簿部分:
班级成员留言簿: 显示留言:class/notebook/index.php
<?
session_start(); // 开始session
if(!session_is_registered("userregister")||($userregister==""))//检查是否注册,如userregister未注册或session为空值,重新注册.
{
echo "<a href='../index.php'>请重新注册<BR>";
exit;
}
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>留言簿</TITLE>
<style type="text/css">
<!--
.blue9 { font-size: 9pt; color: #0099FF; text-decoration: none}
.black9 { font-size: 9pt; text-decoration: none}
.purple10 { font-size: 10pt; color: #9900FF; text-decoration: none}
.white12 { font-size: 12pt; color: #FFFFFF; text-decoration: none}
a:visited { color: #FFFFFF}
a:link { color: #FFFFFF}
-->
</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<?php
include ("../config.php");
$result = mysql_query("SELECT * FROM notebook",$db);
$row=mysql_num_rows($result);//查看查询结果有多少行
$max=$row; //帖子总数
//设每页显示10篇,可自行设定,$p总页数,$page第几页,$low 从第几行开始读,$x 读取几行
if (!$page){ $page=1;}//$page默认值为1
$p=ceil($max/10);//页数为$max/10的最大整数
$low=10*($page-1);
if($page==$p&&($max%10)<>0){$x=($max%10);} else {$x=10;}//如果是最后一页,且不是10的整倍数,读取$max除以10的余数,否则取10
if($max==0){$x=0;}//如果没有帖子,$x取0
$result = mysql_query("select * from notebook ORDER BY time DESC limit $low,$x",$db);//按照帖子的时间降序查询
?>
<table width="98%" border="0" cellspacing="0" cellpadding="0" height="61">
<tr>
<td height="62" width="34%"><img src="/upload/tech/20091012/20091012013309_92262bf907af914b95a0fc33c3f33bf6.gif" width="224" height="60" border="0"></td>
<td height="62" width="66%">
<div align="center"><img src="/upload/tech/20091012/20091012013310_6c9882bbac1c7093bd25041881277658.gif" width="410" height="60"><img src="/upload/tech/20091012/20091012013310_6f2268bd1d3d3ebaabb04d6b5d099425.gif" width="60" height="60"></div>
</td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="0" height="253" bordercolordark="#FFFFFF" bordercolorlight="#003399" align="center">
<tr>
<td height="250">
<div align="center"></div>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="32" bgcolor="#3366FF">
<tr>
<td width="26%" class="white12" height="23"><a href="../guest.php" class="white12">首页</a>
> 留言簿</td>
<td width="48%" class="white12" height="23">
<?php
echo "帖子总数: ",$max," 第";
for ($n=1;$n<=$p;$n++){
echo "<a href=index.php?page=$n>$n</a> ";
}
echo "页";
?>
</td>
<td width="15%" height="23"><a href="addnote.php"><img src="/upload/tech/20091012/20091012013311_854d9fca60b4bd07f9bb215d59ef5561.gif" width="91" height="21" border="0"></a></td>
<td width="11%" height="23"><a href="delnote.php"><span class="white12">留言管理</span></a></td>
</tr>
</table>
<?php
for ($i=0;$i<=($x-1);$i++) {
$user=mysql_result($result,$i,'user');
$time=mysql_result($result,$i,'time');
$ip=mysql_result($result,$i,'ip');
$title=mysql_result($result,$i,'title');
$nnote=mysql_result($result,$i,'nnote');
$yresult = mysql_query("SELECT * FROM user where user='$user'",$db);//读取成员数据库
$name=mysql_result($yresult,0,'name');
$signature=mysql_result($yresult,0,'signature');//读取个人签名
$email=mysql_result($yresult,0,'email');
$face=mysql_result($yresult,0,'face');
$face='../image/face/icon'.$face;
echo "<table width='100%' border='0' cellspacing='0' cellpadding='0' height=107' bordercolor='#FFFFFF'> <tr bgcolor='#eeeeee'>";
echo "<td width='10%' height='33' bgcolor='#eeeeee' class='blue9'> <img src='/upload/tech/20091012/20091012013311_37bc2f75bf1bcfe8450a1a41c200364c.gif' width='32' height='32'></td>";
echo "<td width='16%' height='33' bgcolor='#eeeeee' class='blue9'>留言人:$name</td>";
echo "<td width='41%' height='33' bgcolor='#eeeeee' class='blue9'>发表于:$time</td>";
echo "<td width='12%' height='33' bgcolor='#eeeeee' class='blue9'><a href='mailto:$email'><img src='/upload/tech/20091012/20091012013312_e46de7e1bcaaced9a54f1e9d0d2f800d.gif' width='16' height='16' border=0></a></td>";
echo "<td width='21%' height='33' class='blue9'><img src='/upload/tech/20091012/20091012013312_32bb90e8976aab5298d5da10fe66f21d.gif' width='13' height='15'> $ip</td> </tr> <tr>";
echo "<td colspan='5' class='purple10' height='33'>标题:$title</td> </tr>";
echo "<tr bgcolor='#ffffff'><td colspan='5' class='black9' height='37'>留言内容:$nnote<BR>----------------------<BR>$signature</td></tr></table>";
}
mysql_close($db);
?>
</td>
</tr>
</table>
</BODY>
</HTML>
添加留言:class/notebook/addnote.php
<?
session_start(); // 开始session
if(!session_is_registered("userregister")||($userregister==""))//检查是否注册,如userregister未注册或session为空值,重新注册.
{
echo "<a href='../index.php'>请重新注册<BR>";
exit;
}
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>添加留言</TITLE>
<style type="text/css">
<!--
.white12 { font-size: 12pt; color: #FFFFFF; text-decoration: none}
-->
</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<table width="98%" border="0" cellspacing="0" cellpadding="0" height="61">
<tr>
<td height="62" width="34%"><img src="/upload/tech/20091012/20091012013309_92262bf907af914b95a0fc33c3f33bf6.gif" width="224" height="60" border="0"></td>
<td height="62" width="66%">
<div align="center"><img src="/upload/tech/20091012/20091012013310_6c9882bbac1c7093bd25041881277658.gif" width="410" height="60"><img src="/upload/tech/20091012/20091012013310_6f2268bd1d3d3ebaabb04d6b5d099425.gif" width="60" height="60"></div>
</td>
</tr>
</table>
<?php
include ("../config.php");
if ($submit){
$time=date("Y年m月d日 H:i:s A");
$ip=$REMOTE_ADDR;//留言人ip地址
$title=strip_tags($top);
$nnote=nl2br(strip_tags($content));//先去掉html标记,再将换行符转成 <br>。
if (!$title||!$nnote){ //检查是否填写完整
echo "对不起,您必须填所有内容!<BR>"."<a href='javascript:history.back()'>返回</a>";
exit; }
//写入数据库
$sql="INSERT INTO notebook (user,time,ip,title,nnote) VALUES ('$userregister','$time','$ip','$title','$nnote')";
$result = mysql_query($sql,$db);
mysql_close($db);
echo "留言成功!";
}
?>
<table width="99%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#3366FF">
<tr bgcolor="#3366FF">
<td width="81%" class="white12" height="26"><a href="../../main.php" class="white12">首页</a>
> <a href="index.php" class="white12">留言簿</a> > 添加留言</td>
<td width="19%" class="white12" height="26"><a href='index.php' class="white12">查看留言</a>
</td>
</tr>
<tr>
<td colspan="2">
<form name="form1" method="post" action="addnote.php">
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center">标题<br>
<input type="text" name="top" size="50">
<br>
内容<br>
<textarea name="content" cols="50" rows="6"></textarea>
<br>
<input type="submit" name="submit" value="确定">
<input type="reset" name="cancel" value="重写">
</div>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<p><a href="main.php?user=<? echo $user?>" class="white12"><br>
</a></p>
</BODY>
</HTML>