aboutsummaryrefslogblamecommitdiff
path: root/reservation.php
blob: 84949c5b415a4b26bd351332a7d32bc4b7f344a5 (plain) (tree)



































































































































































                                                                                                                       
<?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>