-
Notifications
You must be signed in to change notification settings - Fork 93
/
changebookingstatus.php
122 lines (112 loc) · 3.31 KB
/
changebookingstatus.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
<html>
<head>
<link rel="stylesheet" href=".css">
<script src="https://code.jquery.com/jquery-2.1.1.min.js" type="text/javascript"></script>
</head><?php include "dbconfig.php"; ?>
<style>
table{
width: 100%;
border-collapse: collapse;
border: 4px solid black;
padding: 1px;
font-size: 25px;
}
th{
border: 1px solid black;
background-color: #4CAF50;
color: white;
text-align: left;
}
tr,td{
border: 1px solid black;
background-color: white;
color: black;
}
</style>
<body style="background-color:white">
<div class="header">
</div>
<form action="changebookingstatus.php" method="post">
<div class="sucontainer">
<label style="font-size:20px" >Doctor:</label><br>
<select name="doctor" id="doctor-list" class="demoInputBox" style="width:100%;height:35px;border-radius:9px">
<option value="">Select Doctor</option>
<?php
$sql1="SELECT * FROM doctor";
$results=$conn->query($sql1);
while($rs=$results->fetch_assoc()) {
?>
<option value="<?php echo $rs["DID"]; ?>"><?php echo "Dr. ".$rs["Name"]; ?></option>
<?php
}
?>
</select>
<br>
<label><b>Date:</b></label><br>
<input type="date" name="dateselected" required><br><br>
<br>
<button type="submit" style="position:center" name="submit" value="Submit">Submit</button>
</form>
<?php
session_start();
if(isset($_POST['submit']))
{
include 'dbconfig.php';
$did=$_POST['doctor'];
$cid=1;
$dateselected=$_POST['dateselected'];
$sql1 = "select * from book where DOV='". $_POST['dateselected']."' AND DID= $did AND CID= $cid order by Timestamp ASC";
$results1=$conn->query($sql1);
require_once("dbconfig.php");
?>
<form action="changebookingstatus.php" method="post">;
<table>
<tr>
<th>UserName</th>
<th>First Name</th>
<th>DOV</th>
<th>Timestamp</th>
<th>Status</th>
</tr>
<?php
while($rs1=$results1->fetch_assoc())
{
echo "<tr>";
echo '<td><input type="text" name="username[]" id="username" value="'.$rs1["Username"].'" readonly></td>'
.'<td><input type="text" name="fname[]" id="fname" value="'.$rs1["Fname"].'" readonly></td>'
.'<td><input type="date" name="dov[]" id="dov" value="'.$rs1["DOV"].'" readonly></td>'
.'<td><input type="text" name="timestamp[]" id="timestamp" value="'.$rs1["Timestamp"].'" readonly></td>'
.'<td><input type="text" name="status[]" id="status" value="'.$rs1["Status"].'"></td></tr>' ;
}
?>
</table>
<button type="submit" style="position:center" name="submit2" value="Submit">Submit Changes</button></form>
<?php
}
require_once("dbconfig.php");
if(isset($_POST['submit2']))
{
$usrnm=$_POST["username"];
$fnm=$_POST["fname"];
$tmstmp=$_POST["timestamp"];
$stts=$_POST["status"];
$dt=$_POST["dov"];
$n=count($usrnm);
for($j=0;$j<$n;$j++)
{
$updatequery="update book set Status='$stts[$j]' where username='$usrnm[$j]' and timestamp='$tmstmp[$j]'";
if (mysqli_query($conn, $updatequery))
{
echo "$fnm[$j] :Status updated successfully..!!<br>";
}
else
{
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
echo "Redirecting.....";
header( "Refresh:3; url=changebookingstatus.php");
}
?>
</body>
</html>