prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 10000 AND 10999');
$kantou -> execute();
$result_kantou = $kantou ->fetchAll(PDO::FETCH_ASSOC);
foreach ($result_kantou as $ca) {
// print_r($ca);
$prepare = $pdo ->prepare('SELECT * FROM univ_cord WHERE university LIKE \''.$ca['university'].'\'');
$prepare -> execute();
$result = $prepare ->fetchAll(PDO::FETCH_ASSOC);
$univrow = array_column($result,'cord','university');
//print_r($univrow);
foreach($univrow as $key => $value){
$univcord = $value;
}
//登録されている問題数をカウントする
$ca_count = $pdo ->prepare('SELECT COUNT(university) FROM ' . $db['table'] .' WHERE year = '.$getyear.' AND university LIKE \''.$ca['university'].'\'');
$ca_count -> execute();
$ca_result = $ca_count ->fetch(PDO::FETCH_OBJ);
foreach ($ca_result as $ca_num) {
// echo $ca['university'] . $ca_num;
}
if($ca_num != 0){
print('
'.$ca_num.''.$ca['university'].'');
}
}
?>