PageRenderTime 42ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/src/page_5.php

https://bitbucket.org/jwubs/gratisgolfpolis.nl
PHP | 236 lines | 213 code | 19 blank | 4 comment | 3 complexity | 83853ad943526d7f997ebf933738e53c MD5 | raw file
  1. <?php
  2. $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
  3. mysql_select_db('gratisgolfpolis', $conn);
  4. $result = mysql_query("SELECT * FROM akties WHERE name LIKE ('".$_POST["id"]."') AND entrycode LIKE ('".$_POST["entry"]."')");
  5. if(mysql_num_rows($result) == 0) {
  6. header("Location: index.php");
  7. exit;
  8. } else {
  9. $row = mysql_fetch_array($result);
  10. $shop = $row["aanbieder"];
  11. $result = mysql_query("SELECT * FROM aanbieders WHERE id ='".$shop."'");
  12. $row = mysql_fetch_array($result);
  13. $sql = "insert into aanvragen (
  14. aanbieder
  15. , aktie
  16. , achternaam
  17. , voorletters
  18. , geslacht
  19. , geboortedag
  20. , geboortemaand
  21. , geboortejaar
  22. , adres
  23. , huisnummer
  24. , postcode
  25. , woonplaats
  26. , telefoon
  27. , email
  28. , aankoopdag
  29. , aankoopmaand
  30. , aankoopjaar
  31. , aantalclubs
  32. , totaalbedrag
  33. , kassabon
  34. , aanvraagdatum
  35. ) values (
  36. ".$shop."
  37. , '".$_POST["id"]."'
  38. , '".$_POST["achternaam"]."'
  39. , '".$_POST["voorletters"]."'
  40. , '".$_POST["geslacht"]."'
  41. , '".$_POST["geboorte_dag"]."'
  42. , '".$_POST["geboorte_maand"]."'
  43. , '".$_POST["geboorte_jaar"]."'
  44. , '".$_POST["adres"]."'
  45. , '".$_POST["huisnummer"]."'
  46. , '".$_POST["pccijfers"]." ".$_POST["pcletters"]."'
  47. , '".$_POST["woonplaats"]."'
  48. , '".$_POST["telefoon_prive"]."'
  49. , '".$_POST["emailadres"]."'
  50. , '".$_POST["aankoopdatum_dag"]."'
  51. , '".$_POST["aankoopdatum_maand"]."'
  52. , '".$_POST["aankoopdatum_jaar"]."'
  53. , '".$_POST["gekochte_clubs"]."'
  54. , '".$_POST["totaalbedrag"]."'
  55. , '".$_POST["kassabon_nummer"]."'
  56. , '".date("d-m-Y")."'
  57. )";
  58. mysql_query($sql);
  59. $resultid = mysql_query("SELECT max(aanvraag_id) as maxid FROM aanvragen");
  60. $rowid = mysql_fetch_array($resultid);
  61. $certnr = $rowid["maxid"] + 110000;
  62. ?>
  63. <?php
  64. $to = $_POST["emailadres"];
  65. $subject = 'uw gratis DIEFSTAL certificaat';
  66. $random_hash = md5(date('r', time()));
  67. $headers = "From: info@gratis-golfpolis.nl\r\nReply-To: info@gratis-golfpolis.nl\r\nBcc: kopie@gratisgolfpolis.nl";
  68. $headers .= "\r\nContent-Type: text/html; charset=\"iso-8859-1\"; boundary=\"PHP-alt-".$random_hash."\"";
  69. ob_start(); //Turn on output buffering
  70. ?>
  71. <table width="581" border="0" cellpadding="0" cellspacing="0">
  72. <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>
  73. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:17px;"><b>CERTIFICAAT<br/>DIEFSTAL-VERZEKERING</b></td></tr>
  74. <tr><td>&nbsp;</td></tr>
  75. <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>
  76. <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>
  77. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
  78. <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
  79. of diefstal<BR/>
  80. van de verzekerde golfclub(s) recht op een schadevergoeding in de vorm van<BR/>
  81. een tegoedbon ter besteding bij:</td></tr>
  82. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:4px;">&nbsp;</td></tr>
  83. <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>
  84. <tr height="30"><td align="center">&nbsp;</td></tr>
  85. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"v><b>CERTIFICAATNUMMER</b></td></tr>
  86. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HDW.<?=$_POST["id"]?>-<?=$certnr?></td></tr>
  87. <tr><td align="center">&nbsp;</td></tr>
  88. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>CERTIFICAATHOUDER</b></td></tr>
  89. <tr><td align="center">
  90. <table border="0" cellpadding="0" cellspacing="0">
  91. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["voorletters"]?> <?=$_POST["achternaam"]?></td></tr>
  92. <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;">&nbsp;:&nbsp;&nbsp;</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>
  93. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["adres"]?> <?=$_POST["huisnummer"]?></td></tr>
  94. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["pccijfers"]?> <?=$_POST["pcletters"]?> <?=$_POST["postcode"]?> <?=$_POST["woonplaats"]?></td></tr>
  95. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["emailadres"]?></td></tr>
  96. </table>
  97. </td></tr>
  98. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">&nbsp;</td></tr>
  99. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VERZEKERD BELANG</b></td></tr>
  100. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">De golfclub(s) gekocht bij:</td></tr>
  101. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$row["bedrijfsnaam"]?> te <?=$row["plaats"]?></td></tr>
  102. <tr><td align="center">
  103. <table border="0" cellpadding="0" cellspacing="0">
  104. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["kassabon_nummer"]?></td></tr>
  105. <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;">&nbsp;:&nbsp;&nbsp;</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>
  106. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">EUR <?=$_POST["totaalbedrag"]?>,00</td></tr>
  107. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["gekochte_clubs"]?></td></tr>
  108. </table>
  109. </td></tr>
  110. <tr><td align="center">&nbsp;</td></tr>
  111. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VOORWAARDEN</b></td></tr>
  112. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HDW.042011</td></tr>
  113. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:5px;">&nbsp;</td></tr>
  114. <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>
  115. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:18px;">&nbsp;</td></tr>
  116. <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>
  117. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
  118. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Datum afgifte: <?=date("d-m-Y")?></td></tr>
  119. <tr><td align="center"><hr /></td></tr>
  120. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><b>INTER-GOLF ASSURANTI&Euml;N</b></td></tr>
  121. <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>
  122. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Email: info@gratis-golfpolis.nl</td></tr>
  123. </table>
  124. <?
  125. //copy current buffer contents into $message variable and delete current output buffer
  126. $message = ob_get_clean();
  127. //send the email
  128. $mail_sent = @mail( $to, $subject, $message, $headers );
  129. ?>
  130. <?php
  131. $to = $_POST["emailadres"];
  132. $subject = 'uw gratis HOLE-IN-ONE certificaat';
  133. $random_hash = md5(date('r', time()));
  134. $headers = "From: info@gratis-golfpolis.nl\r\nReply-To: info@gratis-golfpolis.nl\r\nBcc: kopie@gratisgolfpolis.nl";
  135. $headers .= "\r\nContent-Type: text/html; charset=\"iso-8859-1\"; boundary=\"PHP-alt-".$random_hash."\"";
  136. ob_start(); //Turn on output buffering
  137. ?>
  138. <table width="581" border="0" cellpadding="0" cellspacing="0">
  139. <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>
  140. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:17px;"><b>HOLE-IN-ONE<BR/>CERTIFICAAT</b></td></tr>
  141. <tr><td>&nbsp;</td></tr>
  142. <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>
  143. <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>
  144. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
  145. <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/>
  146. slaan van een Hole-in-One recht op een tegoedbon ter besteding bij:</td></tr>
  147. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:4px;">&nbsp;</td></tr>
  148. <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>
  149. <tr height="30"><td align="center">&nbsp;</td></tr>
  150. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>CERTIFICAATNUMMER</strong></td></tr>
  151. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HIO.<?=$_POST["id"]?>-<?=$certnr?></td></tr>
  152. <tr><td align="center">&nbsp;</td></tr>
  153. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>WAARDE TEGOEDBON</strong></td></tr>
  154. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">EUR <?=$row["hiobedrag"]?></td></tr>
  155. <tr><td align="center">&nbsp;</td></tr>
  156. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>CERTIFICAATHOUDER</strong></td></tr>
  157. <tr><td align="center">
  158. <table border="0" cellpadding="0" cellspacing="0">
  159. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["voorletters"]?> <?=$_POST["achternaam"]?></td></tr>
  160. <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;">&nbsp;:&nbsp;&nbsp;</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>
  161. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["adres"]?> <?=$_POST["huisnummer"]?></td></tr>
  162. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["pccijfers"]?> <?=$_POST["pcletters"]?> <?=$_POST["postcode"]?> <?=$_POST["woonplaats"]?></td></tr>
  163. <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;">&nbsp;:&nbsp;&nbsp;</td><td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$_POST["emailadres"]?></td></tr>
  164. </table>
  165. </td></tr>
  166. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
  167. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VOORWAARDEN</b></td></tr>
  168. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HIO.042011</td></tr>
  169. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:5px;">&nbsp;</td></tr>
  170. <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>
  171. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
  172. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Datum afgifte: <?=date("d-m-Y")?></td></tr>
  173. <tr><td align="center"><hr /></td></tr>
  174. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><b>INTER-GOLF ASSURANTI&Euml;N</b></td></tr>
  175. <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>
  176. <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Email: info@gratis-golfpolis.nl</td></tr>
  177. </table>
  178. <?
  179. //copy current buffer contents into $message variable and delete current output buffer
  180. $message = ob_get_clean();
  181. //send the email
  182. $mail_sent = @mail( $to, $subject, $message, $headers );
  183. ?>
  184. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  185. <html xmlns="http://www.w3.org/1999/xhtml">
  186. <head>
  187. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  188. <title>GRATIS-GOLFPOLIS.nl</title>
  189. <link href="golfpolis_styling.css" rel="stylesheet" type="text/css" />
  190. </head>
  191. <body>
  192. <table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
  193. <tr>
  194. <td colspan="3"><img src="images/logo_golfpolis.jpg" alt="Logo gratis-golfpolis.nl" width="780" height="110" /><br />
  195. <br /></td>
  196. </tr>
  197. <tr>
  198. <td width="130">&nbsp;</td>
  199. <td width="520" class="Frame"><?= $row["bedankpagina"] ?></td>
  200. <td width="130">&nbsp;</td>
  201. </tr>
  202. <tr>
  203. <td colspan="3" align="center"><input type="button" value="Exit" onClick="location.href='/'"/><br/>&nbsp;</td>
  204. </tr>
  205. <tr><td>&nbsp;</td></tr>
  206. <tr>
  207. <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>
  208. </tr>
  209. <tr>
  210. <td colspan="3" class="Footer">&copy; 01-2013: INTER-GOLF ASSURANTIEN</td>
  211. </tr>
  212. </table>
  213. </body>
  214. </html>
  215. <?php
  216. }
  217. ?>