Here you go.
So welcome to another video about the Bakken.
So I have submitted the video input too because that one it became very large and I need to explain
this search Come on.
So that's why I speak a decision so a fresh video full of fresh folks.
So let's begin this search.
So define search.
So for that one before defining this one let me add some values there so that we can search some of
the values in that one.
So insert first let we have 1 1 2 0 1 9 then hundred after that one did exercise.
Then after that one what we have there
study so did study after that one night taken
and then last.
We have by.
So step by step maybe go and copy these value goes down using so they we have this one and one more
in so tail and the debate say the same for 1 0 1 9 data with one done based this whole so not deed which
is this study not study medical instrument same maybe go with this.
Now let me feel drained.
View and Dave we had three entries.
One is with one to 2019.
Then one by nineteen then four for ninety so now that we remove these lines and define of as such.
So search is something that we have not done before and is very easy.
Most of the commands are seen like this but not like this like the feel for because we need to have
some role that will fetch the values and show the up.
So they we have these values and what we require to change here required to pass better meet us in view
we have no parameter.
But in this one we need to positive better does so all these Ben-Ami does.
There must be these
pass them him.
No.
What in case when the user just entered the exercise or just died.
What about the the enemy does.
So what really we do here.
We will pass empty strings so they are going to be empty strings then
so incase.
User did not enter anything then by default their value is null.
So by this you posited me does to this such comma after that one.
In this one select start from Robin will remain same.
What will change here.
The condition here we need to just add via data equal to caution Mark.
And now we will use or condition like user is going to provide one value.
Then what we will do will use or condition that feature one of these is provided by the user.
And no cash go my SO earnings equal to caution Mark board.
If user had provided the exercise so exercise equal to question mark or this study equal to portion
mark or die equal to question mark and then last or buy ton equal to question mark debut now off to
that one I call my here and just pass these parameters so copy from there based them here we go.
Now this is the search function that really quite saved this one.
And now let me try.
So search first X is equal to search because we also need to discern and search something like data
will do and what data we have.
Say for 1 2 19 so 4 1 2 0 1 9.
Then print x save run data go only the one that have this date for 1 to 90 and if I do something like
what we have the things there.
These two common two hundred and two hundred so earnings equal to 200.
Need to wonder.
Now we have two of out of three.
That is 1 to 19 and 4 1 2 19 with 200 earnings.
So this is a search common and perfectly working fine.
So all of our commands are working fine here.
Now we have a perfect database.
Just there are two things too many first one.
Just imagine we are working with other application and at this point we had the database.
What if it doesn't have the database.
So we have done here something like we have first connected this one by using the function first connect
and at that point that is created a table in the database.
But what if there is no database then we need to again call that one.
So this is the first thing we need to add here a connect.
Come on.
But what if there is already existing data.
So in that case it will provide me an ETA like I had saved this one.
And when I run this one I got the data by table who already exist.
So what.
In that case.
So what we will do here is we may make this one remain here and we will add one more line here.
Create table
if not existence.
So if the table in the database doesn't exist that create a table.
Otherwise we have that table already so if we do this fun and run the file legging then deal in that
case we could no end game no way to.
So this is complete about a bacon and now we did not require any change in despair we would just add
a line here in the boat back and that's enough save this one and we are done with this.
So this is about this video in the next video we looked at how we can connect these.
So thanks for watching and I would see in the next video.