PDO::ERRMODE_EXCEPTION)); echo('データベース接続成功。'); } catch (PDOException $e) { echo('データベース接続失敗。'.$e->getMessage()); } // ログイン状態チェック /* if (!isset($_SESSION["NAME"])) { header("Location: Logout.php"); exit; } */ ?> 大学入試 数学過去問DB
 大学入試 過去問集 数学(β版公開)



 年度別(国公立大学・私立大学)
※ 地方は,八地方区分で分類しています。



". h($getyear) ."年度】
"; //問題登録データベースから登録されている大学名をすべて取得 $input_univ = $pdo ->prepare('SELECT * FROM '.$db['table'].' WHERE year = \'' . $getyear . '\''); $input_univ -> execute(); $result_univ = $input_univ ->fetchAll(PDO::FETCH_ASSOC); foreach ($result_univ as $row) { $newrow = $row['university']; $new_univrow[] = $newrow; } //新しく生成した配列において,重複した配列の値を削除する if( ! isset($new_univrow) || $new_univrow == ''){ echo "  ※ ".$getyear."年度の登録は,まだありません。"; }else{ $unique_array= array_unique($new_univrow); //print_r($unique_array); } ?>

  問題登録大学一覧

北海道地方 ・ 国立大学

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'].''); } } ?>

北海道地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 20000 AND 20999'); $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'].''); } } ?>

北海道地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 30000 AND 30999'); $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'].''); } } ?>

東北地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 11000 AND 11999'); $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'].''); } } ?>

東北地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 21000 AND 21999'); $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'].''); } } ?>

東北地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 31000 AND 31999'); $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'].''); } } ?>

関東地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 12000 AND 12999'); $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'].''); } } ?>

関東地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 22000 AND 22999'); $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'].''); } } ?>

関東地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 32000 AND 32999'); $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'].''); } } ?>

中部地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 13000 AND 13999'); $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'].''); } } ?>

中部地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 23000 AND 23999'); $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'].''); } } ?>

中部地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 33000 AND 33999'); $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'].''); } } ?>

関西地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 14000 AND 14999'); $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'].''); } } ?>

関西地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 24000 AND 24999'); $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'].''); } } ?>

関西地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 34000 AND 34999'); $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'].''); } } ?>

中国地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 15000 AND 15999'); $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'].''); } } ?>

中国地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 25000 AND 25999'); $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'].''); } } ?>

中国地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 35000 AND 35999'); $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'].''); } } ?>

四国地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 16000 AND 16999'); $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'].''); } } ?>

四国地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 26000 AND 26999'); $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'].''); } } ?>

四国地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 36000 AND 36999'); $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'].''); } } ?>

九州・沖縄地方 ・ 国立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 17000 AND 18999'); $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'].''); } } ?>

九州・沖縄地方 ・ 公立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 27000 AND 28999'); $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'].''); } } ?>

九州・沖縄地方 ・ 私立大学

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 37000 AND 38999'); $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'].''); } } ?>

省庁大学校

prepare('SELECT university FROM univ_cord WHERE cord BETWEEN 82000 AND 82999'); $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'].''); } } ?>
count(); $prob_regpdf = $prob_regpdfcount ->count(); $sol_regpdf = $sol_regpdfcount ->count(); $prob_nonregjpg = $datanum - $prob_regjpg; $prob_nonregpdf = $datanum - $prob_regpdf; $sol_nonregpdf = $datanum - $sol_regpdf; $probjpg_ritu = sprintf('%.2f',round(( $prob_regjpg ) / ( $datanum )*100,2)); $probpdf_ritu = sprintf('%.2f',round(( $prob_regpdf ) / ( $datanum )*100,2)); $solpdf_ritu = sprintf('%.2f',round(( $sol_regpdf ) / ( $datanum )*100,2)); ?>