📄 tops.php
字号:
<html>
<head>
<title>排行榜</title>
</head>
<?
$MAXROWS=15;
require("index.html.inc");
?>
<body bgcolor="#FFFFFF">
<table border=1 width="100%" bgcolor=#8cc9ec cellpadding=1 cellspacing=1>
<tbody>
<tr>
<td width="20%">
<table border=0 width="100%">
<tbody>
<tr>
<td align=center>.<A href=
<?
print "$PHP_SELF?class=1000";
?>
><FONT class=font6>医生排行榜</FONT></A></td>
</tr>
<tr>
<td align=center>.<A href=
<?
print "$PHP_SELF?class=2000";
?>
><FONT class=font6>护士排行榜</FONT></A></td>
</tr>
<tr><td align=center>.<A href=
<?
print "$PHP_SELF?class=3000";
?>
><FONT class=font6>医疗器械排行榜</FONT></A></td>
</tr>
<tr><td align=center>.<A href=
<?
print "$PHP_SELF?class=4000";
?>
><FONT class=font6>床位排行榜</FONT></A></td>
</tr>
<tr>
<td align=center>.<A href=
<?
print "$PHP_SELF?class=5000";
?>
><FONT class=font6>医药销售排行榜</FONT></A></td>
</tr>
<tr><td align=center>.<A href=
<?
print "$PHP_SELF?class=6000";
?>
><FONT class=font6>领导排行榜</FONT></A></td>
</tr>
<tr>
<td align=center>.<A href=
<?
print "$PHP_SELF?class=top100";
?>
><FONT class=font6>...排行榜</FONT></A></td>
</tr>
</tbody></table></td>
<td width="80%">
<table border=1 align=center width="80%" height="100%" bgcolor=#8cc9ec>
<tbody>
<?
function conndb()
{
$db=@mysql_pconnect("localhost","root","307910");
if($db==false)
{
print "Database failed!";
exit();
}
return $db;
}
$db=conndb();
print "<FONT class=font6>销量前";
if(isset($class)&&($class/1000!=0))
{
$up=$class+1000;
$query="select isdn,title,author from books where class>$class and class<$up order by sell limit 10";
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
$num=@mysql_num_rows($res);
print "10 名</FONT>";
if($num==0)
{
print "<tr><td>NO such information!\n";
}
else
{
for($i=0;$i<$num;$i++)
{
$row=@mysql_fetch_row($res);
print "<tr><td><A href=\"detail.php?isdn=$row[0]\">";
print "$row[1]</A><td>$row[2]</td></tr>\n";
}
}
}
else
{
print "100 名</FONT>";
if(!isset($from))
{
$query="select isdn,title,author from books order by sell limit 100";
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
$num=@mysql_num_rows($res);
$step=($num>$MAXROWS)?$MAXROWS:$num;
$query="select isdn,title,author from books order by sell limit 0,$step";
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
print "显示记录 0 - ". ($step-1) ."( 总有 ".( ($num<100)?$num:100 ). ")\n";
for($i=0;$i<@mysql_num_rows($res);$i++)
{
$row=@mysql_fetch_row($res);
print "<tr><td><A href=\"detail.php?isdn=$row[0]\">";
print "$row[1]</A><td>";
print "$row[2]</td></tr>\n";
}
print "<tr><td align=center colspan=2><A href=\"$PHP_SELF?from=0";
print "&total=$num\">首页</A>";
if($num<$MAXROWS)
{
print "<FONT size=2>(仅一页)</FONT>";
}
else if($num<=(2*$MAXROWS))
{
print " <A href=\"$PHP_SELF?from=$MAXROWS";
print "&total=$num\">末页</A>";
}
else
{
print " <A href=\"$PHP_SELF?from=$MAXROWS";
print "&total=$num\">下一页</A>";
print " <A href=\"$PHP_SELF?from=";
print ($num-$num%$MAXROWS)."&total=$num\">末页</A>";
}
}
else
{
$step=($total-$from)>$MAXROWS?$MAXROWS:($total-$from);
$query="select isdn,title,author from books order by sell limit $from,$step";
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
print "Showing records $from-".($from+$step-1)."(total $total)\n";
for($i=0;$i<$step;$i++)
{
$row=@mysql_fetch_row($res);
print "<tr><td><A href=\"detail.php?isdn=$row[0]\">";
print "$row[1]</A>";
print "<td>$row[2]</td></tr>\n";
}
print "<tr><td align=center colspan=2>";
print "<A href=\"$PHP_SELF?from=0&total=$total\">首页</A>";
if($from>$MAXROWS)
{
print " <A href=\"$PHP_SELF?from=";
print ($from-$MAXROWS)."&total=$total\">上一页</A>";
}
if(($from+$MAXROWS)<$total)
{
print " <A href=\"$PHP_SELF?from=";
print ($from+$MAXROWS)."&total=$total\">下一页</A>";
}
print " <A href=\"$PHP_SELF?from=";
print ($total-$total%$MAXROWS)."&total=$total\">末页</A>";
print "</td></tr>";
}
}
?>
</tbody></table></td>
</tr></tbody></table>
</body>
<?
require("foot.html.inc");
?>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -