Where am I doing wrong - DB
| From: | Chris Carter | Date: | Tue, 28 Nov 2006 06:42:33 +0000 |
| Subject: | Where am I doing wrong - DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42755@lists.php.net to get a copy of this message | ||
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.