PHP:
1
| <?include ("includes/check.inc.php");include ("../includes/config.inc.php");$query = "SELECT * from tblwoningen WHERE woningID = $HTTP_GET_VARS[id]";$query2 = "SELECT plaatsID, plaatsNaam FROM tblplaatsen";$query3 = "SELECT * FROM tblfotos WHERE woningID = $HTTP_GET_VARS[id]";$query4 = "SELECT * FROM tblomschrijvingen WHERE woningID = $HTTP_GET_VARS[id]";$result = mysql_query($query); $result2 = mysql_query($query2); $result3 = mysql_query($query3); $result4 = mysql_query($query4); ?><table border='0' width='100%' cellspacing='1' cellpadding='2' bgcolor='#000000'> <tr> <td width='100%' background='images/background.gif' align='right' valign='top'><font color="#006276"><b>Navigatie</b><b> - <A HREF='bo-index.php'>Index</A></b><b> - <A HREF='bo-index.php?type=Woningaanbod'>Woningaanbod</A></b><b> - <A HREF='bo-index.php?type=Woningaanbod-edit&id=<?php print ($HTTP_GET_VARS[id]); ?>'>Woning informatie wijzigen</A></b></font></td> </tr></table><br><!-- Woningaanbod Wijzigen --><?phpif ($mysql_fetch = mysql_fetch_array($result)) { do { ?> <form name='woningform' action='bo-index.php' method='post' enctype='multipart/form-data'> <table border='0' width='100%' cellspacing='1' cellpadding='2' bgcolor='#000000'> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='2'><b>Bestaande woning wijzigen</b></td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='2'>&nbsp;</td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Adres</td> <td width='95%' background='images/background.gif' align='left' valign='top'><INPUT size=30 name=adres value='<?php print ($mysql_fetch[woningAdres]); ?>'></td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Plaats</td> <td width='95%' background='images/background.gif' align='left' valign='top'><SELECT name=plaats size='1'><?php if ($mysql_fetch2 = mysql_fetch_array($result2)) { do { if ($mysql_fetch2['plaatsID'] == "$mysql_fetch[plaatsID]") { print ("<OPTION value=$mysql_fetch2[plaatsID] selected"); } else { print ("<OPTION value=$mysql_fetch2[plaatsID]"); } print (">$mysql_fetch2[plaatsNaam]</OPTION>"); } while ($mysql_fetch2 = mysql_fetch_array($result2)); } ?></SELECT> (Als u een nieuwe plaats wilt toevoegen kunt u <A HREF='bo-index.php?type=Plaatsen-add'>hier</A> klikken</td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Postcode</td> <td width='95%' background='images/background.gif' align='left' valign='top'><INPUT size='6' name='postcode' maxlength='6' value='<?php print ($mysql_fetch[woningPostcode]); ?>'></td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Omschrijving</td> <td width='95%' background='images/background.gif' align='left' valign='top'><TEXTAREA name='omschrijving' rows=5 cols=25><?php print ($mysql_fetch[woningKorteOmschrijving]); ?></TEXTAREA></td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Prijs €</td> <td width='95%' background='images/background.gif' align='left' valign='top'><INPUT size=30 name=prijs value='<?php print ($mysql_fetch[woningPrijs]); ?>'> (Prijzen op website worden als volgt getoond: € 345.000 (Fl 760.281)</td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Prijssoort</td> <td width='95%' background='images/background.gif' align='left' valign='top'><SELECT name=woningPrijsSoort> <?php if ($mysql_fetch['woningPrijsSoort'] == "0") { ?><OPTION value=0 selected>k.k.</OPTION> <OPTION value=1>v.o.n.</OPTION> <OPTION value=2>huur p/m</OPTION></SELECT> <?php } elseif ($mysql_fetch['woningPrijsSoort'] == "1") { ?><OPTION value=0>k.k.</OPTION> <OPTION value=1 selected>v.o.n.</OPTION> <OPTION value=2>huur p/m</OPTION></SELECT> <?php } else { ?><OPTION value=0>k.k.</OPTION> <OPTION value=1>v.o.n.</OPTION> <OPTION value=2 selected>huur p/m</OPTION></SELECT><?php } ?> </td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Status</td> <td width='95%' background='images/background.gif' align='left' valign='top'><SELECT name=status> <?php if ($mysql_fetch['woningStatus'] == "0") { ?><OPTION value=0 selected>Nieuw!</OPTION> <OPTION value=1>Geen</OPTION> <OPTION value=2>Optie</OPTION> <OPTION value=3>Verkocht</OPTION> <OPTION value=4>Toekomstig</OPTION></SELECT> <?php } elseif ($mysql_fetch['woningStatus'] == "1") { ?><OPTION value=0>Nieuw!</OPTION> <OPTION value=1 selected>Geen</OPTION> <OPTION value=2>Optie</OPTION> <OPTION value=3>Verkocht</OPTION> <OPTION value=4>Toekomstig</OPTION></SELECT> <?php } elseif ($mysql_fetch['woningStatus'] == "2") { ?><OPTION value=0>Nieuw!</OPTION> <OPTION value=1>Geen</OPTION> <OPTION value=2 selected>Optie</OPTION> <OPTION value=3>Verkocht</OPTION> <OPTION value=4>Toekomstig</OPTION></SELECT> <?php } elseif ($mysql_fetch['woningStatus'] == "3") { ?><OPTION value=0>Nieuw!</OPTION> <OPTION value=1>Geen</OPTION> <OPTION value=2>Optie</OPTION> <OPTION value=3 selected>Verkocht</OPTION> <OPTION value=4>Toekomstig</OPTION></SELECT> <?php } else { ?><OPTION value=0>Nieuw!</OPTION> <OPTION value=1>Geen</OPTION> <OPTION value=2>Optie</OPTION> <OPTION value=3>Verkocht</OPTION> <OPTION value=4 selected>Toekomstig</OPTION></SELECT><?php } ?> </td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Woningsoort</td> <td width='95%' background='images/background.gif' align='left' valign='top'><SELECT name=woningSoort> <?php if ($mysql_fetch['woningSoort'] == "0") { ?><OPTION value=0 selected>Woning</OPTION> <OPTION value=1>Bedrijf</OPTION> <OPTION value=2>Nieuwbouw</OPTION> <?php } elseif ($mysql_fetch['woningSoort'] == "1") { ?><OPTION value=0>Woning</OPTION> <OPTION value=1 selected>Bedrijf</OPTION> <OPTION value=2>Nieuwbouw</OPTION> <?php } else { ?><OPTION value=0>Woning</OPTION> <OPTION value=1>Bedrijf</OPTION> <OPTION value=2 selected>Nieuwbouw</OPTION></SELECT><?php } ?> </SELECT> </td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'>Datum</td> <td width='95%' background='images/background.gif' align='left' valign='top'><INPUT size=30 name=datum maxlength=10 value='<?php print ($mysql_fetch[Datum]); ?>''></td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'><b>&nbsp;</b></td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'><b>Omschrijvingen</b></td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'><b>&nbsp;</b></td> </tr> <?php $numbervar = 0; // * // DIT VOLGENDE STUK VOERT HIJ NIET UIT ZODRA QUERY 3 FOTO'S ALS RESULTAAT HEEFT!!!! // * if ($mysql_fetch4 = mysql_fetch_array($result4)) { do { $numbervar ++; print ("</tr><td width='5%' background='images/background.gif' align='left' valign='center'>"); print ("<br>Kop" . $numbervar); print ("</td><td width='25%' background='images/background.gif' align='left' valign='top'>Kop tekst<br><INPUT type='text' size='30' name='extrakop" . $numbervar . "' value='$mysql_fetch4[omschrijvingKop]'><br><br>Omschrijving<br><TEXTAREA name='extraomschrijving" . $numbervar . "' rows='5' cols='25'>"); print("$mysql_fetch4[omschrijvingTekst]</TEXTAREA>"); print("<br><input type='checkbox' name='omschrijving"); print("$numbervar"); print ("del' value='$mysql_fetch4[omschrijvingID]'>Omschrijving verwijderen</td></tr>"); } while ($mysql_fetch4 = mysql_fetch_array($result4)); } $countresult = $looptill; $count = 2 + $numbervar; while ($count <= $countresult) { ?> <tr> <td width='5%' background='images/background.gif' align='left' valign='top'>Kop <?php print ($count); ?></td> <td width='25%' background='images/background.gif' align='left' valign='top'>Kop tekst<br><INPUT type='text' size='30' name='extrakop<?php print ($numbervar); ?>' value=''><br><br>Omschrijving:<BR><TEXTAREA name='extraomschrijving<?php print ($count); ?>' rows='3' cols='25'></TEXTAREA> </tr> <?php $count ++; } ?> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'><b>&nbsp;</b></td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'><b>Foto's</b> (Om een bestaande foto te vervangen hoeft u alleen maar een nieuw bestand te openen door op bladeren te klikken)</td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'>&nbsp;</td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'> <?php if ($mysql_fetch['woningFotoKlein'] != "") { print ("[img]'../show_thumbnail.php?id=$HTTP_GET_VARS[id]&cache=$nocache'[/img]<br>"); } ?> Kleine foto</td> <td width='25%' background='images/background.gif' align='left' valign='top'><INPUT type='file' size='30' name='thumbnail'> <?php if ($mysql_fetch['woningFotoKlein'] != "") { print ("<br><input type='checkbox' name='thumbnaildel' value='ON'>Geen foto gebruiken"); } ?> </td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center'> <?php if ($mysql_fetch['woningFotoGroot'] != "") { print ("[img]'../show_largepic.php?id=$HTTP_GET_VARS[id]&cache=$nocache'[/img]<br>"); } ?> Grote foto</td> <td width='25%' background='images/background.gif' align='left' valign='top'><INPUT type='file' size='30' name='grotefoto'> <?php if ($mysql_fetch['woningFotoGroot'] != "") { print ("<br><input type='checkbox' name='grotefotodel' value='ON'>Geen foto gebruiken"); } ?> </td> </tr> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='2'>&nbsp;</td> </tr> <?php $numbervar = 0; if ($mysql_fetch3 = mysql_fetch_array($result3)) { do { $numbervar ++; print ("<td width='5%' background='images/background.gif' align='left' valign='center'>"); print ("[img]'../show_picture.php?id=$mysql_fetch3[fotoID]&cache=$nocache'[/img]"); print ("<br>Extra foto$numbervar</td><td width='25%' background='images/background.gif' align='left' valign='top'><INPUT type='file' size='30' name='extrafoto$numbervar'><br><br>Naam<br><INPUT type='text' size='30' name='extrafoto"); print("$numbervar"); print("naam' value='$mysql_fetch3[fotoNaam]'><br><input type='checkbox' name='extrafoto"); print("$numbervar"); print ("del' value='$mysql_fetch3[fotoID]'>Geen foto gebruiken</td></tr>"); } while ($mysql_fetch3 = mysql_fetch_array($result3)); } $countresult = $looptill; $count = 1 + $numbervar; while ($count <= $countresult) { print ("<tr><td width='5%' background='images/background.gif' align='left' valign='center'>Extra foto$count</td><td width='25%' background='images/background.gif' align='left' valign='top'><INPUT type='file' size='30' name='extrafoto$count'><br><br>Naam<br><INPUT type='text' size='30' name='extrafoto"); print ("$count"); print ("naam"); print ("'></td></tr>"); $count ++; } ?> <tr> <td width='100%' background='images/background.gif' align='left' valign='top' colspan='4'><b>&nbsp;</b></td> </tr> <tr> <td width='5%' background='images/background.gif' align='left' valign='center' colspan='2'><INPUT type=submit value='Woning Wijzigen' name=Opslaan></td> </tr> </table> <input type='hidden' name='type' value='Woningaanbod-edit-submit'> <input type='hidden' name='id' value='<?php print ("HTTP_GET_VARS[id]"); ?>'> </form> <!-- Woningaanbod Wijzigen --><?php } while ($mysql_fetch = mysql_fetch_array($result));}?> |
Het probleem zit hem erin dat zodra er foto's zijn van query 3 hij het verrekte om query 4 te gebruiken.
Het vage hieraan is dat query 4 voor query 3 gebruikt wordt dus eigenlijk zou query 3 nooit query4 kunnen verhinderen.
Het maakt eigenlijk niet uit wat je bewuste geest doet, omdat je onderbewuste automatisch precies dat doet wat het moet doen