hoi alemaal,
probleempje, ik heb mijn paginering aan de praat gekregen maar hij geeft enkel de 1 ste pagina goed weer met wat hij moet weergeven de volgende paginas kloppen niet en dat komt omdat als ik op pagina 2 klik hij de php self functie aanspreekt van men zoekscriptscript waardoor er foute gegevens worden verzonden omdat men gegevens op het form worden gereset naar de standaard waarde.
<php
<form id="form1" name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" >
<label for="select"></label>
<table width="200" border="0" align="left" cellpadding="5">
<tr>
<th scope="row"><select name="functie" id="select">
<option value="alles" selected="selected">Kies een functiegebied</option>
<option value="lasser">lasser</option>
<option value="mecanicien">Mecanicien</option>
<option value="electricien">electricien</option>
<option value="chauffeur">chauffeur</option>
</select></th>
....
....
?>
php code
<php
<?php
$tableName="kandidatengoed";
$targetpage = "platform.php";
$limit = 10;
$query = "SELECT COUNT(*) as num FROM $tableName WHERE voorkeursfunctiegebied1='".$_POST['functie']."' AND provincie='" . $_POST['provincie'] . "'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
$start = ($page - 1) * $limit;
}else{
$start = 0;
}
// Get page data
$query1 = "SELECT * FROM kandidatengoed WHERE voorkeursfunctiegebied1='".$_POST['functie']."' AND provincie='" . $_POST['provincie'] . "' LIMIT $start, $limit";
$result = mysql_query($query1);
// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;
$paginate = '';
if($lastpage > 1)
{
$paginate .= "<div class='paginate'>";
// Previous
if ($page > 1){
$paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
}else{
$paginate.= "<span class='disabled'>previous</span>"; }
// Pages
if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
}
elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
{
// Beginning only hide later pages
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// Middle hide some front and some back
elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// End only hide early pages
else
{
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
}
}
// Next
if ($page < $counter - 1){
$paginate.= "<a href='$targetpage?page=$next'>next</a>";
}else{
$paginate.= "<span class='disabled'>next</span>";
}
$paginate.= "</div>";
}
echo $total_pages.' Results';
// pagination
echo $paginate;
?>
<ul>
<?php
echo "<table border='1' align='left' cellpadding='4' cellspacing='1' width='auto' bordercolor='#FFCC00'>
<tr>
<th>Voornaam</th>
<th>opleidingsniveau</th>
<th>provincie</th>
<th>Functiegebied</th>
<th>Ervaring</th>
<th>woonplaats</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['voornaam'] . "</td>";
echo "<td>" . $row['opleidingsniveau'] . "</td>";
echo "<td>" . $row['provincie'] . "</td>";
echo "<td>" . $row['voorkeursfunctiegebied1'] . "</td>";
echo "<td>" . $row['ervaring'] . "</td>";
echo "<td>" . $row['woonplaats'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>
2.289 views