PHP Email from Database

RobM

Hi,

I'm having a few problems with sending an html email that is selected by chosing an option in a drop down list, the email is sent however the body of the email is empty. Can anyone offer any assitance with this?

  

  $username = "";
  $password = "";
  $hostname = "";    

  $dbconn = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");

  $database = mysql_select_db("email",$dbconn);

  $query  = "SELECT email FROM eMail WHERE eMail_ID = '" . $_POST["eMail_ID"] . "'";
  $result = mysql_query($query) or die(mysql_error());
	$data = mysql_fetch_row($result);
  $message = $data;

   $to = "email address" ;
	$from = "email address";
	$Subject = "Subject";
	$headers = "MIME-Version: 1.0rn";
	$headers .= "Content-type: text/html; charset=iso-885n-lrn";
	$headers  .= "From: $from\r\n";

mail($to, $from, $subject, $headers, $message);

  mysql_close($dbconn);

Stryker250

You have your $message variable as the incorrect argument in the mail function.

mail($to, $from, $message, $headers);

mail()

RobM

Thanks for the quick response, unfortunately the problem still exists. I have to leave work now unexpectedly so I wont be replying to this thread for the rest of the day. Thanks in advance for any assistance provided.

Stryker250

I just realized that you are pulling the content of the email from the database. But you are assigning an array to the $message variable and not the actual content.
This should solve it.

  $username = "";
  $password = "";
  $hostname = "";    

  $dbconn = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");

  $database = mysql_select_db("email",$dbconn);

  $query  = "SELECT email FROM eMail WHERE eMail_ID = '" . $_POST["eMail_ID"] . "'";
  $result = mysql_query($query) or die(mysql_error());
	$data = mysql_fetch_assoc($result);
  $message = $data['email'];

   $to = "email address" ;
	$from = "email address";
	$Subject = "Subject";
	$headers = "MIME-Version: 1.0rn";
	$headers .= "Content-type: text/html; charset=iso-885n-lrn";
	$headers  .= "From: $from\r\n";

mail($to, $from, $subject, $message, $headers);

  mysql_close($dbconn);

RobM

Thanks once again for your help Stryker, however this has still not resolved my problem. It doesnt even work if I remove all the html out of the database field and just have plain text in it. Is there anything else I can try?

Stryker250

Do you get any errors? (PHP errors for example) Or does anything happen that is not supposed to happen?

RobM

Everything works fine, except the email is blank :queasy:

NogDog

I would suggest adding a check in the code after you execute the query verifying that you did, in fact, get a result (e.g. seeinf if [man]mysql_num_rows/man is > 0). In other words, follow the defensive coding mantra of, "Assume nothing."

Stryker250

I'm not 100% sure if this effects the email content, but as far as I know it does effect the sending and receiving of the email. The CRLF is not correct in the $headers variable as some backslashes are missing.

Also taking in consideration what NogDog said about checking if the DB entry exists as well.

  $username = "";
  $password = "";
  $hostname = "";    

  $dbconn = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");

  $database = mysql_select_db("email",$dbconn);

  $query  = "SELECT email FROM eMail WHERE eMail_ID = '" . $_POST["eMail_ID"] . "'";
  $result = mysql_query($query) or die(mysql_error());
  $data = mysql_fetch_assoc($result);
  $entry = mysql_num_rows($result);
  //Check if entry exists
  if($entry !== 0){
    $message = $data['email'];
    $to = "email address" ;
    $from = "email address";
    $Subject = "Subject";
    $headers = "MIME-Version: 1.0\r\n";
    $headers .= "Content-type: text/html; charset=iso-885n-l\r\n";
    $headers .= "From: $from\r\n";

if(mail($to, $from, $subject, $message, $headers)){
  echo 'Email sent';
}else{
  echo 'Failed sending email';
}
  }else{
    echo 'No email entry found';
  }                    

  mysql_close($dbconn);

RobM

Great, almost there!

Except I can only get it to display plain text in the email. I have tried different charset, changing the html in the email but I still get only text. Do I have to have something enabled php side for this to work?

If your interested in what the problem was, it was the way I had my database setup :queasy: I changed the setup of the ID column and everything started working. sry for the trouble.

Stryker250

If the email is displaying as plain text, try changing your header variables to the following.

    $headers = "MIME-Version: 1.0\n";
    $headers .= "Content-type: text/html; charset=iso-885n-l\n";
    $headers .= "From: $from\n";

RobM

Still the same problem, im wondering if its my html, does there need to be anything special if I'm sending it in email this way?

I have used the same html when manualy sending an email in outlook and everything wors fine?

roscor

Try changing your $message to something like the following, to check to see if the email is being received correctly, $username and $password are data collected from a database, or something similar.

$message = "<html><body><h4>This E-mail Has been sent to you by mysite.co.uk</h4><br><br>
Hi <b>$username</b><br>Forgot Your Password or you are a new member<br>Your password is <b>$password</b><br>
Now Follow the Link<a href='http://mysite.co.uk/login.php'>&nbsp;mysite.co.uk/login</a>&nbsp;To logon</body></html>";

RobM

Thanks for your input roscor, unfortunately it is still returning text.

Could this be related to the configuration of the database, what type of field should I be using to store the HTML code in?

Stryker250

Try changing the charset to iso-8559-1.

roscor

If you have done as stryker250 suggested then use wordwrap. Also look nl2br. Hope this helps!

RobM

Guys,

Thanks for your help with this problem I have had, its much appreicated, I have not been able to get this to work, however I have found a work arround, I am sending the email as an attachment. Not exactly what I wanted to do, but for the time being it will suffice.

Thanks again

RobM