Well let's go Also if you want you know we can just access these things.
You know just when the guys chat is coming to the other side instead of just telling his name we can
also give his email lady.
You know this guy with his email ID is seeing this or you know or something like that if he wanted to
add such stuff.
You know you want to get this entire thing into place.
Then what we can do is we can we can actually state are we here before sending the data right before
the message the client name plus I'll have to add also along with the client name.
I also need to add that e-mail.
So I need to hit the obviously here.
So when I have to hit the is you know I need to hit the database and I need to say oh we're here I can
again let's say I have to say exactly the same thing as costarred executes Sinistar from instead of
I'm going to say here silks are from clients and I need to see where where.
Name equal to name equal to.
And now I need to see a word here namely equal to what I need to put down.
There is a dark format at right instead of the word name equal to what the name of the particular client.
So I need to say Kline's score me.
So with that I get all the details of that particular client from the database.
Right.
So once they get all that the yields will decline from the data is OK I can say I've got that here and
I've got the results here.
I can access the result and if I print if I print you know if I for now let me just print the result.
Now there's one thing that I need to say is Is it because we have you know we are we want to create
these client once again X-Face that we will we can drop them from this particular from this particular
table for now we can drop this entire table and you know we can create a new client we can create a
new table.
So what we can do is we can create a table but after dropping the existing tables so cursedly execute
I can drop the table and create once again every time the server reruns.
So I can say drop you can have a look at the escalating tax you can have a look at the documentation.
Sorry.
Or you can just right there dropping table in a skylight so I can drop that.
So it's just the statement is just drop table and.
And the name of the table that's it.
So you can just say that out there so you can have a look.
So I just have to say is a drop drop table and in the name of the table.
So if my Also you can also do create table if not exists.
Right.
So this is OK but then I want to drop it first so I can just say drop table addresses so that the table
name.
So I can just say a draft table.
Clines right.
So I run that out and.
And then I create the clients once again.
So what I'm going to do is I'm going to close all of these Ptomaine all of them.
They really run this and and we run the first client.
When you say x y z x y z at gmail dot com Nemuro another client then you say you are.
Q Are at each company that come
let me say the client is
and DFI at company that's come once again.
No the silver gets all of these registered back into the you know.
So you created plans as of now.
This is one the decline was the number two.
All right.
Now if any one of the clients sent some message saying Hi it's going to come to all of the clients.
Oh wait.
What has happened is there's an they're healthier here that's why it's not executing to that rate.
So what's your.
Yeah.
So escalate objects created in a trade can only be used in that same.
The object rescript.
So you can find you cannot use the object of a skylight in on trade.
So we need to create a new escalator object once again in a new thread.
Right.
So we need to create that in a new thread in general and execute it once again.
So squaw's you have to stop all and close everything somebody told them I need to make that connection
once again.
So connection.
And then we just get that curso and then do it once again out here.
So basically I need to get that.
And of course save it run it.
Let's say so.
Klein one ready x y z x y z at gmail dot com.
Then comes to p q r p q r at company dot com.
So we test one thing at a time.
Let's just go ahead.
Let's say hi from X Y Z.
Let's see if the cure doesn't get it which means it's an error in server.
Once again there's no such column X Y Z where name.
OK so it says there is no such column x y now y so because X Y Z is not a column but X Y Z where name
equal do I need to put that in the string right.
So these are a few things that you do it while you know and this is the string x y z is going to be
a string.
So I need to put that out there.
Rename it do you know when I put that.
So that's what the field syntax requires.
Again close all terminated so it's a process which is how you build the code with some kind of errors.
Keep executing it.
And to properly enter your name.
So there you are
one more client.
And let me say OK.
So high for a client from X Y Z Oh it's appears there's no error as of now.
What are you going to look.
Got plans registered as of now.
And now I have just you know it gets printed all the details of the client X Y Z gets printed because
of this line it is this line which is printing this particular line whenever that particular guy sends
a message.
So if I send a message from p q r let's say hi.
So it gets printed.
That particular guy's details in result.
So what I can see is this sort of printing results.
I don't want the result to be printed.
I can just print all the Silverside result off zero.
That's the name.
I can just say send a message.
For now that's all the Silverside what I need to append this Klein name and I need to put in brackets
right.
So I'm going to put a string and append.
OK so client namespace I'm going to put in bracket.
I'm going to put the doc format.
I need to put their resolves
get a result of zero is just going it's a list of top notes.
It's just going to get me to the top result of zero.
But I need to get into into the e-mail so I can just the result of zero the first element in the result
of zero and here result of zero and the result of zero Colin zero.
That's the name of the guy.
So I close it and say doc format and of course I put that here.
OK.
And Joe Klein the name of it
plus I add his name email and it costs
less neither Dick.
So with this we are done with the flow of it.
The e-mail lady
we can get the entire thing up and running.
So let's close all.
Hopefully this should be our last try.
Server so server is running fine.
Client Number 1 x y z x y z at company dot com.
Right.
Well let me run another client P-Q or at gmail dot com folks.
I wrote in the wrong name.
OK no worries.
OK I'll just close everything it's going to look good.
Let's rerun it again.
This
raked
and once more
so you have three clients three of them registered.
Let's see haif from X Y Z.
What comes up here.
X y z z Mileti colon Hai and that comes to about let's say hi from here.
DPF within the military colon.
So you can go over here X X Y Z send a message DPF send a message.
SPQR also sends a message.
Hi guys.
That goes to both of them with P-Q us message and also P-Q or send a message comes in the social.
So you know you can even add a client and into the chat.
So you have a group chat and that's awesome.
OK we're going to Delap this father hopefully.
Right.
OK.
So this is about databases and dolls and networking.
We can go deeper into this and the later for now what we can do is let's go ahead with another concept
and that's going to be in the next session.