사용자 그룹 통합 해제(해제는 삭제)
SQL은 이전 글에서 동일하게 사용된 구조.
<code>
#################그룹 통합
/*
$merge="abc";
$str1="abcdef";
$str2="lmopp";
$str3="admins";
$merge_sql="select `GrpTitle`,`GrpId`,`GrpGenCode`,`GrpAdmin` from usergroup where GrpId like '$merge'";
$merge_result=mysqli_query($conn,$merge_sql);
$merge_check=mysqli_num_rows($merge_result);
if($merge_check < 1) { echo "해당 대상이 없습니다";}
else {
while($merge_fetch=mysqli_fetch_assoc($merge_result)) {
$grpTitle=stripslashes($merge_fetch['GrpTitle']);
$grpId=stripslashes($merge_fetch['GrpId']);
$grpGenCode=stripslashes($merge_fetch['GrpGenCode']);
$grpAdmin=stripslashes($merge_fetch['GrpAdmin']);
}echo $merge_update="update usergroup set `GrpTitle` = '$grpTitle', `GrpId` = '$str1', `GrpGenCode` = '$str2' ,
`GrpAdmin` = '$str3' where `Grpid` like 'abc' and GrpIdx >=1";
~~~merge run
}
*/
####################################################
/*그룹 해체
$break_sql="DELETE FROM usergroup WHERE `GrpId` = 'abcdef' and GrpIdx >=1";
~delete run
*/
</code>