/** * 获得特定的Tag列表 * * @param unknown_type $dsql * @param unknown_type $pageno * @param unknown_type $pagesize * @param unknown_type $orderby */ function GetTagList($dsql, $pageno, $pagesize, $orderby = 'aid') { global $cfg_phpurl, $addsql; $start = ($pageno - 1) * $pagesize; $printhead = "<table width='98%' border='0' cellpadding='1' cellspacing='1' align='center' class='tbtitle' style='background:#E2F5BC;margin-bottom:5px;'>\r\n\t\t<tr align='center' bgcolor='#FBFCE2'>\r\n <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('aid')\"><u>ID</u></a></td>\r\n\t\t <td width='20%' class='tbsname'>列表名称</td>\r\n\t\t <td width='20%' class='tbsname'>模板文件</td>\r\n\t\t <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('click')\"><u>点击</u></a></td>\r\n\t\t <td width='15%' class='tbsname'>创建时间</td>\r\n\t\t <td class='tbsname'>管理</td>\r\n \t\t </tr>\r\n"; echo $printhead; $dsql->SetQuery("Select aid,title,templet,click,edtime,namerule,listdir,defaultpage,nodefault From #@__freelist {$addsql} order by {$orderby} desc limit {$start},{$pagesize} "); $dsql->Execute(); while ($row = $dsql->GetArray()) { $listurl = GetFreeListUrl($row['aid'], $row['namerule'], $row['listdir'], $row['defaultpage'], $row['nodefault']); $line = "\r\n\t<tr align='center' bgcolor='#FFFFFF' onMouseMove=\"javascript:this.bgColor='#FCFEDA';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n <td>{$row['aid']}</td>\r\n <td> <a href='{$listurl}' target='_blank'>{$row['title']}</a> </td>\r\n <td> {$row['templet']} </td>\r\n <td> {$row['click']} </td>\r\n <td>" . MyDate("y-m-d", $row['edtime']) . "</td>\r\n <td> <a href='#' onclick='EditNote({$row['aid']})'>更改</a> |\r\n \t<a href='#' onclick='CreateNote({$row['aid']})'>更新</a> |\r\n \t<a href='#' onclick='DelNote({$row['aid']})'>删除</a>\r\n\t</td>\r\n </tr>"; echo $line; } echo "</table>\r\n"; }
function GetTagList($dsql,$pageno,$pagesize,$orderby='aid'){ global $cfg_phpurl,$addsql; $start = ($pageno-1) * $pagesize; $printhead ="<table width='96%' border='0' cellpadding='1' cellspacing='1' align='center' style='margin:0px auto' class='tblist'> <tr align='center'> <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('aid')\"><u>ID</u></a></td> <td width='20%' class='tbsname'>列表名称</td> <td width='20%' class='tbsname'>模板文件</td> <td width='5%' class='tbsname'><a href='#' onclick=\"ReloadPage('click')\"><u>点击</u></a></td> <td width='15%' class='tbsname'>创建时间</td> <td class='tbsname'>管理</td> </tr>\r\n"; echo $printhead; $dsql->SetQuery("Select aid,title,templet,click,edtime,namerule,listdir,defaultpage,nodefault From #@__freelist $addsql order by $orderby desc limit $start,$pagesize "); $dsql->Execute(); while($row = $dsql->GetArray()){ $listurl = GetFreeListUrl($row['aid'],$row['namerule'],$row['listdir'],$row['defaultpage'],$row['nodefault']); $line = " <tr align='center' onMouseMove=\"javascript:this.bgColor='#FCFEDA';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\"> <td>{$row['aid']}</td> <td> <a href='$listurl' target='_blank'>{$row['title']}</a> </td> <td> {$row['templet']} </td> <td> {$row['click']} </td> <td>".strftime("%y-%m-%d",$row['edtime'])."</td> <td> <a href='#' onclick='EditNote({$row['aid']})'>更改</a> | <a href='#' onclick='CreateNote({$row['aid']})'>更新</a> | <a href='#' onclick='DelNote({$row['aid']})'>删除</a> </td> </tr>"; echo $line; } echo "</table>\r\n"; }