query($strSql); if($objConn->nf() != 0) { $objConn->next_record(); $group_id = $objConn->f("group_id"); $group_name = $objConn->f("group_name"); } $objConn->close(); $delete_btn = ""; $which_word = "수정"; } if(getenv("REQUEST_METHOD") != "POST") { ?> 그룹<?=$which_word?>
그룹
그룹ID
그룹명
패스워드
패스워드확인

query($enCoding); $strSql = "SELECT COUNT(group_seq) AS cnt "; $strSql .= "FROM t_group "; $strSql .= "WHERE group_id = '".$group_id."' AND deleted_yn = 'N' "; $objConn->query($strSql); if($objConn->nf() != 0) { $objConn->next_record(); $cnt = $objConn->f("cnt"); if($cnt == 0) { if ($mode == "add") { $strSql = "INSERT INTO t_group(group_id, group_password, group_name, deleted_yn, "; $strSql .= " reg_datetime, update_datetime) "; $strSql .= "VALUES ('".$group_id."', '".$group_password."', '".$group_name."', 'N', now(), now())"; $objConn->query($strSql); echo ""; } else if ($mode == "mod") { $strSql = "UPDATE t_group "; $strSql .= "SET group_id = '$group_id', group_name = '$group_name', group_password = '$group_password' "; $strSql .= "WHERE group_seq = '$gseq' "; $objConn->query($strSql); echo ""; } } else if ($mode == "mod" && $cnt == 1 && $group_id == $group_old_id) { $strSql = "UPDATE t_group "; $strSql .= "SET group_id = '$group_id', group_name = '$group_name', group_password = '$group_password' "; $strSql .= "WHERE group_seq = '$gseq' "; $objConn->query($strSql); echo ""; } else if ($mode == "del" && $cnt == 1) { $strSql = "UPDATE t_group SET deleted_yn = 'Y' "; $strSql .= "WHERE group_seq = '$gseq' "; $objConn->query($strSql); $strSql = "DELETE FROM t_group_member "; $strSql .= "WHERE group_seq = '$gseq' "; $objConn->query($strSql); echo ""; } else { echo ""; die; } }else { echo ""; die; } $objConn->close(); } die; ?>