Pagina-nav inbouwen.

<?php 
$host="localhost"; // Host name 
$username="xxxxx"; // Mysql username 
$password="xxxxxx"; // Mysql password 
$db_name="xxxxxx"; // Database name 
$tbl_name="xxxxx"; // Table name

// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 

$sql="SELECT * FROM $tbl_name ORDER BY gebruiker_id"; 
$result=mysql_query($sql);
 

// Count table rows 
$count=mysql_num_rows($result);
?> 
 
<form name="form1" method="post" action=""> 
 
<?php 
while($rows=mysql_fetch_array($result)){ 
?>

//hier komt het formulier

<?php 
} 
?> 
  
<?php 
// Check if button name "Submit" is active, do this 
if($Submit){ 
for($i=0;$i<$count;$i++){ 
$sql1="UPDATE $tbl_name SET gebruikersnaam='$gebruikersnaam[$i]', email='$email[$i]', website='$website[$i]', ipadres='$ipadres[$i]', wachtwoord='$wachtwoord[$i]', status='$status[$i]' WHERE gebruiker_id='$gebruiker_id[$i]'";
$result1=mysql_query($sql1); 
}
}
 

if($result1){ 
            echo "Gegevens zijn opgeslagen."; 
} 
mysql_close(); 
?>

<?php 
$host="localhost"; // Host name 
$username="xxxxx"; // Mysql username 
$password="xxxxxx"; // Mysql password 
$db_name="xxxxxx"; // Database name 
$tbl_name="xxxxx"; // Table name
 
// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 
 
$sql="SELECT * FROM $tbl_name ORDER BY gebruiker_id"; 
$result=mysql_query($sql);
 
 
// Count table rows 
$count=mysql_num_rows($result);
?> 
 
<form name="form1" method="post" action=""> 
 
<?php 
while($rows=mysql_fetch_array($result)){ 
?>
 
//hier komt het formulier
 
<?php 
} 
?> 
 
<?php 
// Check if button name "Submit" is active, do this 
if($Submit){ 
for($i=0;$i<$count;$i++){ 
$sql1="UPDATE $tbl_name SET gebruikersnaam='$gebruikersnaam[$i]', email='$email[$i]', website='$website[$i]', ipadres='$ipadres[$i]', wachtwoord='$wachtwoord[$i]', status='$status[$i]' WHERE gebruiker_id='$gebruiker_id[$i]'";
$result1=mysql_query($sql1); 
}
}
 
 
if($result1){ 
            echo "Gegevens zijn opgeslagen."; 
} 
mysql_close(); 
?>