Nieuwsbrieven systeem
en de plaatjes zou ik gewoon online zetten en erheen linken
dit zorgt alleen maar voor extra dataverkeer voor de mailserver en de mensen krijgen sneller een volle mailbox
Succes!!
Hoe langer de mailing list is, hoe vaker mensen een nieuwsbrief toegestuurd krijgen. vb.: staat een emailadres op de 10de plek in de ranglijst, dan krijg dit emailadres 10x een nieuwsbrief ontwerp in 1 mailtje onder elkaar. Als ik dat hele ontwerpgedeelte eraf gooi gaat het weer goed, waar ligt de fout ???
//mail.php
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
<?
// require class
require ("lcheck.php");
require("classes/nieuwsbrief_class.php");
//-- create object
$mailer = new nieuwsbrief();
if (!$show)
$show = "add";
//--
//-- add/rem form submit
//--
if ($show == "add")
{
if ($submit && $email && eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,4}$",$email))
{
//-- check for email
if ($mailer->ChkMail($email))
$exist = "1";
else
$exist = "";
//-- add / rem mail
if (($opt == "insert" && !$exist) || ($opt == "rmv" && $exist))
{
//-- insert mail
if ($opt == "insert")
{
if ($mailer->InsertMail($email))
echo "Je bent succesvol aan de mailing lijst toegevoegd.";
else
{
echo "Je bent <b>niet</b> aan de mailing lijst toegevoegd.<P>";
echo "Probeer het opnieuw of neem contact met ons op.";
}
}
//-- remove mail
else
{
if ($mailer->RemMail($email))
echo "Het e-mail adres: <b>$email</b> is succesvol uitgeschreven.";
else
{
echo "Je bent <b>niet</b> uitgeschreven.<p>";
echo "Probeer het opnieuw of neem contact met ons op.";
}
}
}
//-- show exist page
else
{
if ($opt == "insert")
{
echo "Het opgegeven e-mail adres is al aanwezig in de mailinglijst.<p>";
echo "Ga <a href=\"$PHP_SELF?show=add\">terug</a> en probeer het opnieuw.";
}
else
{
echo "Het opgegeven e-mail adres is niet aanwezig in de mailinglijst en kan dus niet verwijderd worden.<p>";
echo "Ga <a href=\"$PHP_SELF?show=add\">terug</a> en probeer het opnieuw.";
}
}
}
//--
//-- add/rem show form
//--
else
{
if ($submit && (!$email || !eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,4}$",$email)))
echo "<b>Het opgegeven e-mail adres is niet, of niet volledig ingevoerd.</b><p>";
echo "In- of uitschrijven voor de mailing lijst<p>";
echo "<form method=\"POST\" action=\"$PHP_SELF\">";
echo "<input type=\"hidden\" name=\"show\" value=\"$show\">";
echo "<i>Aanmelden</i> <input type=\"radio\" name=\"opt\" value=\"insert\" checked> - <i>Afmelden</i> <input type=\"radio\" name=\"opt\" value=\"rmv\"><p>";
echo "<i>E-mail:</i> <input type=\"text\" name=\"email\" value=\"$email\" size=\"25\"><p>";
echo "<input type=\"submit\" name=\"submit\" value=\"Versturen\" class=\"submit\">";
echo "</form>";
}
}
//--
//-- send message
//--
elseif ($show == "sendmsg")
{
if ($submit && $check && $subject && $msg)
{
$nl2brmsg = nl2br($msg);
// $nl2brmsg=addslashes($nl2brmsg);
// $nl2brmsg=stripslashes($nl2brmsg);
//-- show check
echo "<B>$subject</B><p>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
$html .= "<tr><td>";
echo $html;
echo "Beste Lezer,<p>";
echo "$nl2brmsg<P>";
echo "</td></tr></table>";
echo "<p><hr></p>";
echo "<form method=\"post\" action=\"$PHP_SELF\">";
echo "<input type=\"hidden\" name=\"show\" value=\"$show\">";
echo "<input type=\"hidden\" name=\"subject\" value=\"$subject\">";
echo "<input type=\"hidden\" name=\"msg\" value=\"$nl2brmsg\">";
//echo "<input type=\"hidden\" name=\"msg\" value=\"$msg\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Versturen\" class=\"submit\">";
echo "</form>";
}
elseif ($submit && !$check && $subject && $msg)
{ $msg=stripslashes($msg);
//-- send msg
if ($mailer->SendMail($subject, $msg))
echo "Nieuwsbrief succesvol verstuurd.";
else
{
echo "De nieuwsbrief is niet verstuurd.<p>";
echo "Probeer het opnieuw.";
}
}
else
{
if ($submit && (!$subject || !$msg))
{
echo "<b>Je bent een veld vergeten in te vullen.</b>";
}
echo "<form method=\"POST\" action=\"$PHP_SELF\">";
echo "<input type=\"hidden\" name=\"show\" value=\"$show\">";
echo "<input type=\"hidden\" name=\"check\" value=\"1\">";
echo "<i>Onderwerp:</i><br>";
echo "<input type=\"text\" name=\"subject\" value=\"$subject\" size=\"25\"><br>";
echo "<i>Bericht:</i><br>";
echo "<textarea name=\"msg\" cols=\"65\" rows=\"8\">\"$msg\"</textarea><p>";
echo "<input type=\"submit\" name=\"submit\" value=\"Nieuwsbrief bekijken\" class=\"submit\">";
echo "</form>";
// $msg=stripslashes($msg);
}
}
//--
//-- show e-mail adresses
//--
elseif ($show == "list")
{
$html = $mailer->ShowMail();
echo($html);
}
//--
//-- show not exist page
//--
else
{
echo "Er is een onjuiste keuze gemaakt.<P>";
echo "Probeer één van de menu items.";
}
?>
// require class
require ("lcheck.php");
require("classes/nieuwsbrief_class.php");
//-- create object
$mailer = new nieuwsbrief();
if (!$show)
$show = "add";
//--
//-- add/rem form submit
//--
if ($show == "add")
{
if ($submit && $email && eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,4}$",$email))
{
//-- check for email
if ($mailer->ChkMail($email))
$exist = "1";
else
$exist = "";
//-- add / rem mail
if (($opt == "insert" && !$exist) || ($opt == "rmv" && $exist))
{
//-- insert mail
if ($opt == "insert")
{
if ($mailer->InsertMail($email))
echo "Je bent succesvol aan de mailing lijst toegevoegd.";
else
{
echo "Je bent <b>niet</b> aan de mailing lijst toegevoegd.<P>";
echo "Probeer het opnieuw of neem contact met ons op.";
}
}
//-- remove mail
else
{
if ($mailer->RemMail($email))
echo "Het e-mail adres: <b>$email</b> is succesvol uitgeschreven.";
else
{
echo "Je bent <b>niet</b> uitgeschreven.<p>";
echo "Probeer het opnieuw of neem contact met ons op.";
}
}
}
//-- show exist page
else
{
if ($opt == "insert")
{
echo "Het opgegeven e-mail adres is al aanwezig in de mailinglijst.<p>";
echo "Ga <a href=\"$PHP_SELF?show=add\">terug</a> en probeer het opnieuw.";
}
else
{
echo "Het opgegeven e-mail adres is niet aanwezig in de mailinglijst en kan dus niet verwijderd worden.<p>";
echo "Ga <a href=\"$PHP_SELF?show=add\">terug</a> en probeer het opnieuw.";
}
}
}
//--
//-- add/rem show form
//--
else
{
if ($submit && (!$email || !eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,4}$",$email)))
echo "<b>Het opgegeven e-mail adres is niet, of niet volledig ingevoerd.</b><p>";
echo "In- of uitschrijven voor de mailing lijst<p>";
echo "<form method=\"POST\" action=\"$PHP_SELF\">";
echo "<input type=\"hidden\" name=\"show\" value=\"$show\">";
echo "<i>Aanmelden</i> <input type=\"radio\" name=\"opt\" value=\"insert\" checked> - <i>Afmelden</i> <input type=\"radio\" name=\"opt\" value=\"rmv\"><p>";
echo "<i>E-mail:</i> <input type=\"text\" name=\"email\" value=\"$email\" size=\"25\"><p>";
echo "<input type=\"submit\" name=\"submit\" value=\"Versturen\" class=\"submit\">";
echo "</form>";
}
}
//--
//-- send message
//--
elseif ($show == "sendmsg")
{
if ($submit && $check && $subject && $msg)
{
$nl2brmsg = nl2br($msg);
// $nl2brmsg=addslashes($nl2brmsg);
// $nl2brmsg=stripslashes($nl2brmsg);
//-- show check
echo "<B>$subject</B><p>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
$html .= "<tr><td>";
echo $html;
echo "Beste Lezer,<p>";
echo "$nl2brmsg<P>";
echo "</td></tr></table>";
echo "<p><hr></p>";
echo "<form method=\"post\" action=\"$PHP_SELF\">";
echo "<input type=\"hidden\" name=\"show\" value=\"$show\">";
echo "<input type=\"hidden\" name=\"subject\" value=\"$subject\">";
echo "<input type=\"hidden\" name=\"msg\" value=\"$nl2brmsg\">";
//echo "<input type=\"hidden\" name=\"msg\" value=\"$msg\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Versturen\" class=\"submit\">";
echo "</form>";
}
elseif ($submit && !$check && $subject && $msg)
{ $msg=stripslashes($msg);
//-- send msg
if ($mailer->SendMail($subject, $msg))
echo "Nieuwsbrief succesvol verstuurd.";
else
{
echo "De nieuwsbrief is niet verstuurd.<p>";
echo "Probeer het opnieuw.";
}
}
else
{
if ($submit && (!$subject || !$msg))
{
echo "<b>Je bent een veld vergeten in te vullen.</b>";
}
echo "<form method=\"POST\" action=\"$PHP_SELF\">";
echo "<input type=\"hidden\" name=\"show\" value=\"$show\">";
echo "<input type=\"hidden\" name=\"check\" value=\"1\">";
echo "<i>Onderwerp:</i><br>";
echo "<input type=\"text\" name=\"subject\" value=\"$subject\" size=\"25\"><br>";
echo "<i>Bericht:</i><br>";
echo "<textarea name=\"msg\" cols=\"65\" rows=\"8\">\"$msg\"</textarea><p>";
echo "<input type=\"submit\" name=\"submit\" value=\"Nieuwsbrief bekijken\" class=\"submit\">";
echo "</form>";
// $msg=stripslashes($msg);
}
}
//--
//-- show e-mail adresses
//--
elseif ($show == "list")
{
$html = $mailer->ShowMail();
echo($html);
}
//--
//-- show not exist page
//--
else
{
echo "Er is een onjuiste keuze gemaakt.<P>";
echo "Probeer één van de menu items.";
}
?>
//nieuwsbrief_class.php
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<?
require ("lcheck.php");
class nieuwsbrief
{
var $table;
var $datum;
var $url;
var $from;
// make db connection
function nieuwsbrief()
{
$this->table = "my_nieuwsbrief";
$this->datum = date("d.m.Y");
$this->from = "Je naaam <[email protected]>";
include("config.php");
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
$msg = "Kon geen verbinding maken met de database.";
return $msg;
exit();
}
}
// insert to database
function InsertMail($email)
{
$sql = "INSERT INTO $this->table (id, email, datum) VALUES ('', '$email', '$this->datum')";
$res = mysql_query($sql);
return $res;
}
// remove from database
function RemMail($email)
{
$sql = "DELETE FROM $this->table WHERE email = '$email'";
$res = mysql_query($sql);
return $res;
}
// send msg
function SendMail($subject, $nl2brmsg)
{
$sql = "SELECT email FROM $this->table";
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res))
{
// $nl2brmsg=addslashes($nl2brmsg);
// $nl2brmsg=stripslashes($nl2brmsg);
$to = "$row[email]";
$aanhef = "Beste lezer,<br><br>";
$bericht = "$aanhef\n\n";
$bericht .= "$nl2brmsg\n\n";
// $bericht=stripslashes($bericht);
$headers .= "From: $this->from\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n".
"\r\n".
"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\r\n".
"<HTML>\r\n".
"<HEAD>\r\n".
"<link REL=\"STYLESHEET\" TYPE=\"text/css\" HREF=\"http://xxx.nl/layout.css\">\r\n".
"</HEAD>\r\n".
"<BODY bgcolor=\"#eeeeee\" leftmargin=\"0\" topmargin=\"20\" marginwidth=\"0\" marginheight=\"0\">\r\n".
"<TABLE width=\"800\" valign=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"middle\">\r\n".
"<TR>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje01.jpg\" width=\"199\" height=\"183\" ></TD>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje02.jpg\" width=\"201\" height=\"183\" ></TD>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje03.jpg\" width=\"201\" height=\"183\" ></TD>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje04.jpg\" width=\"199\" height=\"183\" ></TD>\r\n".
"</TR>\r\n".
"</TABLE>\r\n".
"<TABLE width=\"800\" valign=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"middle\">\r\n".
"<TR>\r\n".
"<TD bgcolor=\"ffffff\">\r\n".
"<TABLE border=\"0\" width=800 height=300 cellpadding=\"0\" cellspacing=\"0\" STYLE=\"background-image:url('http://xxx.nl/plaatje07.jpg'); background-repeat: no-repeat; background-position: 0% 100%\">\r\n".
"<TR><td height=10> </td></tr><tr>\r\n".
"<TD width=10%> </td><td valign=\"top\">$bericht\r\n".
"<td width=5%> </td>\r\n".
"</TR>\r\n".
"<TR>\r\n".
"<TD bgcolor=\"#ffffff\" height=\"30\"> </TD>\r\n".
"</TR>\r\n".
"</TABLE>\r\n".
"</TD>\r\n".
"</TR>\r\n".
"</TABLE>\r\n".
"</BODY>\r\n".
"</HTML>\r\n".
"\r\n";
mail($to, $subject, $msg, $headers);
}
return $res;
}
// check if email exists
function ChkMail($email)
{
$sql = "SELECT email FROM $this->table WHERE email = '$email'";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
$result = "1";
else
$result = "";
return $result;
}
// show all e-mail adresses
function ShowMail()
{
$sql = "SELECT email,datum FROM $this->table";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
{
$html = "<table border=\"0\" bgcolor=#ffff00 cellspacing=\"0\" cellpadding=\"0\">";
$html .= "<tr><td width=200><i>Email adres</i></td><td width=100><i>Datum</i></td></tr>";
while ($row = mysql_fetch_array($res))
{
$html .= "<tr><td bgcolor=#ffff00>$row[email]</td><td>$row[datum]</td></tr>";
}
$html .= "</table>";
}
else
$html = "Geen e-mail adressen in de mailing lijst.";
return $html;
}
}
?>
require ("lcheck.php");
class nieuwsbrief
{
var $table;
var $datum;
var $url;
var $from;
// make db connection
function nieuwsbrief()
{
$this->table = "my_nieuwsbrief";
$this->datum = date("d.m.Y");
$this->from = "Je naaam <[email protected]>";
include("config.php");
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
$msg = "Kon geen verbinding maken met de database.";
return $msg;
exit();
}
}
// insert to database
function InsertMail($email)
{
$sql = "INSERT INTO $this->table (id, email, datum) VALUES ('', '$email', '$this->datum')";
$res = mysql_query($sql);
return $res;
}
// remove from database
function RemMail($email)
{
$sql = "DELETE FROM $this->table WHERE email = '$email'";
$res = mysql_query($sql);
return $res;
}
// send msg
function SendMail($subject, $nl2brmsg)
{
$sql = "SELECT email FROM $this->table";
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res))
{
// $nl2brmsg=addslashes($nl2brmsg);
// $nl2brmsg=stripslashes($nl2brmsg);
$to = "$row[email]";
$aanhef = "Beste lezer,<br><br>";
$bericht = "$aanhef\n\n";
$bericht .= "$nl2brmsg\n\n";
// $bericht=stripslashes($bericht);
$headers .= "From: $this->from\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n".
"\r\n".
"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\r\n".
"<HTML>\r\n".
"<HEAD>\r\n".
"<link REL=\"STYLESHEET\" TYPE=\"text/css\" HREF=\"http://xxx.nl/layout.css\">\r\n".
"</HEAD>\r\n".
"<BODY bgcolor=\"#eeeeee\" leftmargin=\"0\" topmargin=\"20\" marginwidth=\"0\" marginheight=\"0\">\r\n".
"<TABLE width=\"800\" valign=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"middle\">\r\n".
"<TR>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje01.jpg\" width=\"199\" height=\"183\" ></TD>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje02.jpg\" width=\"201\" height=\"183\" ></TD>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje03.jpg\" width=\"201\" height=\"183\" ></TD>\r\n".
"<TD><IMG src=\"http://xxx.nl/plaatje04.jpg\" width=\"199\" height=\"183\" ></TD>\r\n".
"</TR>\r\n".
"</TABLE>\r\n".
"<TABLE width=\"800\" valign=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"middle\">\r\n".
"<TR>\r\n".
"<TD bgcolor=\"ffffff\">\r\n".
"<TABLE border=\"0\" width=800 height=300 cellpadding=\"0\" cellspacing=\"0\" STYLE=\"background-image:url('http://xxx.nl/plaatje07.jpg'); background-repeat: no-repeat; background-position: 0% 100%\">\r\n".
"<TR><td height=10> </td></tr><tr>\r\n".
"<TD width=10%> </td><td valign=\"top\">$bericht\r\n".
"<td width=5%> </td>\r\n".
"</TR>\r\n".
"<TR>\r\n".
"<TD bgcolor=\"#ffffff\" height=\"30\"> </TD>\r\n".
"</TR>\r\n".
"</TABLE>\r\n".
"</TD>\r\n".
"</TR>\r\n".
"</TABLE>\r\n".
"</BODY>\r\n".
"</HTML>\r\n".
"\r\n";
mail($to, $subject, $msg, $headers);
}
return $res;
}
// check if email exists
function ChkMail($email)
{
$sql = "SELECT email FROM $this->table WHERE email = '$email'";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
$result = "1";
else
$result = "";
return $result;
}
// show all e-mail adresses
function ShowMail()
{
$sql = "SELECT email,datum FROM $this->table";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
{
$html = "<table border=\"0\" bgcolor=#ffff00 cellspacing=\"0\" cellpadding=\"0\">";
$html .= "<tr><td width=200><i>Email adres</i></td><td width=100><i>Datum</i></td></tr>";
while ($row = mysql_fetch_array($res))
{
$html .= "<tr><td bgcolor=#ffff00>$row[email]</td><td>$row[datum]</td></tr>";
}
$html .= "</table>";
}
else
$html = "Geen e-mail adressen in de mailing lijst.";
return $html;
}
}
?>