MST1212.php
2.38 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
<?PHP
//*****************************************************************************
//*
//* プログラム名：め〜るNiポン！V2
//* プログラムID：MST1212.php
//* 機能 ：グループ登録
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/session_start.inc");
include("./include/SessionChk2.inc");
include("./include/dbcon.inc");
switch ($_POST["pMode"]) {
case "1":
//***** 新規 *****
$strSQL = "SELECT * FROM mst_group ORDER BY group_id desc";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRec)==0){
$intGroup_Count=1;
}else{
$objData = pg_fetch_object($objRec, 0);
$intGroup_Count = (integer)$objData->group_id+1;
}
$SetGroup_id = sprintf("%03d",$intGroup_Count);
$strSQL = "INSERT INTO ";
$strSQL .= " mst_group ";
$strSQL .= "(";
$strSQL .= " group_id ,";
$strSQL .= " group_name ";
$strSQL .= ")";
$strSQL .= " VALUES ";
$strSQL .= "(";
$strSQL .= "'".$SetGroup_id."',";
$strSQL .= "'".$_POST["group_name"]."' ";
$strSQL .= ")";
//echo $strSQL;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(INSERT)");
exit;
}
break;
case "2":
//***** 更新 *****
$strSQL = "UPDATE ";
$strSQL .= " mst_group ";
$strSQL .= "SET";
$strSQL .= " group_name='".$_POST["group_name"]."' ";
$strSQL .= "WHERE ";
$strSQL .= " group_id = '".$_POST["group_id"]."' ";
//echo $strSQL;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
break;
case "3":
//***** 削除 *****
$strSQL = "DELETE ";
$strSQL .= "FROM";
$strSQL .= " mst_group ";
$strSQL .= "WHERE ";
$strSQL .= " group_id = '".$_POST["group_id"]."' ";
//echo $strSQL;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
//***** group_INFO削除 *****
$strSQL = "DELETE ";
$strSQL .= "FROM";
$strSQL .= " group_info ";
$strSQL .= "WHERE ";
$strSQL .= " group_id = '".$_POST["group_id"]."' ";
//echo $strSQL;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
break;
}
header("Location:./MST1210.php");
exit;
?>