Just a small database code. Want to make entries in the mySQL table using
PHP. Not being able to. When I run this code it takes me to the next blank
brower window as if the entry has been made but after checking the database
I do not find anything. There is not even an error message, I have tried two
approaches this code is mixed. Please advice.
<?php
// database information
Here was the database information removed for security.
if($submit)
{
// connect and select the database
$conn = mysql_connect($host, $user, $password) or die(mysql_error());
$db = mysql_select_db($dbName, $conn) or die(mysql_error());
// insert new entry in the database if entry submitted
if($query_rows != 0)
{
$error = "THERE SOME ERROR TO BE SHOWN TO THE USER IF THE EMAIL
ADDRESS
EXISTS IN THE DATABASE";
}
else{
/* $fName = $_POST['fName'];
$lName = $_POSR['lName'];
$email = $_POST['email'];
$confEmail = $_POST['confEmail'];
$password = $_POST['password'];
$confirmPassword = $_POST['confirmPassword'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$postCode = $_POST['postCode'];
$gender = $_POST['gender'];
$profession = $_POST['profession'];
$ageGroup = $_POST['ageGroup'];
$mallPref = $_POST['mallPref'];
$mallConsent = $_POST['mallConsent'];*/
// insert new entry into database
$sql = "insert data `userdata` (`fName`, `lName`, `email`, `confEmail`,
`password`, `confirmPassword`, `address`, `city`, `state`, `postCode`,
`gender`, `profession`, `ageGroup`, `mallPref`, `mailConsent`) VALUES
('$fName', '$lName', '$email', '$confEmail', '$password',
'$confirmPassword', '$address', '$city', '$state', '$postCode', '$gender',
'$profession', '$ageGroup', '$mallPref', '$mailConsent');";
$sucess_message = "SHOW HERE SOME MESSAGE TO THE USER IF THE ADDITION IS
SUCESS";
} // end if new entry posted
}
Show some confirm or thank you HTML stuff.
?>
Thank you in advance.
Chris
--
View this message in context:
http://www.nabble.com/Where-am-I-doing-wrong---DB-tf2716628.html#a7574187
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
