connect($dbhost,$dbuser,$dbpw,$dbname,"p"); $is_submit=$_POST["is_submit"]; $col_name=$_POST["col_name"]; if($is_submit=="y"){ if($col_name){ $content=$_POST["content"]; $arr=explode("\n",$content); for($i=0;$i0){ $q="update ".$table_pre."client set ".$col_name."='".$col_value."' where id='".$check["id"]."'"; //echo $q."
"; $db->query($q); $msg.=$no.":".$col_value."-设置成功!
"; }else{ //有误 $msg.="".$no."-客户代码有误!
"; } } }else{ $msg.="请选择字段名!
"; } } $arr_column_client=array("title"=>"用户名称","dpsx"=>"店铺属性","dj"=>"店铺等级","password"=>"登陆密码","zb"=>"指标金额","zb_js"=>"指标件数","zb_ks"=>"指标款数","zb_kss"=>"指标款色数"); // $q="select * from ".$table_pre."keyword where cate='arr_select' and flag_ka='y' and no<>'jgd' and no<>'sx' order by ord"; $r=$db->query($q); while($m=$db->fetch_array($r)){ $arr_column_kh[$m["no"]]=$m["title"]; } ?> 批量设置客户表字段值
"; } ?>
批量设置客户表字段值
格式说明:同行之间用|分隔,如:登陆代码|字段值;多条记录请回车。
".$msg."