-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathedit_lab.php
71 lines (52 loc) · 1.98 KB
/
edit_lab.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
<?php
require('connection.php');
?>
<DOCTYPE html>
<html>
<head>
<title> edit_lab </title>
</head>
<body>
<?php
if(isset($_GET['id']))
{
$getid=$_GET['id'];
$sql = "SELECT * FROM LAB WHERE Serial = $getid";
$query = $conn->query($sql);
$data = mysqli_fetch_assoc($query);
$Serial = $data['Serial'];
$Room_no = $data['Room_no'];
$Name = $data['Name'];
$Floor = $data['Floor'];
}
if(isset($_GET['Serial']))
{
$new_room = $_GET['Room_no'];
$new_name = $_GET['Name'];
$new_floor = $_GET['Floor'];
$new_serial = $_GET['Serial'];
$sql1 = "UPDATE LAB SET
Room_no= '$new_room' , Name= '$new_name ', Floor= '$new_floor'
WHERE Serial = $new_serial";
if( $conn->query($sql1)==TRUE)
{
echo'Update Successful';
}
else
{
echo'Update failed';
}
}
?>
<form action = "edit_lab.php" method = "GET">
ROOM : <br>
<input type = "text" name = "Room_no" value = "<?php echo $Room_no ?>" ><br><br>
LAB NAME : <br>
<input type = "text" name = "Name" value = "<?php echo $Name ?>"><br><br>
FLOOR : <br>
<input type = "text" name = "Floor" value = "<?php echo $Floor ?>"><br><br>
<input type = "text" name = "Serial" value = "<?php echo $Serial ?>" hidden>
<input type = "submit" value = "Update" ><br><br>
</form>
</body>
</html>