| |
|
公众留言板
新增留言
");
while ($row = mysql_fetch_array($result))
{
echo " | 序号:[",$row[0],"] 姓名:[",$row[1],"] 留言类别:[",$row[3],"] 时间:[",$row[4],"]
留言内容:",$row[5]," | ";
if(strlen($row[7])>0)
{ echo "| 回复:",$row[7]," 时间:[",$row[6],"] | ";
}
echo "| | ";
}
mysql_free_result($result);
echo " ";
*/
// 获取当前页数
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
}
// 每页数量
$page_size = 20;
// 获取总数据量
$sql="select count(*) as amount from t_board where showflag='y'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$amount = $row['amount'];
//如果$amount为0就说明没有查到相应的记录
if (0==$amount)
{
exit("没有留言!");
}
// 记算总共有多少页
if( $amount ){
if( $amount < $page_size ){ $page_count = 1; } //如果总数据量小于$PageSize，那么只有一页
if( $amount % $page_size ){ //取总数据量除以每页数的余数
$page_count = (int)($amount / $page_size) + 1; //如果有余数，则页数等于总数据量除以每页数的结果取整再加一
}else{
$page_count = $amount / $page_size; //如果没有余数，则页数等于总数据量除以每页数的结果
}
}
else{
$page_count = 0;
}
// 翻页链接
$page_string = '';
if( $page == 1 ){
$page_string .= '第一页|上一页|';
}
else{
$page_string .= '第一页|上一页|';
}
if( ($page == $page_count) || ($page_count == 0) ){
$page_string .= '下一页|尾页';
}
else{
$page_string .= '下一页|尾页';
}
// 获取数据，以二维数组格式返回结果
if( $amount ){
$sql = "select * from t_board where showflag='y' order by msgtime desc limit ". ($page-1)*$page_size .", $page_size";
$result = mysql_query($sql);
while ( $row = mysql_fetch_array($result) ){
$rowset[] = $row;
}
}else{
$rowset = array();
}
// 没有包含显示结果的代码，那不在讨论范围，只要用foreach就可以很简单的用得到的二维数组来显示结果
$i=0;
foreach ($rowset as $value => $m)
{
echo "";
echo "| 姓名:[",$m[1],"] 留言类别:[",$m[3],"] 留言时间:[",$m[4],"] | ";
echo "留言内容:
",$m[5]," | ";
if(strlen($m[7])>0)
{ echo "回复:
",$m[7]," | ";
echo "| 回复时间:[",$m[6],"] | ";
}
echo " ";
echo "
";
};
mysql_free_result($result);
echo $page_string;
mysql_close($mydb);
?>
|
