0

Hi All,

I am new to this portal, hope some one will guide me with my issue, i wanted to send the data from FORM submit to update in database at the same time it shd go as email,

Any help will be appritiate

thanks
Prashant

5
Contributors
4
Replies
6
Views
7 Years
Discussion Span
Last Post by saad2309
0

Sending data to Email & Database on submit

<?php
require_once('common.php');
$error=array();
if(isset($_POST['email']))
{
  //checking if required fields are not empty
if($_REQUEST['email'] =='')
$error[0] = "Please fill in your email ID";
if($_REQUEST['name'] =='')
$error[count($error)] = "Please fill in your name ";
if($_REQUEST['quantity'] =='')
$error[count($error)] = "Please mention the  Quantity required ";

//checking if the entered email is valid
if(!preg_match('/[\w\-]+@[\w\-]+\.[a-z\.]{2,5}/',$_REQUEST['email']) )
$error[count($error)]=  "Please fill in a valid email ID";

//Inserting into database if no errors are found
if(empty($error))
{
$query = "INSERT INTO `table_name` (
                `name` , `company`,   `email`,`mobile`,				
                ) VALUES ('$_REQUEST[name]','$_REQUEST[company]','$_REQUEST[email]','$_REQUEST[mobile]');                    ";
        mysql_query($query) or die(mysql_error());
		
// Email to the company or as required

$from="email@address.com";
$to =" email@address.com ";
$subject = " Received ";
$message = $_REQUEST[message]; ;
mail($to, $from, $message, $subject);	  
header("location:sent.php?email=$_REQUEST[email]");		
				}
	}
$display_message=implode("<br/>",$error);
// displaying the error messages if any on validating the form values
?>

Jude D’coutho
<EMAIL SNIPPED>

Edited by peter_budo: Adding code tags, removing email and spam message

0

Hello Admin and other PHP experts..!! small question, how to send email to the email IDs, that are listed in a database, i want to sent it as "noreply(at)mydomian(dot)com" and the receipents should be in BCc. And the mail i send is a HTML Advertisement of my service. help me out please... If possible, provide me the code from Line1, i.e,

<?php
$con = mysql_connect("localhost","munna","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// YOUR GIFT SCRIPT FOR ME

mysql_close($con);
?>
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.