PHP vraagje

Gestart doorTmeiland20 dec 20124 reacties36 weergaven

5 berichten · pagina 1 van 1

Tmeiland

Lid · Topicstarter

Berichten: 450
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 12 jun 2025

20 dec 2012, 23:57

Hallo,

ik haal een image uit de database maar ik wil dat na elke 2e query dus

komt en als ik dit doe:

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>
<li class="nomargin">

dan werkt mijn slide niet ik moet t zo fixxe

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>

<li class="nomargin">

dus dat wilt zeggen na elke 2e querie de

weergeven zoals dit:

http://pastebin.com/mJBmzqth

code:

[COLOR= #0000BB]<?php
$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM upload"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]))
{[/COLOR]
        
?>

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>
<li class="nomargin">

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]}[/COLOR]
?>

Bedankt, als iemand mij kan helpen sorry kan t niet beter uitleggen

Groet, Tim

Leax

Lid

Berichten: 347
Reputatie: 0
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 23 okt 2022

21 dec 2012, 13:20

Dus je wil dat hij 2x iets uit de database haalt, en dan die zin plaatst &dan weer verder gaat?

Tmeiland

Lid · Topicstarter

Berichten: 450
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 12 jun 2025

21 dec 2012, 17:09

Ja, ik wil bv

Dat die

1e uit db haalt:

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>

2e uit db haalt:

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>

Dan dit:

<li class="nomargin">

1e uit db haalt:

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>

2e uit db haalt:

<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>

Dan dit:

<li class="nomargin">

enzo steeds door..

dus na elke 2e ding die hij uit haalt uit db

dan dit

<li class="nomargin">

dan weer doorgaan 2 uit db en dan weer dit

<li class="nomargin">

etc etc

Hopelijk snappen jullie t nu

Leax

Lid

Berichten: 347
Reputatie: 0
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 23 okt 2022

21 dec 2012, 18:27

Probeer dit eens?

[COLOR= #0000BB]<?php
$aQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM upload"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aQuery[/COLOR][COLOR= #007700]) ) {[/COLOR]
[COLOR= #0000BB]$bQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM upload WHERE id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]);[/COLOR]
?>
<li>
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
</li>
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_int"]is_int[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR]/[COLOR= #0000BB]2[/COLOR][COLOR= #007700])) {[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<li class="nomargin">[/COLOR][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;
}[/COLOR]
?>

Milan

Lid

Berichten: 8.602
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 12 jun 2025

22 dec 2012, 15:28

Zo moet werken:

[COLOR= #0000BB]<?php
 
$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM upload"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]))
{[/COLOR]
        
    ?>

    <li>
    <a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" rel="lightbox-gallery" title="Spackspuitwerk"><img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]locatie[/COLOR][COLOR= #007700]];[/COLOR] ?>" width="200" height="150" alt="" /></a>
    </li>

    [COLOR= #0000BB]<?php[/COLOR]
    
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]%[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]    <li class="nomargin">[/COLOR][COLOR= #007700];
        
    }[/COLOR]
    
    [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;
    
}[/COLOR]

?>

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.