Créer un compte
Connexion

Page suivante et limite

Pour créer et répondre aux sujets, vous devez être connecté.
Pages: 1
Auteur Message
blingcru
05/01/2011 à 19:14:03
blingcru
Membre
Bonsoir voila j'ai un systeme basique mais je ne sais pas comment le changer la je n'ai aucune idee comment faire sa

Changer Page des pages limiter a 50 par page et en bas exemple 1,2,3,4,5 apres on met derniere page mais exemple on va payer 6 sa nous metra exemple debut 4,5,6,7,8 fin

Voila je vous monter mon code
<?php


include("lib.php");
define("PAGENAME", "Membres");
$player = check_user($secret_key, $db);
$img = "<img src=images/msn_logo.PNG border=0 align=absmiddle><br /><br />";

$limit = (!$_GET['limit'])?30:intval($_GET['limit']); //Use user-selected limit of players to list
$begin = (!$_GET['begin'])?$player->id-intval($limit / 2):intval($_GET['begin']); //List players with the current player in the middle of the list
$begin = ($begin < 0)?0:$begin; //Can't list negative players :)

$total_players = $db->getone("select count(ID) as `count` from `players`");

$begin = ($begin >= $total_players)?$total_players - $limit:$begin; //Can't list players don't don't exist yet either
$begin = ($begin < 0)?0:$begin; //Can't list negative players :)

$lastpage = (($total_players - $limit) < 0)?0:$total_players - $limit; //Get the starting point if the user has browsed to the last page

include("templates/private_header.php");
echo "<div class=\"contenu\">
 <div class=\"contenu_bloc\">
  <h1>Infirmerie</h1>";
?>

<a href="members.php?begin=<?=($begin - $limit)?>&limit=<?=$limit?>">Page preceedente</a> | <a href="members.php?begin=<?=($begin + $limit)?>&limit=<?=$limit?>">Page suivante</a>
<br /><br />
Montrer <a href="members.php?begin=<?=$begin?>&limit=5">5</a> | <a href="members.php?begin=<?=$begin?>&limit=10">10</a>  | <a href="members.php?begin=<?=$begin?>&limit=20">20</a> | <a href="members.php?begin=<?=$begin?>&limit=30">30</a> | <a href="members.php?begin=<?=$begin?>&limit=40">40</a> | <a href="members.php?begin=<?=$begin?>&limit=50">50</a> | <a href="members.php?begin=<?=$begin?>&limit=100">100</a> membres par page

<br /><br /><br />

<table width="100%" class="tableau" border="0">
<tr>
<th width="30%"><b>Pseudo</b></td>
<th width="10%"><b>Gang</b></td>
<th width="30%"><b>Niveau</b></td>
<th width="40%"><b>Actions</b></td>
</tr>
<?php
//Select all members ordered by level (highest first, members table also doubles as rankings table)
$query = $db->execute("select `id`, `username`, `gang`, `tag`, `level` from `players` where `banni`=0 order by `level` desc limit ?,?", array($begin, $limit));

while($member = $query->fetchrow())
{
        echo "<tr>\n";
        echo "<td><a href=\"profile.php?id=" . $member['username'] . "\">";
        echo ($member['username'] == $player->username)?"<b>":"";
        echo $member['username'];
        echo ($member['username'] == $player->username)?"</b>":"";
        echo "</a></td>\n";
        echo "<td><a href=\"gang_profile.php?id=" . $member['gang'] . "\">";
        echo "" . $member['tag'] . "</a></td>\n";
        echo "<td>" . $member['level'] . "</td>\n";
        echo "<td><a href=\"mail.php?act=compose&to=" . $member['username'] . "\">&Eacutecrire un message</a></td>\n";
        echo "</tr>\n";
}
?>
</table>

<?php
include("templates/private_footer.php");
?>


https://guerredesgangs.net & http://www.bazinio.ca & http://www.thestreet2.ca
Pages: 1