0:00
Guys, in the last video, we made our signup form
0:04
I showed you the signup form where user name, password and confirm password
0:09
these three fields will be entered by your user. Now some people were saying
0:13
that if I put my name in the container, then there will be a margin from above
0:18
that is, there will be some space. But I said again that this is not a designing tutorial
0:21
I took the bootstrap so that we don't feel bad about its design
0:25
while developing. I will reload, it came down a little. So that is fine
0:31
Even I can put the placeholder inside. This user name, password and confirm password
0:35
I have a lot of options. I am not making it from a design perspective
0:38
Many people said that darken the nav bar. Now you are saying that I am darkening it
0:43
but I said again that this is not a designing tutorial. If you darken the two lights that were written
0:51
then it will be dark. But if you do not know how this work happened
0:56
then you will see my bootstrap video later. But now I am not teaching you bootstrap
1:01
I am teaching PHP. So let's see PHP now. We will now make our table. Where
1:08
In phpMyAdmin. So here I have made a table called contacts. Sorry, I have made a database called dbarray
1:16
What will I do here? I will make a new database here
1:20
And I will keep its name as users. Now here I want to give you a heads up
1:25
Security Heads Up. All the people who make a database to store user information
1:32
they keep its name as user only. Now there is nothing wrong in it
1:36
And you will say that my database will be hacked. What is the problem? I will keep it as users only
1:40
How will anyone know? I am secure. If you make it users123
1:44
or users make it your date of birth, or you make it 3 digits of your phone number
1:50
then what is the problem? I am just telling you one thing
1:54
You may be able to save yourself. A small thing can save you from getting hacked
1:58
And security where it is said that if I never get hacked
2:02
then there is nothing like that. You can make a mistake anytime
2:06
It is possible that the user guesses the name of your database and enters your website
2:10
With that said, I will keep its name as users only. But I just wanted to give you a security heads up
2:16
In this, I will make a table called users. There will be four columns
2:24
Serial number, username, password and date. Okay. So what I will do here is
2:32
I will make it with four columns. Serial number, username, password and date
2:42
And I will write date as date only. And I want to take it as date time
2:48
Date time. I want to take current time stamp. Serial number, int 11
2:54
username, varchar 11, password varchar 23. I think that should be fine
3:00
So this is the design of my database. Now many of you will ask
3:06
to make the password bigger. But let's leave it for now. You can make it bigger too
3:12
So here I will save it. I have made the serial number
3:16
Primary key, username, password, date. Everything is set. My table is ready
3:22
I will insert dummy record and show it to you. So basically what I want is
3:28
whenever I go to signup, whenever my user goes to signup, then what should happen
3:34
As soon as they enter username, password and confirm password, data should be inserted
3:40
in my users table. At the same time, I will show an alert
3:46
I will show a green color dismissible alert. And I will say
3:54
you know what, catch this alert. So what I will do is
4:00
I will say, give an alert in signup. And where will the alert come
4:06
It will come after the partial snap bar. So I will paste it
4:10
What will I do with it? First of all, I will write success
4:14
I will write success Your account is now created. And you can login
4:24
So I will do this. So see how it will come. And I want to see it green
4:30
So I will make the warning success. And this is bootstrap framework
4:34
There are some classes in this which you should know. I have explained bootstrap framework in one video
4:38
If you want to see it, you can see it from here
4:42
Bootstrap in one video. I made it a few days ago. If you are watching this video later
4:48
I uploaded this video 4 days ago. So search my video in Hindi
4:52
Search here. You will get it. But now you can do it without it
4:58
If you want to make a simple page directly
