自己的低手 给朋友改代码 改烂了
代码如下
<? include "config.php"; ?>
<?php
include "config.php";
$conn = mysql_connect("localhost","$DB_User","$DB_Pass");
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
//设定每一页显示的记录数
$pagesize=20;
mysql_select_db("$DB_Name", $conn);
//取得记录总数$rs,计算总页数用
$rs=mysql_query("select count(*) from offers",$conn);
$myrow = mysql_fetch_array($rs);
$numrows=$myrow[0];
//计算总页数 $pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
$pages++;
//设置页数
if (isset($_GET[@#page@#])){
$page=intval($_GET[@#page@#]);
}
else{
//设置为第一页
$page=1;
}
//计算记录偏移量
$offset=$pagesize*($page - 1);
//读取指定记录数
$rs=mysql_query("select * from offers order by id desc limit $offset,$pagesize",$conn);
if ($myrow = mysql_fetch_array($rs))
{
$i=0;
?>
<table border="1" bordercolor="#238E37" width="500" bgcolor="white">
<tr>
<td>ID</td>
<td>Title</td>
<td>Description</td>
<td><a href="offers-payout.php"><font color="red">Payout</font></a></td>
<td>Complete</td>
</tr>
<?php
do {
$i++;
$url = $myrow['URL'];
eval("\$ida = \"$url\";");
echo "<tr>";
echo "<td>";
echo "<a href='info.php?oid=";
echo $myrow['id'];
echo "' target='_blank'>";
echo $myrow['id'];
echo "</a>";
echo "</td><td>";
echo "<a href='";
echo $ida;
echo "' target='_blank'>";
echo $myrow['Title'];
echo "</a></td><td>";
echo $myrow['Description'];
echo "</td><td>";
echo $myrow['price'];
echo "</td><td>";
include "before.php";
echo $myrow['id'];
include "after.php";
echo "</td></tr>";
}
while ($myrow = mysql_fetch_array($rs));
echo "</table>";
}
echo "<div align=@#center@#>共有".$pages."页(".$page."/".$pages.")";
for ($i=1;$i< $page;$i++)
echo "<a href=@#ofers.php?page=".$i."@#>[".$i ."]</a> ";
echo "[".$page."]";
for ($i=$page+1;$i<=$pages;$i++)
echo "<a href=@#ofers.php?page=".$i."@#>[".$i ."]</a> ";
echo "</div>";
?>
</table>
错误很多 请斧正
代码如下
<? include "config.php"; ?>
<?php
include "config.php";
$conn = mysql_connect("localhost","$DB_User","$DB_Pass");
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
//设定每一页显示的记录数
$pagesize=20;
mysql_select_db("$DB_Name", $conn);
//取得记录总数$rs,计算总页数用
$rs=mysql_query("select count(*) from offers",$conn);
$myrow = mysql_fetch_array($rs);
$numrows=$myrow[0];
//计算总页数 $pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
$pages++;
//设置页数
if (isset($_GET[@#page@#])){
$page=intval($_GET[@#page@#]);
}
else{
//设置为第一页
$page=1;
}
//计算记录偏移量
$offset=$pagesize*($page - 1);
//读取指定记录数
$rs=mysql_query("select * from offers order by id desc limit $offset,$pagesize",$conn);
if ($myrow = mysql_fetch_array($rs))
{
$i=0;
?>
<table border="1" bordercolor="#238E37" width="500" bgcolor="white">
<tr>
<td>ID</td>
<td>Title</td>
<td>Description</td>
<td><a href="offers-payout.php"><font color="red">Payout</font></a></td>
<td>Complete</td>
</tr>
<?php
do {
$i++;
$url = $myrow['URL'];
eval("\$ida = \"$url\";");
echo "<tr>";
echo "<td>";
echo "<a href='info.php?oid=";
echo $myrow['id'];
echo "' target='_blank'>";
echo $myrow['id'];
echo "</a>";
echo "</td><td>";
echo "<a href='";
echo $ida;
echo "' target='_blank'>";
echo $myrow['Title'];
echo "</a></td><td>";
echo $myrow['Description'];
echo "</td><td>";
echo $myrow['price'];
echo "</td><td>";
include "before.php";
echo $myrow['id'];
include "after.php";
echo "</td></tr>";
}
while ($myrow = mysql_fetch_array($rs));
echo "</table>";
}
echo "<div align=@#center@#>共有".$pages."页(".$page."/".$pages.")";
for ($i=1;$i< $page;$i++)
echo "<a href=@#ofers.php?page=".$i."@#>[".$i ."]</a> ";
echo "[".$page."]";
for ($i=$page+1;$i<=$pages;$i++)
echo "<a href=@#ofers.php?page=".$i."@#>[".$i ."]</a> ";
echo "</div>";
?>
</table>
错误很多 请斧正
$nextint=ceil(3.14);
echo $nextint;
?>
原因我不做解释,请在分页的时候注意下就OK了在使用limit的时候,应该使用 "limit ".($page-1)*$maxcount.",".$page*$maxcount;//page是页数,maxcount是每一页最大显示数量你的用法也许是没有错的。但是不如这个效率高吧?其他的问题……没有测试,所以不是非常清楚了