Beste,
ik heb ge probeerd om gewoon 3 items van mijn sql te lezen.
en dan een butten volgende pagina of naar de vorige pagina vorige 3
maar dit lukt met niet kan iemand me toevalig helpen.
Aanvullend bericht:PHP Code:<? $psysteem['reacties'] = mysql_num_rows($pQuery);
$psysteem['paginas'] = ceil($psysteem['reacties'] / 3);
if(isset($_GET['p']))
{
$psysteem['pagina'] = $_GET['p'];
$limit = $_GET['p'] * 3 - 3;
}else{
$psysteem['pagina'] = 1;
$limit = 1 * 3 - 3;
}
if($psysteem['pagina'] > ($psysteem['paginas'] - 2))
{
$psysteem['begin'] = $psysteem['paginas'] - 4;
}elseif(($psysteem['paginas'] > 5) && ($psysteem['pagina'] > 3))
{
$psysteem['begin'] = $psysteem['pagina'] - 2;
}else{
$psysteem['begin'] = 1;
}
$psysteem['i'] = 0;
if($psysteem['paginas'] > 5)
{
$psysteem['max'] = 5;
}else{
$psysteem['max'] = $psysteem['paginas'] - 1;
$psysteem['begin'] = 1;
}
$pSys = '';
$pSys .= '<a style="padding: 4px;" href="'.$url.'?p=1">«</a>';
for($p=$psysteem['begin'];$psysteem['i']<=$psysteem['max'];$p++)
{
if($p == $psysteem['pagina'])
{
$pSys .= '<span style="padding: 4px;">'.$p.'</span>';
}else{
$pSys .= '<a style="padding: 4px;" href="'.$url.'?p='.$p.'">'.$p.'</a>';
}
$psysteem['i']++;
}
$pSys .= '<a style="padding: 4px;" href="'.$url.'?p='.$psysteem['paginas'].'">»</a><br />';
/************ select ******************/
$query = "SELECT * FROM `producten` WHERE eigenaar = '" . mysql_real_escape_string($_SESSION['gebruiker'])."' LIMIT $limit,10";
//$query = "SELECT * FROM tabel where ? = ?";
// resultaat maken door query uit te voeren met onderstaand commando
$result = mysql_query($query) or trigger_error( mysql_error() );
//Alle rijen overlopen in een loop
while($rij = mysql_fetch_assoc($result)){
?>
<?php echo $rij['naam'] ?>
<br/>
<?php
}
echo $pSys;
?>
Of kan me iemand helpen met een werkend pagina nummering script
-
22-05-2012, 22:34 #1
Particulier
- Berichten
- 320
- Lid sinds
- 15 Jaar
pagina nummering
Laatst aangepast door fleur verlinden : 22-05-2012 om 23:36 Reden: Automatisch samengevoegd.
-
In de schijnwerper
[SNELLE LEVERING] Laat je website / webshop snel en professioneel bouwen!Freelance / WerkBacklinks.nl - Vanaf € 1,-SEO/LinkbuildingSpraakcomputers.nl - Premium domeinnaam - Medisch / communicatiemiddelenDomein te koopmooie domeinnamen te koop zoals: trappen.nl hypotheekakte.nl vloerenoutlet.nlDomein te koop -
28-05-2012, 18:10 #2
Particulier
- Berichten
- 69
- Lid sinds
- 18 Jaar
Re: pagina nummering
Je wilt per pagina 3 items weergeven, maar in je query vraag je er 10 op:
Dus die LIMIT moet sowieso $limit,3 zijn.PHP Code:$query = "SELECT * FROM `producten` WHERE eigenaar = '" . mysql_real_escape_string($_SESSION['gebruiker'])."' $limit,10";
Laatst aangepast door Tim Colla : 28-05-2012 om 18:13 Reden: code tag
-
28-05-2012, 19:32 #3
Particulier
- Berichten
- 36
- Lid sinds
- 15 Jaar
Re: pagina nummering
Hier een functie die ik ooit heb geschreven voor paginanumering. Hopelijk kom je er zelf wel uit, zo niet, roep dan even (je zult zo hier en daar namelijk wat dingetjes moeten veranderen) :).
Origineel gepost door fleur verlinden
PHP Code:/*
Prints clickable page numbers.
*/
public function printPageSelection($number_of_pages, $prefix = null, $current_page = 1, $page_numbers_to_display = 7, $space_phrase = '..')
{
/*
$page_numbers_to_display defines how many page numbers will be displayed INCLUDING
the page number of the first and last page.
$prefix
Defines a prefix for the url used in the page number <a> elements.
*/
// Make sure we can use the uri class.
global $uri;
$current_page = $current_page ? $current_page : $this->page;
$pages_in_between = $page_numbers_to_display - 2;
$display_space = ($number_of_pages - $pages_in_between) >= 2 ? true : false;
# Display a link to the first page, which must always be visible.
// Check if this link must be displayed selected.
$selected = $current_page == 1 ? ' selected' : null;
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=1" class="first_page_number page_number' . $selected . '">1</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=1" class="first_page_number page_number' . $selected . '">1</a> ';
}
# Display links to the pages in between the first and the last page.
// Calculate the number of page numbers that should be displayed in between
// the first and the last page.
// Calculate the centered number.
$centered_number = ceil($pages_in_between / 2);
// If the current page number is among the first page numbers, display those,
// but don't make the centered number selected by default.
// For example 1 2 3 4 5 6 .. 10.
if($current_page < (1 + $centered_number))
{
for($i=2; $i<(2 + $pages_in_between) && $i<$number_of_pages; $i++)
{
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=' . $i . '" class="first_page_number page_number' . $selected . '">' . $i . '</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=' . $i . '" class="first_page_number page_number' . $selected . '">' . $i . '</a> ';
}
}
if($display_space)
echo '<span class="space_phrase">' . $space_phrase . '</span> ';
}
// Else if the current page number is among the last page numbers, display those,
// but don't make the centered number selected by default.
// For example 1 .. 5 6 7 8 9 10.
elseif($current_page > ($number_of_pages - $centered_number))
{
// Calculate with which number the for loop should start.
$counter_start = $number_of_pages - $pages_in_between;
// If the counter starts at a number lower than 2, set it to
// be 2, as the last part of the page numbers cannot start
// with a number lower than 2 (as it would then be the first part
// of the page numbers, not the last).
if($counter_start <= 1)
$counter_start = 2;
if($display_space)
echo '<span class="space_phrase">' . $space_phrase . '</span> ';
for($i=$counter_start; $i<$number_of_pages && $i>1; $i++)
{
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=' . $i . '" class="first_page_number page_number' . $selected . '">' . $i . '</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=' . $i . '" class="first_page_number page_number' . $selected . '">' . $i . '</a> ';
}
}
}
// Else if we're displaying neither the first or last page numbers, display
// the numbers in between and make the centered number selected by default.
// For example 1 .. 3 4 [5] 6 7 .. 10
else
{
// Calculate how many numbers will be shown before and after the centered number.
// For example 1 .. 3 4 [5] 6 7 .. 10: 2 numbers beside the centered number.
$numbers_beside_centered = floor($pages_in_between / 2);
// Display $separation_char if there is a gap between the first center number
// and the first page.
if($display_space && ($current_page - $numbers_beside_centered) > 2)
echo '<span class="space_phrase">' . $space_phrase . '</span> ';
// Display the numbers that come before the centered number.
for($i=0; $i<$numbers_beside_centered; $i++)
{
$page = $current_page - ($numbers_beside_centered - $i);
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=' . $page . '" class="first_page_number page_number' . $selected . '">' . $page . '</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=' . $page . '" class="first_page_number page_number' . $selected . '">' . $page . '</a> ';
}
}
// Display the centered number.
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=' . $current_page . '" class="first_page_number page_number' . $selected . '">' . $current_page . '</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=' . $current_page . '" class="first_page_number page_number' . $selected . '">' . $current_page . '</a> ';
}
// Display the numbers that come after the centered number.
for($i=1; $i<=$numbers_beside_centered; $i++)
{
$page = $current_page + $i;
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=' . $page . '" class="first_page_number page_number' . $selected . '">' . $page . '</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=' . $page . '" class="first_page_number page_number' . $selected . '">' . $page . '</a> ';
}
}
// Display $separation_char if there is a gap between the last center number
// and the last page.
if($display_space && ($current_page + $numbers_beside_centered) < ($number_of_pages - 1))
echo '<span class="space_phrase">' . $space_phrase . '</span> ';
}
# If there is more than one page, display the link to the last page,
# which must also always be visible, just like the link to the first page.
if($number_of_pages > 1)
{
// Check if the link is selected.
$selected = $current_page == $number_of_pages ? ' selected' : null;
if($this->searchIsDone())
{
echo '<a href="' . $prefix . '?search=' . $this->search . '&page=' . $number_of_pages . '" class="first_page_number page_number' . $selected . '">' . $number_of_pages . '</a> ';
}
else
{
echo '<a href="' . $prefix . '?page=' . $number_of_pages . '" class="first_page_number page_number' . $selected . '">' . $number_of_pages . '</a> ';
}
}
}
Laatst aangepast door Stephan G. : 28-05-2012 om 19:47
