PageRenderTime 44ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/src/beheer/sendaanmelding.php

https://bitbucket.org/jwubs/gratisgolfpolis.nl
PHP | 94 lines | 82 code | 10 blank | 2 comment | 2 complexity | c61ad30443cf3d1fdcd4d6c53993a5c4 MD5 | raw file
    

  1. <?php
    2. 

  2. $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
    3. 

  3. mysql_select_db('gratisgolfpolis', $conn);
    4. 

  4. 

  5. $result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
    6. 

  6. $aantal = mysql_num_rows($result);
    7. 

  7. 

  8. if($aantal==1){
    9. 

  9. 	$row = mysql_fetch_array($result);
    10. 

  10. 	$bid = $row["id"];
    11. 

  11. 	$bname = $row['name'];
    12. 

  12. } else {
    13. 

  13. 	header("Location:login.html");
    14. 

  14. }
    15. 

  15. 

  16. $result = mysql_query("SELECT * FROM aanvragen WHERE aanvraag_id='".$_GET["id"]."'");
    17. 

  17. $row = mysql_fetch_array($result);
    18. 

  18. 

  19. 

  20. $result = mysql_query("SELECT * FROM aanbieders WHERE id ='".$row["aanbieder"]."'");
    21. 

  21. $shop = mysql_fetch_array($result);
    22. 

  22. 

  23. $certnr = $_GET["id"] + 110000;
    24. 

  24. 

  25. $to = $row["email"];
    26. 

  26. $subject = 'uw gratis DIEFSTAL certificaat'; 
    27. 

  27. $random_hash = md5(date('r', time())); 
    28. 

  28. $headers = "From: info@gratis-golfpolis.nl\r\nReply-To: info@gratis-golfpolis.nl";
    29. 

  29. $headers .= "\r\nContent-Type: text/html; charset=\"iso-8859-1\"; boundary=\"PHP-alt-".$random_hash."\""; 
    30. 

  30. ob_start(); //Turn on output buffering
    31. 

  31. 

  32. 

  33. ?>
    34. 

  34. <table width="581" border="0" cellpadding="0" cellspacing="0">
    35. 

  35. 	<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>
    36. 

  36. 	<tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:17px;"><b>CERTIFICAAT<br/>DIEFSTAL-VERZEKERING</b></td></tr>
    37. 

  37.     <tr><td>&nbsp;</td></tr>
    38. 

  38.     <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>
    39. 

  39.     <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>
    40. 

  40.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
    41. 

  41.     <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
    42. 

  42.     of diefstal<BR/>
    43. 

  43.     van de verzekerde golfclub(s) recht op een schadevergoeding in de vorm van<BR/>
    44. 

  44.     een tegoedbon ter besteding bij:</td></tr>
    45. 

  45.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:4px;">&nbsp;</td></tr>
    46. 

  46.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b><?=$shop["bedrijfsnaam"]?></b> te <b><?=$shop["plaats"]?></b></td></tr>
    47. 

  47.     <tr height="30"><td align="center">&nbsp;</td></tr>
    48. 

  48.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"v><b>CERTIFICAATNUMMER</b></td></tr>
    49. 

  49.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HDW.<?=$row["aktie"]?>-<?=$certnr?></td></tr>
    50. 

  50.     <tr><td align="center">&nbsp;</td></tr>
    51. 

  51.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>CERTIFICAATHOUDER</b></td></tr>
    52. 

  52.     <tr><td align="center">
    53. 

  53.     	<table border="0" cellpadding="0" cellspacing="0">
    54. 

  54.         	<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;"><?=$row["voorletters"]?> <?=$row["achternaam"]?></td></tr>
    55. 

  55.             <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;"><?=$row["geboortedag"]?>-<?=$row["geboortemaand"]?>-<?=$row["geboortejaar"]?></td></tr>
    56. 

  56.             <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;"><?=$row["adres"]?> <?=$row["huisnummer"]?></td></tr>
    57. 

  57.             <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;"><?=$row["pccijfers"]?> <?=$row["pcletters"]?> <?=$row["postcode"]?> <?=$row["woonplaats"]?></td></tr>
    58. 

  58.             <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;"><?=$row["email"]?></td></tr>
    59. 

  59.         </table>
    60. 

  60.     </td></tr>
    61. 

  61.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">&nbsp;</td></tr>
    62. 

  62.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VERZEKERD BELANG</b></td></tr>
    63. 

  63.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">De golfclub(s) gekocht bij:</td></tr>
    64. 

  64.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><?=$shop["bedrijfsnaam"]?> te <?=$shop["plaats"]?></td></tr>
    65. 

  65.     <tr><td align="center">
    66. 

  66.     	<table border="0" cellpadding="0" cellspacing="0">
    67. 

  67.         	<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;"><?=$row["kassabon"]?></td></tr>
    68. 

  68.             <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;"><?=$row["aankoopdag"]?>-<?=$row["aankoopmaand"]?>-<?=$row["aankoopjaar"]?></td></tr>
    69. 

  69.             <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 <?=$row["totaalbedrag"]?>,00</td></tr>
    70. 

  70.             <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;"><?=$row["aantalclubs"]?></td></tr>
    71. 

  71.         </table>
    72. 

  72.     </td></tr>
    73. 

  73.     <tr><td align="center">&nbsp;</td></tr>
    74. 

  74.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><b>VOORWAARDEN</b></td></tr>
    75. 

  75.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">GGP-HDW.042011</td></tr>
    76. 

  76.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:5px;">&nbsp;</td></tr>
    77. 

  77.     <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>
    78. 

  78.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:18px;">&nbsp;</td></tr>
    79. 

  79.     <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>
    80. 

  80.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;</td></tr>
    81. 

  81.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Datum afgifte: <?=date("d-m-Y")?></td></tr>
    82. 

  82.     <tr><td align="center"><hr /></td></tr>
    83. 

  83.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;"><b>INTER-GOLF ASSURANTI&Euml;N</b></td></tr>
    84. 

  84.     <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>
    85. 

  85.     <tr><td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:12px;">Email: info@gratis-golfpolis.nl</td></tr>
    86. 

  86. </table>
    87. 

  87. <?
    88. 

  88. //copy current buffer contents into $message variable and delete current output buffer
    89. 

  89. $message = ob_get_clean();
    90. 

  90. //send the email
    91. 

  91. $mail_sent = @mail( $to, $subject, $message, $headers );
    92. 

  92. 

  93. header("Location:index.php?act=aanmeldingen");
    94. 

  94. ?>
    95.