-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
95 lines (84 loc) · 3.99 KB
/
index.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
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<title>Catering Pick-Up</title>
<meta name="author" content="Denison Enterprises"/>
<meta name="Description" content="Get food."/>
<link href="style.css" rel="stylesheet"/>
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<?php
include("includes/connection.php");
?>
<!--link rel="shortcut icon" href="favicon.ico"/-->
</head>
<!-- PAGE DESIGN -->
<body>
<div id="headerMine">
<h1>Catering Pick-Up</h1>
</div>
<div class="container">
<div class="row">
<div class="col-md-6">
<div id="formMine">
<h1>Sign-Up:</h1><br>
<form class="form-horizontal" name="insertForm" action="insertAttendee.php" method="get">
<div class="form-group">
<label for="inputFName" class="col-md-4 control-label">First Name</label>
<div class="col-lg-8">
<input name="first_name" type="text" class="form-control" id="inputText" required>
</div>
</div>
<div class="form-group">
<label for="inputLName" class="col-md-4 control-label">Last Name</label>
<div class="col-lg-8">
<input name="second_name" type="text" class="form-control" id="inputText" required>
</div>
</div>
<div class="form-group">
<label for="inputDnum" class="col-md-4 control-label">D Number</label>
<div class="col-lg-8">
<input name="d_num" type="text" class="form-control" id="inputText" required>
</div>
</div>
<div class="form-group">
<label for="inputFName" class="col-lg-4 control-label">Event</label>
<div class="col-lg-8">
<select name="event" class="form-control" id="sel1" required>
<?php
$sql_statement3 = "SELECT event_id, food_type, attendance, date, end_time FROM event ORDER BY DATE(date)";
$sth3 = $connect->prepare($sql_statement3);
$sth3->execute();
$sth3->bind_result($event_id, $food_type, $attendance, $date, $start_time);
$sth3->store_result();
while ($sth3->fetch()) {
if ( strtotime( "yesterday" ) <= strtotime($date) ) {
$newDate = date("F j", strtotime($date));
$result = $connect->query("SELECT COUNT(*) FROM attendee WHERE $event_id = event_id");
$row = $result->fetch_row();
$count = $row[0];
if ( $count < $attendance ) {
echo "<option value=\"$event_id\">$food_type on $newDate";
}
}
}
$sth3->close();
?>
</select>
</div>
</div>
<br>
<div class="form-group">
<div class="col-lg-10 col-lg-offset-10">
<button name="submit" type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
</div>
</div>
<?php
include("includes/catering_schedule.php");
?>
</div>
</div>
</body>
</html>