+++ /dev/null
-<html>
-<head>
- <meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-15" />
- <meta NAME="Author" CONTENT="webmaster@vanrenterghem.biz (Frederik Vanrenterghem)" />
- <meta NAME="Description" CONTENT="Personal homepage - Blog from Frederik Vanrenterghem" />
- <title>Frederik Vanrenterghem's Blog</title>
- <link rel='stylesheet' type='text/css' href='/styles/main.css' />
- <link rel='stylesheet' type='text/css' href='/styles/newspage.css' />
- <link rel='stylesheet' type='text/css' href='/styles/header.css' />
-</head>
-<body>
-<?php
-// Print the header
-printf("<!--HEADER-->\n");
-include("../header.shtml");
-
-// Check the input
-// We expect a $berichtID=YYYY-MM-DD as parameters
-
-if(!isset($_GET['berichtID'])){
-die ('<BR>Please specify a date when invoking this script.');
-}
-else {
-$berichtID=$_GET['berichtID'];
-}
-
-if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $berichtID, $regs)) {
- $datum="$regs[1]$regs[2]$regs[3]";
-} else {
- die ('<BR>Invalid date format. Check the URL or <a href="/About/index.shtml">contact the webmaster</a> if this problem persists.');
-}
-
-
-// Print the page title
-printf("<BR><H1>News from $berichtID</H1>\n\n");
-
-// Define the variables
-// frederik.gotdns.org:1976 db
-
-$dbserver="localhost";
-$usernaam="webnews";
-$paswoord="BlaBla123";
-$database="website";
-$tabel="newsContent";
-
-// vanrenterghem.biz db
-//$dbserver="localhost";
-//$usernaam="frederik_fred";
-//$paswoord="fred";
-//$database="frederik_News";
-//$tabel="newsContent";
-
-
-// -- Table structure for table 'newsContent'
-// --
-//
-// CREATE TABLE newsContent (
-// title varchar(40) default NULL,
-// date date default NULL,
-// body text
-// )
-
-// Connect to database
-
-$db=mysql_connect($dbserver,$usernaam,$paswoord) or die ("Geen connectie met server");
-mysql_select_db($database,$db) or die ("Database bestaat niet");
-
-
-$resultatenreeks=mysql_query("SELECT * FROM $tabel WHERE date=$datum") or die ('An error occured while retrieving data from the database. Please <a href="/About/index.shtml">contact the webmaster</a> if this problem persists.');
-
-
-while ($resultatenrij = mysql_fetch_row($resultatenreeks)) {
-
-// Put the results in a table, one table per result
- printf("<!--NEWSITEM-->\n");
- printf("<table border='0' cellpadding='0' cellspacing='0' width='100%%' summary=''><tr><td><table bgcolor='#000084' border='0' cellpadding='0' cellspacing='0' width='100%%' summary=''>
-<tr><td valign='top'><img src='/Pics/newsitem_ul.png' align='left' border='0' hspace='0' vspace='0' alt='cornerul' width='16' height='16'><font color=white><B>
-%s</B></font>
-</td><td align='right' valign='top'><img src='/Pics/newsitem_ur.png' align='right' border='0' hspace='0' vspace='0' alt='cornerur' width='16' height='16'><font color=white><B>
-%s </B></font></td></tr></table></td></tr><tr><td>
-%s <BR><BR></td></tr></table>\n\n",
- $resultatenrij[0], $resultatenrij[1], $resultatenrij[2]);
-
-}
-
-// Print the footer
-printf("<!--FOOTER-->\n");
-include("../footer.php");
-?>
-
-</body>
-</html>
-