wmguk Posted August 19, 2007 Share Posted August 19, 2007 Hi guys, This might be so dumb, but is there anyway to create an html email from some php info? <table width="800" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="80" align="left" valign="top" background="http://www.website.co.uk/images/top.jpg"><p> </p> </td> </tr> <tr> <td align="left" valign="top" background="http://www.website.co.uk//images/middle.jpg"> <table width="800" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="20"> </td> <td class="main"> <p>Dear <?php if ($groom_firstname == 'X') { echo $bride_firstname ; } else { echo $bride_firstname " and " $groom_firstname "," ; } ?></p> <p>We are please to announce that your album has been made live now.</p> <p>Please click <a href="http://website.co.uk/emailgallery.php?login=<? echo $login ; ?>">HERE</a> to view your album. </p> <p>You can also now tell all your family and friends about your new album by clicking HERE. </p></td> <td width="20"> </td> </tr> </table></td> </tr> <tr> <td align="left" valign="top" background="http://www.website.co.uk/images/bottom.jpg"> </td> </tr> <tr> <td align="left" valign="top"><blockquote> </blockquote></td> </tr> </table> Link to comment https://forums.phpfreaks.com/topic/65733-creating-a-html-email-from-php-database-info/ Share on other sites More sharing options...
trq Posted August 19, 2007 Share Posted August 19, 2007 Of course there is, where exactly are you stuck? Link to comment https://forums.phpfreaks.com/topic/65733-creating-a-html-email-from-php-database-info/#findComment-328351 Share on other sites More sharing options...
wmguk Posted August 19, 2007 Author Share Posted August 19, 2007 I dont know how to make the actual email, is it just <?php //Make Connection include "http://www.website.co.uk/scripts/connection.php"; if (!$con) { die( 'Could not connect: ' . mysql_error() ); } mysql_select_db($db, $con); $result = mysql_query("SELECT * FROM album WHERE username= $user"); ?> how do i get the info from the database though? there will only be one row of info to use... only a few fields <?php # -=-=-=- MIME BOUNDARY $mime_boundary = "----Your_Company_Name----".md5(time()); # -=-=-=- MAIL HEADERS $to = "$email"; $subject = "This text will display in the email's Subject Field"; $headers = "From: Our Company <[email protected]>\n"; $headers .= "Reply-To: Our Company <[email protected]>\n"; $headers .= "MIME-Version: 1.0\n"; $headers .= "Content-Type: multipart/alternative; boundary=\"$mime_boundary\"\n"; # -=-=-=- HTML EMAIL PART $message .= "--$mime_boundary\n"; $message .= "Content-Type: text/html; charset=UTF-8\n"; $message .= "Content-Transfer-Encoding: 8bit\n\n"; $message .= "<html>\n"; $message .= "<body style=\"font-family:Verdana, Verdana, Geneva, sans-serif; font-size:14px; color:#666666;\">\n"; $message .= "<table width='800' border='0' align='center' cellpadding='0' cellspacing='0'><tr><td height='80' align='left' valign='top' background='http://www.website.co.uk/images/top.jpg'><p> </p></td></tr><tr><td align='left' valign='top' background='http://www.website.co.uk//images/middle.jpg'>"; $message .= "<table width='800' border='0' cellspacing='0' cellpadding='0'><tr><td width='20'> </td>"; $message .= "<td class='main'><p>Dear "; $message .= "if ($groom_firstname == 'X') { "; $message .= "echo $bride_firstname ; } "; $message .= "else { "; $message .= "echo $bride_firstname ' and ' $groom_firstname ',' ; }</p>"; $message .= "<p>We are please to announce that your album has been made live now.</p>"; $message .= "<p>Please click <a href='http://website.co.uk/emailgallery.php?login=$login'>HERE</a> to view your album. </p>"; $message .= "<p>You can also now tell all your family and friends about your new album by clicking HERE. </p></td><td width='20'> </td></tr></table></td></tr>"; $message .= "<tr><td align='left' valign='top' background='http://www.website.co.uk/images/bottom.jpg'> </td></tr></table>"; $message .= "</body>\n"; $message .= "</html>\n"; # -=-=-=- FINAL BOUNDARY $message .= "--$mime_boundary--\n\n"; # -=-=-=- SEND MAIL $mail_sent = @mail( $to, $subject, $message, $headers ); echo $mail_sent ? "Mail sent" : "Mail failed"; Link to comment https://forums.phpfreaks.com/topic/65733-creating-a-html-email-from-php-database-info/#findComment-328357 Share on other sites More sharing options...
wmguk Posted August 20, 2007 Author Share Posted August 20, 2007 can anyone help me out on the database connection to bring the info in to the email ($login etc) Link to comment https://forums.phpfreaks.com/topic/65733-creating-a-html-email-from-php-database-info/#findComment-328564 Share on other sites More sharing options...
wmguk Posted August 20, 2007 Author Share Posted August 20, 2007 anyone? Link to comment https://forums.phpfreaks.com/topic/65733-creating-a-html-email-from-php-database-info/#findComment-328666 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.