Getting the email link to work

philweb

Hello,

I am pretty new to all this so bare with me. I am trying to get the email results from my database to become live email address links. I have tried the <a>href="mailto:<?php echo $row_formreusults['email']; ?></a> but I can't get it to work. I am using DreamWeaver to provide the connection to the database, so if you have any suggestion I would be very greateful, I have tried all sorts of ways to get this working. Here is the whole page, thanks in advance.

Phil

<?php require_once('Connections/#####); ?>
<?php
mysql_select_db($database_philweb_learning, $####);
$query_formreusults = "SELECT * FROM petition ORDER BY id ASC LIMIT 10";
$formreusults = mysql_query($query_formreusults, $####) or die(mysql_error());
$row_formreusults = mysql_fetch_assoc($formreusults);
$totalRows_formreusults = mysql_num_rows($formreusults);

mysql_select_db($database_####, $####);
$query_Recordset1 = "SELECT name FROM petition ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $####) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Standart//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="no" lang="no">
<head>
<title>Web Design in High Wycombe, Marlow, Beaconsfield, Slough, Maidenhead, Bucks and Berks.</title>
<link href="ready_templates1/custom.css" rel="stylesheet" type="text/css" />
</head>
<body>

	<div style="position:relative; width:770px; position: relative; margin-left: -385px; left: 50%; top: 23px;">
		<table width="770" border="0" align="center" cellpadding="0" cellspacing="0">
			<tr>
				<td id="shadowtop" colspan="3" class="transparent"></td>
			</tr>
			<tr>
				<td id="shadowLeft" class="transparent"></td>
				<td id="innerTable">


					<table width="758" border="0" cellpadding="0" cellspacing="0">
						<tr>
							<td id="headerTop">

								<table style="margin-left: 10px;">
									<tr>
										<td width="55"><img src="ready_templates1/images/company-logo.png" width="47" height="47" /></td>
										<td><h1 class="company-name">phwebdesign</h1></td>
									</tr>
								</table>

							</td>
						</tr>
						<tr>
							<td id="header" valign="bottom">

							<h1 class="header-info">Web Site Solutions </h1>

							</td>
						</tr>
						<tr>
							<td id="navigation" height="22">

								<center>
								<table class="hmains">
									<tr>
										<td class="hmains"><a href="index.php" class="hmains">Home</a></td>
										<td class="hmains"><a href="services.php" class="hmains">Our Services</a></td>
										<td align="center" class="hmains"><a href="login.php" class="hmains"> login</a></td>
										<td class="hmains"><a href="contact.php" class="hmains">Contact us</a></td>
										<td class="hmains"><a href="logout.php" class="hmains">Log out</a></td>
									</tr>
								</table>
								</center>

							</td>
						</tr>
						<tr>
							<td id="content" valign="top"><table width="100%"  border="0" cellpadding="0" cellspacing="2" bgcolor="#CCCCCC">
                              <tr>
                                <td><table width="100%"  border="0" cellspacing="2" cellpadding="0">
                                  <tr><h1>&nbsp;</h1>
                                    <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
                                      <tr>
                                        <td width="6%" align="left" valign="top"><div id="welcome"><!-- InstanceBeginEditable name="EditRegion1" -->
                                          <div align="left">Here is the database as it stands, if you wanted to add your name to this you would need to fill in a form. I suppose the form would be something like this. <a href="petition.php">PETITION </a></div>
                                        <!-- InstanceEndEditable -->

                                        </div></td>
                                      </tr>
                                      <tr>
                                        <td valign="top"><!-- InstanceBeginEditable name="EditRegion2" -->
                                          <p>Thank you <span style="font-weight: bold"><?php echo $row_Recordset1['name']; ?></span> , your entry was the last to be added to our petition. </p>
                                          <table width="100%" border="0" align="center" cellpadding="5" cellspacing="5">
                                            <tr align="left" valign="top">
                                              <td width="6%" align="center"><span style="font-weight: bold; font-size: 10px">Number</span></td>
                                              <td width="19%" align="center"><span style="font-weight: bold; font-size: 10px">Full Name</span></td>
                                              <td width="21%" align="center"><span style="font-weight: bold; font-size: 10px">What is you Email?</span></td>
                                              <td width="17%" align="center"><span style="font-weight: bold; font-size: 10px">What village do you live in? </span></td>
                                              <td width="18%" align="center"><span style="font-weight: bold; font-size: 10px">Do you Support the ban on smoking? </span></td>
                                              <td width="19%" align="center"><span style="font-size: 10px; font-weight: bold">Are you prepared to come to meetings?</span></td>
                                            </tr>
                                            <?php do { ?>
                                            <tr align="center">
                                              <td align="left"><?php echo $row_formreusults['id']; ?></td>
                                              <td><?php echo $row_formreusults['name']; ?></td>
                                              <td><?php echo $row_formreusults['email']; ?></td>
                                              <td><?php echo $row_formreusults['village']; ?></td>
                                              <td><?php echo $row_formreusults['support']; ?></td>
                                              <td><?php echo $row_formreusults['meetings']; ?></td>
                                            </tr>
                                            <?php } while ($row_formreusults = mysql_fetch_assoc($formreusults)); ?>
                                        </table>
                                          <p align="center"><a href="formresults.php">Last</a> |<a href="formresults.php"> </a><a href="formresults1.php">Next</a> </p>
                                        <!-- InstanceEndEditable --></td>
                                      </tr>
                                    </table></td>
                                  </tr>
                                </table></td>
                              </tr>
                            </table></td>
						</tr>
						<tr>
							<td id="footerTop">&nbsp;</td>
						</tr>
						<tr>
							<td id="footer">

								<table width="720" style="margin-left: 20px;">
									<tr>
										<td></td>
										<td align="right">

											<table class="hsubs">
												<tr>
													<td class="hsubs">&nbsp;</td>
													<td class="hsubs">&nbsp;</td>
													<td class="hsubs">&nbsp;</td>
												</tr>
											</table>

										</td>
									</tr>
								</table>

							</td>
						</tr>
					</table>


				</td>		
				<td id="shadowRight" class="transparent"></td>
			</tr>
			<tr>
				<td id="shadowBottom" colspan="3" class="transparent"></td>
			</tr>
			<tr>
				<td><img src="ready_templates1/images/spacer.gif" width="5" height="0" alt="" /></td>
				<td>&nbsp;</td>
				<td><img src="ready_templates1/images/spacer.gif" width="5" height="0" alt="" /></td>
			</tr>
	  </table>
	</div>

</body>

</html>
<?php
mysql_free_result($formreusults);

mysql_free_result($Recordset1);
?>

konrad

<a href="mailto:...">email me</a> is a javascript function that use default email client defined on user machine. If you want to send email with PHP on server side I sugest to use phpmailer - it's very easy to use and reliable class.

philweb

Hi Konrad

Thanks for the tip, however I don't want to send mass email through php, I just want to be able to click anyone of the email addresses and then have the email box pop up. I want to be able to adjust the code to be able to do this, any ideas?

thanks

Phil

konrad

Ensure you've got default email client set in your system and try out this code

<?php 
 require_once('Connections/#####');
 mysql_select_db($database_philweb_learning, $####);
 $query_formreusults = "SELECT * FROM petition ORDER BY id ASC LIMIT 10";
 $formreusults = mysql_query($query_formreusults, $####) or   die(mysql_error());

function url_encode($url){
	return str_replace('+', '%20', urlencode($url));
}

 $subject = 'Some subject';
 $body = 'Body content';

 while ($row_formreusults = mysql_fetch_assoc($formreusults)){
  echo '<a href="mailto: ' . $row_formreusults['email'] . '?subject=' . url_encode($subject) . '&body=' . url_encode($body) . '">Send</a><br />';
 }
?>

Hope this helps

philweb

Konrad

thanks for the code, it sort of worked. I got a list of send links in the top left of my screen of which when clicked it popped up the mail box for those email addresses. All of the other data from the database disappeared. I am not sure what you meant by "Ensure you've got default email client set in your system" I am on a hosting package and don't have access to the server. I am very excited about being able to do this so if you can help some more that would be great.

Phil

konrad

Well, here is your code with inserted email links. You can change subject and body of e-mail globally ( by changing $subject and $body under url_encode function definition) or set diffrent values for each user in do ... while loop.

<?php require_once('Connections/#####'); ?>
<?php
function url_encode($url){
    return str_replace('+', '%20', urlencode($url));
} 

$subject = 'Some subject';
$body = 'Body content'; 

mysql_select_db($database_philweb_learning, $####);
$query_formreusults = "SELECT * FROM petition ORDER BY id ASC LIMIT 10";
$formreusults = mysql_query($query_formreusults, $####) or die(mysql_error());
$row_formreusults = mysql_fetch_assoc($formreusults);
$totalRows_formreusults = mysql_num_rows($formreusults);

mysql_select_db($database_####, $####);
$query_Recordset1 = "SELECT name FROM petition ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $####) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Standart//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="no" lang="no"><!-- InstanceBegin template="/Templates/Template_ready1.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<title>Web Design in High Wycombe, Marlow, Beaconsfield, Slough, Maidenhead, Bucks and Berks.</title>
<link href="ready_templates1/custom.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div style="position:relative; width:770px; position: relative; margin-left: -385px; left: 50%; top: 23px;">
<table width="770" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td id="shadowtop" colspan="3" class="transparent"></td>
</tr>
<tr>
<td id="shadowLeft" class="transparent"></td>
<td id="innerTable">


<table width="758" border="0" cellpadding="0" cellspacing="0">
<tr>
<td id="headerTop">

<table style="margin-left: 10px;">
<tr>
<td width="55"><img src="ready_templates1/images/company-logo.png" width="47" height="47" /></td>
<td><h1 class="company-name">phwebdesign</h1></td>
</tr>
</table>

</td>
</tr>
<tr>
<td id="header" valign="bottom">

<h1 class="header-info">Web Site Solutions </h1>

</td>
</tr>
<tr>
<td id="navigation" height="22">

<center>
<table class="hmains">
<tr>
<td class="hmains"><a href="index.php" class="hmains">Home</a></td>
<td class="hmains"><a href="services.php" class="hmains">Our Services</a></td>
<td align="center" class="hmains"><a href="login.php" class="hmains"> login</a></td>
<td class="hmains"><a href="contact.php" class="hmains">Contact us</a></td>
<td class="hmains"><a href="logout.php" class="hmains">Log out</a></td>
</tr>
</table>
</center>

</td>
</tr>
<tr>
<td id="content" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="2" bgcolor="#CCCCCC">
<tr>
<td><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr><h1>&nbsp;</h1>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td width="6%" align="left" valign="top"><div id="welcome"><!-- InstanceBeginEditable name="EditRegion1" -->
<div align="left">Here is the database as it stands, if you wanted to add your name to this you would need to fill in a form. I suppose the form would be something like this. <a href="petition.php">PETITION </a></div>
<!-- InstanceEndEditable -->

</div></td>
</tr>
<tr>
<td valign="top"><!-- InstanceBeginEditable name="EditRegion2" -->
<p>Thank you <span style="font-weight: bold"><?php echo $row_Recordset1['name']; ?></span> , your entry was the last to be added to our petition. </p>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5">
<tr align="left" valign="top">
<td width="6%" align="center"><span style="font-weight: bold; font-size: 10px">Number</span></td>
<td width="19%" align="center"><span style="font-weight: bold; font-size: 10px">Full Name</span></td>
<td width="21%" align="center"><span style="font-weight: bold; font-size: 10px">What is you Email?</span></td>
<td width="17%" align="center"><span style="font-weight: bold; font-size: 10px">What village do you live in? </span></td>
<td width="18%" align="center"><span style="font-weight: bold; font-size: 10px">Do you Support the ban on smoking? </span></td>
<td width="19%" align="center"><span style="font-size: 10px; font-weight: bold">Are you prepared to come to meetings?</span></td>
</tr>
<?php do { ?>
<tr align="center">
<td align="left"><?php echo $row_formreusults['id']; ?></td>
<td><?php echo $row_formreusults['name']; ?></td>
<?php echo '<td><a href="mailto: ' . $row_formreusults['email'] . '?subject=' . url_encode($subject) . '&body=' . url_encode($body) . '">Send</a></td>';?>
<td><?php echo $row_formreusults['village']; ?></td>
<td><?php echo $row_formreusults['support']; ?></td>
<td><?php echo $row_formreusults['meetings']; ?></td>
</tr>
<?php } while ($row_formreusults = mysql_fetch_assoc($formreusults)); ?>
</table>
<p align="center"><a href="formresults.php">Last</a> |<a href="formresults.php"> </a><a href="formresults1.php">Next</a> </p>
<!-- InstanceEndEditable --></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td id="footerTop">&nbsp;</td>
</tr>
<tr>
<td id="footer">

<table width="720" style="margin-left: 20px;">
<tr>
<td></td>
<td align="right">

<table class="hsubs">
<tr>
<td class="hsubs">&nbsp;</td>
<td class="hsubs">&nbsp;</td>
<td class="hsubs">&nbsp;</td>
</tr>
</table>

</td>
</tr>
</table>

</td>
</tr>
</table>


</td>
<td id="shadowRight" class="transparent"></td>
</tr>
<tr>
<td id="shadowBottom" colspan="3" class="transparent"></td>
</tr>
<tr>
<td><img src="ready_templates1/images/spacer.gif" width="5" height="0" alt="" /></td>
<td>&nbsp;</td>
<td><img src="ready_templates1/images/spacer.gif" width="5" height="0" alt="" /></td>
</tr>
</table>
</div>

</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($formreusults);

mysql_free_result($Recordset1);
?>

Try to avoid escaping from php to html ( use
<?php echo '<td>' . $some_value . '</td>';
echo '<td>' . $other_value . '</td>';
?>
instead of
<td><?php echo $some_value;?></td>
<td><?php echo $other_value;?></td> ).
I wanted you to ensure, that your e-mail client program such as MS Outlook, Thunderbird or Bat is recognized by your system as a default mail client.
Sorry for my poor english.
Hope this make sense...

philweb

Konrad,

Yes, yes and more yes. thanks sooooo much for that. But supposing I wanted to show the email address there instead of the send message, how would this change, is that easy to do?

thanks,

Phil

konrad

Hmmm... It's so easy that I should expect you to change the code for yourself. Anyway, here are modifications:

<?php require_once('Connections/#####'); ?>
<?php
function url_encode($url){
    return str_replace('+', '%20', urlencode($url));
}

$subject = 'Some subject';
$body = 'Body content';

mysql_select_db($database_philweb_learning, $####);
$query_formreusults = "SELECT * FROM petition ORDER BY id ASC LIMIT 10";
$formreusults = mysql_query($query_formreusults, $####) or die(mysql_error());
$row_formreusults = mysql_fetch_assoc($formreusults);
$totalRows_formreusults = mysql_num_rows($formreusults);

mysql_select_db($database_####, $####);
$query_Recordset1 = "SELECT name FROM petition ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $####) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Standart//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="no" lang="no"><!-- InstanceBegin template="/Templates/Template_ready1.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<title>Web Design in High Wycombe, Marlow, Beaconsfield, Slough, Maidenhead, Bucks and Berks.</title>
<link href="ready_templates1/custom.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div style="position:relative; width:770px; position: relative; margin-left: -385px; left: 50%; top: 23px;">
<table width="770" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td id="shadowtop" colspan="3" class="transparent"></td>
</tr>
<tr>
<td id="shadowLeft" class="transparent"></td>
<td id="innerTable">


<table width="758" border="0" cellpadding="0" cellspacing="0">
<tr>
<td id="headerTop">

<table style="margin-left: 10px;">
<tr>
<td width="55"><img src="ready_templates1/images/company-logo.png" width="47" height="47" /></td>
<td><h1 class="company-name">phwebdesign</h1></td>
</tr>
</table>

</td>
</tr>
<tr>
<td id="header" valign="bottom">

<h1 class="header-info">Web Site Solutions </h1>

</td>
</tr>
<tr>
<td id="navigation" height="22">

<center>
<table class="hmains">
<tr>
<td class="hmains"><a href="index.php" class="hmains">Home</a></td>
<td class="hmains"><a href="services.php" class="hmains">Our Services</a></td>
<td align="center" class="hmains"><a href="login.php" class="hmains"> login</a></td>
<td class="hmains"><a href="contact.php" class="hmains">Contact us</a></td>
<td class="hmains"><a href="logout.php" class="hmains">Log out</a></td>
</tr>
</table>
</center>

</td>
</tr>
<tr>
<td id="content" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="2" bgcolor="#CCCCCC">
<tr>
<td><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr><h1>&nbsp;</h1>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td width="6%" align="left" valign="top"><div id="welcome"><!-- InstanceBeginEditable name="EditRegion1" -->
<div align="left">Here is the database as it stands, if you wanted to add your name to this you would need to fill in a form. I suppose the form would be something like this. <a href="petition.php">PETITION </a></div>
<!-- InstanceEndEditable -->

</div></td>
</tr>
<tr>
<td valign="top"><!-- InstanceBeginEditable name="EditRegion2" -->
<p>Thank you <span style="font-weight: bold"><?php echo $row_Recordset1['name']; ?></span> , your entry was the last to be added to our petition. </p>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5">
<tr align="left" valign="top">
<td width="6%" align="center"><span style="font-weight: bold; font-size: 10px">Number</span></td>
<td width="19%" align="center"><span style="font-weight: bold; font-size: 10px">Full Name</span></td>
<td width="21%" align="center"><span style="font-weight: bold; font-size: 10px">What is you Email?</span></td>
<td width="17%" align="center"><span style="font-weight: bold; font-size: 10px">What village do you live in? </span></td>
<td width="18%" align="center"><span style="font-weight: bold; font-size: 10px">Do you Support the ban on smoking? </span></td>
<td width="19%" align="center"><span style="font-size: 10px; font-weight: bold">Are you prepared to come to meetings?</span></td>
</tr>
<?php do { ?>
<tr align="center">
<td align="left"><?php echo $row_formreusults['id']; ?></td>
<td><?php echo $row_formreusults['name']; ?></td>
<?php echo '<td><a href="mailto: ' . $row_formreusults['email'] . '?subject=' . url_encode($subject) . '&body=' . url_encode($body) . '">' . $row_formreusults['email'] . '</a></td>';?>
<td><?php echo $row_formreusults['village']; ?></td>
<td><?php echo $row_formreusults['support']; ?></td>
<td><?php echo $row_formreusults['meetings']; ?></td>
</tr>
<?php } while ($row_formreusults = mysql_fetch_assoc($formreusults)); ?>
</table>
<p align="center"><a href="formresults.php">Last</a> |<a href="formresults.php"> </a><a href="formresults1.php">Next</a> </p>
<!-- InstanceEndEditable --></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td id="footerTop">&nbsp;</td>
</tr>
<tr>
<td id="footer">

<table width="720" style="margin-left: 20px;">
<tr>
<td></td>
<td align="right">

<table class="hsubs">
<tr>
<td class="hsubs">&nbsp;</td>
<td class="hsubs">&nbsp;</td>
<td class="hsubs">&nbsp;</td>
</tr>
</table>

</td>
</tr>
</table>

</td>
</tr>
</table>


</td>
<td id="shadowRight" class="transparent"></td>
</tr>
<tr>
<td id="shadowBottom" colspan="3" class="transparent"></td>
</tr>
<tr>
<td><img src="ready_templates1/images/spacer.gif" width="5" height="0" alt="" /></td>
<td>&nbsp;</td>
<td><img src="ready_templates1/images/spacer.gif" width="5" height="0" alt="" /></td>
</tr>
</table>
</div>

</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($formreusults);

mysql_free_result($Recordset1);
?>