当前位置: 首页 > 图文教程 > 网络编程 > PHP > 挑战最棒的留言本的源码(五)

PHP
一贴学会PHP 新手入门教程
用PHP的ob_start() 控制您的浏览器cache
谈谈新手如何学习PHP 默默经典版本
黑夜路人出的几道php笔试题
一些 PHP 管理系统程序中的后门
用php获取本周,上周,本月,上月,本季度日期的代码
PHP 简单数组排序实现代码
PHP 多维数组排序实现代码
php 全局变量范围分析
php_xmlhttp 乱码问题解决方法
PHP 数组学习排序全接触
php Sql Server连接失败问题及解决办法
PHP 翻页 实例代码
php 随机数的产生、页面跳转、件读写、文件重命名、switch语句
PHP 5.3.0 安装分析心得
php 生成WML页面方法详解
php 取得瑞年与平年的天数的代码
php empty函数 使用说明
php natsort内核函数浅析
PHP 源代码分析 Zend HashTable详解

PHP 中的 挑战最棒的留言本的源码(五)


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

<html>
<title>留言本</title>
<body bgcolor=white>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
td { font-family: "宋体", "serif"; font-size: 9pt; font-weight: normal}
a:link { text-decoration: none}
a:hover { color: #999999}
a:visited { text-decoration: none; font-weight: normal}
body { font-family: "宋体", "serif"; font-size: 11pt}
tr { font-family: "宋体", "serif"; font-size: 11pt}
.unnamed1 { font-size: 9pt; font-weight: bold}
.p9 { font-family: "宋体"; font-size: 11pt}
.unnamed2 { font-size: 11pt}
-->
</style>
</head>
<h1><center><font color="green" size=7>留言信息</font></center></h1>
<?php
require('config.php');
?>

<?php

$initial_record=0;
$sort_field='key_liuyan';
$sort_direction='DESC';
if (strlen($arr_request['initial_record']))
{
$initial_record=$arr_request['initial_record'];
$sort_field=$arr_request['sort_field'];
$sort_direction=$arr_request['sort_direction'];
}

$str_sql_all="select count(*) as number_of_records from $table_name ";
$result=mysql_db_query($db_name,$str_sql_all,$id_link);
if (!result)
{ affy_error_exit('SQL select execution has failed.');}
$record=@mysql_fetch_object($result);
$number_of_records=$record->number_of_records;
if (strlen($sort_field)==0)
{
$str_sql="select * from $table_name
limit $initial_record,$number_records_to_display ";
}
else
{
$str_sql="select * from $table_name order by $sort_field $sort_direction
limit $initial_record,$number_records_to_display ";
}

$result=mysql_db_query($db_name,$str_sql,$id_link);
if (!$result)
{ affy_error_exit('SQL select execution has failed.');}
$number_of_records_on_current_page=@mysql_num_rows($result);
if ($number_of_records<1)
{ echo '<p>表中没有数据!<p>';}
else
{
$next_index=$initial_record+$number_records_to_display;
if ($next_index>$number_of_records)
$next_index=$number_of_records;

$prev_index=$initial_record-$number_records_to_display;
if ($prev_index<0)
{
$prev_index=0;
}

}
echo "<center>";
echo "<table border=0><tr bgcolor=#f1f1f1><td width=24% align=left>";
if ($initial_record!=0)
{
$t1="initial_record=$prev_index";
$sort="sort_field=$sort_field";
$asc="sort_direction=$sort_direction";
echo "<a href="$PHP_SELF?$asc&$sort&$t1 ">";
echo "<<前 $number_records_to_display 条留言</a>";
}
else
{
echo "|前面没有留言了";
}
echo "</td><td width=52% align=center>";
$t2=$initial_record+1;
echo "本页显示第 <font color=green>$t2</font> 到 <font color=green>$next_index</font>
条留言,共<font color=blue>$number_of_records</font>条留言";
echo "</td><td width=24% align=right>";
if ($next_index!=$number_of_records)
{
$t1="initial_record=$next_index";
$sort="sort_field=$sort_field";
$asc="sort_direction=$sort_direction";
echo " <a href="$PHP_SELF?$asc&$sort&$t1 ">";
echo "后 $number_records_to_display 条留言>></a>";
}
else
{
echo "后面没有留言了|";
}
echo "</td></tr></table>";
echo "</center><p>";
?>
<center>
<a href=index.html><h4>[我也要留言]</h4></a>
<p>
<table border="0",width="95%" cellspacing="0" cellpadding="0">
<?php
for ($iindex=0;$iindex<$number_of_records_on_current_page;$iindex++)
{
$record=mysql_fetch_object($result);
require('display.inc');
}
?>
</table>
</center>
<p>
<?php
echo "<center>";
echo "<table border=0><tr><td>";
echo "转到第";
if (($number_of_records % $number_records_to_display)==0)
{
$number_of_pages=$number_of_records / $number_records_to_display;

}
else
{
$number_of_pages=($number_of_records-($number_of_records % $number_records_to_display))/$number_records_to_display+1;
}

$sort="sort_field=$sort_field";
$asc="sort_direction=$sort_direction";

for ($ii=1;$ii<=$number_of_pages;$ii++)
{
$yeshu=($ii-1)*$number_records_to_display ;
$t1="initial_record=$yeshu ";
if ($initial_record!=$yeshu)
{
echo "<a href="$PHP_SELF?$asc&$sort&$t1 ">";
echo "[ $ii ]</a>";
}
else
echo "[ $ii ]";

}






echo "页 共<font color=blue> $number_of_pages </font>页";
echo "</td></tr></table>";
echo "</center><p>";
?>
<hr></hr>
<center>免费留言本由<a href="http://little.oso.com.cn" >小熊</a>提供技术支持</center>

</body>
</html>

【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】