Form submit to MySQL and mail to admin

[rishirajsingh]

I want to submit my from by mail to admin and also store the data in MySQL.
here is my form code

<form name="form" method="post" action="" onSubmit="return validate2();">
<input type="hidden" name="referer" value="<?=$_SERVER['HTTP_REFERER']?>">

here return validate2() is the function used for form validation and also sends mail to admin by mail() function. After sending mail it directs to thankyou.php where I am using $_POST[""] to store the values in MySQL database.

sendmail($txtName,$txtEmail,$toMail,$sub,$message);
header("location:process.php");

The problem I am facing is that if I use action="thankyou.php" in form tag then mailsend() don't work maybe because validate2() function is not call. but values are stored after in database going to thankyou.php

If i use action="" then thankyou.php is not able to store valur in DB.

Please help, suggest if there is any alternative script which can do all the three from validation, mailing and submitting to database.

[rulian]

Well, validate2() is a javascript function, which I assumes checks for the neccesary inputs in your form. J.S. as far as I know doesnt have a built in funtion Mail() to send mail, so unless your using ajax or some other form of submission to send the variables to a PHP file to send mail, return validate2() wont send an email. what it should do is return true if all conditions are met in the form, or false if a condition fails, this will keep the form from submitting if a user puts in the wrong informaiton.

What you should do is point action="" to the script that will both send the email and store the information in the database, if action="" is empty then the file in use should peform the action

so lets take your given form and assumes it returns true

<form name="form" method="post" action="" onSubmit="return validate2();">
<input type="hidden" name="referer" value="<?=$_SERVER['HTTP_REFERER']?>">

what you can do is this

<?PHP
if (isset($_POST["referer"])) 
{
/// assuming a simple insert command
$SQL="INSERT INTO `mysubmitdb` VALUES (NULL, '".$_POST["referer"]."')";

$mail_header="FROM: [e-mail]"; 
$mail_to="[e-mail]"; 
$mail_subject="This is my subject"; 
$mail_body="The referer is : ".$_POST["referer"]; 

if (!mysql_query($SQL)) echo mysql_error(); 
elseif (!mail($mail_to, $mail_subject, $mail_body, $mail_header)) echo "cannot send email"; 
else echo "submission successfull"; 
}
?>

in the form proccessing script, this should insert the new row and send and email using the same information

[rishirajsingh]

Thanks rulian,
I have edited the database code suggested by you as per my requirement and now its working really fine.

I am very thankful to you.