Insert data to MySQL, then send an e-mail. help pls !!

[desmond_ckl]

Hi there, hope u guys able to help.

 

I'm have created a enquiry form where I want these actions to run when a button is submitted:

 

1.  Insert data from form fields into my database

 

2.  When data is inserted into database, then send an e-mail (multiple email user) to the address with the form fields. The e-mail is carrying the form fields.

 

so ...what I need now is how to send the form field to email. Insert the data into my table in my database,then send en e-mail.

 

<? 
// Connects to your Database 

mysql_connect("xxxxxx","xxxxxx","xxxxxx") or die(mysql_error()); 

mysql_select_db("xxxxxx") or die(mysql_error()); 



// now we insert it into the database

    $insert = "INSERT INTO enquiry (name, email, cont_number, subject, msg)

          VALUES ('".$_POST['name']."', '".$_POST['email']."', '".$_POST['cont_number']."',
               '".$_POST['subject']."','".$_POST['msg']."')";

    $add_member = mysql_query($insert);

    ?>



<?php
function error_bool($error, $field) { 
         if($error[$field]) { 
             print("<td style=color:red>"); 
         } 
        else { 
            print("<td>"); 
        } 
    } 

function show_form() { 
global $HTTP_POST_VARS, $print_again, $error; 
?> 



<h2 align="center"> Enquiry Form</h2>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
   <table align="center" cellpadding="3">
    <tr> 
     <?php error_bool($error, "name"); ?> Name </td> 
      <td>:<input name="name" type="text" id="name"  SIZE="33" value="<? echo $_POST["name"]; ?>"></td> 
    </tr> 
    <tr> 
      <?php error_bool($error, "email"); ?> Email </td> 
      <td>:<input name="email" type="text" id="email" SIZE="33" value="<? echo $_POST["email"]; ?>"></td> 
    </tr> 
    
    
    <tr><td>Contact No. </td><td>

:<input type="text" name="cont_number"  SIZE="33" maxlength="10">

</td></tr>

<tr><td>Subject </td><td>

:<input type="text" name="subject"  SIZE="33"  maxlength="25">

</td></tr>



<tr><td>Your Message :</td><td>

<textarea name="msg" cols="27" rows="5"
   wrap="virtual"></textarea>

</td></tr>
    

    <tr> 
      <td><th colspan=4 align="right">
      <input type="reset" value="CLEAR"><input type="submit" name="Submit" value="Submit"></td> 
      </th><td> </td> 
    </tr> 
  </table> 
</form> 
<? 
} 
if(isset($_POST["Submit"])) { 
    check_form(); 
} else { 
    show_form(); 
} 

function check_email_address($email) { 
  // First, we check that there's one @ symbol, and that the lengths are right 
  if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email)) { 
    // Email invalid because wrong number of characters in one section, or wrong number of @ symbols. 
    return false; 
  } 
  // Split it into sections to make life easier 
  $email_array = explode("@", $email); 
  $local_array = explode(".", $email_array[0]); 
  for ($i = 0; $i < sizeof($local_array); $i++) { 
     if (!ereg("^(([A-Za-z0-9!#$%&'*+/=?^_`{|}~-][A-Za-z0-9!#$%&'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$", $local_array[$i])) { 
      return false; 
    } 
  } 
  if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1])) { // Check if domain is IP. If not, it should be valid domain name 
    $domain_array = explode(".", $email_array[1]); 
    if (sizeof($domain_array) < 2) { 
        return false; // Not enough parts to domain 
    } 
    for ($i = 0; $i < sizeof($domain_array); $i++) { 
      if (!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])|([A-Za-z0-9]+))$", $domain_array[$i])) { 
        return false; 
      } 
    } 
  } 
  return true; 
} 


function check_form() 
{ 
global $HTTP_POST_VARS, $error, $print_again; 
$error['name'] = false; 
    if($_POST["name"]=="") { 
        $error['name'] = true; 
         $print_again = true; 
        $message="The name field is empty<br>"; 
    } 
    if(!check_email_address($_POST['email'])) { 
        $error['email'] = true; 
         $print_again = true; 
        $message.="Either Field Empty or Invalid Email ID <br>"; 
    } 
     if($print_again) { 
         show_form(); 
        
       } else { 
        show_form(); 
           $message="Thank You !! <br> 
        Form has been submitted"; 
       } 
   echo "$message"; 
} 

?> 

</body> 
</html>

 

 

 

How do i do this? Thank you in advanced and sorry for bad English.

 

Best regards,

Desmond