挑戰最棒的留言本的源碼（五）_PHP教程

留言本

留言資訊

require('config.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 '

表中沒有資料!

';}
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 "

";
echo "

"; if ($initial_record!=0) { $t1="initial_record=$prev_index"; $sort="sort_field=$sort_field"; $asc="sort_direction=$sort_direction"; echo ""; echo "<<前 $number_records_to_display 條留言"; } else { echo "|前面沒有留言了"; } echo "

"; $t2=$initial_record+1; echo "本頁顯示第 $t2 到 $next_index 條留言,共$number_of_records條留言"; echo "

"; if ($next_index!=$number_of_records) { $t1="initial_record=$next_index"; $sort="sort_field=$sort_field"; $asc="sort_direction=$sort_direction"; echo " "; echo "後 $number_records_to_display 條留言>>"; } else { echo "後面沒有留言了|"; } echo "

";
echo "

";

?>

[我也要留言]

for ($iindex=0;$iindex<$number_of_records_on_current_page;$iindex++) { $record=mysql_fetch_object($result); require('display.inc'); } ?>

echo "

";
echo "

"; 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 ""; echo "[ $ii ]"; } else echo "[ $ii ]"; } echo "頁 共 $number_of_pages 頁"; echo "

";
echo "

";

?>

免費留言本由小熊提供支援人員






【本文著作權歸作者與奧索網共同擁有，如需轉載，請註明作者及出處】

http://www.bkjia.com/PHPjc/316159.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/316159.htmlTechArticlehtml 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: 9...

