9 replies to this topic

[pistonsfreak]

I am in the process of coding yet another website and I was wondering if there is any code out there to produce a newsletter or a free program I can download to send one out. I cant find one so any help would be appreciated.

Thanks

[curthard89]

if your coding a website, why dont u code it urself? lol

[Chaos King]

Now now. Lets not get too vicious. It was a simple question, that harsh of an answer was not needed.

http://www.google.com/search?hl=en&cli...amp;btnG=Search

I hope this search has helped you.

[pistonsfreak]

pistonsfreak, on May 27 2007, 02:34 PM, said:

I am in the process of coding yet another website and I was wondering if there is any code out there to produce a newsletter or a free program I can download to send one out. I cant find one so any help would be appreciated.

Thanks

Because I am intermediate coder I dont knw that much about PHP, and yes it helped me out a lot thanks

[pistonsfreak]

at one point it gives me the code "CREATE TABLE nl_subscribe ( em varchar(75) NOT NULL default '', status varchar(10) NOT NULL defult '') TYPE=MyISAM;" says its incorrect where the flaw?

[Demonslay]

CREATE TABLE `nl_subscribe` ( `em` varchar(75) NOT NULL DEFAULT '', `status` varchar(10) NOT NULL DEFAULT '') TYPE=MyISAM;

Try that. There was a simple miss-type where it said 'defult' instead of 'default' like it should.

[pistonsfreak]

thanks maybe i should start paying more attention to the code and stop wasting peoples time lol thanks

Edited by pistonsfreak, 29 May 2007 - 08:58 AM.

[pistonsfreak]

<? $status = "OK";  // setting the flag to check the status
$msg="";          // setting the variable for message
if (!stristr($em,"@") OR !stristr($em,".")) {
$msg="Your email address is not correct<BR>";
$status= "NOTOK";} 
 echo "<br><br>";
if($status=="OK"){// Now the email is valid and we can add to our database
$query=("INSERT INTO nl_subscribe (em,status) VALUES ('$em','subscribe')");
$result=mysql_query($query);
echo "<center>THANK YOU <br>Thanks for subscribing to our newsletter and any time you can unsubscribe by clicking a link in your newsletter</center>";
          }
else {echo "<center>$msg </center>";}  // this will display the error message if email address is not valid one.
?> 

the problem is when I enter my email to put into the table it says its not valid, the email is pistonsfreak3632@gmail.com

thanks

[Demonslay]

Bit of poor code there if you copy-pasted it from a tutorial or something.
I don't feel like writting more and editing my long email-validating code for you, but this should be a workable change of your existing script.

<?php
$msg = ''; // Setting the variable for message

// Regex Validate Email
if(!preg_match('#([._a-z0-9-]+[._a-z0-9-]*)@(([a-z0-9-]+\.)*([a-z0-9-]+)(\.[a-z]{2,3})?)#i', $em))
  $msg = 'Your email address is not correct<br />';

echo "<br /><br />";

if(empty($msg)){ // Now the email is valid and we can add to our database
  mysql_query("INSERT INTO `nl_subscribe`(`em`, `status`) VALUES('".mysql_real_escape_string($em)."', 'subscribe')") or die(mysql_error());
  echo '<center>THANK YOU<br />Thanks for subscribing to our newsletter and any time you can unsubscribe by clicking a link in your newsletter</center>';
}
else
  echo "<center>{$msg}</center>"; // this will display the error message if email address is not valid one.
?>

If you would like a safer script, simply PM me and I can send you a draft of my own.

[Tarquin]

I really wouldn't recommend using http://www.plus2net....tter_script.php for your tutorial, the whole tutorial I feel is crap.