[insert_php]

$company_name = filter_input(INPUT_POST, ‘company_name’);
$total = filter_input(INPUT_POST, ‘total’);
$first1 = filter_input(INPUT_POST, ‘first1’);
$last1 = filter_input(INPUT_POST, ‘last1′);
$email1 = filter_input(INPUT_POST, ’email1′);
$first2 = filter_input(INPUT_POST, ‘first2’);
$last2 = filter_input(INPUT_POST, ‘last2′);
$email2 = filter_input(INPUT_POST, ’email2′);
$city = filter_input(INPUT_POST, ‘city’);
$state = filter_input(INPUT_POST, ‘state’);
$zipcode = filter_input(INPUT_POST, ‘zipcode’);
$phone = filter_input(INPUT_POST, ‘phone’);
$concerns = filter_input(INPUT_POST, ‘concerns’);

$dsn = ‘mysql:host=localhost;dbname=cbagdon_event-water’;
$username = ‘cbagdon_water’;
$password = ‘TUESfeb6!’;

try {
$db = new PDO($dsn, $username, $password);
echo ‘ ‘;
} catch (PDOException $e) {
$error_message = $e->getMessage();
echo “An error occured whole connecting to the database: $error_message

“;
}

$query = “INSERT INTO water (companyname, total, city, state, first1, last1, email1, first2, last2, email2, phone, concerns, zipcode)
VALUES(:company_name, :total, :city, :state, :first1, :last1, :email1, :first2, :last2, :email2, :phone, :concerns, :zipcode)”;

$statement = $db->prepare($query);
$statement->bindValue(‘:company_name’, $company_name);
$statement->bindValue(‘:total’, $total);
$statement->bindValue(‘:city’, $city);
$statement->bindValue(‘:state’, $state);
$statement->bindValue(‘:first1’, $first1);
$statement->bindValue(‘:last1’, $last1);
$statement->bindValue(‘:email1’, $email1);
$statement->bindValue(‘:first2’, $first2);
$statement->bindValue(‘:last2’, $last2);
$statement->bindValue(‘:email2’, $email2);
$statement->bindValue(‘:phone’, $phone);
$statement->bindValue(‘:concerns’, $concerns);
$statement->bindValue(‘:zipcode’, $zipcode);

$statement->execute();
$statement->closeCursor();

[/insert_php]