001002003004005006007008009010011012013014015016017018019020021022023024025026027028029030031032033034035036037038039040041042043044045046047048049050051052053054055056057058059060061062063064065066067068069070071072073074075076077078079080081082083084085086087088089090091092093094095096097098099100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346
<?php // (2021.1.13, 차재복, Cha Jae Bok, http://www.ktword.co.kr) # 특정 검색 선택 처리 함수 function choice ($ch) { // 선택 switch ($ch) { case ('comp') : case ('1') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%비교' or a.word like '%차이' group by a.no order by a.word"; $title = "비교 리스트"; break; case ('type') : case ('2') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%구분' or a.word like '%종류' group by a.no order by a.word"; $title = "구분/종류 리스트"; break; case ('formula') : case ('3') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 공식' or a.word like '% 방정식' group by a.no order by a.word"; $title = "공식/방정식 리스트"; break; case ('law') : case ('4') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 법칙' group by a.no order by a.word"; $title = "법칙 리스트"; break; case ('theory') : case ('5') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 이론' group by a.no order by a.word"; $title = "이론 리스트"; break; case ('principle') : case ('6') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 원리' group by a.no order by a.word"; $title = "원리 리스트"; break; case ('theorem') : case ('7') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 정리' group by a.no order by a.word"; $title = "정리 리스트"; break; case ('discipline') : case ('8') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%학' group by a.no order by a.word"; $title = "학문 리스트"; break; case ('mode') : case ('9') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%모드%' group by a.no order by a.word"; $title = "모드 리스트"; break; case ('function') : case ('10') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%함수' group by a.no order by a.word"; $title = "함수 리스트"; break; case ('ratio') : case ('11') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%율' or a.word like '%률' or a.word like '%비') and not (a.word like '%효율' or a.word like '%확률' or a.word like '%적률' or a.word like '%법률' or a.word like '%일률' or a.word like '%능률' or a.word like '%설비' or a.word like '%장비' or a.word like '%좀비' or a.word like '%유지비' or a.word like '%공사비' or a.word like '%상각비' or a.word like '%지그비') group by a.no order by a.word"; $title = "율/률/비 리스트"; break; case ('coef') : case ('12') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%계수') group by a.no order by a.word"; $title = "계수 리스트"; break; case ('constant') : case ('13') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%상수' or a.word like '%정수') group by a.no order by a.word"; $title = "정수/상수 리스트"; break; case ('factor') : case ('14') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where ((a.word like '%인수') or (a.word like '%인자') or (a.word like '%인수 분해') or (a.word like '% factor')) and not (a.word like '%라인수' or a.word like '%합병 인수' or a.word like '%품질 인자') group by a.no order by a.word"; $title = "인수/인자,율/률 (factor) 리스트"; break; case ('order') : case ('15') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%order%') and (a.word like '%zero%' or a.word like '%first%' or a.word like '%second%' or a.word like '%tree%' or a.word like '%equation%') and not (a.word like '%byte%' or a.word like '%ordered%') group by a.no order by a.word"; $title = "차수/계수 (order) 리스트"; break; case ('density') : case ('16') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%밀도%') and not (a.word like '%정밀도%') group by a.no order by a.word"; $title = "밀도(density) 리스트"; break; case ('degree') : case ('17') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%degree%') group by a.no order by a.word"; $title = "차수/계수(degree) 리스트"; break; case ('energy') : case ('18') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%에너지%') group by a.no order by a.word"; $title = "에너지 리스트"; break; case ('power') : case ('19') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%전력%') and not (a.word like '%회전력%') group by a.no order by a.word"; $title = "전력 리스트"; break; case ('velocity') : case ('20') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%속도' or a.word like '%속도 벡터' or a.word like '%속도장' or a.word like '%속도계' or a.word like '%광속 불변%') group by a.no order by a.word"; $title = "속도 리스트"; break; case ('field') : case ('21') : $query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where concat(',',full_name,',',extra_keyword,',') like '%field,%' and concat(',',full_name,',',korean,',',extra_keyword,',') like '%장,%' group by a.no order by a.word"; $title = "장(場) 리스트"; break; case ('reform') : $title = "개선 진행중"; break; case ('coding') : $title = "작성중 (코딩이란?)"; break; default : exit; } return array('title'=>$title, 'query'=>$query); } # 특정어별로 타이틀,쿼리 등을 담은 배열 function choice_v2 () { return [ "1" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%비교' or a.word like '%차이' group by a.no order by a.word", "title" => "비교 리스트", "alias" => "비교", "desc" => "유사 용어들 간의 비교 (같음/닮음/다름)" ], "2" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%구분' or a.word like '%종류' group by a.no order by a.word", "title" => "구분/종류 리스트", "alias" => "종류", "desc" => "특정 기술 용어별 종류/구분 등" ], "3" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 공식' or a.word like '% 방정식' group by a.no order by a.word", "title" => "공식/방정식 리스트", "alias" => "공식", "desc" => "각종 주요 공식,방정식 등" ], "4" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 법칙' group by a.no order by a.word", "title" => "법칙 리스트", "alias" => "법칙", "desc" => "자연과학 법칙들" ], "5" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 이론' group by a.no order by a.word", "title" => "이론 리스트", "alias" => "이론", "desc" => "자연과학 이론들" ], "6" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 원리' group by a.no order by a.word", "title" => "원리 리스트", "alias" => "원리", "desc" => "주요 원리들" ], "7" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 정리' group by a.no order by a.word", "title" => "정리 리스트", "alias" => "정리", "desc" => "주요 정리들" ], "8" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%학' group by a.no order by a.word", "title" => "학문 리스트", "alias" => "학문", "desc" => "학문 분야 구분" ], "9" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%모드%' group by a.no order by a.word", "title" => "모드 리스트", "alias" => "모드", "desc" => "( mode )" ], "10" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%함수' group by a.no order by a.word", "title" => "함수 리스트", "alias" => "함수", "desc" => "( function )" ], "11" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%율' or a.word like '%률' or a.word like '%비') and not (a.word like '%효율' or a.word like '%확률' or a.word like '%적률' or a.word like '%법률' or a.word like '%일률' or a.word like '%능률' or a.word like '%설비' or a.word like '%장비' or a.word like '%좀비' or a.word like '%유지비' or a.word like '%공사비' or a.word like '%상각비' or a.word like '%지그비') group by a.no order by a.word", "title" => "율/률/비 리스트", "alias" => "율/률/비", "desc" => "( ratio/proportion/rate fraction percentage concentration )" ], "12" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%상수' or a.word like '%정수') group by a.no order by a.word", "title" => "정수/상수 리스트", "alias" => "정수/상수", "desc" => "( constant )" ], "13" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where ((a.word like '%인수') or (a.word like '%인자') or (a.word like '%인수 분해') or (a.word like '% factor')) and not (a.word like '%라인수' or a.word like '%합병 인수' or a.word like '%품질 인자') group by a.no order by a.word", "title" => "인수/인자,율/률 (factor) 리스트", "alias" => "인자(factor)", "desc" => "( factor )" ], "14" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%계수') group by a.no order by a.word", "title" => "계수 리스트", "alias" => "계수(coefficient)", "desc" => "( coefficient )" ], "15" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%order%') and (a.word like '%zero%' or a.word like '%first%' or a.word like '%second%' or a.word like '%tree%' or a.word like '%equation%') and not (a.word like '%byte%' or a.word like '%ordered%') group by a.no order by a.word", "title" => "차수/계수 (order) 리스트", "alias" => "계수(order)", "desc" => "( order )" ], "16" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%degree%') group by a.no order by a.word", "title" => "차수/계수 (degree) 리스트", "alias" => "차수(degree)", "desc" => "( degree )" ], "17" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%밀도%') and not (a.word like '%정밀도%') group by a.no order by a.word", "title" => "밀도 (density) 리스트", "alias" => "밀도", "desc" => "( density )" ], "18" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%에너지%') group by a.no order by a.word", "title" => "에너지 리스트", "alias" => "에너지", "desc" => "( energy )" ], "19" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%전력%') and not (a.word like '%회전력%') group by a.no order by a.word", "title" => "전력 리스트", "alias" => "전력", "desc" => "( power )" ], "20" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%속도' or a.word like '%속도 벡터' or a.word like '%속도장' or a.word like '%속도계' or a.word like '%광속 불변%') group by a.no order by a.word", "title" => "속도 리스트", "alias" => "속도", "desc" => "( velocity )" ], "21" => [ "query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where concat(',',full_name,',',extra_keyword,',') like '%field,%' and concat(',',full_name,',',korean,',',extra_keyword,',') like '%장,%' group by a.no order by a.word", "title" => "장(場) 리스트", "alias" => "장(場)", "desc" => "( field )" ] ]; } # function special_title_display() { $title_arr = choice_v2(); for($i=1; $i<=12; $i++){ echo "<a href='/test/search/special_srch.php?ch={$i}' data-ch='{$i}' class='special'>"; echo $title_arr[$i]['alias']; echo "</a> " ."\n"; } echo "<br><br>"; for($i=13; $i<count($title_arr); $i++){ echo "<a href='/test/search/special_srch.php?ch={$i}' data-ch='{$i}' class='special'>"; echo $title_arr[$i]['alias']; echo "</a> " ."\n"; } } ?>