Webwereld

Paginanavigatie

Gestart doorRubenmaxie5 reacties24 weergaven
Log in om mee te praten

6 berichten · pagina 1 van 1

Rubenmaxie

Lid · Topicstarter

Berichten
592
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Heey,

Ik wil dus zegmaar een paginanavigatie op me site hebben voor de ledenlijst. Dus zegmaar,
dat je van die cijfers krijgt, waar je op kan klikken.

Kan iemand dit mij uitleggen? redface
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Ik kan het niet echt uitleggen, maar zo gebruikte ik het bij mijn ledensysteem:

<h1>Gebruikerslijst</h1> 
[COLOR= #0000BB]<?php
    $per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]15[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]] :[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$pagina[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) +[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$paginas_mysql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(1) AS aantal FROM login_members"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$fetch_mysql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$paginas_mysql[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$paginas[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch_mysql[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]][/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR]
                    
    [COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id,munten,status,username FROM login_members ORDER BY id LIMIT "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]","[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700])) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<table>"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td><b>Id:</b></td><td><b>Username:</b></td><td><b>Muntjes:</b></td><td><b>Rang:</b></td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
        
        [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$users[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700])) {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td width="15%">[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000].</td><td width="55%">[/COLOR][COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR][COLOR= #DD0000]</td><td width="15%">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]munten[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</td><td width="15%">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700]; 
        }[/COLOR]
        
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table><br />"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="multierror">Geen gebruikers gevonden met het id [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] of hoger</div><br />[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++) {[/COLOR]
       [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$paginas[/COLOR][COLOR= #007700]) {[/COLOR]
          [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]) {[/COLOR]
             [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700];
          }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
             [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href=index.php?p=list&start="[/COLOR] [COLOR= #007700]. (([/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700])*[/COLOR][COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]">"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];
          }[/COLOR]
          [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"&nbsp;"[/COLOR][COLOR= #007700];
       }
    }[/COLOR]
?>
0
Rubenmaxie

Lid · Topicstarter

Berichten
592
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Kan iemand dit misschien wel uitleggen? hypocrite
Ik snap het namelijk maar half.
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
h1>Gebruikerslijst</h1> 
[COLOR= #0000BB]<?php
    $per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]15[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// hoeveel gebruikers per pagina ?[/COLOR]
    [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]] :[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// berekeningetje[/COLOR]
    
    [COLOR= #0000BB]$pagina[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) +[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// nog een berekeningetje[/COLOR]
    [COLOR= #0000BB]$paginas_mysql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(1) AS aantal FROM login_members"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR] [COLOR= #FF8000]// het ophalen van hoeveel gebruikers er eigenlijk zijn[/COLOR]
    [COLOR= #0000BB]$fetch_mysql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$paginas_mysql[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #FF8000]// die ook fetchen[/COLOR]
    [COLOR= #0000BB]$paginas[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch_mysql[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]][/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #FF8000]// kijken hoeveel paginas nodig zijn om elke gebruiker te laten zien[/COLOR]
                    
    [COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id,munten,status,username FROM login_members ORDER BY id LIMIT "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]","[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR] [COLOR= #FF8000]// ophalen wat er in ledenlijst moet[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700])) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<table>"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td><b>Id:</b></td><td><b>Username:</b></td><td><b>Muntjes:</b></td><td><b>Rang:</b></td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
        
        [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$users[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700])) {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td width="15%">[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000].</td><td width="55%">[/COLOR][COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR][COLOR= #DD0000]</td><td width="15%">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]munten[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</td><td width="15%">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$users[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700]; 
        }[/COLOR] [COLOR= #FF8000]// echoen van de gebruikersgegevens[/COLOR]
        
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table><br />"[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="multierror">Geen gebruikers gevonden met het id [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] of hoger</div><br />[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// als er geen gebruiker met id x is gevonden error weergeven[/COLOR]
    [COLOR= #007700]}[/COLOR]
    [COLOR= #FF8000]// paginatie crap[/COLOR]
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++) {[/COLOR]
       [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$paginas[/COLOR][COLOR= #007700]) {[/COLOR]
          [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]) {[/COLOR]
             [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700];
          }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
             [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href=index.php?p=list&start="[/COLOR] [COLOR= #007700]. (([/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700])*[/COLOR][COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]">"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];
          }[/COLOR]
          [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"&nbsp;"[/COLOR][COLOR= #007700];
       }
    }[/COLOR]
?>
0
Rubenmaxie

Lid · Topicstarter

Berichten
592
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Thnx! Ik snap het! biggrin
Edit:
Oh, nog even een vraagje...

Hoe worden die nieuwe paginas dan aangemaakt, waar tie naar linkt? redface
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Hij haalt uit de de url ?start=

Daar begint ie uit de sql te halen (dus bijvoorbeeld vanaf 15 tot en met 30)

En echod die
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren