내용부러오기 질문좀 드려요 부탁드립니다. 채택완료
include_once("./_common.php");
auth_check($auth[$sub_menu], "r");
$sql_common = " from $g4[member_table] ";
$sql_search = " where (1) "; if ($stx) { $sql_search .= " and ( "; switch ($sfl) { case "mb_point" : $sql_search .= " ($sfl >= '$stx') "; break; case "mb_level" : $sql_search .= " ($sfl = '$stx') "; break; case "mb_tel" : case "mb_hp" : $sql_search .= " ($sfl like '%$stx') "; break; default : $sql_search .= " ($sfl like '$stx%') "; break; } $sql_search .= " ) "; }
// 만료일 검색 if ($membership_date1&&$membership_date2) { $sql_search .= " and (mb_1 >= '$membership_date1' and mb_1 <= '$membership_date2') "; }
// 회비납부 연장 클릭에 대한 DB쿼리
if($membership_fee&&$membership_id){ switch ($membership_fee) { case "ok" : $sql_fee = " update $g4[member_table] set mb_1 = DATE_FORMAT(DATE_ADD(mb_1,INTERVAL 1 MONTH),'%Y-%m-%d') where mb_id = '$membership_id' "; break; case "cancle" : $sql_fee = " update $g4[member_table] set mb_1 = '' where mb_id = '$membership_id' "; break; default : $sql_fee = " update $g4[member_table] set mb_1 = '".date("Y-m-d", mktime(0,0,0,date("m")+1 , date("d"), date("Y")))."' where mb_id = '$membership_id' "; break; } sql_query($sql_fee); }
//if ($is_admin == 'group') $sql_search .= " and mb_level = '$member[mb_level]' "; if ($is_admin != 'super') $sql_search .= " and mb_level <= '$member[mb_level]' ";
if (!$sst) { $sst = "mb_datetime"; $sod = "desc"; }
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt $sql_common $sql_search $sql_order "; $row = sql_fetch($sql); $total_count = $row[cnt];
$rows = $config[cf_page_rows]; $total_page = ceil($total_count / $rows); // 전체 페이지 계산 if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지) $from_record = ($page - 1) * $rows; // 시작 열을 구함
$listall = "처음";
$g4[title] = "회원관리"; include_once("./admin.head.php");
$sql = " select * $sql_common $sql_search $sql_order limit $from_record, $rows "; $result = sql_query($sql);
$colspan = 10; $today_date_7 = date("Y-m-d", mktime(0,0,0,date("m") , date("d")+7, date("Y"))); $today_date = date('Y-m-d'); ?>
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
if ($stx) echo "\n"; ?> include_once ("./admin.tail.php"); ?>
--------------------------------------------------------------------------------------------------
".$row[mb_1]."
만료일자를 로그인하면 옆에 넣고 싶은데 어떻게 해야하나요?
답변을 작성하려면 로그인이 필요합니다.
로그인