网络编程 
首页 > 网络编程 > 浏览文章

文章推荐系统(三)

(编辑:jimmy 日期: 2024/11/18 浏览:3 次 )
=====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);
  ?>

                                                      (待续)  

上一篇:多重條件組合查詢(二)
下一篇:多重條件組合查詢(一)