WEBVTT 00:00:07.140 --> 00:00:13.870 In this video we're going to create a school database using our subpanel dashboard so to access the 00:00:13.990 --> 00:00:18.870 panel just go to the complete web hosting Web sites and then log in 00:00:21.280 --> 00:00:25.290 . 00:00:28.200 --> 00:00:34.780 And after that click on services then click on the accounts that you created. 00:00:34.880 --> 00:00:36.940 It's the beginning of the course. 00:00:37.830 --> 00:00:38.360 OK. 00:00:38.430 --> 00:00:43.710 Now to access this panel just click on logging to see panel. 00:00:43.710 --> 00:00:45.910 So here is our panel dashboard. 00:00:45.960 --> 00:00:50.870 So if you scroll down you will see a database's section. 00:00:50.880 --> 00:00:52.380 So that creates a database. 00:00:52.380 --> 00:00:57.400 Just click on my Escurial databases. 00:00:57.420 --> 00:01:01.050 So first let's choose a name for our database. 00:01:01.440 --> 00:01:03.780 So I'm going to call its uses. 00:01:04.180 --> 00:01:08.980 OK so the full name is going to be the text you see in this box. 00:01:09.080 --> 00:01:10.560 And the school uses. 00:01:10.560 --> 00:01:12.390 So let's click on create a database 00:01:15.110 --> 00:01:17.530 and go back. 00:01:17.730 --> 00:01:17.950 OK. 00:01:17.970 --> 00:01:21.880 So now we've got one database created. 00:01:21.990 --> 00:01:22.720 OK. 00:01:22.980 --> 00:01:32.220 Now we need to create a user and password for our database so that we can connect to the database using 00:01:32.220 --> 00:01:34.170 PSP later on. 00:01:34.170 --> 00:01:39.220 OK so let's choose a user name and then go for user. 00:01:39.380 --> 00:01:39.890 OK. 00:01:40.050 --> 00:01:45.390 So that's the full user name and then for the password we can generate the password using the password 00:01:45.390 --> 00:01:46.400 generator. 00:01:46.860 --> 00:01:54.000 So if you're happy with the password just copy it somewhere safe and then click on I have copy the password 00:01:54.120 --> 00:02:00.080 and then use password again known this creates the user. 00:02:02.140 --> 00:02:04.620 OK let's go back 00:02:07.560 --> 00:02:11.740 and make sure that you store all details somewhere safe. 00:02:11.820 --> 00:02:23.170 So that's the password and that's the user name which starts with this and then use. 00:02:26.880 --> 00:02:28.500 OK. 00:02:28.500 --> 00:02:32.450 Now we've got our database created of course a username and password. 00:02:32.460 --> 00:02:37.280 Now we to access the database using BHB my admin. 00:02:37.400 --> 00:02:39.690 OK so we're going to go back to the subpanel 00:02:42.690 --> 00:02:45.390 and then we're going to go to my army 00:02:45.400 --> 00:02:51.590 . 00:02:55.620 --> 00:02:59.440 Now on the left hand side you can see our database. 00:02:59.540 --> 00:03:04.260 So if you click on it you'll be able to create a table inside the database. 00:03:04.410 --> 00:03:05.340 OK. 00:03:05.940 --> 00:03:11.180 So we're going to create a table and then we're going to use it to store details about Web sites uses 00:03:11.340 --> 00:03:18.390 we can saw their e-mail address their password and also their age and let's add an I.D. which is going 00:03:18.390 --> 00:03:20.970 to identify every single user. 00:03:21.360 --> 00:03:23.520 So at the end we're going to have four columns. 00:03:23.550 --> 00:03:23.990 Right. 00:03:24.030 --> 00:03:24.590 So it's cool. 00:03:24.600 --> 00:03:29.550 Our table uses is going to have four columns. 00:03:29.550 --> 00:03:32.850 So let's click on go. 00:03:33.360 --> 00:03:38.650 Now we're going to be able to sense details about different fields inside our table. 00:03:38.760 --> 00:03:43.790 So each of these rows corresponds to one column. 00:03:43.800 --> 00:03:44.400 OK. 00:03:44.640 --> 00:03:47.700 So let's start with the first column. 00:03:47.940 --> 00:03:50.940 So I'm going to call it ID. 00:03:51.180 --> 00:03:55.880 So this field is going to identify every single user in our table. 00:03:56.110 --> 00:03:56.830 OK. 00:03:57.180 --> 00:04:00.290 So if we're the type we're going to go for an integer. 00:04:00.410 --> 00:04:01.150 All right. 00:04:01.410 --> 00:04:07.910 And also we're going to give this field an index primary. 00:04:08.700 --> 00:04:17.490 So this is referring to a primary key which is going to correspond to one single record in our table 00:04:17.510 --> 00:04:17.900 . 00:04:18.270 --> 00:04:21.500 OK so that's what's a primary key means. 00:04:22.350 --> 00:04:26.850 So every record is going to have a unique ID. 00:04:26.910 --> 00:04:29.950 And finally we're going to have another setting for the ID. 00:04:30.390 --> 00:04:37.800 It's going to be the auto increments so also increments means that if we create a new record and we 00:04:37.800 --> 00:04:45.780 don't specify the ID for that record then automatically the ID is going to be the previous ID or the 00:04:45.780 --> 00:04:48.020 last ID plus one. 00:04:48.240 --> 00:04:48.940 OK. 00:04:48.990 --> 00:04:51.510 So that's what auto increment means. 00:04:52.260 --> 00:04:57.650 OK let's move to the next one so the next one is going to be the e-mail column. 00:04:58.410 --> 00:04:59.370 OK. 00:04:59.380 --> 00:05:03.260 So it's either going to be looking as the string types. 00:05:04.170 --> 00:05:07.960 So let's start with a voucher. 00:05:08.550 --> 00:05:19.360 OK let's go for a maximum length of 30 so 30 means that's the maximum number of characters we're going 00:05:19.360 --> 00:05:24.580 to store in the field is going to be 30. 00:05:24.610 --> 00:05:35.380 So even if the user inputs a and inputs of 40 characters in our form in a CML in a database we want 00:05:35.380 --> 00:05:40.880 to store the inputs we're going to be able to store only 30 characters. 00:05:41.100 --> 00:05:41.770 OK. 00:05:41.940 --> 00:05:49.000 So it's really important to control the inputs lens in the DML forms. 00:05:49.020 --> 00:05:49.540 OK. 00:05:49.870 --> 00:05:52.960 Now for the string Sipes Let's have a look. 00:05:52.980 --> 00:05:57.960 It's the difference between the jaw and var transcripts. 00:05:58.120 --> 00:06:00.550 So if we go for var cha. 00:06:01.300 --> 00:06:08.660 So the memory used for the user inputs is going to correspond to the number of characters. 00:06:08.680 --> 00:06:17.560 So if our input is 10 Coxs long then we're going to be using 10 characters worth of memory. 00:06:17.560 --> 00:06:24.150 OK plus 1 bytes which is going to store the number of characters. 00:06:24.220 --> 00:06:24.930 All right. 00:06:25.260 --> 00:06:26.250 So that's for March. 00:06:26.310 --> 00:06:31.850 If we go for the char type that's going to be slightly different. 00:06:32.050 --> 00:06:39.020 So the chart type is going to store all the time or use all the time 30 characters worth of memory. 00:06:39.120 --> 00:06:44.880 So even if the input is only 10 characters for example we're going to be using 30 characters. 00:06:45.190 --> 00:06:54.580 So the other 20 characters are going to be filled by space OK or empty space or blank spaces. 00:06:54.570 --> 00:06:57.900 So the next one is going to be the password. 00:06:58.770 --> 00:07:02.410 OK I'm going to use a voucher for this. 00:07:02.500 --> 00:07:06.820 So for the email we're going to use Varsha cajas to optimize 00:07:09.390 --> 00:07:10.600 the use of memory. 00:07:10.850 --> 00:07:11.520 OK. 00:07:11.640 --> 00:07:15.430 Because the length of emails go into very much. 00:07:15.690 --> 00:07:20.400 And the final one is going to be the age that is going to be an integer. 00:07:20.970 --> 00:07:21.940 OK. 00:07:22.180 --> 00:07:26.150 And it says a maximum number of characters for the password. 00:07:26.380 --> 00:07:27.550 Sergey carcasses. 00:07:28.060 --> 00:07:28.620 OK. 00:07:29.010 --> 00:07:34.870 Now please click on Save. 00:07:34.890 --> 00:07:35.260 All right. 00:07:35.250 --> 00:07:40.980 Now let's go to our database and click on the users table. 00:07:43.380 --> 00:07:46.970 So at the moment we don't see anything because our table is empty. 00:07:47.160 --> 00:07:47.720 OK. 00:07:47.860 --> 00:07:55.200 So the query we run to see the recalls inside our table is select staw from the table uses. 00:07:55.260 --> 00:07:55.850 OK. 00:07:56.040 --> 00:08:01.530 And then of course limits Zero says he meaning those we starting as record zero. 00:08:01.810 --> 00:08:07.100 And we're going to be displaying a maximum number of records equal to 30 records. 00:08:07.290 --> 00:08:07.950 OK. 00:08:08.250 --> 00:08:15.800 So now let's insets some records inside out table by clicking on inserts. 00:08:15.850 --> 00:08:16.490 OK. 00:08:16.690 --> 00:08:30.420 So let's give the first record an ID of seven for example in this place and email the name ID email 00:08:30.620 --> 00:08:37.060 those come a password and age. 00:08:37.500 --> 00:08:37.970 OK. 00:08:38.190 --> 00:08:44.120 And for the second record let's leave the ID field empty and let's have an e-mail 00:08:46.890 --> 00:08:51.320 password and an age. 00:08:51.500 --> 00:08:55.220 OK so let's click on go. 00:08:57.610 --> 00:09:03.280 So that's the query we had to run to insert the record inside our table and that's the result so two 00:09:03.270 --> 00:09:04.220 rows inserted. 00:09:04.240 --> 00:09:05.480 So that was successful. 00:09:05.760 --> 00:09:07.440 OK. 00:09:07.440 --> 00:09:07.710 All right. 00:09:07.720 --> 00:09:15.900 Now if we click on our table again now we can see us we've got two recalls inside our table so you can 00:09:15.900 --> 00:09:17.110 see the structure. 00:09:17.130 --> 00:09:22.710 So those are the fields ID email password and age and we can see the values inside of fields. 00:09:22.720 --> 00:09:23.190 OK. 00:09:23.380 --> 00:09:28.030 So for the first record these are the values we have in says it sales. 00:09:28.330 --> 00:09:32.290 But the second one we can see that's the ID. 00:09:32.290 --> 00:09:38.940 Even if we left the empty it's equal to the previous ID plus 1 and that's due to the auto increment 00:09:39.000 --> 00:09:39.970 property. 00:09:40.430 --> 00:09:42.050 OK. 00:09:43.020 --> 00:09:46.100 Now we can do things like deleting a record. 00:09:46.120 --> 00:09:50.310 So we just need to click on the delete button or editing the record. 00:09:50.380 --> 00:09:50.700 OK. 00:09:50.700 --> 00:09:54.480 So let's Deles the second one for example. 00:09:55.500 --> 00:09:57.700 And now we're left with only one record. 00:09:58.070 --> 00:10:04.180 So so far we understood how to create a database using the C panel. 00:10:04.500 --> 00:10:05.040 OK. 00:10:05.190 --> 00:10:12.790 And also how to use PSP my admin to insert or create a table inside the database manipulates the table 00:10:13.390 --> 00:10:16.350 records to list them or edits them. 00:10:16.480 --> 00:10:24.540 OK so in the next few videos we're going to learn how to do all these operations using BHB and why you 00:10:24.690 --> 00:10:24.800 . 00:10:24.880 --> 00:10:30.210 So we're going to be connections to databases using PSP mice girl. 00:10:30.250 --> 00:10:33.030 We're going to be creating databases tables. 00:10:33.100 --> 00:10:44.450 We're going to be setting records in tables deleting them deleting tables and so on.L矙yBba)XTvNaT~| t[n,;-9㉘IYVV? '&|"-#W9bpĔ8IB@ %͊Jn5(aV+}PGLR@>ұnrh{r80=at.DwZ_Q(~+gSsV/GGO$`E^udޗ0h84ҞA-9 6i[\kiO + KtҼ:w!-tg,^nX"Ri:VX0O43J^>y0xṯ/A-՞hþ֩D?]-[B!zpADwҧ?xeڧ>rYꁠx(I26*^a{x+\82,963~,\f,q=.0ȡXTx .p\ %U JȩdVSUf"%5~#EkÖFN9ZjSrUSL}1}S̩hU ѐGCYS1XO|b ]E#J[X0a3OQOP@|]c ?)@2U~Ȯ=wKw#y_V5%_w}q0A"Õ\v q^ކ;[݇eB]  "WPL,H1`

E*֦7?ߜ|a`}p4{+zC5KM̺ ߖ{X胕;*iDx׽GQ#}.KV[HKP9#OctB&I ?1o~K@<:y|}W^$u#ý g8^\Pciְ4\ih(\AU 6x&1K|FQ/ 4K{&_ ̮@Հ؄ @rE邚<Įe$3AO }A8)y sZϞY dmW@PܲW}?^i+ȃ#g XCG3gzRwzV)iT䘍Xx 4蚦7k\" H褔:_n\ #eQ^؆',Aj߬GJQ]d?/u|$5527!ψ gTꬓW_le>r |iprіopL[,Ф3)O?wpAE@r{kU@t׸k5A]H<5l҆F*xFh1dĿ8#E tOV[}q,X0 71|TWx)gN}@66n=|$Nc8N N,%Nj6/ |!۹ 4WM '?3 E6.朿x0/Bi%jΏPTI&@yx0[S[}Mo:2U70&I?/Vm/ MmU8YAɦ,</ތ he`&J50Q =0 g&E(VX"h`2*2̩K7 ͠ D \<jo $ ( YpdgU[rkEu!cKg/!wVq\KYb48PA"DJ Or̒E^֘ξP@4* V#[~ Gf-u ,N9\rcѧNiX#АT"F|% 7q*,I|8Y%Ǽ{j=_.r0TQ$BdUb\y>  `Ҳdj>$%y`a`GdI3xr?>ΚKsi~"zIȿ0,6ܾkF,sjUuT_F`"g&=0@Uˎ?@a-+> (apo?0!dԏͳ+-e@=@TJRA"_|׊=sI_AvCofci|j6?KFIzpgF,N-h=k:'ZW? !)zRplц~#kV `LJ+ PB]A#A,ӂepM'BZGt076!q喲o[Q`@kzR,?F*rX|Q5(4SNQ@%cW a1r6AKhƠ'D8W vۘT/ @Z r]B$&}P$ 0yA}Xzj׀ JHo'}v_yJu19 B(Dsw+x(xNosq_ލ3&ex:̭ ,2 .6KAV9x^k]g/0^\31!!Vc_=K,Oso[wj+ Iڪv ?<(iGK~1|A?n_"*814Ў[h9!4[@۔\N ޷)`3%/^R~ «$kuM"BX P."? MNL]\C0`h~xM`W_p2 PE@o-`%eH1ą:IE#w)Ic 'WB F108V5sq !&1mA]@EH^8UY&951o}`Tj YJ=Vy1뷛@:ϵs !"&WWp>"πdS<urwaI8/Yx9!︔(Eu}^!U(1HK)\X50C;!, m}=pSUx禫;AM̾<,J=1~ EIS%gr҇MIm@V᳂zQB.'_KGVxדx]>s Z:LNp %t}!S"\?WRTEp8ҵc-MψƄtq3HRؔg.u23rNE.̜ÀZmewS!`岆L34 ߡ(s,߀p<@YPF87sB 8GƜ\d:dT %1'W:WSdk ß#&13QVp# ǣ +ζOzp]<\3P-"wV,R߽ pjD0>PS"X\W/hWaSKJd.?@H\9h '20ݜ,]v}-xDbKf2H sd?`c[p ` CvU(a͠O_]%ǙYtAE-d(`P r~[/#"))0.i:P4A3 "%;*֜{MY` ԩ 3Fc  FW&=^pƂ})Lኈ[`G@cƁ;{@@Ikܰr#'7O4EnVi{FhɕW𬆙!)FD@15R&9' -91/b2M[m|B114qS{1oHe *>BiǡGЀ@7W 1YV{ ʎ,Gn mYW2 _(Cx ?i(h* wEBG diLXfe Z$ѡ]+_wC \ocJa9P68+ej͈n .KK<7^S~9fQG9GZ]zؐp'ODIfnSc% C4@a ֑r*#?%?8RTD@`m?5Vi+SF8`W؊C#Ŭ߀#XvH1Z2tMf Nk,Q,(k_tm`6(rO"x{[mϭ$!gL's6ˠg@F hJ"(Ƒ p@q÷ ?b"p5]?!#lBtO=ƁM_x(R'k<ċL- !kC~]p>?l4w 2AjoZ! m0 ETrS: G\0֢ܶx>*&&@H45ڞ0ދ_ }iQilxJMqZzϷޯ^|30Q7m_H!Qe1O_^)'{g rF]^qt=M⼳3Gh9G2(m_a *$ F%}4,U?W ^-dx"jjבuFI}#A1&5c/=pSVx禩?φbT-Rae?m$zf/⤩ɒ?ѲkI.mG/[eո]YG)=.AK+++բ;WdBVzXzGFFBI.43 $ s9xei,0@uHKx8OYyǜ$Pʭ$>FC? >)n?ﾣ" ) 'bp{L3hlڙkAD 7xZb,VÐ$UZlX mMW<3Þo85HXPq-gƅ$m?)dZL_z~VvG'@ ܆&x?,hD|;2jk#L.Z@ }]㢧xzF` &VЉۍ׶>W~$BF7$DN667@ VqR1>bpțK&GaPKquP5߾̨3f('09M\zs_J0cfb?%5<|?C;:)M1؜@CYU @8[_kHö BWW QC?ѭ8C= q=OWkkk ?z m%58^#?tZ3wPm}a s BTu~z2iYihUvłv +9*J0!_[_k}=B'=g0kkkk:YϰGO/Kyk^:;&>*%%~ J  tWg"`Lg?1 0'V0Ԡ lz51{ V܊Eg#Ȧ+gѣ0=$J9V&*?U:ghksox~ AC[(s 144ckEF*;`paҹgk8C% 9[<3'A {(΢>8`T|"SSu > Sk MM0qSߝxe(wRaZp(y`P`| KH!c"Y4jbf;?;vU<[<bc2ܶ'sڤxPnsIF?N!?!B= +[BVѺ{8 MO4H~aN@kF[5x&mgˤvў@w_ܓ|X{'X.WUK 9uq~?MOݻ*`XBVyWܐ\#0d62Y' @a @?RP/9.q\H΀@i`;hiFMRޡ> Ҋ0r y]%eu[ ,U%X[JykHvsJ S92J=lc Y o&&׻^aWe(aS,CD$GrAp@×/DØsw V~Llyd(!u/! )^^~000~,@;GM ʻy cTuӴ!E,Q W pBSdcGL~7}VH>5aߐx∻)C mnſhN&wf ɇ3<(F~nx9ދ\4W 2 ` j]$FF겒^O-8v{p~/HB9G9ޙ66 V3SaEAxD ~CQlB#}| "'U J](D]ad4GDÀIW|wCu^_H]8N3U Q)=C]ѿQgJy? F޴3Jأ]{9~ɦdK:$#XCW~އ+O-)qY q`Bh"1W*.s0 L%F,C: +sm$owtg%jBB^pd6^Fש~ 0Qrw AFfl"V DJX@[>| Zf݇%TX)1FC+~r/ ||OS(;DOc L:)O)/A_ʼ3 dju@F3x82;Df)"-]#ߛMQ2z .}#^l;RpRl} U>fD`HiCXT8v 1 %7QK7P"d%0" öy#i:Y(?1(bu# nQFB|z4=6ucB&4Uա_TD%F%ohBd8Mea c}RĴ)GaCyhm8C?rC @1cQ䣨 PyoD o1e Lb(:Gk|&bacHOSgyUV` wY]Yo '~1`8 #^*#f쵰v7P>}D.p e''">%kkǢ#|D>ȋl0B%k3C 0tI[|%=kdvuO吩xLd0 )OWfX| 9K껧 |#1߫! Mb8-'=g*_i盱?*9YYGpH.NC2)f9]J *x" Qckm0M{uMߓ=O ";r.+8jt.&R8%+z`!rC [}fv,w}-0i[8H=&D?01DBvw1+IeE6?}ٛf>k#Oה/ߏ^P}>UaڳH0E(YlZ֭;謾_pK@}}}}3%mw4+cq&KODŸbjs_ UhApx\>w;HZ Y[`$ 5 zQDH_3Um1̎w6^Jk+HOߧ3뮺뮺뮺뮺뮺뮺Ѕ\ϿI2ag@Q7=n : =>$=Br;튧ZH21T [&~nd+(?H4}gB<#8F1>BWp#k;˵y[qQL ;@!**߅#LC/ B(H78)f|"Lץ1Zch{D]|kI$!W||mo1q^ IYN[Vx y/z1Bְ &`vؙBYEXJ-N4s!$MB[NRc XmŠmw7 AƹRp*{#bG9س^QfE1ǂw )dbD&lkGVML Pj}@RZ٩ ZM`KW0v7 ZHfBrY(dyw@*FoBpV ??B< }ۛZ_w Px4k/dbR1U}Z0-X3/D|늵'ðpRNantx6P44zwSON/@(‹}W@+X;,I漀QrlH3ᄣA PEoxڶhe? ~IAK9H kcUFP!\N 9FP_iSP y޴B~kUqND;W4;%M{u!ׂ>h\FF?_d3HUO`4poW kt~zkacC>ZnOkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk`A49a as+{*~BM8=QC}Ia $dDE,:T~oo`qd*`6]F0Lo^<Npd=/D3}( : DYrX> K@F2 #fh 8q9ȾTÿ=)Ժz]_t/AF0Lo^zP0&XZtC s =/PAbmūnl;@AQ()c` = vt ؚ#\8@=wfgiyç K;Fh^=F`X$2/(VBY}?4-þplҦ` Dm&n_դ,n7? JBxPniaEDž 6w.~N#@U كH`/k 3=LӖ)n ǀ(eNga%nRT< a61 _FhD? DsumNN$7r't#!:Ϳ&W15yK!دQ>;53$g2u^b_8ِ |?y #O'$>R$K8-@R 2Ї8XzTzN])ϑlf酈.Ͻ>Ь{[[[[[[YCLmmmmmmmg]FG[Nܷg]Ft}Ft} ' iknoܠdQ@r~B-a7gPZgraތXs~QAkx}HT C*!?滿qx ̾㷂Cho$ƮsD;=|qj־}{:__sᭀ60zdȥqgg(1?aeu&I?$F!Dc$)!$ՍWZdW֣ o ZYOv"I?vj|f0m%-#+YSK@juhBvϣعJbMu_AYl|VG<8C J6˱35-b'C9Z=|('a!M[hw_ Px~P]05#9 . PFÊ\6hdxe00! %s;lI*b-[h]f4eWQ vn!B7V{X,?<L0OqaE)NʁQ! LN;{缻EQG|PkNlH0 qa` >D F2DlR'D`!L-8=},`4L S] s+ SKA5z[Zhb~5hƾ:ꃲ|C kYϘOi>}2Kf56 ְ+:ALdTq R_?c,U0/5 !L~p!} K@T bo!:a<?Ԅ"A\ @Yx"ߠwY X~_xG*s;QKzw__bKl0DZ,6d$-nj">yqiV'U]tdo? ?ok('FlH!EE6cu8ʀE@ ,cW9Truo_)|sY/"]Uq#F:GMj3DâY;}wٟ?o{Fnbiw~)}?]0ۭ>h* : "OWPܗ(69@Bb/3,1PL持mPGm66{9g}y6Ik6Hj!~( @b>LSr pr^K?A[:4@o\h:%! >>&Ѕuh] (5 KSѣV0#*fޭ vRMwjsyD"Y XĒ߾YϢǟqLX] =TqGp )C.zbc3N+aðDax x+:{fm"RJ9 ,?:-m,01nԯ-huJX OfD,;O. !Dx nWQXGJ;T3Aחө<#'/9fL{h2Ƙ en>:E9| PfIB_n%VUдDr|3#ǿ45=vs`;:q`xb,Ծ RYf|_ؠb&3?* <#h!މ : eh_SÂ=‚"O@ ui3w՞ "H6[݂