/src/beheer/beheer_sponsorpage.php
PHP | 536 lines | 521 code | 15 blank | 0 comment | 20 complexity | 71124deefca1ca671d4e33cf62e643ac MD5 | raw file
- <?php
- $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
- mysql_select_db('gratisgolfpolis', $conn);
- $result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
- $aantal = mysql_num_rows($result);
- if($aantal==1){
- $row = mysql_fetch_array($result);
- $bid = $row["id"];
- $bname = $row['name'];
- } else {
- header("Location:login.html");
- }
- $sponsor01 = "0";
- $sponsor02 = "0";
- $sponsor03 = "0";
- $sponsor04 = "0";
- $sponsor05 = "0";
- $sponsor06 = "0";
- $sponsor07 = "0";
- $sponsor08 = "0";
- $sponsor09 = "0";
-
-
- $logo01 = "nognietgevuld.jpg";
- $logo02 = "nognietgevuld.jpg";
- $logo03 = "nognietgevuld.jpg";
- $logo04 = "nognietgevuld.jpg";
- $logo05 = "nognietgevuld.jpg";
- $logo06 = "nognietgevuld.jpg";
- $logo07 = "nognietgevuld.jpg";
- $logo08 = "nognietgevuld.jpg";
- $logo09 = "nognietgevuld.jpg";
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- $result = mysql_query("SELECT * FROM sponsorpage");
-
-
- while($row = mysql_fetch_array($result))
- {
- $sponsor01 = $row["sponsor_01"];
- $sponsor02 = $row["sponsor_02"];
- $sponsor03 = $row["sponsor_03"];
- $sponsor04 = $row["sponsor_04"];
- $sponsor05 = $row["sponsor_05"];
- $sponsor06 = $row["sponsor_06"];
- $sponsor07 = $row["sponsor_07"];
- $sponsor08 = $row["sponsor_08"];
- $sponsor09 = $row["sponsor_09"];
-
- if(strlen($row["logo_01"]) > 3 ) $logo01 = $row["logo_01"];
- if(strlen($row["logo_02"]) > 3 ) $logo02 = $row["logo_02"];
- if(strlen($row["logo_03"]) > 3 ) $logo03 = $row["logo_03"];
- if(strlen($row["logo_04"]) > 3 ) $logo04 = $row["logo_04"];
- if(strlen($row["logo_05"]) > 3 ) $logo05 = $row["logo_05"];
- if(strlen($row["logo_06"]) > 3 ) $logo06 = $row["logo_06"];
- if(strlen($row["logo_07"]) > 3 ) $logo07 = $row["logo_07"];
- if(strlen($row["logo_08"]) > 3 ) $logo08 = $row["logo_08"];
- if(strlen($row["logo_09"]) > 3 ) $logo09 = $row["logo_09"];
- }
-
- ?>
-
- <table border="1" bordercolor="#000000" cellpadding="25" cellspacing="25">
- <tr>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor01" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor01."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo01 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen" o/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor01edit" style="display:block;">
- <form name="frmsponsor01" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="1">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor01){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo01 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor01.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=1'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor02" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor02."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo02 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor02edit" style="display:block;">
- <form name="frmsponsor02" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="2">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor02){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo02 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor02.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=2'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor03" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor03."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo03 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor03edit" style="display:block;">
- <form name="frmsponsor03" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="3">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor03){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo03 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor03.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=3'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- </tr>
- <tr>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor04" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor04."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo04 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor04edit" style="display:block;">
- <form name="frmsponsor04" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="4">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor04){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo04 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor04.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=4'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor05" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor05."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo05 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor05edit" style="display:block;">
- <form name="frmsponsor05" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="5">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor05){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo05 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor05.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=5'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor06" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor06."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo06 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor06edit" style="display:block;">
- <form name="frmsponsor06" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="6">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor06){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo06 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor06.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=6'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- </tr>
- <tr>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor07" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor07."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo07 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor07edit" style="display:block;">
- <form name="frmsponsor07" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="7">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor07){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo07 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor07.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=7'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor08" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor08."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo08 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor08edit" style="display:block;">
- <form name="frmsponsor08" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="8">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor08){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo08 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor08.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=8'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- <td width="190" height="190" bgcolor="#FFFFFF">
- <div id="sponsor09" style="display:none;">
- <?php
- $sponsornaam = "[ leeg ]";
- $sponsordetails = mysql_query("SELECT * FROM aanbieders where id='".$sponsor09."'");
- while($sponsor = mysql_fetch_array($sponsordetails))
- {
- $sponsornaam = $sponsor["name"];
- }
- ?>
- <table width="190" height="190">
- <tr valign="top" height="10"><td align="center"><?= $sponsornaam ?></td></tr>
- <tr valign="top"><td align="center"><img src="/img/<?= $logo09 ?>" border="0"/></td></tr>
- <tr valign="top" height="10"><td align="center"><input type="button" value="wijzigen"/> <input type="button" value="verwijder"/></td></tr>
- </table>
- </div>
- <div id="sponsor09edit" style="display:block;">
- <form name="frmsponsor09" action="changesponsorpage.php" method="post" enctype="multipart/form-data">
- <input type="hidden" name="sponsorblock" value="9">
- <table width="190" height="190">
- <tr valign="top" height="30">
- <td>Sponsor</td>
- <td>
- <select name="sponsorselect">
- <option value="0">niet geselecteerd
- <?php
- $sponsors = mysql_query("SELECT * FROM aanbieders");
- while($sponsor = mysql_fetch_array($sponsors))
- {
- ?>
- <option value="<?= $sponsor["id"] ?>" <?php if($sponsor["id"]==$sponsor09){ ?> selected <?php } ?>><?= $sponsor["name"] ?>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr valign="top">
- <td align="center" colspan="2">Afbeelding<br />
- <img src="/img/<?= $logo09 ?>" border="0"/><br/><br/>
- <input type="checkbox" name="editsponsorlogo" value="ja" onclick="document.frmsponsor09.sponsorlogo.disabled=!this.checked;"/>
- <input type="file" name="sponsorlogo" size="5" disabled/>
- </td>
- </tr>
- <tr valign="bottom" height="30">
- <td colspan="2" align="center"><input type="submit" value="opslaan"><input type="button" value="verwijderen" onClick="location.href='removefromsponsorpage.php?sponsorblock=9'"/></td>
- </tr>
- </table>
- </form>
- </div>
- </td>
- </tr>
- </table>