当前位置:Gxlcms > PHP教程 > 留言本挑战最棒的留言本的源码(五)

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

时间:2021-07-01 10:21:17 帮助过:46人阅读


留言本





留言信息


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_
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 "

";
?>



免费留言本由小熊提供技术支持



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

以上就介绍了留言本 挑战最棒的留言本的源码(五),包括了留言本方面的内容,希望对PHP教程有兴趣的朋友有所帮助。

人气教程排行