文章推荐系统(三)
2018-09-07 13:56
  =====Article.php==== 
<? 
 if(!isset($pagenum)){ 
$pagenum=1;} 
 $conn=mysql_connect("localhost","user","password"); 
 mysql_select_db("bamboo"); 
 $sql="select count(*) from article"; 
 $result=mysql_query($sql,$conn); 
 $count=mysql_result($result,0); 
 $sign=0; 
 $lesssign=0; 
 $pagec=1; 
for($icount=0;($icount<$count)&&($sign=0);$icount+=16){ 
for($i=0;$i<=16;$i++){ 
if(($icount*16+$i)==$count) 
$sign=1; 
} 
$pagec++; 
} 
$dispeof=16*$pagenum; 
$dispend=16*($pagenum-1); 
if($count>=(16*$pagenum)) 
$dispbeg=16*$pagenum; 
else 
$dispbeg=$count; 
$isdispnum=$count-$dispeof; 
if($isdispnum<0){ 
$lesssign=1; 
} 
echo"<table width=100%>"; 
$fuhao="◇"; 
$color=e9eae9; 
$iscolor=0; 
$lessnum=0; 
for($i=$dispbeg;$i>$dispend;$i--){ 
$sql="select *from article where id=$i"; 
$result=mysql_query($sql,$conn); 
echo"<tr><td align=left bgcolor=$color>"; 
echo $fuhao; 
echo"<a href=articledisp.php?article_id=$i>"; 
$obj=mysql_fetch_object($result); 
echo $obj->articlename; 
echo"</a></td></tr>"; 
$lessnum++; 
if($iscolor==0){ 
$color=ffffff; 
$iscolor=1; 
} 
else{ 
$color=e9eae9; 
$iscolor=0; 
} 
} 
if($lesssign==1){ 
for($iless=$lessnum;$iless<=16;$iless++){ 
echo"<tr bgcolor=$color><td>"; 
echo $fuhao."<br>n"; 
echo"</td></tr>"; 
if($iscolor==0){ 
$color=ffffff; 
$iscolor=1; 
} 
else{ 
$color=e9eae9; 
$iscolor=0; 
} 
} 
} 
echo"</table>"; 
?> 
</td> 
</tr> 
</table> 
<? 
echo"<table width=100% bgcolor=00ff00>"; 
$str="共有"; 
$str=$str.strval($pagec); 
$str=$str."页"; 
echo"<tr><td>$str"; 
echo"</td>"; 
echo"<td align=center>"; 
$str="当前页是第"; 
$str=$str.strval($pagenum); 
$str=$str."页"; 
echo $str; 
echo"</td>"; 
echo"<td>"; 
echo"转到第"; 
for($i=1;$i<=$pagec;$i++){ 
$strpage=" "; 
$strpage=$strpage.strval($i); 
$strpage=$strpage." "; 
echo"<a href=articlcont.php?pagenum=$i>$strpage</a>"; 
} 
echo"页"; 
echo"</td>"; 
echo"</tr>"; 
echo"</table>"; 
mysql_close($conn); 
?> 
(待续)