insert form data in an sql and email the content

ddnk77872 · February 12th, 2007, 10:30 PM

hi everyone-

I need help submitting a form that will both submit the data to a sql database and email that info to me and another person. I have set the form up to submit the data to the sql db, but I am not sure how to email that data..

any help would be very much appreciated

Thanks

prashu_hi25 · February 13th, 2007, 03:17 AM

Hi ddnk,

i hope this will help u.

<form method="post" action="sendmail.php">
Fist name :<input type="text" name="fname"/>
Last name :<input type="text" name="lname"/>
Email : <input type="text" name="email"/>
Address : <input type="text" name="address"/>
<input type="submit" value="SUBMIT"/>
</form>

sendmail.php
-------------

    $subject="test";//user subject

    $to = '[email protected]' . ', '.'[email protected]'; // note the comma

    $fname=$_POST[fname];
        $lname=$_POST[lname];
    $address=$_POST[address];
    $from=$_POST[email]; //$user->email;

    $message = <<<MESSAGE
<html>
<body>
  <table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="18%" valign="top"> FIRST NAME : </td>
    <td width="82%">$fname</td>
  </tr>
<tr>
    <td width="18%" valign="top"> LAST NAME : </td>
    <td width="82%">$lname</td>
  </tr>
<tr>
    <td valign="top">EMAIL : </td>
    <td>$from</td>
  </tr>
  <tr>
    <td valign="top">ADDRESS : </td>
    <td>$address</td>
  </tr>

    </table>
</body>
</html>
MESSAGE;

    $mail_mime .= "MIME-Version: 1.0\n";

       $mail_mime .= "Content-Type: text/html;\n";
      $mail_mime .= "Message-ID: <".md5($to)."@$_SERVER[SERVER_NAME]>\n";

    mail($to,$subject,$message,"Reply-to: $from\nFrom: $from\n".$mail_mime);

    echo "The mail was sent!";

i hope this help u... plz let me know if this is what u want....

ddnk77872 · February 13th, 2007, 04:07 AM

Thanks so much for your reply!

I have a php script that sends mail, but I don't know how to BOTH submit the data to my sql database and use a php email action like your "sendmail.php"

I want the form to both submit the data and then email the data submitted to a couple email addresses

I apologize if I am not explaining this well, I am new to php and mysql.

Thanks

prashu_hi25 · February 13th, 2007, 09:47 AM

oh well in sendmail.php you can write mysql query to insert the record into database like mysql_query("insert into tablename(col1, col2, col3, col4,..) values ("$_POST[fname]","$_POST[lname]",...) u can write this code at the top of this sendmail.php page

let me know if it is this what u have been asking for...