SQL($SQL); $HTML=$tmp[0]; //webタイトルタイトル $tool->title=$web_title." "; //ディスクリプション $tool->discri=$web_discripton.""; //キーワード $tool->keyword=$web_keyword.""; $tool->h1=" ".$web_title; $tool->BASE_CHK(BASE_URL."?ssid=".$tool->ssid); //view///////////////////////////////////////////////////////////////////////////////////////////////////////// $tool->HEAD(); //トップ画像 //キャッチ print "
"; print "

携槍・専門学校をチェック!

"; print "
\n"; print "
"; print "\n"; print BAITAI."スクールナビは".BAITAI."の専門学校から簡単にパンフレットや学校の資料・願書を請求できるホームページです!"; print "簡単検索で行きたい学校を決めよう!"; print "\n"; print "
\n"; print "
"; print "

パンフレットは全部無料

"; print "
\n"; //Quoキャンペーン print "
[全員対象]
Quoカードが当る
キャンペーン実施中!
\n"; //Macキャンペーン print "
[地元高校生限定]
資料請求7件以上で
キャンペーン実施中!
\n"; //一括リンク print "
いろんな学校の資料を
一括で請求する!
\n"; /* //なりたい仕事で探す! print "
"; print "

なりたい仕事で探す!

"; print "
\n"; print $tool->mimg[145]."WEBデザイナー
\n"; print $tool->mimg[73]."プログラマー
\n"; print $tool->mimg[41]."ホテルマン
\n"; */ //検索画面 学科・カテゴリで検索 print "
"; print "

学科カテゴリで検索

"; print "
\n"; /*if($tool->ktype=="au"){ print $tool->mimg[36]."公務員"; print $tool->mimg[145]."IT"; print $tool->mimg[53]."美容"; print $tool->mimg[65]."教育"; print $tool->mimg[120]."福祉"; print $tool->mimg[64]."技術"; print $tool->mimg[91]."ペット"; print $tool->mimg[147]."事務"; print $tool->mimg[47]."調理"; print $tool->mimg[34]."観光"; }else{ */ //新検索用 $cnt=1; $SQL="select * from HANYOU where TYPE='CATEGORI_BIG' "; $CATEGORI=$tool->SQL($SQL); foreach($CATEGORI as $key=>$value){ if(!$value['BODY02']){continue;} //カテゴリ詳細 $SQL="select BODY01 from HANYOU where TYPE='CATEGORI' and BODY02 like '".$value['BODY01']."'"; $DETAIL=$tool->SQL($SQL); unset($detail_data); unset($SRC_CATEGORI); $course_cnt=0; if(count($DETAIL)){ print "
\n"; foreach($DETAIL as $ke=>$va){ //カテゴリ詳細 $SRC_CATEGORI[]="B.CATEGORI like '%".$va['BODY01']."%'"; $detail_data.=$va['BODY01']." "; /* //チェック必要? $SQL="select distinct(A.SID) from SCHOOL as A , COURSE as B , CLIENT as C "; //検索指定 学校基本に、コースと企業情報をつなげる $SQL.=" where A.SID = B.SID and C.CID=A.CID "; //削除設定 企業・学校・学科/コーステーブルが 全てOKな時だけ表示ね。 $SQL.=" and A.SAKUJO = 0 and B.SAKUJO =0 and C.SAKUJO=0 "; $SQL.=" and B.CATEGORI like '%".$va['BODY01']."%' "; $chk=$tool->SQL($SQL); if(count($chk)==0){continue;} $detail_data.= "".$va['BODY01']." \n"; */ // $detail_data.= "".$va['BODY01']."\n"; // $detail_data.= "".$va['BODY01']."(".count($chk).")\n"; } print "
\n"; //全体件数誌シ $SQL="select count(B.COID) from SCHOOL as A , COURSE as B , CLIENT as C "; //検索指定 学校基本に、コースと企業情報をつなげる $SQL.=" where A.SID = B.SID and C.CID=A.CID and C.BAITAI='".BAITAI."'"; //削除設定 企業・学校・学科/コーステーブルが 全てOKな時だけ表示ね。 $SQL.=" and A.SAKUJO = 0 and B.SAKUJO =0 and C.SAKUJO=0 "; if(count($SRC_CATEGORI)){ $SQL.=" and (".implode(" or ",$SRC_CATEGORI).") "; } $tmp=$tool->SQL($SQL); $course_cnt=$tmp[0]['count(B.COID)']; } print "
\n"; print "
".$tool->CNG_STR_K($value['BODY01']."(".$course_cnt.")")."
\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "
\n"; print "".$value["; print "\n"; print "
\n"; print $detail_data; print "
\n"; print "
\n"; $cnt++; print "
\n"; /*print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "
\n"; print "
"; print $tool->mimg[36]."公務員"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[145]."IT"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[53]."美容"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[65]."教育"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[120]."福祉"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[64]."技術"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[91]."ペット"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[147]."事務"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[47]."調理"; print "
\n"; print "
\n"; print "
"; print $tool->mimg[34]."観光"; print "
\n"; print "
\n"; print "\n"; print "
\n";*/ } //検索画面 学科・コースで検索 /*print "
学科コースで検索
\n"; print "
\n"; $SCH_CATE=$tool->SQL("select BODY01 from HANYOU where TYPE='カテゴリ' order by NO asc"); $i = 0; //携槍隈文字マーク 後で汎用DBに入れようかな。 $SCHE_MARK=array("1","145","57","91","64","65","147","120","53","5","162","36","47","34","144","143","169","142","52"); if(count($SCH_CATE)){ foreach($SCH_CATE as $key=>$value){ //件数あるかチェック $chkdatas=explode("・",$value['BODY01']); $sqls = " and (C.CATEGORI like '%".implode("%' or C.CATEGORI like '%",$chkdatas)."%') "; $SQL="select distinct(B.SID) from CLIENT as A, SCHOOL as B, COURSE as C where A.CID=B.CID and B.SID=C.SID and C.SAKUJO=0 and B.SAKUJO=0 and A.BAITAI='沖縄県' and A.SAKUJO=0 ".$sqls; $Vcourse=$tool->SQL($SQL); if(count($Vcourse)>0){ print $tool->mimg[$SCHE_MARK[$key]]; print "".mb_convert_kana($value['BODY01'],"k","Shift-JIS")."(".count($Vcourse).")\n"; //print ""; print "
\n"; } $i++; } } print "
\n";*/ //検索画面 学校名で検索 print "
"; print "

学校名で検索

"; print "
\n"; //print "
学校名で検索
\n"; print "
\n"; $SCH_NAME=$tool->SQL("select distinct B.SCHOOL_NAME from CLIENT as A ,SCHOOL as B where B.CID=A.CID and A.BAITAI='".BAITAI."' and A.SAKUJO = 0 and B.SAKUJO=0"); print "
"; print "\n"; print "\n"; print "
\n"; print "
\n"; //検索画面 キーワードで検索 //print "
キーワードで検索
\n"; print "
"; print "

キーワードで検索

"; print "
\n"; print "
\n"; print "
"; print "TEXT_TYPE("1","width:50%;font-size:xx-small;")." size='10'>\n"; print "\n"; print "
\n"; print "
\n"; /* print "
"; print "

お役立ちページ

"; print "
\n"; print "
\n"; print "
沖縄の専門学校一覧
\n"; print "
\n"; */ /* if(count($HTML)){ print "
\n"; print "
運営者のつぶやき ".$HTML['TITLE']."

"; print "
\n"; print $tool->DATA_CUTS(html_entity_decode($HTML['HTML'])); print "
\n"; print "詳しく見る\n"; print "

\n"; print "
\n"; } */ $tool->FOOT(); ?>