+++ /dev/null
-<html>
-<HEAD>
- <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-15">
- <META NAME="Author" CONTENT="frederik.vanrenterghem@chello.be (Frederik Vanrenterghem)">
- <META NAME="Description" CONTENT="Personal homepage - news">
- <TITLE>http://frederik.gotdns.org:1976 - News</TITLE>
-</HEAD>
-<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#0000EF" VLINK="#55188A" ALINK="#FF0000">
-<?php
-// Print the header
-printf("<!--HEADER-->\n");
-include("../header.shtml");
-
-// Check the input
-// We expect a $berichtID=YYYY-MM-DD as parameters
-
-if(!isset($berichtID)){die ('<BR>Please specify a date when invoking this script.');}
-
-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
-
-$dbserver="localhost";
-$usernaam="frederik";
-$paswoord="Fred1210";
-$database="website";
-$tabel="newsContent";
-$maxShown=5;
-
-
-
-// -- 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>
-