$val) { if (in_array($key, $var_list)) { $$key = $val; } else { unset($$key); } } } //¥»¥Ã¥·¥ç¥ó¤ËPOST¤µ¤ì¤¿¥Ç¡¼¥¿¤ò¥¨¥¹¥±¡¼¥×½èÍý¤·¤Ä¤ÄÅÐÏ¿¤¹¤ë¡£ //¶õ¤¸¤ã¤Ê¤¤¾ì¹ç¤Î¤ßstr_safe´Ø¿ô¤ò $_SESSION["jobs"] = str_safe($jobs); $_SESSION["empsys"] = str_safe($empsys); $_SESSION["faform"] = str_safe($faform); $_SESSION["pref"] = str_safe($pref); $_SESSION["dcode"] = str_safe($dcode); $_SESSION["pref2"] = str_safe($pref2); $_SESSION["dcode2"] = str_safe($dcode2); $_SESSION["pref3"] = str_safe($pref3); $_SESSION["dcode3"] = str_safe($dcode3); $_SESSION["lpref"] = str_safe($lpref); $_SESSION["lcode"] = str_safe($lcode); $_SESSION["stcode"] = str_safe($stcode); $_SESSION["bcharge"] = str_safe($bcharge); $_SESSION["fword"] = str_safe($fword); $_SESSION["nofword"] = str_safe($nofword); $_SESSION["jyusyo"] = str_safe($jyusyo); $_SESSION["in_tgyomu1"] = str_safe($in_tgyomu1); $_SESSION["in_tgyomu2"] = str_safe($in_tgyomu2); $_SESSION["in_tgyomu3"] = str_safe($in_tgyomu3); $_SESSION["in_tgyomu4"] = str_safe($in_tgyomu4); $_SESSION["in_tgyomu5"] = str_safe($in_tgyomu5); $_SESSION["in_tgyomu6"] = str_safe($in_tgyomu6); $_SESSION["in_tgyomu7"] = str_safe($in_tgyomu7); $_SESSION["in_tgyomu8"] = str_safe($in_tgyomu8); $_SESSION["in_tgyomu9"] = str_safe($in_tgyomu9); $_SESSION["in_tgyomu10"] = str_safe($in_tgyomu10); $_SESSION["in_tgyomu11"] = str_safe($in_tgyomu11); $_SESSION["te_segment1"] = str_safe($te_segment1); $_SESSION["te_segment2"] = str_safe($te_segment2); $_SESSION["te_segment3"] = str_safe($te_segment3); $_SESSION["te_segment4"] = str_safe($te_segment4); $_SESSION["te_segment5"] = str_safe($te_segment5); $_SESSION["te_segment6"] = str_safe($te_segment6); $_SESSION["te_segment7"] = str_safe($te_segment7); $_SESSION["te_segment8"] = str_safe($te_segment8); $_SESSION["te_segment9"] = str_safe($te_segment9); $_SESSION["te_segment10"] = str_safe($te_segment10); $_SESSION["te_segment11"] = str_safe($te_segment11); $_SESSION["te_segment12"] = str_safe($te_segment12); $_SESSION["te_segment13"] = str_safe($te_segment13); $_SESSION["te_segment14"] = str_safe($te_segment14); $_SESSION["te_segment15"] = str_safe($te_segment15); $_SESSION["te_segment16"] = str_safe($te_segment16); $_SESSION["te_segment17"] = str_safe($te_segment17); $_SESSION["te_segment18"] = str_safe($te_segment18); $_SESSION["te_segment19"] = str_safe($te_segment19); $_SESSION["te_segment20"] = str_safe($te_segment20); $_SESSION["te_segment21"] = str_safe($te_segment21); $_SESSION["te_segment22"] = str_safe($te_segment22); $_SESSION["te_segment23"] = str_safe($te_segment23); $_SESSION["te_segment24"] = str_safe($te_segment24); $_SESSION["te_segment25"] = str_safe($te_segment25); $_SESSION["te_segment26"] = str_safe($te_segment26); $_SESSION["te_segment27"] = str_safe($te_segment27); $_SESSION["te_otherCon"] = str_safe($otherCon); $_SESSION["kkhaichi"] = str_safe($kkhaichi); //Îãʸ¥Á¥§¥Ã¥¯ Îãʸ¤¬Æþ¤Ã¤Æ¤¤¤¿¾ì¹ç¶õÇò¤Ë $fowrdEX = "Î㡧Âçºå¡¡Àµ´Ç¸î»Õ"; if(mbereg($fowrdEX,$fword)){ $fword = ""; $_SESSION["fword"] = ""; } //¥Õ¥ê¡¼¥ï¡¼¥É¤òÇÒ¼Ú $find_str = $fword; $nofind_str = $nofword; /* * PageÍÑ * intval(var ¤Î integer ¤È¤·¤Æ¤ÎÃͤòÊÖ¤·¤Þ¤¹¡£) */ $p = intval($p); if ($p <1) { $p = 1; } if(!empty($_GET['fword'])){ $fword = urldecode($fword); } /* ** modeÊä´° */ //»È¤Ã¤Æ¤ë·ÁÀפ¬¸«¤ì¤Ê¤¤¤Î¤Ç¥³¥á¥ó¥È¥¢¥¦¥È 20110225 byÀÐÁÒ //if($lnk==1) $mode = "list_access"; /* * mode¤Ë¤è¤ë½èÍý¿¶¤êʬ¤± * ¥µ¡¼¥Á·ë²Ì¡¦¥ê¥¹¥Èɽ¼¨ */ switch($mode) { case "list_access": // ¶Ð̳¸¡º÷ÍÑ /******************************** ** ±èÀþ¥Ç¡¼¥¿¤ò¼èÆÀ *********************************/ // ¥³¥Í¥¯¥È $dbc = new dbConnect; //EUC-JP¤ò»È¤¨¤ë¤è¤¦¤Ë $sql_enc = "SET NAMES ujis"; $rs_enc = $dbc->doQuery($sql_enc); //¼¢²ì¡½Ï²λ³¤Î±èÀþ¥Ç¡¼¥¿¼èÆÀ $sql = "SELECT pk_id_trainid, cd_prefcode, cd_linecode, cd_stationcode, nm_linename, nm_stationname, flg_del, etc_sonota FROM tbs_train WHERE flg_del = 0 AND cd_prefcode BETWEEN 25 AND 30 ORDER BY cd_prefcode, cd_linecode DESC"; // ¼Â¹Ô $rs = $dbc->doQuery($sql); // ¸¡º÷·ë²Ì¥Ç¡¼¥¿ // pg_fetch_row¤Ë¤Æ¿ô»ú¤ò¥¤¥ó¥Ç¥Ã¥¯¥¹¤È¤¹¤ëÇÛÎó¤È¤·¤Æ¹Ô¤òÆÀ¤ë while ($rec = mysqli_fetch_array($rs)) { $in_trainid = $rec[0]; // ±èÀþID $in_prefcode[$in_trainid] = $rec[1]; // ÅÔÆ»Éܸ©¥³¡¼¥É $in_linecode[$in_trainid] = $rec[2]; // ±èÀþ¥³¡¼¥É $in_stationcode[$in_trainid] = $rec[3]; // ±Ø¥³¡¼¥É $te_linename[$in_trainid] = $rec[4]; // ±èÀþ̾ $te_stationname[$in_trainid] = $rec[5]; // ±Ø̾ $in_delflg[$in_trainid] = $rec[6]; // ºï½ü¥Õ¥é¥° $te_sonota[$in_trainid] = $rec[7]; // ¤½¤Î¾ } // ¸½ºß¤Îɽ¼¨¥ì¥³¡¼¥É·ï¿ô // pg_num_row PostgreSQL¤Î·ë²Ì¥ê¥½¡¼¥¹¤Î¹Ô¿ô¤òÊÖ¤¹¡£ $rec_num_now = mysql_num_rows($rs); // ¥á¥â¥ê¤ò³«Êü mysqli_free_result($rs); //ÅÔÆ»Éܸ©Ê¬ÁªÂòÍóʸÀ¸À® $line_select .= ''; $station_select .= ''; $line_select .= ''; $line_select .= ''; $line_select .= ''; $line_select .= ''; $line_select .= ''; $line_select .= ''; foreach($in_prefcode as $num => $value){ //°ì²óÀ¸À®¤µ¤ì¤¿Ï©Àþ¤ÏµÑ²¼ if($tmp_code != $in_linecode[$num]){ // ÅϤµ¤ì¤¿lcode¤È°ìÃפ¹¤ì¤Ð"selected" if($in_linecode[$num].$value == $lcode ){ $selectmark = 'selected = "selected"'; //ÍúÎò¥µ¥Ö¥á¥Ë¥å¡¼¤Ø // (°Ê²¼¤Ï½üµî //$sublcode = substr($te_linename[$num], 0, strrchr($te_linename[$num], '(')); $subdisplname1 = $te_linename[$num]; }else{ $selectmark = ""; } //±èÀþ¥³¡¼¥ÉÀ¸À® $line_select .= ''; $tmp_code = $in_linecode[$num]; } // ÅϤµ¤ì¤¿lcode¤È°ìÃפ¹¤ì¤Ð"selected" if($in_linecode[$num].$value == $lcode && $in_stationcode[$num] == $stcode){ $selectmark = 'selected = "selected"'; //ÍúÎò¥µ¥Ö¥á¥Ë¥å¡¼¤Ø $subdispstname1 = $te_stationname[$num]; }else{ $selectmark = ""; } // Ï©ÀþÊ̥ǥե©¥ë¥È¤Ë¡ÖÁªÂò¤·¤Æ²¼¤µ¤¤¡£¡×¤òÀ¸À® value=""¤ò»ØÄꤹ¤ë¤È¡Öselected¡×¤¬¸ú¤«¤Ê¤¤¤Î¤Ç³°¤¹ // value¤Ë¡ÖÁªÂò¤·¤Æ¤¯¤À¤µ¤¤¡£¡×¤¬Æþ¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢¤¢¤È¤ÇÃÖ´¹ if($tmp_code2 != $in_linecode[$num]){ $station_select .= ""; $tmp_code2 = $in_linecode[$num]; } //±Ø¥³¡¼¥ÉÀ¸À® $station_select .= ''; } // ¶Ð̳ÃÏ­¢¡¡¶Ð̳ÃÏ­£¤ËÆþÎϤ¬¤¢¤ì¤Ð¹àÌܤòɽ¼¨¤¹¤ë if(strlen($pref2) || strlen($dcode2) || strlen($pref3) || strlen($dcode3)){ $disp1 = "none"; $disp2 = "block"; } //ÁªÂò¤·¤Æ¤¯¤À¤µ¤¤¡£¤òÃÖ´¹ if(!is_numeric($stcode)){ $stcode = ""; } if(!empty($find_str)){ $find_str = urlencode($find_str); $find_str = urldecode($find_str); } //$find_str = mb_convert_encoding($find_str, "EUC-JP", "SJIS"); if(!empty($nofind_str)){ $nofind_str = urlencode($nofind_str); $nofind_str = urldecode($nofind_str); } //¥Ñ¥é¥á¡¼¥¿Ìµ³²²½ if (isset($find_str)) { $find_str = str_safe($find_str); $nofind_str = str_safe($nofind_str); } // ɽ¼¨³«»Ï¥ì¥³¡¼¥É if(strlen($s)) { $rec_start = $s; $st = $s; } else { $rec_start = 0; $st = 0; } $rec_start_view = $rec_start + 1; // ¥ì¥³¡¼¥Éɽ¼¨¿ô(º£¤Î¤È¤³¤í20·ï) if(strlen($d)) { $rec_disp = $d; } else { $rec_disp = 20; } //¥Ú¡¼¥¸ÈÖ¹æÍÑ $prev = $p - 1; if($prev < 1) { $prev = 1; } $next = $p + 1; /* ** SQL InjectionÂкö ** ¥¯¥¨¥êÀ¸À®Á°¥¨¥¹¥±¡¼¥×½èÍý */ $rec_start = pg_escape_string($rec_start);//ľÁ°¤Ë¥¨¥¹¥±¡¼¥×½èÍý $rec_disp = pg_escape_string($rec_disp);//ľÁ°¤Ë¥¨¥¹¥±¡¼¥×½èÍý $dcode = pg_escape_string($dcode);//ľÁ°¤Ë¥¨¥¹¥±¡¼¥×½èÍý $pref = pg_escape_string($pref);//ľÁ°¤Ë¥¨¥¹¥±¡¼¥×½èÍý //pref¤òÁª¤ó¤Ç¤«¤é¡Ö´ØÀ¾Á´°è¡×¤ËÌ᤹¤ÈdcodeÆâ¤Ë"0"¤¬Æþ¤ë¤Î¤ÇnullÊä´° if($dcode == 0){ $dcode = ""; } if($dcode2 == 0){ $dcode2 = ""; } if($dcode3 == 0){ $dcode3 = ""; } /*************************************** ** ¶Ð̳ÃÏ£±¡¦£²¡¦£³ ** Ãͤ¬¤¢¤ë¤â¤Î¤À¤±¼èÆÀ¤¹¤ë ****************************************/ //¸¡º÷ÍѤ˻ԶèĮ¼¥³¡¼¥É¤«¤é¼èÆÀ //»Ô¶èĮ¼ if(strlen($dcode)){ //»Ô¶èĮ¼ÍÑSQL $sql = "SELECT pk_code, te_name FROM mt_pref WHERE pk_code = '" . pg_escape_string($dcode) . "' "; //¥¯¥¨¥ê¼Â¹Ô $rs = $dbc->doQuery($sql); // ¸¡º÷·ë²Ì¥Ç¡¼¥¿ // pg_fetch_row¤Ë¤Æ¿ô»ú¤ò¥¤¥ó¥Ç¥Ã¥¯¥¹¤È¤¹¤ëÇÛÎó¤È¤·¤Æ¹Ô¤òÆÀ¤ë while ($rec = mysqli_fetch_array($rs)) { $pk_code = $rec[0]; // ÃÄÂÎ¥³¡¼¥É $prName = $rec[1]; // »Ô¶èĮ¼̾ } // ¥á¥â¥ê¤ò³«Êü mysqli_free_result($rs); } if(strlen($dcode2)){ //»Ô¶èĮ¼ÍÑSQL $sql2 = "SELECT pk_code, te_name FROM mt_pref WHERE pk_code = '" . pg_escape_string($dcode2) . "' "; //¥¯¥¨¥ê¼Â¹Ô $rs2 = $dbc->doQuery($sql2); // ¸¡º÷·ë²Ì¥Ç¡¼¥¿ // pg_fetch_row¤Ë¤Æ¿ô»ú¤ò¥¤¥ó¥Ç¥Ã¥¯¥¹¤È¤¹¤ëÇÛÎó¤È¤·¤Æ¹Ô¤òÆÀ¤ë while ($rec2 = mysqli_fetch_array($rs2)) { $pk_code2 = $rec2[0]; // ÃÄÂÎ¥³¡¼¥É $prName2 = $rec2[1]; // »Ô¶èĮ¼̾ } // ¥á¥â¥ê¤ò³«Êü mysqli_free_result($rs2); } if(strlen($dcode3)){ //»Ô¶èĮ¼ÍÑSQL $sql3 = "SELECT pk_code, te_name FROM mt_pref WHERE pk_code = '" . pg_escape_string($dcode3) . "' "; //¥¯¥¨¥ê¼Â¹Ô $rs3 = $dbc->doQuery($sql3); // ¸¡º÷·ë²Ì¥Ç¡¼¥¿ // pg_fetch_row¤Ë¤Æ¿ô»ú¤ò¥¤¥ó¥Ç¥Ã¥¯¥¹¤È¤¹¤ëÇÛÎó¤È¤·¤Æ¹Ô¤òÆÀ¤ë while ($rec3 = mysqli_fetch_array($rs3)) { $pk_code3 = $rec3[0]; // ÃÄÂÎ¥³¡¼¥É $prName3 = $rec3[1]; // »Ô¶èĮ¼̾ } // ¥á¥â¥ê¤ò³«Êü mysqli_free_result($rs3); } //±èÀþ¥³¡¼¥É¤ÎÀ°·Á $lcode = substr($lcode, 0, 5); // ¸¡º÷ÍѤÎSQLʸ¹½ÃÛ //ɱ¡Ã±°Ì¤Çɽ¼¨¤¹¤ë¤Î¤ËÊѹ¹¡¢¤µ¤é¤Ë¹¹¿·¡¡by À¾Â¼ 20100310 //ɱ¡Ã±°Ì¤Ä¤«"DISTINCT"¤Ï½ÅÊ£¥Ç¡¼¥¿¹Ô¤òÇÓ½ü¤·¤Æ°ì¤Ä¤ËÅ»¤á¤Æ¤¯¤ì¤ó¤À¤±¤É¤Í¡£ //¤Ê¤Î¤Çpk_csystemid¤ò¥­¡¼¤Ë»ý¤Ã¤Æ¤¯¤ë¤È¶Ð̳¥ì¥³¡¼¥É¤Î°ì¹Ô¤·¤«¼è¤ê½Ð¤»¤Ê¤¤¡£ //¤³¤Î¥·¥¹¥Æ¥à¤Ë¤Ï°ÕÌ£¤Î̵¤¤½èÍý¤À¤«¤é¥Ð¥Ã¥¯¥¢¥Ã¥×¥Õ¥¡¥¤¥ë¤Îµ­½Ò¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£20100405 //in_tgyomu1-11¤âɽ¼¨¤¹¤ë¤Î¤Ç¡¢SELECT¤ËÄɲᣡ¡by À¾Â¼ 20100428 $sql = "SELECT K.in_kinmuid, K.te_catchcopy, B.te_byoinmei, K.te_kikan, K.te_kinmuti, K.te_moyorieki, K.te_maintitle, K.te_bodycopy, K.te_gazo1, K.te_segment1, K.te_segment2, K.te_segment3, K.te_segment4, K.te_segment5, K.te_segment6, K.te_segment7, K.te_segment8, K.te_segment9, K.te_segment10, K.te_segment11, K.te_segment12, K.te_segment13, K.te_segment14, K.te_segment15, K.te_segment16, K.te_segment17, K.te_segment18, K.te_segment19, K.te_segment20, K.te_segment21, K.te_segment22, K.te_segment23, K.te_segment24, K.in_syokusyu3, K.in_koyokbn9, K.te_kinmu,K. te_kyujitu, K.fl_hosyukin, K.in_byoinid, K.in_tgyomu1, K.in_tgyomu2, K.in_tgyomu3, K.in_tgyomu4, K.in_tgyomu5, K.in_tgyomu6, K.in_tgyomu7, K.in_tgyomu8, K.in_tgyomu9, K.in_tgyomu10, K.in_tgyomu11, B.te_todohuken, B.te_kangotaikei, B.te_gurupu, B.te_byoinsyu, K.te_segment25, K.te_segment26, K.te_segment27, K.in_hideflg FROM k_kisok as K, b_kiso as B WHERE B.in_byoinid = K.in_byoinid AND B.in_delflag = 0 AND K.in_delflg = 0 AND K.in_todofuken BETWEEN '25' AND '30' AND SUBSTRING(K.in_campaign, 9, 1) = 1 "; //------------------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------------------- //-------------¤³¤³¤«¤é£Ð£Ï£Ó£Ô¥Ç¡¼¥¿¤Ë¤è¤ëSQLʬ¤òºîÀ® //------------------------------------------------------------------------------------------------------- //------------------------------------------------------------------------------------------------------- //¾ò·ïʸ¤¬ºÇ½é¤ËÄɲ䵤줿¾ì¹ç¤ÎȽÃǥե饰 $first_flg = 0; //¶Ð̳ÃÏÁªÂò¥Õ¥é¥° $kinmuchiflg = 0; /*********************************** ** ½»½ê£± ************************************/ // ÅÔÆ»Éܸ©¡¦»Ô¶èĮ¼¶¦¤Ë¤¢¤ë¾ì¹ç if(strlen($pref) && strlen($prName) && substr($dcode, -4) != "0000" && $pref != 48){ //½é¤Ãü¥Õ¥é¥°¤¬Î©¤Ã¤Æ¤¤¤Ê¤±¤ì¤ÐΩ¤Æ¤ë if($first_flg == 0){ $sql .= " AND ( ( "; $first_flg = 1; }else{ $sql .= " OR ("; } $sql .= "B.te_todohuken LIKE '%".$arypref[$pref-25]."%' AND B.te_shikutyoson LIKE '%" .pg_escape_string($prName)."%' )"; $kinmuchiflg = 1; }elseif(strlen($pref) && !strlen($prName) && $pref != 48){ //ÅÔÆ»Éܸ©¤Î¤ß¤Î¾ì¹ç //½é¤Ãü¥Õ¥é¥°¤¬Î©¤Ã¤Æ¤¤¤Ê¤±¤ì¤ÐΩ¤Æ¤ë if($first_flg == 0){ $sql .= " AND ( "; $first_flg = 1; }else{ $sql .= " OR "; } $sql .= "B.te_todohuken LIKE '%".$arypref[$pref-25]."%' "; $kinmuchiflg = 1; } /*********************************** ** ½»½ê£² ************************************/ // ÅÔÆ»Éܸ©¡¦»Ô¶èĮ¼¶¦¤Ë¤¢¤ë¾ì¹ç if(strlen($pref2) && strlen($prName2) && substr($dcode2, -4) != "0000" && $pref2 != 48){ //½é¤Ãü¥Õ¥é¥°¤¬Î©¤Ã¤Æ¤¤¤Ê¤±¤ì¤ÐΩ¤Æ¤ë if($first_flg == 0){ $sql .= " AND ( ( "; $first_flg = 1; }else{ $sql .= " OR ("; } $sql .= "B.te_todohuken LIKE '%".$arypref[$pref2-25]."%' AND B.te_shikutyoson LIKE '%" .pg_escape_string($prName2)."%' )"; $kinmuchiflg = 1; }elseif(strlen($pref2) && !strlen($prName2) && $pref2 != 48){ //ÅÔÆ»Éܸ©¤Î¤ß¤Î¾ì¹ç //½é¤Ãü¥Õ¥é¥°¤¬Î©¤Ã¤Æ¤¤¤Ê¤±¤ì¤ÐΩ¤Æ¤ë if($first_flg == 0){ $sql .= " AND ( "; $first_flg = 1; }else{ $sql .= " OR "; } $sql .= "B.te_todohuken LIKE '%".$arypref[$pref2-25]."%' "; $kinmuchiflg = 1; } /*********************************** ** ½»½ê£³ ************************************/ // ÅÔÆ»Éܸ©¡¦»Ô¶èĮ¼¶¦¤Ë¤¢¤ë¾ì¹ç if(strlen($pref3) && strlen($prName3) && substr($dcode3, -4) != "0000" && $pref3 != 48){ //½é¤Ãü¥Õ¥é¥°¤¬Î©¤Ã¤Æ¤¤¤Ê¤±¤ì¤ÐΩ¤Æ¤ë if($first_flg == 0){ $sql .= " AND ( ( "; $first_flg = 1; }else{ $sql .= " OR ("; } $sql .= "B.te_todohuken LIKE '%".$arypref[$pref3-25]."%' AND B.te_shikutyoson LIKE '%" .pg_escape_string($prName3)."%' )"; $kinmuchiflg = 1; }elseif(strlen($pref3) && !strlen($prName3) && $pref3 != 48){ //ÅÔÆ»Éܸ©¤Î¤ß¤Î¾ì¹ç //½é¤Ãü¥Õ¥é¥°¤¬Î©¤Ã¤Æ¤¤¤Ê¤±¤ì¤ÐΩ¤Æ¤ë if($first_flg == 0){ $sql .= " AND ( "; $first_flg = 1; }else{ $sql .= " OR "; } $sql .= "B.te_todohuken LIKE '%".$arypref[$pref3-25]."%' "; $kinmuchiflg = 1; } if($kinmuchiflg == 0) { /*********************************** ** ±èÀþ ************************************/ // ±Ø̾¤Þ¤ÇÍ­¤ë¾ì¹ç(ÅÔÆ»Éܸ©¡¦±èÀþ¡¦±Ø̾) if(strlen($lpref) && strlen($lcode) && strlen($stcode)){ // ±Ø¥³¡¼¥É¤À¤±Ä´¤Ù¤ë $sql .= "AND (K.in_stationcode1 = ".$stcode." OR K.in_stationcode2 = ".$stcode." OR K.in_stationcode3 = ".$stcode." OR K.in_stationcode4 = ".$stcode.")"; }elseif(strlen($lpref) && strlen($lcode) && !strlen($stcode)){ //ÅÔÆ»Éܸ©¡¦±èÀþ¤Î¾ì¹ç $sql .= "AND (K.in_linecode1 = ".$lcode." OR K.in_linecode2 = ".$lcode." OR K.in_linecode3 = ".$lcode." OR K.in_linecode4 = ".$lcode.")"; } }else{ $sql .= ")"; } //¿¦¼ï if(!empty($jobs)) { $sql .= "AND K.in_syokusyu3 ='" .pg_escape_string($jobs). "'"; } //¸ÛÍѶèʬ if(!empty($empsys)) { $sql .= "AND K.in_koyokbn9 ='" .pg_escape_string($empsys). "'"; } //»ÜÀß·ÁÂÖ if(!empty($faform)){ $sql .= "AND K.te_shisetsu ='" .pg_escape_string($faform). "'"; } //---------------------------------- //¸ÛÍѶèʬÍÑ // $in_tgyomu[] //---------------------------------- /* ANDÆâOR¸¡º÷¢ªAND¸¡º÷¤Î¹Ê¹þ¤Ë¤·¤Þ¤·¤¿¡¡by À¾Â¼20100310 // ½èÍýÆâÍƤϲáµî¥í¥°¥Õ¥¡¥¤¥ë¤Ë byUe20100405 */ $array_tgyomu = array($in_tgyomu1, $in_tgyomu2, $in_tgyomu3, $in_tgyomu4, $in_tgyomu5, $in_tgyomu6, $in_tgyomu7, $in_tgyomu8, $in_tgyomu9, $in_tgyomu10, $in_tgyomu11); $count = 0; foreach($array_tgyomu as $num => $value){ //¶õ¤¸¤ã¤Ê¤±¤ì¤Ð if(!empty($value)){ $count = $num + 1; $sql .= "AND K.in_tgyomu".$count." = '" . pg_escape_string($value) . "' "; } } //---------------------------------- //ôÅö¶È̳&¤½¤Î¾¾ò·ïÍÑ on off¥Á¥§¥Ã¥¯¤ÈSQL //---------------------------------- $array_seg = array($te_segment1, $te_segment2, $te_segment3, $te_segment4, $te_segment5, $te_segment6, $te_segment7, $te_segment8, $te_segment9, $te_segment10, $te_segment11, $te_segment12, $te_segment13, $te_segment14, $te_segment15, $te_segment16, $te_segment17, $te_segment18, $te_segment19, $te_segment20); $count = 0; foreach($array_seg as $num => $value){ //¶õ¤¸¤ã¤Ê¤±¤ì¤Ð if(!empty($value)){ $count = $num + 1; $sql .= "AND K.te_segment".$count." = '" . pg_escape_string($value) . "' "; } } //---------------------------------- //ôÅö¶È̳&¤½¤Î¾¾ò·ïÍÑ ÄɲÃʬ¥»¥°¥á¥ó¥È //---------------------------------- $array_seg = array("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", $te_segment25, $te_segment26, $te_segment27); $count = 0; foreach($array_seg as $num => $value){ //¶õ¤¸¤ã¤Ê¤±¤ì¤Ð if(!empty($value)){ $count = $num + 1; $sql .= "AND K.te_segment".$count." = '" . pg_escape_string($value) . "' "; } } //-------------------------------------------Ê£¿ô¥ï¡¼¥É¸¡º÷ // Ê£¿ô¥ï¡¼¥É¸¡º÷SQL·ÁÀ® // B.te_byoinmei,K.te_maintitle,K.te_worknaiyo,K.te_kinmuti, // K.te_taigu,K.te_catchcopy,K.te_bodycopy,K.te_moyorieki //-------------------------------------------Ê£¿ô¥ï¡¼¥É¸¡º÷ if(!empty($find_str)){//Æþ¤Ã¤Æ¤¿¤é¤Î½èÍý¤Ç¤¤¤¤¤Ç¤·¤çJK if(preg_match("/[ |¡¡]+/", $find_str, $strNum)){//Ⱦ³Ñ¡¢Á´³Ñ¶õÇò¤¬2ʸ»ú°Ê¾åϢ³¤Ç³¤¤¤Æ¤¿¤é $find_str = mb_convert_kana($find_str,"s","EUC-JP"); $keywd = trim(preg_replace('/[\s]+/',' ',$find_str)); $keywd = explode(" ",$keywd);//Ⱦ³Ñ¥¹¥Ú¡¼¥¹¶èÀÚ¤ê¤ÇÇÛÎó¤Ë³ÊǼ }else{//¤½¤¦¤Ç¤Ê¤«¤Ã¤¿¤é(Ê£¿ô¸ì¸¡º÷¤Ç¤Ï¤Ê¤¤) $keywd[0] = $find_str;//ʸ»úÎó¤ò¤½¤Î¤Þ¤Þ$keywd¤ËÂåÆþ } //------------------------------------------¢§¢§ //FROM b_kiso as B, k_kiso as K //------------------------------------------¢§¢§ //te_syamei foreach($keywd as $syamei){ if($syamei != ""){ //$skwd[] = " C.te_syamei LIKE '%" .pg_escape_string($syamei)."%' ";//C.te_syamei¥«¥é¥à¤«¤éõ¤¹Likeʸ¤òÀ¸À® //$skwd[] = " C.te_syamei LIKE '%" .pg_escape_string($syamei)."%' "; //b_kiso¤Ë¤Ê¤ê¥«¥é¥à̾¤¬ÊѤï¤Ã¤¿¤Î¤Ç½¤Àµ $skwd[] = " B.te_byoinmei LIKE '%" .pg_escape_string($syamei)."%' "; } } //te_maintitle foreach($keywd as $mtitle){ if($mtitle != ""){ //$mkwd[] = " B.te_maintitle LIKE '%" .pg_escape_string($mtitle)."%' ";//B.te_maintitle¥«¥é¥à¤«¤éõ¤¹Likeʸ¤òÀ¸À® $mkwd[] = " K.te_maintitle LIKE '%" .pg_escape_string($mtitle)."%' "; } } //te_worknaiyo foreach($keywd as $wnaiyou){ if($wnaiyou != ""){ $wkwd[] = " K.te_worknaiyo LIKE '%" .pg_escape_string($wnaiyou)."%' "; } } //te_kinmuti foreach($keywd as $kim){ if($kim != ""){ $kkwd[] = " K.te_kinmuti LIKE '%" .pg_escape_string($kim)."%' "; } } //te_taigu foreach($keywd as $taigu){ if($taigu != ""){ $tkwd[] = " K.te_taigu LIKE '%" .pg_escape_string($taigu)."%' "; } } //te_catchcopy foreach($keywd as $catch){ if($catch != ""){ $ckwd[] = " K.te_catchcopy LIKE '%" .pg_escape_string($catch)."%' "; } } //te_bodycopy foreach($keywd as $te_bcopy){ if($te_bcopy != ""){ $bkwd[] = " K.te_bodycopy LIKE '%" .pg_escape_string($te_bcopy)."%' "; } } //te_moyorieki foreach($keywd as $moyoriEki){ if($moyoriEki != ""){//¥­¡¼¥ï¡¼¥É¤¬Ì¤»ØÄê¤Ç¤Ê¤«¤Ã¤¿¤é $mekwd[] = " K.te_moyorieki LIKE '%" .pg_escape_string($moyoriEki)."%' "; } } $sql .= " AND ("; //if($find_str != ""){//¸¡º÷¸ì¤¬¶õ¤Ç¤Ê¤¯ if(count($skwd) > 0 && count($mkwd) > 0 && count($wkwd) > 0 //if(count($mkwd) > 0 && count($wkwd) > 0 && count($kkwd) > 0 && count($tkwd) > 0 && count($ckwd) > 0 && count($bkwd) > 0 && count($mekwd) > 0){//¸¡º÷¥ï¡¼¥É¤¬0¸Ä¤Ç¤Ê¤±¤ì¤Ð $sql .= implode("or",$skwd)." or "; $sql .= implode("or",$mkwd)." or "; $sql .= implode("or",$wkwd)." or "; $sql .= implode("or",$kkwd)." or "; $sql .= implode("or",$tkwd)." or "; $sql .= implode("or",$ckwd)." or "; $sql .= implode("or",$bkwd)." or "; $sql .= implode("or",$mekwd);//and¤ÇÇÛÎó¤ÎÍ×ÁǤò·ë¹ç(Îã:byoinmei LIKE '%Âçºå%' AND title LIKE '%Ë̶è%') } $sql .= " )"; //} } /************************************************ ** ¸¡º÷¾ò·ï¤ò¥µ¥Ö¥á¥Ë¥å¡¼¾å¤Ë¥Õ¥í¡¼¥Èɽ¼¨¤¹¤ë ** ½èÍý¡¡¡¡°ì¤Ä¤Ç¤âÆþÎϤ¬¤¢¤ì¤Ð¥Õ¥í¡¼¥È¤ò·ÁÀ®¤¹¤ë *************************************************/ if(strlen($jobs) || strlen($empsys) || strlen($faform) || strlen($pref) || strlen($dcode) || strlen($pref2) || strlen($dcode2) || strlen($pref3) || strlen($dcode3) || strlen($lcode) || strlen($stcode) || strlen($bcharge) || strlen($jyusyo) || strlen($in_tgyomu1) || strlen($in_tgyomu2) || strlen($in_tgyomu3) || strlen($in_tgyomu4) || strlen($in_tgyomu5) || strlen($in_tgyomu6) || strlen($in_tgyomu7) || strlen($in_tgyomu8) || strlen($in_tgyomu9) || strlen($in_tgyomu10) || strlen($in_tgyomu11) || strlen($te_segment1) || strlen($te_segment2) || strlen($te_segment3) || strlen($te_segment4) || strlen($te_segment5) || strlen($te_segment6) || strlen($te_segment7) || strlen($te_segment8) || strlen($te_segment9) || strlen($te_segment10) || strlen($te_segment11) || strlen($te_segment12) || strlen($te_segment13) || strlen($te_segment14) || strlen($te_segment15) || strlen($te_segment16) || strlen($te_segment17) || strlen($te_segment18) || strlen($te_segment19) || strlen($te_segment20) || strlen($te_segment21) || strlen($te_segment22) || strlen($te_segment23) || strlen($te_segment24) || strlen($te_segment25) || strlen($te_segment26) || strlen($te_segment27)) { // ÍúÎòÍѥơ¼¥Ö¥ë $subsearchForm = '
'; /******************************* ** ÍúÎò¥µ¥Ö¥á¥Ë¥å¡¼ÍѤËÀ°·Á ********************************/ //¿¦¼ï if(strlen($jobs)){ $subsearchForm .= ''; } //¸ÛÍÑ·ÁÂÖ if(strlen($empsys)){ $subsearchForm .= ''; } //»ÜÀß·ÁÂÖ if(strlen($faform)){ $subsearchForm .= ''; } //¶Ð̳ÃÏ£± if(strlen($pref) && $pref != 48){ $subsearchForm .= ''; } //¶Ð̳ÃÏ£² if(strlen($pref2) && $pref2 != 48){ $subsearchForm .= ''; } //¶Ð̳ÃÏ£³ if(strlen($pref3) && $pref3 != 48){ $subsearchForm .= ''; } //±èÀþ if(strlen($lcode) || strlen($stcode)){ //¶èʬ¥¿¥¤¥È¥ë $subsearchForm .= ''; //±èÀþ̾ if(strlen($lcode)){ $subsearchForm .= ""; } } //////////////////////////////////// // ¶Ð̳·ÁÂÖ //////////////////////////////////// if(intval($te_segment1)===1 || intval($te_segment2)===1 || intval($te_segment4)===1 || intval($te_segment5)===1 || intval($te_segment25)===1 ){ //2¸òÂå¶Ð̳ if(intval($te_segment1) === 1){ $kinmuwords .= "¡¦2¸òÂå¶Ð̳"; } //3¸òÂå¶Ð̳ if(intval($te_segment2) === 1){ $kinmuwords .= "¡¦3¸òÂå¶Ð̳"; //$subdispseg2 = "3¸òÂå¶Ð̳"; } //Æü¶Ð¤Î¤ß if(intval($te_segment4) === 1){ $kinmuwords .= "¡¦Æü¶Ð¤Î¤ß"; //$subdispseg4 = "Æü¶Ð¤Î¤ß"; } //Ìë¶Ð¤Î¤ß if(intval($te_segment5) === 1){ $kinmuwords .= "¡¦Ìë¶Ð¤Î¤ß"; //$subdispseg5 = "Ìë¶Ð¤Î¤ß"; } //¥µ¥Ý¡¼¥È¥Ê¡¼¥¹(·ÀÌó) if(intval($te_segment25) === 1){ $kinmuwords .= "¡¦¥µ¥Ý¡¼¥È¥Ê¡¼¥¹"; } //¶èʬ¥¿¥¤¥È¥ë $subsearchForm .= ''; } //////////////////////////////////// // ôÅö¶È̳ //////////////////////////////////// if(intval($in_tgyomu1)===1 || intval($in_tgyomu2)===1 || intval($in_tgyomu3)===1 || intval($in_tgyomu4)===1 || intval($in_tgyomu5)===1 || intval($in_tgyomu6)===1 || intval($in_tgyomu7)===1 || intval($in_tgyomu8)===1 || intval($in_tgyomu9)===1 || intval($in_tgyomu10)===1 || intval($in_tgyomu11)===1){ //ÉÂÅï if(intval($in_tgyomu1) === 1){ $tantouwords .= "¡¦ÉÂÅï"; } //³°Íè if(intval($in_tgyomu2) === 1){ $tantouwords .= "¡¦³°Íè"; } //¥ª¥Ú¼¼ if(intval($in_tgyomu3) === 1){ $tantouwords .= "¡¦¥ª¥Ú¼¼"; } //µßµÞ³°Íè if(intval($in_tgyomu4) === 1){ $tantouwords .= "¡¦µßµÞ³°Íè"; } //ICU·Ï if(intval($in_tgyomu5) === 1){ $tantouwords .= "¡¦ICU·Ï"; } //Æ©ÀÏ if(intval($in_tgyomu6) === 1){ $tantouwords .= "¡¦Æ©ÀÏ"; } //ˬÌä´Ç¸î if(intval($in_tgyomu7) === 1){ $tantouwords .= "¡¦Ë¬Ìä´Ç¸î"; } //²ð¸î»ÜÀß if(intval($in_tgyomu8) === 1){ $tantouwords .= "¡¦²ð¸î»ÜÀß"; } //¸¡¿Ç¡¦·ò¿Ç if(intval($in_tgyomu9) === 1){ $tantouwords .= "¡¦¸¡¿Ç¡¦·ò¿Ç"; } //ÊÝ°é±à¡¦³Ø¹» if(intval($in_tgyomu10) === 1){ $tantouwords .= "¡¦ÊÝ°é±à¡¦³Ø¹»"; } //¤½¤Î¾ if(intval($in_tgyomu11) === 1){ $tantouwords .= "¡¦¤½¤Î¾"; } //¶èʬ¥¿¥¤¥È¥ë $subsearchForm .= ''; } //////////////////////////////////// // ¤³¤À¤ï¤ê¾ò·ï ////////////////////////////////////̤·Ð¸³¼Ô if(intval($te_segment6)===1 || intval($te_segment10)===1 || intval($te_segment11)===1 || intval($te_segment13)===1 || intval($te_segment15)===1 || intval($te_segment16)===1 || intval($te_segment17)===1 || intval($te_segment18)===1 || intval($te_segment19)===1 || intval($te_segment20)===1 || intval($te_segment26)===1 || intval($te_segment27)===1){ //̤·Ð¸³¼Ô if(intval($te_segment6) === 1){ $goodwords .= "¡¦Ì¤·Ð¸³¼Ô"; } //¸¦½¤½¼¼Â if(intval($te_segment10) === 1){ $goodwords .= "¡¦¸¦½¤½¼¼Â"; } //±Ø5ʬ°ÊÆâ if(intval($te_segment11) === 1){ $goodwords .= "¡¦±Ø5ʬ°ÊÆâ"; } //¼ÖÄÌ¶Ð²Ä if(intval($te_segment13) === 1){ $goodwords .= "¡¦¼ÖÄ̶вÄ"; } //ÎÀ¤¢¤ê if(intval($te_segment15) === 1){ $goodwords .= "¡¦ÎÀ¤¢¤ê"; } //»Ä¶È¤¬¾¯¤Ê¤¤ if(intval($te_segment16) === 1){ $goodwords .= "¡¦»Ä¶È¤¬¾¯¤Ê¤¤"; } //ÅÚ¡¦ÆüµÙ¤ß if(intval($te_segment17) === 1){ $goodwords .= "¡¦ÅÚ¡¦ÆüµÙ¤ß"; } //4½µ8µÙ°Ê¾å if(intval($te_segment18) === 1){ $goodwords .= "¡¦4½µ8µÙ°Ê¾å"; } //Â÷»ù½ê¤¢¤ê if(intval($te_segment19) === 1){ $goodwords .= "¡¦Â÷»ù½ê¤¢¤ê"; } //»Ò°é¤Æ»Ù±ç if(intval($te_segment20) === 1){ $goodwords .= "¡¦»Ò°é¤Æ»Ù±ç"; } //µëÍ¿¹â¤á if(intval($te_segment26) === 1){ $goodwords .= "¡¦µëÍ¿¹â¤á"; } //¥Ö¥é¥ó¥¯OK if(intval($te_segment27) === 1){ $goodwords .= "¡¦¥Ö¥é¥ó¥¯OK"; } //¶èʬ¥¿¥¤¥È¥ë $subsearchForm .= ''; } ////////////////////////////////////// // ¥Õ¥ê¡¼¥ï¡¼¥É ////////////////////////////////////// // ¶õÍó/²þ¹Ô¤Î¤ß¥Á¥§¥Ã¥¯ if(!nbr_tk($find_str)){ $find_str = ""; } if(strlen($find_str)){ $subsearchForm .= ''; } //¥Æ¡¼¥Ö¥ëÊĤ¸¥¿¥° $subsearchForm .='
ÁªÂò¤µ¤ì¤¿¾ò·ï¡¡¡¡¡¡ ÊĤ¸¤ë
¿¦¼ï
'.$aryJobs[$jobs].'
¸ÛÍÑ·ÁÂÖ
'.$aryEmpsys[$empsys].'
»ÜÀß·ÁÂÖ
'.$aryFaform[$faform].'
¶Ð̳ÃÏ£±
'.$arypref[$pref-25].$prName.'
¶Ð̳ÃÏ£²
'.$arypref[$pref2-25].$prName2.'
¶Ð̳ÃÏ£³
'.$arypref[$pref3-25].$prName3.'
±èÀþ
".$subdisplname1."".$subdispstname1."
¶Ð̳·ÁÂÖ
'; $subsearchForm .= $kinmuwords; //Äù¤á $subsearchForm .= '
ôÅö¶È̳
'; $subsearchForm .= $tantouwords; //Äù¤á $subsearchForm .= '
¤³¤À¤ï¤ê¾ò·ï
'; $subsearchForm .= $goodwords; //Äù¤á $subsearchForm .= '
¥Õ¥ê¡¼¥ï¡¼¥É
'.$find_str.'
'; $subsearchForm .=' '; } /******************************************** // Áí·ï¿ô¤¬¼èÆÀ¤Ç¤­¤ëÃʳ¬¤ÎSQLʸ¤ÇÀè¤Ë¼Â¹Ô ********************************************/ /* echo "
sql="; var_dump($sql); echo "
"; */ //exit; $rs2 = $dbc->doQuery($sql); $rec_num = mysql_num_rows($rs2); //¥½¡¼¥È $sql .= " ORDER BY K.ti_kosinbi DESC, B.in_gyosyuno ASC LIMIT " . $rec_disp . " OFFSET " . $rec_start; // echo "
sql="; // var_dump($sql); // echo "
"; // exit; //¥¯¥¨¥ê¼Â¹Ô $rs = $dbc->doQuery($sql); // ¸¡º÷·ë²Ì¥Ç¡¼¥¿ // pg_fetch_row¤Ë¤Æ¿ô»ú¤ò¥¤¥ó¥Ç¥Ã¥¯¥¹¤È¤¹¤ëÇÛÎó¤È¤·¤Æ¹Ô¤òÆÀ¤ë while ($rec = mysqli_fetch_array($rs)) { $pk_csystemid = $rec[0]; // Ä̤·´ÉÍýÈÖ¹æ $pte_catchcopy[$pk_csystemid] = $rec[1]; // ¥­¥ã¥Ã¥Á¥³¥Ô¡¼ $pte_syamei[$pk_csystemid] = $rec[2]; // ¼Ò̾ $pte_kikan[$pk_csystemid] = $rec[3]; // ´ü´Ö $pte_kinmuti[$pk_csystemid] = $rec[4]; // ¶Ð̳ÃÏ $pte_moyorieki[$pk_csystemid] = $rec[5]; // ºÇ´ó±Ø $pte_maintitle[$pk_csystemid] = $rec[6]; // ¥á¥¤¥ó¥¿¥¤¥È¥ë $pte_bodycopy[$pk_csystemid] = $rec[7]; // ¥Ü¥Ç¥£¥³¥Ô¡¼ $pte_gazo1[$pk_csystemid] = $rec[8]; // ²èÁü£± $pte_segment1[$pk_csystemid] = $rec[9]; // ¶èʬ£± $pte_segment2[$pk_csystemid] = $rec[10]; // ¶èʬ£² $pte_segment3[$pk_csystemid] = $rec[11]; // ¶èʬ£³ $pte_segment4[$pk_csystemid] = $rec[12]; // ¶èʬ£´ $pte_segment5[$pk_csystemid] = $rec[13]; // ¶èʬ£µ $pte_segment6[$pk_csystemid] = $rec[14]; // ¶èʬ£¶ $pte_segment7[$pk_csystemid] = $rec[15]; // ¶èʬ£· $pte_segment8[$pk_csystemid] = $rec[16]; // ¶èʬ£¸ $pte_segment9[$pk_csystemid] = $rec[17]; // ¶èʬ£¹ $pte_segment10[$pk_csystemid] = $rec[18]; // ¶èʬ£±£° $pte_segment11[$pk_csystemid] = $rec[19]; // ¶èʬ£±£± $pte_segment12[$pk_csystemid] = $rec[20]; // ¶èʬ£±£² $pte_segment13[$pk_csystemid] = $rec[21]; // ¶èʬ£±£³ $pte_segment14[$pk_csystemid] = $rec[22]; // ¶èʬ£±£´ $pte_segment15[$pk_csystemid] = $rec[23]; // ¶èʬ£±£µ $pte_segment16[$pk_csystemid] = $rec[24]; // ¶èʬ£±£¶ $pte_segment17[$pk_csystemid] = $rec[25]; // ¶èʬ£±£· $pte_segment18[$pk_csystemid] = $rec[26]; // ¶èʬ£±£¸ $pte_segment19[$pk_csystemid] = $rec[27]; // ¶èʬ£±£¹ $pte_segment20[$pk_csystemid] = $rec[28]; // ¶èʬ£²£° $pte_segment21[$pk_csystemid] = $rec[29]; // ¶èʬ£²£± $pte_segment22[$pk_csystemid] = $rec[30]; // ¶èʬ£²£² $pte_segment23[$pk_csystemid] = $rec[31]; // ¶èʬ£²£³ $pte_segment24[$pk_csystemid] = $rec[32]; // ¶èʬ£²£´ $pin_syokusyu3[$pk_csystemid] = $rec[33]; // ¿¦¼ï $pin_koyokbn9[$pk_csystemid] = $rec[34]; // ¸ÛÍÑ·ÁÂÖ $pte_kinmu[$pk_csystemid] = $rec[35]; // ¶Ð̳»þ´Ö $pte_kyujitu[$pk_csystemid] = $rec[36]; // µÙÆü $pfl_hosyukin[$pk_csystemid] = $rec[37]; // µëÍ¿ $ppk_hospitalid[$pk_csystemid] = $rec[38]; // ɱ¡ID $pin_tgyomu1[$pk_csystemid] = $rec[39]; // ôÅö¶È̳¡ÊÉÂÅï¡Ë $pin_tgyomu2[$pk_csystemid] = $rec[40]; // ôÅö¶È̳¡Ê³°Íè¡Ë $pin_tgyomu3[$pk_csystemid] = $rec[41]; // ôÅö¶È̳¡Ê¥ª¥Ú¼¼¡Ë $pin_tgyomu4[$pk_csystemid] = $rec[42]; // ôÅö¶È̳¡ÊµßµÞ³°Íè¡Ë $pin_tgyomu5[$pk_csystemid] = $rec[43]; // ôÅö¶È̳¡ÊICU·Ï¡Ë $pin_tgyomu6[$pk_csystemid] = $rec[44]; // ôÅö¶È̳¡ÊÆ©ÀÏ¡Ë $pin_tgyomu7[$pk_csystemid] = $rec[45]; // ôÅö¶È̳¡ÊˬÌä´Ç¸î¡Ë $pin_tgyomu8[$pk_csystemid] = $rec[46]; // ôÅö¶È̳¡Ê²ð¸î/Ï·¿Í/Ê¡»ã¡Ë $pin_tgyomu9[$pk_csystemid] = $rec[47]; // ôÅö¶È̳¡Ê¸¡¿Ç/·ò¿Ç¡Ë $pin_tgyomu10[$pk_csystemid] = $rec[48]; // ôÅö¶È̳¡ÊÊÝ°é±à/³Ø¹»¡Ë $pin_tgyomu11[$pk_csystemid] = $rec[49]; // ôÅö¶È̳¡Ê¤½¤Î¾¡Ë $pin_jusyo[$pk_csystemid] = $rec[50]; // ÅÔÆ»Éܸ© $pte_kkhaichi[$pk_csystemid] = $rec[51]; // ´Ç¸î´ð½à $pte_gurupu[$pk_csystemid] = $rec[52]; // ¥°¥ë¡¼¥×̾ $pte_uneisyu[$pk_csystemid] = $rec[53]; // ±¿±Ä¼çÂÎ $pte_segment25[$pk_csystemid] = $rec[54]; // ¶èʬ£²£µ $pte_segment26[$pk_csystemid] = $rec[55]; // ¶èʬ£²£¶ $pte_segment27[$pk_csystemid] = $rec[56]; // ¶èʬ£²£· $hideflg[$pk_csystemid] = $rec[57]; // ̱´Öɱ¡¥Õ¥é¥° } //echo $sql; // ¸½ºß¤Îɽ¼¨¥ì¥³¡¼¥É·ï¿ô // pg_num_row PostgreSQL¤Î·ë²Ì¥ê¥½¡¼¥¹¤Î¹Ô¿ô¤òÊÖ¤¹¡£ $rec_num_now = mysql_num_rows($rs); // ¥á¥â¥ê¤ò³«Êü mysqli_free_result($rs); mysqli_free_result($rs2); //DBÀÚÃÇ $dbc->dbClose(); break; } /* * bodyÉô */ $body = ""; $searchdata = ""; $goods_html = file(TEMPLATE_LIST); if ($rec_num_now != 0) {/* ³ºÅö¥ì¥³¡¼¥É¤¬¤¢¤ë¤È¤­ */ foreach($pte_catchcopy as $num => $title) { //£Ð£Ã¥µ¥¤¥È¤Ï´ðËÜʸ»ú¥³¡¼¥É¤¬EUC¤Ê¤Î¤Çʸ»ú¥¨¥ó¥³¡¼¥É»ß¤á¤Æ¥ê¥×¥ì¡¼¥¹¤À¤± foreach($goods_html as $str) { //$str = str_replace("_%rec_num%_", $rec_num, $str); $str = str_replace("_%kid%_", $num, $str); $str = str_replace("_%te_catchcopy%_", $pte_catchcopy[$num], $str); $byoinmei = ""; if($pte_uneisyu[$num] != "ÉÔÌÀ" && $pte_uneisyu[$num] != "¼«¼£ÂÎ") $byoinmei .= $pte_uneisyu[$num]."¡¡"; if($pte_gurupu[$num] != "ÉÔÌÀ") $byoinmei .= $pte_gurupu[$num]."¡¡"; $byoinmei .= $pte_syamei[$num]; //Èó¸ø³«¥Õ¥é¥° if($hideflg[$num] == 1){ $byoinmei = "°åÎÅË¡¿Í¡¡Ì±´Öɱ¡¡¡¢¨¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£"; } //$str = str_replace("_%syamei%_", $te_syamei[$num], $str); $str = str_replace("_%syamei%_", $byoinmei, $str); $str = str_replace("_%pk_hospitalid%_", $ppk_hospitalid[$num], $str); //$str = str_replace("_%pk_renban%_", $pk_renban[$num], $str); if(empty($te_kikan[$num])) $te_kikan[$num] = "-"; $str = str_replace("_%te_kikan%_", $pte_kikan[$num], $str); $kinmuchi = $pin_jusyo[$num] . $pte_kinmuti[$num]; $str = str_replace("_%te_kinmuti%_", $kinmuchi, $str); $str = str_replace("_%te_moyorieki%_", $pte_moyorieki[$num], $str); $str = str_replace("_%te_maintitle%_", $pte_maintitle[$num], $str); $str = str_replace("_%te_bodycopy%_", $pte_bodycopy[$num], $str); //Ãæ¿È¤¬¤¢¤ë¤Ê¤é¤½¤Î¤Þ¤Þ»ÈÍÑ if(!strlen($pte_gazo1[$num]) || $pte_gazo1[$num] == "NULL"){ $img = "photo/no_photo4.gif"; }else{ //¤Ê¤±¤ì¤ÐNoimageÊä´° $img = $pte_gazo1[$num]; } //²èÁü¥¢¥Ã¥×¥í¡¼¥É $str = str_replace("_%uplordimg%_", $img, $str); $str = str_replace("_%segment1%_", $arysegu[$pte_segment1[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment2%_", $arysegu[$pte_segment2[$num]], $str); //¥»¥°¥á¥ó¥È //$str = str_replace("_%segment3%_", $arysegu[$pte_segment3[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment4%_", $arysegu[$pte_segment4[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment5%_", $arysegu[$pte_segment5[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment6%_", $arysegu[$pte_segment6[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment7%_", $arysegu[$pte_segment7[$num]], $str); //¥»¥°¥á¥ó¥È //$str = str_replace("_%segment8%_", $arysegu[$pte_segment8[$num]], $str); //¥»¥°¥á¥ó¥È //$str = str_replace("_%segment9%_", $arysegu[$pte_segment9[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment10%_", $arysegu[$pte_segment10[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment11%_", $arysegu[$pte_segment11[$num]], $str); //¥»¥°¥á¥ó¥È //$str = str_replace("_%segment12%_", $arysegu[$pte_segment12[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment13%_", $arysegu[$pte_segment13[$num]], $str); //¥»¥°¥á¥ó¥È //$str = str_replace("_%segment14%_", $arysegu[$pte_segment14[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment15%_", $arysegu[$pte_segment15[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment16%_", $arysegu[$pte_segment16[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment17%_", $arysegu[$pte_segment17[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment18%_", $arysegu[$pte_segment18[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment19%_", $arysegu[$pte_segment19[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment20%_", $arysegu[$pte_segment20[$num]], $str); //¥»¥°¥á¥ó¥È /* $str = str_replace("_%segment21%_", $arysegu[$pte_segment21[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment22%_", $arysegu[$pte_segment22[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment23%_", $arysegu[$pte_segment23[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment24%_", $arysegu[$pte_segment24[$num]], $str); //¥»¥°¥á¥ó¥È */ //¥¼¥íÊä´° if(!strlen($pte_segment25[$num])){ $pte_segment25[$num] = 0; } if(!strlen($pte_segment26[$num])){ $pte_segment26[$num] = 0; } if(!strlen($pte_segment27[$num])){ $pte_segment27[$num] = 0; } $str = str_replace("_%segment25%_", $arysegu[$pte_segment25[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment26%_", $arysegu[$pte_segment26[$num]], $str); //¥»¥°¥á¥ó¥È $str = str_replace("_%segment27%_", $arysegu[$pte_segment27[$num]], $str); //¥»¥°¥á¥ó¥È if(!strlen($pin_tgyomu1[$num]) || $pin_tgyomu1[$num] == -1) $pin_tgyomu1[$num] = 2; if(!strlen($pin_tgyomu2[$num]) || $pin_tgyomu2[$num] == -1) $pin_tgyomu2[$num] = 2; if(!strlen($pin_tgyomu3[$num]) || $pin_tgyomu3[$num] == -1) $pin_tgyomu3[$num] = 2; if(!strlen($pin_tgyomu4[$num]) || $pin_tgyomu4[$num] == -1) $pin_tgyomu4[$num] = 2; if(!strlen($pin_tgyomu5[$num]) || $pin_tgyomu5[$num] == -1) $pin_tgyomu5[$num] = 2; if(!strlen($pin_tgyomu6[$num]) || $pin_tgyomu6[$num] == -1) $pin_tgyomu6[$num] = 2; if(!strlen($pin_tgyomu7[$num]) || $pin_tgyomu7[$num] == -1) $pin_tgyomu7[$num] = 2; if(!strlen($pin_tgyomu8[$num]) || $pin_tgyomu8[$num] == -1) $pin_tgyomu8[$num] = 2; if(!strlen($pin_tgyomu9[$num]) || $pin_tgyomu9[$num] == -1) $pin_tgyomu9[$num] = 2; if(!strlen($pin_tgyomu10[$num]) || $pin_tgyomu10[$num] == -1) $pin_tgyomu10[$num] = 2; if(!strlen($pin_tgyomu11[$num]) || $pin_tgyomu11[$num] == -1) $pin_tgyomu11[$num] = 2; $str = str_replace("_%in_tgyomu1%_", $arytgyomu[$pin_tgyomu1[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu2%_", $arytgyomu[$pin_tgyomu2[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu3%_", $arytgyomu[$pin_tgyomu3[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu4%_", $arytgyomu[$pin_tgyomu4[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu5%_", $arytgyomu[$pin_tgyomu5[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu6%_", $arytgyomu[$pin_tgyomu6[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu7%_", $arytgyomu[$pin_tgyomu7[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu8%_", $arytgyomu[$pin_tgyomu8[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu9%_", $arytgyomu[$pin_tgyomu9[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu10%_", $arytgyomu[$pin_tgyomu10[$num]], $str); //ôÅö¶È̳ $str = str_replace("_%in_tgyomu11%_", $arytgyomu[$pin_tgyomu11[$num]], $str); //ôÅö¶È̳ if(empty($pin_syokusyu3[$num]) || $pin_syokusyu3[$num] == -1) $pin_syokusyu3[$num] = 0; if(empty($pin_koyokbn9[$num]) || $pin_koyokbn9[$num] == -1) $pin_koyokbn9[$num] = 0; $str = str_replace("_%in_syokusyu3%_", $arysyoku[$pin_syokusyu3[$num]], $str); $str = str_replace("_%in_koyokbn9%_", $arykoyo[$pin_koyokbn9[$num]], $str); $str = str_replace("_%te_kinmu%_", $pte_kinmu[$num], $str); $str = str_replace("_%te_kyujitu%_", $pte_kyujitu[$num], $str); if(empty($pfl_hosyukin[$num]) || $pfl_hosyukin[$num] == "ÉÔÌÀ") $pfl_hosyukin[$num] = "¤ªµ¤·Ú¤Ë¤´ÁêÃ̲¼¤µ¤¤"; $str = str_replace("_%fl_hosyukin%_", $pfl_hosyukin[$num], $str); $str = str_replace("_%worknaiyo%_", "½ÐÎÏͽÄê¡Ê¤Þ¤À̤¼ÂÁõ¡Ë", $str); if(empty($pte_kkhaichi[$num]) || $pte_kkhaichi[$num] == "ÉÔÌÀ") $pte_kkhaichi[$num] = "¤ªµ¤·Ú¤Ë¤´ÁêÃ̲¼¤µ¤¤"; $str = str_replace("_%te_kkhaichi%_", $pte_kkhaichi[$num], $str); // entry¥ê¥ó¥¯¤Ë¥­¥ã¥ó¥Ú¡¼¥óID¤òÉÕÍ¿ $str = str_replace("_%campaignID%_", $linkcampaign, $str); $body .= $str; } } } else { //³ºÅö¥ì¥³¡¼¥É̵¤·¡Ê¸¡º÷·ë²Ì£°·ï¡Ë¤Î»þ¤Î¥¨¥é¡¼½ÐÎÏ //³°Éô¥¹¥¿¥¤¥ë¥·¡¼¥È¤Î±Æ¶Á¤Ç¡¢¼ã´³¸«¤¿Ìܤ¬Êø¤ì¤Æ¤¤¤¿¤Î¤ÇÄ´À°¤·¤Þ¤·¤¿¡£byÀ¾Â¼ if (!empty($find_str)) { //$searchdata = "

¡Ø " .$find_str. " ¡Ù ¤Ë°ìÃפ¹¤ë¾ðÊó¤Ï¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£


\n"; $searchdata = "
\n

¸½ºß¤Ï¡¢¡Ø " .$find_str. " ¡Ù ¤Ë°ìÃפ¹¤ë¸ø³«µá¿Í¤Ï¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£

\n"; } else { //$searchdata = "

¾ò·ï¤Ë°ìÃפ¹¤ë¾ðÊó¤Ï¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£


\n"; $searchdata = "
\n

¸½ºß¤Ï¡¢¤³¤Î¾ò·ï¤Ë°ìÃפ¹¤ë¸ø³«µá¿Í¤Ï¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£

\n"; } //¥­¥ã¥ê¥¢¥³¥ó¥µ¥ë¥¿¥ó¥È¤ËÁêÃ̤¹¤ë¡Ê¶¦ÄÌ¡Ë $searchdata .= "

¥­¥ã¥ê¥¢¥³¥ó¥µ¥ë¥¿¥ó¥È¤ËÁêÃ̤¹¤ë

\n"; //ºÆ·úºö¤Î¥Ò¥ó¥È¡Ê¶¦ÄÌ¡Ë $searchdata .= "

ºÆ¸¡º÷¤Î¥Ò¥ó¥È¡§

\n"; $searchdata .= "

¤´´õ˾¤Î¾ò·ï¥Ü¥¿¥ó¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¤«³Îǧ¤·¤Æ¤¯¤À¤µ¤¤¡£

\n

¥­¡¼¥ï¡¼¥É¤¬Àµ¤·¤¯ÆþÎϤǤ­¤Æ¤¤¤ë¤«¡¢¸í»ú¤¬¤Ê¤¤¤«³Îǧ¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

\n

Ʊ¤¸°ÕÌ£¤ÎÊ̤θÀÍÕ¤ò¤¿¤á¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

\n"; $searchdata .= "
\n"; } /* ** ¥Ñ¡¼¥Ä(searchdata) */ //¥ì¥³¡¼¥É¤¬¤¢¤ë¾ì¹ç if ($rec_num_now != 0) { $start = $rec_start + 1; $end = $start + $rec_num_now - 1; //$searchdata = "

¸¡º÷¤·¤¿·ë²Ì" . $rec_num . "·ï¤Î¥Ç¡¼¥¿¤È°ìÃפ·¤Þ¤·¤¿¡£


"; //$searchdata .= "

" . $start . " ¡Á " . $end . "¤òɽ¼¨¤·¤Æ¤¤¤Þ¤¹¡£

"; } /* ** linkbuttonÉô¡Ê¥ê¥ó¥¯ÈÖ¹æ¤Î¥Ü¥¿¥ó¡Ë */ $link = ""; $move = ""; if ($rec_num_now != 0) { /* if ($rec_num != 0){ */ $link_num = $rec_num / $rec_disp; $find_str = urlencode($find_str); $rec_disp_view = $rec_disp * ($p - 1) + $rec_num_now; $link .= "
¸¡º÷·ë²Ì¡§".$rec_num."·ïÃæ¡¡".$rec_start_view."¡Á".$rec_disp_view."·ïɽ¼¨
\n"; $link .= "
    "; $link_num = $rec_num / $rec_disp; $fword = urlencode($fword); //¥ê¥ó¥¯ÍÑÃÍ·²¤òºîÀ® //¶õ¤Î¹àÌܤò¥ê¥ó¥¯¤Ëɽ¼¨¤¹¤ë¤Ènotice¥¨¥é¡¼¤¬¤Ç¤ë¤Î¤Ç°ì¤Ä°ì¤Ä¶õÍó¥Á¥§¥Ã¥¯¤·¤Æ¤«¤éÄɲ䷤Ƥ¤¤¯ byÀÐÁÒ 20110225 $move .= "?mode=$mode"; if(!empty($find_str)){ $move .= "&fword=$find_str"; } if(!empty($nofind_str)){ $move .= "&nofword=$nofind_str"; } if(!empty($pref)){ $move .= "&pref=$pref"; } if(!empty($dcode)){ $move .= "&dcode=$dcode"; } if(!empty($pref2)){ $move .= "&pref2=$pref2"; } if(!empty($dcode2)){ $move .= "&dcode2=$dcode2"; } if(!empty($pref3)){ $move .= "&pref3=$pref3"; } if(!empty($dcode3)){ $move .= "&dcode3=$dcode3"; } if(!empty($jobs)){ $move .= "&jobs=$jobs"; } if(!empty($lpref)){ $move .= "&lpref=$lpref"; } if(!empty($lcode)){ $move .= "&lcode=$lcode$lpref"; } if(!empty($stcode)){ $move .= "&stcode=$stcode"; } if(!empty($empsys)){ $move .= "&empsys=$empsys"; } if(!empty($faform)){ $move .= "&faform=$faform"; } if(!empty($kkhaichi)){ $move .= "&kkhaichi=$kkhaichi"; //´Ç¸î´ð½à(kkhaichi)¤òÄɲà } if(!empty($te_segment1)){ $move .= "&te_segment1=$te_segment1"; } if(!empty($te_segment2)){ $move .= "&te_segment2=$te_segment2"; } if(!empty($te_segment3)){ $move .= "&te_segment3=$te_segment3"; } if(!empty($te_segment4)){ $move .= "&te_segment4=$te_segment4"; } if(!empty($te_segment5)){ $move .= "&te_segment5=$te_segment5"; } if(!empty($te_segment6)){ $move .= "&te_segment6=$te_segment6"; } if(!empty($te_segment7)){ $move .= "&te_segment7=$te_segment7"; } if(!empty($te_segment8)){ $move .= "&te_segment8=$te_segment8"; } if(!empty($te_segment9)){ $move .= "&te_segment9=$te_segment9"; } if(!empty($te_segment10)){ $move .= "&te_segment10=$te_segment10"; } if(!empty($te_segment11)){ $move .= "&te_segment11=$te_segment11"; } if(!empty($te_segment12)){ $move .= "&te_segment12=$te_segment12"; } if(!empty($te_segment13)){ $move .= "&te_segment13=$te_segment13"; } if(!empty($te_segment14)){ $move .= "&te_segment14=$te_segment14"; } if(!empty($te_segment15)){ $move .= "&te_segment15=$te_segment15"; } if(!empty($te_segment16)){ $move .= "&te_segment16=$te_segment16"; } if(!empty($te_segment17)){ $move .= "&te_segment17=$te_segment17"; } if(!empty($te_segment18)){ $move .= "&te_segment18=$te_segment18"; } if(!empty($te_segment19)){ $move .= "&te_segment19=$te_segment19"; } if(!empty($te_segment20)){ $move .= "&te_segment20=$te_segment20"; } if(!empty($te_segment21)){ $move .= "&te_segment21=$te_segment21"; } if(!empty($te_segment22)){ $move .= "&te_segment22=$te_segment22"; } if(!empty($te_segment23)){ $move .= "&te_segment23=$te_segment23"; } if(!empty($te_segment24)){ $move .= "&te_segment24=$te_segment24"; } if(!empty($te_segment25)){ $move .= "&te_segment25=$te_segment25"; } if(!empty($te_segment26)){ $move .= "&te_segment26=$te_segment26"; } if(!empty($te_segment27)){ $move .= "&te_segment27=$te_segment27"; } if(!empty($in_tgyomu1)){ $move .= "&in_tgyomu1=$in_tgyomu1"; } if(!empty($in_tgyomu2)){ $move .= "&in_tgyomu2=$in_tgyomu2"; } if(!empty($in_tgyomu3)){ $move .= "&in_tgyomu3=$in_tgyomu3"; } if(!empty($in_tgyomu4)){ $move .= "&in_tgyomu4=$in_tgyomu4"; } if(!empty($in_tgyomu5)){ $move .= "&in_tgyomu5=$in_tgyomu5"; } if(!empty($in_tgyomu6)){ $move .= "&in_tgyomu6=$in_tgyomu6"; } if(!empty($in_tgyomu7)){ $move .= "&in_tgyomu7=$in_tgyomu7"; } if(!empty($in_tgyomu8)){ $move .= "&in_tgyomu8=$in_tgyomu8"; } if(!empty($in_tgyomu9)){ $move .= "&in_tgyomu9=$in_tgyomu9"; } if(!empty($in_tgyomu10)){ $move .= "&in_tgyomu10=$in_tgyomu10"; } if(!empty($in_tgyomu11)){ $move .= "&in_tgyomu11=$in_tgyomu11"; } /*if ($rec_num != 0) {//¾å·ÓÀþɽ¼¨ $link .= "
    \n"; }*/ //¡Ö¡ãÁ°¤Ø¡×¥ê¥ó¥¯É½¼¨ if ($p > 1) { $spre = $s - $rec_disp;//¥ì¥³¡¼¥É¿ô($s)¤«¤é¾å¸Â¤ò°ú¤­¥×¥ì¥Ó¥å¡¼¤¹¤ë¥Ç¡¼¥¿°ÌÃÖ¤ò½Ð¤¹¡£ //$link .= "≪Á°¤Ø\n"; $link .= "
  • ≪Á°¤Ø
    • \n"; } for ($i = 0; $i < $link_num; $i++) {//¥ê¥ó¥¯ºîÀ® $j = $i + 1; $k = $i + 1;//¥Ú¡¼¥¸ÈÖ¹æÍÑ $z = $i * 20; if ($p !== $k) { //$link .= "" . $j . "\n"; $link .= "
  • " . $j . "
    • \n"; } else { $link .= "
  • " . $j . "
    • \n"; } } if (($next - 1) * $rec_disp < $rec_num) { $sp = $rec_disp * $p;//¥ì¥³¡¼¥É¿ô($s)¤«¤é¾å¸Â¤ò°ú¤­¥×¥ì¥Ó¥å¡¼¤¹¤ë¥Ç¡¼¥¿°ÌÃÖ¤ò½Ð¤¹ //$link .= "¼¡¤Ø≫\n"; $link .= "
  • ¼¡¤Ø≫
    • \n"; } /*if ($rec_num != 0) {//²¼·ÓÀþɽ¼¨ $link .= "
    \n"; }*/ $link .= '
'; } else { $link = ""; } /* ** ½ÐÎϡʤÈƱ¤¸¤³¤È¡£¡Ë */ //html¥Õ¥¡¥¤¥ëÉôʬ require_once("inc/inc_all_skillup.php"); ?>