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

2011-02-20 Thread Donovan Brooke
Daniel Brown wrote: On Sun, Feb 20, 2011 at 14:11, Nazish Zafar wrote: $insert = "INSERT INTO user_info (login, password) VALUES ("$login", "$password"); You're using double-quotes to encapsulate your $insert variable data, then never closing them. What's more, you're also using double

[PHP-DB] data formats

2011-02-20 Thread Richard Dunne
I'm submitting form data which is a mixture of checkboxes and text inputs, some of which are integers and a couple text based. I am retrieving the data as follows: $var = (int)!empty($_POST['var']); for checkboxes, $var = (int)$_POST['var']; for integers and $var = mysql_real_escape_string($_P

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

2011-02-20 Thread Daniel Brown
On Sun, Feb 20, 2011 at 14:11, Nazish Zafar wrote: > > $insert = "INSERT INTO user_info > (login, password) > VALUES > ("$login", "$password"); You're using double-quotes to encapsulate your $insert variable data, then never closing them. What's more, you're also using double-quotes to encap

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

2011-02-20 Thread Nazish Zafar
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 (even though the v