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

PHP
php 清除网页病毒的方法
php 远程关机操作的代码
Zend Studio for Eclipse的java.lang.NullPointerException错误的解决方法
PHP 出现乱码和Sessions验证问题的解决方法！
php2html php生成静态页函数
中英文字符串翻转函数
php escape URL编码
PHP Google的translate API代码
php 文件状态缓存带来的问题
linux下 C语言对 php 扩展
php mssql 数据库分页SQL语句
php IP及IP段进行访问限制的代码
PHP 采集程序 常用函数
php 设计模式之 单例模式
php 设计模式之 工厂模式
php xml-rpc远程调用
php 获取完整url地址
PHP MSSQL 存储过程的方法
PDP Document 代码注释规范
PHP HTML代码串截取代码

No. « 117 118 119 120 »

技术文章搜索

关键字

PHP 中的 杏林同学录(七)

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-10-12   浏览: 189 ::
收藏到网摘: 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>