I have problem with my paging PHP script. First page works perfectly, but next pages are blank. Config.php include database setting like host etc. Please help me solve my problem. Thanks in advance.
Here is my code:
include 'config.php';
mysql_connect($iplogow, $userlogow, $haslologow) or die("Mysql error: " . mysql_error());
mysql_select_db($bazalogow)or die("Błąd bazy danych: " . mysql_error());
echo '<br>
<table class="table table-bordered table-striped" width="500px">
<thead>
<tr>
<th>table1</th>
<th>table2</th>
<th>table3</th>
<th>table4</th>
<th>table5</th>
<th>table6</th>
<th>table7</th>
</tr></thead>';
$result = mysql_query("SELECT Count(id) FROM `logi`");
$row = mysql_fetch_row($result);
$count_users = $row[0];
$per_page = 10;
$pages = ceil($count_users / $per_page);
$current_page = !isset($_GET['page']) ? 1 : (int)clear($_GET['page']);
if($current_page < 1 || $current_page > $pages) {
$current_page = 1;
}
if($count_users > 0) {
$result = mysql_query("SELECT * FROM `logi` ORDER BY `id` DESC LIMIT ".($per_page*($current_page-1)).", ".$per_page);
while($row = mysql_fetch_assoc($result)) {
echo '<tr>
<td>'.$row['nick'].'</td>
<td>'.$row['ip'].'</td>
<td>'.$row['password'].'</td>
<td>'.$row['productid'].'</td>
<td>'.$row['client'].'</td>
<td>'.$row['date'].'</td>
<td>'.$row['hour'].'</td>
</tr>';
}
} else {
echo '<tr>
<td colspan="3" style="text-align:center">Niestety nie znaleziono żadnych ataków.</td>
</tr>';
}
echo '</table>';
if($pages > 0) {
echo '<p>';
if($pages < 11) {
for($i = 1; $i <= $pages; $i++) {
if($i == $current_page) {
echo '<b>['.$current_page.']</b> ';
} else {
echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
}
}
} elseif($current_page > 10) {
echo '<a href="ataki.php?page=1">[1]</a> ';
echo '<a href="ataki.php?page=2">[2]</a> ';
echo '[...] ';
for($i = ($current_page-3); $i <= $current_page; $i++) {
if($i == $current_page) {
echo '<b>['.$current_page.']</b> ';
} else {
echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
}
}
for($i = ($current_page+1); $i <= ($current_page+3); $i++) {
if($i > ($pages)) break;
if($i == $current_page) {
echo '<b>['.$current_page.']</b> ';
} else {
echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
}
}
if($current_page < ($pages-4)) {
echo '[...] ';
echo '<a href="ataki.php?page='.($pages-1).'">['.($pages-1).']</a> ';
echo '<a href="ataki.php?page='.$pages.'">['.$pages.']</a> ';
} elseif($current_page == ($pages-4)) {
echo '[...] ';
echo '<a href="ataki.php?page='.$pages.'">['.$pages.']</a> ';
}
} else {
for($i = 1; $i <= 11; $i++) {
if($i == $current_page) {
if($i > ($pages)) break;
echo '<b>['.$current_page.']</b> ';
} else {
echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
}
}
if($pages > 12) {
echo '[...] ';
echo '<a href="ataki.php?page='.($pages-1).'">['.($pages-1).']</a> ';
echo '<a href="ataki.php?page='.$pages.'">['.$pages.']</a> ';
} elseif($pages == 12) {
echo '[...] ';
echo '<a href="ataki.php?page=12">[12]</a> ';
}
}
echo '</p>';
}
?>