-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathscheduleappointment.php
260 lines (245 loc) · 11.7 KB
/
scheduleappointment.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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Health Centre</title>
<link href="jquery-ui.min.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="jquery-1.11.1.min.js"></script>
<script type="text/javascript" src="jquery-ui.min.js"></script>
<script type="text/javascript" src="main_sau.js"></script>
<style type="text/css">
<!--
body {
font: 100%/1.4 Verdana, Arial, Helvetica, sans-serif;
background-color: #42413C;
margin: 0;
padding: 0;
color: #000;
}
/* ~~ Element/tag selectors ~~ */
ul, ol, dl { /* Due to variations between browsers, it's best practices to zero padding and margin on lists. For consistency, you can either specify the amounts you want here, or on the list items (LI, DT, DD) they contain. Remember that what you do here will cascade to the .nav list unless you write a more specific selector. */
padding: 0;
margin: 0;
}
h1, h2, h3, h4, h5, h6, p {
margin-top: 0; /* removing the top margin gets around an issue where margins can escape from their containing block. The remaining bottom margin will hold it away from any elements that follow. */
padding-right: 15px;
padding-left: 15px; /* adding the padding to the sides of the elements within the blocks, instead of the block elements themselves, gets rid of any box model math. A nested block with side padding can also be used as an alternate method. */
}
a img { /* this selector removes the default blue border displayed in some browsers around an image when it is surrounded by a link */
border: none;
}
/* ~~ Styling for your site's links must remain in this order - including the group of selectors that create the hover effect. ~~ */
a:link {
color: #42413C;
text-decoration: underline; /* unless you style your links to look extremely unique, it's best to provide underlines for quick visual identification */
}
a:visited {
color: #6E6C64;
text-decoration: underline;
}
a:hover, a:active, a:focus { /* this group of selectors will give a keyboard navigator the same hover experience as the person using a mouse. */
text-decoration: none;
}
/* ~~ This fixed width container surrounds all other blocks ~~ */
.container {
width: 960px;
background-color: #FFFFFF;
margin: 0 auto; /* the auto value on the sides, coupled with the width, centers the layout */
}
/* ~~ The header is not given a width. It will extend the full width of your layout. ~~ */
header {
background-color: #ADB96E;
}
/* ~~ These are the columns for the layout. ~~
1) Padding is only placed on the top and/or bottom of the block elements. The elements within these blocks have padding on their sides. This saves you from any "box model math". Keep in mind, if you add any side padding or border to the block itself, it will be added to the width you define to create the *total* width. You may also choose to remove the padding on the element in the block element and place a second block element within it with no width and the padding necessary for your design.
2) No margin has been given to the columns since they are all floated. If you must add margin, avoid placing it on the side you're floating toward (for example: a right margin on a block set to float right). Many times, padding can be used instead. For blocks where this rule must be broken, you should add a "display:inline" declaration to the block element's rule to tame a bug where some versions of Internet Explorer double the margin.
3) Since classes can be used multiple times in a document (and an element can also have multiple classes applied), the columns have been assigned class names instead of IDs. For example, two sidebar blocks could be stacked if necessary. These can very easily be changed to IDs if that's your preference, as long as you'll only be using them once per document.
4) If you prefer your nav on the left instead of the right, simply float these columns the opposite direction (all left instead of all right) and they'll render in reverse order. There's no need to move the blocks around in the HTML source.
*/
.sidebar1 {
float: left;
width: 180px;
background-color: #EADCAE;
padding-bottom: 10px;
}
.content {
padding: 10px 0;
width: 600px;
float: left;
}
aside {
float: left;
width: 180px;
background-color: #EADCAE;
padding: 10px 0;
}
/* ~~ This grouped selector gives the lists in the .content area space ~~ */
.content ul, .content ol {
padding: 0 15px 15px 40px; /* this padding mirrors the right padding in the headings and paragraph rule above. Padding was placed on the bottom for space between other elements on the lists and on the left to create the indention. These may be adjusted as you wish. */
}
/* ~~ The navigation list styles (can be removed if you choose to use a premade flyout menu like Spry) ~~ */
nav ul{
list-style: none; /* this removes the list marker */
border-top: 1px solid #666; /* this creates the top border for the links - all others are placed using a bottom border on the LI */
margin-bottom: 15px; /* this creates the space between the navigation on the content below */
}
nav li {
border-bottom: 1px solid #666; /* this creates the button separation */
}
nav a, nav a:visited { /* grouping these selectors makes sure that your links retain their button look even after being visited */
padding: 5px 5px 5px 15px;
display: block; /* this gives the link block properties causing it to fill the whole LI containing it. This causes the entire area to react to a mouse click. */
width: 160px; /*this width makes the entire button clickable for IE6. If you don't need to support IE6, it can be removed. Calculate the proper width by subtracting the padding on this link from the width of your sidebar container. */
text-decoration: none;
background-color: #C6D580;
}
nav a:hover, nav a:active, nav a:focus { /* this changes the background and text color for both mouse and keyboard navigators */
background-color: #42E1DA;
color: #FFF;
}
/* ~~ The footer ~~ */
footer {
padding: 10px 0;
background-color: #CCC49F;
position: relative;/* this gives IE6 hasLayout to properly clear */
clear: both; /* this clear property forces the .container to understand where the columns end and contain them */
}
/* ~~ Miscellaneous float/clear classes ~~ */
.fltrt { /* this class can be used to float an element right in your page. The floated element must precede the element it should be next to on the page. */
float: right;
margin-left: 8px;
}
.fltlft { /* this class can be used to float an element left in your page. The floated element must precede the element it should be next to on the page. */
float: left;
margin-right: 8px;
}
.clearfloat { /* this class can be placed on a <br /> or empty block element as the final element following the last floated block (within the .container) if the footer is removed or taken out of the .container */
clear:both;
height:0;
font-size: 1px;
line-height: 0px;
}
/*HTML 5 support - Sets new HTML 5 tags to display:block so browsers know how to render the tags properly. */
header, section, footer, aside, article, figure {
display: block;
text-align: center;
}
-->
</style><!--[if lt IE 9]>
<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]--></head>
<body>
<div class="container">
<header>
<a href="/index.php"><img src="/images/photo.jpg" alt="loading" width="180" height="90" id="Insert_logo" style="background-color: #FFFFFF; display: block; background-image: url(src);" /></a>
</header>
<div class="sidebar1">
<nav>
<ul>
<li style="font-weight:bold"> Schedule an </li>
<li style="font-weight:bold"> Appointment</li>
<li><a href="./checkappointment.php">Check Appointment</a></li>
<li><a href="./feedback.php">Feedback</a></li>
</ul>
</nav>
<aside>
<p>If there is any immediate attention required, please do not take appointment rather Dial 911 or contact local hospital.</p>
</aside>
<!-- end .sidebar1 --></div>
<article class="content">
<h2>Schedule Appointment</h2>
<section>
<?php
require "./db/db.php";
if(!isset($rowcnt))
{
$rowcnt = 0;
}
if((isset($_POST['studentid'])) && (isset($_POST['dob']))){
$sql = "select s.student_id, s.student_dob from student as s where s.student_id= ".$_POST['studentid']." and s.student_dob = '".$_POST['dob']."'";
$rowcnt = rowcount($sql);
}
if($rowcnt!=1){
?>
<h2>Login</h2>
<form action="scheduleappointment.php?c=1" method="post">
<table border="0" cellspacing="0" cellpadding="2" >
<tr>
<td style="align-content:flex-start"><label for="textfield2">Student ID</label></td>
<td><input type="text" name="studentid" id="textfield2" autocomplete="off"></td>
</tr>
<tr>
<td nowrap> Date of Birth :</td>
<td>
<input type="text" id="textfield5" name="dob">
<!-- <input type="text" id="datepicker" name="dob">-->
</td>
<td>
(YY-MM-DD)
</td>
</tr>
</table>
<input type="hidden" value="<?php $_POST['a'] ?>" name=a>
<p>
<input type="submit" name="submit" id="submit" value="Submit">
<?php
if (isset($_GET['c'])){
echo "<br />Please enter correct student id or date of birth";
}
?>
</p>
</form>
</section>
<?php
}elseif($rowcnt==1){
$htmlcode="<section><h3>Dates Available-</h3><form action='./scheduleapp.php' method='post'><table border='0' cellspacing='0' cellpadding='2'><tr><td><select name='date'>";
$sql2="select distinct(date) from appointment_status where status<15 and date between current_date() and (current_date()+15)";
$sql3="select distinct(time) from appointment_status where status<15 and date between current_date() and (current_date()+15)";
$result2 = db($sql2);
$result3 = db($sql3);
while($row2 = $result2->fetch_assoc()){
$htmlcode= $htmlcode." <option value=".$row2['date']."> ".$row2['date']."</option>";
}
$htmlcode= $htmlcode."</select></td><td><select name='time'>";
while($row3 = $result3->fetch_assoc()){
$htmlcode= $htmlcode." <option value=".$row3['time']."> ".$row3['time']."</option>";
}
$htmlcode= $htmlcode."</select></td></tr>
<tr><td>Reason</td><td><input type='text' name='reason'></td></tr></table>
<tr><td><input type='submit' value='Take Appointment' name='check'></td></tr></table><input type='hidden' value=". $_POST['studentid'] . " name=student></form>";
echo $htmlcode;
}
?>
</p>
</section>
<section>
</section>
<!-- end .content --></article>
<form action="/login.php" method="post">
<aside>
<h4>Admin Login</h4>
<p>
<label for="textfield2">ID</label>
<input type="text" name="username" id="textfield2" autocomplete="off">
</p>
<p>
<label for="password">Password</label><br />
<input type="password" name="pass" id="password">
</p>
<p>
<input type="submit" name="submit" id="submit" value="Go">
<?php
if (isset($_GET['p'])){
echo "<br />ID or Password incorrect";
}
?>
</p>
</aside>
</form>
<footer>
<p>The above content is not copyrighted. </p>
</footer>
<!-- end .container --></div>
</body>
</html>