Is it possible to send an html email with php and mysql data?

[wickedneat]

I'm trying to send a form that has both html, php, and mysql queries is this possible? Any documentation?

[Dan Grossman]

Are you saying someone is typing code into the form and you want that code to appear in the e-mail? There wouldn't be any special handling for that, it's just text like other user input.

[wickedneat]

No, I'm saying I want stuff to be pulled from the database and sent statically.

[Dan Grossman]

mysql_connect("host", "user", "pass");
mysql_select_db("dbname");

$sql = "SELECT name, email FROM user_table";
$sql_result = mysql_query($sql);
while ($row = mysql_fetch_array($sql_result)) {
  
  $body = "Dear " . $row['name'] . ", \n\n";
  $body .= "Thank you for being a user of our service!\n\n";
  $body .= "Sincerely,\n";
  $body .= "Dan";

  mail($row['email'], "Just a Thank You!", $body, "From: admin@example.com");

} 

[wickedneat]

In the above how does it know address to send it to and things?

[spikeZ]

they are taken from the database and assigned $row['email'], assuming you have their email address in the database.....

[wickedneat]

well i do have, but I need it to email like 4 or 5 different accounts.

[wickedneat]

also I need to use html to make a table to put the data in?

[spikeZ]

Have a read through http://uk.php.net/manual/en/function.mail.php, it should answer all your questions

[Servyces]

Basically you can build a complete php/mysql driven page and mail the contents once everything is parsed. Just put all the commands within the $body variable.

The below example would mail the results that phpinfo returns to the given e-mail address.

<?php
$body = phpinfo();
mail('you@yourdomain.com','PHP Info from server',$body);
?>

You get the idea. You can do this with both PHP and HTML code and have it sent once everything is parsed.

[wickedneat]

What do you mean put all the commands within the body variable?

[Dan Grossman]

Basically you can build a complete php/mysql driven page and mail the contents once everything is parsed. Just put all the commands within the $body variable.

The below example would mail the results that phpinfo returns to the given e-mail address.

<?php
$body = phpinfo();
mail('you@yourdomain.com','PHP Info from server',$body);
?>

You get the idea. You can do this with both PHP and HTML code and have it sent once everything is parsed.

Off Topic:

That wouldn't work since phpinfo() doesn't return a string but instead outputs directly.

[Servyces]

What do you mean put all the commands within the body variable?

To put all the PHP code you would like executed within the body variable of the e-mail.

[wickedneat]

So everything I want to email has to be in there?

[Servyces]

Yes or references to earlier executed code. Like:

$query = mysql_query("SELECT name FROM customers WHERE id=3");
while ($row = mysql_fetch_assoc($query)) {
    $name = $row['name'];
}

$body = "Dear $name, \r\n";
$body .= "\r\n";
$body .= "Thank you for your inquiry. We will get back to you as soon as possible.";

mail ('me@myinbox.com','Inquiry',$body);