📄 sitelist.php
字号:
<?require("functions.php");$ROWPERPAGE=25;$subid=isset($subid)?$subid:1;$page=isset($page)?$page:1;$conn=DBConnect();$sql="select id from links_users where sitesubtype=$subid";$sitesnum=mysql_num_rows(mysql_query($sql,$conn));$pages=floor($sitesnum/$GLOBALS["ROWPERPAGE"])+1;function showlist(){ global $conn,$page,$pages,$subid,$ROWPERPAGE; //$sql="update links_users set cpd=counter/(TO_DAYS(NOW())-TO_DAYS(signupday))"; //mysql_query($sql,$conn); $sql="select id,sitename,siteurl,siteintro,counter,signupday,cpd from links_users where sitesubtype="; $sql=$sql.$subid." order by cpd DESC"; $sql=$sql." LIMIT ".(($page-1)*$ROWPERPAGE).", ".$ROWPERPAGE; //echo $sql; $result=mysql_query($sql,$conn); //$now=getdate(); //$nowtime=mktime(0,0,0,$now["mon"],$now["mday"],$now["year"]); $bgclr[0]="#e8e8e8"; $bgclr[1]="#ffffff"; $i=($page-1)*$ROWPERPAGE+1; echo "<br>\n"; echo "<table align=right border=0 cellpadding=0 cellspacing=1 width=95%>\n"; echo "<tr bgcolor=".$bgclr[0].">\n"; echo "<td align=middle width=30>名次</td>\n"; echo "<td align=middle width=125>网站名称</td>\n"; echo "<td align=middle>站点简介</td>\n"; echo "<td align=middle width=50>日均</td>\n"; echo "<td width=70></td>\n"; echo "</tr>\n"; //echo $sql; while($obj=mysql_fetch_object($result)){ //$tmp=explode("-",$obj->signupday); //$signuptime=mktime(0,0,0,$tmp[1],$tmp[2],$tmp[0]); //$countperday=round($obj->counter/($nowtime-$signuptime)*60*60*24); echo "<tr bgcolor=".$bgclr[$i%2].">\n"; echo "<td align=middle>".$i."</td>\n"; echo "<td><a href=".$LINKS_URL."click.php?from=1&to=".$obj->id." target=_blank>".$obj->sitename."</a></td>\n"; echo "<td>".$obj->siteintro."</td>\n"; echo "<td align=center>".$obj->cpd."</td>\n"; echo "<td align=middle><a href=\"javascript:window.external.AddFavorite('".$obj->siteurl."','".$obj->sitename."')\">加入收藏夹</a> </td>\n"; echo "</tr>\n"; $i++; } echo "<tr><td colspan=5>\n \n</td></tr>\n"; echo "<tr><td colspan=5 align=right>\n"; if($page!=1){ echo "<a href=".$GLOBALS["PHP_SELF"]."?subid=".$subid."&page=1>首页</a>\n"; echo "<a href=".$GLOBALS["PHP_SELF"]."?subid=".$subid."&page=".($page-1)."><<</a>\n"; } else{ echo"首页\n"; echo "<<\n"; } for($i=1;$i<=$pages;$i++){ if($i==$page){ echo $i."\n"; } else{ echo "<a href=".$GLOBALS["PHP_SELF"]."?subid=".$subid."&page=".$i.">".$i."</a>\n"; } } if($page!=$pages){ echo "<a href=".$GLOBALS["PHP_SELF"]."?subid=".$subid."&page=".($page+1).">>></a>\n"; echo "<a href=".$GLOBALS["PHP_SELF"]."?subid=".$subid."&page=".$pages.">尾页</a>\n"; } else{ echo ">>\n"; echo"尾页\n"; } echo "</td></tr>\n"; echo "</table>\n";}?><html><head><title>"<?echo $SITE_TITLE;?></title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><link rel="stylesheet" href="cssset.css"></head><body bgcolor="#FFFFFF" text="#000000" link="#000000" vlink="#000000" alink="#000000" leftmargin="5" topmargin="0" marginwidth="5" marginheight="0"><table border=0 cellpadding=0 cellspacing=0 width="100%"> <tbody> <tr> <td colspan="3"><?include("setup/pg_head.php");?> </td> </tr> <tr> <td bgcolor=#6699FF height=8 valign=top width="18%"> </td> <td bgcolor=#6699FF height=8><font color="#ffffff">welcome</font></td> <td bgcolor=#6699FF height=8 valign=top width="18%"> </td> </tr> <tr> <td background=table_bg.gif height="380" width="20%" valign="top"><?MakeMenu(-2);?> </td> <td align=middle valign=top colspan="2"><?showlist();?> </td> </tr> <tr> <td colspan="3"><?include("setup/pg_foot.php");?> </td> </tr> </tbody></table></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -