<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>
<style type="text/css" media="screen">
<!--
a.menu:link { color: #fff; background: #000084; text-decoration: none; }
a.menu:visited { color: #fff; background: #000084; text-decoration: none; }
-->
</style>
</HEAD>
<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#0000EF" VLINK="#55188A" ALINK="#FF0000">
<?php
// Print the header
printf("<!--HEADER-->\n");
include("../header.shtml");

// Print the page title
printf("<BR><H1>News Page</H1>\n\n");

// Define the variables

$dbserver="localhost";
$usernaam="frederik";
$paswoord="Fred1210";
$database="website";
$tabel="newsContent";
$maxShown=5;

if(!isset($begin)){$begin=0;}

if(ereg('[^0-9]', $begin)) {
  die ('Invalid input format in URL. Please <a href="/About/index.shtml">contact the webmaster</a> if this problem persists.');
}

// -- 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");

// Count the number of news items in the table

$aantalNewsItems=mysql_query("SELECT COUNT(*) from $tabel");
$aantalNewsItemsNo=mysql_fetch_row($aantalNewsItems);


// LIMIT x, y will limit the results to y rows, starting from x

$resultatenreeks=mysql_query("SELECT * FROM $tabel ORDER BY date DESC LIMIT $begin, $maxShown") 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>
<A HREF='/News/permalink.php?berichtID=%s 'class='menu'>%s </A> </B></font></td></tr></table></td></tr><tr><td>
%s <BR><BR></td></tr></table>\n\n",
		$resultatenrij[0], $resultatenrij[1], $resultatenrij[1], $resultatenrij[2]);

}

// Add some navigation - still to add option to modify maxShown
if($aantalNewsItemsNo[0]>$maxShown)
{
	printf("<!--NAVIGATION-->\n");
	printf("<table border='0' cellpadding='0' cellspacing='0' width='100%%' summary=''><tr><td align='left'>\n");
	// Only show the option for the previous items on post-first-page
	if($begin>0 AND $aantalNewsItemsNo[0]>($maxShown*2))
	 {printf("<a href='index.php?begin=" . ($begin - $maxShown) . "'>Show items ".($begin-$maxShown+1) . " to " . ($begin) . "</a><BR>\n");}
	// Show the next items, make sure not to mention a non-existing number of items with the min function
	if($aantalNewsItemsNo[0]>($maxShown+$begin))
	 {printf("</TD><TD align='right'><a href='index.php?begin=" .($begin+$maxShown)."'>Show items ".($begin+$maxShown+1) . " to " . min(($maxShown*2+$begin),$aantalNewsItemsNo[0]) . "</a></td></tr></table>\n");}
	// Once we have shown all items, show the option to return to the first items
	else
	 {printf("</TD><TD align='right'><a href='index.php?begin=".(0)."'>Show items ".(1) . " to " . ($maxShown) . "</a></td></tr></table>\n");}
	printf("<!--END NAVIGATION-->\n");
}

// Include a link to an XML RSS feed
printf("<P><A HREF='/phppages/rss.php' title='Get the first 10 items of this News section in RSS XML format.'><IMG SRC='/Pics/xml.png' BORDER=0 ALT='XML RSS icon'></A></P>\n");
// Print the footer
printf("<!--FOOTER-->\n");
include("../footer.php");
?>

</BODY>
</HTML>