RE: [PHP-DB] Where am I doing wrong - DB
| From: | Dwight Altman | Date: | Tue, 28 Nov 2006 15:10:14 +0000 |
| Subject: | RE: [PHP-DB] Where am I doing wrong - DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42757@lists.php.net to get a copy of this message | ||
Assuming $submit even has a value (Are you sure you don't mean
$_POST['something'] here?) all your code does is test 2 variables, connect
to the server, change to a database and set some more few variables. When
do you plan to execute a query "mysql_query($sql)", or output a print or
echo of some text or HTML?
"or die" doesn't output anything because $submit is probably false.
Your page should be blank and nothing should go to the database with this
code.
Regards,
Dwight
x2407
> -----Original Message-----
> From: Ankur Dave [mailto:ankurd@aztecsoft.com]
> Sent: Tuesday, November 28, 2006 1:01 AM
> To: Chris Carter; php-db@lists.php.net
> Subject: RE: [PHP-DB] Where am I doing wrong - DB
>
>
> 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
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php