[Resolved] trying to pass form info to db and email

tazdog

Is there a good place or tutorial to help me in this..

I can get the data into the db now, but unsure how to get what fields to multiple email addresses..

thanks..

Scott

kender

what kind of data,
you can probably do this...

<?

$priority = 0;							// Should the email be sent with priority? (0 = No, 1 = Yes)
$toemail = "USER@DOMAIN.COM, [email]USER2@DOMAIN.COM[/email]";	 		// Who do you want to send the email to?

$mail = "
<html>
<head>
  <title>The contents of the form submitted at SITENAME</title>
</head>
<body>	
Here are the contents of the form:<br><br>";
foreach ($_POST as $key => $value){
	$mail .= "<b>$key</b>: ".nl2br($value)." <br>";
}
$mail .= "
</body>
</html>
";

$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\n";
if ($priority){
	$headers .= "X-Priority: 1\n";
	$headers .= "X-MSMail-Priority: High\n";
}
	$headers .= "X-Mailer: php\n";
  	$headers .= "From: \"$_POST[name]\" <$_POST[email]>\n";

   mail ($toemail, "Form sent from: SITENAME", $mail, $headers);


}

?>

this assumes that your form contains the fields name and email for the user to enter his coresponding data and your form method is post

tazdog

Here is the code I have now, how would this integrate with what you have shown..
Sorry rather new to this and learning
thanks
Scott

$dbcxn = mysql_connect("$host","$user","$pswd");
	if (!$dbcxn) die ("Could not connect MySQL");
	mysql_select_db($dbname,$dbcxn) or die ("Could not open database");



$sql = "INSERT INTO Pilots (PilotID, Name, State, Country, Email, Passwd, BirthDate, Vatsim, BVIAccount, HubID) VALUES ('$PilotID', '$fullname', '$state', '$country', '$email', '$passwd', '$birthdate', '$vatsim', '$bviaccount', '$hub')";
$result = mysql_query($sql);
echo "<b>Thank you!</b>&nbsp;Your Information has been entered.";

kender

how are you getting the values?

from a form? where they enter the data?

ie: where is the code that says..
$fullname = XXXXXX; is it a $_GET from a form submitted?

tazdog

Values are coming from a form on a different page
and its a post value..

kender

<?

$priority = 0;							// Should the email be sent with priority? (0 = No, 1 = Yes)
$toemail = "".$_POST['Email'].", [email]USER2@DOMAIN.COM[/email]";	 		// Who do you want to send the email to?

$mail = "
<html>
<head>
  <title>The contents of the form submitted at SITENAME</title>
</head>
<body>	
Here are the contents of the form:<br><br>";
foreach ($_POST as $key => $value){
	$mail .= "<b>$key</b>: ".nl2br($value)." <br>";
}
$mail .= "
</body>
</html>
";

$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\n";
if ($priority){
	$headers .= "X-Priority: 1\n";
	$headers .= "X-MSMail-Priority: High\n";
}
	$headers .= "X-Mailer: php\n";
  	$headers .= "From: \"$_POST[name]\" <$_POST[Email]>\n";

   mail ($toemail, "Form sent from: SITENAME", $mail, $headers);

}

$dbcxn = mysql_connect("$host","$user","$pswd"); 
    if (!$dbcxn) die ("Could not connect MySQL"); 
    mysql_select_db($dbname,$dbcxn) or die ("Could not open database"); 

   $sql = "INSERT INTO Pilots (PilotID, Name, State, Country, Email, Passwd, BirthDate, Vatsim, BVIAccount, HubID) VALUES ('$PilotID', '$fullname', '$state', '$country', '$email', '$passwd', '$birthdate', '$vatsim', '$bviaccount', '$hub')"; 
    $result = mysql_query($sql); 
    echo "<b>Thank you!</b>&nbsp;Your Information has been entered.";


?>

If your database is posting correctly as is written, this should work, just adjust your email variables

tazdog

I appreciate the help and later this afternoon I will give this a shot..

thanks and I will post to let ya know how it went..

Scott

tazdog

This is what I tried and it worked to the DB but not to email..
Since this is new to me, did I miss something..

thanks
Scott

<? 
//Db CXN Info Here

$priority = 0;				 // Should the email be sent with priority? (0 = No, 1 = Yes) 
$toemail = "".$_POST['Email'].", [email]email@domain.com[/email]";             // Who do you want to send the email to? 

$mail = " 
<html> 
<head> 
  <title>The contents of the form submitted at SITENAME</title> 
</head> 
<body>     

Here are the contents of the form:<br><br>"; 
foreach ($_POST as $key => $value){ 
    $mail .= "<b>$key</b>: ".nl2br($value)." <br>"; 
} 
$mail .= " 
</body> 
</html> 
"; 

$headers = "MIME-Version: 1.0\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\n"; 
if ($priority){ 
    $headers .= "X-Priority: 1\n"; 
    $headers .= "X-MSMail-Priority: High\n"; 
} 
    $headers .= "X-Mailer: php\n"; 
      $headers .= "From: \"$_POST[name]\" <$_POST[Email]>\n"; 

   mail ($toemail, "Form sent from: SITENAME", $mail, $headers); 




$dbcxn = mysql_connect("$host","$user","$pswd");  

    if (!$dbcxn) die ("Could not connect MySQL");  

    mysql_select_db($dbname,$dbcxn) or die ("Could not open database");  

   $sql = "INSERT INTO Pilots (PilotID, Name, State, Country, Email, Passwd, BirthDate, Vatsim, BVIAccount, HubID) VALUES ('$PilotID', '$fullname', '$state', '$country', '$email', '$passwd', '$birthdate', '$vatsim', '$bviaccount', '$hub')";  

    $result = mysql_query($sql);  

    echo "<b>Thank you!</b>&nbsp;Your Information has been entered."; 


?>

kender

change this line

$toemail = "".$_POST['Email'].", [email]email@domain.com[/email]";             // Who do you want to send the email to?

to your email address

or at least the email@domain.com one, the $_POST[] should go to the person who submitted

of course, you realize, you are sending you the registerd persons password

tazdog

I should have clarified that in my last post..

I did have my email in there and a different email (but goes to me) as the form email...

kender

try breaking it up

$toemail = $_POST['Email'];
$toemail .= ", [email]email@domain.com[/email]";             // Who do you want to send the email to?

i dont see anyhting else with the rest
unless you are on a server where mail(); doesnt work

tazdog

its been a long day
I forgot to say (after relooking at the code) that when I first ran this earlier.. I was getting an error.

It was with a }

I took it out and the info still writes to the DB but I bet that is why the mail isnt working..

trying it now with the split lines

edit: Still no email
Do you want me to repost the current code and show you where I removed that bracket }

Scott

Here it is:

mail ($toemail, "Form sent from: SITENAME", $mail, $headers); 

} 

$dbcxn = mysql_connect("$host","$user","$pswd");

Thats the bracket that was giving me an error

kender

the whole page, except the dbconnect info

tazdog

$priority = 0;				 // Should the email be sent with priority? (0 = No, 1 = Yes) 
$toemail = $_POST['Email']; 
$toemail .= ", [email]phpdev@tazdog.com[/email]";

$mail = " 
<html> 
<head> 
  <title>The contents of the form submitted at SITENAME</title> 
</head> 
<body>     

Here are the contents of the form:<br><br>"; 
foreach ($_POST as $key => $value){ 
    $mail .= "<b>$key</b>: ".nl2br($value)." <br>"; 
} 
$mail .= " 
</body> 
</html> 
"; 

$headers = "MIME-Version: 1.0\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\n"; 
if ($priority){ 
    $headers .= "X-Priority: 1\n"; 
    $headers .= "X-MSMail-Priority: High\n"; 
} 
    $headers .= "X-Mailer: php\n"; 
      $headers .= "From: \"$_POST[name]\" <$_POST[Email]>\n"; 

   mail ($toemail, "Form sent from: SITENAME", $mail, $headers); 


$dbcxn = mysql_connect("$host","$user","$pswd");  

    if (!$dbcxn) die ("Could not connect MySQL");  

    mysql_select_db($dbname,$dbcxn) or die ("Could not open database");  

   $sql = "INSERT INTO Pilots (PilotID, Name, State, Country, Email, Passwd, BirthDate, Vatsim, BVIAccount, HubID) VALUES ('$PilotID', '$fullname', '$state', '$country', '$email', '$passwd', '$birthdate', '$vatsim', '$bviaccount', '$hub')";  

    $result = mysql_query($sql);  

    echo "<b>Thank you!</b>&nbsp;Your Information has been entered."; 


?>

kender

this isnt the page where you get the posted info?

where do you convert $_POST['Email'] to $email ?

tazdog

panamva.com/form.html

kender

do me a favor, .zip form.html, and enter.php and attach it

tazdog

I created a new page so the dbcxn would not be there..

If for some reason you need that, then send me an email @ phpdev @ tazdog dot com

and I will send to you..

thanks for all your help..

Scott

kender

radical idea
try this, without the other 2 files (just use this)

save as form.php

<?

if (isset($_GET['action'])){$action = $_GET['action'];
if ($_GET['action'] == "send"){sendmail();}}
else {mailform();}

function mailform(){

?>
<html>
<head>
<title> php form test </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="panamva.css" type="text/css">
</head>

<body>
<p align="center"><img border="0" src="images/layout_r2_c2.jpg" width="279" height="156" alt="Pan American Virtual Airlines, Virtual Flight Simulation Airline"><img border="0" src="images/layout_r2_c3.jpg" width="218" height="156"alt="Pan American Virtual Airlines, Virtual Flight Simulation Airline"><img border="0" src="images/layout_r2_c4.jpg" width="263" height="156"alt="Pan American Virtual Airlines, Virtual Flight Simulation Airline"></p>
<br>
<br>
<p align="center">
<form action="./form.php?action=send" method="post" enctype="multipart/form-data">
    <table align="center" width="500" border="1" cellspacing="0" cellpadding="0">
        <tr>
            <td width="229" class="formfont">Full Name:</td>
            <td width="265" class="forminput"><input type="text" name="fullname" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">State:</td>
            <td class="forminput"><input type="text" name="state" size="5" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Country (2 letter abbr.):</td>
            <td class="forminput"><input type="text" name="country" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">VATSIM or IVAO ID: </td>
            <td class="forminput"><input type="text" name="vatsim" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr></tr>
            <td class="formfont">BVI Account # ([url]www.vastock.com[/url]) </td>
            <td class="forminput"><input type="text" name="bviaccount" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Hub (domicile) Preference: </td>
            <td class="forminput"><input type="text" name="hub" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Desired Password: </td>
            <td class="forminput"><input type="text" name="passwd" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Email:</td>
            <td class="forminput"><input type="text" name="email" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Birth Date (mm/dd/yyyy) </td>
            <td class="forminput"><input type="text" name="birthdate" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Flight Hours you Would Like to Claim:</td>
            <td class="forminput"><input type="text" name="prevhours" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td class="formfont">Link to verify the Hours: </td>
            <td class="forminput"><input type="text" name="linkverify" size="30" style="font-family: Tahoma; font-size: 8pt; background-color: #E6E6E6; border: 1 solid #003366"></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2" valign="top" align="center">By submitting this application the following statements are true;<br>
			<br>
			I Agree with Pan Am Virtual Airlines Terms and Conditions.<br>
			I have read and I understand the Pan Am Virtual Airlines Pilot Handbook.<br>
			<br>
			<input type="submit" name="submit" value="Submit Pilot Application"></td>
        </tr>
    </table>
</form>
</p>
</body>
</html>
<?
}

function sendmail(){

$priority = 0;							// Should the email be sent with priority? (0 = No, 1 = Yes)
$toemail = $_POST['email'];	 			// Who do you want to send the email to?
$toemail .= ", [email]second@email.add[/email]";		// Who do you want to send the email to?

$mail = "
<html>
<head>
  <title>The contents of the form submitted at WEBSITE</title>
</head>
<body>	
Here are the contents of the form:<br><br>";
foreach ($_POST as $key => $value){
	$mail .= "<b>$key</b>: ".nl2br($value)." <br>";
}
$mail .= "
</body>
</html>
";

$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\n";
if ($priority){
	$headers .= "X-Priority: 1\n";
	$headers .= "X-MSMail-Priority: High\n";
}
	$headers .= "X-Mailer: php\n";
  	$headers .= "From: \"$_POST[fullname]\" <$_POST[email]>\n";

   mail ($toemail, "Form sent from: WEBSITE", $mail, $headers);

$dbcxn = mysql_connect("$host","$user","$pswd");  

    if (!$dbcxn) die ("Could not connect MySQL");  

    mysql_select_db($dbname,$dbcxn) or die ("Could not open database");  

   $sql = "INSERT INTO Pilots (PilotID, Name, State, Country, Email, Passwd, BirthDate, Vatsim, BVIAccount, HubID) VALUES ('$PilotID', '$fullname', '$state', '$country', '$email', '$passwd', '$birthdate', '$vatsim', '$bviaccount', '$hub')";  

    $result = mysql_query($sql);  

echo 'Thank you for your submission.<br /><br />'.$mail.'<br />

</body>
</html>';
}

dofooter();
?>

you will need to enter dbconnect info

tazdog

Ok here is an update:

I created that new page. called it form.php

I do show 1 error before I process the form and its at the bottom and it says:

Fatal Error: Call to undefined Function: dofooter() in PATH/form.php on line 148

Then once I process the form, it seems to work as it displays the form results on the page but it does not, email and it does not enter the info into the db..

panamva.com/test2.php is just a display db page..

thanks for all your help..

Scott