时间: 2021-07-31 作者:daque
<html> <title>留言本</title> <body bgcolor=white> <head> <meta http-equiv="content-type" content="text/html; charset=utf8"> <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> 【正文版权归作家与奥索网共通具有,如需连载,请证明作家及根源】