Hello, friend.
Welcome back.
You know, previous video, we successfully completed our edited version and also we updated it right
before we did that work with using that you're looking toward him.
So here we edit it with using that to look into them.
And also we have updated it with using that you look into autumn.
So right now, I want to do I want to do the same things, OK?
I want to do the same things with using that query builder so we can do that work.
I show you like first of all, I want to edit it like here if you are trying to make it as a comment
out.
So if you want to edit, uh, the physical laws on the page with the edit the specific, one of the
ideas or everything will be just like that.
Same only in your controller.
That means know category controller here.
I want to update it.
So here, if you use that query builder supposedly will be saved.
My name it as a catagories again.
So I take one of the variable of the categories and then I want to add that that means the DB.
So I use that DB and then I add that there will be a table that means from which table you want to get
the specific data.
I want to get a specific that are from the categories table.
That means here you have to do have to add these categories table.
Right.
So now I have these categories table and after that we have to do we have to put on the condition.
We have to put that condition when our distinguished idee will be matched with our categories.
They will this field idea that we will both of this will be match like if you click on the edit and
when you consider to the eight ID, so that is the requested ID.
So this idea will be matched with all these categories and decide when it will be matched then shall
we get this data.
OK, so here you have to do it, you have to add it.
So for doing this I would want to add the word condition.
That means the player where our database filename or database filename as the idea where our ID will
be match or where our idea will be matched with our requested ID.
That is this is that our requested ID.
So we should be matched then.
I want to do and to get one specific one data.
Right.
So here I want to load a specific one data.
So if you want to load all the specific ones that are in CareerBuilder, you have to we have to be added
as a father data.
So here you have to add as a fast.
So Namee to the fast data, OK, I hope is very much clear to you.
So that is our DB and then our table from which they really want to get the specific data.
That is where our database table in the category categories table filled at name as ID idea ideal be
matched with our D requested I.D. And then I get this file data and I take these files that are the
things with this variable and here I pass it in the compact, in our easy pace.
So before I use that, we look into them and that is the same code for the rebuilder.
Now let's check this out if you're going to save all and now if you go to all categories.
So now if you can eat it.
Yes, you can see the result is that just like that same.
But right now we are using that CareerBuilder.
Right.
So now I want to do and update it.
So before we have updated it with using that, uh, look into autumn.
So here that is our update portion.
So here we use that.
You look at where I am right now.
I have to learn to make it as a comment out.
I want to use query builder.
It will be very much easier to I hope I show you, like if you want to use that, you look into, um,
CareerBuilder, then you have to add on the data.
So I take all of the data out of here, OK, I take one of the data at it and after that into the data
area, you have to use that data.
So with this data, you have to pass your all that field.
OK, so here I pass our field.
That means our database field, our database field as this one is a category name.
So now and want to use this category name, OK, because it is actually pretty much the same procedure.
So that is a category name equal to equal to our DG state category name.
So before I have already discussed about the things we do that was requested and that is our category
name.
Right, for this category name is means whatever name you actually pass from this input field.
So here I simply added that in the category name.
And after that you have to add that semicolon into the query builder that they look into Aughrim, you
have to use that comma.
But when you use that as a query builder, then you have to use that as a semicolon.
OK, and also on to do the same things for our another field.
So here I take that as a data and data or filename or filename as a user ID and user ID will be just
like Dersim, which will be as an authenticated user ID.
So it's a bit odd.
And then your user ID like.
And also make sure you add that semicolon and after that, I have to do I have to update this data that
means TV, even the DBI, our table from the reestablishment of the deed.
I want to put it in our this catagories table that that is our catagories table.
So now I copy it and here I paste our this catagories table and where you have to put that condition
where again that means the fire, our same condition actually where our database field as the idea will
be match with our requested ID.
That is, that is actually our requested I.D..
Right.
We did the same things for our edit.
So now for the update.
We also have to add it.
So whenever this requested I.D. and our database stability will be match, then I want to do I want
to update it.
So here after that, I want to have it as update, update, update our this data.
So now I want to on to add this data.
OK, so that's all you have to do.
So will be just like that.
That's what this will for our rebuilder and this will for our education.
What.
And so when this data will be updated and after that it we can redirect to the same as it all plays
with some of the success message.
So here we don't need to change anything.
So that's all.
Now let's check this out.
Our lives successfully complete our application.
I'm not likely to save all.
Now go here, go to all category now and bet that our RTM not because they are in one click category.
Yes.
You consider the category of successful and category is also better if you go to our database and the
database, if you browse it and you can see our update, that is our category is name is now updated.
I hope it's very clear to your friend.
How can do that work with using that look at them and how can do this work with using that query builder.
So here we successfully complete our edit portion and I have discussed both of these with you.
So now in your next video, I will discuss about that Dilek portion.
So do deal.
I want to do I want to add as a sort of Philomene.
So I think actually, first of all, the electorate will be saved as a temporary with our another area.
And after that you can be elected.
So can working with the soft elect.
How can it be that this category that are permanently in our next video, I'll show you that things
with a live example.
So thanks for watching.
I'll see you in the next video.