guestbook_admin.php

这是matlab的一个小程序

<?php
require_once(dirname(__FILE__)."/config.php");
CheckRank(0,0);
$pagesize = isset($pagesize) && is_numeric($pagesize) ? $pagesize : 5;
$pageno = isset($pageno) && is_numeric($pageno) ? max(1,$pageno) : 1;
if(empty($dopost))
{
	$dopost = '';
}

//重载列表
if($dopost=='getlist')
{
	AjaxHead();
	GetList($dsql,$pageno,$pagesize);
	exit();
}

//删除留言
if($dopost=='del')
{
	if(!empty($aid))
	{
		$aid = intval($aid);
		$dsql->ExecuteNoneQuery("Delete From `#@__member_guestbook` where aid='$aid' And mid='".$cfg_ml->M_ID."'; ");
	}
	else if(!empty($ids))
	{
		$ids = ereg_replace("[^0-9,]",'',$ids);
		if($ids!='')
		{
			$dsql->ExecuteNoneQuery("Delete From `#@__member_guestbook` where aid in($ids) And mid='".$cfg_ml->M_ID."'; ");
		}
	}
	AjaxHead();
	GetList($dsql,$pageno,$pagesize);
	exit();
}

//第一次进入这个页面
if($dopost=='')
{
	$row = $dsql->GetOne("Select count(*) as dd From `#@__member_guestbook` where mid='".$cfg_ml->M_ID."'; ");
	$totalRow = $row['dd'];
	include(dirname(__FILE__)."/templets/guestbook_admin.htm");
}

//获得特定的关键字列表
function GetList($dsql,$pageno,$pagesize)
{
	global $cfg_phpurl,$cfg_ml;
	$pagesize = intval($pagesize);
	$pageno = intval($pageno);
	$start = ($pageno-1) * $pagesize;
	$dsql->SetQuery("Select * From `#@__member_guestbook` where mid='".$cfg_ml->M_ID."' order by aid desc limit $start,$pagesize ");
	$dsql->Execute();
	$line = '';
	while($row = $dsql->GetArray())
	{

		$line .= "<table cellspacing='1' class='list mB10'>
  <thead>
    <tr>
      <th colspan='2' ><strong class='fLeft'>留言标题：".$row['title']."</strong><span class='fRight'>
        <input name=\"ids\" type=\"checkbox\" id=\"ids\" value=\"".$row['aid']."\" />
        <a href='#' onclick='DelNote(".$row['aid'].")'>删除</a></span></th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td width='15%' align='left' valign='top'>用户称呼：".$row['uname']."</td>
      <td>时间：".MyDate("Y-m-d H:i",$row['dtime'])."&nbsp;IP地址：".$row['ip']."&nbsp;";

		if(!empty($row['gid']))
		{
			$line .= " <a href='index.php?uid={$row['gid']}&action=infos' target='_blank'>资料</a> <a href='index.php?uid={$row['gid']}' target='_blank'>空间</a> <a href='index.php?uid={$row['gid']}&action=guestbook' target='_blank'>回复</a> ";
		}
		$line .= "
		</td>
    </tr>
    <tr>
      <td align='left' valign='top'><p>Email：".$row['email']."</p><p>联系电话：".$row['tel']."</p><p>其它：".$row['qq']."</p></td>
      <td align='left' valign='top'>".Text2Html($row['msg'])."</td>
    </tr>
  </tbody>
</table>";

	}
	$line = $line == '' ? '暂无留言' : $line;
	echo $line;
}

?>