forked from hzequn/PHP_hotel
-
Notifications
You must be signed in to change notification settings - Fork 0
/
update_room.php
131 lines (127 loc) · 4.68 KB
/
update_room.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
<?php
$id=$_GET["id"];
include_once 'conn.php';
$ndate =date("Y-m-d");
$addnew=$_POST["addnew"];
?>
<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"];
$picture=$_POST["picture"];
$remarks=$_POST["remarks"];
$number=$_POST['number'];
$sql="update jiudianxinxi set name='$name',grade='$grade',price='$price',number='$number',picture='$picture',remarks='$remarks' where id= ".$id;
mysql_query($sql);
echo
"<script>
$(function(){
swal('成功','修改客房信息','success').then(() => {
location.href='check_room.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 jiudianxinxi 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' value='<?php echo mysql_result($query,$i,name);?>' autocomplete="off"/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password">客房星级：</span>
<select name='grade' id='grade'> *
<option value="五星级">五星级</option>
<option value="四星级">四星级</option>
<option value="三星级">三星级</option>
<option value="二星级">二星级</option>
</select>
</li>
<li>
<span class="password">客房价格：</span>
<input name='price' type='text' id='price' value='<?php echo mysql_result($query,$i,price);?>' autocomplete="off"/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li>
<span class="password">剩余数量：</span>
<input name='number' type='text' id='number' value='<?php echo mysql_result($query,$i,number);?>' autocomplete="off"/> *
<input type='text' style='display:none'> <!-- 针对firefox -->
</li>
<li style="position:relative;">
<span class="password">客房图片：</span>
<input name='picture' type='text' id='picture' readonly autocomplete="off" value="<?php echo mysql_result($query,$i,picture);?>" style="cursor:pointer;"/>
<input id="uploadImg" name="upfile" type="file" class="imgBtn" style="cursor:pointer;"/>
</li>
<li>
<span class="password news_ab">客房备注：</span>
<span class="none"></span>
<textarea name="remarks" id="remarks" /><?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 language="javascript">
function uploadImg(){
var url = "upfile.php";
var data = new FormData($("#form1")[0])
$.ajax({
url: url,
type: "POST",
data:data,
contentType:false,
processData:false,
success: function(res){
document.getElementById("picture").value=res;
}
})
}
$(function(){
$("#uploadImg").change(function(){
uploadImg();
})
})
</script>
</body>
</html>