Jump to content

Email Formatting


cerebrus189

Recommended Posts

So I have this page that outputs a sql query for required courses (healthcare field) and creates an email based on user input (variable). The email sends and I receive the information but the format is jacked up. My markup in the email shows.

 

As an example, I should be getting this.

 

Course                                            Date

Mandt Recert                                  1/16/2011

AWMD Recert                                  9/15/2010

 

etc, etc.

 

 

What I currently get in the email is this:

 

 

<table width=100% class="style11"><th align="left"><u>Course</u></th><th align="left"><u>Complete By</u></th><th align="left"> <th><tr><td width=33%>Abuse Neglect and Exploitation</td><td width=10%>12-31-1997</td><td width=33%></td></tr><tr><td width=33%>BloodBorne Pathogens Video</td><td width=10%>04-18-2008</td><td width=33%></td></tr><tr><td width=33%>MANDT Recert</td><td width=10%>08-11-2010</td><td width=33%></td></tr><tr><td width=33%>AWMD Recert</td><td width=10%>06-28-2011</td><td width=33%></td></tr><tr><td width=33%>CPR/1st Aid Combo</td><td width=10%>07-16-2012</td><td width=33%></td></tr></table></body></html>

 

 

<?php
	//connect to the database
	include 'dbcommon.php';
	$conn = mysql_connect($dbhost, $username, $password)
	  or die("Could not show the required classes." . mysql_error($conn));
	mysql_select_db($dbname);

	//grab the classes that are required
	$query="SELECT course, date_last_taken, certification FROM course_completions WHERE employee_id='" . $_REQUEST['employid'] . "' order by date_last_taken asc"; 
	$rs = mysql_query($query, $conn);
	$numrequired = mysql_num_rows($rs);

	$emailtext .= "<table width=100% class=\"style11\">";
	$emailtext .= "<th align=\"left\"><u>Course</u></th><th align=\"left\"><u>Complete By</u></th><th align=\"left\"> <th>";
	if ($numrequired == 0) {
	$emailtext .= "<html>\n";  
	$emailtext .= "<body>";
	$emailtext .= "<tr><td colspan=3>No classes required</td></tr>";
	}
	while ($results = mysql_fetch_array($rs))
	{
	  $emailtext .= "<tr>";
	  $emailtext .= "<td width=33%>";
	  $emailtext .= $results["course"];
	  $emailtext .= "</td>";
	  $emailtext .= "<td width=10%>";
	  $emailtext .= date("m-d-Y",strtotime($results["date_last_taken"]));
	  $emailtext .= "</td>";
	  $emailtext .= "<td width=33%>";
	  $emailtext .= "</td>";
	  $emailtext .= "</tr>";		  	  
	}
	$emailtext .= "</table>";
	$emailtext .= "</body>";
	$emailtext .= "</html>";
	echo $emailtext;

	mysql_close($conn);

	$headers .= "MIME-Version: 1.0\n";
	$headers .= "Content-Type: multipart/alternative; boundary=\"$mime_boundary\"\n";


	//email the results/		
	$email = $_REQUEST["email"];
	$comment = "message1";
	$subject = " ARCA Required Courses ";

	$message = $emailtext; 


	mail($email, $subject, $message);

	if ($mail) {
       echo "Email sent, click <a href=displaycourses.php?" . SID . ">here</a> to return.";
      }
      else {
        echo "There was a problem sending the email.";
      }

      ?> 
      
      

 

I'm sure the syntax isn't correct somewhere but I need help with the output of the email formatting.

 

Thanks!

Link to comment
https://forums.phpfreaks.com/topic/210557-email-formatting/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.