<?php
$username = "private_info";
$password = "private_info";
$hostname = "host";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
//select a database to work with
$selected = mysql_select_db("private_info",$dbhandle)
or die("Could not select that database");
//execute the SQL query and return records
$result = mysql_query("SELECT id, reference,amount,name,cardtype,cardnumber,exp,cvc2,ssn,address,city,state,email,zip,phone,initials");
//debug testing data is captured correctly - yes
echo $reference . $amount . $name . $cardtype . $cardnumber . $exp . $cvc2 . $ssn;
$data = "INSERT INTO users (reference,amount,name,cardtype,cardnumber,exp,cvc2,ssn,address,city,state,email,zip,phone,initials) VALUES ('$reference', '$amount', '$name', '$cardtype', '$cardnumber', '$exp', '$cvc2', '$ssn', '$address', '$city', '$state','$email','$zip','$phone', '$initials')";
echo "Your Information Has Been Added";
?>
mysql_close($dbhandle);
?>
