KIN002.php
2.46 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
<?php
//*****************************************************************************
//*
//* プログラム名：個人情報
//* プログラムID：KIN002.php
//* 機能 ：個人情報更新
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
if (strlen($birth_m)==1){
$birth_m="0".$birth_m;
}
if (strlen($birth_d)==1){
$birth_d="0".$birth_d;
}
if (strlen($nyusya_m)==1){
$nyusya_m="0".$nyusya_m;
}
if (strlen($nyusya_d)==1){
$nyusya_d="0".$nyusya_d;
}
if ($birth_y != "" && $birth_m != "" && $birth_d != ""){
$birthday=$birth_y ."/". $birth_m . "/" .$birth_d;
}
if ($nyusya_y != "" && $nyusya_m != "" && $nyusya_d != ""){
$nyusya_date=$nyusya_y ."/". $nyusya_m ."/". $nyusya_d;
}
$mail_addr=$email1."@". $email2;
$yubin_no=$yubin_no1 . $yubin_no2;
$tel_no=$telno1 ."-". $telno2 ."-".$telno3;
$keitai_no=$keitaiNo1 ."-". $keitaiNo2 . "-". $keitaiNo3;
$address2 = addslashes($address2);
$address3 = addslashes($address3);
$address4 = addslashes($address4);
$strSql = "UPDATE syain_tbl SET name_kn_sei = '$sei_kn',name_kn_mei='$mei_kn',sex='$sex', ".
"birthday='$birthday',nyusya_date='$nyusya_date',mail_addr='$mail_addr', ".
"extension_no='$naisen_no',yubin_no='$yubin_no',addr_pref='$address1', ".
"addr_city='$address2',addr_banti='$address3',addr_apart='$address4', ".
"tel_no='$tel_no',keitai_no='$keitai_no' " .
"WHERE syain_cd = '$PHP_SYAIN_CD'";
//echo $strSql;
$objRecSet = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
$strSQL="SELECT * FROM syain_dat_tbl Where syain_cd='$PHP_SYAIN_CD'";
$objRec2 = pg_exec($strSQL);
if($objRec2==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$mail_addr_kei=$email_k1."@". $email_k2;
//データ存在時
if (pg_numrows($objRec2) > 0){
$strSql = "UPDATE syain_dat_tbl SET mail_addr_kei='$mail_addr_kei' ".
"WHERE syain_cd = '$PHP_SYAIN_CD'";
$objRecSet = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(UPDATE)");
exit;
}
}else{
$strSql = "INSERT INTO syain_dat_tbl VALUES ('$PHP_SYAIN_CD','$mail_addr_kei')";
$objRecSet = pg_exec($strSql);
if($objRecSet==false){
echo("SQL実行に失敗しました(INSERT)");
exit;
}
}
header("Location:KST001.php");
?>