1
00:00:05,740 --> 00:00:08,640
Here everyone now we have greatly different and beckon.

2
00:00:09,240 --> 00:00:12,240
It's time to combine them so that they can flock together.

3
00:00:12,850 --> 00:00:19,360
So first of all we will begin the review and such so that we can have some data here.

4
00:00:20,120 --> 00:00:24,480
And after that we will work with the add and delete view and before.

5
00:00:24,550 --> 00:00:29,320
Because if we add something we also need to see that whether it's added or not.

6
00:00:30,190 --> 00:00:35,710
So first of all let's begin with the view now here for you.

7
00:00:35,730 --> 00:00:43,900
I will add a command in the View button that is view all that we call our function save you.

8
00:00:43,890 --> 00:00:47,060
Come on you underscore.

9
00:00:47,070 --> 00:00:47,930
Come on.

10
00:00:48,160 --> 00:00:51,710
Maybe go and then we will define that function.

11
00:00:52,520 --> 00:00:56,700
So define view come on.

12
00:00:56,780 --> 00:00:58,730
Without a barometer there.

13
00:00:58,730 --> 00:01:01,100
Now in this one that's very easy.

14
00:01:01,100 --> 00:01:02,050
What will I do.

15
00:01:02,090 --> 00:01:05,610
I will first make this one list completely empty.

16
00:01:05,660 --> 00:01:13,010
Then I will fetch all the rows of a level in the back and view all and one by one insert them here.

17
00:01:13,820 --> 00:01:15,830
So I hope you go to these three steps.

18
00:01:15,830 --> 00:01:21,010
First delete everything so list dot delete everything.

19
00:01:21,080 --> 00:01:23,280
And how 0 2.

20
00:01:23,290 --> 00:01:34,220
And so from 0 to end I will delete everything there after that one full roll in now where I require

21
00:01:34,220 --> 00:01:45,110
them in the view met turn over against a view function of back and so back and don't view the view.

22
00:01:46,280 --> 00:01:55,490
So this will one by one work with the every single row every level in our database and then I will insert

23
00:01:55,610 --> 00:01:58,470
all of these here in this list books.

24
00:01:58,730 --> 00:02:10,280
So just list not insert and from there from and to number of flows available or whatever that is particular

25
00:02:10,290 --> 00:02:10,910
at that point.

26
00:02:12,000 --> 00:02:17,670
So here I have ended at the end and off the end one by one I will include all the rows of a liver.

27
00:02:18,300 --> 00:02:20,480
So save this one.

28
00:02:20,490 --> 00:02:25,280
And when I run this one I know David go this one click on visual.

29
00:02:25,560 --> 00:02:27,990
David go with the all available.

30
00:02:28,680 --> 00:02:29,970
So I have done there.

31
00:02:30,090 --> 00:02:35,880
And now one thing you need to notice him when I am whenever I'm clicking any of these I'm getting a

32
00:02:35,880 --> 00:02:42,020
type better so that's something we are going to define get selected draws.

33
00:02:43,010 --> 00:02:45,070
But wait for that one.

34
00:02:45,230 --> 00:02:46,550
Now here we are done with this display.

35
00:02:46,940 --> 00:02:56,570
Now what about the search so for that one I will define end of function search underscored.

36
00:02:56,570 --> 00:03:09,890
Come on maybe go and view that one in this search button where we have that Mondale so command equal

37
00:03:09,890 --> 00:03:13,190
to such underscore.

38
00:03:13,190 --> 00:03:13,890
Come on.

39
00:03:14,190 --> 00:03:17,210
Daniel no.

40
00:03:17,260 --> 00:03:20,450
How will I make that happen is way too simple.

41
00:03:20,770 --> 00:03:28,380
I will take whatever the user is entering them and pass that one in the back and search data will look

42
00:03:28,380 --> 00:03:33,060
out for that particular barometer that how many jewels are available they have a debt barometer and

43
00:03:33,060 --> 00:03:36,970
they've written all the details so this is most of like The View.

44
00:03:36,970 --> 00:03:37,690
Come on.

45
00:03:37,870 --> 00:03:43,000
I'm just coming this one because first I need to make the list box empty.

46
00:03:44,170 --> 00:03:48,520
And then for every row in back and don't search.

47
00:03:50,170 --> 00:03:55,420
So whatever the number of floors available there I will insert them in here.

48
00:03:55,450 --> 00:03:58,920
What difference here is I need to pass the.

49
00:03:59,130 --> 00:04:01,030
That what I'm looking for.

50
00:04:01,030 --> 00:04:09,250
So I will pass that particular parameter here like the one that we have used here for the entries because

51
00:04:09,250 --> 00:04:13,480
whatever we are entering in the entries.

52
00:04:13,480 --> 00:04:20,840
So this is right now we have no defined function completely so whatever we are acting in the entries

53
00:04:20,840 --> 00:04:22,650
are stored in these variables.

54
00:04:22,700 --> 00:04:26,480
So we need to take the variables and provide them here.

55
00:04:26,630 --> 00:04:33,710
And if you do simple like this one then that will also not work because to get the variables written

56
00:04:33,710 --> 00:04:41,810
in the entries we need to use a method known as gate that will get the value available at that particular

57
00:04:41,810 --> 00:04:46,310
variable or say entry to a main program.

58
00:04:46,310 --> 00:04:51,530
Generally we have to go into the method GET and POST but here we are going to use the gate.

59
00:04:51,620 --> 00:04:54,170
So here we will use this one in this way.

60
00:04:55,280 --> 00:05:04,640
And similarly for all of these like earnings underscored text don't get the view.

61
00:05:04,790 --> 00:05:16,100
Then we have exercise and the school text don't get maybe old and sturdy underscored text don't get

62
00:05:17,510 --> 00:05:26,230
after that one died underscore text don't get so it will just dig the variable peasant at that particular

63
00:05:26,290 --> 00:05:35,580
entry and its value and passed it on here and in the last 5 10 score X don't get David go.

64
00:05:35,710 --> 00:05:36,760
Now we are done with this one.

65
00:05:38,280 --> 00:05:42,260
Just save this one have provided the search for Monday.

66
00:05:43,320 --> 00:05:47,660
Now just on your program here and illegal.

67
00:05:47,880 --> 00:05:51,650
So we got some error that is generating come.

68
00:05:51,680 --> 00:05:53,100
That's a spelling mistake I believe.

69
00:05:53,880 --> 00:05:55,760
So do we have any better.

70
00:05:56,130 --> 00:05:57,780
So see your let.

71
00:05:57,790 --> 00:05:59,940
Indeed that is.

72
00:05:59,970 --> 00:06:03,080
Sorry for that one and let me read it right.

73
00:06:03,180 --> 00:06:03,920
You.

74
00:06:04,170 --> 00:06:05,390
Now we have this one.

75
00:06:05,670 --> 00:06:07,230
We all will.

76
00:06:07,650 --> 00:06:10,700
And now I will search for did exercise.

77
00:06:11,010 --> 00:06:15,920
So did exercise search.

78
00:06:16,250 --> 00:06:18,750
David go with the exercise.

79
00:06:18,740 --> 00:06:26,030
Now did you study David Eagle just one day.

80
00:06:26,530 --> 00:06:27,560
Then fun.

81
00:06:27,560 --> 00:06:32,750
1 2 0 1 9 search that is only available there.

82
00:06:33,680 --> 00:06:40,170
After that one earnings say 400 you won't debate such.

83
00:06:40,490 --> 00:06:43,360
Only this one two hundred.

84
00:06:43,610 --> 00:06:48,620
We have to and for that are not available like 900.

85
00:06:48,810 --> 00:06:49,580
We have them.

86
00:06:49,650 --> 00:06:52,090
We have an empty list box.

87
00:06:52,170 --> 00:06:52,770
So there we go.

88
00:06:52,770 --> 00:06:55,870
We did one other search command and view Commander booking.

89
00:06:56,040 --> 00:06:57,670
Perfectly fine.

90
00:06:57,750 --> 00:06:58,950
Now just add and delete.

91
00:06:58,950 --> 00:07:02,220
Come on that we are going to cover in the next videos.

92
00:07:02,220 --> 00:07:03,280
So thanks for watching.

93
00:07:03,280 --> 00:07:04,320
I would say in the next video.