/* starting point to view guestbook entries from database */
$link2 = mysqli_connect("$db_host", "$db_user", "$db_pass", "$db_name");

/* check connection */
if (mysqli_connect_errno()) 
{
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* select needed data from database */
$query = "SELECT id, naam, email, bericht FROM gastenboek ORDER by ID LIMIT 10";
$result = mysqli_query($link2, $query);

if (mysqli_num_rows($result) <= 0) 
{
	echo "Geen berichten"; // no messages
}
	
else {
	echo printf("<small>Er zijn %d berichten.</small>\n", mysqli_num_rows($result)); 
	while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){

		echo 	"<BR /><BR/>
				<article>\n
				<header>\n
				<p class=\"article-info\">Geschreven op <time datetime=\"\">17 augustus, 2012</time> door <a href=\"#\"> ". $row['naam'] . "</a>";

				if(isset($_POST['submit2'])) 
				{
				
					$link_view = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

					/* check connection */
					if (mysqli_connect_errno()) 
					{
						printf("Connect failed: %s\n", mysqli_connect_error());
						exit();
					}
					
					$row['id'] = $id;
					$id = mysqli_real_escape_string($link_view, $id);
					
					$query2 = "DELETE FROM gastenboek WHERE id = $id";
					
					if (mysqli_query($link_view, $query2)) 
					{
						printf("%d rows deleted.\n", mysqli_affected_rows($link_view));
					}
					mysqli_close($link_view);
				} 
	
				
						
				if (getRealIpAddr() == "127.0.0.1")  { 
				
				?>

				<form method="POST" action="<?php echo ($_SERVER['PHP_SELF']); ?>">
				<input type="hidden" name="del_id" value="">
				<button name="submit2" style="float: right; border: none; background: none;"><img src="images/delete_.gif" /></button>
				</form>

				<?php
				} // end html form
									
				echo 	"\n</header>\n
						<div class=\"article-content\">\n
						<p> " . $row['bericht'] . "</p>\n
						</div>\n 
						<hr class=\"line\">\n
						</article>\n
						<BR />\n
						";
						
						

			} // end while loop
} // end if statement


mysqli_free_result($result);

mysqli_close($link2);