pointup_all.php
1.61 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
<?PHP
// ポイントを一括加算減算する
//
$hostname="172.31.18.14";
$database="post_kanri";
if( !$pg_con2=pg_connect("host=$hostname port=5434 dbname=$database user=pgsqladmin password=pgsqladmin") ) {
print "Error : connect to ${hostname}<br>";
exit;
}
// //表示名称を取得
// $strSQL = "SELECT user_id " .
// "FROM mst_kanri " ;
// "WHERE user_id = '".$user_id."'";
// $objRecSet = pg_exec($pg_con2,$strSQL);
// if($objRecSet==false){
// $res = "False";
// }
// $intMax=pg_numrows($objRecSet);
$disp_user_id = split("/",$strChkDat);
$intMax = count($disp_user_id);
for($intCnt = 0; $intCnt < $intMax ; $intCnt++) {
// $objRecData = pg_fetch_object($objRecSet, $intCnt);
$user_id = $disp_user_id[$intCnt];
//表示名称を取得
$strSQL = "SELECT use_point,max_point,use_date " .
"FROM point_tbl " .
"WHERE user_id = '".$user_id."'";
$objRecSet3 = pg_exec($pg_con2,$strSQL);
if($objRecSet3==false){
$res = "False";
}
if(pg_numrows($objRecSet3)!=0){
$objRecData3 = pg_fetch_object($objRecSet3, 0);
$Point = $objRecData3->use_point;
}else{
$Point = 0;
}
if($flg==0){
$Point = (integer)$Point - (integer)$value;
}else{
$Point = (integer)$Point + (integer)$value;
}
if(pg_numrows($objRecSet3)!=0){
$strSQL = "Update point_tbl Set use_point=".$Point." where user_id='".$user_id."'";
}else{
$strSQL = "Insert into point_tbl (user_id,use_point,max_point) values ('".$user_id."',".$Point.",0)";
}
$objRecSet3 = pg_exec($pg_con2,$strSQL);
if($objRecSet3==false){
$res = "False";
}
}
header("Location: point_menu.php");
?>