Pagina nummer komen niet?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
<?php
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Calculate some stuff
$end = $start + $max; // This is for the query, gives the number for the LIMIT
$prev = $start - $max; // This number is for $start in the Previous-hyperlink
$next = $end; // This number is for $start in the Next-hyperlink
if(!$_GET['letter'])
{
$letter = 'a';
}
else
{
$letter = $_GET['letter']; // Begin letter
}
// Select everything from the table
$query = mysql_query("SELECT * FROM leden WHERE gebruikersnaam LIKE '".$letter."%' ORDER BY gebruikersnaam LIMIT $start, $max") or die (mysql_error());
// Number of rows from $query
$num = mysql_num_rows($query);
if (empty($num))
{
echo "Er zijn geen gebruikers gevonden!";
}
else
{
echo '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
echo '<tr><td><b>Gebruikersnaam:</b></td><td><b>Voornaam:</b></td><td><b>Waarschuwingen:</b></td><td><b>Rank:</b></td></tr>';
while ($row = mysql_fetch_assoc($query))
{
$rank = $row['rank'];
echo '<tr><td>'.$row['gebruikersnaam'].'</td><td>'.$row['naam'].'</td><td>'.$row['waarschuwingen'].'</td><td><font color="'.$color_array[$rank].'">'.$row['rank'].'</font></td></tr>';
}
echo '</table>';
echo "<br><center>";
// Check if $prev is higher than or equal to 0, if so add the Previous-hyperlink
if ($prev >= '0')
{
echo "[<a href=\"?p=pages/user/ledenlijst&start=$prev&max=$max\">Vorige</a>]\n";
} else {
echo "[Vorige]\n";
}
// Count how many rows there are in the table
$count = mysql_fetch_assoc(mysql_query("SELECT count(*) FROM leden WHERE gebruikersnaam LIKE '".$letter."%' ORDER BY gebruikersnaam"));
// Calculate on which page we are
$thispage = ceil($start/$max+1);
// If $count[0] is higher than $max, show the pagenumbers
if ($count[0] > $max)
{
// Calculate the amount of pages
$total = ceil($count[0]/$max);
for($i=0;$i<$total;$i++)
{
// The number to show has to be $1+1 (because $i starts with 0)
$number = $i+1;
// $start has to be $i * $max
$start = $i*$max;
// If thispage is equal to the number, the link has to be bold
if ($thispage == $number)
{
echo "<strong>[<a href=\"?p=pages/user/ledenlijst&start=" . $start . "&max=" . $max . "\">" . $number . "</a>]</strong>\n";
} else {
echo "<a href=\"?p=pages/user/ledenlijst&start=" . $start . "&max=" . $max . "\">" . $number . "</a>\n";
}
}
}
// If $count[0] is higher than $next, show the hyperlink
if ($count[0] > $next)
{
echo "[<a href=\"?p=pages/user/ledenlijst&start=$next&max=$max\">Volgende</a>]\n";
} else {
echo "[Volgende]\n";
}
echo "</center>";
}
?>
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Calculate some stuff
$end = $start + $max; // This is for the query, gives the number for the LIMIT
$prev = $start - $max; // This number is for $start in the Previous-hyperlink
$next = $end; // This number is for $start in the Next-hyperlink
if(!$_GET['letter'])
{
$letter = 'a';
}
else
{
$letter = $_GET['letter']; // Begin letter
}
// Select everything from the table
$query = mysql_query("SELECT * FROM leden WHERE gebruikersnaam LIKE '".$letter."%' ORDER BY gebruikersnaam LIMIT $start, $max") or die (mysql_error());
// Number of rows from $query
$num = mysql_num_rows($query);
if (empty($num))
{
echo "Er zijn geen gebruikers gevonden!";
}
else
{
echo '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
echo '<tr><td><b>Gebruikersnaam:</b></td><td><b>Voornaam:</b></td><td><b>Waarschuwingen:</b></td><td><b>Rank:</b></td></tr>';
while ($row = mysql_fetch_assoc($query))
{
$rank = $row['rank'];
echo '<tr><td>'.$row['gebruikersnaam'].'</td><td>'.$row['naam'].'</td><td>'.$row['waarschuwingen'].'</td><td><font color="'.$color_array[$rank].'">'.$row['rank'].'</font></td></tr>';
}
echo '</table>';
echo "<br><center>";
// Check if $prev is higher than or equal to 0, if so add the Previous-hyperlink
if ($prev >= '0')
{
echo "[<a href=\"?p=pages/user/ledenlijst&start=$prev&max=$max\">Vorige</a>]\n";
} else {
echo "[Vorige]\n";
}
// Count how many rows there are in the table
$count = mysql_fetch_assoc(mysql_query("SELECT count(*) FROM leden WHERE gebruikersnaam LIKE '".$letter."%' ORDER BY gebruikersnaam"));
// Calculate on which page we are
$thispage = ceil($start/$max+1);
// If $count[0] is higher than $max, show the pagenumbers
if ($count[0] > $max)
{
// Calculate the amount of pages
$total = ceil($count[0]/$max);
for($i=0;$i<$total;$i++)
{
// The number to show has to be $1+1 (because $i starts with 0)
$number = $i+1;
// $start has to be $i * $max
$start = $i*$max;
// If thispage is equal to the number, the link has to be bold
if ($thispage == $number)
{
echo "<strong>[<a href=\"?p=pages/user/ledenlijst&start=" . $start . "&max=" . $max . "\">" . $number . "</a>]</strong>\n";
} else {
echo "<a href=\"?p=pages/user/ledenlijst&start=" . $start . "&max=" . $max . "\">" . $number . "</a>\n";
}
}
}
// If $count[0] is higher than $next, show the hyperlink
if ($count[0] > $next)
{
echo "[<a href=\"?p=pages/user/ledenlijst&start=$next&max=$max\">Volgende</a>]\n";
} else {
echo "[Volgende]\n";
}
echo "</center>";
}
?>
Er zijn nog geen reacties op dit bericht.