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
|
<? include("../../manage/category/mscommon.php");
$msQry = "SELECT * From app_priv WHERE user_id = '$_COOKIE[COMID]' and app_id = '11'"; $msResult = MYSQL_QUERY($msQry); mysql_close;
$msRow = MYSQL_FETCH_ARRAY($msResult); $sa_uid = $msRow[user_id]; $sa_dbip = $msRow[app_dbip]; $sa_dbname = $msRow[app_dbname];
if( MYSQL_NUM_ROWS($msResult) > 0){
include("../carmate/common.php"); if( isset($mode) && $mode == "insert"){ // Á¤ºñ¿¹¾à »õ°Ô½Ã¹° ÀÔ·Â. $reg_date = date('Y-m-d'); $insertQry = "INSERT INTO `res_fix`(`sa_code`,`res_fix_date`,`cus_code`,`res_fix_detail`,`res_date`,`res_Online`,`res_fix_Check`) VALUES ('$sacode_','$txtdate','$cuscode_','$fixinfo','$reg_date','Online','0');"; mysql_query($insertQry);
?> <script> location.href = "ecarbookreserve.php";
</script> <? } if( $mode == "update" && $uid !== ""){ $reg_date = date('Y-m-d'); $updateQry = " update res_fix set res_fix_date = '$txtdate' , res_fix_detail = '$fixinfo', res_date = '$reg_date', res_fix_Check = '0' WHERE res_fix_code = '$uid' " ; mysql_query($updateQry); ?> <script> location.href = "ecarbookreserve.php"; </script> <? } if( $mode == "delete" && $uid !== ""){ $deleteQry = " delete from res_fix where res_fix_code = '$uid' "; mysql_query($deleteQry); ?> <script> location.href = "ecarbookreserve.php";
</script> <? } } ?>
|