$v){
$fen=explode(",",trim($v));
foreach($fen as $f){
if(!empty($f)&&!in_array($f,$arr)){
$arr[]=$f;
$likearr[]="shortname like '%".$f."%'";
}
}
}
$likestr = empty($likearr)?"":"and (".implode(" or ",$likearr).")";
$semesteridstr=empty($semesterid)?"":"and semesterid = ".intval($semesterid);
global $list;
$list=sql("select id,shortname from {{class}} where schoolid = '".intval($schoolid)."' $likestr $semesteridstr")->queryAll();
//print_r($list);
echo '
结果1:
';
function getid($str){
global $list;
$id="";
foreach($list as $v){
if(strstr($v['shortname'],$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 '
';
$nonearr=array();
foreach($arr as $v){
$isin=false;
foreach($list as $c){
if(strstr($c['shortname'],$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;
}
?>