-
Notifications
You must be signed in to change notification settings - Fork 27
/
Copy pathupdate_goods.php
144 lines (143 loc) · 5.61 KB
/
update_goods.php
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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
<?php
$id=$_GET["id"];
include_once 'conn.php';
$ndate =date("Y-m-d");
$addnew=$_POST["addnew"];
$sql="select * from jiudianyuding where id=".$id;
$query=mysql_query($sql);
$rowscount=mysql_num_rows($query);
?>
<script src="js/jquery-2.1.3.min.js" type="text/javascript" charset="utf-8"></script>
<script src="js/sweetalert.min.js" type="text/javascript" charset="utf-8"></script>
<?php
if ($addnew=="1" )
{
$name=$_POST["name"];
$grade=$_POST["grade"];
$price=$_POST["price"];
$time=$_POST["time"];
$state=$_POST["state"];
$personal=$_POST["personal"];
$number=$_POST["number"];
$remarks=$_POST["remarks"];
$sql="update jiudianyuding set name='$name',grade='$grade',price='$price',state='$state',personal='$personal',time='$time',number='$number',remarks='$remarks' where id= ".$id;
mysql_query($sql);
echo
"<script>
$(function(){
swal('成功','修改订单信息','success').then(() => {
location.href='check_goods.php';
})});
</script>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>更新客房订单信息</title>
<link rel="stylesheet" href="css/bootstrap.min.css" />
<link rel="stylesheet" href="css/jquery.mCustomScrollbar.min.css" />
<link rel="stylesheet" href="css/custom.css" />
<link rel="stylesheet" href="css/demo_add.css" />
<link rel="stylesheet" href="css/font-awesome.min.css" />
<link rel="stylesheet" href="css/style.css" />
</head>
<body class="add_news_body">
<!--客房订单信息修改-->
<div class="add_news">
<div class="clearfix admin_con_top">
<h2 class="fl">客房订单信息修改</h2>
<p class="fr">当前日期： <?php echo $ndate; ?></p>
</div>
<div class="add_news_box">
<?php
$sql="select * from jiudianyuding where id=".$id;
$query=mysql_query($sql);
$rowscount=mysql_num_rows($query);
if($rowscount>0)
{
?>
<form id="form1" name="form1" method="post" action="">
<ul>
<li>
<span class="user">客房名称：</span>
<input name='name' type='text' id='name' class="disable" autocomplete="off" style="cursor:not-allowed" readonly value='<?php echo mysql_result($query,$i,name);?>'/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password">客房星级：</span>
<input name='grade' type='text' id='grade' class="disable" autocomplete="off" style="cursor:not-allowed" readonly value='<?php echo mysql_result($query,$i,grade);?>' /> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password">客房价格：</span>
<input name='price' type='text' id='price' class="disable" autocomplete="off" style="cursor:not-allowed" readonly value='<?php echo mysql_result($query,$i,price);?>'/> *
</li>
<li>
<span class="password">客房状态：</span>
<select name="state" id="state" value="<?php echo mysql_result($query,$i,state);?>'/>"> *
<option value="1">1</option>
<option value="0">0</option>
</select>
</li>
<li>
<span class="password">客户姓名：</span>
<input name='personal' type='text' id='personal'autocomplete="off" value='<?php echo mysql_result($query,$i,personal);?>'/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password">预定时间：</span>
<input name='time' type='text' id='time' class="disable" autocomplete="off" readonly style="cursor:not-allowed" readonly value='<?php echo date("Y/m/d",strtotime(mysql_result($query,$i,time)));?>'/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password">预订人数：</span>
<input name='number' type='text' id='number' autocomplete="off" value='<?php echo mysql_result($query,$i,number);?>'/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password news_ab">备注信息：</span>
<span class="none"></span>
<textarea name="remarks" id="remarks" value=""/><?php echo mysql_result($query,$i,remarks);?></textarea>
</li>
</ul>
<div class="bottom_box">
<input type="submit" name="Submit" value="修改" onclick="return check();" >
<input type="reset" name="Submit2" value="重置"/>
<input type="hidden" name="addnew" value="1" />
</div>
</form>
<?php
}
?>
</div>
</div>
<!--客房订单信息修改end-->
<script>
function check()
{
if(document.getElementById("personal").value==""){
swal({
title: "失败！",
text: "姓名不能修改为空！",
icon: "error",
showConfirmButton: true
})
document.getElementById("personal").focus();
return false;
}
if(document.getElementById("number").value==0){
swal({
title: "失败！",
text: "预订人数不能小于1！",
icon: "error",
showConfirmButton: true
})
document.getElementById("number").focus();
return false;
}
}
</script>
</body>
</html>