wrap $email in a mailto

[Rollo_Tamasi]

hi guys i'm pulling up email addresses from a mysql database, when i get the email adresses on the page i would like to have them appear as mailto's. I have tried several peices of code such as

Users Email:<mailto:"<?php echo "$email" ?>"

&

<?php echoUsers Email:<mailto:?> <?php echo "$email" ?><?php echo> 

i found this on the net from alt-php-faq.net. Its a function that transforms all linkable elements to links :

<?php
// Written by Fredrik Kristiansen (russlndr at online.no)
// and Albrecht Guenther (ag at phprojekt.de).

function html_activate_links($str) {
    $str = eregi_replace('(((f|ht){1}tp://)[-a-zA-Z0-9@:%_\+.~#?&//=]+)', '<a href="\\1" target="_blank">\\1</a>', $str);
    $str = eregi_replace('([[:space:]()[{}])(www.[-a-zA-Z0-9@:%_\+.~#?&//=]+)', '\\1<a href="http://\\2" target="_blank">\\2</a>', $str);
    $str = eregi_replace('([_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,3})','<a href=\"mailto:\\1\">\\1</a>', $str);
    return $str;
}
?> 

but none work, would someone be able to help out? Thanks

[rincewind456]

It might work better if you checked that the HTML was correct. This works

<a href="mailto:<?php echo $email ?>">Users Email</a>

[Rollo_Tamasi]

thanks but that doesn't work. Myself and a friend can't figure this one out. here is the complete page if it makes any difference.

<title>View Emails</title>
 <?
include("dbconnect.php");
$getnews = mysql_query("SELECT * FROM contact ORDER BY date DESC");

while($r=mysql_fetch_array($getnews)){
extract($r);

echo("<hr><table>
  <tr>
	<td>Email Received:</td>
	<td>$date</td>
  </tr>
  <tr>
	<td>Department:</td>
	<td>$department</td>
  </tr>
  <tr>
	<td>Name:</td>
	<td>$name</td>
  </tr>
  <tr>
	<td>Email Address:</td>
	<td>$email</td>
  </tr>
  <tr>
	<td>Phone Number:</td>
	<td>$phonenumber</td>
  </tr>
  <tr>
	<td>Title:</td>
	<td>$title</td>
  </tr>
  <tr>
	<td>Message:</td>
	<td>$message</td>
  </tr>
  <tr>
	<td>Status:</td>
	<td>answered/unanswered</td>
  </tr>
	<td></td>
	<td>
   </tr>
</table>");

}

?>

[m37h0d]

<title>View Emails</title>
<?
include("dbconnect.php");
$getnews = mysql_query("SELECT * FROM contact ORDER BY date DESC");

while($r=mysql_fetch_array($getnews)){
extract($r);

echo '
<hr><table>
      <tr>
        <td>Email Received:</td>
        <td>'.$date.'</td>
      </tr>
      <tr>
        <td>Department:</td>
        <td>'.$department.'</td>
      </tr>
      <tr>
        <td>Name:</td>
        <td>'.$name.'</td>
      </tr>
      <tr>
        <td>Email Address:</td>
        <td><a href="mailto:'.$email.'"></td>
      </tr>
      <tr>
        <td>Phone Number:</td>
        <td>'.$phonenumber.'</td>
      </tr>
      <tr>
        <td>Title:</td>
        <td>'.$title.'</td>
      </tr>
      <tr>
        <td>Message:</td>
        <td>'.$message.'</td>
      </tr>
      <tr>
        <td>Status:</td>
        <td>answered/unanswered</td>
      </tr>
        <td></td>
        <td>
       </tr>
    </table>
';

}

?>

Use that, I bet it will work 😉

[Rollo_Tamasi]

m37h0d wrote:

Use that, I bet it will work 😉

your lucky you didn't put any money on it! didn't work mate.
i suppose since i put up the code it would do no harm to post up the mysql for the contact table

CREATE TABLE `contact`  (
    `id` int(11) NOT NULL auto_increment,
    `name` varchar(255) NOT NULL default '',
    `email` varchar(22) NOT NULL default '',
    `phonenumber` varchar(22) NOT NULL default '',
    `title` varchar(22) NOT NULL default '',
    `department` varchar(22) NOT NULL default '',
    `date` varchar(50) NOT NULL default '0000-00-00',
    `message` text NOT NULL,
    PRIMARY KEY (`id`)
)   TYPE=MyISAM AUTO_INCREMENT=1;

i'm stumped!

[rincewind456]

Are you certain that your retrieving any data? Your code should work fine, unless there are no records being retrieved.

You would have to change your line to something like

<td><a href='mailto: $email'>$email</a></td>

to get a mail to link though.

[Rollo_Tamasi]

:xbones:
cheers rincewind456, thats perfect, the script is now functional. Thanks a million.