Email Validation

Yrogerg

I'm setting up an email list and storing names in MySQL.

Step 1:
I need to first verify what they've entered is a valid email address and next check that is not already in the database, therefore eliminating any duplicates.

Step 2:
I need to write a script that can remove someone from the list should they choose to do so, using an id # in MySQL.

Step 3:
Does php have a BCC mail option? I need to be able to send text/html formatted emails to all the emails on the list using BCC.

If anyone replies, THANK YOU!
I'm a php/mysql novice.

hand

Step 1

// simple validation
if (!eregi("^[_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,4}$",$email)):
  # Sorry .....
endif;

Duplicate check I think is really no problem:
select from table where emailfieldintable = '$email';

<?php
$result = mysql_query("select * from table where emailfieldintable = '$email'");
$num_rows = mysql_num_rows($result);

if ($num_rows > 0) {
   print "sorry email exists ... "
}
?>

Step 3
Yes - within the mail header
http://www.php3.de/manual/en/function.mail.php

Yrogerg

I'm still running into some problems. One of which, is when the field is blank and is submitted I don't get any response. Here's the script:

if($email){
		include 'includes/connect.php';
		$flag = true;
		// validate email
		$validEmail = "^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,4}$";
		if(empty($email)){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif($email = ""){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif(!eregi($validEmail, $email)){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif(strlen($email) > 50){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		else{
			$valid = true;
		}
		// check for dupliates
		if($valid == true){
			$query = "SELECT * FROM list where email = '$email'";
			$result = mysql_query($query, $conn);
			$rows = mysql_num_rows($result);
			if($rows > 0){
				$error = "<span class='pageCount'>You're already on the list.</span>";
			}
			else{
				$success = true;
			}
		}
	}

And later inside some html:

	if($flag){	
						if($error){
				  			echo $error;
						}
						else{
							if($success = true){
								echo "<span class='pageCount'>You've been added to our email list successfully.</span>";
							}
						}
					}

hand

elseif($email == ""){
instead of
elseif($email = ""){

and

if($success == true){
instead of
if($success = true){

Yrogerg

Good eye.
Everything works perfectly, except if I enter nothing in the textfield I still get no response. If I enter a space, I get the right response, but not if nothing is entered.

any ideas?

thanks btw.

hand

if($email){ // this IF is the reason why
   ...
} else {
   $error = "<span class='pageCount'>Please enter a valid email address.</span>";
}

meetn2veg

I'm new (surprise...) but am doing exactly the same thing.

The way I've coped with is is to include javascript in the page itself, checking;

js code...
if(form.email.value.length = 0){alert('...error msg...')}

etc...

Then, in the FORM tag;

I hope this might help you out!

Cheers
R.

Yrogerg

Still nada. I've tried Dreamweaver's built-in javascript validation but no avail. The only reason I have the if($email) is because the page is submitted to itself.

http://dienovember.com/im/home.php

HELP!!

hand

Instead of row
if($email){

try it with
if($imageField){

Yrogerg

nothin'.
is it me or is this unexpectedly complicated?

hand

It is simple and really not complicated. Please post your skript which validates the email again.

Yrogerg

Remember it submits to itself, all one page.

<?
	if($imageField){
		include 'includes/connect.php';
		$flag = true;
		// validate email
		$validEmail = "^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,4}$";
		if(empty($email)){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif($email == ""){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif(!eregi($validEmail, $email)){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif($email == "name@domain.com"){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		elseif(strlen($email) > 50){
			$error = "<span class='pageCount'>Please enter a valid email address.</span>";
		}
		else{
			$valid = true;
		}
		// check for dupliates
		if($valid == true){
			$query = "SELECT * FROM list where email = '$email'";
			$result = mysql_query($query, $conn);
			$rows = mysql_num_rows($result);
			if($rows > 0){
				$error = "<span class='pageCount'>You're already on the list.</span>";
			}
			else{
				$success = true;
			}
		}
	}
?>

later in the html:

<? 
				  	if($flag){	
						if($error){
				  			echo $error;
						}
						else{
							if($success == true){
								echo "<span class='pageCount'>You've been added to our email list successfully.</span>";
							}
						}
					}
				  ?>

hand

Add following hidden field to your form:
<input name="submit" type="hidden" value="submit">

Then instead of row
if($imageField){

try it with
if($submit){

(Sorry, I did'nt know, that a form field with type image doesn't work like type submit or type text)

Yrogerg

Works! Many thanks.

hand

You're welcome :p

Weedpacket

When submitting a form, it is possible to use an image instead of the standard submit button with a tag like:
<input type="image" src="image.gif" name="sub">
When the user clicks somewhere on the image, the accompanying form will be transmitted to the server with two additional variables, sub_x and sub_y. These contain the coordinates of the user click within the image. The experienced may note that the actual variable names sent by the browser contains a period rather than an underscore, but PHP converts the period to an underscore automatically.