extract email adress

[kristijan]

hi,

i wanna extract emails from a query result and make them active.
the replace doesn't work - i think the error is in the regex...

would be very apprecheated for help.

if (ereg("[\w-]+(.[\w-])@\w+(.\w+)(.[a-z]{2,4})", mysql_result($result, $i, "Text"), $match)) {

$repl = ereg_replace($match[0], "<a href=mailto:$match[1]$match[2]$match[3]> $match[0] </a>" , "<p><font face='Arial' size='2' color='#000000'>" . nl2br(htmlentities(stripslashes(mysql_result($result, $i, "Text")))) . "</font></p>");
print "$repl";
} else {
print "<p><font face='Arial' size='2' color='#000000'>" . nl2br(htmlentities(stripslashes(mysql_result($result, $i, "Text")))) . "</font></p>";
}

many thanx
kristijan

[Mega]

apprecheated

appreciated or appreciative

now I think your trying to replace email addresses, I have no idea but i will try to help you 🙂

$text = mysql_result($result, $i, "Text");

$text = preg_replace("#([a-zA-Z0-9_][a-zA-Z0-9._-]+@[a-zA-Z0-9][a-zA-Z0-9._-]+[a-zA-Z0-9][^\\s])#Ui", '<a href="mailto:\\\\1">\\\\1</a>', $text);

edit:
god damn vB, why does it make me double slash everything, piece of crap

[jpr]

Hello Mega, I have a question about the last piece of code you gave. It seems to be the solution I need, to find all emails in a string, if they are in <a href=\"mailto: [e-mail]\"> or even if it is just [e-mail]. Your code worked, however it is giving weird results, it is finding the email addresses and it seems to be cutting off the last part of the address. For example:

$myString= 'blah blaah <a href="mailto: [e-mail]">me</a> [e-mail] ';

preg_match_all("#([a-zA-Z0-9][a-zA-Z0-9.-]+@[a-zA-Z0-9][a-zA-Z0-9._-]+[a-zA-Z0-9][^\s])#Ui", $myString, $email_matches); #be sure to include the spaces
$emails = $email_matches[0]; #$links is an array of all the links.

for ($i=0; $i<count($emails); $i++) {
echo $emails[$i] . "<br>\n";
}

That returns the following:

test1@emai
test2@emai

Any ideas, thank you!