del_user.php
1.3 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
<?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-1 ; $intCnt++) {
// $objRecData = pg_fetch_object($objRecSet, $intCnt);
$user_id = $disp_user_id[$intCnt];
//表示名称を取得
$strSQL = "SELECT db_name " .
"FROM mst_kanri " .
"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);
$db_name = $objRecData3->db_name;
}else{
$db_name = "";
}
$strSQL = "drop database ".$db_name."";
//echo $strSQL;
$objRecSet3 = pg_exec($pg_con2,$strSQL);
if($objRecSet3==false){
$res = "False";
}
}
header("Location: point_menu.php");
?>