DAT004.php
2.2 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
<?php
//*****************************************************************************
//*
//* プログラム名：資料集
//* プログラムID：DAT004.php
//* 機能 ：更新.追加.削除
//* 作成者 ：新谷(MTC)
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strTempPath="temp/".$PHP_FOLDER_NAME."/siryou/";
if ($intsyorists==1){
//アップロード
$reg_date=date("Y/m/d");
$reg_time=date("H:i:s");
$strSql = "SELECT * FROM siryo_tbl ORDER BY seq DESC";
$rsRecset = pg_exec($pg_con,$strSql);
$intRsCnt = pg_numrows($rsRecset);
if ($intRsCnt==0) {
$seqNum=1;
}else{
$seqNum=pg_result($rsRecset,0,"seq")+1;
}
$upfile_name=str_replace(".","/",$upfile_name);
list($strname,$strextension)=split("/",$upfile_name);
$upfile_name="siryo_".$seqNum.".".$strextension;
$file_name_jp=$strname.".".$strextension;
$file = $strTempPath.$upfile_name;
if (@move_uploaded_file($upfile,$file)!=0 ) {
$strSql = "DELETE FROM siryo_tbl WHERE filename = '$upfile_name'";
$rsRecset = pg_exec($strSql);
$strSql="INSERT INTO siryo_tbl (seq,filename,filename_jp,syain_cd,up_date,up_time,comment,ctg_no,send_bumon)".
"VALUES($seqNum,'$upfile_name','$file_name_jp','$PHP_SYAIN_CD',".
"'$reg_date','$reg_time','$comment',$ctg,$send_bumon)";
$varResult = pg_exec($pg_con,$strSql);
} else {
echo "<BR>";
echo "<center><font color='#FF0000'>アップロードに失敗しました</font></center>";
echo "<BR>";
echo "<BR>";
exit;
}
}
else{
//削除
//ファイル名取得
$strSql="SELECT filename FROM siryo_tbl WHERE seq = $intseq";
$objRecSet = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$intRsCnt = pg_numrows($objRecSet);
if ($intRsCnt!=0) {
$objRecData = pg_fetch_object($objRecSet, 0);
$Res = unlink($strTempPath.$objRecData->filename);
}
$strSql = "DELETE FROM siryo_tbl WHERE seq = $intseq";
$rsRecset = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(delete)");
exit;
}
}
header("Location:DAT001.php");
?>