Jump to content


Photo

a php question


  • Please log in to reply
2 replies to this topic

#1 fogofogo

fogofogo
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 25 April 2006 - 01:12 PM

Hello all,

I have a php script that processes a web form, sends and email and insert the information into a MySQL database. It all works fine, but I am trying to make some modifications to it and I'm not sure how to do it. I keep making changes and breaking it every time!

The first thing I am trying to do is change how the email is sent. When the email is sent to the recipient, the sender email address seems to be generated by the web server that the script is sitting on. I was hoping to change it to the email that the user entered with the form ($email). any ideas how this is done?

Heres what me code looks like:

<?php


// read in variables from form


$to = $to;
$from = $from;
$email = $email;
$subject = "Registration";
$address = $address;
$middlename = $middlename;
$lastname = $lastname;
$dateofbirth = $dateofbirth;
$town = $town;
$county = $county;
$country = $country;
$postcode = $postcode;
$telephone = $telephone;
$nickname = $nickname;
$password = $password;
$bigslickprivate = $bigslickprivate;
$bigslickplayers = $bigslickplayers;
$bigslickpreffered = $bigslickpreffered;
$today = date ("l, F jS Y");



// database stuff



$dbhost = 'host in here ';
$dbuser = 'coolhan_admin';
$dbpass = 'wordword';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'coolhan_bigslickreg';
mysql_select_db($dbname);

$sql = "INSERT INTO players (dfirstname,dmiddlename,dlastname,demail, ddateofbirth, daddress, dtown, dcounty, dcountry, dpostcode, dtelephone, dnickname, dpassword, dprivateclub, dplayerclub, dpreferredclub) VALUES ('$from','$middlename','$lastname','$email','$dateofbirth','$town','$county','$country', '$postcode','$telephone','$nickname','$password','$bigslickprivate','$bigslickprivate','$bigslickplayers','$bigslickpreffered')";
$result = mysql_query($sql);



// check that required forms are complete



if (($to == "") || ($from == "") || ($email == "") || ($subject == "") || ($address == "") || ($middlename == "") || ($lastname == "") || ($dateofbirth == "") || ($town == "") || ($county == "") || ($country == "") || ($postcode == "") || ($telephone == "") || ($nickname == "") || ($password == "") || ($bigslickprivate == "") || ($bigslickplayers == "") || ($bigslickpreffered == "")) {
        readfile("blankfields.html");
       exit;
       } else {
       }



// check email format



if (($email != "")) {
        $locationofat = strpos($email, '@');
        $locationofdot = strrpos($email, '.');
        if (($locationofat == "0") || ($locationofdot < $locationofat) || $locationofdot == "0") {
                readfile("bademail.html");
                exit;
                } else {
                }
}



// create the email message



$msg .= "PLEASE FORWARD THIS EMAIL TO bigslick@website.com \n\n\n";

if ($from != "") {
     $msg .= "First Name : $from\n";
     }
if ($middlename != "") {
     $msg .= "Middle Name : $middlename\n";
     }
if ($lastname != "") {
     $msg .= "Last Name : $lastname\n";
     }
if ($email != "") {
     $msg .= "Email : $email\n";
     }
if ($dateofbirth != "") {
     $msg .= "Date of Birth : $dateofbirth\n";
     }
$msg .= "Address : $address\n";

if ($town != "") {
     $msg .= "Town : $town\n";
     }
if ($county != "") {
     $msg .= "County : $county\n";
     }
if ($country != "") {
     $msg .= "Country : $country\n";
     }
if ($postcode != "") {
     $msg .= "Postcode : $postcode\n";
     }
if ($telephone != "") {
     $msg .= "Telephone : $telephone\n";
     }
if ($nickname != "") {
     $msg .= "Nick Name : $nickname\n";
     }
if ($password != "") {
     $msg .= "Password : $password\n";
     }
if ($bigslickprivate != "") {
     $msg .= "Join the Big Slick Private Members club? : $bigslickprivate\n";
     }
if ($bigslickplayers != "") {
     $msg .= "Join the Big Slick Players Club? : $bigslickplayers\n";
     }
if ($bigslickpreffered != "") {
     $msg .= "Obtain membership to Big Slick's preferred members club? : $bigslickpreffered\n\n";
     }
$msg .= "Sent : $today\n";



// send the email



$mailheaders = "BigSlick Site registration ( $from )<> \n";
$mailheaders .= "Reply-To: $email\n\n";

mail($to, $subject, $msg, $mailheaders);



// pull in the thank you file



readfile("thankyou.html");

exit;

?>


Thanks guys,

John

#2 wisewood

wisewood
  • Members
  • PipPipPip
  • Advanced Member
  • 226 posts
  • LocationRotherham, England

Posted 25 April 2006 - 01:51 PM

$headers .= "From: \"".$senders_email."\" <".$senders_email.">\n";
mail($recipient, $subject, $message, $headers);


hope this helps.
wisewood: proven fact, I am both wise, and wooden.

#3 fogofogo

fogofogo
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 25 April 2006 - 02:11 PM

[!--quoteo(post=368436:date=Apr 25 2006, 08:51 AM:name=wisewood)--][div class=\'quotetop\']QUOTE(wisewood @ Apr 25 2006, 08:51 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
$headers .= "From: \"".$senders_email."\" <".$senders_email.">\n";
mail($recipient, $subject, $message, $headers);
hope this helps.
[/quote]

Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users