prefix("addr_book")." order by name";
//PageBar(資料數, 每頁顯示幾筆資料, 最多顯示幾頁);
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, _MD_ADDR_CANT_GET."
{$sql}");
$total=$xoopsDB->getRowsNum($result);
$navbar = new PageBar($total, $xoopsModuleConfig['show_num'], 10);
$mybar = $navbar->makeBar();
$bar= sprintf(_MD_PAGE_BAR,$mybar['total'],$mybar['current'],$mybar['left'].$mybar['center'].$mybar['right']);
$sql.=$mybar['sql'];
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, _MD_ADDR_CANT_GET."
{$sql}");
$all="";
$i=2;
while(list($sn,$name,$email,$tel,$addr) = $xoopsDB->fetchRow($result)){
$style=($i%2)?"odd":"even";
$all.="
| {$name} |
{$email} |
{$tel} |
{$addr} |
";
$i++;
}
$data="
| "._MD_ADDR_NAME." | "._MD_ADDR_EMAIL." |
"._MD_ADDR_TEL." | "._MD_ADDR_ADDRESS." |
|---|
$all
$bar";
return $data;
}
//管理工具
function admin_tool(){
global $xoopsModule,$xoopsUser;
if ($xoopsUser) {
$module_id = $xoopsModule->getVar('mid');
$isAdmin=$xoopsUser->isAdmin($module_id);
if($isAdmin)$toolbar=""._MD_ADDR_ADD."";
return $toolbar;
}
}
$main=list_addr_book();
/*-----------秀出結果區--------------*/
include XOOPS_ROOT_PATH."/header.php";
echo admin_tool().$main;
include_once XOOPS_ROOT_PATH.'/footer.php';
?>