📄 list.php
字号:
<?php
function conndb()
{
$db=@mysql_pconnect("localhost","root","307910");
if($db==false)
{
print "Database failed!";
exit();
}
return $db;
}
function get_reply($db,$cata,$id)
{
$res=@mysql_db_query("community","select id,subject,author,issuetime,beenread from essays where cata=$cata and attrib=1 and reply=$id order by issuetime",$db);
$num=@mysql_num_rows($res);
for($i=0;$i<$num;$i++)
{
$row=@mysql_fetch_row($res);
print "!_> <A href=\"content.php?action=read&id=$row[0]\" target=bottom>";
print "row[1]</A> ";
print "-row[2] <I>$row[3]</I> [被访问次数$row[4]]<br>";
}
return $num;
}
$MAXROWS=5;
session_start();
$db=conndb();
?>
<html>
<head>
<title>讨论社区列表</title></head>
<body>
<?
$cata;
if(!strcmp($action,"refrsh"))
{
$cata=$whichboard;
}
if(!isset($username))
{
print "你还末页登录到我们的讨论社区，所有取法查看套路社区内容，点击此<FONT color=#cc0066><b><A href=\"forum.php\" target=\"_parent\">登录</A></b></FONT>!";
}
else if(!strcmp($action,"listuser"))
{
$res=@mysql_db_query("community","select * from onlineusers",$db);
$num=@mysql_num_rows($res);
$pages=ceil($num/$MAXROWS);
$step=($num>$MAXROWS?$MAXROWS:$num);
if($num==0)
{
print "当前没有用户在线!";
}
for($i=0;$i<$step;$i++)
{
$row=@mysql_fetch_row($res);
print "$row[0]$row[1]登录到讨论社区<br>";
}
if($pages>1)
{
print "<A href=\"$PHP_SELF?from=0&total=$num&pages=$pages\" target=top>";
print "首页</A> ";
}
if($pages>2)
{
print "<A href=\"$PHP_SELF?from=0&total=$num&pages=$pages\"";
print "target=top>下一页</A> ";
}
if($pages>=2)
{
print "<A href=\"$PHP_SELF?from=";
print ($num-$num%$MAXROWS)."&total=$num&pages=$pages\" target=top>";
print "末页</A> ";
}
}
else if(isset($from))
{
$step=($total-$from)>$MAXROWS?$MAXROWS:($total-$from);
$res=@mysql_db_query("community","select * from onlineusers limit $from,$step;",$db);
for($i=0;$i<$step;$i++)
{
$row=@mysql_fetch_row($res);
print "$row[0]$row[1]登录到讨论社区<br>";
}
print "<A href=\"$PHP_SELF?from=0&total=$num&pages=$pages\" target=top>";
print "首页</A> ";
if($pages>2&&$from>0)
{
print "<A href=\"$PHP_SELF?from=".($from-$MAXROWS);
print "&total=$total&pages=$pages\" target=top>上一页</A> ";
}
if($from+$MAXROWS<$total)
{
print "<A href=\"$PHP_SELF?from=".($from+$MAXROWS);
print "&total=$total&pages=$pages\" target=top>下一页</A> ";
}
print "<A href=\"$PHP_SELF?from=".($num-$num%$MAXROWS);
print "&total=$num&pages=$pages\" target=top>末页</A> ";
}
else if(!empty($cata))
{
$whichboard=$cata;
session_register("whichboard");
$query="select id,subject,author,issuetime,beenread from essays where cata=$cata and attrib=0 order by issuetime desc";
$res=@mysql_db_query("community",$query,$db);
$num=@mysql_num_rows($res);
if($num==0)
{
print "当前还没有新文章!";
}
else
{
print "<p align=center>讨论区</p>";
for($i=0;$i<$num;$i++)
{
$row=@mysql_fetch_row($res);
print "<A href=\"content.php?action=read&id=$row[0]\"";
print "target=bottom>row[1]</A> ";
print "-row[2] <I>$row[3]</I> [被访问次数$row[4]]<br>";
get_reply($db,$cata,$row[0]);
}
}
}
else
{
?>
请选择一个讨论社区!
<?
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -