$v){ $fen=explode(",",trim($v)); foreach($fen as $f){ if(!empty($f)&&!in_array($f,$arr)){ $arr[]=$f; $likearr[]="realname = '$f'"; } } } $likestr = empty($likearr)?"":"and (".implode(" or ",$likearr).")"; global $list; $list=sql("select id,realname from {{user_teacher}} where schoolid = '".intval($schoolid)."' $likestr")->queryAll(); //print_r($list); echo '
结果1:
'; function getid($str){ global $list; $id=""; foreach($list as $v){ if($v['realname']==$str){ $id = $v['id']; break; } } return $id; } $line=array(); foreach($strarr as $k => $v){ $fen=explode(",",trim($v)); $tarr=array(); foreach($fen as $f){ if(empty($f)){ //$tarr[]=""; } else{ $id=getid($f); if(!empty($id))$tarr[]=$id; } } $line[]=implode(",",$tarr); } //print_r($line); echo ''; $same=sql("select id,realname,phone,count(*) as count,Group_concat(id) as ids from {{user_teacher}} where schoolid = '".intval($schoolid)."' $likestr group by realname having count>1")->queryAll(); //print_r($same); $samearr=array(); foreach($same as $v){ $samearr[]=''.$v['realname']."(".$v['count'].")".$v['ids'].''; } if(!empty($same)){ echo "

重名:
".implode("
",$samearr)."
"; } $nonearr=array(); foreach($arr as $v){ $isin=false; foreach($list as $c){ if($c['realname']==$v){ $isin=true; break; } } if(!$isin)$nonearr[]=$v; } if(!empty($nonearr))echo "

不存在:
".implode("
",$nonearr)."
"; echo "

结果2:
"; $line=array(); foreach($strarr as $k => $v){ $fen=explode(",",trim($v)); $tarr=array(); foreach($fen as $f){ if(empty($f)){ $tarr[]=$f; } else{ $id=getid($f); if(empty($id)){ $tarr[]=$f; } else{ $tarr[]=$id; } } } $line[]=implode(",",$tarr); } //print_r($line); echo ''; echo '
'; exit; } ?> 获取老师ID

学校ID: