$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).")"; //$classstr=empty($classid)?"":"and classid = ".intval($classid); $classstr=""; $gradearr=array(); if(!empty($grade)){ $gradearr=explode(",",$grade); foreach($gradearr as $k => $v){ $gradearr[$k]=intval($v); } } //$gradestr=empty($gradearr)?"":"and grade in (".implode(",",$gradearr).")"; $gradestr=empty($grade)?"":"and grade = ".intval($grade); $gradeurl=empty($grade)?"":"&grade_operator=%3D&grade=".intval($grade); global $list; $list=sql("select id,Group_concat(id) as ids,realname from {{user}} where schoolid = '".intval($schoolid)."' and studentid is not null $gradestr $classstr $likestr group by realname")->queryAll(); //print_r($list); echo '
结果1:
'; function getid($str){ global $list; $id=""; foreach($list as $v){ if($v['realname']==$str){ //$id = $v['id']; $id = $v['ids']; 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,Group_concat(studentid) as studentids from {{user}} where schoolid = '".intval($schoolid)."' and studentid is not null $gradestr $classstr $likestr group by realname having count>1")->queryAll(); //print_r($same); $samearr=array(); foreach($same as $v){ $idsarr=explode(",",$v['ids']); $studentidsarr=explode(",",$v['studentids']); $arr2=array(); foreach($idsarr as $k => $s){ $arr2[]="{".$idsarr[$k].":".$studentidsarr[$k]."}"; } $arr2str=implode(",",$arr2); $samearr[]=''.$v['realname']."(".$v['count'].")".$arr2str.''; } if(!empty($same)){ echo "

重名{ID:学号}:
".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: 年级: