$num=mysql_num_rows($result1);
$pagesize=10;
$pages=$num/$pagesize;
$correct=($correctpage<=0)?0:$correctpage;
$correct=($correctpage>$pages)?$correctpage:$pages;
$offset=$correctpage*pagesize;
while(--$offset>0)
$row1=mysql_fect_row($result1);
$i=1;
while($row1=mysql_fetch_array($result1))
{
$data = $row1["bin_data"];
$type = $row1["filetype"];
$filename = $row1["filename"];
$description = $row1["description"];
if($count++>$pagesize)
break;
}
$pagesize=10;
$pages=$num/$pagesize;
$correct=($correctpage<=0)?0:$correctpage;
$correct=($correctpage>$pages)?$correctpage:$pages;
$offset=$correctpage*pagesize;
while(--$offset>0)
$row1=mysql_fect_row($result1);
$i=1;
while($row1=mysql_fetch_array($result1))
{
$data = $row1["bin_data"];
$type = $row1["filetype"];
$filename = $row1["filename"];
$description = $row1["description"];
if($count++>$pagesize)
break;
}
//$row1=mysql_fetch_array($result1);
$numperpage=15;
if($curnum=="")
$curnum=1;
for($i=0;$i<$curnum;$i++)
$row1=mysql_fetch_array($result1);
for($i=0;$i<15;$i++)
{
while(is_array($row1)){
$data = $row1["bin_data"];
$type = $row1["filetype"];
$filename = $row1["filename"];
$description = $row1["description"];
echo $data." ".$type." ".$filename." ".$description."<br>";
$curnum++;
$row1=mysql_fetch_array($result1);
}
}
echo "<br><a href=\"".$PHP_SHEF."?curnum=".$curnum."\">下一页</a>"
$result1= mysql_query("select * from ccs_image where upicid ='$user_id' LIMIT 0, 30");
$row1=mysql_fetch_array($result1);$data = $row1["bin_data"];
$type = $row1["filetype"];
$filename = $row1["filename"];
$description = $row1["description"];
以下是源代码:
<?
require("includes/connection.php");
require("includes/tools.php"); session_save_path("111");
session_start();if(!session_is_registered(user_id) || !session_is_registered(user_name))
{
echo "你的数据系统不能识别,请从新登陆!";
//echo "<meta http-equiv=\"refresh\" content=\"0; url=../default.php\">";
exit();
}
$result1= mysql_query("select * from ccs_image where upicid ='$user_id'");
$row1=mysql_fetch_array($result1);$data = $row1["bin_data"];
$type = $row1["filetype"];
$filename = $row1["filename"];
$description = $row1["description"]; $num=mysql_num_rows($result1);
$pagesize=10;
$pages=$num/$pagesize;
$correct=($correctpage<=0)?0:$correctpage;
$correct=($correctpage>$pages)?$correctpage:$pages;
$offset=$correctpage*pagesize;
while(--$offset>0)
$row1=mysql_fect_row($result1);
$i=1;
while($row1=mysql_fetch_array($result1))
{
echo $data;
//echo $type;
//echo $filename;
//echo $description;
if($count++>$pagesize)
break;
} ?>