foto's van sql
Allen de foto’s werk niet goed ik krijg bij alle items zelfde foto.
Kan iemand mij helpen?
Bedankt .
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
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
<?
include_once("inc_connect.php");
$query = mysql_query("SELECT * FROM movie ORDER BY ean") or die(mysql_error());
$content = "";
$content .= "<div class=\"content\">";
$paginatie = "";
if (mysql_num_rows($query) > 0 ){
//create pages
$pg = empty($_GET['pg']) ? 1 : $_GET['pg'];
$catePePag = "5"; // no of items per page
$nrIntrari = mysql_num_rows($query);
$rij = mysql_fetch_assoc($query);
$rest = ($nrIntrari % $catePePag);
$nrPag = IntVal($nrIntrari / $catePePag);
$paginatie = "Page: ";
if ($rest <> 0)
$nrPag = $nrPag + 1;
for ($i=1; $i<=$nrPag; $i++) {
if ($i == $pg)
$paginatie .=" <b>".$i."</b> ";
else
$paginatie .= "<a href=\"index.php?&pg=".$i."\">".$i."</a> ";
}
if ((!intval($pg)) or ($pg > $nrPag))
echo "<script>location.href('index.php?&pg=1');</script>";
$content .= "\n<h1>Books</h1>";
$content .= "<div class=\"paginatie\">";
$content .= $paginatie;
$content .= "</div>";
if ($pg == 1)
$inf = 0;
else
$inf = $catePePag * ($pg-1);
$intrariPag = mysql_query("SELECT * FROM movie ORDER BY ean DESC LIMIT " . $inf . ",". $catePePag. "") or die(mysql_error());
//end of pagination
for($i=0; $i<mysql_num_rows($intrariPag); $i++) {
$content .= "\n<dl class=\"formular\">";
$photo='../images/' . $rij["ean"] . ".jpg";
$content .='<img src="' . $photo .'">';
$content .= "<dt><strong>Name</strong></dt><dd>". mysql_result($intrariPag,$i,'naam')."</dd>";
$content .= "<dt><strong>Nevisande</strong></dt><dd>".mysql_result($intrariPag,$i,'actors')."</dd>";
$content .= "<dt><strong>Mozo</strong></dt><dd>".mysql_result($intrariPag,$i,'omschrijving')."</dd>";
$content .= "<dt><strong>download</strong></dt><dd><a href=\"book.php?ean=" .mysql_result($intrariPag,$i,'ean')."\">"
.mysql_result($intrariPag,$i,'zipnaam')."</a></dd>";
$content .= "\n</dl>";
$content .= "<div class=\"sterge\"> </div>";
if ($i != mysql_num_rows($intrariPag)-1)
$content .= "<hr />";
else
$content .= "<p style=\"margin: 4px 0; padding: 0;\"> </p>";
}
}
$content .= "<div class=\"paginatie\">";
$content .= $paginatie;
$content .= "</div>";
print $content;
?>
include_once("inc_connect.php");
$query = mysql_query("SELECT * FROM movie ORDER BY ean") or die(mysql_error());
$content = "";
$content .= "<div class=\"content\">";
$paginatie = "";
if (mysql_num_rows($query) > 0 ){
//create pages
$pg = empty($_GET['pg']) ? 1 : $_GET['pg'];
$catePePag = "5"; // no of items per page
$nrIntrari = mysql_num_rows($query);
$rij = mysql_fetch_assoc($query);
$rest = ($nrIntrari % $catePePag);
$nrPag = IntVal($nrIntrari / $catePePag);
$paginatie = "Page: ";
if ($rest <> 0)
$nrPag = $nrPag + 1;
for ($i=1; $i<=$nrPag; $i++) {
if ($i == $pg)
$paginatie .=" <b>".$i."</b> ";
else
$paginatie .= "<a href=\"index.php?&pg=".$i."\">".$i."</a> ";
}
if ((!intval($pg)) or ($pg > $nrPag))
echo "<script>location.href('index.php?&pg=1');</script>";
$content .= "\n<h1>Books</h1>";
$content .= "<div class=\"paginatie\">";
$content .= $paginatie;
$content .= "</div>";
if ($pg == 1)
$inf = 0;
else
$inf = $catePePag * ($pg-1);
$intrariPag = mysql_query("SELECT * FROM movie ORDER BY ean DESC LIMIT " . $inf . ",". $catePePag. "") or die(mysql_error());
//end of pagination
for($i=0; $i<mysql_num_rows($intrariPag); $i++) {
$content .= "\n<dl class=\"formular\">";
$photo='../images/' . $rij["ean"] . ".jpg";
$content .='<img src="' . $photo .'">';
$content .= "<dt><strong>Name</strong></dt><dd>". mysql_result($intrariPag,$i,'naam')."</dd>";
$content .= "<dt><strong>Nevisande</strong></dt><dd>".mysql_result($intrariPag,$i,'actors')."</dd>";
$content .= "<dt><strong>Mozo</strong></dt><dd>".mysql_result($intrariPag,$i,'omschrijving')."</dd>";
$content .= "<dt><strong>download</strong></dt><dd><a href=\"book.php?ean=" .mysql_result($intrariPag,$i,'ean')."\">"
.mysql_result($intrariPag,$i,'zipnaam')."</a></dd>";
$content .= "\n</dl>";
$content .= "<div class=\"sterge\"> </div>";
if ($i != mysql_num_rows($intrariPag)-1)
$content .= "<hr />";
else
$content .= "<p style=\"margin: 4px 0; padding: 0;\"> </p>";
}
}
$content .= "<div class=\"paginatie\">";
$content .= $paginatie;
$content .= "</div>";
print $content;
?>
je doet echo $rij["ean"] op je forloop die op $i loopt..
Haal regel 18 daarom weg en vervang je for lus door een foreach lus zoals dit voorbeeld:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?php
$query = mysql_query("SELECT * FROM movie ORDER BY ean") or die(mysql_error());
//de teller op 0 zetten
$i = 0;
foreach($rij = mysql_fetch_assoc($query))
{
$photo='../images/' . $rij["ean"] . ".jpg";
$content .='<img src="' . $photo .'">';
//de teller heb je nodig.
$i++;
}
?>
$query = mysql_query("SELECT * FROM movie ORDER BY ean") or die(mysql_error());
//de teller op 0 zetten
$i = 0;
foreach($rij = mysql_fetch_assoc($query))
{
$photo='../images/' . $rij["ean"] . ".jpg";
$content .='<img src="' . $photo .'">';
//de teller heb je nodig.
$i++;
}
?>
Gewijzigd op 01/01/1970 01:00:00 door Mark D
Elwin