WEBVTT

00:00.390 --> 00:04.770
Well let's go Also if you want you know we can just access these things.

00:04.950 --> 00:11.100
You know just when the guys chat is coming to the other side instead of just telling his name we can

00:11.100 --> 00:13.630
also give his email lady.

00:13.680 --> 00:19.800
You know this guy with his email ID is seeing this or you know or something like that if he wanted to

00:19.800 --> 00:21.770
add such stuff.

00:21.780 --> 00:25.020
You know you want to get this entire thing into place.

00:25.080 --> 00:34.020
Then what we can do is we can we can actually state are we here before sending the data right before

00:34.020 --> 00:39.310
the message the client name plus I'll have to add also along with the client name.

00:39.390 --> 00:41.090
I also need to add that e-mail.

00:41.130 --> 00:43.460
So I need to hit the obviously here.

00:43.590 --> 00:52.560
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

00:52.620 --> 01:02.580
again let's say I have to say exactly the same thing as costarred executes Sinistar from instead of

01:04.180 --> 01:10.890
I'm going to say here silks are from clients and I need to see where where.

01:11.100 --> 01:15.530
Name equal to name equal to.

01:15.570 --> 01:19.730
And now I need to see a word here namely equal to what I need to put down.

01:19.740 --> 01:30.210
There is a dark format at right instead of the word name equal to what the name of the particular client.

01:30.240 --> 01:34.360
So I need to say Kline's score me.

01:34.680 --> 01:40.390
So with that I get all the details of that particular client from the database.

01:40.390 --> 01:41.010
Right.

01:41.070 --> 01:49.710
So once they get all that the yields will decline from the data is OK I can say I've got that here and

01:49.710 --> 01:51.630
I've got the results here.

01:51.750 --> 02:02.460
I can access the result and if I print if I print you know if I for now let me just print the result.

02:02.470 --> 02:12.110
Now there's one thing that I need to say is Is it because we have you know we are we want to create

02:12.110 --> 02:18.770
these client once again X-Face that we will we can drop them from this particular from this particular

02:18.770 --> 02:26.060
table for now we can drop this entire table and you know we can create a new client we can create a

02:26.060 --> 02:27.140
new table.

02:27.140 --> 02:34.700
So what we can do is we can create a table but after dropping the existing tables so cursedly execute

02:34.820 --> 02:38.780
I can drop the table and create once again every time the server reruns.

02:38.780 --> 02:47.300
So I can say drop you can have a look at the escalating tax you can have a look at the documentation.

02:47.410 --> 02:51.370
Sorry.

02:51.660 --> 02:58.720
Or you can just right there dropping table in a skylight so I can drop that.

02:59.190 --> 03:05.400
So it's just the statement is just drop table and.

03:05.760 --> 03:07.970
And the name of the table that's it.

03:08.010 --> 03:11.990
So you can just say that out there so you can have a look.

03:12.240 --> 03:18.900
So I just have to say is a drop drop table and in the name of the table.

03:18.900 --> 03:24.640
So if my Also you can also do create table if not exists.

03:24.980 --> 03:25.310
Right.

03:25.350 --> 03:31.530
So this is OK but then I want to drop it first so I can just say drop table addresses so that the table

03:31.530 --> 03:32.070
name.

03:32.460 --> 03:34.810
So I can just say a draft table.

03:34.920 --> 03:37.800
Clines right.

03:37.800 --> 03:40.080
So I run that out and.

03:40.140 --> 03:42.120
And then I create the clients once again.

03:42.120 --> 03:47.750
So what I'm going to do is I'm going to close all of these Ptomaine all of them.

03:51.390 --> 03:58.130
They really run this and and we run the first client.

03:58.140 --> 04:13.050
When you say x y z x y z at gmail dot com Nemuro another client then you say you are.

04:13.600 --> 04:17.050
Q Are at each company that come

04:20.610 --> 04:23.010
let me say the client is

04:25.660 --> 04:31.200
and DFI at company that's come once again.

04:32.320 --> 04:37.520
No the silver gets all of these registered back into the you know.

04:37.660 --> 04:40.210
So you created plans as of now.

04:40.210 --> 04:43.290
This is one the decline was the number two.

04:43.360 --> 04:43.740
All right.

04:43.750 --> 04:50.160
Now if any one of the clients sent some message saying Hi it's going to come to all of the clients.

04:50.390 --> 04:51.860
Oh wait.

04:52.000 --> 04:59.090
What has happened is there's an they're healthier here that's why it's not executing to that rate.

04:59.290 --> 05:00.570
So what's your.

05:00.670 --> 05:01.000
Yeah.

05:01.000 --> 05:04.600
So escalate objects created in a trade can only be used in that same.

05:04.650 --> 05:06.150
The object rescript.

05:06.220 --> 05:12.080
So you can find you cannot use the object of a skylight in on trade.

05:12.100 --> 05:16.830
So we need to create a new escalator object once again in a new thread.

05:16.840 --> 05:17.280
Right.

05:17.410 --> 05:23.050
So we need to create that in a new thread in general and execute it once again.

05:23.050 --> 05:33.060
So squaw's you have to stop all and close everything somebody told them I need to make that connection

05:33.060 --> 05:34.230
once again.

05:34.820 --> 05:36.740
So connection.

05:37.130 --> 05:44.430
And then we just get that curso and then do it once again out here.

05:44.450 --> 05:48.710
So basically I need to get that.

05:48.850 --> 05:53.420
And of course save it run it.

05:53.470 --> 05:55.540
Let's say so.

05:55.540 --> 06:03.710
Klein one ready x y z x y z at gmail dot com.

06:04.760 --> 06:13.100
Then comes to p q r p q r at company dot com.

06:13.660 --> 06:15.010
So we test one thing at a time.

06:15.010 --> 06:17.410
Let's just go ahead.

06:17.440 --> 06:19.840
Let's say hi from X Y Z.

06:19.960 --> 06:23.510
Let's see if the cure doesn't get it which means it's an error in server.

06:23.740 --> 06:27.650
Once again there's no such column X Y Z where name.

06:28.150 --> 06:37.130
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

06:37.140 --> 06:39.550
equal do I need to put that in the string right.

06:39.550 --> 06:46.090
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

06:46.090 --> 06:46.450
a string.

06:46.450 --> 06:47.650
So I need to put that out there.

06:47.650 --> 06:50.350
Rename it do you know when I put that.

06:50.380 --> 06:52.670
So that's what the field syntax requires.

06:52.690 --> 07:00.980
Again close all terminated so it's a process which is how you build the code with some kind of errors.

07:01.150 --> 07:02.930
Keep executing it.

07:02.930 --> 07:09.570
And to properly enter your name.

07:09.920 --> 07:10.940
So there you are

07:14.700 --> 07:15.720
one more client.

07:21.890 --> 07:25.250
And let me say OK.

07:25.350 --> 07:30.400
So high for a client from X Y Z Oh it's appears there's no error as of now.

07:30.680 --> 07:31.900
What are you going to look.

07:31.930 --> 07:34.270
Got plans registered as of now.

07:34.570 --> 07:44.230
And now I have just you know it gets printed all the details of the client X Y Z gets printed because

07:44.230 --> 07:50.680
of this line it is this line which is printing this particular line whenever that particular guy sends

07:50.680 --> 07:51.520
a message.

07:51.520 --> 07:55.960
So if I send a message from p q r let's say hi.

07:56.410 --> 07:58.110
So it gets printed.

07:58.210 --> 08:00.850
That particular guy's details in result.

08:00.850 --> 08:02.910
So what I can see is this sort of printing results.

08:02.920 --> 08:05.340
I don't want the result to be printed.

08:05.710 --> 08:13.010
I can just print all the Silverside result off zero.

08:13.270 --> 08:15.030
That's the name.

08:15.250 --> 08:19.370
I can just say send a message.

08:19.500 --> 08:26.550
For now that's all the Silverside what I need to append this Klein name and I need to put in brackets

08:26.550 --> 08:27.030
right.

08:27.060 --> 08:32.960
So I'm going to put a string and append.

08:33.070 --> 08:37.050
OK so client namespace I'm going to put in bracket.

08:37.050 --> 08:40.580
I'm going to put the doc format.

08:41.100 --> 08:43.770
I need to put their resolves

08:46.790 --> 08:50.900
get a result of zero is just going it's a list of top notes.

08:51.450 --> 08:54.160
It's just going to get me to the top result of zero.

08:54.190 --> 09:01.480
But I need to get into into the e-mail so I can just the result of zero the first element in the result

09:01.480 --> 09:08.370
of zero and here result of zero and the result of zero Colin zero.

09:08.390 --> 09:11.510
That's the name of the guy.

09:11.820 --> 09:18.740
So I close it and say doc format and of course I put that here.

09:19.110 --> 09:19.570
OK.

09:19.620 --> 09:22.970
And Joe Klein the name of it

09:25.730 --> 09:33.410
plus I add his name email and it costs

09:38.000 --> 09:39.690
less neither Dick.

09:39.930 --> 09:43.870
So with this we are done with the flow of it.

09:44.030 --> 09:44.870
The e-mail lady

09:48.390 --> 09:51.130
we can get the entire thing up and running.

09:51.180 --> 09:52.270
So let's close all.

09:52.380 --> 09:54.040
Hopefully this should be our last try.

09:57.130 --> 10:01.570
Server so server is running fine.

10:01.570 --> 10:10.510
Client Number 1 x y z x y z at company dot com.

10:11.180 --> 10:11.950
Right.

10:13.580 --> 10:21.750
Well let me run another client P-Q or at gmail dot com folks.

10:21.760 --> 10:24.790
I wrote in the wrong name.

10:24.790 --> 10:28.550
OK no worries.

10:28.840 --> 10:33.870
OK I'll just close everything it's going to look good.

10:34.060 --> 10:35.870
Let's rerun it again.

10:40.660 --> 10:40.870
This

10:46.630 --> 10:47.240
raked

10:54.690 --> 10:55.950
and once more

11:05.530 --> 11:08.980
so you have three clients three of them registered.

11:09.190 --> 11:11.150
Let's see haif from X Y Z.

11:11.260 --> 11:12.330
What comes up here.

11:12.550 --> 11:18.750
X y z z Mileti colon Hai and that comes to about let's say hi from here.

11:19.060 --> 11:21.480
DPF within the military colon.

11:21.550 --> 11:26.250
So you can go over here X X Y Z send a message DPF send a message.

11:26.380 --> 11:28.410
SPQR also sends a message.

11:28.630 --> 11:29.990
Hi guys.

11:30.220 --> 11:36.880
That goes to both of them with P-Q us message and also P-Q or send a message comes in the social.

11:37.120 --> 11:41.050
So you know you can even add a client and into the chat.

11:41.050 --> 11:43.300
So you have a group chat and that's awesome.

11:43.520 --> 11:46.450
OK we're going to Delap this father hopefully.

11:46.540 --> 11:47.310
Right.

11:47.650 --> 11:48.070
OK.

11:48.070 --> 11:53.680
So this is about databases and dolls and networking.

11:53.680 --> 12:02.890
We can go deeper into this and the later for now what we can do is let's go ahead with another concept

12:03.040 --> 12:05.470
and that's going to be in the next session.
