Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-21 Thread Nazish Zafar
Thanks! -- I'll definitely look into Netbeans. (The IDE that I was using didn't seem to recognize syntax errors.) On Mon, Feb 21, 2011 at 4:13 AM, Pete Ford wrote: > > Nazish, > Find yourself an editor or development environment that does source code > highlighting - this sort of error will be

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-21 Thread Pete Ford
On 20/02/11 21:37, Nazish wrote: Issue resolved! It turned out to be the use of quotations. Instead of double quotations to surround the $insert variable, it worked with single quotations: $insert = ' INSERT INTO user_info (login,password) VALUES ("'.$login.'", "'.$passw

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Andre Polykanine
: Tamara Temple To: PHP General Date created: , 12:27:46 AM Subject: [PHP] Submitting data to MySQL database using HTML/PHP form I'm wondering if anyone is going to comment on the transmittal and storage of plain text passwords -- PHP General Mailing List (http://www.php.net

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Tamara Temple
I'm wondering if anyone is going to comment on the transmittal and storage of plain text passwords -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread admin
tring($password)."' The double quote is in the wrong place. -Original Message- From: Nazish [mailto:naz...@gmail.com] Sent: Sunday, February 20, 2011 3:54 PM To: php-general@lists.php.net Subject: Re: [PHP] Submitting data to MySQL database using HTML/PHP form Update: I a

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Andre Polykanine
: php-general@lists.php.net Date created: , 10:53:35 PM Subject: [PHP] Submitting data to MySQL database using HTML/PHP form Update: I added "echo" statements after mysql_connect and mysql_select_db to check where the code was broken. These statements show up on the login.php

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Andre Polykanine
m_elensule Facebook: http://facebook.com/menelion Original message From: Nazish To: php-general@lists.php.net Date created: , 10:04:07 PM Subject: [PHP] Submitting data to MySQL database using HTML/PHP form Thanks everyone! However, when I click the "submit&q

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Nazish
l_real_escape_string($login)."','".mysql_real_escape_string($passwor > d)."')"; > > Here is the issue > > ," '.mysql_real_escape_string($password)." ' > > Your escaping incorrectly. > > It should be > ,' ".mysql_real_escape_string($pass

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Nazish
Update: I added "echo" statements after mysql_connect and mysql_select_db to check where the code was broken. These statements show up on the login.php page after submitting the form, which means the MySQL connection works. So, the problem seems to lie with the *$insert *query... ideas? On Sun,

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Nazish
Thanks everyone! However, when I click the "submit" button, the url simply moves to http://localhost/login.php (from home.php) and it is a blank page (apart from asking whether it should remember the password for future use). The values still do not move to the database. I included most of your su

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Andre Polykanine
y blog: http://oire.org/menelion (mostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Nazish To: php-general@lists.php.net Date created: , 7:44:24 PM Subject: [PHP] Submitting data to MySQL database using HTM

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Donovan Brooke
This is probably a post better sent to the php-db list... but Whenever you work with MySQL, it's good to retrieve the actual error from mysql to help you troubleshoot. I posted this php_mysql lib a while back which is what I used on my last project. http://www.euca.us/downloads/euca_phpmysq

Re: [PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Daniel Brown
On Sun, Feb 20, 2011 at 12:55, Daniel Brown wrote: > On Sun, Feb 20, 2011 at 12:53, Daniel Brown wrote: >> >>    If the value isn't that of your database password, there's your >> problem: register_globals.  A simpler way is to check the output of >> phpinfo(); to see if register_globals is enabl

[PHP] Submitting data to MySQL database using HTML/PHP form

2011-02-20 Thread Nazish
Hi there, I am creating a login page for my website. The users' information will be stored in a MySQL database. I have a registration form on my home page, and a separate file called "login.php" to process the user values. However, the entries are not going to the MySQL database (however, the valu