Need help mailing someone based on a form variable

A

Anonymous

Guest
Hi all

I'll try simplify my problem as much as I can so you can understand me. I have a form that takes the users input & puts it into a mysql DB, 1 of the fields in the form is a dropdown menu containing names that are being taken from a table in the DB.
My form is submitted to a file called process.php, here is my process.php file
Code: 
<?php
include("config.php");
$dbh = mysql_connect ($dbhost, $dbuname, $dbpass) or die ( 'I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($dbname) or die (mysql_error());
$result = mysql_query ("INSERT INTO travel (prn, date, name, dir, purpose, sponsor, refund, what_refundable, flight_cost, subsis_cost, no_nights, depart_location, depart_time, out_flight, via_location, via_arrive, via_depart, arrive_location, arrive_time, arrive_flight, return_location, return_time, return_flight, via_location2, via_arrive2, via_depart2, depart_time2, arrive_time2, flight_num2, uname) values ('".$_POST['prn']."','".$_POST['date']."','".$_POST['name']."','".$_POST['dir']."',
'".$_POST['purpose']."','".$_POST['sponsor']."','".$_POST['refund']."',
'".$_POST['what_refundable']."','".$_POST['flight_cost']."',
'".$_POST['subsis_cost']."','".$_POST['no_nights']."',
'".$_POST['depart_location']."','".$_POST['depart_time']."',
'".$_POST['out_flight']."','".$_POST['via_location']."','".$_POST['via_arrive']."',
'".$_POST['via_depart']."','".$_POST['arrive_location']."',
'".$_POST['arrive_time']."','".$_POST['arrive_flight']."',
'".$_POST['return_location']."','".$_POST['return_time']."',
'".$_POST['return_flight']."','".$_POST['via_location2']."',
'".$_POST['via_arrive2']."','".$_POST['via_depart2']."',
'".$_POST['depart_time2']."','".$_POST['arrive_time2']."',
'".$_POST['flight_num2']."','".$_POST['uname']."')", $dbh);


$result = mysql_query ("select id, name, email from managers");
while ($row = mysql_fetch_array($result)) {
if ($dir = $name);
echo "$email";
mail ("$email", "test", "content", "test");
}
?>
What I want to do is get the value of "$_POST['dir']" & email the address that corresponds to that variable in my managers table.

Example, if I have bob as a user & bob@bob.com in my managers DB & a user selects the name bob in the form, I want something mailed to bob's email which is bob@bob.com.

Thanks in advance for any replies, all input & suggestions welcome :wink:
 
Hi again, the problem was you were referring to the email pulled from the database as $email when it should have been $row as mysql_fetch_array makes an array of the information where the [key] is the name of the db table column. This script should work and also ive change your select function to only pull the details out if it matches with the name submitted on your form.


<?php
include("config.php");
$dbh = mysql_connect ($dbhost, $dbuname, $dbpass) or die ( 'I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($dbname) or die (mysql_error());

$result = mysql_query ("INSERT INTO travel (prn, date, name, dir, purpose, sponsor, refund, what_refundable, flight_cost, subsis_cost, no_nights, depart_location, depart_time, out_flight, via_location, via_arrive, via_depart, arrive_location, arrive_time, arrive_flight, return_location, return_time, return_flight, via_location2, via_arrive2, via_depart2, depart_time2, arrive_time2, flight_num2, uname) values ('".$_POST['prn']."','".$_POST['date']."','".$_POST['name']."','".$_POST['dir']."',
'".$_POST['purpose']."','".$_POST['sponsor']."','".$_POST['refund']."',
'".$_POST['what_refundable']."','".$_POST['flight_cost']."',
'".$_POST['subsis_cost']."','".$_POST['no_nights']."',
'".$_POST['depart_location']."','".$_POST['depart_time']."',
'".$_POST['out_flight']."','".$_POST['via_location']."','".$_POST['via_arrive']."',
'".$_POST['via_depart']."','".$_POST['arrive_location']."',
'".$_POST['arrive_time']."','".$_POST['arrive_flight']."',
'".$_POST['return_location']."','".$_POST['return_time']."',
'".$_POST['return_flight']."','".$_POST['via_location2']."',
'".$_POST['via_arrive2']."','".$_POST['via_depart2']."',
'".$_POST['depart_time2']."','".$_POST['arrive_time2']."',
'".$_POST['flight_num2']."','".$_POST['uname']."')", $dbh);


$result = mysql_query ("select id, name, email from managers WHERE name = '$dir'");
while ($row = mysql_fetch_array($result)) {
echo "$row[email]";
mail ("$row[email]", "test", "content", "test");
}
?>

Let me know if you have any problems...
 
if you want to make teh email message a little cooler, use the following script instead:
Code: 
mail("$row[email]"."<".$row[name]".">",Subject, Messages, "From: ".Your email."<".your name.">");

by the way, what does invalid session mean. i get it sometimes when i try to post a reply here
 
Mammal, thank you very, very much :mrgreen: :mrgreen: :mrgreen:
I just had a big long reply for you to tell you it wasnt working but when I changed $_POST['name'] to $name it worked :D
Thanks to you things are making alot more sense !

Ihoss, thanks I'll try that. As for your invalid session, could it be that you went to reply to a message, got disconnected from the internet & came back to reply to the message with a different IP address ?? that happened me yesterday.

Cheers
amp2000
 
No worries amp. let me know if you get stuck in future...
 
You must log in or register to reply here.
Back
Top