'Edge AI', 'doc'=>'1ZK6q_gHBQHnfp-sPN8hyzGcceYr9U1KYs3O7IYrEE5M', 'gid'=>'0'), ); if($_POST){ $first_name = isset($_POST['a']) ? $_POST['a'] : ''; $last_name = isset($_POST['b']) ? $_POST['b'] : ''; $class= isset($_POST['c']) ? $_POST['c'] : ''; $month= isset($_POST['d1']) ? $_POST['d1'] : ''; $day= isset($_POST['d2']) ? $_POST['d2'] : ''; #if(strlen($month)){ $month = $month<10 && strlen($month)==1 ? '0'.$month : $month; } #if(strlen($day)){ $day = $day<10 && strlen($day)==1 ? '0'.$day : $day; } if(!$first_name){die('

Please input 姓, Go Back');} if(!$last_name){die('

Please input 名, Go Back');} if(isset($ary_classes[$class])){ $class = $ary_classes[$class]; }else{ die('

Please pick a class, Go Back'); } $doc = isset($class['doc']) ? $class['doc'] : ''; $gid = isset($class['gid']) ? $class['gid'] : ''; $google_doc_url = 'https://docs.google.com/spreadsheets/d/'.$doc.'/export?format=tsv&gid='.$gid; $s = file_get_contents($google_doc_url); $a = preg_split("/(\r\n|\n|\r)/",$s); $bool = false; $true_num = 0; $ary_signup_date = []; foreach($a as$v): list($FIRST_NAME,$LAST_NAME,$DATE) = explode("\t", $v); if($FIRST_NAME==$first_name && $LAST_NAME==$last_name){ $bool = true; $true_num+=1; $ary_signup_date[] = $DATE; } endforeach; $msg = ''; if($true_num==1){ $msg = '【'.$first_name.$last_name.'】已於 "'.implode('" 與 "',$ary_signup_date).'" 報名.'; } } ?> 查詢報名 '.$msg.'' : '';?>