Comments form and E-mail

[Anon]

Hello,

I've modified/built a little script to allow users to post comments on each page of my website. After a couple posts, I was thinking it would be nice to get an e-mail with what the person commented on. I have many pages, and if I overlook some vulgarity, I may upset my parents. smile 25 and still worried about the folks...

Okay here is a cut out of my add coding:

<?php
$username = "NOTHINGHERE";
$password = "NOTHINGHERE";
$host = "localhost";
$database = "NOTHINGHERE";

mysql_connect($host,$username,$password) or die("Cannot connect to the database.<br>" . mysql_error());
mysql_select_db($database) or die("Cannot select the database.<br>" . mysql_error());

if(!empty($name)) {
$name = ($name);
$subject = ($subject);
$content = ($content);
$id = ($id);

$sql = "INSERT INTO fpcomments SET fpsubject='$subject', fpname='$name', fpcontent='$content', fpdate=now(), fpid='$id'";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());

echo "<center>Database Updated. <br><br> <a href=\"http://www.jasonthomasfrance.com\">return to main page</a></center>";
} else {
?>

Here is a link to the TXT:
http://www.jasonthomasfrance.com/fpcommentsadd.txt

[Anon]

Sorry,

All the add coding (Missed the form):

<?php
$username = "NOTHINGHERE";
$password = "NOTHINGHERE";
$host = "localhost";
$database = "NOTHINGHERE";

mysql_connect($host,$username,$password) or die("Cannot connect to the database.<br>" . mysql_error());
mysql_select_db($database) or die("Cannot select the database.<br>" . mysql_error());

if(!empty($name)) {
$name = ($name);
$subject = ($subject);
$content = ($content);
$id = ($id);

$sql = "INSERT INTO fpcomments SET fpsubject='$subject', fpname='$name', fpcontent='$content', fpdate=now(), fpid='$id'";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());

echo "<center>Database Updated. <br><br> <a href=\"http://www.jasonthomasfrance.com\">return to main page</a></center>";
} else {
?>

<b>Add Comments to Page</b>
<form name="blogger" method="post" action="<?php echo $PHP_SELF; ?>">
Name: <input type="text" name="name">
<br>
Subject: <input type="text" name="subject">
<br>
Content:
<input type="text" name="content">
<br>
<input type="submit" name="Submit" value="Submit">
</form>
<?php
}
?>

[rob_earl]

bool mail (string to, string subject, string message [, string additional_headers [, string additional_parameters]])

e.g. mail($YourEmail, "Comment posted on: "$SERVER_NAME."[".$subject."]", $content);

[Anon]

Oh man... you lost me...

Add the mail ( string) info below the sql statements or something?

$sql = "INSERT INTO fpcomments SET fpsubject='$subject', fpname='$name', fpcontent='$content', fpdate=now(), fpid='$id'";
mail($MyEmail, $subject, $content);
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());

Then define $MyEmail in the....

Hey it worked!!!! THANK YOU THANK YOU THANK YOU

So here it is:
<?php
$username = "NOTHINGHERE";
$password = "NOTHINGHERE";
$host = "localhost";
$database = "NOTHINGHERE";
$MyEmail = "[e-mail]";

mysql_connect($host,$username,$password) or die("Cannot connect to the database.<br>" . mysql_error());
mysql_select_db($database) or die("Cannot select the database.<br>" . mysql_error());

if(!empty($name)) {
$name = ($name);
$subject = ($subject);
$content = ($content);
$id = ($id);

$sql = "INSERT INTO fpcomments SET fpsubject='$subject', fpname='$name', fpcontent='$content', fpdate=now(), fpid='$id'";
mail($MyEmail, $subject, $content);
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());

echo "<center>Database Updated. <br><br> <a href=\"http://www.jasonthomasfrance.com\">return to main page</a></center>";
} else {
?>

<b>Add Comments to Page</b>
<form name="blogger" method="post" action="<?php echo $PHP_SELF; ?>">
Name: <input type="text" name="name">
<br>
Subject: <input type="text" name="subject">
<br>
Content:
<input type="text" name="content">
<br>
<input type="submit" name="Submit" value="Submit">
</form>
<?php
}
?>

[Anon]

Okay,

This is what I'm using as my mail command:

mail($MyEmail, "Comments on $REQUEST_URI", "Name: $name, Subject: $subject, Comments: $content");

Works great! Thanks for the help!