how to send gmail and save in mysql using xampp in php

[leomar]

#using the code how can i save the data in mysql and send the data.???#

<?
//edit these lines
$your_name="";
$your_email="leomarogie@gmail.com";
$your_web_site_name="";
?>

<?php 
//If the form is submitted
if(isset($_POST['name'])) {

		//Check to make sure that the name field is not empty
		if(trim($_POST['name']) === '') {
			$hasError = true;
		} else {
			$name = trim($_POST['name']);
		}
		
		//Check to make sure sure that a valid email address is submitted
		if(trim($_POST['email']) === '')  {
			$hasError = true;
		} else if (!trim("^[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,4}$", trim($_POST['email']))) {
			$hasError = true;
			$errorMessage = "Please enter a valid email address!";
		} else {
			$email = trim($_POST['email']);
		}

		//Check to make sure that the phone field is not empty
		if(trim($_POST['phone']) === '') {
			$hasError = true;
		} else {
			$phone = trim($_POST['phone']);
		}

		//company name
		$company_name = trim($_POST['company_name']);

		//company url
		$company_url = trim($_POST['company_url']);

			
		//Check to make sure comments were entered	
		if(trim($_POST['message']) === '') {
			$hasError = true;
		} else {
			if(function_exists('stripslashes')) {
				$comments = stripslashes(trim($_POST['message']));
			} else {
				$comments = trim($_POST['message']);
			}
		}
		
		//If there is no error, send the email
		if(!isset($hasError)) {

			$emailTo = $your_email;
			$subject = 'Contact Form Submission from '.$name;
			
			//message body 
			$body  ="Name: $name \n\n";
			$body .="Email: $email \n\n";
			$body .="Phone:$phone\n\n";
			$body .="Company Name:$company_name\n\n";
			$body .="Company Url:$company_url \n\n";
			$body .="Message: $comments";


			$headers = 'From: '.$your_web_site_name.' <'.$emailTo.'>' . "\r\n" . 'Reply-To: ' . $email;
			
			mail($emailTo, $subject, $body, $headers);

			$emailSent = true;
	}
} 


		
?>

<?php if(isset($emailSent) == true) { ?>
	<div class="ok_box">
		<h3>Thanks, <?php echo $name;?></h3>
		<p>Your email was successfully sent. We will be in touch soon.</p>
	</div>
<?php } ?>

<?php if(isset($hasError) ) { ?>
	<div class="error_box">
		There was an error submitting the form.
		<br />
		<?php echo $errorMessage;?>
	</div>
<?php } ?>

[jdstankosky]

This is actually pretty simple. First thing you need is a database. Create a table for this email form, and make sure it has a column for each field you want to store information for.

You can then just execute a query to insert all your information into the table as a new row.

In addition to the information you want to store, I would include 2 other columns, an id column (populate with uuid() ) and a date_time column (populate with now() ) to keep track of all the emails you store.