$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;
}
?>