Gastenboek met verschillende pagina's

<?php
include('config.php');
$query = mysql_query("SELECT COUNT(id) FROM post") or die("query:". mysql_error());
$items_totaal = mysql_result($query, 0);
mysql_free_result($query);
$items_per_pagina = 5;
$aantal_paginas = ceil($items_totaal / $items_per_pagina);
$huidige_pagina = 0;
if(isset($_GET['p']) && is_numeric($_GET['p']) && $_GET['p'] > 0 && $_GET['p'] < $aantal_paginas) {
    $huidige_pagina = $_GET['p'];
}
$offset = $huidige_pagina * $items_per_pagina;
$output = mysql_query("SELECT * FROM post ORDER BY id DESC LIMIT ".
$offset.",".$items_per_pagina)
 or die("output:". mysql_error());

?>

<?php
ob_start();
 

  while ($output = mysql_fetch_assoc($query)) 
    { 
     print ($output['auteur'] . " " . "-" . " ");
     print ($output['email'] . "<br />");
     print (stripslashes($output['bericht']));
     print ("<hr />");
    }
if(isset($_POST['verzenden']))
{


mysql_query("INSERT INTO post (auteur, email, bericht) VALUES ('".$_POST['auteur']."','".$_POST['email']."','".$_POST['bericht']."')") or die (mysql_error()); 
header('Location: '.$_SERVER['PHP_SELF']);
print "Je bericht is succesvol toegevoegd"; 
  } 
else 
  {
  ?>
  <center>
<form action=" <?=$_SERVER['PHP_SELF']?> " method="POST">
Voornaam: <br><input type="text" name="auteur"><br /> 
E-mail: <br><input type="text" name="email"><br /> 
Bericht: <br><textarea name="bericht" rows="5" cols="30">Typ hier je bericht</textarea><br /> 
<input type="submit" name="verzenden" value="verzenden"> 
</form> </center>
<?php
  } 
?> 

<?php
include('config.php');
$query = mysql_query("SELECT COUNT(id) FROM post") or die("query:". mysql_error());
$items_totaal = mysql_result($query, 0);
mysql_free_result($query);
$items_per_pagina = 5;
$aantal_paginas = ceil($items_totaal / $items_per_pagina);
$huidige_pagina = 0;
if(isset($_GET['p']) && is_numeric($_GET['p']) && $_GET['p'] > 0 && $_GET['p'] < $aantal_paginas) {
    $huidige_pagina = $_GET['p'];
}
$offset = $huidige_pagina * $items_per_pagina;
$output = mysql_query("SELECT * FROM post ORDER BY id DESC LIMIT ".
$offset.",".$items_per_pagina)
 or die("output:". mysql_error());
 
?>
 
<?php
ob_start();
 
 
  while ($output = mysql_fetch_assoc($query)) 
    { 
     print ($output['auteur'] . " " . "-" . " ");
     print ($output['email'] . "<br />");
     print (stripslashes($output['bericht']));
     print ("<hr />");
    }
if(isset($_POST['verzenden']))
{
 
 
mysql_query("INSERT INTO post (auteur, email, bericht) VALUES ('".$_POST['auteur']."','".$_POST['email']."','".$_POST['bericht']."')") or die (mysql_error()); 
header('Location: '.$_SERVER['PHP_SELF']);
print "Je bericht is succesvol toegevoegd"; 
  } 
else 
  {
  ?>
  <center>
<form action=" <?=$_SERVER['PHP_SELF']?> " method="POST">
Voornaam: <br><input type="text" name="auteur"><br /> 
E-mail: <br><input type="text" name="email"><br /> 
Bericht: <br><textarea name="bericht" rows="5" cols="30">Typ hier je bericht</textarea><br /> 
<input type="submit" name="verzenden" value="verzenden"> 
</form> </center>
<?php
  } 
?>

$query = mysql_query("SELECT * FROM post ORDER BY id DESC LIMIT ".

$query = mysql_query("SELECT * FROM post ORDER BY id DESC LIMIT ".

<?php
if(empty($_POST['auteur']))
{
    echo 'Auteur is niet ingevuld.';
}
else
{
    $auteur = mysql_escape_string($_POST['auteur']);
    # hier je QUERY, ipv. $_POST waarde gebruik je $auteur
}
?>

<?php
if(empty($_POST['auteur']))
{
    echo 'Auteur is niet ingevuld.';
}
else
{
    $auteur = mysql_escape_string($_POST['auteur']);
    # hier je QUERY, ipv. $_POST waarde gebruik je $auteur
}
?>