commit 0304a7fe20c3a1f4310f1ab1a5bcf1aeafa7a17d
parent 0adf0a66c23e4ed7854f5df82f21a67e2cc7e43d
Author: LennartSchroot <[email protected]>
Date: Tue, 18 Apr 2023 14:43:01 +0200
tabel gefixt en opmaak
joe
Diffstat:
12 files changed, 97 insertions(+), 10 deletions(-)
diff --git a/add_contract.php b/add_contract.php
@@ -4,6 +4,7 @@
<title>Add contract</title>
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/general.css">
</head>
<?php
include "navbar.php";
diff --git a/add_customer.php b/add_customer.php
@@ -4,6 +4,7 @@
<title>Add user</title>
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
</head>
<?php
include "navbar.php";
diff --git a/add_user.php b/add_user.php
@@ -4,6 +4,7 @@
<title>Add user</title>
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
</head>
<?php
include "navbar.php";
diff --git a/alter_contract.php b/alter_contract.php
@@ -4,6 +4,7 @@
<title>Add contract</title>
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
</head>
<?php
include "navbar.php";
diff --git a/alter_customer.php b/alter_customer.php
@@ -5,6 +5,7 @@
<title>Add user</title>
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
</head>
<?php
include "navbar.php";
diff --git a/alter_user.php b/alter_user.php
@@ -5,6 +5,7 @@
<title>User toevoegen</title>
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
</head>
<?php
use Lollipop\DatabaseObject;
diff --git a/css/general.css b/css/general.css
@@ -0,0 +1,6 @@
+@import url('https://fonts.googleapis.com/css?family=Montserrat:400,700&display=swap');
+
+body {
+ margin: 0;
+ font-family: 'Montserrat', sans-serif;
+}
+\ No newline at end of file
diff --git a/css/weerdata.css b/css/weerdata.css
@@ -0,0 +1,49 @@
+@import url('https://fonts.googleapis.com/css?family=Montserrat:400,700&display=swap');
+
+body {
+ margin: 0;
+ font-family: 'Montserrat', sans-serif;
+}
+
+table {
+ border-collapse: collapse;
+ width: 100%;
+ font-family: 'Montserrat', sans-serif;
+ font-size: 15px;
+ color: #444444;
+}
+
+th {
+ background-color: #f2f2f2;
+ color: #333333;
+ font-weight: bold;
+ padding: 8px;
+ text-align: left;
+ border: 1px solid #dddddd;
+}
+
+td {
+ padding: 8px;
+ border: 1px solid #dddddd;
+}
+
+tr:nth-child(even) {
+ background-color: #f9f9f9;
+}
+
+tr:hover {
+ background-color: #f5f5f5;
+}
+
+tfoot {
+ background-color: #e6e6e6;
+ font-weight: bold;
+}
+
+tfoot td {
+ border: none;
+}
+
+tfoot:hover {
+ background-color: #e2e2e2;
+}
+\ No newline at end of file
diff --git a/search_contract.php b/search_contract.php
@@ -2,6 +2,7 @@
<html lang="eng">
<head>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
<?php
include "navbar.php";
include "utils/autoloader.php";
diff --git a/search_customer.php b/search_customer.php
@@ -2,6 +2,7 @@
<html lang="eng">
<head>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
<?php
include "navbar.php";
include "utils/autoloader.php";
diff --git a/search_data.php b/search_data.php
@@ -17,7 +17,7 @@ error_reporting(0);
$endDate = $_GET['date-end'];
$station = $_GET['station'];
- $sql = "SELECT station_name, date_time, validated, temperature FROM weather_data";
+ $sql = "SELECT * FROM weather_data";
if(!isset($_GET['date-begin']) && !isset($_GET['date-end']) && !isset($_GET['station'])){
$sql .= " LIMIT 250";
}
@@ -59,6 +59,7 @@ error_reporting(0);
<html>
<head>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/weerdata.css">
</head>
<body>
<form class="d-flex" action="search_data.php" method="get">
@@ -72,21 +73,41 @@ error_reporting(0);
if ($result->num_rows > 0) {
echo "<table class=\"table table-striped\">
<thead>
- <tr>
- <th>Station</th>
- <th>Date</th>
- <th>Validated</th>
- <th>Temperature</th>
- </tr>
+ <tr>
+ <th> Station name </th>
+ <th> Date & Time </th>
+ <th> Validated </th>
+ <th> Temperature </th>
+ <th> Dewpoint </th>
+ <th> Sea pressure </th>
+ <th> Station pressure </th>
+ <th> Visibility </th>
+ <th> Wind speed </th>
+ <th> Precipitation </th>
+ <th> Snow depth </th>
+ <th> Events </th>
+ <th> Cloud count </th>
+ <th> Wind direction </th>
+ </tr>
</thead>
<tbody>";
while ($row = mysqli_fetch_assoc($result)) {
$link = "/search_data.php?station=" . $row['station_name'];
echo "<tr>";
echo "<td><a href='" . $link . "'>" . $row['station_name'] . "</a></td>";
- echo "<td>" . $row['date_time'] . "</td>";
- echo "<td>" . $row['validated'] . "</td>";
- echo "<td>" . $row['temperature'] . "</td>";
+ echo "<td>" . $row["date_time"]. "</td>";
+ echo "<td>" . $row["validated"]. "</td>";
+ echo "<td>" . $row["temperature"]. "</td>";
+ echo "<td>" . $row["dew_point"]. "</td>";
+ echo "<td>" . $row["pressure_sea"]. "</td>";
+ echo "<td>" . $row["pressure_station"]. "</td>";
+ echo "<td>" . $row["visibility"]. "</td>";
+ echo "<td>" . $row["wind_speed"]. "</td>";
+ echo "<td>" . $row["precipitation"]. "</td>";
+ echo "<td>" . $row["snow_depth"]. "</td>";
+ echo "<td>" . $row["events"]. "</td>";
+ echo "<td>" . $row["cloud_count"]. "</td>";
+ echo "<td>" . $row["wind_direction"]. "</td>";
echo "</tr>";
}
echo "
diff --git a/search_user.php b/search_user.php
@@ -2,6 +2,7 @@
<html lang="eng">
<head>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
+ <link rel="stylesheet" type="text/css" href="/css/homepage.css">
<?php
include "navbar.php";
include "utils/autoloader.php";
