Since our goal is to make the blog a members only area we need to create a registration form and a log
in page.
Once a user registers the data will be stored into a database.
We need to create the database before creating the log in and registration page.
Let's go ahead and launch BHP my admin so we can create the database
with P2P my admin loaded click the new button
so we can create the database and we'll give it the name.
Perfect cup.
Just be careful with the spelling to make sure it's correct and for the collation choose UTF Unicode
C.I.
and click Create.
You should see the database appear on the left column so just click on it.
When it does once you do that you'll have the option of creating a table and we're going to create a
new table you can name the table members and give it five columns.
The first column will be named I.D..
The type will be integer 15 15 characters Max set the index to primary because it'll be our primary
key and check off auto increment the next column will be f me and make that var char 25
next is l name
email
and password.
Again do be careful that the spelling is correct and there's no typos so password will be var char as
well but set the length to two hundred and fifty characters
and before I click save I'll just confirm everything is OK.
So once you've done that just click the save button and you'll see your members table pops up on the
left column as well.
Now that we have the database and table created you can minimize HP my admin because we'll be working
with it a bit later on.
So I'll just move that out of the way for now.