preg_split, preg_match, explode()??? Stumped

[fuzzy1]

Hey All,

Trying to retrieve email address from bounced email in mysql table.

I've got most of the addresses from bounced emails getting marked in my contacts table as invalid by a removeme.id.tag in the sent email, but sometimes the mailer daemon just returns something like the following in the email body without the removeme.id.tag.

This is an automatically generated Delevery Status Notification. Delivery To the following recipients failed. '[e-mail]'

without the id.tag. So... how might I go about extracting the email address from the email body?

while ($row = mysql_fetch_assoc($result)) 
{ //$row['description'] == email body text

$description = $row['description'];
$str = 'This is an automatically generated Delevery Status Notification. Delivery To the following recipients failed.' ;
//$_split_email = preg_split ('//','$str', $description);
//$_split_email = array_shift(explode('$str', $description));

$_split_email = array_pop(explode('$description', $str,)); 

echo $_split_email;
}

Better Still... how might i just ignore all BUT the email string in the body, as the body text is bound to vary from one mailer_daemon to the next?

[NogDog]

Perhaps something like:

if(preg_match("/'([^@']+@[^@']+)'/", $description, $matches))
{
   echo "Email: " . $matches[1];
}

?

[fuzzy1]

Hey there NogDog!

Well, I was able to get results out of array_pop()...

<?php
$description = 'This is an automatically generated Delevery Status Notification: Delivery To the following recipients failed. [e-mail]';
$str = 'failed.';
$var = array_pop(explode("$str", $description)); 
echo $var; 
?>

but as I've said, I don't think it a good long term solution. Would much rather go with preg_match() and have been at it all afternoon. Tried your suggestion, but sadly... No Joy there either🙁 tried...

<?php
$description = 'This is an automatically generated Delevery Status Notification: Delivery To the following recipients failed. [e-mail]';
if(preg_match("/'([^@']+@[^@']+)'/", $description, $matches)) 
{ 
  echo "Email: " . $matches[1]; 
} 
	else{echo 'No Joy';}
?>

[NogDog]

You changed the data on me. In your initial post there were single quotes around the email address, which I used in the regex. You need to clearly determine/define what the pattern is that you want to look for.

If you just want to find anything that is a validly structured email address:

$qtext = '[^\\x0d\\x22\\x5c\\xa6-\\xff]';
$dtext = '[^\\x0d\\x5b-\\x5d\\xa6-\\xff]';
$atom = '[^\\x00-\\x20\\x22\\x28\\x29\\x2c\\x2e\\x3a-\\x3c'.
'\\x3e\\x40\\x5b-\\x5d\\xa6-\\xff]+';
$quoted_pair = '\\x5c[\\x00-\\xa5]';
$domain_literal = "\\x5b($dtext|$quoted_pair)*\\x5d";
$quoted_string = "\\x22($qtext|$quoted_pair)*\\x22";
$domain_ref = $atom;
$sub_domain = "($domain_ref|$domain_literal)";
$word = "($atom|$quoted_string)";
$domain = "$sub_domain(\\x2e$sub_domain)*";
$local_part = "$word(\\x2e$word)*";
$addr_spec = "$local_part\\x40$domain";
if(preg_match("/$addr_spec/", $description, $matches))
{
   echo "Email: " . $matches[0];
}
else
{
   echo 'No joy';
}

[fuzzy1]

You changed the data on me. In your initial post there were single quotes around the email address, which I used...

Sorry, my bad. Not intentional to be sure. Meanwhile, I got a little something working, and while I have no doubt the regex construct you have offered will be more fool-proof, I'm going to hold off implementing that until I've got the rest of my update working.
It's been a LONG day, and I'm getting punchy.

Having trouble updating from the array here...

$result = @mysql_query ($bounce_no_removeme)or die ("Query Failed");
$numresults=mysql_query($bounce_no_removeme); 
	$numrows=mysql_num_rows($numresults); 
// If we have no results, die
	if ($numrows != 0)
     {
	while ($row = mysql_fetch_assoc($result))
     {
		$description= $row['description'];
		$_get_email_addr =  preg_match_all("/[\._a-zA-Z0-9-]+@[\._a-zA-Z0-9-]+/i", $description, $matches);
		$email_addr = $matches[0];

$_update_invalid = "UPDATE contacts SET invalid_email ='1' 
WHERE email1 ='$email_addr[?]' ";// here's where I'm stuck
	$query = @mysql_query ($_update_invalid) or die ("Query Failed Updating Invalid emails." .mysql_error()); // Run the query. 
	$affected_rows = mysql_affected_rows(); 
	}
	echo $affected_rows .'<br>';
	echo $numrows;
}	

One of these days I'm going to get a handle on arrays and the foreach and while loops:mad: