<?php
/**
 * Created by PhpStorm.
 * User: aleksejjj
 * Date: 5/31/2016
 * Time: 3:14 AM
 */

die('WTF????????????? Cache?????????????????');

// Connect Data
$db_host = 'localhost';
$db_name = 'louiseda_rsvp';
$db_user = 'louiseda_admin';
$db_pass = 'Password1';

// Important!!! Comment 'print' line in production using!!!
try
{
    $dbh = new PDO('mysql:host='. $db_host .';dbname=' . $db_name, $db_user, $db_pass);
}
catch (PDOException $e)
{
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}

echo '>>>';
echo $_POST['name'];
echo '<<<';

// If fields empty - die
if (empty($_POST['name']) || empty($_POST['email']) || empty($_POST['attend']) || empty($_POST['note']))
{
    echo $_POST['name'];
    echo $_POST['email'];
    echo $_POST['attend'];
    echo $_POST['note'];
    die('Error!');
}
print_r($_POST);

$sth = $dbh->prepare('INSERT INTO users (name, email, attend, note) VALUES (:name, :email, :$attend, :note)');
$sth->bindParam('name', $_POST['name'], PDO::PARAM_STR);
$sth->bindParam('email', $_POST['email'], PDO::PARAM_STR);
$sth->bindParam('attend', $_POST['attend'], PDO::PARAM_STR);
$sth->bindParam('note', $_POST['note'], PDO::PARAM_STR);

$sth->execute();

if (!$sth) {
    echo "\nPDO::errorInfo():\n";
    print_r($dbh->errorInfo());
}

return 'ok';