$user=$_POST['user']; $arr=array(); $darr=array(); $darr= array_diff($arr,$user); if(!empty($user)){ for($i=0;$i if($user=="checked") //echo ""; $db->query("update members set fuchu='".$_POST['fuchu']."' where uid='".$user[$i]."'"); } }
if(!empty($darr)){ for($j=0;$j<=count($darr);$j++){ $rowf=$db->get_one("select * from members where fuchu=".$_POST['fuchu']); if($darr[$j]==$rowf['uid']) unset($darr[$j]); else $db->query("update members set fuchu='0' where uid='".$darr[$j]."'"); } }
这是获取checkbox的jquery代码 //city onchange $('#fuchu').change(function() { var city = $(this).val(); var province=$("#depart").val(); $.get("getdepart.php", {category:'user', city:city,province:province}, function(data) { $('#result').html(data); //alert (data); }); });
这是html代码 if($_REQUEST["city"]!=""){ $sql="select * from members left join userclass on members.flag=userclass.flagid where admitright=4 and groupid=".$_REQUEST['province']; $result=$db->query($sql); $str=""; if ($db->num_rows($result) > 0) { while ($row =$db->fetch_array($result)) { if($row['fuchu']==$_REQUEST['city']){ $str.= $row['username']; $str.= " "; }else{ $str.= $row['username']; $str.= " "; }