"); //基準のexh_cd if($ucd != ""){ $stmt = $pdo->prepare('Select exh_mst.exh_cd, exh_mst.exh_nm From exh_mst, usr_bsc WHERE usr_bsc.usr_cd =:ucd 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.pbc_flg = \'1\')'); $stmt -> bindValue(':ucd', $ucd, PDO::PARAM_INT); // クエリの実行 $stmt->execute(); $stmt_cnt=$stmt->rowCount(); while ($ekh_row = $stmt->fetch(PDO::FETCH_ASSOC)) { $exh_cd = disp_backslash_escape($ekh_row["exh_cd"]); $exh_nm = disp_backslash_escape($ekh_row["exh_nm"]); } if($stmt_cnt !== 1) { print("Error!"); die; } require_once($base_path."autoid2024/module/edit_usr_select.inc"); //usr_cd(ucd)から出展社情報を抽出 } else { print("Error!"); die; } require_once($base_path."autoid2024/views/usr_detail.inc"); ?>