RE: [PHP-DB] Where am I doing wrong - DB
| From: | Ankur Dave | Date: | Tue, 28 Nov 2006 07:00:38 +0000 |
| Subject: | RE: [PHP-DB] Where am I doing wrong - DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42756@lists.php.net to get a copy of this message | ||
For getting error msg your php.ini should enable this line -
error_reporting = E_ALL & ~E_NOTICE
chk for this.
-=-=-=-=-=-=-=-=-=-
@nkur d@ve || http://ullu.wordpress.com
-----Original Message-----
From: Chris Carter [mailto:chandan9sharma@yahoo.com]
Sent: Tuesday, November 28, 2006 12:13 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Where am I doing wrong - DB
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#a757418
7
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
The information contained in, or attached to, this e-mail, contains confidential information and is
intended solely for the use of the individual or entity to whom they are addressed and is subject to
legal privilege. If you have received this e-mail in error you should notify the sender immediately
by reply e-mail, delete the message from your system and notify your system manager. Please do not
copy it for any purpose, or disclose its contents to any other person. The views or opinions
presented in this e-mail are solely those of the author and do not necessarily represent those of
the company. The recipient should check this e-mail and any attachments for the presence of viruses.
The company accepts no liability for any damage caused, directly or indirectly, by any virus
transmitted in this email.
www.aztecsoft.com