-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmyschedule.php
137 lines (109 loc) · 5.39 KB
/
myschedule.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
<?php include('header.php'); ?>
<?php include('session.php'); ?>
<?php include('dbcon.php'); ?>
<?php include('navbar_dasboard.php'); ?>
<div class="container">
<div class="margin-top">
<div class="row">
<div class="span3">
<ul class="nav nav-tabs nav-stacked">
<li class="active">
<a href="#"><i class="icon-pencil icon-large"></i> Create Account</a>
</li>
</ul>
<p><strong>Today is:</strong></p>
<div class="alert alert-success">
<i class="icon-calendar icon-large"></i>
<?php
$Today = date('d:m:y');
$new = date('l, F d, Y', strtotime($Today));
echo $new;
?>
</div>
<div class="alert alert-info">Time Guide for Each Number</div>
<p>Number 1 - 9:30 - 10:00</p>
<p>Number 2 - 10:00 - 10:30</p>
<p>Number 3 - 10:30 - 11:00</p>
<p>Number 4 - 11:30 - 12:00</p>
<p>Number 5 - 12:30 - 1:00</p>
<p>Number 6 - 3:00 - 3:30</p>
<p>Number 7 - 3:30 - 4:00</p>
<p>Number 8 - 4:30 - 5:00</p>
<div class="alert alert-info">Office Hours</div>
<p>Monday - Firday (9:30 am to 1:00 pm)</p>
<p>Monday - Friday (3:00 pm to 5:00 pm)</p>
<p>Room 312</p>
<p>Saturday(half day)</p>
<p>(9:30 pm to 1:00 pm)</p>
<p>Alpha Tower</p>
<p>Sheikh Zayed Road</p>
<div class="alert alert-info">Testimonial</div>
<div class="testimonial_div">
<p>
I was delighted with the services offered. Despite me being a somewhat timid person, the counselors and tutos really accommodating and helpful in not only listening to my true requirments but also effectively facilitating the coordination of each session.
</p>
</div>
</div>
<div class="span6">
<img src="img/dr.jpg">
<br>
<br>
<div class="alert alert-info">My Schedule</div>
<table cellpadding="0" cellspacing="0" border="0" class="table table-bordered" id="example">
<thead>
<tr>
<th>My Number</th>
<th>Date</th>
<th>Service</th>
<th>Price</th>
</tr>
</thead>
<tbody>
<?php $user_query=mysqli_query($conn,"select * from schedule where member_id = '$session_id' ")or die(mysqli_error($conn));
while($row=mysqli_fetch_array($user_query)){
$id=$row['id'];
$member_id = $row['member_id'];
$service_id = $row['service_id'];
/* member query */
$member_query = mysqli_query($conn,"select * from members where member_id = ' $member_id'")or die(mysqli_error($conn));
$member_row = mysqli_fetch_array($member_query);
/* service query */
$service_query = mysqli_query($conn,"select * from service where service_id = '$service_id' ")or die(mysqli_error($conn));
$service_row = mysqli_fetch_array($service_query);
?>
<tr class="del<?php echo $id ?>">
<td width="100"><?php echo $row['Number']; ?></td>
<td><?php echo $row['date']; ?></td>
<td><?php echo $service_row['service_offer']; ?></td>
<td><?php echo $service_row['price']; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<div class="span3">
<img src="img/32x32/facebook.png">
<img src="img/32x32/twitter.png">
<img src="img/32x32/rss.png">
<div class="alert alert-info">List of Services</div>
<table class="table table-bordered">
<thead>
<tr>
<th>Service Offer</th>
<th>Price</th>
</tr>
</thead>
<tbody>
<?php $user_query=mysqli_query($conn,"select * from service")or die(mysqli_error($conn));
while($row=mysqli_fetch_array($user_query)){
$id=$row['service_id']; ?>
<tr class="del<?php echo $id ?>">
<td><?php echo $row['service_offer']; ?></td>
<td><?php echo $row['price']; ?></td>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<?php include('footer.php') ?>