Kod: Zaznacz cały
nazwastrony.pl/admin/index.php?users
Kod: Zaznacz cały
?page=
KOD PHP pliku
Kod: Zaznacz cały
<?php
$query = "SELECT COUNT(*) as all_posts FROM users";
$result = mysql_query($query) or die (mysql_error());
$rows = mysql_fetch_array($result);
extract($rows);
$onpage = 50;
$navnum = 5;
$allpages = ceil($all_posts/$onpage);
if(!isset($_GET['page']) or $_GET['page'] > $allpages or !is_numeric($_GET['page']) or $_GET['page'] <= 0){
$page = 1;
}else{
$page = $_GET['page'];
}
$limit = ($page - 1) * $onpage;
if(isset($_POST['id_login'])) {
$kryterium = clear($_POST['id_login']);
$query = "SELECT * FROM `users` WHERE `nick`='$kryterium' AND `id`='$kryterium' ORDER BY `kasa`";
} else {
$query = "SELECT * FROM `users` ORDER BY `kasa` DESC LIMIT $limit, $onpage";
}
$sql = mysql_query($query) or die (mysql_error());
if(mysql_num_rows($sql) > 0)
{
echo '<div class="well">
<table class="table">
<thead>
<tr>
<th>#</th>
<th>
<center>Nick(ID)</center>
</th>
<th>
<center>E-Mail</center>
</th>
<th>
<center>Portfel</center>
</th>
<th>
<center>PA</center>
</th>
</tr>
</thead>
<tbody>
';
$num = 1 + ($onpage * ($page - 1));
while($r = mysql_fetch_assoc($sql))
{
if($r['grupa'] == 1) {
$grupa = '<a href="#" class="btn btn-success btn-lg disabled" role="button">TAK</a>';
} else {
$grupa = '<a href="#" class="btn btn-danger btn-lg disabled" role="button">NIE</a>';
}
$id = $r['id'];
$login = $r['nick'];
$email = $r['email'];
$kasa = $r['kasa'];
echo '
<tr>
<td style="border-right:solid 1px silver">'.$num.'</td>
<td style="border-right:solid 1px silver"><center>'.$login.' ('.$id.')</center></td>
<td style="border-right:solid 1px silver"><center>'.$email.'</center></td>
<td style="border-right:solid 1px silver"><center>'.$kasa.' wPLN</center></td>
<td style="border-right:solid 1px silver"><center>'.$grupa.'</center></td>
</tr>';
$num++;
}
echo '</tbody></table>';
mysql_free_result($sql);
mysql_close();
}
if($navnum > $allpages){
$navnum = $allpages;
}
$forstart = $page - floor($navnum/2);
$forend = $forstart + $navnum;
if($forstart <= 0){ $forstart = 1; }
$overend = $allpages - $forend;
if($overend < 0){ $forstart = $forstart + $overend + 1; }
$forend = $forstart + $navnum;
$prev = $page - 1;
$next = $page + 1;
$script_name = $_SERVER['SCRIPT_NAME'];
echo "<center ".(($nopages == 1) ? 'style="display: none"': '')."><nav>
<ul class=\"pagination\">";
if($page > 1) echo "<li><a class=\"btn btn-primary\" href=\"".$script_name."?page=".$prev."\">«</a></li>";
if ($forstart > 1) echo "<li><a href=\"".$script_name."?page=1\">1</a></li>";
if ($forstart > 2) echo "<li>...</li>";
for($forstart; $forstart < $forend; $forstart++){
if($forstart == $page){
echo "<li class=\"active\">";
}else{
echo "<li> ";
}
echo "<a class=\"btn btn-primary\" href=\"".$script_name."?page=".$forstart."\">".$forstart."</a></li>";
}
if($forstart - 1 < $allpages) echo "<li><a class=\"btn btn-primary\" href=\"".$script_name."?page=".$allpages."\">".$allpages."</a></li>";
if($page < $allpages) echo "<li><a class=\"btn btn-primary\" href=\"".$script_name."?page=".$next."\">»</a></li>";
echo "</ul></nav></cemter>";
echo '</div>';
echo '
</div>';
#require_once "include/rightbox.php";
echo '</div>';
?>
Liczę na waszą pomoc, bo masakra jakaś ;d pewnie błahostka jakaś, jak zwykle