<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>
【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】;;;;
标签: