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
|
<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width initial-scale=1.0"/>
<link href="style.css" rel="stylesheet" type="text/css"/>
<title>Yota Callplan</title>
</head>
<body>
<header><a href="http://yota.yu1srs.org.rs/">YOTA</a></header>
<nav>
<a href="index.php">Activity Plan</a>
<a class="active" href="reservation.php">Make reservation</a>
<?php
if (isset($_SESSION['admin']) && $_SESSION['admin'] == true) {
echo '<a class="right" href="/logout.php">Logout</a>';
echo '<a class="right" href="admin.php">Administration</a>';
} else {
echo '<a class="right" href="/admin.php">Login</a>';
}
?>
</nav>
<main>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['fname']) && isset($_POST['lname']) && isset($_POST['age'])) {
$user = "yota_user";
$password = "leex3EThieK0ieLaiVaicaifef5eecei";
$database = "yota_call_db";
$table = "activities";
try {
$conn = new PDO("mysql:host=localhost;dbname=$database", $user, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("INSERT INTO activities (name, surname, age) VALUES (:name, :surname, :age)");
$stmt->bindParam(':name', $_POST['fname']);
$stmt->bindParam(':surname', $_POST['lname']);
$stmt->bindParam(':age', $_POST['age']);
$stmt->execute();
echo "<p>Data inserted.</p>";
} catch (PDOException $e) {
echo "<p>Error!: " . $e->getMessage() . "</p>";
}
}
?>
<form method="post">
<label for="fname">First name:</label>
<input type="text" id="fname" name="fname">
<label for="lname">Last name:</label>
<input type="text" id="lname" name="lname">
<label for="age">Age:</label>
<input type="number" id="age" name="age">
<input type="submit" value="Submit">
</form>
<hr>
<hr>
<hr>
<form method="post">
<!-- SPECIAL CALL -->
<label for="special-call">Special Call:</label>
<select id="special-call" name="scall">
<option value="YT50SCWC">YT50SCWC</option>
</select>
<!-- START TIME -->
<label for="start-time">Start time:</label>
<input type="datetime-local" id="start-time" name="stime">
<!-- END TIME -->
<label for="end-time">End time:</label>
<input type="datetime-local" id="end-time" name="etime">
<!-- BANDS -->
<fieldset>
<legend>I will be active on bands:</legend>
<input type="checkbox" id="cb1" name="cb1" value="1.8 MHz">
<label for="cb1">1.8 MHz</label><br>
<input type="checkbox" id="cb2" name="cb2" value="3.5 MHz">
<label for="cb2">3.5 MHz</label><br>
<input type="checkbox" id="cb3" name="cb3" value="7 MHz">
<label for="cb3">7 MHz</label><br>
<input type="checkbox" id="cb4" name="cb4" value="10 MHz">
<label for="cb4">10 MHz</label><br>
<input type="checkbox" id="cb5" name="cb5" value="14 MHz">
<label for="cb5">14 MHz</label><br>
<input type="checkbox" id="cb6" name="cb6" value="18 MHz">
<label for="cb6">18 MHz</label><br>
<input type="checkbox" id="cb7" name="cb7" value="21 MHz">
<label for="cb7">21 MHz</label><br>
<input type="checkbox" id="cb8" name="cb8" value="24 MHz">
<label for="cb8">24 MHz</label><br>
<input type="checkbox" id="cb9" name="cb9" value="28 MHz">
<label for="cb9">28 MHz</label><br>
<input type="checkbox" id="cb10" name="cb10" value="50 MHz">
<label for="cb10">50 MHz</label><br>
<input type="checkbox" id="cb11" name="cb11" value="144 MHz">
<label for="cb11">144 MHz</label><br>
<input type="checkbox" id="cb12" name="cb12" value="432 MHz">
<label for="cb12">432 MHz</label><br>
<input type="checkbox" id="cb13" name="cb13" value="1.2 GHz">
<label for="cb13">1.2 GHz</label><br>
<input type="checkbox" id="cb14" name="cb14" value="2.3 GHz">
<label for="cb14">2.3 GHz</label><br>
</fieldset>
<!-- MODES -->
<fieldset>
<legend>I will use modes:</legend>
<input type="checkbox" id="CW" name="CW" value="CW">
<label for="CW">CW</label><br>
<input type="checkbox" id="SSB" name="SSB" value="SSB">
<label for="SSB">SSB</label><br>
<input type="checkbox" id="FM" name="FM" value="FM">
<label for="FM">FM</label><br>
<input type="checkbox" id="RTTY" name="RTTY" value="RTTY">
<label for="RTTY">RTTY</label><br>
<input type="checkbox" id="MFSK" name="MFSK" value="MFSK">
<label for="MFSK">MFSK (JT65, FT8...)</label><br>
<input type="checkbox" id="IMAGING" name="IMAGING" value="IMAGING">
<label for="IMAGING">IMAGING (ATV, SSTV...)</label><br>
<input type="checkbox" id="OTHER DIGITAL" name="OTHER DIGITAL" value="OTHER DIGITAL">
<label for="OTHER DIGITAL">OTHER DIGITAL</label><br>
</fieldset>
<!-- OPERATOR CALL -->
<label for="operator-call">Operator call sign:</label>
<input type="text" id="operator-call" name="ocall">
<!-- OPERATOR NAME -->
<label for="operator-name">Operator name:</label>
<input type="text" id="operator-name" name="oname">
<!-- OPERATOR EMAIL -->
<label for="operator-email">Operator email:</label>
<input type="email" id="operator-email" name="email">
<!-- OPERATOR PHONE -->
<label for="operator-phone">Operator phone:</label>
<input type="tel" id="operator-phone" name="phone">
<!-- SUBMIT BUTTON -->
<input type="submit" value="Submit reservation request">
</form>
</main>
</body>
</html>
|
