get_results('SELECT * FROM (SELECT classprefix, SUBSTRING(dates,1,10) sdate, SUBSTRING(dates,LENGTH(dates)-9) edate FROM `class_aiacademy_tw`.`class_dates`) AS t WHERE classprefix LIKE "_T%" ORDER BY classprefix'); $area = array('A'=>'[台北]','J'=>'[新竹]','B'=>'[台中]','E'=>'[南部]'); $tp = 0; $hc = 0; $tc = 0; $st = 1; $ary_tp = array(); $ary_hc = array(); $ary_tc = array(); $ary_st = array(); $area2num = array('[台北]'=>'tp','[新竹]'=>'hc','[台中]'=>'tc','[南部]'=>'st'); $s = ''; ?> sdate.'~'.$v->edate; if(in_array($record, $${'ary_'.$num_key})){ continue; } $area_key = substr($v->classprefix,0,1); $area_value = $area[$area_key]; $name = $area_value; $name .= '民國1'.substr($v->classprefix,2,2); $n = substr($v->classprefix,4,1); $name .= '第 '.$n.' 次的課班: '; $num_key = $area2num[$area_value]; $$num_key = $$num_key+1; $lnk = 'aiacademy.tw/admission-tech-'.$num_key.$$num_key.'/'; $lnk_alt = 'aiacademy.tw/admission-tech-'.$num_key.'/'; $s .= ''; $j[] = array('name'=>$name, 'open_date'=>$v->sdate, 'close_date'=>$v->edate,'lnk'=>$lnk,'lnk_alt'=>'aiacademy.tw/admission-tech-'.$num_key.'/'); $${'ary_'.$num_key}[] = $record; } $s .='

'.implode('	',['Title','start','end','url','url(alternative)']).'
'.implode( '	', [$name, $v->sdate, $v->edate,''.$lnk.'', $lnk_alt] ).'

'; if(isset($_GET['json'])){ echo json_encode($j,JSON_UNESCAPED_UNICODE); }else{ echo$s; }