SOrry, but im new at this

markmil2002

I am trying to make a signup page called signup.php. When the user click on the submit button I want all the variables' values to be stored in a mySQL database in their respective spots. So if I have an Input tag with Name="firstname" I need to know where in the document I put the PHP and the SQL. I also need to know how to get the variable first name to store on my database.

Shrike

Create an HTML form. Point the action attribute of the form at 'signup.php'. Make the method attribute 'POST'. Then add your form fields. You can access their values in signup.php after the form is submitted using the prewritten $POST[] array e.g.

<html>
...
<form method="post" action="signup.php">
<input type="text" name="firstname"/>
<input type="submit" name="sibmit" value="Submit"/>
</form>
...
</html>

//signup.php
echo "Your first name is ".$_POST['firstname'];
$sql = "INSERT INTO users VALUES (".$_POST['firstname'].")";

That's the basics. Remember when you accept database input you need to parse it thoroughly 🙂

markmil2002

I understand most of that, except for the INSERT part, I was wondering where to put the table and column name

Shrike

You don't actually need to specify the column names, the values represent the columns in order. You should replace 'users' with whatever your table is called.

MySQL Manual
If you do not specify the column list for INSERT ... VALUES or INSERT ... SELECT, values for every column in the table must be provided in the VALUES() list or by the SELECT. If you don't know the order of the columns in the table, use DESCRIBE tbl_name to find out.