del_group_chk.php

来自「一个很不错的oa系统,简单好用,数据库是用mysql5,所以大家要注意,不要因为」· PHP 代码 · 共 38 行

<?php
	session_start();
	include "../inc/chec.php";
	include "../conn/conn.php";
	include "../inc/func.php";
	$fields = read_field($conn,"tb_group","u_group",$_GET[id]);
	/*删除用户组*/
	$sqlstr = "delete from tb_group where id = ".$_GET[id];
	$result = mysql_query($sqlstr,$conn);
	/*****************************/
	/*删除list功能列表中相对应的组*/
	$l_sqlstr = "select * from tb_list";
	$l_result = mysql_query($l_sqlstr,$conn);
	while($l_rows = mysql_fetch_row($l_result)){
		if($l_rows[4] != "0"){
			/* 生成用户组列表 */
			$l_list = split(",",$l_rows[4]);
			$new_fields = "";
			for($num = 0; $num < (count($l_list) -1); $num++){
				if($fields != $l_list[$num]){
					$new_fields .= $l_list[$num].",";
				}
			}
			$n_sqlstr = "update tb_list set o_group = '".$new_fields."' where id = ".$l_rows[0];
			mysql_query($n_sqlstr,$conn);
			
		}
		else{
		
		}
	}
	/******************************/
	if($result)
		echo "<script>alert('删除成功！');location='user_group.php';</script>";
	else
		echo "<script>alert('系统繁忙，请稍后再试');history.go(-1);</script>";
?>