老大帮忙看看我的代码分不了页
<html>
<head>
<title>123456</title>
</head>
<style>
body,td,tr,a{
font-family:Arial, Helvetica, sans-serif;
font-size:10px;
font-style:normal;
color: #3A5576;
text-decoration: none;
}
</style>
<body background="../images/bg.gif" topmargin="0" bottommargin="0">
<table border="0" width="760" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../images/gallery/uback.gif" width="100%" height="28" border="0"></td>
<td width="760" background="../images/gallery/uback.gif" align="center" border="0"><FONT SIZE="4" COLOR="#FF0000"><B>图库欣赏</B></FONT></td>
<td><img src="../images/gallery/uback.gif" width="100%" height="28" border="0"></td>
</tr>
</TABLE>
<TABLE border="0" align="center" width="760" cellpadding="0" cellspacing="0">
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" valign="top">
<?
//.....[基本设定].....
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "123456";
$mysql_database = "xp";
//.......
if (empty($mypage))
{
$mypage=0;
}
//select*from qf_upfic order by id desc limit $mypage,5
//select*from qf_link order by id desc limit $mypage,5
// SQL语法 (查询,显示)
$sql = "INSERT INTO `qf_upfic` ( `id` , `upfilename` , `title` , `submit` , `ip` , `time_at` ) VALUES (NULL , '$upfilename', '$title', '$submit', '$ip', NOW()) limit $mypage,5";
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password);
$result=mysql_db_query($mysql_database, $sql, $conn );
//while($row=mysql_fetch_row($result));
?>
<?php
$dir_file = "files/";
$dir = opendir($dir_file);
$mypage = 1;
while($file = readdir($dir)){
if($file == '.' || $file == '..' || $file == 'Thumbs.db' || $file == 'index.php') continue;
//echo "<img src=\"".$dir_file."/".$file."\"><br>";
echo "<a href=\"".$dir_file."/".$file."\" target=\"_blank\">$file</a><br>";
$mypage++;
if($mypage>5) break;
}
closedir($dir);
echo "<HR>";
?>
</TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" valign="top">
<?php
if (empty($mypage))
{
//$mypage=0;
}
$pagepic=5;//每页显示的页数
if(isset($_GET[mypage])){
$mypage=intval($_GET[mypage]);
}
else{
$mypage=1;
}
$start=($mypage-1)*$pagepic;//确定起始行
$myquery_total="select id from qf_upfic ";
$myquery="INSERT INTO `qf_upfic` ( `id` , `upfilename` , `title` , `submit` , `ip` , `time_at` ) VALUES (NULL , '$upfilename', '$title', '$submit', '$ip', NOW()) limit $mypage,5";
$result=mysql_query($myquery);
$total_rows=mysql_num_rows(mysql_query($myquery_total));
$maxpage=ceil($total_rows/$pagepic);
// ceil :计算大于指定数的最小整数。
echo "共计<font SIZE=\"4\" color=\"#ff0000\">$total_rows</font>"; ?>张图片 第<?php echo "<font SIZE=\"4\" color=\"#ff0000\">$mypage</font>"; ?>页 共<?php echo "<font SIZE=\"4\" color=\"#ff0000\">$maxpage</font>"; ?>页 <a href="index.php?mypage=1"> 第一页</a> <a href="index.php?mypage=<?php if($mypage>1){echo ($mypage-1);}else{echo "1";} ?>"> 上一页</a> <a href="index.php?mypage=<?php if($mypage<$maxpage){echo ($mypage+1);}else{echo $maxpage;} ?>"> 下一页</a> <a href="index.php?mypage=<?php echo $maxpage; ?>"> 最后页</a>
</TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" valign="top">
</TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" valign="top">
</TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" ><a href="../upfiles/input.php" target="_blank" title=""><font face=宋体 color="#ff0000" size="4px"><b>我要上传</b></A></font></TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" ><a href="../index.php" target="_blank" title=""><font face=宋体 size="4px"> www.xxx.com </A></font></TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" ><a href="../gbook/" target="_blank" title=""><font size="2px">对本站有任何建议、意见或投诉，请点这里在线联系我们！</font></A></TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" >
</TD>
</TR>
<TR>
<TD border="0" align="center" width="100%" bgcolor="#ABC0E7" > </TD>
</TR>
</TABLE>
</body>
</html>
