<!DOCTYPE html>
<head>
<meta charset="utf-8" />
<meta name="author" content="Ciske de Rat" />
<title>Administratie</title>
<link rel="stylesheet" type="text/css" href="style.css" >
<script src="lib/jquery/jquery-1.8.3.min.js"></script>
<script>
$(document).ready(function() {
$("#status").change(function() {
var val = $(this).val();
if ( val == 'Aanwezig' ) {
$("#Naam").show();
$("#Datum").show()
$("#rede").hide();
$("#vakantieduur").hide();
$("#aankomst").hide();
}
});
});
</script>
<script>
$(document).ready(function() {
$("#status").change(function() {
var val = $(this).val();
if ( val == 'Ziek' ) {
$("#Naam").show();
$("#Datum").show()
$("#rede").show();
$("#vakantieduur").hide();
$("#aankomst").hide();
}
});
});
</script>
<script>
$(document).ready(function() {
$("#status").change(function() {
var val = $(this).val();
if ( val == 'Vakantie' ) {
$("#Naam").show();
$("#Datum").show()
$("#rede").show();
$("#vakantieduur").show();
$("#aankomst").hide();
}
});
});
</script>
<script>
$(document).ready(function() {
$("#status").change(function() {
var val = $(this).val();
if ( val == 'Telaat' ) {
$("#Naam").show();
$("#Datum").show()
$("#rede").show();
$("#aankomst").show();
$("#vakantieduur").hide();
}
});
});
</script>
<script>
$(document).ready(function() {
$("#status").change(function() {
var val = $(this).val();
if ( val == 'Beter' ) {
$("#Naam").show();
$("#Datum").show()
$("#rede").hide();
$("#aankomst").hide();
$("#vakantieduur").hide();
}
});
});
</script>
</head>
<body>
<header>
<h1>Administratie personeel lijst</h1>
</header>
<h2>Zieken</h2>
<table border='1'>
<tr>
<th>Naam:</th>
<th>Rede:</th>
<th>Datum:</th>
</tr>
<?php
$db_host = "ik ben niet gek";
$db_username = "alleen";
$db_pass = "prettig";
$db_name = "GESTOORD";
mysql_connect ("$db_host","$db_username","$db_pass") or die ("Kon niet verbinden met de MySQL database");
mysql_select_db ("$db_name") or die ("Geen database gevonden");
$result = mysql_query("SELECT * FROM status WHERE STATUS = 'Ziek'");
while($row = mysql_fetch_array($result)) {
if (!empty($row['Naam'])) {
echo "<tr>";
echo "<th>".$row['Naam']."</th>";
echo "<th>".$row['Rede']."</th>";
echo "<th>".$row['Datum']."</th>";
echo "</tr>";
}
}
?>
</table>
<h2>Aanwezige</h2>
<table border='1'><tr>
<th>Naam:</th>
<th>Datum:</th>
</tr>
<?php
$result = mysql_query("SELECT * FROM STATUS WHERE STATUS = 'Aanwezig' OR STATUS = 'Telaat'");
while($row = mysql_fetch_array($result)) {
if (!empty($row['Naam'])) {
echo "<tr>";
echo "<th>".$row['Naam']."</th>";
echo "<th>".$row['Datum']."</th></tr>";
}
}
?>
</table>
<h2>Vakantie</h2>
<table border='1'><tr>
<th>Naam:</th>
<th>Rede:</th>
<th>Vakantie tot:</th>
<th>Datum:</th>
</tr>
<?php
$result = mysql_query("SELECT * FROM STATUS WHERE STATUS = 'VAKANTIE'");
while($row = mysql_fetch_array($result)) {
if (!empty($row['Naam'])) {
echo "<tr>";
echo "<th>".$row['Naam']."</th>";
echo "<th>".$row['Rede']."</th>";
echo "<th>".$row['vakantieduur']."</th>";
echo "<th>".$row['Datum']."</th></tr>";
}
}
?>
</table>
<h2>Te laat</h2>
<table border='1'><tr>
<th>Naam:</th>
<th>Rede:</th>
<th>Aankomsttijd:</th>
<th>Datum:</th>
</tr>
<?php
$result = mysql_query("SELECT * FROM STATUS WHERE STATUS = 'TELAAT'");
while($row = mysql_fetch_array($result)) {
if (!empty($row['Naam'])) {
echo "<tr>";
echo "<th>".$row['Naam']."</th>";
echo "<th>".$row['Rede']."</th>";
echo "<th>".$row['aankomst']."</th>";
echo "<th>".$row['Datum']."</th></tr>";
}
}
?>
</table>
<h2>Beter</h2>
<table border='1'><tr>
<th>Naam:</th>
<th>Datum:</th>
</tr>
<?php
$result = mysql_query("SELECT * FROM STATUS WHERE STATUS = 'Beter'");
while($row = mysql_fetch_array($result)) {
if (!empty($row['Naam'])) {
echo "<tr>";
echo "<th>".$row['Naam']."</th>";
echo "<th>".$row['Datum']."</th></tr>";
}
}
?>
</table>
<br>
<form method="post">
Status: <select id="status" name="status">
<option value="Aanwezig">Aanwezig</option>
<option value="Ziek">Ziek</option>
<option value="Telaat">Telaat</option>
<option value="Vakantie">Vakantie</option>
<option value="Beter">Beter</option>
</select><br>
Naam:
<?php
$result = mysql_query("SELECT * FROM WERKNEMERS");
echo "<select name='naam'>";
while ($row = mysql_fetch_array($result)) {
echo "<option value='".$row['Naam']."'>".$row['Naam']."</option>";
}
echo "</select>";
?>
<div id="rede">Rede: <input name="rede" type="text" /></div>
Datum: <input name="datum" type='date' />
<div id="aankomst">Aankomsttijd: <input name="aankomst" type="time" /></div>
<div id="vakantieduur">Vakantieduur: <input name="vakantieduur" type="date" /></div>
<input name="submit" type='submit' value="Verzenden" />
</form>
<?php
if (isset($_POST['submit'])) {
$status = $_POST['status'];
$naam = $_POST['naam'];
$rede = $_POST['rede'];
$datum = $_POST['datum'];
$aankomst = $_POST['aankomst'];
$vakantieduur = $_POST['vakantieduur'];
if ($_POST['status'] == "Aanwezig") {
mysql_query("INSERT INTO STATUS (Status, Naam, Datum)
VALUES ('$status', '$naam', '$datum')");
} elseif ($_POST['status'] == "Ziek") {
mysql_query("INSERT INTO STATUS (Status, Naam, Datum, Rede)
VALUES ('$status', '$naam', '$datum', '$rede')");
} elseif ($_POST['status'] == "Telaat") {
mysql_query("INSERT INTO STATUS (Status, Naam, Datum, Rede, aankomst)
VALUES ('$status', '$naam', '$datum', '$rede', '$aankomst')");
} elseif ($_POST['status'] == "Vakantie") {
mysql_query("INSERT INTO STATUS (Status, Naam, Datum, Rede, vakantieduur)
VALUES ('$status', '$naam', '$datum', '$rede', '$vakantieduur')");
} elseif ($_POST['status'] == "Beter") {
mysql_query("INSERT INTO STATUS (Status, Naam, Datum)
VALUES ('$status', '$naam', '$datum')");
}
Header('Location: index.php');
}
?>
<footer>
<p>
© Copyright by Ciske de Rat
</p>
</footer>
</body>
</html>