CON002_1.php
2.09 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
<?php
//*****************************************************************************
//*
//* プログラム名：会社情報DB設定処理
//* プログラムID：CON002_1
//* 機能 ：会社情報をDB設定する
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/dbcon.inc");
$kaisya_kj = addslashes($kaisya_kj);
$dai_sei_kj = addslashes($dai_sei_kj);
$dai_mei_kj = addslashes($dai_mei_kj);
$homepage = addslashes($homepage);
$strSql = "SELECT company_name,company_name_kn,dai_name_sei_kj,dai_name_mei_kj,dai_name_sei_kn,dai_name_mei_kn,";
$strSql = $strSql."create_date,sihonkin,hp_adr,email FROM mst_company";
$rsRecset = pg_exec($pg_con,$strSql);
$intRsCnt = pg_numrows($rsRecset);
$strWkDate=sprintf("%d/%02d/%02d",$souritu_year,$souritu_month,$souritu_day);
$strSourituDate = $strWkDate;
$strEmail=$email1."@".$email2;
//レコードが無い場合（新規登録）
if($sihonkin == ""){
$sihonkin = "Null";
}
if ($intRsCnt==0) {
$strSql = "INSERT INTO mst_company VALUES(";
$strSql = $strSql."'$kaisya_kj','$kaisya_kn','$dai_sei_kj','$dai_mei_kj',";
$strSql = $strSql."'$dai_sei_kn','$dai_mei_kn','$strSourituDate',";
$strSql = $strSql."$sihonkin,'$homepage','$strEmail')";
}else{
//レコードが2件以上の場合
if ($intRsCnt >= 2) {
echo "<Script language=\"JavaScript\">\n";
echo "alert('データベースが破損しています。管理者にお問い合わせください')\n";
echo "</Script>\n";
exit;
}
//レコードが1件の場合（更新）
$strSql = "UPDATE mst_company SET ";
$strSql .= "company_name='$kaisya_kj', ";
$strSql .= "company_name_kn='$kaisya_kn', ";
$strSql .= "dai_name_sei_kj='$dai_sei_kj', ";
$strSql .= "dai_name_mei_kj='$dai_mei_kj', ";
$strSql .= "dai_name_sei_kn='$dai_sei_kn', ";
$strSql .= "dai_name_mei_kn='$dai_mei_kn', ";
$strSql .= "create_date='$strSourituDate', ";
$strSql .= "sihonkin=$sihonkin, ";
$strSql .= "hp_adr='$homepage', ";
$strSql .= "email='$strEmail'; ";
}
$varResult = pg_exec($pg_con,$strSql);
header("Location: CON001.php");
?>