aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--handle-reservation.php44
-rw-r--r--index.php22
-rw-r--r--notes.sql4
-rw-r--r--reservation.php27
-rw-r--r--style.css14
5 files changed, 81 insertions, 30 deletions
diff --git a/handle-reservation.php b/handle-reservation.php
new file mode 100644
index 0000000..3e24dd8
--- /dev/null
+++ b/handle-reservation.php
@@ -0,0 +1,44 @@
+<?php
+if ($_SERVER["REQUEST_METHOD"] == "POST") {
+ // DB INFO
+ $user = "yota_requester";
+ $password = "oon5iraeghaidoShi5sheefie2uuz3gu";
+ $database = "yota_call_db";
+ $table = "activities";
+
+ // SPECIAL CALL
+ $specialCall = $_POST["scall"];
+
+ // TIME
+ $fromTime = $_POST["sdate"] . $_POST["stime"] . ":00";
+ $toTime = $_POST["edate"] . $_POST["etime"] . ":00";
+
+ // FREQUENCIES
+ $frequencies = $_POST["freqs"][0];
+ for ($i = 0; $i < sizeof($_POST["freqs"]) - 1; $i++) {
+ $frequencies += ", " . $_POST["freqs"][$i];
+ }
+
+ // MODES
+ $modes = $_POST["modes"][0];
+ for ($i = 0; $i < sizeof($_POST["modes"]) - 1; $i++) {
+ $modes += ", " . $_POST["modes"][$i];
+ }
+
+ // OPERATOR INFORMATION
+ $operatorCall = $_POST["ocall"] . "<br>";
+ $operatorName = $_POST["oname"] . "<br>";
+ $operatorEmail = $_POST["email"] . "<br>";
+ $operatorPhone = $_POST["phone"] . "<br>";
+
+ try {
+ //$conn = new PDO("mysql:host=localhost;dbname=$database", $user, $password);
+ //$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+ //$stmt = $conn->prepare("INSERT INTO $table (name, surname, age) VALUES (:name, :surname, :age)");
+ //$stmt->bindParam(':name', $_POST['fname']);
+ //$stmt->execute();
+ //echo "<p>Data inserted.</p>";
+ } catch (PDOException $e) {
+ echo "<p>Error!: " . $e->getMessage() . "</p>";
+ }
+}
diff --git a/index.php b/index.php
index 938534c..6fd938b 100644
--- a/index.php
+++ b/index.php
@@ -26,7 +26,7 @@ session_start();
<main>
<?php
$user = "yota_user";
- $password = "leex3EThieK0ieLaiVaicaifef5eecei";
+ $password = "gahdeer6shai9hogai2sai4quuaj1eVu";
$database = "yota_call_db";
$table = "activities";
@@ -37,16 +37,22 @@ session_start();
echo '<div style="overflow-x:auto;">';
echo "<table>\n";
echo "<thead><tr>";
- echo "<th>Ime</th>";
- echo "<th>Prezime</th>";
- echo "<th>Godine</th>";
+ echo "<th>Operator</th>";
+ echo "<th>From</th>";
+ echo "<th>To</th>";
+ echo "<th>Special sign</th>";
+ echo "<th>Frequencies</th>";
+ echo "<th>QSO</th>";
echo "</tr></thead><tbody>\n";
- foreach($db->query("SELECT * FROM $table where approved=true") as $row) {
+ foreach($db->query("SELECT * FROM $table where approved=false ORDER BY `id` DESC") as $row) {
echo "<tr>";
- echo "<td>" . $row['name'] . "</td>";
- echo "<td>" . $row['surname'] . "</td>";
- echo "<td>" . $row['age'] . "</td>";
+ echo "<td>" . $row['operatorCall'] . "</td>";
+ echo "<td>" . $row['fromTime'] . "</td>";
+ echo "<td>" . $row['toTime'] . "</td>";
+ echo "<td>" . $row['specialCall'] . "</td>";
+ echo "<td>" . $row['frequencies'] . "</td>";
+ echo "<td>" . $row['qso'] . "</td>";
echo "</tr>\n";
}
diff --git a/notes.sql b/notes.sql
index 1794c53..dd59770 100644
--- a/notes.sql
+++ b/notes.sql
@@ -3,15 +3,17 @@ USE yota_db;
CREATE TABLE activities(
`id` int(11) not null auto_increment primary key,
+ `approved` boolean not null default false;
+ `specialCall` varchar(50) not null,
`fromTime` datetime not null,
`toTime` datetime not null,
- `specialCall` varchar(50) not null,
`frequencies` varchar(255) not null,
`modes` varchar(255) not null,
`operatorCall` varchar(50) not null,
`operatorName` varchar(50) not null,
`operatorEmail` varchar(100) not null,
`operatorPhone` varchar(50) not null
+ `qso` int not null default 0;
) charset=utf8;
CREATE TABLE admins(
diff --git a/reservation.php b/reservation.php
index 7b34f71..ec46440 100644
--- a/reservation.php
+++ b/reservation.php
@@ -25,24 +25,7 @@ session_start();
</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>";
- }
-}
+ require "handle-reservation.php";
?>
<form method="post">
@@ -52,11 +35,15 @@ if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['fname']) && isset($_PO
<option value="YT50SCWC">YT50SCWC</option>
</select>
<!-- START TIME -->
+<label for="start-date">Start date:</label>
+<input type="date" id="start-date" name="sdate">
<label for="start-time">Start time:</label>
-<input type="datetime-local" id="start-time" name="stime">
+<input type="time" id="start-time" name="stime">
<!-- END TIME -->
+<label for="end-date">End date:</label>
+<input type="date" id="end-date" name="edate">
<label for="end-time">End time:</label>
-<input type="datetime-local" id="end-time" name="etime">
+<input type="time" id="end-time" name="etime">
<!-- BANDS -->
<fieldset>
<legend>I will be active on bands:</legend>
diff --git a/style.css b/style.css
index 7fee13f..7b2b25e 100644
--- a/style.css
+++ b/style.css
@@ -48,7 +48,7 @@ nav a:hover {
/* MAIN STYLING */
main {
margin: 1rem auto;
- max-width: 750px;
+ /*max-width: 750px;*/
line-height: 1.6rem;
font-size: 1rem;
@@ -71,6 +71,13 @@ table {
width: 100%;
}
+thead {
+ background-color: black;
+ color: white;
+ /*color: black;*/
+ /*background-color: #ccc;*/
+}
+
td, th {
border: 1px solid #ccc;
text-align: left;
@@ -82,6 +89,11 @@ tr:nth-child(even) {
}
/* FORM STYLING */
+form {
+ max-width: 750px;
+ margin: 0rem auto;
+}
+
input, select {
width: 100%;
padding: 12px 10px;