PHP Login Help - I am new to this...

[ThePhoenix2006]

Hey Everyone,

I have been trying to get PHP to work on a website I am trying to build. I am currently reading "PHP and mySQL For Dummies"...yes I will admit it I am a dummy.

I made a artist table under my database MemberDirectory

I made the following columns:
loginName
creatDate
password
bandName
email
members
about
website
phone
state
city
zip
genre1
genre2

Now..my question is how do I get new user to register properly and then upload the new info to this database. Then when they are registered they would be able to login and see the info they have or change it. Could I use a form text field and name it a variable then do it that way?

I hope someone can help me I have been beating my head against the wall all week. :ichatcry:

THANKS FOR READING!

[bfsog]

He

Now..my question is how do I get new user to register properly and then upload the new info to this database.

Well, you would create a web page with a form on it. This form would have text boxes/radio buttons/form elements for all the information you need. You should name these how you named your database columns, just to make it easier.

Then, depending on how you setup your <form> tag, you will either need to use the $_POST array or the $_GET array.

I am assuming you are using the $_POST method (eg <form method="post" action="..">.

On the php page that does the inserting into the database, you would assign a php variable to the value of a form element. For instance, if you have a textbox called username, setting a variable would be as easy as...

<?php
   $user = $_POST['username'];
?>

You would have to do that fir all the values you want to insert.

Once you have done that, you would do the INSERT command, which will insert these variables.

I hope this gets you on your way, your post asked for a mix of information, so if you need more specific help, just reply and I will try my best.