WEBVTT

00:00.560 --> 00:00.870
All right.

00:00.870 --> 00:05.570
So what we need to do is we have already decoded the client info.

00:05.670 --> 00:11.890
So what we have decoded we have you know we have put it into a list.

00:11.940 --> 00:18.280
And that particular list we have got we've indexed this year with element and that name and the first

00:18.280 --> 00:25.130
Telemann than that e-mail us and the scores I'm just saying got a connection from client that address.

00:25.140 --> 00:28.020
Now I need to fire.

00:28.860 --> 00:29.800
I need to fire.

00:29.830 --> 00:42.180
Oh Claudia where I need to run this particular this particular I need to store this name in email in

00:42.210 --> 00:44.140
this particular table clients.

00:44.270 --> 00:44.850
Right.

00:44.880 --> 00:53.490
So I need to write the SQL query so it's insert into uncertainty you can have a look from my connecting

00:53.490 --> 01:01.860
to escalate what was the query given inserted to teachers the ID name gender and stuff like that so

01:01.860 --> 01:03.840
we can just put them out here.

01:03.930 --> 01:11.010
So instead of putting a triple double code put a triple single called so because there's gonna be some

01:11.010 --> 01:17.240
codes which are going to come all right to insert into a teacher's right or insert your teachers or

01:17.240 --> 01:23.580
we hear it's going to be insert into into the table name is clients.

01:23.610 --> 01:24.400
Right.

01:24.420 --> 01:33.840
So insert into Clines and we need to say insert into Kline's and have a look once again at what are

01:33.840 --> 01:37.250
the different parameters and what are the values that we need to insert.

01:37.320 --> 01:43.830
So we need to say insert where is that insert into clients and you just to say let's say out of that

01:44.190 --> 01:52.780
I want to put the name I want to put email of course and let me save the idea.

01:53.290 --> 01:59.790
I want these three things to be put up and the values are going to be this right so I'm going to say

02:00.150 --> 02:07.550
space values are going to be values are going to be whatever the values you need to say.

02:07.800 --> 02:10.530
And if it is a string you need to put in double quotes right.

02:10.680 --> 02:12.790
So that's what you need to put up there.

02:13.020 --> 02:21.340
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

02:21.340 --> 02:22.360
Savarkar.

02:22.570 --> 02:27.880
You need to insert the email which is also a gap which is going to be e-mail.

02:27.880 --> 02:32.530
Now the problem is now if I put just double code name it's going to put there it's not going to put

02:32.530 --> 02:34.330
the variable name.

02:34.390 --> 02:38.770
Not going to put this variable name but it's actually going to put the string name right.

02:38.920 --> 02:40.570
So I need to insert the variable there.

02:40.570 --> 02:41.660
How do I do it.

02:41.710 --> 02:48.040
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

02:48.040 --> 02:58.090
the 0 element the first element and let's say what we here first and then I need to address is also

02:58.090 --> 03:00.490
going to be is also going to be a string.

03:00.700 --> 03:01.000
Right.

03:01.000 --> 03:04.700
So I'm going to say this is going to veto though.

03:04.980 --> 03:11.200
Yes it's going to be the second element which is going to be put up in curly braces right.

03:11.230 --> 03:14.160
And of course we close.

03:14.160 --> 03:15.410
Insert into clients.

03:15.500 --> 03:21.700
This particular thing so I close up with this stripper code and close it up.

03:21.730 --> 03:22.220
Right.

03:22.420 --> 03:27.580
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

03:27.580 --> 03:38.340
insert the variables name email and ETR so I'm going to say Dot Dot format dot format and there any

03:38.340 --> 03:43.180
way to say wherever there a zero I need to put I need to put the name.

03:43.750 --> 03:50.110
Then the email and then the EDTA.

03:50.830 --> 03:54.880
OK so name email NDA.

03:55.150 --> 03:55.640
So what.

03:55.640 --> 03:56.120
So.

03:56.140 --> 03:58.680
So this is the minute the minute it connects.

03:59.020 --> 04:03.760
And all these other things which which needs to be stored in the database.

04:03.760 --> 04:10.800
And of course once these things are done let's say for example after they are done I just need to you

04:10.830 --> 04:14.230
know got a connection from client address and stuff like that.

04:15.300 --> 04:26.200
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.

04:26.200 --> 04:26.500
All right.

04:26.510 --> 04:28.820
So I have I fired the Square-D.

04:28.820 --> 04:37.850
No I have not fired the query which means that the 5 Square-D by saying I have to scale there is Daut.

04:38.060 --> 04:46.440
That's the query the query has to be because ADOT Cazador execute after execute the query.

04:48.350 --> 04:49.470
Right.

04:49.580 --> 04:55.970
And of course after executing the query I also need to say a connection come at the rate which will

04:55.970 --> 04:58.940
come at whatever has been done.

04:59.420 --> 05:00.170
Fine.

05:00.170 --> 05:00.740
All right.

05:00.740 --> 05:07.400
And then after committing the committing to the connection now let's say so I got a connection from

05:07.400 --> 05:09.260
client address and are in name.

05:09.270 --> 05:14.660
Yeah that can be told fine lines of names kind.

05:14.660 --> 05:16.970
So I'm sorting the con in a dictionary.

05:17.060 --> 05:18.490
That's cool enough.

05:18.890 --> 05:19.830
OK.

05:20.000 --> 05:27.070
But then comes that comes something let's say let's say for example.

05:27.740 --> 05:36.880
I have to work with now when I start with a new trade in each thread I have to go with it.

05:37.250 --> 05:45.740
You know I need to I need to use new curso that's something which which you will understand in some

05:45.740 --> 05:46.430
time.

05:46.760 --> 05:47.490
Right.

05:47.930 --> 05:59.370
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.

05:59.420 --> 06:03.750
So what I can do is I can just fire it up for now I can just execute it afterwards.

06:03.770 --> 06:08.980
We'll see what what changes can be done in the trade so as to display to know good fashion.

06:08.990 --> 06:09.470
All right.

06:09.640 --> 06:13.250
So I'm going to run though sober sober code once.

06:13.340 --> 06:14.840
Let me run it up and let me see it.

06:14.840 --> 06:16.120
There is no problem.

06:16.190 --> 06:17.600
Control shift.

06:17.680 --> 06:19.220
S10.

06:19.380 --> 06:19.640
All right.

06:19.650 --> 06:24.350
My server is running fine and right.

06:24.360 --> 06:26.190
And my client.

06:26.200 --> 06:29.550
I need to run it up when I run this.

06:29.880 --> 06:31.310
What does it say.

06:31.450 --> 06:38.080
Anti-O names so let's see X Y Z and excelsis into name.

06:38.090 --> 06:38.500
All right.

06:38.520 --> 06:45.980
And it says into your e-mail socity X Y Z at company dot com.

06:46.230 --> 06:46.990
Right.

06:47.040 --> 06:51.170
Let me have a look what's come to the Silverside is there any of that is an error.

06:51.240 --> 06:54.460
What does Yerra operational need are.

06:54.880 --> 06:56.270
That's OK.

06:56.280 --> 07:00.740
So that's the error on line number 32.

07:00.750 --> 07:05.610
So just have a look at in the server.

07:05.640 --> 07:08.440
Have a look at line number 32 32.

07:08.540 --> 07:11.100
Get ready queries executed as a problem.

07:11.100 --> 07:11.460
Why.

07:11.460 --> 07:20.760
Because why because you have in the ETR The address is nothing but it's going to be these two Karev

07:20.760 --> 07:21.770
meters.

07:22.080 --> 07:23.020
Right.

07:23.040 --> 07:26.920
So that's something which we have.

07:26.940 --> 07:31.290
We have these two parameters which are which are there.

07:31.380 --> 07:38.570
So what we can do is we need to as a result of the OK.

07:38.610 --> 07:39.000
All right.

07:39.020 --> 07:46.280
So the idea are we need to because it is already an address in itself.

07:46.280 --> 07:48.030
That's the problem.

07:48.080 --> 07:48.370
OK.

07:48.380 --> 07:49.900
So it's a strain.

07:50.030 --> 07:56.120
So what we can do is for now before I fire the Square-D Can we just print this address and the type

07:56.120 --> 07:57.620
of address and just check it out.

07:57.690 --> 07:59.480
So right so predated your

08:02.770 --> 08:10.490
and print type of rate so we can rerun this.

08:10.490 --> 08:17.820
You can stop this and we can rerun this and just check out what happens.

08:17.830 --> 08:18.190
Correct.

08:18.190 --> 08:23.110
So let's say we'll disclose all of them close all.

08:23.110 --> 08:25.640
And we read on this and we can just type.

08:25.720 --> 08:29.040
You know we can just get it printed before executing the query.

08:29.050 --> 08:31.810
So even this needs to be commended out.

08:31.810 --> 08:34.960
We'll just check it up first and then go on.

08:35.080 --> 08:36.500
One error at a time.

08:36.550 --> 08:38.470
So it's just table Kline's already exists.

08:38.470 --> 08:42.030
So that's one problem we have all we create the stable client.

08:42.130 --> 08:47.350
So what we gonna do is be let's not create the table Cline's once again because we have created it once

08:47.350 --> 08:50.590
when we ran the program it ran into an error only after coming here.

08:50.650 --> 08:53.650
It's a step by step program so let's not run it again.

08:54.240 --> 08:58.000
Let's just make a connection and let's say control shift 10.

08:58.360 --> 08:59.790
So things are running fine.

08:59.800 --> 09:08.250
Client control shares turn 10 so into name x y z x y z at company dot com

09:11.280 --> 09:15.690
it's going as your object has no attributes de-code.

09:15.750 --> 09:19.200
So where's that name that de-code going to be there.

09:19.230 --> 09:24.720
It's in line number twenty eight of sherbert that I.

09:24.740 --> 09:30.350
We don't need to decode this because the name is already a string we already have decoded.

09:30.350 --> 09:32.070
Each of them in detail right.

09:32.150 --> 09:38.600
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

09:38.600 --> 09:41.810
to decode this up it's already done.

09:42.140 --> 09:45.050
The arguments are just name.

09:45.260 --> 09:47.290
Conn and ADR.

09:47.330 --> 09:48.800
That's true.

09:48.800 --> 09:54.160
So let's stop the client too and the server is already stopped.

09:54.200 --> 09:59.560
Let's run the C on the server multiple reruns will help us to find out multiple.

10:00.460 --> 10:10.440
Which which can cause us to figure out how to debug our code at company dot com.

10:10.900 --> 10:12.220
So things are fine.

10:12.220 --> 10:16.000
Got a connection from client and address this now.

10:16.020 --> 10:16.810
Hello.

10:17.020 --> 10:19.850
The address that we have got is a class topper.

10:20.000 --> 10:20.380
OK.

10:20.410 --> 10:24.750
And it consists of a string and it consists of this.

10:24.840 --> 10:25.420
Right.

10:25.450 --> 10:28.230
So what we can do is we just need to store the address.

10:28.260 --> 10:33.010
OK you want to store even the part number then what you need to do is the top needs to be converted

10:33.010 --> 10:33.930
into a string.

10:34.030 --> 10:34.300
Right.

10:34.300 --> 10:45.290
So what we can do is instead of we can just print we can convert this SD CRB Jarobi and and just recheck

10:45.290 --> 10:45.920
it once again.

10:45.920 --> 10:58.620
So we'll stop this and stop the client and let's let's close close all control chip 10 and let's read

10:58.630 --> 11:01.440
on the client to control this 10.

11:01.490 --> 11:08.480
So it's going to be x y z x y z at company dot com.

11:11.280 --> 11:19.050
Got a action from address and name so it's ok right.
