1
00:00:00,390 --> 00:00:06,270
Since our goal is to make the blog a members only area we need to create a registration form and a log

2
00:00:06,270 --> 00:00:07,430
in page.

3
00:00:07,650 --> 00:00:12,130
Once a user registers the data will be stored into a database.

4
00:00:12,170 --> 00:00:17,520
We need to create the database before creating the log in and registration page.

5
00:00:17,560 --> 00:00:21,550
Let's go ahead and launch BHP my admin so we can create the database

6
00:00:26,340 --> 00:00:30,430
with P2P my admin loaded click the new button

7
00:00:33,430 --> 00:00:37,290
so we can create the database and we'll give it the name.

8
00:00:37,360 --> 00:00:38,500
Perfect cup.

9
00:00:42,540 --> 00:00:50,440
Just be careful with the spelling to make sure it's correct and for the collation choose UTF Unicode

10
00:00:51,130 --> 00:00:51,670
C.I.

11
00:00:55,970 --> 00:00:57,240
and click Create.

12
00:00:57,310 --> 00:01:01,790
You should see the database appear on the left column so just click on it.

13
00:01:01,790 --> 00:01:10,230
When it does once you do that you'll have the option of creating a table and we're going to create a

14
00:01:10,230 --> 00:01:20,520
new table you can name the table members and give it five columns.

15
00:01:20,690 --> 00:01:23,420
The first column will be named I.D..

16
00:01:23,900 --> 00:01:35,040
The type will be integer 15 15 characters Max set the index to primary because it'll be our primary

17
00:01:35,490 --> 00:01:47,730
key and check off auto increment the next column will be f me and make that var char 25

18
00:01:50,610 --> 00:01:51,630
next is l name

19
00:01:56,320 --> 00:01:56,800
email

20
00:02:01,250 --> 00:02:02,020
and password.

21
00:02:06,200 --> 00:02:14,040
Again do be careful that the spelling is correct and there's no typos so password will be var char as

22
00:02:14,040 --> 00:02:17,580
well but set the length to two hundred and fifty characters

23
00:02:22,080 --> 00:02:26,380
and before I click save I'll just confirm everything is OK.

24
00:02:28,640 --> 00:02:34,960
So once you've done that just click the save button and you'll see your members table pops up on the

25
00:02:34,960 --> 00:02:36,030
left column as well.

26
00:02:38,020 --> 00:02:44,230
Now that we have the database and table created you can minimize HP my admin because we'll be working

27
00:02:44,230 --> 00:02:46,060
with it a bit later on.

28
00:02:46,270 --> 00:02:47,880
So I'll just move that out of the way for now.