prepare('Select usr_bsc.usr_cd, usr_bsc.usr_nm, usr_bsc.usr_ym, usr_bsc.usr_note, usr_bsc.exh_cd, usr_bsc.pbc_flg From usr_bsc, exh_mst WHERE usr_bsc.exh_cd = :exh_selsct AND usr_bsc.exh_cd = exh_mst.exh_cd AND (usr_bsc.del_flg is null or usr_bsc.del_flg = \'\') AND (exh_mst.del_flg is null or exh_mst.del_flg = \'\') AND (usr_bsc.usr_nm like :usr_nm_like OR usr_bsc.usr_note like :usr_note_like OR usr_bsc.usr_cd IN (Select ss_tbl.usr_cd from ss_tbl where ss_tbl.ss_ttl like :ss_ttl_like OR ss_tbl.ss_hbn like :ss_hbn_like And (ss_tbl.del_flg is null Or ss_tbl.del_flg = \'\')) OR usr_bsc.usr_cd IN (Select prtnr_tbl.usr_cd from prtnr_tbl where prtnr_tbl.sub_nm like :sub_nm_like And (prtnr_tbl.del_flg is null Or prtnr_tbl.del_flg = \'\'))) Order by usr_bsc.usr_ym , usr_bsc.usr_cd'); $stmt -> bindValue(':exh_selsct', $exh_selsct, PDO::PARAM_INT); $stmt -> bindValue(':usr_nm_like', $usr_nm_like, PDO::PARAM_STR); $stmt -> bindValue(':usr_note_like', $usr_note_like, PDO::PARAM_STR); $stmt -> bindValue(':ss_ttl_like', $ss_ttl_like, PDO::PARAM_STR); $stmt -> bindValue(':ss_hbn_like', $ss_hbn_like, PDO::PARAM_STR); $stmt -> bindValue(':sub_nm_like', $sub_nm_like, PDO::PARAM_STR); //$rs_chk_cnt=$stmt->rowCount(); //はかる・調べるフォーラムの展示会を表示 if($exh_cd == "forum") { $stmt = $pdo->prepare('Select usr_bsc.usr_cd, usr_bsc.usr_nm, usr_bsc.usr_ym, usr_bsc.usr_note, usr_bsc.exh_cd, usr_bsc.pbc_flg From usr_bsc, exh_mst WHERE usr_bsc.exh_cd = exh_mst.exh_cd AND usr_bsc.exh_cd in(1,2,3,4,5) AND (usr_bsc.del_flg is null or usr_bsc.del_flg = \'\') AND (exh_mst.del_flg is null or exh_mst.del_flg = \'\') AND (usr_bsc.usr_nm like :usr_nm_like OR usr_bsc.usr_note like :usr_note_like OR usr_bsc.usr_cd IN (Select ss_tbl.usr_cd from ss_tbl where ss_tbl.ss_ttl like :ss_ttl_like OR ss_tbl.ss_hbn like :ss_hbn_like And (ss_tbl.del_flg is null Or ss_tbl.del_flg = \'\')) OR usr_bsc.usr_cd IN (Select prtnr_tbl.usr_cd from prtnr_tbl where prtnr_tbl.sub_nm like :sub_nm_like And (prtnr_tbl.del_flg is null Or prtnr_tbl.del_flg = \'\'))) Order by usr_bsc.usr_ym , usr_bsc.usr_cd'); $stmt -> bindValue(':usr_nm_like', $usr_nm_like, PDO::PARAM_STR); $stmt -> bindValue(':usr_note_like', $usr_note_like, PDO::PARAM_STR); $stmt -> bindValue(':ss_ttl_like', $ss_ttl_like, PDO::PARAM_STR); $stmt -> bindValue(':ss_hbn_like', $ss_hbn_like, PDO::PARAM_STR); $stmt -> bindValue(':sub_nm_like', $sub_nm_like, PDO::PARAM_STR); } //全ての展示会を表示 /* if($exh_cd == "all") { $stmt = $pdo->prepare('Select usr_bsc.usr_cd, usr_bsc.usr_nm, usr_bsc.usr_ym, usr_bsc.usr_note, usr_bsc.exh_cd, usr_bsc.pbc_flg From usr_bsc, exh_mst WHERE usr_bsc.exh_cd = exh_mst.exh_cd AND (usr_bsc.del_flg is null or usr_bsc.del_flg = \'\') AND (exh_mst.del_flg is null or exh_mst.del_flg = \'\') AND (usr_bsc.usr_nm like :usr_nm_like OR usr_bsc.usr_note like :usr_note_like OR usr_bsc.usr_cd IN (Select ss_tbl.usr_cd from ss_tbl where ss_tbl.ss_ttl like :ss_ttl_like OR ss_tbl.ss_hbn like :ss_hbn_like And (ss_tbl.del_flg is null Or ss_tbl.del_flg = \'\')) OR usr_bsc.usr_cd IN (Select prtnr_tbl.usr_cd from prtnr_tbl where prtnr_tbl.sub_nm like :sub_nm_like And (prtnr_tbl.del_flg is null Or prtnr_tbl.del_flg = \'\'))) Order by usr_bsc.usr_ym , usr_bsc.usr_cd'); $stmt -> bindValue(':usr_nm_like', $usr_nm_like, PDO::PARAM_STR); $stmt -> bindValue(':usr_note_like', $usr_note_like, PDO::PARAM_STR); $stmt -> bindValue(':ss_ttl_like', $ss_ttl_like, PDO::PARAM_STR); $stmt -> bindValue(':ss_hbn_like', $ss_hbn_like, PDO::PARAM_STR); $stmt -> bindValue(':sub_nm_like', $sub_nm_like, PDO::PARAM_STR); } */ // クエリの実行 //print($query); $stmt->execute(); $rs_cnt=$stmt->rowCount(); $stmt_exh = $pdo->prepare('Select exh_mst.exh_nm From exh_mst WHERE exh_mst.exh_cd = :exh AND (exh_mst.del_flg is null or exh_mst.del_flg = \'\')'); $stmt_exh -> bindValue(':exh', $exh, PDO::PARAM_INT); // クエリの実行 $stmt_exh->execute(); $rs_exh_cnt=$stmt_exh->rowCount(); while ($ekh_row = $stmt_exh->fetch(PDO::FETCH_ASSOC)) { $exh_nm = disp_backslash_escape(htmlspecialchars(trim($ekh_row['exh_nm']), ENT_QUOTES, "UTF-8")); } /* if($exh == "forum") { $exh_nm = "はかる・調べるフォーラム"; } */ } else { print("Error!"); die; } ?> <?php print($exh_nm);?>
<?php print($exh_nm); ?>

Webポータル展⽰

"> はかる・調べるフォーラム

">計量計測展

">センサエキスポジャパン2021

">総合検査機器展

">SUBSEA TECH JAPAN 2021

">自動認識総合展

">地盤技術フォーラム

\n"); print("
\n"); print("
\n"); print("

フリーワード検索：

\n"); print("
\n"); print(" \n"); print(" \n"); print("
\n"); print("
\n"); print("
\n"); print("\n"); print("
\n"); print("

50音検索

\n"); print("\n"); print("\n"); print("\n"); print("
\n"); print("\n"); print(" \n"); print("
\n"); print("

出展社一覧

\n"); print("
\n"); print("
\n"); print("
\n"); if($rs_cnt == 0){ print("

該当する出展社がありません。

"); }else{ while ($arylst = $stmt->fetch(PDO::FETCH_ASSOC)) { $usr_cd = disp_backslash_escape(htmlspecialchars(trim($arylst['usr_cd']), ENT_QUOTES, "UTF-8")); $usr_nm = disp_backslash_escape(htmlspecialchars(trim($arylst['usr_nm']), ENT_QUOTES, "UTF-8")); $usr_ym = disp_backslash_escape(htmlspecialchars(trim($arylst['usr_ym']), ENT_QUOTES, "UTF-8")); $usr_note = disp_backslash_escape(htmlspecialchars(trim($arylst['usr_note']), ENT_QUOTES, "UTF-8")); $exh_cd = disp_backslash_escape(htmlspecialchars(trim($arylst['exh_cd']), ENT_QUOTES, "UTF-8")); $pbc_flg = disp_backslash_escape(htmlspecialchars(trim($arylst['pbc_flg']), ENT_QUOTES, "UTF-8")); include($base_path."autoid2024/module/str_50.inc"); //配列 print("
\n"); print("
\"\"
\n"); print("
\n"); print("
\n"); print("

\n"); if($pbc_flg == "1"){ print(""); } print($usr_nm); if($pbc_flg == "1"){ print("\n"); } $prtnr_stmt = $pdo->prepare('Select prtnr_tbl.sub_nm, prtnr_tbl.sub_nm_e, prtnr_tbl.sub_url, prtnr_tbl.sub_url_e From prtnr_tbl, usr_bsc WHERE prtnr_tbl.usr_cd = usr_bsc.usr_cd AND prtnr_tbl.usr_cd = :ucd AND (prtnr_tbl.del_flg is null or prtnr_tbl.del_flg = \'\') AND (usr_bsc.del_flg is null or usr_bsc.del_flg = \'\') Order by prtnr_tbl.prtnr_id'); $prtnr_stmt -> bindValue(':ucd', $usr_cd, PDO::PARAM_INT); $prtnr_stmt->execute(); $prtnr_stmt_cnt=$prtnr_stmt->rowCount(); if($prtnr_stmt_cnt > 0){ while ($ary_prtnr = $prtnr_stmt->fetch(PDO::FETCH_ASSOC)) { $sub_nm = disp_backslash_escape(htmlspecialchars(trim($ary_prtnr['sub_nm']), ENT_QUOTES, "UTF-8")); $sub_url = disp_backslash_escape(htmlspecialchars(trim($ary_prtnr['sub_url']), ENT_QUOTES, "UTF-8")); print("／"); // if($sub_url != ""){ // print(""); // } print($sub_nm); // if($sub_url != ""){ // print(""); // } print("\n"); } } print("

\n"); if($usr_note != ""){ print(mb_substr($usr_note,0,35)); if(mb_strlen($usr_note) > 35){ print("..."); } } print("
\n"); if($pbc_flg == "1"){ 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"); if($pbc_flg == "1"){ if($exh_cd == "autoid"){ print(""); } else { print(""); } } print("".$usr_nm.""); if($pbc_flg == "1"){ print("\n"); } if($exh_cd == "autoid"){ $query = "Select prtnr_tbl.sub_nm, prtnr_tbl.sub_url From ".$autoid_db_name.".prtnr_tbl, ".$autoid_db_name.".usr_bsc WHERE prtnr_tbl.usr_cd = usr_bsc.usr_cd AND prtnr_tbl.usr_cd = ".$usr_cd." AND (prtnr_tbl.del_flg is null or prtnr_tbl.del_flg = '') AND (usr_bsc.del_flg is null or usr_bsc.del_flg = '') Order by prtnr_tbl.prtnr_id"; $prtnr_stmt = $pdo->prepare($query); } else { $prtnr_stmt = $pdo->prepare('Select prtnr_tbl.sub_nm, prtnr_tbl.sub_nm_e, prtnr_tbl.sub_url, prtnr_tbl.sub_url_e From prtnr_tbl, usr_bsc WHERE prtnr_tbl.usr_cd = usr_bsc.usr_cd AND prtnr_tbl.usr_cd = :ucd AND (prtnr_tbl.del_flg is null or prtnr_tbl.del_flg = \'\') AND (usr_bsc.del_flg is null or usr_bsc.del_flg = \'\') Order by prtnr_tbl.prtnr_id'); $prtnr_stmt -> bindValue(':ucd', $usr_cd, PDO::PARAM_INT); } $prtnr_stmt->execute(); $prtnr_stmt_cnt=$prtnr_stmt->rowCount(); if($prtnr_stmt_cnt > 0){ while ($ary_prtnr = $prtnr_stmt->fetch(PDO::FETCH_ASSOC)) { $sub_nm = disp_backslash_escape(htmlspecialchars(trim($ary_prtnr['sub_nm']), ENT_QUOTES, "UTF-8")); $sub_url = disp_backslash_escape(htmlspecialchars(trim($ary_prtnr['sub_url']), ENT_QUOTES, "UTF-8")); print("／"); if($sub_url != ""){ print(""); } print($sub_nm); if($sub_url != ""){ print(""); } print("\n"); } } if($usr_note != ""){ print("

"); print(mb_substr($usr_note,0,35)); if(mb_strlen($usr_note) > 35){ print("..."); } print("

\n"); } print("\n"); print("\n"); if($pbc_flg == "1"){ if($exh_cd == "autoid"){ print(""); print("\"詳細\""); print("\n"); } else { print(""); print("\"詳細\""); print("\n"); } } print("\n"); print("\n"); print("\"".$exh_nm."\"\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"); } //アクセス数の格納 if($exh === "forum"){ $acc_exh = 0; } else { $acc_exh = $exh; } $stmt = $pdo->prepare('INSERT INTO list_acc (acc_page, applydate) VALUES (:exh_cd, :applydate)'); $stmt -> bindValue(':exh_cd', $acc_exh, PDO::PARAM_INT); $stmt -> bindValue(':applydate', $nowdate, PDO::PARAM_STR); $stmt->execute(); ?>