Mailing - Forum

Willem Jan Z

07-05-2005 14:45

Ja van die query wist ik niet zeker of het zo werkte...
Anders definieer je de variabale eerst nog... Is ook wat overzichtelijker

Dus:
<?
$id = $_GET['id'];
$sql = "SELECT email FROM dvdreacties WHERE id = $id AND mailing = 1";
$result = mysql_query($sql) or die(mysql_error());
?>

En dat haakje teveel achter mail was typfoutje...

?

Onbekende gebruiker

07-05-2005 14:47

Dit heb ik er uiteindelijk van gemaakt maar het werkt niet

<?php
include ("test.php");
//datum en tijd
$datum = date("d/m/Y");
$tijd = date("H:i");

if ($_POST['Submit']) {
$bericht=htmlspecialchars($_POST['bericht'],ENT_QUOTES);
$naam=htmlspecialchars($_POST['naam'],ENT_QUOTES);
$titel=htmlspecialchars($_POST['titel'],ENT_QUOTES);
$email=htmlspecialchars($_POST['email'],ENT_QUOTES);
$DVDR = ""; $DIVX = ""; $AUDIO = ""; $CDR = ""; $DVDR = ""; $VCD = "";
{
if(isset($_POST['DVDR']))
{
foreach ($_POST['DVDR'] as $value)
{
$DVDR.= $value." ";
}
}
}

{
if(isset($_POST['DIVX']))
{
foreach ($_POST['DIVX'] as $value)
{
$DIVX.= $value." ";
}
}
}

{
if(isset($_POST['AUDIO']))
{
foreach ($_POST['AUDIO'] as $value)
{
$AUDIO.= $value." ";
}
}
}

{
if(isset($_POST['VCD']))
{
foreach ($_POST['VCD'] as $value)
{
$VCD.= $value." ";
}
}
}
{
if(isset($_POST['CDR']))
{
foreach ($_POST['CDR'] as $value)
{
$CDR.= $value." ";
}
}
}
if (!$naam)
$error = "Je moet je eigen Naam invullen<br><br>";
elseif (!$email)
$error = "Je moet je e-mailadres invullen<br><br>";
elseif (!$bericht)
$error = "Je moet een Omschrijving (versie) invullen<br><br>";
if ($error == "") {
if (isset($_POST['mailing']))//opvragen met checkbox die je mailing noemt
{
$mailing = 1;
}
else
{
$mailing = 0;
}
$query ="INSERT INTO dvdreacties (naam, tijd, datum, bericht, forumid, email, DVDR, DIVX, AUDIO, CDR, PRIJS, VCD, WINKEL, plaatje, MERK, MERKKEUZE, mailing) VALUES ('$naam', '$tijd', '$datum', '$bericht', '$forumid', '$email', '$DVDR', '$DIVX', '$AUDIO', '$CDR', '$PRIJS', '$VCD', '$WINKEL', '$plaatje', '$MERK', '$MERKKEUZE', '$mailing')";
mysql_query($query) or die(mysql_error());
echo "<div align=\"center\"><table width=\"50%\" border=\"1\"
cellspacing=\"0\" cellpadding=\"2\">
<tr><td bordercolor=\"#000000\" bgcolor=\"#CCCCCC\" height=\"36\">
<div align=\"center\"><font color=\"#000000\" face=\"Verdana,
Arial, Helvetica, sans-serif\" size=\"-1\">Je Dvd speler reactie is verzonden
<br>klik <a href=\"dvdspelers.php?forumid=$forumid\">hier</a>
om terug naar het Request bericht te gaan.</font></div>
</td></tr></table>
</div>";
} elseif ($error) {
echo "
<div align=\"center\"><table width=\"50%\" border=\"1\"
cellspacing=\"0\" cellpadding=\"2\">
<tr bordercolor=\"#000000\">
<td bordercolor=\"#000000\" bgcolor=\"#CCCCCC\" height=\"36\">
<div align=\"center\"><font color=\"#000000\" face=\"Verdana,
Arial, Helvetica, sans-serif\" size=\"-1\"><div align=center>
<font color=black size=-1 face=verdana><b>$error</b><br>
</font></div></font></div>
<form method=\"post\" action=\"javascript:history.go(-1)\">
<div align=center><input type=\"submit\" name=\"Terug\"
value=\"Terug\"></div></form></td></tr></table></div>";
}

} if (!$_POST['Submit']) {
?> <?
include ("test.php");

$sql = "SELECT email FROM dvdreacties WHERE id = '".$_GET['id']."' AND mailing = 1";
$result = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
$email = $row['email'];
$bericht = "Er is gereageert op uw bericht op het forum...";
$subject = "Reactie op uw bericht op forum";
mail($email,$subject,$bericht);
}

}

?>
<form method="post" action="">

<a name="top37">
<table width="90%" border="0" cellpadding="2" id="table307">
<tr><td width="9%">
<p align="right"><font size="2" color="#FF0000">*</font></td>
<a name="top161">
<td width="19%" style="border: 1px solid #C0C0C0; ">
<b><font face="Times New Roman" style="font-size: 9pt">Je Naam :</font></b></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<div align="center"> <b><font face="Verdana, Arial,
Helvetica, sans-serif" size="-1">
<span style="font-size: 7pt"><font color="#C00000">
<span style="font-size: 9pt">
<input name="naam" id="naam" size="52" style="float: left; font-family:Times New Roman; font-size:11; color:#000000"></span></font></span></font></b></div></td></tr><tr>
<td width="9%">
<p align="right"><font color="#FF0000" style="font-size: 9pt">*</font></td>
<td width="19%" style="border: 1px solid #C0C0C0; "> <b>
<font face="Times New Roman" style="font-size: 9pt">Email adres
:</font></b></td><td width="70%" style="border: 1px solid #C0C0C0; "> <div align="center"><b><font face="
Verdana, Arial, Helvetica, sans-serif" size="-1">
<span style="font-size: 7pt"><font color="#C00000">
<span style="font-size: 9pt">
<input name="email" id="email" size="52" style="float: left; font-size:11; font-family:Times New Roman; color:#000000"></span></font></span></font></b></div></td></tr><tr>
<td width="9%">
<p align="right">
 </td><td width="19%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt; font-weight: 700">Type CDR :</span></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">

<span style="font-size: 9pt">

<input type="checkbox" name="CDR[0]" value="CDR">CDR       </span><a name="top163"><span style="font-size: 9pt"><input type="checkbox" name="CDR[1]" value="CDRW"></span></a><span style="font-size: 9pt">
CDRW<td width="16%"></tr><tr>
<td width="9%">
<p align="right">
 </td><td width="19%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt; font-weight: 700">Type DVDR :</span></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt">
<input type="checkbox" name="DVDR[0]" value="DVD+R">DVD+R   
<input type="checkbox" name="DVDR[1]" value="DVD+RW">DVD+RW 
<input type="checkbox" name="DVDR[2]" value="DVD+R DL">DVD+R DL
<input type="checkbox" name="DVDR[3]" value="DVD-R">DVD-R                             
<input type="checkbox" name="DVDR[4]" value="DVD-RW">DVD-RW
<input type="checkbox" name="DVDR[5]" value="DVD-R DL">DVD-R DL
<input type="checkbox" name="DVDR[6]" value="DVD-R RAM">DVD-R RAM</span></td>
</tr><A name=top162>
<tr>
<td width="9%">
<p align="right">
 </td><td width="19%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt; font-weight: 700">Video Formaten</span></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<a name="top154">
<span style="font-size: 9pt">
<input type="checkbox" name="VCD[0]" value="VCD"></span></a><span style="font-size: 9pt"></a></a>VCD  </span><a name="top155"><span style="font-size: 9pt"><input type="checkbox" name="VCD[1]" value="SVCD"></span></a><span style="font-size: 9pt"></a></a>SVCD  </span><a name="top156"><span style="font-size: 9pt"><input type="checkbox" name="VCD[2]" value="CVD"></span></a><span style="font-size: 9pt"></a></a>CVD</span></td></tr>
<tr>
<td width="9%">
<p align="right">
 </td><td width="19%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt; font-weight: 700">Video Formaten :</span></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt">
<input type="checkbox" name="DIVX[0]" value="DIVX"></a></a></a>Divx
<input type="checkbox" name="DIVX[1]" value="XVID"></a>Xvid</span><a name="top159"><span style="font-size: 9pt"><input type="checkbox" name="DIVX[2]" value="WMV"></span></a><span style="font-size: 9pt">WMV
<input type="checkbox" name="DIVX[3]" value="SD"></a>Selectable Divx/Xvid subs (SD)</span></td></tr>
<tr>
<td width="9%">
<p align="right">
 </td><td width="19%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt; font-weight: 700">Audio Formaten :</span></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<span style="font-size: 9pt">
<input type="checkbox" name="AUDIO[0]" value="MP3"></a>Mp3
<input type="checkbox" name="AUDIO[1]" value="WMA"></a>WMA
<input type="checkbox" name="AUDIO[2]" value="DVD-WMA"></a>DVD-WMA
<input type="checkbox" name="AUDIO[3]" value="DVD-MP3"></a>DVD-MP3
<input type="checkbox" name="AUDIO[4]" value="MP4"></a>MP4                      
<input type="checkbox" name="AUDIO[5]" value="DTS"></a>DTS</span></td></tr><tr>
<td width="9%">
<p align="right">
 </td>
<td width="19%" style="border: 1px solid #C0C0C0; ">
<b><span style="font-size: 9pt">Prijs in € :</span></b></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<a name="top139">
<b><font face="Verdana, Arial, Helvetica,
sans-serif" size="-1">
<span style="font-size: 7pt"><font color="#C00000">
<span style="font-size: 8pt"><font face="Times New Roman">
<input name="PRIJS" size="5" style="float: left; font-size:11; font-family:Times New Roman; color:#000000"></font></span></font></span></font></b></a></a></a><font face="Times New Roman" size="-1"><span style="font-size: 8pt">(Geen </span></font>
<font face="Times New Roman"><span style="font-size: 8pt">
€
gebruiken )</span></font></td></tr>
<tr>
<td width="9%">
<p align="right"><font color="#FF0000" style="font-size: 9pt">*</font></td>
<td width="19%" style="border: 1px solid #C0C0C0; ">
<span style="font-weight: 700; font-size: 9pt">Opmerking </span>
<span style="font-size: 9pt; font-weight: 700">:</span></td>
<a name="top103">
</a>
<td width="70%" style="border: 1px solid #C0C0C0; ">
<div align="left"><b>
<font face="Verdana, Arial, Helvetica,
sans-serif" size="-1"><span style="font-size: 7pt"><font color="#C00000">
<textarea name="bericht" cols="55" rows="6" style="font-family:Times New Roman; color:#000000; font-size:11"></textarea></font></span></font></b></div></td></tr><tr>
<td width="9%">
 </td><td width="19%" style="border: 1px solid #C0C0C0; ">

<span style="font-size: 9pt; font-weight: 700">Web winkel :</span></td>
<td width="70%" style="border: 1px solid #C0C0C0; ">
 </td></tr>
<tr>
<td width="9%">
 </td><td width="19%" style="border: 1px solid #C0C0C0">

<span style="font-size: 9pt; font-weight: 700">Plaatje (url)</span></td>
<td width="70%" style="border: 1px solid #C0C0C0">
<a name="top170">
<span style="font-size: 7pt">
<b>
<font color="#C00000" face="Verdana, Arial, Helvetica,
sans-serif" size="-1">
<span style="font-size: 9pt">
<font face="Times New Roman">
<input name="plaatje" size="53" style="float: left; font-size:11; font-family:Times New Roman"></font></span></font></b></span></td></tr>
<tr>
<td width="9%">
 </td><td width="19%" style="border: 1px solid #C0C0C0">

<b><span style="font-size: 9pt">Dvd merk tip :</span></b></td>
<td width="70%" style="border: 1px solid #C0C0C0">
<a name="top173">
<span style="font-size: 7pt">
<b>
<font color="#C00000" face="Verdana, Arial, Helvetica,
sans-serif" size="-1">
<span style="font-size: 9pt">
<font face="Times New Roman">
<input name="MERK" size="25" style="float: left; font-size:8pt"></font></span></font></b></span><a name="top172"><select size="1" name="MERKKEUZE" style="font-size: 10px">
<option>Type</option>
<option value=" DVD+R">DVD+R</option>
<option value=" DVD+RW">DVD+RW</option>
<option value=" DVD+R DL">DVD+R DL</option>
<option value=" DVD-R">DVD-R</option>
<option value=" DVD-RW">DVD-RW</option>
<option value=" DVD-R DL">DVD-R DL</option>
<option value=" DVD-R RAM">DVD-R RAM</option>
</select></a></a></a></td></tr>
<a name="top">
<tr>
<td width="9%">
 </td><td width="19%">
<span style="font-size: 9pt; font-weight: 700">email bij reactie</span></td><td width="70%">
<A name=top183>
<span style="font-size: 9pt">
<input type="checkbox" name="mailing" value="1"></span></td></tr>
<tr>
<td width="9%">
 </td><td width="19%">
<p align="left"> </td><td width="70%"><span style="font-size: 9pt">
Velden met een</span> <font size="2" color="#FF0000">*</font><span style="font-weight: 700"><font face="Verdana, Arial,
Helvetica, sans-serif" style="font-size: 8pt" color="#C00000"> </font></span>
<font face="Times New Roman" style="font-size: 9pt">zijn verplicht.</font></td></tr>
</a></table>
</a></a>
<p>
<font face="Verdana,
Arial, Helvetica, sans-serif">
                                              
<a name="top102">
<a name="top">
<input type="submit" name="Submit" value="plaats" style="border-style: solid; border-width: 1px; font-size:11; font-family:tim; "></font><A name=top><a name="top"></a></p>
</form>

?

Onbekende gebruiker

07-05-2005 14:54

ik dacht dat ik het zo wel goed gedaan had ?

?

Onbekende gebruiker

07-05-2005 15:00

oke ik wil niet heel dringerig klinken ofzo hoor , maar ben je er nog ???

Willem Jan Z

07-05-2005 15:34

Begin bijvoorbeeld eens te vertellen wat de foutmelding is die je nu krijgt....

Wij gana echt geen meters script doorlopen zoeken naar foutjes.... ik in ieder geval niet

?

Onbekende gebruiker

07-05-2005 15:35

oke de pagina word geopend , de variabelen worden in de db gezet , maar de mail functie doet het gewoon niet.

Z

Zim Zim

07-05-2005 15:46 gewijzigd op 07-05-2005 15:47

Staat de mail functie aan op je server?

anders meot je dat ff testen met: mail("[email protected]","lalala","lalalaaaaa")

?

Onbekende gebruiker

07-05-2005 15:47

ja want een heb ook een contact formulier en die doet het perfect

?

Onbekende gebruiker

07-05-2005 15:48

maar jij denkt dat het zo zou moeten werken ?

Willem Jan Z

07-05-2005 16:33

Maar wat is de foutmelding?!
Je zei nu alleen wat het wel en niet deed, in de foutmelding staat waarom iets het niet doet...