SIM0011.php
3.07 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
//*****************************************************************************
//* プログラム名：ユーザログインチェック
//* プログラムID：SIM0011.php
//* 機能 ：グループログインチェック
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/dbcon.inc");
include('./inc/smarty.conf');
$errFlg = 1;
session_unregister("PHP_BUMON_SEQ");
session_unregister("PHP_BUMON_NAME");
session_unregister("PHP_BUMON_ADMIN");
session_unregister("PHP_USER_SEQ");
session_unregister("PHP_USER_NAME");
session_unregister("PHP_USER_ADMIN");
session_unregister("PHP_USER_NYUKIN");
session_unregister("PHP_USER_SHIKIN");
if(trim($_POST["useq"]) != "" && trim($_POST["upw"]) != ""){
$useq = trim($_POST["useq"]);
$upw = trim($_POST["upw"]);
// $strSQL = "SELECT * FROM user_inf WHERE user_seq = '".$useq."' AND user_pw='".$upw."'";
$strSQL = "SELECT bm.bumon_seq, bm.bumon_name, bm.all_flg, us.user_seq, us.user_namekj, ";
$strSQL .= "us.admin_flg, us.nyukin_flg, us.shikin_flg FROM user_inf AS us ";
$strSQL .= "INNER JOIN bumon_tbl AS bm ON (us.bumon_seq = bm.bumon_seq) ";
$strSQL .= "WHERE us.user_seq = '".$useq."' AND us.user_pw='".$upw."'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
//デバッグ
//echo($strSQL."<br>useq:".$useq."<br>numrows:".pg_numrows($objRecSet));
if (pg_numrows($objRecSet) == 1) {
$objData = pg_fetch_object($objRecSet, 0);
$PHP_BUMON_SEQ=($objData->bumon_seq);
$PHP_BUMON_NAME=($objData->bumon_name);
$PHP_BUMON_ADMIN=($objData->all_flg);
$PHP_USER_SEQ=($objData->user_seq);
$PHP_USER_NAME=($objData->user_namekj);
$PHP_USER_ADMIN=($objData->admin_flg);
$PHP_USER_NYUKIN=($objData->nyukin_flg);
$PHP_USER_SHIKIN=($objData->shikin_flg);
session_register("PHP_BUMON_SEQ");
session_register("PHP_BUMON_NAME");
session_register("PHP_BUMON_ADMIN");
session_register("PHP_USER_SEQ");
session_register("PHP_USER_NAME");
session_register("PHP_USER_ADMIN");
session_register("PHP_USER_NYUKIN");
session_register("PHP_USER_SHIKIN");
setcookie("cookie_user_cd",$useq,time() + 604800);
$errFlg = 0;
}else{
$errFlg = 1;
}
}else{
$errFlg = 1;
}
if($errFlg == 0){
header("Location:./SIM0100.php");
exit;
}else{
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; cahrset=euc-jp">
<meta http-equiv="content-style-type" content="text/css">
<meta name="robots" content="noindex, nofollow">
<title></title>
<script language="javascript">
function trans(){
document.frm.action = "SIM0010.php";
document.frm.method="POST";
document.frm.submit();
}
</script>
</head>
<body onload="trans();">
<form name="frm">
<input type="hidden" name="gid" value="<?PHP echo trim($_POST["gid"])?>">
<input type="hidden" name="gpw" value="<?PHP echo trim($_POST["gpw"])?>">
<input type="hidden" name="uid" value="<?PHP echo trim($_POST["useq"])?>">
<input type="hidden" name="upw" value="<?PHP echo trim($_POST["upw"])?>">
</form>
</body>
</html>
<?PHP
}
?>