Hello again guys,<br /><br />How easy is it to add a "join our mailing list" text box and then either have that feed into some sort of database or in worst case just email to the site owner so he can add it manually?<br /><br />I'm trying to create a good way for people to subscribe to a form of update/newsletter?<br /><br />Does anybody have an examples of this?<br /><br />Cheers<br /><br />Crammy<!--content-->
There is a good program called "Subscriber" or similar ( I'll get the name tomorrow ) which you can connect to your mailbox, so that:<br /><br />A user (or your server) can email the users email address (using the FROM field) to your mailbox to add themselves<br />A user can send an email with the subject "Unsubscribe" or similar to your mailbox to remove themselves.<br /><br />I have used it to create mailshots to about 2000 people before now, and it has worked well - the actual input mailing list was generated by Actinic so I don't know how easy it is to do it manually.<!--content-->
<!-- w --><a class="postlink" href="http://www.ymlp.com">www.ymlp.com</a><!-- w -->, ive used that a few times in various websites<!--content-->
are there any free scripts or examples i.e without advertising that anyone knows of?<br /><!--content-->
I'm about to start using MailChimp<br /><br />they have pay as you go plans...pay as you go<!--content-->
GroupMail is the name of the one I am using... however that is because it allows CSV imports, which is a required thing of using Actinic...<br /><br />I have heard good things of MailChimp so far<!--content-->
We're using a thing called SendBlaster at the moment which is a godsend for me. I can create rich HTML emails and send blaster will extract all of the text from it to send as a plain text email along side it. <br /><br />It's got some nice features too.<br /><br />As for a 'subscribe' form I do mine in PHP so you make a basic form. Something like this:<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><form name="signup" action="#" method="post" ><br />Â Â Â Â <div align="right">Email: <input name="email" type="text" class="boxes" style="width:170px;" /><br /><br />Â Â Â Â <input name="Submit" type="submit" value="Submit" class="boxes" style="width:60px;" /></div><br /></form><!--c2--></div><!--ec2--><br /><br />And then add this code to insert it in to your database (I've called the table 'signup').<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><?php <br /><br />Â Â Â Â if(isset($_POST['email'])){<br />Â Â Â Â Â Â Â Â Â Â Â Â mysql_select_db($database, $connection);<br />Â Â Â Â Â Â Â Â Â Â Â Â $query_add = "SELECT * FROM `signup` WHERE `email` = '".$_POST['email']."' ";<br />Â Â Â Â Â Â Â Â Â Â Â Â $add = mysql_query($query_add, $connection);<br />Â Â Â Â Â Â Â Â Â Â Â Â $row_add = mysql_fetch_assoc($add);<br />Â Â Â Â Â Â Â Â Â Â Â Â $totalRows_add = mysql_num_rows($add);<br />Â Â Â Â Â Â Â Â Â Â Â Â <br />Â Â Â Â Â Â Â Â Â Â Â Â if($totalRows_tab == 0){<br />Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â mysql_query("INSERT INTO `signup` ( `email` ) VALUE ( '".$_POST['email']."' ) ", $connection);<br />Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â echo mysql_error();<br />Â Â Â Â Â Â Â Â Â Â Â Â }<br />Â Â Â Â Â Â Â Â <br />?><!--c2--></div><!--ec2--><br /><br />Of course you will need to connect to a MySQL database and set the relevant variables but that's all that required for doing it yourself.<!--content-->
There is a good program called "Subscriber" or similar ( I'll get the name tomorrow ) which you can connect to your mailbox, so that:<br /><br />A user (or your server) can email the users email address (using the FROM field) to your mailbox to add themselves<br />A user can send an email with the subject "Unsubscribe" or similar to your mailbox to remove themselves.<br /><br />I have used it to create mailshots to about 2000 people before now, and it has worked well - the actual input mailing list was generated by Actinic so I don't know how easy it is to do it manually.<!--content-->
<!-- w --><a class="postlink" href="http://www.ymlp.com">www.ymlp.com</a><!-- w -->, ive used that a few times in various websites<!--content-->
are there any free scripts or examples i.e without advertising that anyone knows of?<br /><!--content-->
I'm about to start using MailChimp<br /><br />they have pay as you go plans...pay as you go<!--content-->
GroupMail is the name of the one I am using... however that is because it allows CSV imports, which is a required thing of using Actinic...<br /><br />I have heard good things of MailChimp so far<!--content-->
We're using a thing called SendBlaster at the moment which is a godsend for me. I can create rich HTML emails and send blaster will extract all of the text from it to send as a plain text email along side it. <br /><br />It's got some nice features too.<br /><br />As for a 'subscribe' form I do mine in PHP so you make a basic form. Something like this:<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><form name="signup" action="#" method="post" ><br />Â Â Â Â <div align="right">Email: <input name="email" type="text" class="boxes" style="width:170px;" /><br /><br />Â Â Â Â <input name="Submit" type="submit" value="Submit" class="boxes" style="width:60px;" /></div><br /></form><!--c2--></div><!--ec2--><br /><br />And then add this code to insert it in to your database (I've called the table 'signup').<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><?php <br /><br />Â Â Â Â if(isset($_POST['email'])){<br />Â Â Â Â Â Â Â Â Â Â Â Â mysql_select_db($database, $connection);<br />Â Â Â Â Â Â Â Â Â Â Â Â $query_add = "SELECT * FROM `signup` WHERE `email` = '".$_POST['email']."' ";<br />Â Â Â Â Â Â Â Â Â Â Â Â $add = mysql_query($query_add, $connection);<br />Â Â Â Â Â Â Â Â Â Â Â Â $row_add = mysql_fetch_assoc($add);<br />Â Â Â Â Â Â Â Â Â Â Â Â $totalRows_add = mysql_num_rows($add);<br />Â Â Â Â Â Â Â Â Â Â Â Â <br />Â Â Â Â Â Â Â Â Â Â Â Â if($totalRows_tab == 0){<br />Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â mysql_query("INSERT INTO `signup` ( `email` ) VALUE ( '".$_POST['email']."' ) ", $connection);<br />Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â echo mysql_error();<br />Â Â Â Â Â Â Â Â Â Â Â Â }<br />Â Â Â Â Â Â Â Â <br />?><!--c2--></div><!--ec2--><br /><br />Of course you will need to connect to a MySQL database and set the relevant variables but that's all that required for doing it yourself.<!--content-->