<?php
if (!isset($PHP_AUTH_USER))
{
header('WWW-Authenticate: Basic realm="Inloggen"');
header('HTTP/1.0 401 Unauthorized');
echo 'Alleen voor de <b>Administrator</b> van deze pagina!';
exit;
}
elseif (isset($PHP_AUTH_USER))
{
if (($PHP_AUTH_USER != "***") || ($PHP_AUTH_PW != "***"))
{
header('WWW-Authenticate: Basic realm="Admin"');
header('HTTP/1.0 401 Unauthorized');
echo 'Om op de volgende pagina te komen, moet je ingelogd zijn!';
exit;
}
else
{
echo "";
}
}
?>
<html>
<head>
<title>Admin</title>
<style>
body {scrollbar-base-color: #FF0099;
scrollbar-face-color: #FFFFFF;
scrollbar-track-color: #FFFFFF;
scrollbar-arrow-color: #FF8330;
scrollbar-3dlight-color: #FFFFFF;
scrollbar-shadow-color: #FF0099;}
A:link {color: #FF8330; text-decoration:none;font-weight:bold; }
A:visited {color: #FF0099; text-decoration:none;font-weight:bold; }
A:active {color: #FF0099; text-decoration:none;font-weight:bold;}
A:hover {color: #FF0099;text-decoration:none;font-weight:bold}
</style>
</head>
<body>
<?php
// Mysql connectie gegevens
mysql_connect('localhost', '***', '***');
mysql_select_db('***');
if(IsSet($_POST['datum']))
{
$query1 = mysql_query("SELECT id FROM agenda ORDER BY id DESC");
$array = mysql_fetch_array($query1, MYSQL_ASSOC);
$id = $array['id'] + 1;
$query2 = mysql_query("INSERT INTO agenda (id, datum, bericht) VALUES ('$id', '{$_POST['datum']}', '{$_POST['bericht']}')");
print("<b><i><font face='Verdana' size='2' color='#FF0099'>Agendapunt toegevoegd!</font></i></b>");
}
if(IsSet($_GET['del']))
{
$query3 = mysql_query("DELETE FROM agenda WHERE id='{$_GET['del']}'");
print("<b><i><font face='Verdana' size='2' color='#FF0099'>Agendapunt verwijderd!</font></i></b>");
}
$query4 = mysql_query("SELECT * FROM agenda ORDER BY id DESC");
while($a = mysql_fetch_array($query4, MYSQL_ASSOC))
{
print($a['datum']."<br>".$a['bericht']."<br><a href=\"agenda.php?del=".$a['id']."\">DELETE</a> - <a href=\"agenda.php?wijzig=1&id=".$a['id']."\">Wijzig</a>");
}
if(IsSet($_GET['wijzig']))
{
$query5 = mysql_query("SELECT * FROM agenda WHERE id='{$_GET['id']}'");
$w = mysql_fetch_array($query5, MYSQL_ASSOC);
print("<form action=\"agenda.php?change=1&id=".$_GET['id']."\" method=\"post\">");
}
else
print("<form action=\"agenda.php\" method=\"post\">");
if(IsSet($_GET['change']))
{
$query6 = mysql_query("UPDATE agenda SET datum='{$_POST['datum']}', bericht='{$_POST['bericht']}' WHERE id='{$_GET['id']}'");
print("Agendapunt gewijzigd!");
}
?>
<table cellpadding="2">
<tr>
<td><b><font color='#FF8330' face='Verdana' size='2'><font face='Arial' color='#ff0099' size='2'>► </font>Datum:</b></font>
<td><input type="text" name="datum" style='border: 1px solid #FF0099; color:#FF0099; font-family:Verdana' size="20" value="<? print($w['datum']);?>">
<tr>
<td><b><font color='#FF8330' face='Verdana' size='2'><font face='Arial' color='#ff0099' size='2'>► </font>Bericht:</b></font>
<td><input type="text" name="bericht" style='border: 1px solid #FF0099; color:#FF0099; font-family:Verdana' size="20" value="<? print($w['bericht']);?>">
<tr>
<td>
<td><input type="submit" style='border:1px solid #FF8330; font-family: Verdana; font-size: 10 pt; color:#FF0099; background-color:#FFFFFF; font-weight:bold' tabindex='10' value="Voeg agendapunt toe">
</table>
</body>
</html>