1 00:00:00,330 --> 00:00:01,030 Hello, friend. 2 00:00:01,050 --> 00:00:01,920 Welcome back. 3 00:00:02,330 --> 00:00:08,370 You know, previous video, we successfully completed our edited version and also we updated it right 4 00:00:08,940 --> 00:00:12,600 before we did that work with using that you're looking toward him. 5 00:00:12,990 --> 00:00:16,190 So here we edit it with using that to look into them. 6 00:00:16,260 --> 00:00:19,870 And also we have updated it with using that you look into autumn. 7 00:00:20,040 --> 00:00:22,950 So right now, I want to do I want to do the same things, OK? 8 00:00:23,010 --> 00:00:27,020 I want to do the same things with using that query builder so we can do that work. 9 00:00:27,030 --> 00:00:32,730 I show you like first of all, I want to edit it like here if you are trying to make it as a comment 10 00:00:32,730 --> 00:00:32,990 out. 11 00:00:33,360 --> 00:00:38,640 So if you want to edit, uh, the physical laws on the page with the edit the specific, one of the 12 00:00:38,640 --> 00:00:41,220 ideas or everything will be just like that. 13 00:00:41,220 --> 00:00:43,050 Same only in your controller. 14 00:00:43,360 --> 00:00:45,120 That means know category controller here. 15 00:00:45,130 --> 00:00:46,070 I want to update it. 16 00:00:46,440 --> 00:00:50,360 So here, if you use that query builder supposedly will be saved. 17 00:00:50,370 --> 00:00:52,890 My name it as a catagories again. 18 00:00:52,890 --> 00:00:58,470 So I take one of the variable of the categories and then I want to add that that means the DB. 19 00:00:58,500 --> 00:01:06,090 So I use that DB and then I add that there will be a table that means from which table you want to get 20 00:01:06,360 --> 00:01:07,760 the specific data. 21 00:01:07,770 --> 00:01:10,970 I want to get a specific that are from the categories table. 22 00:01:11,310 --> 00:01:14,320 That means here you have to do have to add these categories table. 23 00:01:14,460 --> 00:01:14,780 Right. 24 00:01:14,820 --> 00:01:19,950 So now I have these categories table and after that we have to do we have to put on the condition. 25 00:01:20,280 --> 00:01:25,890 We have to put that condition when our distinguished idee will be matched with our categories. 26 00:01:25,890 --> 00:01:31,770 They will this field idea that we will both of this will be match like if you click on the edit and 27 00:01:31,770 --> 00:01:36,650 when you consider to the eight ID, so that is the requested ID. 28 00:01:36,660 --> 00:01:42,300 So this idea will be matched with all these categories and decide when it will be matched then shall 29 00:01:42,300 --> 00:01:43,270 we get this data. 30 00:01:43,680 --> 00:01:46,500 OK, so here you have to do it, you have to add it. 31 00:01:46,770 --> 00:01:50,130 So for doing this I would want to add the word condition. 32 00:01:50,130 --> 00:01:58,410 That means the player where our database filename or database filename as the idea where our ID will 33 00:01:58,410 --> 00:02:02,850 be match or where our idea will be matched with our requested ID. 34 00:02:03,360 --> 00:02:06,060 That is this is that our requested ID. 35 00:02:06,390 --> 00:02:07,950 So we should be matched then. 36 00:02:07,950 --> 00:02:10,800 I want to do and to get one specific one data. 37 00:02:10,980 --> 00:02:11,360 Right. 38 00:02:11,370 --> 00:02:14,580 So here I want to load a specific one data. 39 00:02:14,970 --> 00:02:20,430 So if you want to load all the specific ones that are in CareerBuilder, you have to we have to be added 40 00:02:20,430 --> 00:02:21,390 as a father data. 41 00:02:21,540 --> 00:02:23,640 So here you have to add as a fast. 42 00:02:24,900 --> 00:02:30,050 So Namee to the fast data, OK, I hope is very much clear to you. 43 00:02:30,060 --> 00:02:35,840 So that is our DB and then our table from which they really want to get the specific data. 44 00:02:35,850 --> 00:02:42,540 That is where our database table in the category categories table filled at name as ID idea ideal be 45 00:02:42,540 --> 00:02:49,000 matched with our D requested I.D. And then I get this file data and I take these files that are the 46 00:02:49,040 --> 00:02:53,790 things with this variable and here I pass it in the compact, in our easy pace. 47 00:02:54,090 --> 00:02:59,670 So before I use that, we look into them and that is the same code for the rebuilder. 48 00:03:00,990 --> 00:03:06,350 Now let's check this out if you're going to save all and now if you go to all categories. 49 00:03:06,990 --> 00:03:08,430 So now if you can eat it. 50 00:03:08,610 --> 00:03:11,400 Yes, you can see the result is that just like that same. 51 00:03:11,430 --> 00:03:13,760 But right now we are using that CareerBuilder. 52 00:03:13,980 --> 00:03:14,220 Right. 53 00:03:14,850 --> 00:03:16,890 So now I want to do and update it. 54 00:03:16,890 --> 00:03:20,880 So before we have updated it with using that, uh, look into autumn. 55 00:03:21,060 --> 00:03:24,080 So here that is our update portion. 56 00:03:24,300 --> 00:03:25,500 So here we use that. 57 00:03:25,500 --> 00:03:26,680 You look at where I am right now. 58 00:03:26,680 --> 00:03:28,710 I have to learn to make it as a comment out. 59 00:03:29,010 --> 00:03:31,620 I want to use query builder. 60 00:03:32,040 --> 00:03:39,140 It will be very much easier to I hope I show you, like if you want to use that, you look into, um, 61 00:03:39,170 --> 00:03:42,000 CareerBuilder, then you have to add on the data. 62 00:03:42,000 --> 00:03:48,720 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 63 00:03:48,880 --> 00:03:50,980 area, you have to use that data. 64 00:03:51,120 --> 00:03:54,050 So with this data, you have to pass your all that field. 65 00:03:54,420 --> 00:03:57,150 OK, so here I pass our field. 66 00:03:57,160 --> 00:04:01,610 That means our database field, our database field as this one is a category name. 67 00:04:02,070 --> 00:04:07,250 So now and want to use this category name, OK, because it is actually pretty much the same procedure. 68 00:04:07,560 --> 00:04:12,560 So that is a category name equal to equal to our DG state category name. 69 00:04:12,930 --> 00:04:17,880 So before I have already discussed about the things we do that was requested and that is our category 70 00:04:17,880 --> 00:04:18,240 name. 71 00:04:18,240 --> 00:04:24,020 Right, for this category name is means whatever name you actually pass from this input field. 72 00:04:24,600 --> 00:04:27,600 So here I simply added that in the category name. 73 00:04:27,600 --> 00:04:33,240 And after that you have to add that semicolon into the query builder that they look into Aughrim, you 74 00:04:33,240 --> 00:04:34,380 have to use that comma. 75 00:04:34,620 --> 00:04:39,520 But when you use that as a query builder, then you have to use that as a semicolon. 76 00:04:39,540 --> 00:04:43,710 OK, and also on to do the same things for our another field. 77 00:04:44,040 --> 00:04:52,560 So here I take that as a data and data or filename or filename as a user ID and user ID will be just 78 00:04:52,560 --> 00:04:55,620 like Dersim, which will be as an authenticated user ID. 79 00:04:55,710 --> 00:04:57,120 So it's a bit odd. 80 00:04:57,120 --> 00:04:58,950 And then your user ID like. 81 00:04:59,790 --> 00:05:05,190 And also make sure you add that semicolon and after that, I have to do I have to update this data that 82 00:05:05,200 --> 00:05:10,800 means TV, even the DBI, our table from the reestablishment of the deed. 83 00:05:10,800 --> 00:05:16,490 I want to put it in our this catagories table that that is our catagories table. 84 00:05:16,500 --> 00:05:22,950 So now I copy it and here I paste our this catagories table and where you have to put that condition 85 00:05:23,250 --> 00:05:29,640 where again that means the fire, our same condition actually where our database field as the idea will 86 00:05:29,640 --> 00:05:32,100 be match with our requested ID. 87 00:05:32,580 --> 00:05:34,560 That is, that is actually our requested I.D.. 88 00:05:34,620 --> 00:05:34,920 Right. 89 00:05:34,950 --> 00:05:36,770 We did the same things for our edit. 90 00:05:36,780 --> 00:05:38,130 So now for the update. 91 00:05:38,130 --> 00:05:39,510 We also have to add it. 92 00:05:39,900 --> 00:05:46,080 So whenever this requested I.D. and our database stability will be match, then I want to do I want 93 00:05:46,080 --> 00:05:47,040 to update it. 94 00:05:47,340 --> 00:05:53,710 So here after that, I want to have it as update, update, update our this data. 95 00:05:53,880 --> 00:05:56,160 So now I want to on to add this data. 96 00:05:56,790 --> 00:06:00,120 OK, so that's all you have to do. 97 00:06:00,210 --> 00:06:02,640 So will be just like that. 98 00:06:03,060 --> 00:06:08,480 That's what this will for our rebuilder and this will for our education. 99 00:06:08,550 --> 00:06:08,760 What. 100 00:06:08,760 --> 00:06:15,540 And so when this data will be updated and after that it we can redirect to the same as it all plays 101 00:06:15,540 --> 00:06:17,180 with some of the success message. 102 00:06:17,190 --> 00:06:19,010 So here we don't need to change anything. 103 00:06:19,560 --> 00:06:20,250 So that's all. 104 00:06:20,400 --> 00:06:21,510 Now let's check this out. 105 00:06:21,510 --> 00:06:24,210 Our lives successfully complete our application. 106 00:06:24,210 --> 00:06:26,580 I'm not likely to save all. 107 00:06:27,000 --> 00:06:35,790 Now go here, go to all category now and bet that our RTM not because they are in one click category. 108 00:06:35,940 --> 00:06:36,450 Yes. 109 00:06:36,450 --> 00:06:42,430 You consider the category of successful and category is also better if you go to our database and the 110 00:06:42,450 --> 00:06:49,490 database, if you browse it and you can see our update, that is our category is name is now updated. 111 00:06:50,160 --> 00:06:52,230 I hope it's very clear to your friend. 112 00:06:52,230 --> 00:06:57,870 How can do that work with using that look at them and how can do this work with using that query builder. 113 00:06:58,590 --> 00:07:03,330 So here we successfully complete our edit portion and I have discussed both of these with you. 114 00:07:03,330 --> 00:07:06,780 So now in your next video, I will discuss about that Dilek portion. 115 00:07:06,900 --> 00:07:07,640 So do deal. 116 00:07:07,800 --> 00:07:12,010 I want to do I want to add as a sort of Philomene. 117 00:07:12,040 --> 00:07:18,180 So I think actually, first of all, the electorate will be saved as a temporary with our another area. 118 00:07:18,180 --> 00:07:19,740 And after that you can be elected. 119 00:07:20,070 --> 00:07:22,620 So can working with the soft elect. 120 00:07:22,620 --> 00:07:28,460 How can it be that this category that are permanently in our next video, I'll show you that things 121 00:07:28,470 --> 00:07:29,610 with a live example. 122 00:07:30,030 --> 00:07:31,740 So thanks for watching. 123 00:07:31,740 --> 00:07:33,570 I'll see you in the next video.