<?php

$hostname="****";
$username="****";  //mysql username default is root.
$password="****";       //blank if no password is set for mysql.
$database="****";  //database name which you created
$con=mysql_connect($hostname,$username,$password);
if(! $con)
{
die('Connection Failed'.mysql_error());
}

mysql_select_db($database,$con);


if(isset($_POST['submit']))
{
    Register();
}

function Register()
{
    $name = $_POST['Name'];
    $address = $_POST['Address'];
    $city = $_POST['City'];
    $state =  $_POST['State'];
    $zip =  $_POST['ZipCode'];
    $email =  $_POST['Email'];
    $optin =  $_POST['OptinCB'];
    $captcha = $_POST['Captcha'];

    if( $captcha == "6" )
    {
        if( isset($optin) )
    {
        $query = "INSERT INTO Users (Name,Address,City,State,Zipcode,Email,Optin) VALUES ('$name','$address','$city','$state','$zip','$email','optin')";
        $data = mysql_query ($query)or die(mysql_error());
        if($data)
        {
            header("Location: http://www.williamisom.info/thankyou.html");
            exit;
        }
    }
    else
    {
        echo "You Have Not Agreed To The Optin Terms";
    }
    }
    else
    {
        echo "Captcha input incorrect or blank, please go back and try again";
        exit;
    }
}
?>