query($enCoding); $strSql = " SELECT member_name "; $strSql .= " FROM t_group_member "; $strSql .= " WHERE member_cellphone = '$phone' AND group_seq = '$group_seq' "; $objConn->query($strSql); if($objConn->nf() != 0) { $objConn->next_record(); $member_name = $objConn->f("member_name"); } $objConn->close(); $delete_btn = ""; $which_word = "수정"; } if($group_seq != "") { if(getenv("REQUEST_METHOD") == "GET") { ?> 멤버<?=$which_word?>
멤버
이름
핸드폰

query($enCoding); $mode = trim($_POST['mode']); $group_seq = trim($_POST['group']); $member_name = trim($_POST['member_name']); $member_old_cellphone = trim(str_replace("-", "", $_POST['member_old_cellphone'])); $member_cellphone = trim(str_replace("-", "", $_POST['member_cellphone'])); $strSql = "SELECT COUNT(group_seq) AS cnt "; $strSql .= "FROM t_group_member "; $strSql .= "WHERE group_seq = ".$group_seq." AND member_cellphone = '".$member_cellphone."'"; $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_member(group_seq, member_name, member_cellphone, reg_datetime, update_datetime) "; $strSql .= "VALUES (".$group_seq.", '".$member_name."', '".$member_cellphone."', now(), now())"; $objConn->query($strSql); echo ""; } else if ($mode == "mod") { $strSql = "UPDATE t_group_member "; $strSql .= "SET member_name = '$member_name', member_cellphone = '$member_cellphone', update_datetime = now() "; $strSql .= "WHERE group_seq = '$group_seq' AND member_cellphone = '$member_old_cellphone' "; $objConn->query($strSql); echo ""; } } else if ($cnt > 0 && $mode == "mod" && $member_cellphone == $member_old_cellphone) { $strSql = "UPDATE t_group_member "; $strSql .= "SET member_name = '$member_name', member_cellphone = '$member_cellphone', update_datetime = now() "; $strSql .= "WHERE group_seq = '$group_seq' AND member_cellphone = '$member_old_cellphone' "; $objConn->query($strSql); echo ""; } else if ($cnt == 1 && $mode == "del") { $strSql = "DELETE FROM t_group_member "; $strSql .= "WHERE group_seq = ".$group_seq." AND member_cellphone = '".$member_old_cellphone."'"; $objConn->query($strSql); echo ""; } else { echo ""; } } $objConn->close(); } }else { echo ""; die; } ?>