Hello, friend.
Welcome back in a previous video I have already shared with you.
How can you set this data with using that Akwe Builder?
And that is our program.
That means that looking toward him and also I share both of these Web sites right now, but I want to
to make it as a comment that is actually builder and I want to open it with our new look into.
OK, that is already looking at what.
So it's also successfully work, as I told you before.
So right now I to do on to actually get all that out that I have already answered all the data.
So now I to do to get all the data and visible this data in our particular, this area.
So how can do that work.
So if you want to do that work, they have the tooltip, you can do it, you can use that.
You're looking at what you can use that query builder social, both of these.
So first of all, I want to work with this looking toward him.
So when you're working with this, you look into what will need our model.
Right.
And also this base that means here I have lauded one of the base.
So this piece I have loaded, if you go to our category controller, if the category controller, you
can see I have already created the method as an all cat method.
And here I return our view admin catalog and the index base.
So here we have to do we have to pass this data.
Right.
We have to pass all the third category data from our database and then we have to load it.
So here we have to do have to work in particular this method area as all cat.
So now I want to do I want to, first of all, use that look into our M.
So here I want to undertake one of the variables.
I want to take one of the variables as a.
OK, name each of the categories or whatever you want.
So now after that, we have to do we have to add our model.
Right.
So I have already loaded our model as a category model.
So with this category model, I want to do I want to get all that our data.
So if you want to get all the data here, you have to do with this category model and want to add our
all data.
So that will be our all data.
So I take all that our data and take that things with this variable.
Now we have to do we have to pass all the other categories, data in our TS index based.
So if you want to pass it, what exactly you have to do?
I have already discussed about that things with your friend here you have to do.
We have to pass it with the compact.
Right.
So that is a compact.
And with this compact and the compact area I want to do and to pass are all the data.
So I have already take all that our data, the things with this variable here, I have to pass it.
So now we can actually use it.
Right.
So now we can actually use our these categories data that in these categories that are in our these
index based.
So now go to our index base.
So that is our admin category and the index so well into the view.
So that is a view add mean category and the category that we are index based.
Since the index is here, I want to do all the visible it right.
So here I want to visible it.
So first of all, I want to want to update this portion.
So here I want to display that serial number.
I want to display that category, name, category name.
That will be as a category name.
And also I want to display that user name.
OK, use a name that means that user and the created at Perfect.
So after that, there is a word for loop.
So here we have to do we have to add that for each.
Right.
I hope you already remember that part.
We have I have already discussed about that things with you.
So no simple word simply I want to do want to add that as a for loop, as a foreach.
That means that for each and all the for each from here, I have already posted a past as our categories.
Right.
I take that data with this variable, all that our category data.
So now I take it as a category.
So now I trying to do and as I need as a as category or whatever you want.
You can also make it as a rule, I made it better as a category.
OK, that will be as a category.
So now with this category you can actually display all the data and also we have to do we have to end
it.
That means we have to end our foreach as and for each.
OK, I added.
So now, first of all, I want to do an divisible our category name.
So now with this category.
So here.
OK.
So here with this category and the visible are filename for the category name.
I have already declared that our field name, our field name will be as a category name.
Right.
So if you go to the list texture and it this texture there is a category name, I copy it.
So I want to display our category name and also with this category.
OK, but I copy it.
So with this category I want to do the visible our another authenticated user name, so authenticated
user.
That means that the user really suffering right now.
So we actually display our user ideas of one.
That means you can see.
That is all that I will be doing, the relationship with another table as I use a table and from the
user table, I want to get this data so we can create some the relation we do have.
This table will also show you right now.
I also want to display our user ID, our user.
I feel that I will be visible.
And then also I want to visible our creator that that means here.
But I copy it.
I copy it and it will be our filename, our filename as a created that right.
So now to do that, these are created, created underscore at.
OK, perfect.
So that's all you have to do.
So now let's check this out if you're not together, Savol and now if you go here and refresh it.
Yes.
You can see so perfectly getting all that our category, our user.
And as I told you friend lately, I will create some of the relation with our another table that that
is our user ID should be rejected.
On the relation with this user table and when our idea will be met, then I get this name so we can
create that relation.
I will show you that things later.
Don't worry about it.
Everything is step by step.
I will show you.
OK.
So right now that is our category name is perfectly visible.
Our user, indivisible and created ad is visible.
So for this card here I use that our query builder.
So we will do it's not created any date.
And also there is a serial number.
So if you want to add the serial number, I think you already know about it.
See here you have to do we have to add on the PSP.
So name it as a PSP and leave the area.
I want to take one of the variable.
I take variable as I and then I make it as a standard which will be standard from the one.
And here, here I want to do want to actually add it right.
So if you want to add it then you have to do you have to add it with this variable.
This variable will be as a plus plus there all because I save all.
No, refresh it.
Yeah.
You can see it's perfectly updated.
Right.
And also if you want to change the date from it, you can change the date from it.
As I told you friend before, that is another function.
That is another function as a def for humans, for humans.
So if you use that function, then automatically our D created that format will be changed clear to
save all.
And now if you go and refresh it now, considering it's now showing some of the outer, it's showing
this error as it is not is null.
OK, that is it.
Now, because of all, if you go here, you can see for this card that have not created a date.
So for the results actually getting this at different to you want to feel to actually be this very much
easy.
One of the function I want to add that is one of the conditions I want to add here.
That means that is collected.
So I want to do to add one of the if condition.
So I simply add another if condition, if our I want to do if our category.
That means with this category, with this category and takes this out, this category at with this category,
I want to access our this category.
So I want to put this current condition will still be equal.
Now then it should be display one of the another message rather than it should be displayed all that
our D our Direk that form it.
OK, so here I want to put this up on the condition.
So when our with this category and to access our this database field, that means that is our database
field as a created that we will be OK.
We need to be as equal equal now that is when it will be as now.
OK, that means when this field is empty then it should be short on the message.
So to do and to add some disspain better.
OK, I add that Espin and I close that Espin.
I hope you enjoyed very much.
So if you know that very I mean core functionality, how much easier it is you can say.
So I add all of this spin class.
I want to add in the spin class and into the spin class.
I want to make it as a text Djenne danger.
Danger.
So that will be the text danger.
And here it will be displayed as a law and dot date.
OK, no date set to this step of one of the messages will be displayed and elds else it shall be displayed.
Our previous one that means ls aless will be display our this one OK.
And also make sure you and that Arafeh condition so and it as and if condition perfect.
So friend.
That's all you have to do now.
Let's check this out.
If you look at the save all and now if you refresh it, yeah, you can see when they have done it,
it still be displayed that dead from it.
And when they have now, they'll actually display this message.
How much is this?
How much is it for this condition?
So that is the one of these small condition when our category field and then with this Category I or
this category at field in this field is empty.
It should be displayed this message and else it shall be display our default one.
OK, that means all the dead formatted that are visible.
And then I simply add if perfect.
So here is now successfully display all the data from our database.
And also that is the ascending and the descending order like here if you now create a new one.
OK, if you create a new category, if the add category here, you can see these categories inserted
into the last.
So here, if you want to make it as a fast, then you can also make it.
So for doing this, you have to do we have to update your controller.
That means the controller.
That is our category.
I get all the data.
So if you want to get that latest product, then here you have to do have to change it.
So here you have to add that latest.
OK, latest.
That means the latest one will be sure in our forecast.
And then I want to get this data.
That means right now our latest data will be displayed into the fast and every condition will be the
same.
OK, you get this data, the latest data, the fast and easy to get this data with this variable here
compacted and then it will display in our index base.
That means here to display.
Now, let's check this out.
If you're looking at the save, also here, I have updated our latest data.
Now, everything will be very clear.
The refresh.
Yes, you can see that is our first data.
I have already answered that.
Right.
So you can see that is are fast.
About a fifty eight second ago.
That is a 32 minute.
There is a 33.
So all the data is now visible in our fast area.
So friend, here I get all the data with using that you look into R.M. So how can get this data with
using that query builder in our next video.
I will show you that things with a live example.
So thanks for watching.
I'll see you in next video.