All right.
So what we need to do is we have already decoded the client info.
So what we have decoded we have you know we have put it into a list.
And that particular list we have got we've indexed this year with element and that name and the first
Telemann than that e-mail us and the scores I'm just saying got a connection from client that address.
Now I need to fire.
I need to fire.
Oh Claudia where I need to run this particular this particular I need to store this name in email in
this particular table clients.
Right.
So I need to write the SQL query so it's insert into uncertainty you can have a look from my connecting
to escalate what was the query given inserted to teachers the ID name gender and stuff like that so
we can just put them out here.
So instead of putting a triple double code put a triple single called so because there's gonna be some
codes which are going to come all right to insert into a teacher's right or insert your teachers or
we hear it's going to be insert into into the table name is clients.
Right.
So insert into Clines and we need to say insert into Kline's and have a look once again at what are
the different parameters and what are the values that we need to insert.
So we need to say insert where is that insert into clients and you just to say let's say out of that
I want to put the name I want to put email of course and let me save the idea.
I want these three things to be put up and the values are going to be this right so I'm going to say
space values are going to be values are going to be whatever the values you need to say.
And if it is a string you need to put in double quotes right.
So that's what you need to put up there.
So what we can do is what we can say is we can say values and of course we need to insert the name with
Savarkar.
You need to insert the email which is also a gap which is going to be e-mail.
Now the problem is now if I put just double code name it's going to put there it's not going to put
the variable name.
Not going to put this variable name but it's actually going to put the string name right.
So I need to insert the variable there.
How do I do it.
I need to put the you know I need to use the doc format so I can say the sun is zero I need to insert
the 0 element the first element and let's say what we here first and then I need to address is also
going to be is also going to be a string.
Right.
So I'm going to say this is going to veto though.
Yes it's going to be the second element which is going to be put up in curly braces right.
And of course we close.
Insert into clients.
This particular thing so I close up with this stripper code and close it up.
Right.
But I need to say I need to see a dot format where I need to insert into the zero one two I need to
insert the variables name email and ETR so I'm going to say Dot Dot format dot format and there any
way to say wherever there a zero I need to put I need to put the name.
Then the email and then the EDTA.
OK so name email NDA.
So what.
So.
So this is the minute the minute it connects.
And all these other things which which needs to be stored in the database.
And of course once these things are done let's say for example after they are done I just need to you
know got a connection from client address and stuff like that.
And so I have to put up let's say whatever I have inserted into I'm going to put it up here and there.
All right.
So I have I fired the Square-D.
No I have not fired the query which means that the 5 Square-D by saying I have to scale there is Daut.
That's the query the query has to be because ADOT Cazador execute after execute the query.
Right.
And of course after executing the query I also need to say a connection come at the rate which will
come at whatever has been done.
Fine.
All right.
And then after committing the committing to the connection now let's say so I got a connection from
client address and are in name.
Yeah that can be told fine lines of names kind.
So I'm sorting the con in a dictionary.
That's cool enough.
OK.
But then comes that comes something let's say let's say for example.
I have to work with now when I start with a new trade in each thread I have to go with it.
You know I need to I need to use new curso that's something which which you will understand in some
time.
Right.
So let's say we do this and then what we can do is are to execrate and the new trade in E-2 OK.
So what I can do is I can just fire it up for now I can just execute it afterwards.
We'll see what what changes can be done in the trade so as to display to know good fashion.
All right.
So I'm going to run though sober sober code once.
Let me run it up and let me see it.
There is no problem.
Control shift.
S10.
All right.
My server is running fine and right.
And my client.
I need to run it up when I run this.
What does it say.
Anti-O names so let's see X Y Z and excelsis into name.
All right.
And it says into your e-mail socity X Y Z at company dot com.
Right.
Let me have a look what's come to the Silverside is there any of that is an error.
What does Yerra operational need are.
That's OK.
So that's the error on line number 32.
So just have a look at in the server.
Have a look at line number 32 32.
Get ready queries executed as a problem.
Why.
Because why because you have in the ETR The address is nothing but it's going to be these two Karev
meters.
Right.
So that's something which we have.
We have these two parameters which are which are there.
So what we can do is we need to as a result of the OK.
All right.
So the idea are we need to because it is already an address in itself.
That's the problem.
OK.
So it's a strain.
So what we can do is for now before I fire the Square-D Can we just print this address and the type
of address and just check it out.
So right so predated your
and print type of rate so we can rerun this.
You can stop this and we can rerun this and just check out what happens.
Correct.
So let's say we'll disclose all of them close all.
And we read on this and we can just type.
You know we can just get it printed before executing the query.
So even this needs to be commended out.
We'll just check it up first and then go on.
One error at a time.
So it's just table Kline's already exists.
So that's one problem we have all we create the stable client.
So what we gonna do is be let's not create the table Cline's once again because we have created it once
when we ran the program it ran into an error only after coming here.
It's a step by step program so let's not run it again.
Let's just make a connection and let's say control shift 10.
So things are running fine.
Client control shares turn 10 so into name x y z x y z at company dot com
it's going as your object has no attributes de-code.
So where's that name that de-code going to be there.
It's in line number twenty eight of sherbert that I.
We don't need to decode this because the name is already a string we already have decoded.
Each of them in detail right.
We had a decline in foaled de-code and then we got it into a list and stuff like that so we don't need
to decode this up it's already done.
The arguments are just name.
Conn and ADR.
That's true.
So let's stop the client too and the server is already stopped.
Let's run the C on the server multiple reruns will help us to find out multiple.
Which which can cause us to figure out how to debug our code at company dot com.
So things are fine.
Got a connection from client and address this now.
Hello.
The address that we have got is a class topper.
OK.
And it consists of a string and it consists of this.
Right.
So what we can do is we just need to store the address.
OK you want to store even the part number then what you need to do is the top needs to be converted
into a string.
Right.
So what we can do is instead of we can just print we can convert this SD CRB Jarobi and and just recheck
it once again.
So we'll stop this and stop the client and let's let's close close all control chip 10 and let's read
on the client to control this 10.
So it's going to be x y z x y z at company dot com.
Got a action from address and name so it's ok right.