toon volgende 7 berichten
MIJN HUIDIGE CODE
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
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
<?
//-- maak eerst de connectie met de database!
$user = "*****";
$pass = "*****";
$host = "*****";
$dbdb = "*****";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
echo "Kan geen verbinding maken met de database.";
exit();
}
unset($user);
unset($pass);
unset($host);
unset($dbdb);
$resultaten = mysql_query("SELECT *
FROM `news`
WHERE 1 ORDER BY `id` DESC LIMIT 0, 7");
while ($gegevens = mysql_fetch_object($resultaten))
{
$id = ($gegevens->id);
$titel = ($gegevens->titel);
$datum = ($gegevens->datum);
$bericht = ($gegevens->bericht);
echo "<table width=\"650\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "<strong>";
echo "$datum";
echo " ";
echo " ";
echo "$titel";
echo "</strong>";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td height=\"1\" bgcolor=\"#55708F\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "$bericht";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
?>
//-- maak eerst de connectie met de database!
$user = "*****";
$pass = "*****";
$host = "*****";
$dbdb = "*****";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
echo "Kan geen verbinding maken met de database.";
exit();
}
unset($user);
unset($pass);
unset($host);
unset($dbdb);
$resultaten = mysql_query("SELECT *
FROM `news`
WHERE 1 ORDER BY `id` DESC LIMIT 0, 7");
while ($gegevens = mysql_fetch_object($resultaten))
{
$id = ($gegevens->id);
$titel = ($gegevens->titel);
$datum = ($gegevens->datum);
$bericht = ($gegevens->bericht);
echo "<table width=\"650\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "<strong>";
echo "$datum";
echo " ";
echo " ";
echo "$titel";
echo "</strong>";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td height=\"1\" bgcolor=\"#55708F\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "$bericht";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
?>
dit is dan je query:
"SELECT *
FROM `news`
WHERE 1 ORDER BY `id` DESC LIMIT ".$_GET['pagina'].", 7"
en dan zet je waar je de link wil dit:
zoiets zou het normaal moeten zijn...
Gewijzigd op 09/06/2004 19:54:00 door de VeeWee
Elwin ook..
http://www.phphulp.nl/php/scripts.php?cat=2&id=123
En bassie ook!
http://www.phphulp.nl/php/scripts/3/156
Gewijzigd op 10/06/2004 01:58:00 door Arend a
zet dat er nog ff boven, dan doettie ut..
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
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
<?
//-- maak eerst de connectie met de database!
$user = "****";
$pass = "****";
$host = "****";
$dbdb = "****";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
echo "Kan geen verbinding maken met de database.";
exit();
}
unset($user);
unset($pass);
unset($host);
unset($dbdb);
$resultaten = mysql_query("SELECT *
FROM `news`
WHERE 1 ORDER BY `id` DESC LIMIT ".$_GET['pagina'].", 6");
while ($gegevens = mysql_fetch_object($resultaten))
{
$id = ($gegevens->id);
$titel = ($gegevens->titel);
$datum = ($gegevens->datum);
$bericht = ($gegevens->bericht);
echo "<table width=\"650\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "<strong>";
echo "$datum";
echo " ";
echo " ";
echo "$titel";
echo "</strong>";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td height=\"1\" bgcolor=\"#55708F\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "$bericht";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
?>
//-- maak eerst de connectie met de database!
$user = "****";
$pass = "****";
$host = "****";
$dbdb = "****";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
echo "Kan geen verbinding maken met de database.";
exit();
}
unset($user);
unset($pass);
unset($host);
unset($dbdb);
$resultaten = mysql_query("SELECT *
FROM `news`
WHERE 1 ORDER BY `id` DESC LIMIT ".$_GET['pagina'].", 6");
while ($gegevens = mysql_fetch_object($resultaten))
{
$id = ($gegevens->id);
$titel = ($gegevens->titel);
$datum = ($gegevens->datum);
$bericht = ($gegevens->bericht);
echo "<table width=\"650\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "<strong>";
echo "$datum";
echo " ";
echo " ";
echo "$titel";
echo "</strong>";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td height=\"1\" bgcolor=\"#55708F\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td valign=\"top\">\n";
echo "<font face=\"arial\" size=\"-1\" color=\"#55708F\">";
echo "$bericht";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
?>
<table width="650" border="0" cellpadding="0" cellspacing="0"><tr><td><div align="right">
Code (php)
1
2
3
4
2
3
4
<?php
$page = $_GET['pagina'] + 6;
echo "<a href=\"?pagina=".$page."\"><font face=\"arial\" size=\"-1\" color=\"#55708F\">>></a>";
?>
$page = $_GET['pagina'] + 6;
echo "<a href=\"?pagina=".$page."\"><font face=\"arial\" size=\"-1\" color=\"#55708F\">>></a>";
?>
resultaten = mysql_query("SELECT *
FROM `news`
WHERE 1 ORDER BY `id` DESC LIMIT ".$_GET['pagina'].", 6");
Kan er ook voor gezorgd worden dat er bvb
Op pagina 1 : >>
Op pagina 2 : << >>
...
Op de laatste pagina enkel : <<
Elwin
[Edit: Typo]
Gewijzigd op 10/06/2004 11:12:00 door Elwin - Fratsloos
Code (php)
1
2
3
2
3
<?php
$resultaten = mysql_query("SELECT * FROM `news` WHERE 1 ORDER BY `id` DESC LIMIT ".$_GET['pagina'].", 6");
?>
$resultaten = mysql_query("SELECT * FROM `news` WHERE 1 ORDER BY `id` DESC LIMIT ".$_GET['pagina'].", 6");
?>
(Ik snap trouwens je WHERE niet in deze query, maar oké...)
Als ik nou eens niet jouw hyperlink in de pagina volg (pagina.php?pagina=1), maar van die 1 iets anders maak bijvoorbeeld ?pagina=1,2;DROP TABLE blabla.
Dan ben je mooi tabel blabla kwijt...
Elwin
Hier staat dus als $_GET['pagina'] een getal is, dan krijgt $pagina de waarde van $_GET['pagina'];
In je query kan je dat $pagina doen in plaats van $_GET['pagina'];
Je kan ook bijvoorbeeld zoiets doen:
if(!is_numeric($_GET['pagina'])
{
echo "fout!";
} else {
// Voer de query uit... (nu wel met $_GET['pagina'] erin...)
}
Elwin
ga ik toch ook vlug even beveiligen!
Gewijzigd op 10/06/2004 15:35:00 door Arend a