wholist.php

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

<?
  include "config.inc.php";

function ReadOnlineUser() {
  global $ONLINE_TABLE,$USER_TABLE;
  global $userid,$nickname,$login_time,$login_ip,$count;

  $SQL="SELECT * FROM $ONLINE_TABLE";

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

  $count=mysql_numrows($result);

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

    $row=mysql_fetch_Array($result);

    $userid[$i]=$row[userid];
    $nickname[$i]=$row[nickname];
    $login_time[$i]=$row[login_time];
    $login_ip[$i]=$row[login_ip];
  }
}


function PrintOnlineUser() {
  global $ONLINE_TABLE;
  global $id,$userid,$nickname,$count;

  $size=$count/4;

  for ($i=0; $i<$size; $i++) {
    echo "<TR>\n";
    for ($j=$i*4; $j<($i+1)*4; $j++) {
      if ($j<$count) {
        echo "<TD width=25% height=24><A href=\"who.php?id=$id&who=".$userid[$j]."\">".$userid[$j]."(".$nickname[$j].")</A></TD>\n";
      } else echo "<TD width=25% height=24>&nbsp;</TD>\n";
    }
    echo "</TR>\n";
  }
}

  ReadOnlineUser();

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

<TABLE width=95% border=0 align=center>
  <TR class=wdBlack>
    <TD width=25%>　<FONT class=wdBlue>●</FONT> 网上邻居</TD>
    <TD width=50%>&nbsp;</TD>
    <TD width=25% align=center></TD>
  </TR>
</TABLE>

<TABLE width=98% border=0 align=center bgcolor=<? echo $HEADER_COLOR; ?>>
  <TR>
    <TD width=84% class=wdBlack></TD>
    <TD width=16% class=wdBlue align=center>　<a href="JavaScript:history.back()">返回</a></TD>
  </TR>
</TABLE>

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

<TABLE width="95%" border="0" cellspacing="1" cellpadding="1" align="center" bgcolor="<? echo $BODY_COLOR; ?>">
  <? PrintOnlineUser(); ?>
</TABLE>

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

<table width=98% border=0 align=center bgcolor=<? echo $HEADER_COLOR; ?>>
  <tr>
    <td width=84% class=wdBlack></td>
    <td width=16% class=wdBlue align=center>　<a href="JavaScript:history.back()">返回</a></td>
  </tr>
</table>

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

</BODY>
</HTML>