BBS002_m.php
4.47 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
//*****************************************************************************
//*
//* プログラム名：掲示板(携帯電話)
//* プログラムID：BBS002_m.php
//* 機能 ：詳細画面
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");
//*** 広告 ***//
include("include_m/Advertisement.inc");
//*** 共通処理 ***//
include("include_m/CommonProcess.inc");
//*** 掲示板***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'BBS001.php'";
$rsRecset = pg_exec($strMenuSQL);
$PHP_TITLE_NAME=mb_convert_encoding(pg_result($rsRecset,0,"name"), "SJIS", "EUC-JP");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<TITLE>E-グルPro(<?php echo $PHP_TITLE_NAME; ?>)</TITLE>
</HEAD>
<BODY>
<center>
<?php echo $PHP_TITLE_NAME; ?>(詳細)<br>
<?php echo $strName; ?>
<HR width="100%">
<?php echo $koukokuTEL; ?>
</center>
<?php
//メニュー表示
include("include_m/CommonMenuReturn.inc");
?>
<HR width="100%">
<a href="BBS001_m.php?seq=<?php echo $objData->seq ?>&intPage=<?php echo $intPage ?>&<?php echo $PHP_Argument ?>"accesskey="1"><?php echo Get_Num("1"); ?>掲示板一覧</A>
<br><br>
<form method="GET" action="BBS004_m.php">
<?php
//掲示板情報取得
$strSQL = "SELECT bbs_TBL.syain_cd,read_flg,bbs_TBL.seq,title,syozoku_cd,send_bumon,voicedate,message,".
"voicetime,filename,filename_jp,name_kj_sei,name_kj_mei ".
"FROM bbs_TBL,pbbs_tbl,syain_TBL WHERE bbs_tbl.seq ='$seq' ".
" and ( bbs_TBL.seq = pbbs_tbl.seq and pbbs_tbl.syain_cd ='$PHP_SYAIN_CD' and bbs_TBL.syain_cd =syain_tbl.syain_cd) ".
" Order by read_flg,seq DESC";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objData = pg_fetch_object($objRecSet, 0);
$message = str_replace ("\n", "<BR>", mb_convert_encoding($objData->message, "SJIS", "EUC-JP" ));
$message = str_replace ("\t", " ", $message);
$message = str_replace (" ", " ", $message);
$message = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$message);
if ($objData->send_bumon==0){
$strSendBumon="全部門";
}else{
$strSendSql="SELECT bumon_name FROM mst_bumon WHERE syozoku_cd =$objData->send_bumon" ;
$objSend = pg_exec($strSendSql);
if($objSend==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objSendBumon = pg_fetch_object($objSend, 0);
$strSendBumon=mb_convert_encoding($objSendBumon->bumon_name, "SJIS", "EUC-JP" );
}
echo '【件名】';
// echo mb_convert_encoding($objData->title, "SJIS", "EUC-JP").'('.$strSendBumon.')<INPUT type="submit" NAME="intsts" VALUE="返信"><br>';
echo mb_convert_encoding($objData->title, "SJIS", "EUC-JP").'('.$strSendBumon.')<br>';
?>
<INPUT TYPE="hidden" NAME="seq" VALUE="<?php echo $objData->seq ?>">
<INPUT TYPE="hidden" NAME="intPage" VALUE="<?php echo $intPage ?>">
<?php
//*** 共通変数取得 ***//
include("include_m/CommonHidden.inc");
?>
</form>
<form method="GET" action="BBS003_m.php">
<?php
echo "【掲載者】";
echo mb_convert_encoding($objData->name_kj_sei, "SJIS", "EUC-JP" )." ".mb_convert_encoding($objData->name_kj_mei, "SJIS", "EUC-JP" )."<br>";
echo "【日時】";
echo mb_convert_encoding( $objData->voicedate, "SJIS", "EUC-JP" )." ".mb_convert_encoding( substr($objData->voicetime,0,5), "SJIS", "EUC-JP" )."<br>";
echo "【本文】<br>";
echo $message."<br>";
if ($objData->filename_jp != ""){
echo "【添付ファイル】<br>";
echo mb_convert_encoding($objData->filename_jp, "SJIS", "EUC-JP")."<br>";
}
//確認ボタン
if (mb_convert_encoding($objData->read_flg, "SJIS", "EUC-JP")==0){
echo '<br><center><INPUT type="submit" NAME="intsts" VALUE="確認"></center> ';
}
//削除ボタン
if (mb_convert_encoding($objData->syain_cd, "SJIS", "EUC-JP")==$PHP_SYAIN_CD){
echo '<center><INPUT type="submit" NAME="intsts" VALUE="削除"></center>';
}
?>
<br>
<a href="BBS001_m.php?seq=<?php echo $objData->seq ?>&intPage=<?php echo $intPage ?>&<?php echo $PHP_Argument ?>"accesskey="1"><?php echo Get_Num("1"); ?>掲示板一覧</A>
<HR width="100%">
<INPUT TYPE="hidden" NAME="seq" VALUE="<?php echo $objData->seq ?>">
<INPUT TYPE="hidden" NAME="intPage" VALUE="<?php echo $intPage ?>">
<?php
//メニュー表示
include("include_m/CommonMenuReturn.inc");
//*** 共通変数取得 ***//
include("include_m/CommonHidden.inc");
?>
</form>
</BODY>
</HTML>