Re: Write from form to DB

From: Date: Wed, 03 Aug 2005 18:10:36 +0000
Subject: Re: Write from form to DB
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-219929@lists.php.net to get a copy of this message
George B wrote:
Ok, I got this far. include("config.php"); $username = $_GET['name']; $password = $_GET['pword']; echo "Username = " . $username . "<br>"; echo "Password = " . $password . "<br>"; $query = "INSERT INTO user (name,password) VALUES ($username","$password") $result = mysql_query($query) config is just all the info to connect to server. i have to forms. name which is a for for entering username, and pword for entering password. I would like it so that when I enter the info for the forms, it puts all the data that I entered into a database. In this case I THOUGHT this $query = "INSERT INTO user (name,password) VALUES ($username","$password")
Your query is mis-quotes and missing the semi-colon. $query = "INSERT INTO user (name,password) VALUES ('$username', '$password')";
would do the job but, it dosent. It gives a Parse error: syntax error, unexpected T_VARIABLE in C:\Program Files\Apache Group\Apache2\htdocs\php\login\registration_action.php on line 15 How do I fix this, and make it send the data from the form, into the database?
-- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com

« previous php.general (#219929) next »