$host = "localhost"; $user = "YOUR_USERNAME"; $pass = "YOUR_PASSWORD"; $dbname = "asanchez41"; $cnx = mysqli_connect($host, $user, $pass, $dbname); if (!$cnx) { die("Connection failed: " . mysqli_connect_error()); } $custLast = $_POST['custLast']; $custFirst = $_POST['custFirst']; $custAddress = $_POST['custAddress']; $custCity = $_POST['custCity']; $custState = $_POST['custState']; $custZip = $_POST['custZip']; $custEmail = $_POST['custEmail']; $custPhone = $_POST['custPhone']; $dt = date("Y-m-d H:i:s"); $sql = "INSERT INTO customer VALUES ( null, '$custLast', '$custFirst', '$custAddress', '$custCity', '$custState', '$custZip', '$custEmail', '$custPhone', '$dt' )"; $result = mysqli_query($cnx, $sql); if ($result) { echo "

Customer record added successfully!

"; } else { echo "

Error inserting record:

" . mysqli_error($cnx); } mysqli_close($cnx);