1 files changed, 164 insertions, 0 deletions
diff --git a/reservation.php b/reservation.php
new file mode 100644
index 0000000..84949c5
--- /dev/null
+++ b/reservation.php
@@ -0,0 +1,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>