-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate-appointment.php
138 lines (125 loc) · 6.25 KB
/
update-appointment.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
<?php
include "./dbcon.php";
$id = $_GET["updateid"];
$sql = "Select * from `appointments`where id=$id";
$result = mysqli_query($dbcon, $sql);
$row = mysqli_fetch_assoc($result);
$name = $row['name'];
$surname = $row['surname'];
$id_number = $row['id_number'];
$city = $row['city'];
$department = $row['department'];
$date = $row['date'];
if (isset($_POST['submit'])) {
$name = $_POST['name'];
$surname = $_POST['surname'];
$id_number = $_POST['id_number'];
$city = $_POST['city'];
$department = $_POST['department'];
$date = $_POST['date'];
mysqli_query($dbcon, "update `appointments` set id=$id,name='$name',surname='$surname',id_number='$id_number',city='$city',department='$department' where id='$id'");
header('location:./all-appointments.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!--Meta-->
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Update Appointment</title>
<link rel="icon" type="image/x-icon" href="https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQhOOn89h2oC2mX4CubFI1t2B2ftiUldDH5sHC9BFxd9g&s" />
<!--Bootstrap-->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body>
<?php include './header.php'; ?>
<!--Appointment-->
<section class="container rounded-3 mt-3">
<div class="row">
<!--Input-->
<form method="post" class="col col-md-6 d-flex flex-column align-items-center justify-content-center gap-3">
<div class="w-100 bg-light rounded-3-4 p-4">
<h4>Personal Information</h4>
<div class="input-group mb-2">
<div class="input-group-prepend">
<div class="input-group-text">Name</div>
</div>
<input type="text" class="form-control" id="NameInput" name="name" required value=<?php echo $name; ?> />
</div>
<div class="input-group mb-2">
<div class="input-group-prepend">
<div class="input-group-text">Surname</div>
</div>
<input type="text" class="form-control" id="SurnameInput" name="surname" required value=<?php echo $surname; ?> />
</div>
<div class="input-group mb-4">
<div class="input-group-prepend">
<div class="input-group-text">ID Number</div>
</div>
<input type="text" class="form-control" id="IdInput" name="id_number" required value=<?php echo $id_number; ?> />
</div>
<h4>Appointment Information</h4>
<div class="input-group mb-2">
<div class="input-group-prepend">
<div class="input-group-text">City</div>
</div>
<select class="form-control" id="CityInput" name="city" required>
<option>
<?php echo $city; ?>
</option>
<option>Antalya</option>
<option>Izmir</option>
<option>Tekirdag</option>
<option>Istanbul</option>
<option>Ankara</option>
</select>
</div>
<div class="input-group mb-2">
<div class="input-group-prepend">
<div class="input-group-text">Department</div>
</div>
<select class="form-control" id="DepartmentInput" name="department" placeholder="Choose City" required>
<option>
<?php echo $department ?>
</option>
<option>Oral and Dental Diseases</option>
<option>Eye Diesases</option>
<option>Ear, Nose and Throat Diseases</option>
<option>General Surgery</option>
<option>Plastic Surgery</option>
</select>
</div>
<div class="input-group mb-2">
<div class="input-group-prepend">
<div class="input-group-text">Date</div>
</div>
<input type="date" class="form-control" id="DateInput" name="date" required value=<?php echo $date; ?> />
</div>
<!--Button-->
<div class="d-flex gap-2 mt-3">
<button class="btn btn-danger w-100 rounded-2 text-light" type="button">
<a href="./home.php" class="nav-link">Back to the MainPage</a> </button>
<button class="btn btn-success w-100 rounded-2 text-light" id="BtnSubmit" name="submit" type="submit">
Update the Appointment
</button>
</div>
</div>
</form>
<!--Animation-->
<div class="col col-md-6 d-flex align-items-center justify-content-center">
<script src="https://unpkg.com/@lottiefiles/lottie-player@latest/dist/lottie-player.js"></script>
<lottie-player src="https://assets7.lottiefiles.com/packages/lf20_x1gjdldd.json" mode="bounce" background="transparent" speed="0.6" style="width: fit-content; height: fit-content" loop autoplay></lottie-player>
</div>
</div>
</section>
<!--JS-->
<script>
if (window.history.replaceState) {
window.history.replaceState(null, null, window.location.href);
}
</script>
</body>
</html>