/src/page_5.php
PHP | 236 lines | 213 code | 19 blank | 4 comment | 3 complexity | 83853ad943526d7f997ebf933738e53c MD5 | raw file
- <?php
- $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
- mysql_select_db('gratisgolfpolis', $conn);
-
- $result = mysql_query("SELECT * FROM akties WHERE name LIKE ('".$_POST["id"]."') AND entrycode LIKE ('".$_POST["entry"]."')");
-
- if(mysql_num_rows($result) == 0) {
- header("Location: index.php");
- exit;
- } else {
- $row = mysql_fetch_array($result);
- $shop = $row["aanbieder"];
-
- $result = mysql_query("SELECT * FROM aanbieders WHERE id ='".$shop."'");
- $row = mysql_fetch_array($result);
- $sql = "insert into aanvragen (
- aanbieder
- , aktie
- , achternaam
- , voorletters
- , geslacht
- , geboortedag
- , geboortemaand
- , geboortejaar
- , adres
- , huisnummer
- , postcode
- , woonplaats
- , telefoon
- , email
- , aankoopdag
- , aankoopmaand
- , aankoopjaar
- , aantalclubs
- , totaalbedrag
- , kassabon
- , aanvraagdatum
- ) values (
- ".$shop."
- , '".$_POST["id"]."'
- , '".$_POST["achternaam"]."'
- , '".$_POST["voorletters"]."'
- , '".$_POST["geslacht"]."'
- , '".$_POST["geboorte_dag"]."'
- , '".$_POST["geboorte_maand"]."'
- , '".$_POST["geboorte_jaar"]."'
- , '".$_POST["adres"]."'
- , '".$_POST["huisnummer"]."'
- , '".$_POST["pccijfers"]." ".$_POST["pcletters"]."'
- , '".$_POST["woonplaats"]."'
- , '".$_POST["telefoon_prive"]."'
- , '".$_POST["emailadres"]."'
- , '".$_POST["aankoopdatum_dag"]."'
- , '".$_POST["aankoopdatum_maand"]."'
- , '".$_POST["aankoopdatum_jaar"]."'
- , '".$_POST["gekochte_clubs"]."'
- , '".$_POST["totaalbedrag"]."'
- , '".$_POST["kassabon_nummer"]."'
- , '".date("d-m-Y")."'
- )";
-
- mysql_query($sql);
- $resultid = mysql_query("SELECT max(aanvraag_id) as maxid FROM aanvragen");
- $rowid = mysql_fetch_array($resultid);
- $certnr = $rowid["maxid"] + 110000;
- ?>
- <?php
- $to = $_POST["emailadres"];
- $subject = 'uw gratis DIEFSTAL certificaat';
- $random_hash = md5(date('r', time()));
- $headers = "From: info@gratis-golfpolis.nl\r\nReply-To: info@gratis-golfpolis.nl\r\nBcc: kopie@gratisgolfpolis.nl";
- $headers .= "\r\nContent-Type: text/html; charset=\"iso-8859-1\"; boundary=\"PHP-alt-".$random_hash."\"";
- ob_start(); //Turn on output buffering
- ?>
- <table width="581" border="0" cellpadding="0" cellspacing="0">
- <tr><td><img src="http://www.gratis-golfpolis.nl/images/logo_golfpolis_mail.jpg" alt="Logo gratis-golfpolis.nl" width="581" height="110" /></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:17px;"><b>CERTIFICAAT<br/>DIEFSTAL-VERZEKERING</b></td></tr>
- <tr><td> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>BEWAAR DIT CERTIFICAAT EN UW KASSABON GOED!!</strong></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>IN GEVAL VAN SCHADE DIENT U DEZE TE OVERLEGGEN</strong></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Met inachtneming van de van toepassing zijnde voorwaarden geeft dit certificaat u bij verlies
- of diefstal<BR/>
- van de verzekerde golfclub(s) recht op een schadevergoeding in de vorm van<BR/>
- een tegoedbon ter besteding bij:</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:4px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b><?=$row["bedrijfsnaam"]?></b> te <b><?=$row["plaats"]?></b></td></tr>
- <tr height="30"><td align="center"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"v><b>CERTIFICAATNUMMER</b></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HDW.<?=$_POST["id"]?>-<?=$certnr?></td></tr>
- <tr><td align="center"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>CERTIFICAATHOUDER</b></td></tr>
- <tr><td align="center">
- <table border="0" cellpadding="0" cellspacing="0">
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Voorl. + Naam</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["voorletters"]?> <?=$_POST["achternaam"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Geboortedatum</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["geboorte_dag"]?>-<?=$_POST["geboorte_maand"]?>-<?=$_POST["geboorte_jaar"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Adres</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["adres"]?> <?=$_POST["huisnummer"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Postcode + Plaats</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["pccijfers"]?> <?=$_POST["pcletters"]?> <?=$_POST["postcode"]?> <?=$_POST["woonplaats"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">E-mail adres</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["emailadres"]?></td></tr>
- </table>
- </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VERZEKERD BELANG</b></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">De golfclub(s) gekocht bij:</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$row["bedrijfsnaam"]?> te <?=$row["plaats"]?></td></tr>
- <tr><td align="center">
- <table border="0" cellpadding="0" cellspacing="0">
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Kassabonnr.</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["kassabon_nummer"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Aankoopdatum</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["aankoopdatum_dag"]?>-<?=$_POST["aankoopdatum_maand"]?>-<?=$_POST["aankoopdatum_jaar"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Aankoopbedrag</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">EUR <?=$_POST["totaalbedrag"]?>,00</td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Aantal golfclubs</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["gekochte_clubs"]?></td></tr>
- </table>
- </td></tr>
- <tr><td align="center"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VOORWAARDEN</b></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HDW.042011</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:5px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">(u kunt deze voorwaarden downloaden op de website <a href="http://www.gratis-golfpolis.nl/GRATIS-GOLFPOLIS VOORWAARDEN GGP-HDW.042011.pdf">www.gratis-golfpolis.nl</a>)</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:18px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Dit certificaat vervangt alle eventueel eerder afgegeven certificaten met hetzelfde nummer.</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Datum afgifte: <?=date("d-m-Y")?></td></tr>
- <tr><td align="center"><hr /></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><b>INTER-GOLF ASSURANTIËN</b></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Postbus 5, 3740 AA Baarn Tel.: 0900 - 123 GOLF (=> 0900 - 123 4653 / 0,05ct. p.min.)</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Email: info@gratis-golfpolis.nl</td></tr>
- </table>
- <?
- //copy current buffer contents into $message variable and delete current output buffer
- $message = ob_get_clean();
- //send the email
- $mail_sent = @mail( $to, $subject, $message, $headers );
- ?>
- <?php
- $to = $_POST["emailadres"];
- $subject = 'uw gratis HOLE-IN-ONE certificaat';
- $random_hash = md5(date('r', time()));
- $headers = "From: info@gratis-golfpolis.nl\r\nReply-To: info@gratis-golfpolis.nl\r\nBcc: kopie@gratisgolfpolis.nl";
- $headers .= "\r\nContent-Type: text/html; charset=\"iso-8859-1\"; boundary=\"PHP-alt-".$random_hash."\"";
- ob_start(); //Turn on output buffering
- ?>
- <table width="581" border="0" cellpadding="0" cellspacing="0">
- <tr><td><img src="http://www.gratis-golfpolis.nl/images/logo_golfpolis_mail.jpg" alt="Logo gratis-golfpolis.nl" width="581" height="110" /></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:17px;"><b>HOLE-IN-ONE<BR/>CERTIFICAAT</b></td></tr>
- <tr><td> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>BEWAAR DIT CERTIFICAAT EN UW KASSABON GOED!!</strong></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>BIJ EEN HOLE-IN-ONE DIENT U DEZE TE OVERLEGGEN</strong></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Met inachtneming van de van toepassing zijnde voorwaarden geeft dit certificaat bij het<br/>
- slaan van een Hole-in-One recht op een tegoedbon ter besteding bij:</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:4px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b><?=$row["bedrijfsnaam"]?></b> te <b><?=$row["plaats"]?></b></td></tr>
- <tr height="30"><td align="center"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>CERTIFICAATNUMMER</strong></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HIO.<?=$_POST["id"]?>-<?=$certnr?></td></tr>
- <tr><td align="center"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>WAARDE TEGOEDBON</strong></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">EUR <?=$row["hiobedrag"]?></td></tr>
- <tr><td align="center"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>CERTIFICAATHOUDER</strong></td></tr>
- <tr><td align="center">
- <table border="0" cellpadding="0" cellspacing="0">
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Voorl. + Naam</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["voorletters"]?> <?=$_POST["achternaam"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Geboortedatum</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["geboorte_dag"]?>-<?=$_POST["geboorte_maand"]?>-<?=$_POST["geboorte_jaar"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Adres</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["adres"]?> <?=$_POST["huisnummer"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Postcode + Plaats</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["pccijfers"]?> <?=$_POST["pcletters"]?> <?=$_POST["postcode"]?> <?=$_POST["woonplaats"]?></td></tr>
- <tr height="20"><td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">E-mail adres</td><td style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> : </td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["emailadres"]?></td></tr>
- </table>
- </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VOORWAARDEN</b></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HIO.042011</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:5px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">(u kunt deze voorwaarden downloaden op de website <a href="http://www.gratis-golfpolis.nl/GRATIS-GOLFPOLIS VOORWAARDEN GGP-HIO.042011.pdf">www.gratis-golfpolis.nl</a>)</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"> </td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Datum afgifte: <?=date("d-m-Y")?></td></tr>
- <tr><td align="center"><hr /></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><b>INTER-GOLF ASSURANTIËN</b></td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Postbus 5, 3740 AA Baarn Tel.: 0900 - 123 GOLF (=> 0900 - 123 4653 / 0,05ct. p.min.)</td></tr>
- <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Email: info@gratis-golfpolis.nl</td></tr>
- </table>
- <?
- //copy current buffer contents into $message variable and delete current output buffer
- $message = ob_get_clean();
- //send the email
- $mail_sent = @mail( $to, $subject, $message, $headers );
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>GRATIS-GOLFPOLIS.nl</title>
- <link href="golfpolis_styling.css" rel="stylesheet" type="text/css" />
- </head>
- <body>
- <table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr>
- <td colspan="3"><img src="images/logo_golfpolis.jpg" alt="Logo gratis-golfpolis.nl" width="780" height="110" /><br />
- <br /></td>
- </tr>
- <tr>
- <td width="130"> </td>
- <td width="520" class="Frame"><?= $row["bedankpagina"] ?></td>
- <td width="130"> </td>
- </tr>
- <tr>
- <td colspan="3" align="center"><input type="button" value="Exit" onClick="location.href='/'"/><br/> </td>
- </tr>
- <tr><td> </td></tr>
- <tr>
- <td colspan="3" align="center"><a href="contact.php" style="color:#000000;">contact</a> | <a href="privacy.php" style="color:#000000;">privacybeleid</a> | <a href="disclaimer.php" style="color:#000000;">disclaimer</a></td>
- </tr>
- <tr>
- <td colspan="3" class="Footer">© 01-2013: INTER-GOLF ASSURANTIEN</td>
- </tr>
- </table>
- </body>
- </html>
- <?php
- }
- ?>