1

00:00:00,180 --> 00:00:00,870

Hello, friend.



2

00:00:00,900 --> 00:00:01,750

Welcome back.



3

00:00:02,220 --> 00:00:07,450

You know, previous video I have discussed about that Pasig Nation, I hope you will understand about



4

00:00:07,470 --> 00:00:12,640

how you can add that designation in Lavallade project to now in this video.



5

00:00:12,660 --> 00:00:14,580

I want to discuss about this user.



6

00:00:14,970 --> 00:00:20,190

And here you can see, friend, it's not showing as a user want, user want and for everyone because



7

00:00:20,190 --> 00:00:24,530

of all here, I have created all that category with all this user.



8

00:00:24,810 --> 00:00:28,200

So that is the user and by default, this ID as a one.



9

00:00:28,560 --> 00:00:28,940

Right.



10

00:00:29,220 --> 00:00:32,070

So now I want to do I want to visible that name.



11

00:00:32,370 --> 00:00:37,210

Like, if you go to our table, that means there is a user table and they use a table here.



12

00:00:37,240 --> 00:00:38,240

Consider the idea.



13

00:00:38,520 --> 00:00:39,520

There is one idea.



14

00:00:39,540 --> 00:00:45,330

So that is our I right now I'm talking with the admin and for this admin actually I do one.



15

00:00:45,450 --> 00:00:45,870

Right.



16

00:00:46,110 --> 00:00:53,220

And also if you go to our database again and the database, if you go to that, our categories and the



17

00:00:53,220 --> 00:00:59,190

categories here, I have already declared on the table as a user ID right there is on the table filled



18

00:00:59,190 --> 00:01:00,060

as a user ID.



19

00:01:00,450 --> 00:01:03,360

So now I want to do I want to join two of this table.



20

00:01:03,360 --> 00:01:07,170

I want to join our categories table to our these users table.



21

00:01:07,350 --> 00:01:13,190

And then I want to match with our two of this feel that this user I.D. will be matched with our this



22

00:01:13,290 --> 00:01:14,250

card user.



23

00:01:14,430 --> 00:01:20,340

That is that user table decided OK, will still be match then I want to do to get this name.



24

00:01:20,970 --> 00:01:23,790

So here you can do that work with both of these.



25

00:01:23,790 --> 00:01:25,080

What you can do that work with.



26

00:01:25,080 --> 00:01:29,400

They look into our and also you can do this work with using that query builder.



27

00:01:29,400 --> 00:01:31,230

So I'll share both of these with you.



28

00:01:31,230 --> 00:01:33,150

Then everything will be very clear to you.



29

00:01:33,480 --> 00:01:33,970

So friendly.



30

00:01:34,050 --> 00:01:38,310

As I told you when you were working with this, you look into one and then we have to do we have to



31

00:01:38,310 --> 00:01:39,480

work with the model.



32

00:01:39,570 --> 00:01:39,960

Right.



33

00:01:40,200 --> 00:01:46,380

Like if you go to our project right now, but I remember everything, OK, remove everything, then



34

00:01:46,380 --> 00:01:47,360

it will be better.



35

00:01:48,150 --> 00:01:50,360

I remove everything and I just make it clean.



36

00:01:50,790 --> 00:01:57,000

So right now, if you go to our view, that means that is the position I actually declared in our view.



37

00:01:57,180 --> 00:02:04,470

That means if you go to our there is a root out will be needed and then that is our another file.



38

00:02:05,520 --> 00:02:06,900

That is all layout's.



39

00:02:06,900 --> 00:02:08,400

That is a profile.



40

00:02:08,430 --> 00:02:13,050

And in the view area into the category here, I have created one of the index cards, HTML.



41

00:02:13,110 --> 00:02:13,410

Right.



42

00:02:13,650 --> 00:02:15,030

And do the index statistical.



43

00:02:15,030 --> 00:02:19,410

Here you can see friend, I only display with this category as a user.



44

00:02:19,410 --> 00:02:24,270

I do feel that is right now this user I feel is visible that that is our user.



45

00:02:24,270 --> 00:02:27,380

I do want and for the reasons all that one idea is visible.



46

00:02:27,750 --> 00:02:30,150

So now I want to do I want to join two of these.



47

00:02:30,160 --> 00:02:33,200

They want to join our this category table to our user.



48

00:02:33,570 --> 00:02:37,410

So if you want to do that, work with using that, you look into what and then we have to do we have



49

00:02:37,410 --> 00:02:38,780

to work in our model.



50

00:02:38,820 --> 00:02:41,220

That means I have also created one of the model.



51

00:02:41,670 --> 00:02:46,830

I if you go to our model and you can see that the category model similar, the category model here we



52

00:02:46,830 --> 00:02:49,320

have to do we have to create one of the function.



53

00:02:49,600 --> 00:02:57,360

OK, so I show you like here after this, after this I want to do the creator of the function and I



54

00:02:57,360 --> 00:03:05,670

just named that function as a public public and then function and then public function and I name it



55

00:03:05,670 --> 00:03:06,270

as a user.



56

00:03:06,270 --> 00:03:10,140

So whatever he wants right now, I name that method will be as a user matter.



57

00:03:10,500 --> 00:03:13,400

And after that here, I want to do want to create that relation.



58

00:03:13,530 --> 00:03:17,850

So if you want to create a position is will be it was a one to one relation.



59

00:03:18,150 --> 00:03:26,410

So I want to do this as a return and return and this return this and after that here I want to do want



60

00:03:26,430 --> 00:03:28,060

to add that one to one relation.



61

00:03:28,110 --> 00:03:30,950

Want one deletion means it will be as it has one.



62

00:03:31,050 --> 00:03:38,430

OK, that means that will be has one, I name it as it has and then one friend and has one relation



63

00:03:38,430 --> 00:03:44,580

I want to do that is there has one of the relation with our user, so that is our user model.



64

00:03:44,580 --> 00:03:47,040

And here I want to do to add that class.



65

00:03:47,910 --> 00:03:49,260

So that will be our class.



66

00:03:49,410 --> 00:03:53,910

And after that, which filled with both two of these really want to create the relation.



67

00:03:53,910 --> 00:03:59,890

I want to create the relation in our user terbil into the user terbil that is actually idea that this



68

00:03:59,910 --> 00:04:03,770

idea will be matched with our these categories, this user ID.



69

00:04:03,900 --> 00:04:04,220

Right.



70

00:04:04,500 --> 00:04:06,780

So here you have to do we have to add both of this.



71

00:04:07,050 --> 00:04:12,960

So you had that ID, so one will be as ID and here it will be, create the relation with another one



72

00:04:13,290 --> 00:04:17,280

and that one will be as a user underscore I right.



73

00:04:17,460 --> 00:04:25,800

Since I simply added both of these are they will feel as ID and the user ID and also I get all the data,



74

00:04:25,800 --> 00:04:29,990

I get all the data and display that things in our with the controller.



75

00:04:30,000 --> 00:04:30,410

Right.



76

00:04:30,420 --> 00:04:31,970

So now open our controller.



77

00:04:32,310 --> 00:04:37,440

So I have already created the controller as a category controller and the category controller here.



78

00:04:37,440 --> 00:04:42,210

You can see that is our look into them and that is our Manadel one.



79

00:04:42,210 --> 00:04:45,030

So that is our query builder.



80

00:04:45,030 --> 00:04:45,330

Right.



81

00:04:45,720 --> 00:04:50,370

So right now I want to do want to first of all, work with the we warrant Warren for the reasons here



82

00:04:50,400 --> 00:04:51,900

in our database.



83

00:04:51,900 --> 00:04:52,800

That means this model.



84

00:04:52,800 --> 00:04:53,420

We need it.



85

00:04:53,730 --> 00:04:59,340

So right now, I want to do I want to actually make it as a command out so that that is actually our



86

00:04:59,340 --> 00:04:59,810

query Will.



87

00:04:59,920 --> 00:05:04,700

Ah, so now I want to do want to point out this look into water, right?



88

00:05:04,960 --> 00:05:05,980

So what is he looking at?



89

00:05:05,990 --> 00:05:07,820

What am I positive about?



90

00:05:07,840 --> 00:05:11,590

That is a category the CATAGORIES model also found with a category model.



91

00:05:11,590 --> 00:05:13,090

That is the latest all the data.



92

00:05:13,090 --> 00:05:17,800

And that is our basic mission, which I have already discussed about that things were different.



93

00:05:17,840 --> 00:05:23,500

So right now I get all the data from all categories and here I take the things with this variable and



94

00:05:23,500 --> 00:05:26,110

after that I compacted that mhere.



95

00:05:26,110 --> 00:05:28,990

Here I pass the data index statistical base.



96

00:05:29,000 --> 00:05:29,350

Right.



97

00:05:29,620 --> 00:05:31,510

So that is our index.



98

00:05:32,230 --> 00:05:39,430

Like if you go to that is our view under the category and the index is right.



99

00:05:39,460 --> 00:05:43,730

So here I simply get all the data and visibility on here.



100

00:05:44,290 --> 00:05:48,880

So now if you want to visibility so you can actually visibility with using that user.



101

00:05:48,910 --> 00:05:52,690

So here I have created that method name, our method name as a user.



102

00:05:53,050 --> 00:05:55,930

So now with this user, we can actually access out.



103

00:05:55,930 --> 00:06:00,070

This is the field that this user user table feels.



104

00:06:00,090 --> 00:06:02,530

So now I want to do I want to use that user.



105

00:06:03,130 --> 00:06:05,170

So here we don't need this.



106

00:06:05,170 --> 00:06:06,840

I want to do I want to use that user.



107

00:06:06,850 --> 00:06:10,780

And with this user, I want to access our filename.



108

00:06:10,780 --> 00:06:14,350

That means I want to do I want to display our TS name.



109

00:06:14,530 --> 00:06:14,850

OK.



110

00:06:14,930 --> 00:06:15,860

That means this name.



111

00:06:16,120 --> 00:06:18,670

So now I want to do and that is our freedom.



112

00:06:19,180 --> 00:06:22,800

Our freedom will be as a name, perfect.



113

00:06:22,810 --> 00:06:24,290

So that's all you have to do.



114

00:06:24,310 --> 00:06:25,460

Now let's check this out.



115

00:06:25,480 --> 00:06:32,110

Now, if you click on the save all I can of to save all and now if you go to your side and now if you



116

00:06:32,110 --> 00:06:32,860

refresh it.



117

00:06:34,270 --> 00:06:37,330

Yes, you can see it now is perfectly updated.



118

00:06:37,360 --> 00:06:39,040

So that is the all the user.



119

00:06:39,050 --> 00:06:41,140

That means this Karzai is visible.



120

00:06:41,290 --> 00:06:41,680

Right.



121

00:06:41,920 --> 00:06:48,240

If you go to our user and the user here can see that is idea one is our Cozette, OK?



122

00:06:48,260 --> 00:06:50,450

And I do it for the audience.



123

00:06:50,450 --> 00:06:56,230

So if you go to our categories and here if you want to change it, like I change it and make this as



124

00:06:56,230 --> 00:06:59,560

a two no click as they serve.



125

00:06:59,560 --> 00:07:02,170

And now you can see there is already two to now.



126

00:07:02,170 --> 00:07:04,870

It should be visible for our Mansi item.



127

00:07:05,080 --> 00:07:07,030

That should be visible as a tool.



128

00:07:07,300 --> 00:07:07,590

Right.



129

00:07:08,020 --> 00:07:12,460

So now let's check this out if you notice, because that means there is a regular mouse fashion.



130

00:07:13,030 --> 00:07:19,510

And now if you refresh, yes, you can see there is actually inside and some outside item is now become



131

00:07:19,510 --> 00:07:25,960

changed and now it's become showing as a ardia hockey fan, I hope is very much clear to you.



132

00:07:25,960 --> 00:07:31,800

If you go to that second base and the second page here, you can see everything is not perfectly displayed.



133

00:07:32,200 --> 00:07:39,790

So here I can create one of the relation as a one to one relation with our catagories table to our user



134

00:07:39,790 --> 00:07:40,330

table.



135

00:07:40,330 --> 00:07:46,510

And here I must to have this field as the idea will be matched with our these categories table user



136

00:07:46,510 --> 00:07:48,550

idea and we initially match.



137

00:07:48,550 --> 00:07:49,870

I get this name.



138

00:07:50,060 --> 00:07:52,660

OK, that means this table user table them.



139

00:07:53,230 --> 00:07:58,010

So here, if you are working with this, you look into our end, then you can actually work with this.



140

00:07:58,010 --> 00:08:00,970

We, we have then you have to work into the model area.



141

00:08:01,240 --> 00:08:03,210

That means category model here.



142

00:08:03,220 --> 00:08:09,910

I have created one of the method and then I return and this has one and I simply load it to have this



143

00:08:09,910 --> 00:08:10,230

field.



144

00:08:10,720 --> 00:08:16,300

OK, so that's how you can actually create that religion of this table and you can get this data.



145

00:08:16,310 --> 00:08:23,380

And here I visibility with our user and then our film, I hope is very much clear to your friend Zino.



146

00:08:23,380 --> 00:08:24,190

Next video.



147

00:08:24,190 --> 00:08:30,250

I want to do the same thing, so I want to do the same things with using our query builder.



148

00:08:30,260 --> 00:08:31,540

So here I have used that.



149

00:08:31,540 --> 00:08:36,190

You look into Aughrim so we can do the same, that Misho can create that relationship.



150

00:08:36,190 --> 00:08:39,130

We do have this table with using that CareerBuilder.



151

00:08:39,130 --> 00:08:42,520

In our next video, I will show you that things with a live example.



152

00:08:42,970 --> 00:08:46,540

So thanks for watching and I will see you in the next video.