📄 newbooks2.php
字号:
<html><head><title>欢迎光临</title>
<meta content="text/html;charset=gb2312" http-equiv=Content-Type></head>
<?
require("index.html.inc");
?>
<body bgcolor="#FFFFFF">
<table border=1 width="100%" bgcolor=#8cc9ec cellspacing=1 cellpadding=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>
</tbody></table></td>
<td width="80%">
<table border=0 width="100%" height="100%" bgcolor=#FFFFFF>
<tbody>
<?
$MAXROWS=15;
function conndb()
{
$db=@mysql_pconnect("localhost","root","307910");
if($db==false)
{
print "Database failed!";
exit();
}
return $db;
}
$db=conndb();
$date=mktime(0,0,0,date("m")-1,date("d"),date("Y"));
//$query="select isdn,title,author from books where class>$class and class<($class+1000) and UNIX_TIMESTAMP(publishday)>$date order by publishday";
$query="select isdn,title,author from books where class>$class and class<($class+1000)";
//echo "好的,就执行到这个地方!";////////////////////////////////////////////////////////
if(!isset($from))
{
echo "好的,就执行到这个地方!";////////////////////////////////////////////////////////
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
$num=@mysql_num_rows($res);
$step=($num>$MAXROWS)?$MAXROWS:$num;
if($step<=$MAXROWS)
$total=$num;
print "本页显示 0-".(($step-1)>0?($step-1):0)."(总有 $total 本)";
$query="$query limit 0,$step";
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
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></td><td>$row[2]</td></tr>";
}
print "<tr><td align=center colspan=2>";
print "<a href=\"$PHP_SELF?class=$class&from=0";
print "&total=$num\">首页</A>";
if($num<=$MAXROWS)
{
print "<FONT size=2>(仅一页)</FONT>";
}
else if($num<=(2*$MAXROWS))
{
print " <a href=\"$PHP_SELF?class=$class&";
print "from=$MAXROWS&total=$num\">";
print "末页</A>";
}
else
{
print " <a href=\"$PHP_SELF?class=$class&";
print "from=$MAXROWS&total=$num\">";
print "下一页</A>";
print " <a href=\"$PHP_SELF?from=";
print ($num-$num%$MAXROWS)."&total=$num\">末页</A>";
}
print "</td></tr>";
}
else
{
$step=$total-$from;
$step=($step>$MAXROWS)?$MAXROWS:$step;
$query="$query limit $from,$step";
$res=@mysql_query("set names 'gb2312'");/////////////////////////////////////////////////
$res=@mysql_db_query("bookseller",$query,$db);
print "本页显示 $from-".($from+$step-1);
print "(总有 $total 本)";
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></td><td>$row[2]</td></tr>";
}
print "<tr><td align=center colspan=2>";
print "<a href=\"$PHP_SELF?class=$class&from=0";
print "&total=$num\">首页</A>";
if($from>(2*$MAXROWS))
{
print " <a href=\"$PHP_SELF?class=$class&from=";
print ($from-$MAXROWS)."&total=$total\">上一页</A>";
}
else///////////////////////人为添加
{
print " <a href=\"$PHP_SELF?class=$class&from=";
print ($from+$MAXROWS)."&total=$total\">下一页</A>";
print " <a href=\"$PHP_SELF?from=";
print ($from-$from%$MAXROWS)."&total=$total\">末页</A>";
}
if($num<=(2*$MAXROWS))
{
print " <a href=\"$PHP_SELF?class=$class&";
print "from=$MAXROWS&total=$num\">末页</A>";
}
else
{
print " <a href=\"$PHP_SELF?class=$class&from=";
print ($num+$MAXROWS)."&total=$total\">下一页</A>";
print " <a href=\"$PHP_SELF?from=";
print ($num-$num%$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 + -