<?php
			 $serverName = "127.0.0.1"; //address for MySQL server
			 $user = "***";
			 $pass = "***";
			 $dbName ="***";
			 $fname = ($_POST["firstName"]);
			 $lname = ($_POST["lastName"]);
			 $address = ($_POST["add"]);
			 $loccity = ($_POST["city"]);
			 $locstate = ($_POST["state"]);
			 $zcode = ($_POST["zip"]);
			 $telephone = ($_POST["phoneNumber"]);
			 $subemail = ($_POST["email"]);
			 $user_chars = "#[^a-zA-Z0-9_\-]#";
			 $email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/";
			function errorMsg()
			{
				$con = mysql_connect('*********');
				if (!$con)
				{
					die('Could not connect: ' . mysql_error());
				}
				else
				{
					if (!empty($_POST))
					{
						if ((empty($_POST["firstName"]))||(empty($_POST["lastName"]))||(empty($_POST["add"]))||(empty($_POST["city"]))||(empty($_POST["zip"]))||(empty($_POST["phoneNumber"]))||(empty($_POST["email"])))
						{
							die('Some fields were missing; go <a href="register.php">back here</a> and start again.');
						}
						else
						{
							$DB_DB ="***";
							$FNAME = ($_POST["firstName"]);
							$LNAME = ($_POST["lastName"]);
							$ADDRESS = ($_POST["add"]);
							$LOCCITY = ($_POST["city"]);
							$LOCSTATE = ($_POST["state"]);
							$ZCODE = ($_POST["zip"]);
							$TELEPHONE = ($_POST["phoneNumber"]);
							$SUBEMAIL = ($_POST["email"]);
							$user_chars = "#[^a-zA-Z0-9_\-]#";
							$email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/";
							$FORMAT = ($_POST["optIn"]);
							if (strlen($ZCODE) != 5) // check zip code
							{
								die('Invalid zip code; go <a href="register.php">back here</a> and start again.');
							}
							if (strlen($TELEPHONE) <= 9) // check phone number
							{
								die('Invalid phone number; go <a href="register.php">back here</a> and start again.');
							}
							if (strlen($TELEPHONE) >= 18) // check phone number
							{
								die('Invalid phone number; go <a href="register.php">back here</a> and start again.');
							}
							if(preg_match($user_chars,$FNAME)) // check first name
							{
								die('Invalid first name; go <a href="register.php">back here</a> and start again.');
							}
							if(preg_match($user_chars,$LNAME))// check last name
							{
								die('Invalid last name; go <a href="register.php">back here</a> and start again.');
							}
							if(preg_match($user_chars,$LOCCITY))// check city
							{
								die('Invalid city; go <a href="register.php">back here</a> and start again.');
							}
							else
							{
								unset($qry);
								$SUBEMAIL = mysql_real_escape_string($SUBEMAIL);
								$register_sql = "insert into " . mysql_real_escape_string($DB_DB) . ".marketing (fname,lname,address,loccity,locstate,zcode,telephone,format,subemail) values ('" . $FNAME . "','" . $LNAME . "','" . $ADDRESS . "','" . $LOCCITY . "','" . $LOCSTATE . "','" . $ZCODE . "','" . $TELEPHONE . "','" . $FORMAT . "','" . $SUBEMAIL . "')";
								$qry = @mysql_query($register_sql, $con);
								if (!$qry)
								{
									die("Error creating account: " . mysql_error());
								}
								else{
									if (FORMAT == "1") // opt in for flyer
									{
										echo 'Thank you for signing up for our flyer!<br />';
									}
									if ($FORMAT == "2") //opt in for email
									{
										echo 'Thank you for signing up for our email!<br />';
									}
									else // opt in for email and flyer
									{
										echo 'Thank you for signing up for our email and flyer!<br />';
									}
								}
							}
						}
					}
				}
			}
				errorMsg(); // Write function
				mysql_close($con); // terminate MySQL connection
		?>