addrbook.php

一个很好的同学录,PHP+TXT,没有数据库的网友的最好选择

<?
session_start();
if(!$_SESSION['power']>0) {$error="你没有登陆或你没有权限";include("inc_error.php");die();}

$title="成员地址簿";
include("inc_head.php");
if(!$_CLASS_CONF) include("conf_class.php");
if(!$_MYSQL_INC) include("conf_mysql.php");
$sql="select ID from mc_member where power>0";
$Myres=mysql_query($sql,$Mylink);
$mem_total=mysql_num_rows($Myres);		//计算班级总人数
echo '
<table align=center border=1 cellpadding=0 cellspacing=0 width=762 bordercolor=#FFFFFF style="border-collapse: collapse">
  <tr>
    <td width=580 bgcolor=#6BBED6 valign="top" align="center">
      <div style="margin:8px;background-color:#FFFFFF;width:560px;text-align:center" >
		  <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=#F9F9EF>
            <tr>
              <td width=180 rowspan=2></td>
              <td width=200 style="border:1px solid #C7C7C3;border-top-width:0;height:24px;background:#F0F3ED;font-size:16px" valign="middle" align="center">'.htmlspecialchars($class_name).'</td>
              <td width=180 rowspan=2></td>
            </tr>
            <tr><td align="center"><img src="images/bt_t07.gif" width=176 height=11></td></tr>
            <tr valign="bottom"><td height=28 colspan=3>　　<img src="images/jiao02.gif" width=9 height=10> 成 员 地 址 簿</td></tr>
            <tr><td height=5 colspan=3 background="images/bj06.gif"></td></tr>
          </table>

          <table width=92% border=0 cellspacing=0 cellpadding=0 style="margin-top:4px;margin-bottom:8px">
            <tr>
              <td width=37%><a href="down_addr.php"><img src="images/b_dc.gif" width=75 height=15></a></td>
              <td width=29% align="right"><a href="personal.php"><img src="images/b_xglxff.gif" width=113 height=15></a></td>
              <td width=34% align="right">班级成员:共 '.$mem_total.' 人</td>
            </tr>
          </table>
          <table width=94% border=0 cellspacing=0 cellpadding=0>
            <tr align="center" bgcolor=#F0ECE6>
              <td width=46 height=36>身份</td>
              <td width=55>姓名</td>
              <td width=83>ID</td>
              <td width=219>邮 件 地 址</td>
              <td width=41>访问<br>
                次数</td>
              <td width=82>上次访问时间</td>
            </tr>
            <tr><td height=1 colspan=6 bgcolor=#6BBED6></td></tr>
';
if($_GET['p']>0) $page=$_GET['p'];
else $page=0;
$sql="select power,name,id,Email,logintimes,lastlogin from mc_member where power>0 order by jointime limit ".($page*$mems_per_page).",".($mems_per_page+1);
$Myres=mysql_query($sql,$Mylink);
$tmp_num=mysql_num_rows($Myres);
$f_pageup=($page?1:0);
$f_pagedown=($tmp_num>$mems_per_page?1:0);
$tmp_i=0;
while($row=mysql_fetch_row($Myres))
{
	
	if($tmp_i==$mems_per_page) break;		//实际查询多一条记录,这多一条不显示...
	if($row[0]==1) $mem_power="成员";
	else if($row[0]==2) $mem_power="管理员";
	else $mem_power="创始人";
	$mem_name=htmlspecialchars($row[1]);
	$mem_id=htmlspecialchars($row[2]);
	$mem_email=$row[3];
	$mem_logintimes=$row[4];
	$mem_lastlogin=$row[5];
	print <<<a_lable1
            <tr align="center">
              <td height=32 class="sf">{$mem_power}</td>
              <td class="xm"><a href="member.php?id={$mem_id}" class="001D7D">{$mem_name}</a></td>
              <td class="xm">{$mem_id}</td>
              <td class="xm"><a href="mailto:{$mem_email}" class="001D7D">{$mem_email}</a></td>
              <td class="cs">{$mem_logintimes}</td>
              <td class="cs">{$mem_lastlogin}</td>
            </tr>
a_lable1;
	$tmp_i++;
}
$page_first=$page*$mems_per_page+1;
if($tmp_num<$mems_per_page) $page_last=$page*$mems_per_page+$tmp_num;
else $page_last=($page+1)*$mems_per_page;
echo '
            <tr>
              <td height=24 colspan=6 align="center" bgcolor=#F0ECE6 style="border-top:1 solid #6BBED6">';
echo "共 {$mem_total} 条，本页是第 {$page_first} 到第 {$page_last} 条记录　  　 ";
if($f_pageup) echo '<a href="addrbook.php?p='.($page-1).'" class="black">上一页</a>　 ';
if($f_pagedown) echo '<a href="addrbook.php?p='.($page+1).'" class="black">下一页</a>';
echo '			  </td>
            </tr>
          </table>
          <p>&nbsp;</p>
      </div>
	</td>
    <td width=184 bgcolor=#E1EFF6 valign="top" align="center">';
include("inc_birth.php");
include("inc_nav.php");
echo '
	</td>
  </tr>
</table>';
include("inc_foot.php");
?>