View difference between Paste ID: xJyRm0f9 and e5X7667S

 <?php session_start();
 
 $con = mysql_connect("172.16.4.23","reportswo","writeonly");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }
 
 
 $date = date('Y-m-d');
 $quote_type = $_POST["auto"];
 
 echo "you got here";
 
 mysql_select_db("reports", $con);
-$sql="INSERT INTO tracydriscoll (date, contactName, address, city, state, zip, email, quote_type)
+$sql="INSERT INTO tracydriscoll (date, contactName, address, city, state, zip, email, quote_type) VALUES ('".$date."','".$_POST['contactName']."','".$_POST['address']."','".$_POST['city']."','".$_POST['state']."','".$_POST['zip']."','".$_POST['email']."','".$_POST['quote_type']."')";
-VALUES
+
-('$_POST[date]','$_POST[contactName]','$_POST[address]','$_POST[city]','$_POST[state]','$_POST[zip]','$_POST[email]','$_POST[quote_type]')";
+
   {
   die('Error: ' . mysql_error());
   }
 echo "1 record added";
 
 mysql_close($con);
 
     ini_set('display_errors', 'On');
     error_reporting(E_ALL);
 
 
     /* *********** FUNCTIONS ****************** */
 
     function checkit($contactName) {
             return(str_replace(array("\r", "\n", "%OA", "%oa", "%OD", "%od", "Content-Type:","BCC:","bcc:"), "", $contactName));
     }
 
     function cleanUp($data) {
        $data = trim(strip_tags(htmlspecialchars($data)));
        return $data;
     }
 
     $referer=$_SERVER['HTTP_REFERER'];
     #print($referer);
     $refsplit=explode("?",$referer);
     #if($refsplit[0]=='http://www.tracy-driscoll.com/landingpages/auto/quote2.html'){
 
     $errorFields = array();
 
     if (isset($_POST['submit'])) {
 		echo "got to this stage<br />";
 		$contactName =cleanUp($_POST['contactName']);
 		$address=cleanUp($_POST['address']);
 		$city=cleanUp($_POST['city']);
 		$state=cleanUp($_POST['state']);
 		$zip=cleanUp($_POST['zip']);
 		$phone=cleanUp($_POST['phone']);
 		$email=cleanUp($_POST['email']);
 		$dobMonth=cleanUp($_POST['dobMonth']);
 		$dobDay=cleanUp($_POST['dobDay']);
 		$dobYear=cleanUp($_POST['dobYear']);
 		$driversLicense=cleanUp($_POST['driversLicense']);
 		$doYou=cleanUp($_POST['doYou']);
 		$bodilyInjury=cleanUp($_POST['bodilyInjury']);
 		$propertyDamage=cleanUp($_POST['propertyDamage']);
 		$medicalPayments=cleanUp($_POST['medicalPayments']);
 		$comprehensiveDeductible=cleanUp($_POST['comprehensiveDeductible']);
 		$collisionDeductible=cleanUp($_POST['collisionDeductible']);
 		$rentalReimbursement=cleanUp($_POST['rentalReimbursement']);
 		$towing=cleanUp($_POST['towing']);
 		$v1year=cleanUp($_POST['v1year']);
 		$v1make=cleanUp($_POST['v1make']);
 		$v1vin=cleanUp($_POST['v1vin']);
 		$v2year=cleanUp($_POST['v2year']);
 		$v2make=cleanUp($_POST['v2make']);
 		$v2vin=cleanUp($_POST['v2vin']);
 		$otherDrivers=cleanUp($_POST['otherDrivers']);
 		$howMany=cleanUp($_POST['howMany']);
 		$permission=cleanUp($_POST['permission']);
 		$ssn=cleanUp($_POST['ssn']);
 
 		if (!strlen($contactName)) array_push($errorFields, 'contactName');
 		if (!strlen($email)) array_push($errorFields, 'email');
 		if (!strlen($phone)) array_push($errorFields, 'phone');
 		echo "got here step 2";
 
 		#check for valid e-mail address
 		if (!preg_match("^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]+)*$^",$email)) {
 				 array_push($errorFields, 'email');
 				 die("Invalid Email Address.  Email will not be sent");
 		}
 
     #die if there are line returns in the name or e-mail field
             //if (!preg_match("\r",$contactName) || !preg_match("\n",$contactName) || !preg_match("\r",$email) || !preg_match("\n",$email)){
                      //die("Why ?? :(");
             //}
 
 		if (!count($errorFields)) {
 			echo "no errors";
 			#replace manual line returns in e-mail field
 			$email = preg_replace("([\r\n])", "", $email);
 
 			#prevent BCC
 			$find = "[content-type|Content-Type|bcc:|cc:|viagra|levitra|pariscialis|angelfire|freewebpages|xxx|gay|sluts|incest|hardcore|anal]";
 			#$find2 = "[http:]";
 			if (preg_match($find, $contactName) || preg_match($find, $email) || preg_match($find, $phone) || preg_match($find, $city) || preg_match($find, $state) || preg_match($find, $zip)) {
 					print("<p>No meta/header injections, please.  E-mail will not be sent.</p>");
 			   exit;
 			}
 
 /* *********** First email to Don, Teresa and TD ****************** */
 
 require_once('class.phpmailer.php');
 include_once("class.smtp.php"); // optional, gets called from within class.phpmailer.php if not already loaded
 
 $mail = new PHPMailer(); // the true param means it will throw exceptions on errors, which we need to catch
 
 $mail->IsSMTP(); // telling the class to use SMTP
 
 try{
 
 	$mail->Host       = "172.16.4.18"; // SMTP server
 	$mail->Port       = 25;
 	$mail->SMTPAuth = true;
 	$mail->Username   = "tracy1@oldgate.org"; // SMTP account username
 	$mail->Password   = "driscoll2";
 	$mail->SMTPDebug = 0; // enables SMTP debug information (for testing)
 
 	$mail->AddReplyTo(stripslashes(checkit($_POST['email'])), stripslashes(checkit($_POST['contactName'])));
 	//$mail->AddAddress('bkdehm@tracy-driscoll.com' , 'Brian Dehm');
 	//$mail->AddAddress('DPolletta@mbcinteractive.com' , 'Don Polletta');
 	$mail->AddAddress('teresa.romano@nc.rr.com' , 'Teresa Romano');
 	$mail->SetFrom(stripslashes(checkit($_POST['email'])), stripslashes(checkit($_POST['contactName'])));
 	$mail->Subject = 'Auto Insurance Quote Request from the Tracy-Driscoll web site';
 	$mail->AltBody = 'To view the message, please use an HTML compatible email viewer!'; // optional - MsgHTML will create an alternate automatically
 	$mail->msgHTML(
 
 		'Received On: '.date('m/d/Y H:i:s').'<br/><br/>
 
 		<h3>Insured Information</h3><br/>'.
 
 		'Name: ' . stripslashes(checkit($contactName)) . '<br/>'.
 		'Address:  '.$address.'<br/>'.
 		'City:  '.$city.'<br/>'.
 		'State: '.$state.'<br/>'.
 		'Zip: '.$zip.'<br/>'.
 		'Phone:  '.$phone.'<br/>'.
 		'Email:  '.$email.'<br/>'.
 		'Date of Birth: '.$dobMonth.' '.$dobDay.','.$dobYear.'<br/>'.
 		'Drivers License Number:  '.$driversLicense.'<br/>'.
 
 		'<h3>Current Insurance</h3><br/>'.
 
 		'Do you have Insurance:  '.$do_you.'<br/><br/>'.
 
 		'<h3>Coverages</h3><br/>'.
 
 		'Bodily Injury Liability:  '.$bodilyInjury.'<br/>'.
 		'Property Damage Liability:  '.$propertyDamage.'<br/>'.
 		'Medical Payments:  '.$medicalPayments.'<br/>'.
 		'Comprehensive Deductible:  '.$comprehensiveDeductible.'<br/>'.
 		'Collision Deductible:  '.$collisionDeductible.'<br/>'.
 		'Rental Reimbursement:  '.$rentalReimbursement.'<br/>'.
 		'Towing & Labor:  '.$towing.'<br/><br/>'.
 
 		'<h3>Vehicle 1 Information:</h3><br/>'.
 			  'Year:  '.$v1year.'<br/>'.
 			  'Make & Model:  '.$v1make.'<br/>'.
 			  'VIN:  '.$v1vin.'<br/><br/>'.
 
 		'<h3>Vehicle 2 Information:</h3><br/>'.
 			'Year:  '.$v2year.'<br/>'.
 			'Make & Model:  '.$v2make.'<br/>'.
 			'VIN:  '.$v2vin.'<br/><br/>'.
 
 		'<h3>Licensed Drivers:</h3><br/>'.
 
 		'Any other Drivers:  '.$otherDrivers.'<br/>'.
 		'How Many?:  '.$howMany.'<br/><br/>'.
 
 		'<h3>Credit Check</h3><br/>'.
 
 		'Permission:  '.$permission.'<br/>'.
 		'SSN:  '.$ssn);
 
 
 		$mail->Send();
 
 			  echo "Message Sent OK</p><br/>";
 		  } catch (phpmailerException $e) {
 			echo $e->errorMessage(); //Pretty error messages from PHPMailer
 		  } catch (Exception $e) {
 			echo $e->getMessage(); //Boring error messages from anything else!
 		  }
 
 		  /* *********** Second email to customer ****************** */
 
 		  require_once('class.phpmailer.php');
 		  include_once("class.smtp.php"); // optional, gets called from within class.phpmailer.php if not already loaded
 
 
 		  $mail = new PHPMailer(true); // the true param means it will throw exceptions on errors, which we need to catch
 
 		  $mail->IsSMTP(); // telling the class to use SMTP
 
 		  try {
 
 			$mail->Host     = "172.16.4.18"; // SMTP server
 			$mail->Port       = 25;
 			$mail->SMTPAuth = true;
 			$mail->Username   = "tracy1@oldgate.org"; // SMTP account username
 			$mail->Password   = "driscoll2";
 
 			$mail->SMTPDebug  = 0; // enables SMTP debug information (for testing);
 
 			$mail->AddReplyTo('webserver@tracy-driscoll.com', 'Online Quote');
 			$mail->AddAddress('teresa.romano@nc.rr.com' , 'Teresa Romano');
 			$mail->AddAddress(stripslashes(checkit($_POST['email'])), stripslashes(checkit($_POST['contactName'])));
 			$mail->SetFrom('webserver@tracy-driscoll.com', 'Online Quote');
 			$mail->Subject = 'Auto Insurance Quote Request from the Tracy-Driscoll web site';
 
 			$mail->msgHTML(
 
 				  'Hello '.$contactName.',<br/><br/>
 
 				  This email is a confirmation that we have received your request and is now being processed. You will be contacted by phone or email to discuss your insurance options with a Tracy-Driscoll agent shortly.<br/><br/>'.
 
 				  'No matter what type of service you are in search of, there are certain things you probably look for when choosing a company to do business with: quality work, exceptional products, friendly assistance, prompt attention, fair pricing... <br/><br/>'.
 
 				  'When you are looking for someone to meet your insurance coverage needs, Tracy-Driscoll Insurance & Financial Services provides all this and more.  We will carefully analyze your needs and recommend the right plan to make sure you are adequately protected, at the most reasonable rates.  <br/><br/>'.
 
 				  'Whether you are in need of auto, homeowners, health, life or business coverage, trust Tracy-Driscoll, supporting our community for 90 years.  <br/><br/>'.
 
 				  'Call us today to speak with an insurance specialist (860) 589-3434, or visit us online at www.Tracy-Driscoll.com.   <br/><br/>'.
 
 				  'Sincerely,<br/>'.
 				  'Brian K. Dehm, President ');
 
 		  $mail->Send();
 
 			echo "Message Sent OK</p>\n";
 			} catch (phpmailerException $e) {
 			  echo $e->errorMessage(); //Pretty error messages from PHPMailer
 			} catch (Exception $e) {
 			  echo $e->getMessage(); //Boring error messages from anything else!
 			}
 
       		header("Location: http://www.tracydriscoll.com/landingpages/auto/thanks.html");
       }else{ // else for errors..
           echo "you have errors!<br />";
           print_r($errorFields);
       }
   }else{
       header("Location: https://www.tracy-driscoll.com/forms/auto_quote.php");
   }
 
 
 ?>