prime.php

这是使用ＰＨＰ编程的虚拟社区ＭySQL的简易版

<?
  include "config.inc.php";
  include "func.php";

function ReadList() {
  global $BBS_TABLE,$PAGE_MAX_LINE;
  global $bbsid,$mainid,$blockid,$mood,$title,$size,$writer,
         $writetime,$read_value,$sub_value,$hot_value;
  global $show,$total,$begin,$end,$count;

  if (!isset($show)) $show=0;

  $SQL="SELECT Count(*) AS total FROM $BBS_TABLE WHERE blockid='$blockid' && bbsprime=1";

  $result=mysql_query($SQL) or die(mysql_error());
  $row=mysql_fetch_Array($result);
  $total=$row[total];

  $begin= ($total>0) ? $show*$PAGE_MAX_LINE+1 : 0;
  $end= ($total>0) ? ($show+1)*$PAGE_MAX_LINE : 0;

  if ($total>0) {
    $SQL="SELECT bbsid,mainid,mood,title,size,writer,writetime,
                 read_value,sub_value,hot_value
          FROM $BBS_TABLE
          WHERE blockid='$blockid' && bbsprime=1
          ORDER BY writetime DESC
          LIMIT $show,$PAGE_MAX_LINE";

    $result=mysql_query($SQL) or die(mysql_error());
    $count=mysql_numrows($result);

    for ($i=0;$i<$count;$i++) {
      $row=mysql_fetch_Array($result);

      $bbsid[$i]=$row[bbsid];
      $mainid[$i]=$row[mainid];
      $mood[$i]=$row[mood];
      $title[$i]=$row[title];
      $size[$i]=$row[size];
      $writer[$i]=$row[writer];
      $writetime[$i]=$row[writetime];
      $read_value[$i]=$row[read_value];
      $sub_value[$i]=$row[sub_value];
      $hot_value[$i]=$row[hot_value];
    }

    if ($total<$PAGE_MAX_LINE) $end=$total;
  }
}


function PrintList() {
  global $mainid,$mood,$title,$writer,$writetime,$size,$read_value,$sub_value,$hot_value;
  global $id,$blockid,$count;

  for ($i=0;$i<$count;$i++) {
    echo "  <TR class=wdBlack>\n";
    echo "    <TD width=8% height=22 bgcolor=white align=center>";
    echo $size[$i];
    echo "</TD>";
    echo "    <TD width=5% height=22 bgcolor=white align=center><IMG src=images/mood".$mood[$i].".gif width=15 height=15></TD>\n";
    echo "    <TD width=60% height=22 bgcolor=white><A href=primeread.php?id=$id&blockid=$blockid&mainid=$mainid[$i]>";
    echo ($title[$i]) ? $title[$i] : "无主题";
    echo "</TD>";
    echo "    <TD width=12% height=22 bgcolor=white><A href=who.php?id=$id&who=".$writer[$i].">".$writer[$i]."</A></TD>\n";
    echo "    <TD width=15% height=22 bgcolor=white align=center>".date("m.d H:i",$writetime[$i])."</TD>\n";
    echo "  </TR>\n";
  }
}

function Page() {
  global $PAGE_MAX_LINE;
  global $id,$blockid,$show,$total;

  $next=$show+$PAGE_MAX_LINE;
  $prev=$show-$PAGE_MAX_LINE;

  if ($prev>=0) echo "　<A href=\"$PHP_SELF?id=$id&blockid=$blockid&show=$prev\"> &lt;&lt; </A>";
  if ($next<$total) echo "　<A href=\"$PHP_SELF?id=$id&blockid=$blockid&show=$next\"> &gt;&gt; </A>";
}

  ReadUserid();
  ReadBlock();
  ReadList();

  include "header.inc.php";
  include "ad.php";
?>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=30%>　　版主： <A href=who.php?who=<? echo $sysop.">".$sysop; ?></A></TD>
    <TD width=40%><FONT color=red><? echo $chinese."( ".$english." ) 精华区"; ?></FONT></TD>
    <TD width=30%> 第 <FONT color=red><? echo $begin; ?></FONT> 篇 - 第 <FONT color=red><? echo $end; ?></FONT> 篇 共 <FONT color=red><? echo $total; ?></FONT> 篇</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=100% size=1>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlue>
    <TD width=70%></TD>
    <TD width=30% align=center>　<? echo Page(); ?>　</TD>
  </TR>
</TABLE>

<TABLE width=98% border=0 class=main cellspacing=2 cellpadding=2 align=center bgcolor=<? echo $BODY_COLOR; ?>>
  <TR class=wdBlack>
    <TD width=8% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>回 应</TD>
    <TD width=5% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=60% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>主　　　　　　　　　　　　题</TD>
    <TD width=12% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>作 者</TD>
    <TD width=15% height=20 bgcolor=<? echo $HEADER_COLOR; ?> align=center>时 间</TD>
  </TR>
<? PrintList(); ?>
  <TR class=wdBlack>
    <TD width=8% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=5% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=60% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=12% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
    <TD width=15% height=20 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
  </TR>
</TABLE>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlue>
    <TD width=70%></TD>
    <TD width=30% align=center>　<? echo Page(); ?>　</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=100% size=1>


<DIV class=wdBlack align=center><? echo $COPYRIGHT; ?></DIV><BR>

</BODY>
</HTML>