script for sending mail?

Anon

does anyone have a simple script for sending an email that displays some database variables?

so, make a call to the database, grab a record, put those fields in the body of the email. i can't get database varibles to display.

Anon

It should be pretty easy. You just have to set the variables and then use the variables in the body of the email.

$myvar = from db... (do the needful here)

$body ="
hello my variable $myvar
";

mail($email, $subject, $body, $from);

Hope this helps,

Masood Nasir
http://www.webx.net

Anon

Hey. Ok yea you need to first call the fields you want to show. Set them to variables and then within the same PHP script do the mail($to,$subject,$message);
Check the parse on that. But in your $message have something like:
$message = "Dear $clientname: It has been brought to our attention that we know PHP and you don't. I am so sorry to hear. Please keep in touch.";

Final Script would be:

$db = mysql_connect("localhost");
mysql_select_db("db", $db);
$sql = "select * from table where something='super'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$clientname = $row["clientname"];
}
$to = "phpisgod@phpgod.com";
$subject = "Is PHP your forte?";
$message = "Dear $clientname: It has been brought to our attention that we know PHP and you don't. I am so sorry to hear. Please keep in touch.";
mail($to,$subject,$message);
?>

There we go. Not to bad eh? Take it easy and hope it helps.
~ Zig's ~

Anon

For some reason, my db variables don't show up in the email. I know I'm connecting, because I tried printing them out to the page and that worked. Here's my script:

?php

function mailer_header()
{
?>

<HEAD><TITLE>Tip Me</TITLE></HEAD>
<BODY>
<?php
}

function mailer_footer()
{
?>
</BODY>

<?php
}

function error_message($msg)
{
mailer_header();
print "<SCRIPT>alert(\"Error: $msg\");history.go(-1)</SCRIPT>";
mailer_footer();
exit;
}

function user_message($msg)
{
mailer_header();
"<SCRIPT>alert(\"$msg\");history.go(-1)</SCRIPT>";
mailer_footer();
exit;
}

function mail_form()
{
global $PHP_SELF;
?>
<FORM METHOD=POST ENCTYPE="MULTIPART/FORM-DATA" ACTION="<?php print $PHP_SELF ?>">
<INPUT TYPE="hidden" NAME="action" VALUE="send_mail">

<?php
}

function send_mail()
{
global $mail_to, $mail_from, $mail_body, $mail_subject;

$mail_parts["mail_to"] = $mail_to;
$mail_parts["mail_from"] = $mail_from;
$mail_parts["mail_subject"] = $mail_subject;
$mail_parts["mail_body"] = $mail_body;

if(my_mail($mail_parts))
	print "Successfully sent the email.";
else print "An unknown error occurred while attempting to send the email.";

}

function my_mail($mail_parts)
{

db connection

include "../Includes/db_conn.inc";

$query = "SELECT * FROM members WHERE id='$id';";
$result = mysql_query($query, $db);
$query_data = mysql_fetch_array($result, MYSQL_ASSOC);

$firstname =  stripslashes($query_data["firstname"]);
$lastname = stripslashes($query_data["lastname"]);	

$message = "Here is the contact info:\n";
$message .=$firstname.$lastname."\n";

$mail_to = $mail_parts["mail_to"];
$mail_from = $mail_parts["mail_from"];
$mail_subject = "I have a tip for you.";
$mail_body = $message;

if (empty($mail_to)) error_message("Empty to field!");

$mail_to = str_replace(";", ",", $mail_to);

$mail_headers = '';

if (!empty($mail_from)) $mail_headers .= "From: $mail_from\n";

$mail_subject = stripslashes($mail_subject);
$mail_body = stripslashes($mail_body);

return mail($mail_to,$mail_subject,$mail_body,$mail_headers);

}

switch ($action)
{
case "send_mail":
mailer_header();
send_mail();
mailer_footer();
break;
case "mail_form":
mailer_header();
send_form();
mailer_footer();
break;
default:
mailer_header();
mail_form();
mailer_footer();
break;
}
?>

Anon

Can you debug using:

print $message;

after these lines:

$message = "Here is the contact info:\n";
$message .=$firstname.$lastname."\n";

and see what is the value of $message?

Anon

Yes, when I print it, it looks just like the email (missing the db variables).

Masood Nasir wrote:

Can you debug using:

print $message;

after these lines:

$message = "Here is the contact info:\n";
$message .=$firstname.$lastname."\n";

and see what is the value of $message?

fahhem

that means you aren't getting the database variables right. try printing the firstname and lastname . If that works, I'd do $message="Here is the contact info:\n$firstname $lastname\n"
instead.

Anon

When I print them out right above the form it works fine. It seems that after I hit "Send" in the form the db variables get lost. Including the $id that gets passed in through the query string. You can look at it here, just type in your email address in the fields.

http://209.15.104.59/Admin/tipme.php?id=50