Webwereld

[PHP]Ledenlijst, hulp nodig

Gestart doorFreestyle7 reacties64 weergaven
Log in om mee te praten

8 berichten · pagina 1 van 1

Freestyle

Lid · Topicstarter

Berichten
7.681
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik heb een ledenlijst. Met pagina systeem er in. Maar nu lukt het mij niet om alles te sorteren.
Op naam, id, email etc.

Voor dat sorteren gebruik ik het volgende scriptje:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]])) {[/COLOR]
[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM table ORDER BY id ASC"[/COLOR][COLOR= #007700]:[/COLOR]
[COLOR= #FF8000]///de rest van de query
/// hier de lijst[/COLOR]
[COLOR= #007700]}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]]))[/COLOR]
[COLOR= #FF8000]/// hier de lijst[/COLOR]
[COLOR= #007700]}[/COLOR]
etc[COLOR= #007700],[/COLOR]


Maar met dat pagina nummering doet ie dat niet.
Bij dat pagina nummering word de link: ?p=1 (of 0,2,3,4 etc)
Dus hoe kan ik dit het besten doen?
0
Kenzo

Lid

Berichten
1.314
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
LIMIT 5,10 bijvoorbeeld gebruiken.
Dus hij start bij 5 en laat er dan 10 zien. Zo zou je dat dus kunnen doen, dan moet je checken op $_get[p] en dan gaan tellen enz. Ik heb wel een mooi pagina nummering scriptje geschreven en misschien post ik die het weekend hier wel even.
0
Freestyle

Lid · Topicstarter

Berichten
7.681
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Kenzo schreef:
LIMIT 5,10 bijvoorbeeld gebruiken.
Dus hij start bij 5 en laat er dan 10 zien. Zo zou je dat dus kunnen doen, dan moet je checken op $_get[p] en dan gaan tellen enz. Ik heb wel een mooi pagina nummering scriptje geschreven en misschien post ik die het weekend hier wel even.
Dat script heb ik en werkt. Maar het werkt niet samen met het script hier bovensadleyDit script gebruik ik: http://www.sitemasters.be/tutorials/1/1/198/PHP/Pagina_navigatie_in_PHP_en_MySQL
Naja die tutorial heb ik gebruikt.
0
Wiitse

Lid

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik heb even speciaal voor jou dit gemaakt: (Ik verveelde me toch... yummie)

[COLOR= #0000BB]<?php
$per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]10[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM table ORDER BY id ASC"[/COLOR][COLOR= #007700]):[/COLOR]
[COLOR= #0000BB]$pages[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])[/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]= ([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]]) &&[/COLOR] is_nummeric[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]])) ?[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]] :[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM table ORDER BY id LIMIT "[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]",10"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #FF8000]///de rest van de query
/// hier de lijst[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="?p=1">&laquo</a>[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]2[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]2[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]<a href="?p=[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]</a>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]<a href="?p=[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]</a>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<strong>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</strong>[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]<a href="?p=[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]</a>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]2[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]2[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]<a href="?p=[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$page[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]</a>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="?p=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$pages[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">$raquo</a>[/COLOR][COLOR= #007700];[/COLOR]

[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]]))[/COLOR]
[COLOR= #FF8000]/// hier de lijst[/COLOR]
[COLOR= #007700]}[/COLOR]
?>


Niet getest, maar het zou moeten werken. smile
0
Freestyle

Lid · Topicstarter

Berichten
7.681
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hij werkt niet.
Dat licht onder anderen aan:

$sql = "SELECT * FROM table ORDER BY id LIMIT ".($page * $per_pagina).",10";
0
Justafool

Lid

Berichten
515
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Freestyle schreef:
Hij werkt niet.
Dat licht onder anderen aan:

$sql = "SELECT * FROM table ORDER BY id LIMIT ".($page * $per_pagina).",10";
Misschien "table" even aanpassen naar de tabelnaam in jou database waar het uit gehaald moet worden..
0
Jeffreyy

Lid

Berichten
6.144
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
$sql = "SELECT * FROM table ORDER BY id LIMIT ".($page * $per_pagina).", ".($page * $per_pagina + $per_pagina);
0
Freestyle

Lid · Topicstarter

Berichten
7.681
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Jponsen schreef:
$sql = "SELECT * FROM table ORDER BY id LIMIT ".($page * $per_pagina).", ".($page * $per_pagina + $per_pagina);
Maar het licht niet aan het pagina nummer systeem. Want dat werkt. Het werkt niet samen met het sorteer script
Script:
Spoiler tonen
<table id="rounded-corner">
    <thead>
        <tr>
            <th scope="col" class="rounded-company"></th>
            <th scope="col" class="rounded"><a href="?id">Id</a></th>
            <th scope="col" class="rounded"><a href="?usr?">Naam</a></th>
            <th scope="col" class="rounded"><a href="?mail">Email</a></th>
            <th scope="col"class="rounded"><a href="?ip">IP</a></th>
            <th scope="col" class="rounded"><a href="?sal">Saldo</a></th>
            <th scope="col" class="rounded"><a href="?pro">Producten</a></th>
            <th scope="col" class="rounded-q4">Wijzig</th>
        </tr>
    </thead>
    <tbody>
[COLOR= #0000BB]<?php
$res1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(id) FROM users"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res1: "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR] [COLOR= #FF8000]// vraag het AANTAL items op[/COLOR]
[COLOR= #0000BB]$items_totaal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #FF8000]// het totaal aantal items[/COLOR]
[URL="http://www.php.net/mysql_free_result"]mysql_free_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res1[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #FF8000]// geef het resultaat vrij[/COLOR]

[COLOR= #0000BB]$items_per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// vrij te kiezen[/COLOR]
[COLOR= #0000BB]$aantal_paginas[/COLOR] [COLOR= #007700]=[/COLOR]  [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$items_totaal[/COLOR] / [COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #FF8000]// het aantal items per pagina

// de huidige pagina opvragen[/COLOR]
[COLOR= #0000BB]$huidige_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// default[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]] >[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]] <[/COLOR] [COLOR= #0000BB]$aantal_paginas[/COLOR][COLOR= #007700]) {[/COLOR]
    [COLOR= #0000BB]$huidige_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]];
}[/COLOR]

[COLOR= #FF8000]// items van de huidige pagina ophalen[/COLOR]
[COLOR= #0000BB]$offset[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$huidige_pagina[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY id ASC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]])&&[/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]usr[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY gebruiker ASC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mail[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY email ASC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]sal[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY saldo DESC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pro[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY gebruiker ASC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY ip DESC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]    
    [COLOR= #0000BB]$res2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users ORDER BY gebruiker ASC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$offset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR]
    [COLOR= #007700].[/COLOR][COLOR= #0000BB]$items_per_pagina[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"res2:"[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700])) 
    {[/COLOR]
    ?>
        <tr>
            <td><input type="checkbox" name="" /></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>&euro; [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]saldo[/COLOR][COLOR= #007700]];[/COLOR] ?></td>
            <td>4</td>
            <td><a href="?verwijder"><img src="images/user_edit.png" alt="" title="" border="0" /></a></td>
        </tr>
    [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR]

[COLOR= #FF8000]// resultaten vrijgeven[/COLOR]
[URL="http://www.php.net/mysql_free_result"]mysql_free_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res2[/COLOR][COLOR= #007700]);[/COLOR]



[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="pagination">[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #FF8000]// navigatie[/COLOR]
[URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$aantal_paginas[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++) {[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$huidige_pagina[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #FF8000]// huidige pagina is niet klikbaar[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<span class="current">[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</b>"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</span>[/COLOR][COLOR= #007700];
    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [COLOR= #FF8000]// een andere pagina dan de huidige is wel klikbaar[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href=""[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]PHP_SELF[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"?p="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"">"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];
    }[/COLOR]
   [COLOR= #FF8000]// deel-streepje tussen alle items[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$aantal_paginas[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]" - "[/COLOR][COLOR= #007700];
    }
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];[/COLOR]
?>
        
        
    </tbody>
</table>
Alvast bedankt
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