1
00:00:00,000 --> 00:00:10,393
>> [Daqq ta mużika]

2
00:00:10,393 --> 00:00:11,037

3
00:00:11,037 --> 00:00:12,120
DAVID J. Malan: Kull dritt.

4
00:00:12,120 --> 00:00:12,830
Merħba lura.

5
00:00:12,830 --> 00:00:13,890
Dan huwa CS50.

6
00:00:13,890 --> 00:00:15,570
Dan huwa l-aħħar ta 'ġimgħa 8.

7
00:00:15,570 --> 00:00:18,360
U kif tafu, aħna għandna pretty
sigħat regolari uffiċċju fi ftit

8
00:00:18,360 --> 00:00:21,090
tal-swali dining,
inkluż Annenberg.

9
00:00:21,090 --> 00:00:23,860
U wħud mill-tim ġentilment
ħa xi ritratti aħħar.

10
00:00:23,860 --> 00:00:26,230
U fl-unur ta '
Halloween, ħsibna aħna'd

11
00:00:26,230 --> 00:00:30,160
sehem wieħed li pjuttost maqbuda us mill
sorpriża hawn fil Annenberg Hall biss

12
00:00:30,160 --> 00:00:31,490
oħra bil-lejl.

13
00:00:31,490 --> 00:00:36,300
Classmate tiegħek Jacob maħluqa għall
dan ir-ritratt, iżda kien aktar divertenti

14
00:00:36,300 --> 00:00:39,760
kien fuq Facebook, il riżultanti
konverżazzjoni li ġara afterward.

15
00:00:39,760 --> 00:00:43,020
>> Ewwel kariga tiegħu bħala rispons
biex ritratt tiegħu kien dan.

16
00:00:43,020 --> 00:00:46,740
A ftit minuti wara, huwa ddeċieda
biex wieħed up ruħu ma 'dan.

17
00:00:46,740 --> 00:00:53,800
Hija marret fuq biex imbagħad mur għal dan,
u mbagħad, saħansitra aktar divertenti

18
00:00:53,800 --> 00:00:55,320
huwa meta mom tiegħu chimed fi.

19
00:00:55,320 --> 00:00:59,240

20
00:00:59,240 --> 00:01:01,800
U mbagħad finalment,
jidher dan kien biss

21
00:01:01,800 --> 00:01:04,860
Ruse isbaħ għal
play li għaddej.

22
00:01:04,860 --> 00:01:07,080
>> Allura, jekk inti tixtieq
biex tara Jacob u oħrajn,

23
00:01:07,080 --> 00:01:10,880
fosthom Cynthia Meng, li l-
wara l-kwinti tal-persunal żona CS50,

24
00:01:10,880 --> 00:01:13,970
ras għal dan il-URL u dan id-dramm hawn.

25
00:01:13,970 --> 00:01:18,810
Allura mingħajr aktar dewmien, illum aħna
tkompli dan il-ħarsa lejn programmazzjoni web,

26
00:01:18,810 --> 00:01:21,810
u l-ħolqien attwali ta 'programmi
li ma jmorrux fil-kmand linja tiegħek,

27
00:01:21,810 --> 00:01:24,080
iżda minflok run ġewwa ta 'browser.

28
00:01:24,080 --> 00:01:26,320
>> Preżumibbilment issa, jew ħafna
dalwaqt, int ser

29
00:01:26,320 --> 00:01:30,200
li jkun fil-midst ta 'implimentazzjoni
web server tiegħek stess, li

30
00:01:30,200 --> 00:01:31,700
hija differenti minn programmazzjoni web.

31
00:01:31,700 --> 00:01:36,210
Il-web server fl pset6 hija kollha dwar
kitba software li jaf kif jieħdu

32
00:01:36,210 --> 00:01:39,300
Talbiet HTTP minn browser,
jew saħansitra mill inti, bniedem,

33
00:01:39,300 --> 00:01:42,340
ma 'programm imsejjaħ telnet, u
imbagħad jirrispondu għal dawk it-talbiet jew

34
00:01:42,340 --> 00:01:48,600
billi tobżoq out fajl HTML, jew
jpeg, jew gif, jew saħansitra fajl PHP.

35
00:01:48,600 --> 00:01:52,490
>> Iżda ma 'web server, mhuwiex
suppost biss tiftaħ fajl PHP,

36
00:01:52,490 --> 00:01:55,260
xi ħaġa li jispiċċa fil-PHP, u
imbagħad bżiq out-kontenut.

37
00:01:55,260 --> 00:01:58,440
Huwa suppost li tagħmel
dak li dan il-fajl ewwel?

38
00:01:58,440 --> 00:01:59,390
Biex ngħidu hekk.

39
00:01:59,390 --> 00:02:04,060
Mhux josservawha, għidna nhar it-Tnejn,
iżda rather-- Għalhekk, tinterpreta dan.

40
00:02:04,060 --> 00:02:08,070
>> PHP huwa lingwa interpretat, u għalhekk
Waħda mill-karatteristiċi ewlenin fil-web tiegħek

41
00:02:08,070 --> 00:02:11,550
server, għalkemm implimentati mill us,
hija din il-ħila għall-web server tiegħek

42
00:02:11,550 --> 00:02:12,490
li l-avviż, oh.

43
00:02:12,490 --> 00:02:14,580
Dan huwa fajl li jispiċċa fil-PHP.

44
00:02:14,580 --> 00:02:17,970
Let me mhux biss tibgħat lill-
utent simili huwa kontenut statiku,

45
00:02:17,970 --> 00:02:20,970
iżda pjuttost let me taqraha linja minn
linja, xellug għal-lemin, u jinterpreta dan.

46
00:02:20,970 --> 00:02:23,030
>> U li jagħmlu, li inti
guys se essenzjalment

47
00:02:23,030 --> 00:02:26,520
Punt għal programm fl-appliance,
u fuq lott ta 'sistemi tal-kompjuter,

48
00:02:26,520 --> 00:02:27,500
biss imsejħa PHP.

49
00:02:27,500 --> 00:02:30,579
Li huwa l-isem ta 'PHP l-
interpretu stess lingwa.

50
00:02:30,579 --> 00:02:33,120
Allura, li l-biċċa nimplimentaw għall
inti, u dak ix-xellug għalik,

51
00:02:33,120 --> 00:02:35,240
finalment, huwa numru
ta 'biċċiet, fosthom

52
00:02:35,240 --> 00:02:37,960
qed timplimenta l-appoġġ
għall-kontenut statiku.

53
00:02:37,960 --> 00:02:40,180
>> Imma issa, u ma '
problema sett seba, int

54
00:02:40,180 --> 00:02:43,660
ser tibda tranżizzjoni għal
fatt bil-miktub l-kodiċi PHP

55
00:02:43,660 --> 00:02:45,970
li gets interpretat
fil tkellem għal tmiem lura

56
00:02:45,970 --> 00:02:47,960
database li taħżen l-informazzjoni.

57
00:02:47,960 --> 00:02:51,020
Mela ejja jifhmu aħjar l-ewwel
koppja ta 'dawn superglobals

58
00:02:51,020 --> 00:02:53,720
u biss kemm qawwa li għandek
toħroġ il-kaxxa b'xejn

59
00:02:53,720 --> 00:02:55,250
ma 'lingwa bħal PHP.

60
00:02:55,250 --> 00:02:57,350
Affarijiet li inti ma għandekx
biex jimplimentaw yourself.

61
00:02:57,350 --> 00:03:01,700
>> Allura, rajna nhar it-Tnejn $ _GET,
li huwa superglobal,

62
00:03:01,700 --> 00:03:05,496
li huwa biss PHP jitkellmu għal globali
varjabbli jista 'jkollok aċċess kullimkien.

63
00:03:05,496 --> 00:03:06,620
U x'hemm ġewwa ta '$ _GET?

64
00:03:06,620 --> 00:03:09,930

65
00:03:09,930 --> 00:03:12,110
X'hemm ġewwa ta 'dan
superglobal li naraw?

66
00:03:12,110 --> 00:03:15,900

67
00:03:15,900 --> 00:03:19,020
Żgur statistikament fil
inqas persuna waħda jaf.

68
00:03:19,020 --> 00:03:21,590
X'hemm ġewwa ta '$ _GET?

69
00:03:21,590 --> 00:03:22,426
Yeah?

70
00:03:22,426 --> 00:03:24,130
>> UDJENZA: Hu l-varjabbli
inti tpoġġi fis-sekwenza mistoqsija.

71
00:03:24,130 --> 00:03:24,530
>> DAVID J. Malan: Perfect.

72
00:03:24,530 --> 00:03:26,488
Huwa l-varjabbli inti
jitqiegħdu fil-sekwenza mistoqsija.

73
00:03:26,488 --> 00:03:29,910
Allura, fl-eżempju anzjani tagħna ta '
reimplementing Google meta kellna

74
00:03:29,910 --> 00:03:34,130
URL, u mbagħad kwistjoni mark,
li tiddemarka l-bidu tal HTTP

75
00:03:34,130 --> 00:03:37,950
parametri, allura kellna q ugwali
xi ħaġa, bħal q ugwali qtates,

76
00:03:37,950 --> 00:03:41,500
dak li awtomatikament imorru ġewwa
ta 'li $ _GET super globali għalik,

77
00:03:41,500 --> 00:03:47,430
minħabba PHP, huwa ċentrali ta 'Q,
u tal-valur tiegħu ta 'qtates.

78
00:03:47,430 --> 00:03:51,250
>> Fi kliem ieħor, $ _GET u kollha ta '
dawn l-affarijiet huma arrays assoċjattiva,

79
00:03:51,250 --> 00:03:54,530
tabelli hash ta 'tipi, li
ċwievet taħżen u valuri.

80
00:03:54,530 --> 00:03:57,980
Issa, lura fl pset5, il-hash
tabella inti jista 'jkollok implimentati,

81
00:03:57,980 --> 00:04:00,220
jew il ipprova inti tista
implimentaw, verament

82
00:04:00,220 --> 00:04:04,010
kien effettivament assoċjattiv
array, struttura data

83
00:04:04,010 --> 00:04:07,220
fejn inti tista 'tassoċja
ċwievet bil-valuri.

84
00:04:07,220 --> 00:04:09,690
>> Iżda fil pset5, il-valuri kienu trivjali.

85
00:04:09,690 --> 00:04:12,430
Il-valur kien essenzjalment vera jew falza.

86
00:04:12,430 --> 00:04:13,900
Hija l-kelma fid-dizzjunarju?

87
00:04:13,900 --> 00:04:18,279
Allura, meta inti hashed kelma bħal tuffieħ
biex tara jekk tuffieħ huwa fil-dizzjunarju,

88
00:04:18,279 --> 00:04:21,820
funzjoni check tiegħek preżumibbilment
lura vera jew falza.

89
00:04:21,820 --> 00:04:24,120
Allura, dak effettivament l-
valur aħna qed jkollna lura.

90
00:04:24,120 --> 00:04:26,456
>> Imma rajna nhar it-Tnejn
qosor, inti tista 'ċertament

91
00:04:26,456 --> 00:04:28,830
jassoċjaw aktar interessanti
Valuri milli sempliċement vera jew falza

92
00:04:28,830 --> 00:04:30,790
bl ċwievet, bħal tuffieħ.

93
00:04:30,790 --> 00:04:33,909
Inti tista 'attwalment jirritorna l
string arbitrarja, u tabilħaqq,

94
00:04:33,909 --> 00:04:36,200
dan huwa dak $ _GET u dawn
varjabbli oħra let inti tagħmel.

95
00:04:36,200 --> 00:04:40,595
>> Allura $ _POST huwa simili fl-ispirtu,
imma jekk inti jissottomettu formola bil-posta,

96
00:04:40,595 --> 00:04:44,490
metodu HTTP differenti li l-
użat għal affarijiet bħal karti ta 'kreditu,

97
00:04:44,490 --> 00:04:48,410
u informazzjoni privata, u anki
informazzjoni binarja bħall ritratti,

98
00:04:48,410 --> 00:04:51,840
dawk l-affarijiet jispiċċaw ġewwa ta '$ _POST.

99
00:04:51,840 --> 00:04:53,770
U fil-fatt għall-fajls
bħal jpegs u whatnot,

100
00:04:53,770 --> 00:04:58,290
hemm anke ieħor li mhux
up here imsejħa $ _FILES kif ukoll.

101
00:04:58,290 --> 00:05:01,280
>> Allura, server aħna mhux se nitkellem fuq wisq
ħafna, iżda li tagħtik aċċess

102
00:05:01,280 --> 00:05:04,860
sort ta 'dettalji livell aktar baxx dwar
l-server innifsu li inti qed tuża.

103
00:05:04,860 --> 00:05:07,430
Cookie u sessjoni, għalkemm,
Ser naraw effettiv issa.

104
00:05:07,430 --> 00:05:10,940
L-aħħar huwa dak li nużaw biex jimplimentaw
l-kunċett ta 'shopping cart.

105
00:05:10,940 --> 00:05:14,480
A super sempliċi wieħed, iżda recall
li kellna dan l-eżempju hawn,

106
00:05:14,480 --> 00:05:17,640
għadd kif ħafna drabi inti
kien żar din il-paġna qabel.

107
00:05:17,640 --> 00:05:20,850
>> Imma llum, aktar milli biss ħarsa lejn
l-effett ta 'dan, ejja jiftħu

108
00:05:20,850 --> 00:05:22,640
Spettur Chrome,
li inti tista 'normalment

109
00:05:22,640 --> 00:05:25,740
tagħmlu billi tikklikkja jew Control dritt
tikklikkja kullimkien fuq paġna web,

110
00:05:25,740 --> 00:05:27,250
u mbagħad jagħżlu jispezzjonaw element.

111
00:05:27,250 --> 00:05:31,600
Jew inti tista 'tmur permezz tal-menus
li aħna jiddeskrivu fid spec pset6 tal.

112
00:05:31,600 --> 00:05:35,020
U jien ser l-tab Network
hawn, u ejja watch għal mument

113
00:05:35,020 --> 00:05:37,590
it-traffiku HTTP li l-
jmorru quddiem u lura.

114
00:05:37,590 --> 00:05:40,929
>> Let me ewwel imorru quddiem
u cache Chrome ċara tal.

115
00:05:40,929 --> 00:05:43,470
Allura xi wħud minnkom jista 'jkun familjari
ma din it-teknika diġà,

116
00:05:43,470 --> 00:05:45,790
u aħna qed tmur biex tużah
għal skopijiet debugging hawn.

117
00:05:45,790 --> 00:05:48,890

118
00:05:48,890 --> 00:05:50,890
Issa aħna bħala kompjuter
xjentisti ser tibda

119
00:05:50,890 --> 00:05:53,920
tagħmel dan għall debugging
skopijiet, li biha

120
00:05:53,920 --> 00:05:55,910
aħna se tikklerja l-cache,
tipikament, sabiex inkunu

121
00:05:55,910 --> 00:05:57,670
tista 'teħles minn affarijiet imsejħa cookies.

122
00:05:57,670 --> 00:06:01,700
Allura int probabilment ġeneralment familjari
ma 'dak cookies huma, jew għall-inqas

123
00:06:01,700 --> 00:06:04,370
li dawn jeżistu, iżda x'hemm
komprensjoni tiegħek minnhom,

124
00:06:04,370 --> 00:06:06,920
biss bħala utent ta '
kompjuters, dak li huwa cookie?

125
00:06:06,920 --> 00:06:09,490

126
00:06:09,490 --> 00:06:09,990
Yeah.

127
00:06:09,990 --> 00:06:14,391
>> UDJENZA: Huwa daqsxejn of-- tajjeb, ma
bit fi żmien ta 'xjenza tal-kompjuter.

128
00:06:14,391 --> 00:06:18,303
Huwa biċċa ta 'data li
websajt tibgħat lilek sabiex

129
00:06:18,303 --> 00:06:20,209
biex ikunu kapaċi jirreġistra l-istatistika fuqek.

130
00:06:20,209 --> 00:06:21,250
DAVID J. Malan: OK, tajba.

131
00:06:21,250 --> 00:06:24,980
Allura huwa biċċa ta 'data li
server, tpoġġi fuq il-kompjuter tiegħek,

132
00:06:24,980 --> 00:06:28,840
u ejja jiġġeneralizza anki
aktar, huwa importanti value-- sew,

133
00:06:28,840 --> 00:06:30,064
li jkollna aktar preċiża.

134
00:06:30,064 --> 00:06:31,980
Hija biċċa ta '
informazzjoni, biċċa ta 'data,

135
00:06:31,980 --> 00:06:34,430
li server huwa kapaċi
li jitpoġġew fuq il-kompjuter tiegħek

136
00:06:34,430 --> 00:06:38,592
u ħafna drabi, il-server ma
dan sabiex tiftakar min int.

137
00:06:38,592 --> 00:06:40,300
Hekk per eżempju, odds
huma int probabilment

138
00:06:40,300 --> 00:06:42,982
logged in siti bħal Facebook,
jew Gmail, jew oħrajn qabel,

139
00:06:42,982 --> 00:06:44,940
u tilloggja bil tiegħek
username u password,

140
00:06:44,940 --> 00:06:49,000
u mbagħad wara li, għal xi numru
ta 'minuti jew sigħat jew jiem anke,

141
00:06:49,000 --> 00:06:52,970
il-server jiftakar li
inti, fil-fatt, illoggjat.

142
00:06:52,970 --> 00:06:54,600
Issa, kif huwa li attwalment jiġri?

143
00:06:54,600 --> 00:06:58,630
Għax int żgur mhux retyping
username u password kull darba

144
00:06:58,630 --> 00:07:00,760
inti jinnaviga għal
paġna differenti fuq Facebook.

145
00:07:00,760 --> 00:07:02,570
Għalhekk jirriżulta li l-
cookies huma r-risposta.

146
00:07:02,570 --> 00:07:05,360
>> A cookie inti tista 'taħseb bħala,
tip simili, idejn diġitali

147
00:07:05,360 --> 00:07:09,200
timbru li inti tista 'tikseb fi divertiment
park jew klabb li essenzjalment

148
00:07:09,200 --> 00:07:11,740
tindika ġejt hawn
qabel, u inti stajt diġà

149
00:07:11,740 --> 00:07:16,070
muri ID tiegħek għall-bouncer, għal
Pereżempju, u li l-klabb jew l-park

150
00:07:16,070 --> 00:07:19,050
għandu issa jassumi li inti
diġà awtentikati.

151
00:07:19,050 --> 00:07:21,270
Inti diġà ġew identifikati minnha.

152
00:07:21,270 --> 00:07:24,740
>> Allura jekk wieħed iżomm f'moħħu,
ejja jiftħu counter here.

153
00:07:24,740 --> 00:07:27,220
Let me imorru quddiem, I biss ma,
u ċara kollha ta 'cookies tiegħi.

154
00:07:27,220 --> 00:07:29,970
U issa dak li jien ser tagħmel hu li
istiva Shift, biss għal miżura tajba,

155
00:07:29,970 --> 00:07:31,740
u sfurzat rikarigu-paġna.

156
00:07:31,740 --> 00:07:34,170
Shift biss tagħmel żgur
li xejn gets Cached.

157
00:07:34,170 --> 00:07:36,850
U hawnhekk it-talba
li marru quddiem u lura.

158
00:07:36,850 --> 00:07:41,560
Allura hawn għandna talba, u let
me zoom isfel hawn, u ħafna ta 'dan

159
00:07:41,560 --> 00:07:44,710
huwa dettalji tip ta uninteresting għal
issa li l-browser għandha awtomatikament

160
00:07:44,710 --> 00:07:47,800
mibgħuta, imma ejja ikklikkja View
Sors biex tara d-headers prima.

161
00:07:47,800 --> 00:07:51,700
>> U jekk inti stajt dived fis pset6 diġà,
inti ser ċertament jirrikonoxxu affarijiet

162
00:07:51,700 --> 00:07:54,990
bħal dan, u forsi xi
ta 'dawn il-linji l-oħra hawn,

163
00:07:54,990 --> 00:07:59,040
imma x'hemm aktar interessanti għal-lum
jekk I iscroll, mhux għat-talba

164
00:07:59,040 --> 00:08:02,870
iżda għar-rispons hekk imsejħa,
din il-linja probabbilment jistenna familjari.

165
00:08:02,870 --> 00:08:04,977
Li l-ħaġa tajba
meta inti tara 200 OK.

166
00:08:04,977 --> 00:08:07,060
Apparentement dan huwa l-
data u l-ħin fuq is-server

167
00:08:07,060 --> 00:08:08,268
u hemm mazz ta 'għalf.

168
00:08:08,268 --> 00:08:09,290
Oh, dan huwa interessanti.

169
00:08:09,290 --> 00:08:13,430
>> Jinstabx kull meta inti tuża
PHP, għall-inqas f'dan server,

170
00:08:13,430 --> 00:08:16,360
l-server spits out liema
verżjoni ta 'PHP inti qed tuża.

171
00:08:16,360 --> 00:08:18,962
Li, fil-fatt, għas-sigurtà
skopijiet, mhix ħaġa tajba.

172
00:08:18,962 --> 00:08:21,170
Iżda, aħna ser terga 'lura għal dik
xi żmien ieħor forsi.

173
00:08:21,170 --> 00:08:25,740
Imma issa dan huwa l-linja mmerraq llum,
u rajna fil-qosor xi wħud minn dawn,

174
00:08:25,740 --> 00:08:29,240
Naħseb ma Facebook meta aħna poked
madwar l-Ispettur dak iż-żmien,

175
00:08:29,240 --> 00:08:33,380
cookie sett huwa dak li huwa tħawwil
li ftit biċċa informazzjoni

176
00:08:33,380 --> 00:08:34,890
fuq il-kompjuter tiegħek.

177
00:08:34,890 --> 00:08:37,490
>> Dan huwa header HTTP
thats effettivament

178
00:08:37,490 --> 00:08:39,970
javżak browser tiegħek,
Chrome, IE, ikun x'ikun,

179
00:08:39,970 --> 00:08:44,480
ħej browser maħżen fuq li l-utent
hard drive, jew RAM-utent,

180
00:08:44,480 --> 00:08:49,680
ewlieni imsejjaħ PHPSESSID, li huwa
notazzjoni shorthand għal sessjoni ID,

181
00:08:49,680 --> 00:08:53,670
u tagħtiha valur ta '
0vlk8t, dot, dot, dot.

182
00:08:53,670 --> 00:08:56,480
A psewdo verament twila
string alfanumerika każwali.

183
00:08:56,480 --> 00:08:59,480
Huwa biss numru verament kbir, iżda
huwa encoded ma 'ittri u numri

184
00:08:59,480 --> 00:09:03,550
sabiex id-daqs ta 'dan jista' jkun
saħansitra ikbar minn numri biss.

185
00:09:03,550 --> 00:09:06,947
U mbagħad, mill-mod, Path = /, li
ifisser biss li dan il-cookie għandha tkun

186
00:09:06,947 --> 00:09:08,780
assoċjati mal-
intier tal-websajt,

187
00:09:08,780 --> 00:09:11,150
mhux biss speċifika
paġna il-ħaġa sħiħa.

188
00:09:11,150 --> 00:09:12,930
Allura dan huwa dak timbru idejn virtwali.

189
00:09:12,930 --> 00:09:16,330
Huwa bħallikieku l-server, Facebook,
jew fil-każ tagħna l-appliance,

190
00:09:16,330 --> 00:09:21,140
għandha 0vlk8t litteralment miktub
u oħrajn, fuq naħa tiegħek.

191
00:09:21,140 --> 00:09:24,360
Avviż dak li l-server,
ma nagħmilx huwa mhuwiex

192
00:09:24,360 --> 00:09:27,730
ħażna username tiegħi, ċertament
mhux ħażna password tiegħi.

193
00:09:27,730 --> 00:09:31,710
>> Minflok, jidher li jkun
ħażna ta 'informazzjoni psewdo każwali

194
00:09:31,710 --> 00:09:35,010
b'tali mod li ebda wieħed jista raden
liema timbru idejn tiegħi huwa.

195
00:09:35,010 --> 00:09:37,590
Fuq in-naħa server,
sadanittant, il-server

196
00:09:37,590 --> 00:09:40,370
se tiftakar, probabbilment
f'database jew xi ħaġa,

197
00:09:40,370 --> 00:09:46,490
li l-utent, li fil-futur
jippreżenta timbru idejn ta 0vlk8t, dot,

198
00:09:46,490 --> 00:09:51,440
dot, dot, għandhom ikunu assoċjati ma 'din
partikolari shopping cart, biex ngħidu hekk.

199
00:09:51,440 --> 00:09:55,060
Fi kliem ieħor, jekk I issa jmorru
lura hawn u rikarigu din il-paġna,

200
00:09:55,060 --> 00:09:58,020
kif ma 'l-server jaf
li I miżjura darba waħda?

201
00:09:58,020 --> 00:10:01,730
>> Jew jekk I jagħmlu mill-ġdid, kif ma 'l-server
jafu li stajt żar it darbtejn?

202
00:10:01,730 --> 00:10:04,680
Ukoll jekk I jinżlu għal din
aktar talba reċenti, li

203
00:10:04,680 --> 00:10:09,150
issa hija t-tielet li stajt mibgħuta
b'kollox, avviż talba tiegħi issa.

204
00:10:09,150 --> 00:10:11,300
Għad hemm din
jitlob up here,-istess

205
00:10:11,300 --> 00:10:15,040
bħal qabel, għad hemm mazz sħiħ
ta 'għalf li konna injorati bħal qabel,

206
00:10:15,040 --> 00:10:19,350
iżda l-ħafna aħħar header, dan
żmien, għaliex stajt kien hawn qabel,

207
00:10:19,350 --> 00:10:21,980
hija preżentazzjoni ta '
dan it-timbru virtwali idejn.

208
00:10:21,980 --> 00:10:28,957
>> Li biha din il-linja hawn, mhux stabbiliti cookie
iżda cookie kolon PHPSESSI = 0vlk8t,

209
00:10:28,957 --> 00:10:32,040
li jinsab biss browser tiegħi awtomatika
preżentazzjoni ta 'dan it-timbru idejn sabiex

210
00:10:32,040 --> 00:10:37,910
issa l-server, hekk kif jirrealizza,
ooh, dan huwa l-utent 0vlk8t dot, dot, dot,

211
00:10:37,910 --> 00:10:42,010
I issa jistgħu jiftakru li hu jew hi
u reassociate ma 'dak l-utent ikun x'ikun

212
00:10:42,010 --> 00:10:46,450
informazzjoni Irrid li, u kollha ta '
dik l-informazzjoni tista 'tiġi maħżuna minnek,

213
00:10:46,450 --> 00:10:50,130
l-programmer, fil $ _SESSION.

214
00:10:50,130 --> 00:10:57,170
>> Allura biex tkun ċara, jekk I jiftħu malajr reali
fil gedit dan il-fajl attwali, counter.php,

215
00:10:57,170 --> 00:11:02,340
fl-direttorju pubbliku ospitanti lokali tiegħi
bħal qabel, avviż li, tabilħaqq,

216
00:11:02,340 --> 00:11:06,860
Jien finalment ħażna fil
$ _SESSION Kwotazzjoni unquote "counter,"

217
00:11:06,860 --> 00:11:10,110
il-valur tal-counter ta 'qabel li
I tikseb minn dawn il-linji up here li aħna

218
00:11:10,110 --> 00:11:13,010
ħares lejn aħħar darba plus wieħed.

219
00:11:13,010 --> 00:11:14,980
Hekk taħt il-barnuża,
li l-cookies kollha huma.

220
00:11:14,980 --> 00:11:17,563
Huwa biss il-tip ta diġitali
timbru idejn jmorru quddiem u lura,

221
00:11:17,563 --> 00:11:20,450
u franchement jekk inti tiftaħ l Chrome
Spettur fuq kwalunkwe websajt

222
00:11:20,450 --> 00:11:22,580
inti żżur illum, ma
super probabbiltà għolja,

223
00:11:22,580 --> 00:11:25,450
int ser tara forsi waħda,
forsi nofs tużżana cookies

224
00:11:25,450 --> 00:11:26,650
qed mfakkar minnek.

225
00:11:26,650 --> 00:11:29,500
>> U agħar għadu, jekk dawk
websajt int jżuru

226
00:11:29,500 --> 00:11:32,640
kollha għandhom reklami, li
huwa ċertament pjuttost komuni llum,

227
00:11:32,640 --> 00:11:36,100
u jekk dawk ir-reklami huma ġejjin
minn xi parti ċentrali, xi ħadd

228
00:11:36,100 --> 00:11:39,000
bħall-Google jew AdWords kif
sejħa wieħed mill-prodotti tagħhom

229
00:11:39,000 --> 00:11:42,880
jew bejjiegħa oħra bħal dawn li
jbiegħu ads, x'hemm interessanti,

230
00:11:42,880 --> 00:11:46,510
u franchement x'hemm ftit
tħassib, dwar kif HTTP xogħlijiet,

231
00:11:46,510 --> 00:11:50,855
hija li jekk għandek ad inkorporat
fil Facebook.com, u Google.com,

232
00:11:50,855 --> 00:11:54,240
u Harvard.edu, kull numru
ta 'websajts, dan huwa tali

233
00:11:54,240 --> 00:11:58,130
li hemm bniedem tan-nofs li qed iservi
up ads għal kull tlieta minn dawn il-websajts,

234
00:11:58,130 --> 00:12:02,110
jirriżulta li l-
cookies huma għal kull dominju.

235
00:12:02,110 --> 00:12:05,910
>> Mela jekk għandek ad li ġejjin mill-
istess kumpanija fuq il-websajts differenti,

236
00:12:05,910 --> 00:12:11,140
dik il-kumpannija tista 'effettivament track li
inti madwar kollha ta 'dawn il-websajts.

237
00:12:11,140 --> 00:12:13,140
Harvard jista 'ma jafux
qed iżuru Facebook.

238
00:12:13,140 --> 00:12:15,306
Facebook ma jista jafu u
int jżuru Harvard.

239
00:12:15,306 --> 00:12:18,160
Imma tkun xi tkun servizz ad
dawn qed jużaw jekk dik dominju huwa

240
00:12:18,160 --> 00:12:21,710
preżenti fiż-żewġ web Harvard.edu
paġni u webpages Facebook.com,

241
00:12:21,710 --> 00:12:26,850
dan il-bniedem tan-nofs żgur jaf min int
minħabba dawn il-cookies tiġi maqsuma

242
00:12:26,850 --> 00:12:30,910
madwar, jew pjuttost li,
li l-hekk imsejħa middleman.

243
00:12:30,910 --> 00:12:33,820
>> Allura aħna ser terga 'lura għal dan fil
implikazzjonijiet ta 'sigurtà tagħhom,

244
00:12:33,820 --> 00:12:37,170
imma hemm ħafna ta 'informazzjoni
maħżuna dwarek kwalunkwe ħin li inti

245
00:12:37,170 --> 00:12:40,120
żur aktar xi paġna tal-web fuq
l-internet u li verament

246
00:12:40,120 --> 00:12:42,877
inaqqas għal dan il-mekkaniżmu sempliċi ħafna.

247
00:12:42,877 --> 00:12:44,710
X'jiġri, imbagħad, jekk
int super paranojde

248
00:12:44,710 --> 00:12:48,190
u inti tiddeċiedi li jmorru fis Chrome jew IE
jew kwalunkwe u itfi cookies tiegħek?

249
00:12:48,190 --> 00:12:49,365
X'jiġri?

250
00:12:49,365 --> 00:12:50,790
Yeah?

251
00:12:50,790 --> 00:12:53,170
You really-- inti ghamilt dan id-dritt?

252
00:12:53,170 --> 00:12:54,350
OK.

253
00:12:54,350 --> 00:12:55,994
Le, imorru quddiem.

254
00:12:55,994 --> 00:12:59,645
>> UDJENZA: Ċerti websajts ma jkollhom
funzjoni mingħajr ma simili Facebook.

255
00:12:59,645 --> 00:13:00,520
DAVID J. Malan: Yeah!

256
00:13:00,520 --> 00:13:02,311
Allura ċerti websajts
se biss tieqaf taħdem.

257
00:13:02,311 --> 00:13:05,520
U f'ħafna websajts dawn il-jiem
li fundamentalment jiddependu fuq cookies,

258
00:13:05,520 --> 00:13:08,360
speċjalment jekk dawn ikollhom tilloggja
fil, dawn qed biss jmorru biex jinkiser.

259
00:13:08,360 --> 00:13:10,360
Minħabba jikkunsidraw il-
alternattiva, jekk il-websajt

260
00:13:10,360 --> 00:13:14,480
m'għandha l-ebda mod ta 'ftakar min int,
u għalhekk web browser tiegħek ma tkunx

261
00:13:14,480 --> 00:13:16,949
jirrappreżentaw ma 'kull HTTP
talba ta 'dan it-timbru idejn,

262
00:13:16,949 --> 00:13:18,740
effettiv websajt
simili tmur Facebook

263
00:13:18,740 --> 00:13:22,050
li jkollhom pront inti biex
log f'kull ħin darn

264
00:13:22,050 --> 00:13:26,200
int bdilt paġni, jew ikklikkja rabta, li
huwa żgur mhumiex utenti partikolarment tajba

265
00:13:26,200 --> 00:13:26,920
esperjenza.

266
00:13:26,920 --> 00:13:30,020
>> Allura li hemm, wisq, huwa
fost il-kompromessi.

267
00:13:30,020 --> 00:13:34,140
Allura mingħajr aktar dewmien, ejja tagħti
għall mogħtija li mal-programmazzjoni web,

268
00:13:34,140 --> 00:13:37,630
fil-lingwi bħal PHP, inti tista tiftakar
informazzjoni bħal dik fl problema stabbiliti

269
00:13:37,630 --> 00:13:41,550
seba meta inti jimplimentaw tiegħek stess
Website E * Kummerċ simili li biex jixtru

270
00:13:41,550 --> 00:13:45,710
u jbigħu l-ħażniet, inti ser tiftakar eżattament
dak l-utent ikun mixtrija u mibjugħa

271
00:13:45,710 --> 00:13:49,110
u li hu jew hi
permezz ta 'din is-sessjoni.

272
00:13:49,110 --> 00:13:51,110
Imma aħna qed tmur għall-ħtieġa
mod fancier minn email

273
00:13:51,110 --> 00:13:52,640
biex tibda jżommu l-informazzjoni madwar.

274
00:13:52,640 --> 00:13:53,140
Dritt?

275
00:13:53,140 --> 00:13:56,780
>> Nhar it-Tnejn, tkellimna dwar IMs Frosh
u kif fil-verżjoni waħda ta 'din il-websajt,

276
00:13:56,780 --> 00:14:00,250
snin ilu, kollox aħna ma kien
email Procter li s

277
00:14:00,250 --> 00:14:04,250
responsabbli mill-isports intramurali
programm, l-isem, u l-ġeneru,

278
00:14:04,250 --> 00:14:07,330
u jekk jew le dawn qed kaptan,
u l dorm ta xi ħadd li

279
00:14:07,330 --> 00:14:10,136
reġistrazzjoni għal sport intramurali.

280
00:14:10,136 --> 00:14:13,010
Allura huwa mhux ħażin, iżda hu jew hi imbagħad
kellhom troll permezz ta 'email tagħhom,

281
00:14:13,010 --> 00:14:16,010
tagħmel spreadsheet jew xi ħaġa simili
li, biex iżommu kollox organizzat.

282
00:14:16,010 --> 00:14:19,750
Allura żgur aħna bħala programmaturi
tista 'tagħmel dan għal dak Procter.

283
00:14:19,750 --> 00:14:22,970
U hekk jidħol fil SQL,
Strutturat Mistoqsija Lingwa,

284
00:14:22,970 --> 00:14:26,050
li se tfittex pretty
differenti kemm C u PHP,

285
00:14:26,050 --> 00:14:30,990
u tkun taf adsa ħafna aktar idejn fuq
PHP u l-problema jistabbilixxu sebgħa imma wkoll SQL,

286
00:14:30,990 --> 00:14:35,310
jew SQL, din hija lingwa li
tuża biex jitkellmu ma 'database.

287
00:14:35,310 --> 00:14:36,480
>> Imma x'hemm database?

288
00:14:36,480 --> 00:14:38,440
Well taħseb ta '
database, għall-inqas għal issa,

289
00:14:38,440 --> 00:14:41,750
bħala sempliċement bħal fajl Excel, jew
jekk int Mac numri utent fajl,

290
00:14:41,750 --> 00:14:44,400
jew jekk int Apps Google
utent spreadsheet Google,

291
00:14:44,400 --> 00:14:49,120
huwa effettivament database, jew verament
speċifikament database relazzjonali.

292
00:14:49,120 --> 00:14:53,070
A database relazzjonali huwa biss
xi ħaġa li għandha ringieli u kolonni,

293
00:14:53,070 --> 00:14:56,440
u inti jista 'jaħżen kwalunkwe tip ta'
informazzjoni f'dawn fillieri jew kolonni.

294
00:14:56,440 --> 00:15:00,480
>> Imma x'hemm sbieħ dwar SQL, u
dwar databases attwali, mhux biss

295
00:15:00,480 --> 00:15:04,910
spreadsheets jew spreadsheets Google,
hija li inti tista 'tuża lingwa

296
00:15:04,910 --> 00:15:09,000
li attwalment tesegwixxi mistoqsijiet li
daħħal data, biex jitneħħew id-data,

297
00:15:09,000 --> 00:15:11,620
biex tfittex data, anke
aktar importanti, u int

298
00:15:11,620 --> 00:15:16,110
ma għandekx tużah pjuttost manwalment
kif inti tista tipikament Google

299
00:15:16,110 --> 00:15:17,690
spreadsheet bħal dan.

300
00:15:17,690 --> 00:15:22,217
>> Allura fil SQL, hemm mazz ta '
dikjarazzjonijiet fundamentali jew biċċiet

301
00:15:22,217 --> 00:15:23,300
ta 'funzjonalità mibnija.

302
00:15:23,300 --> 00:15:26,450
Hemm ħafna aktar minn dawn,
imma int tista 'tmur distanza enormi

303
00:15:26,450 --> 00:15:28,620
biss billi jafu li
din il-lingwa imsejħa

304
00:15:28,620 --> 00:15:30,840
SQL għandu mill-inqas erba '
dikjarazzjonijiet inti tista 'lieva.

305
00:15:30,840 --> 00:15:34,420
>> Ħassar, għat-tneħħija tad-data,
Daħħal, għaż-żieda ringieli,

306
00:15:34,420 --> 00:15:37,340
Aġġornament, għall-bdil
ringieli, u l-għażla,

307
00:15:37,340 --> 00:15:39,860
għall jkollna lura ringieli u
dan huwa tabilħaqq dak SQL ma.

308
00:15:39,860 --> 00:15:43,810
Hija topera kompletament fuq ringieli hekk
li meta inti daħħal, jew ineħħu,

309
00:15:43,810 --> 00:15:47,470
jew aġġornament, jew tagħżel dak li int
jkollna lura bħala hekk imsejħa sett riżultat,

310
00:15:47,470 --> 00:15:49,690
bħal firxa ta 'ringieli.

311
00:15:49,690 --> 00:15:51,700
A mazz ta 'ringieli minn tabella.

312
00:15:51,700 --> 00:15:54,050
>> Allura lura fil-ġurnata,
u anke biex din il-ġurnata,

313
00:15:54,050 --> 00:15:56,560
inti tista 'jinteraġixxu mal-
database tuża linja tal-kmand,

314
00:15:56,560 --> 00:15:59,691
iżda mhux partikolarment divertenti għall-użu
dan il-tieqa iswed u abjad stil

315
00:15:59,691 --> 00:16:02,190
u fil-fatt tesegwixxi jikkmanda
u poke madwar database tiegħek.

316
00:16:02,190 --> 00:16:06,054
A user interface grafika, jew GUI,
huwa ħafna aktar preferibbli, forsi,

317
00:16:06,054 --> 00:16:08,970
u għalhekk l-għodda nirrakkomandaw u
preinstalled għalik fuq l-appliance

318
00:16:08,970 --> 00:16:10,580
huwa msejjaħ phpMyAdmin.

319
00:16:10,580 --> 00:16:14,060
Huwa koinċidenza total li l-
isem ta 'dan ħaġa għandha PHP fiha,

320
00:16:14,060 --> 00:16:17,430
dan ifisser biss li l-poplu
li kiteb dan il-programm huma stess

321
00:16:17,430 --> 00:16:18,670
kiteb dan fil-PHP.

322
00:16:18,670 --> 00:16:23,740
>> Imma hija finalment dwar jamministra
server database, bħal MySQL server

323
00:16:23,740 --> 00:16:26,589
li inti jista 'jkollok, kif inti
do, fl-appliance CS50.

324
00:16:26,589 --> 00:16:29,130
Allura hemm aktar dettall hawn minn
għandna bżonn għall-kura dwar llum,

325
00:16:29,130 --> 00:16:33,280
imma dak ewlieni huwa li fuq ix-xellug
naħa hija lista tad-databases

326
00:16:33,280 --> 00:16:36,040
li għandek fuq il-kompjuter tiegħek,
fuq appliance CS50 tiegħek,

327
00:16:36,040 --> 00:16:40,090
jew jiġu proġetti finali li inti tista
jkollhom fuq parti terza, ta 'l-kumpanija

328
00:16:40,090 --> 00:16:43,415
websajt jew web server, li
inti tista 'tħallas għall-ispazju.

329
00:16:43,415 --> 00:16:45,290
Allura fuq ix-xellug huwa l-
databases, li waħda minnhom

330
00:16:45,290 --> 00:16:48,750
huwa pset7 li jiena misluf mill jmiss
ġimgħat pset, u mbagħad fuq il-quċċata

331
00:16:48,750 --> 00:16:51,570
hemm avviż hemm
mazz ta 'tabs, li waħda minnhom

332
00:16:51,570 --> 00:16:55,150
huwa databases, SQL, status,
utenti, l-esportazzjoni u oħrajn.

333
00:16:55,150 --> 00:16:56,900
Allura inti tista 'tmur twil
mod biss billi realizzat

334
00:16:56,900 --> 00:16:59,770
li ħafna mill-user interface
hija fil-kolonna tax-xellug

335
00:16:59,770 --> 00:17:02,650
u madwar l-quċċata dritt up hemm.

336
00:17:02,650 --> 00:17:04,980
Allura x'nistgħu attwalment tagħmel ma 'dan?

337
00:17:04,980 --> 00:17:08,609
Well, ejja tibda ħolqien ta '
daqsxejn ta 'informazzjoni kif ġej.

338
00:17:08,609 --> 00:17:11,760
>> Ejja ngħidu li ġej huwa l-każ,
kif se jkun fi ftit jiem,

339
00:17:11,760 --> 00:17:14,440
inti tixtieq li jimplimentaw
websajt, imsejħa CS50 Finanzi,

340
00:17:14,440 --> 00:17:17,328
u din il-websajt ihallik jixtru
nikkwota unquote u tbiegħ il-ħażniet.

341
00:17:17,328 --> 00:17:19,619
U li għaddej biex insemmu
il-prezz ta 'dawk l-istokkijiet,

342
00:17:19,619 --> 00:17:22,380
finalment kif tkun taf tara,
billi tkellem lill Yahoo Finanzi.

343
00:17:22,380 --> 00:17:26,250
Li, wonderfully, għandha servizz b'xejn
li biha inti tista 'tgħaddi fil-ticker stokk

344
00:17:26,250 --> 00:17:29,830
bħall GOOG għall-Google, u se
jagħtuk lura istokk kurrenti Google

345
00:17:29,830 --> 00:17:32,250
prezz fi ħdan il-passat
ftit minuti inqas.

346
00:17:32,250 --> 00:17:35,080
>> Allura inti ser tuża li, finalment,
li nippretendu għall-utent

347
00:17:35,080 --> 00:17:37,750
li jixtru u jbiegħu attwali
ħażniet li jużaw flus virtwali,

348
00:17:37,750 --> 00:17:39,750
imma l-ewwel ħaġa
l-utent għaddej biex tara

349
00:17:39,750 --> 00:17:43,850
huwa dan l-iskrin login li jitlobhom
għall-username tagħhom u password.

350
00:17:43,850 --> 00:17:46,540
U għalhekk, wieħed mill-ewwel
sfidi għalik fl pset7

351
00:17:46,540 --> 00:17:50,460
se tkun biex jimplimentaw il-aħħar lura
database, il-spreadsheet jekk inti se,

352
00:17:50,460 --> 00:17:53,369
li għaddej biex jaħżnu
ismijiet u passwords utenti

353
00:17:53,369 --> 00:17:56,660
u finalment dak ħażniet huma stess, u
kemm, u kemm flus kemm huma għandhom,

354
00:17:56,660 --> 00:18:00,110
hekk mazz ta 'affarijiet oħra
tabelli oħrajn, jew spreadsheets.

355
00:18:00,110 --> 00:18:05,020
>> Mela ejja tagħti ħarsa lejn kif dan
jista 'jidher mad-daqqa t'għajn.

356
00:18:05,020 --> 00:18:06,980
Jien se jmorru lura għall-
l-appliance u jien

357
00:18:06,980 --> 00:18:14,102
se jmorru għal dan il-URL hawn
phpMyAdmin localhost / phpmyadmin

358
00:18:14,102 --> 00:18:16,060
u tkun taf tara li
jieħu me għal interface

359
00:18:16,060 --> 00:18:18,520
eżattament kif rajna fuq il-
screen shot, u hawn I

360
00:18:18,520 --> 00:18:21,560
jkollhom database addizzjonali
sejjaħ lecture għal-lum

361
00:18:21,560 --> 00:18:24,280
u let me jimxi 'l quddiem
ewwel u kklikkja fuq pset7.

362
00:18:24,280 --> 00:18:27,940
>> I jidhru li jkollhom koppja ta 'għażliet,
waħda għal prodotti ġodda, għall-ħolqien ta 'tabella ġdida,

363
00:18:27,940 --> 00:18:30,770
u link għall-utenti, li
huwa tabella I diġà maħluqa.

364
00:18:30,770 --> 00:18:31,790
Allura x'hemm tabella?

365
00:18:31,790 --> 00:18:33,740
Mela jekk inti użati Excel
qabel, u jekk inti stajt

366
00:18:33,740 --> 00:18:37,110
numri użati jew Google
Spreadsheets, inti tiftaħ tieqa

367
00:18:37,110 --> 00:18:39,350
u ikollok mazz sħiħ
ta 'ringieli u kolonni,

368
00:18:39,350 --> 00:18:43,120
iżda imbagħad inti normalment ikollhom worksheets
tul il-qiegħ, jew tabs separati.

369
00:18:43,120 --> 00:18:46,140
Inti tista 'taħseb ta' kull
worksheet bħala mejda

370
00:18:46,140 --> 00:18:51,150
hekk li database, finalment, huwa
kombinazzjoni ta 'tabelli wieħed jew aktar, wieħed

371
00:18:51,150 --> 00:18:54,064
jew aktar worksheets, fil-
dinja ta 'spreadsheet normali.

372
00:18:54,064 --> 00:18:55,980
So let me go l quddiem u
ikklikkja fuq din worksheet

373
00:18:55,980 --> 00:18:59,420
li I premade, imsejħa l-utenti, a.k.a.

374
00:18:59,420 --> 00:19:00,700
Tabella database.

375
00:19:00,700 --> 00:19:04,130
U jekk I iscroll stabbiliti hawn,
let me zoom out a bit,

376
00:19:04,130 --> 00:19:08,479
dan huwa dak phpMyAdmin huwa javżak
us huwa ġewwa ta 'din it-tabella dritt issa.

377
00:19:08,479 --> 00:19:11,020
Huwa ftit konfuża fl-ewwel
t'għajn minħabba li l-UI mhix

378
00:19:11,020 --> 00:19:15,140
il-ħaġa prettiest fid-dinja, iżda
dak li huwa interessanti huwa din il-parti hawnhekk.

379
00:19:15,140 --> 00:19:17,970
ID, username, u hash.

380
00:19:17,970 --> 00:19:20,510
>> Bil-quddiem, u tkun taf tkun f'idha
dan il-problema sett seba,

381
00:19:20,510 --> 00:19:25,050
aħna nagħtuk fajl li jinkludi super
tabella database żgħar, mislufa attwalment

382
00:19:25,050 --> 00:19:27,070
mill-Hacker edizzjoni
ta 'problema sett tnejn,

383
00:19:27,070 --> 00:19:29,480
ġewwa li minnhom hemm sitt ringieli.

384
00:19:29,480 --> 00:19:32,720
Waħda għall Belinda kollha
mod isfel sa wieħed għal Zamyla,

385
00:19:32,720 --> 00:19:35,980
u avviż lejn ix-xellug ta 'dawk
usernames huma IDs uniċi bħal wieħed,

386
00:19:35,980 --> 00:19:39,410
tnejn, tlieta, erba ', ħames, sitt, interi,
u mbagħad lejn il-lemin huma hashes.

387
00:19:39,410 --> 00:19:42,780
>> U jekk, odds huma, inti ma tagħmel
il-problema Hacker edizzjoni stabbiliti tnejn,

388
00:19:42,780 --> 00:19:46,560
iżda hash huwa biss bħal encrypted
password bi ftit caveats.

389
00:19:46,560 --> 00:19:49,470
U għalhekk, dak li tara hawn huma
il-verżjonijiet encrypted ta 'kull sitt

390
00:19:49,470 --> 00:19:52,950
ta 'passwords tagħna minn problema
stabbiliti żewġ ta edizzjoni Hacker.

391
00:19:52,950 --> 00:19:56,500
Issa biex ix-xellug huwa biss xi għalf GUI,
editjar dan ringiela, ikkupjar dan ringiela,

392
00:19:56,500 --> 00:19:57,630
tħassar dan filliera.

393
00:19:57,630 --> 00:19:59,840
>> Imma x'hemm interessanti
issa huwa kif ġej.

394
00:19:59,840 --> 00:20:03,810
I tista 'tabilħaqq tibda
jesperimentaw bil din it-tabella.

395
00:20:03,810 --> 00:20:07,330
Mela jekk jien tmur u kklikkja l-SQL
tab, I nikseb dan kaxxa ta 'test big.

396
00:20:07,330 --> 00:20:10,190
U dan mhux kif aħna qed tmur biex
tagħmel dan meta attwalment tikteb kodiċi.

397
00:20:10,190 --> 00:20:12,700
Biex ikunu ċari, phpMyAdmin
huwa biss għodda li l-

398
00:20:12,700 --> 00:20:16,450
ser jgħidilna poke madwar id-database
u jgħidilna esperiment ma mistoqsijiet.

399
00:20:16,450 --> 00:20:19,430
>> Allura per eżempju, jissoponi
I tesegwixxi eżattament dan.

400
00:20:19,430 --> 00:20:22,820
Agħżel, li hija waħda minn dawk
keywords semmejt qabel, star,

401
00:20:22,820 --> 00:20:25,900
li jirrappreżenta kollha
l-kolonni tabella.

402
00:20:25,900 --> 00:20:26,820
Minn dak tabella?

403
00:20:26,820 --> 00:20:27,990
Ukoll, l-utenti.

404
00:20:27,990 --> 00:20:29,950
U avviż hemm dan
konvenzjoni stramb fil SQL

405
00:20:29,950 --> 00:20:32,140
fejn inti attwalment jużaw
lura qurdien, tipikament,

406
00:20:32,140 --> 00:20:35,940
kwotazzjonijiet ma uniku u kwotazzjonijiet ma doppja
meta tkellem dwar ismijiet tabelli,

407
00:20:35,940 --> 00:20:38,990
sabiex il-kwotazzjoni lura huwa l-ħaġa fuq il-
quċċata xellug tal-tastiera tiegħek aktar

408
00:20:38,990 --> 00:20:39,720
probabbli.

409
00:20:39,720 --> 00:20:41,850
>> So let me imorru quddiem issa
u biss leave li waħdu

410
00:20:41,850 --> 00:20:46,020
u iscroll isfel u kklikkja Mur, u aħna qed
attwalment għaddejjin biex tara l-istess ħaġa.

411
00:20:46,020 --> 00:20:52,410
Għadna kemm eżegwiti query SQL
qal tagħżel star kollox

412
00:20:52,410 --> 00:20:55,610
mit-tabella msejħa utenti, u
dak ikollok lura huwa dan.

413
00:20:55,610 --> 00:20:58,400
Fl-aħħarnett, aħna ser tkun tista '
jagħmlu l-istess ħaġa fil-kodiċi,

414
00:20:58,400 --> 00:21:02,109
iżda għal issa kollha jien ridt li
do kienet tara li fil-browser tiegħi.

415
00:21:02,109 --> 00:21:03,900
Well ejja nagħmlu xi ħaġa
ftit differenti.

416
00:21:03,900 --> 00:21:08,330
Let me jmorru lura għall-tab SQL,
u ejja biss jgħidu li dak li?

417
00:21:08,330 --> 00:21:11,520
Zamyla tilef kull tal tagħha
flus, u għalhekk huwa

418
00:21:11,520 --> 00:21:13,190
ħin għalina biex tħassar tagħha bħala utent.

419
00:21:13,190 --> 00:21:14,630
Hi tal m'għadhomx qtugħ fil.

420
00:21:14,630 --> 00:21:18,870
>> Hekk jien se ngħid tħassar from--
ukoll, iżommu kapitalizzazzjoni

421
00:21:18,870 --> 00:21:23,080
għall-konsistenza, iħassru
mill-utenti fejn.

422
00:21:23,080 --> 00:21:25,430
U hekk, nistgħu jkollhom dawn
predicates, jew dawn

423
00:21:25,430 --> 00:21:31,180
kwalifiki, fl-aħħar tal-istqarrija tiegħi
fejn u kif jista I ħassar Zamyla?

424
00:21:31,180 --> 00:21:34,190
Bl-isem Zamyla tagħha, sabiex il-
kolonna, wieħed mill-kolonni

425
00:21:34,190 --> 00:21:37,950
kien imsemmi, dan meta isem = "Zamyla".

426
00:21:37,950 --> 00:21:40,000
U hawn I użu doppju
kwotazzjonijiet jew kwotazzjonijiet uniku,

427
00:21:40,000 --> 00:21:42,958
inti tuża biss id-dahar qurdien meta
jitkellem dwar l-ismijiet, per eżempju,

428
00:21:42,958 --> 00:21:45,130
ta 'tabelli jew oqsma.

429
00:21:45,130 --> 00:21:47,440
U let me ikklikkja Mur hawn.

430
00:21:47,440 --> 00:21:50,400
U issa, il-paġna web huwa
tkun ftit uptight.

431
00:21:50,400 --> 00:21:53,620
>> Or, do int verament tixtieq li tesegwixxi tħassar
minn utenti fejn isem huwa ekwivalenti għal Zamyla?

432
00:21:53,620 --> 00:21:54,680
Iva.

433
00:21:54,680 --> 00:22:01,900
Allura issa, jekk immorru lura għall-mejda tiegħi
mill-utenti tikklikkja, avviż li Hm.

434
00:22:01,900 --> 00:22:02,530
I goofed.

435
00:22:02,530 --> 00:22:04,070
U fil-fatt, I tip ta '
għafast bogħod daqstant b'mod mgħaġġel

436
00:22:04,070 --> 00:22:06,195
inti lanqas biss tara l-
messaġġ ta 'żball aħmar, forsi.

437
00:22:06,195 --> 00:22:07,649
What did I do wrong?

438
00:22:07,649 --> 00:22:09,690
UDJENZA: Inti ma kellhomx bżonn
għall-kapitalizzazzjoni isem tagħha.

439
00:22:09,690 --> 00:22:11,260
DAVID J. Malan: Yeah I
kapitalizzat isem tagħha,

440
00:22:11,260 --> 00:22:13,770
iżda tagħha username-- attwalment I
għamel żbalji koppja, id-dritt?

441
00:22:13,770 --> 00:22:16,720
Waħda, username tagħha huwa
zamyla, Z zghar,

442
00:22:16,720 --> 00:22:20,140
u l-isem kolonna hija username,
mhux isem, hekk ejja tagħmel dan mill-ġdid.

443
00:22:20,140 --> 00:22:25,750
Let me imorru quddiem u
tħassar mill-utenti fejn

444
00:22:25,750 --> 00:22:28,990
username ugwali kwotazzjoni unquote "Zamyla".

445
00:22:28,990 --> 00:22:29,490
Kull dritt?

446
00:22:29,490 --> 00:22:32,600
Allura dan jistenna ftit aħjar, ejja
me go iscroll isfel u kklikkja Go.

447
00:22:32,600 --> 00:22:34,730
Huwa għadu għaddej biex
Yell fil lili li jkun żgur.

448
00:22:34,730 --> 00:22:37,500
I ikklikkja Iva, u issa naraw,
franchement dan ġara, verament

449
00:22:37,500 --> 00:22:39,870
fast, inqas minn wieħed
tieni ċertament, dan

450
00:22:39,870 --> 00:22:41,720
huwa eżattament l-mistoqsija li ltqajna esegwiti.

451
00:22:41,720 --> 00:22:45,617
Biex tikkonferma, let me ikklikkja utenti
u tabilħaqq issa Zamyla hija marret.

452
00:22:45,617 --> 00:22:46,700
Issa ejja tagħmel l-oppost.

453
00:22:46,700 --> 00:22:49,320
Ejja ngħidu li Gabe trid
jirreġistraw għall-websajt.

454
00:22:49,320 --> 00:22:52,825
X'hemm-mistoqsija SQL, x'inhu l-
kmand I tista tip li jżidu Gabe?

455
00:22:52,825 --> 00:22:54,200
Ukoll huwa pjuttost sempliċi.

456
00:22:54,200 --> 00:22:58,260
Daħħal in-utenti, u issa
jiġrilha ftit cryptic.

457
00:22:58,260 --> 00:23:03,190
I bżonn li jispeċifikaw, għall-server,
dak oqsma nixtieq li tassenja.

458
00:23:03,190 --> 00:23:06,630
I ma verament kura liema ID Gabe tal
numru huwa, hekk jien ser skip dan.

459
00:23:06,630 --> 00:23:11,360
Jien minflok se ngħid
username, hash, u mbagħad

460
00:23:11,360 --> 00:23:14,960
il-valuri Irrid li jpoġġu
hemm se tkun Gabe.

461
00:23:14,960 --> 00:23:16,800
U mbagħad hash tiegħu, I do not know.

462
00:23:16,800 --> 00:23:19,900
Allura għal issa, jien ser
leave li bħala kbar biex jagħmlu.

463
00:23:19,900 --> 00:23:21,650
Aħna ser jiġu lura
li fil-problema stabbilita

464
00:23:21,650 --> 00:23:23,390
spec kif inti fil-fatt tagħmel dan.

465
00:23:23,390 --> 00:23:24,630
>> Allura avviż, għal darb'oħra, il-sintassi.

466
00:23:24,630 --> 00:23:28,430
Daħħal in-isem tal-mejda, imbagħad
lista parenthesized 'l-oqsma,

467
00:23:28,430 --> 00:23:30,980
il-kolonni tixtieq iżżid
valuri għal, u allura biss

468
00:23:30,980 --> 00:23:34,495
l-istess tordna eżatt xellug biex
dritt tal-valuri li inti trid iżżid,

469
00:23:34,495 --> 00:23:36,870
u huwa biss tgeżwir minħabba
it-test huwa xi ftit twil.

470
00:23:36,870 --> 00:23:38,520
Allura issa let me ikklikkja Go.

471
00:23:38,520 --> 00:23:39,830
Wieħed ringiela mdaħħal.

472
00:23:39,830 --> 00:23:43,020
U issa jekk immur lura għall
utenti, x'hemm interessanti

473
00:23:43,020 --> 00:23:48,960
hija li mhux biss huwa Gabe issa fil-
database, dak li apparentament huwa ID tiegħu?

474
00:23:48,960 --> 00:23:49,820
>> Ukoll huwa sebgħa.

475
00:23:49,820 --> 00:23:51,479
Għaliex hi seba meta I ma żidux dan?

476
00:23:51,479 --> 00:23:54,020
Allura dan, wisq, huwa wieħed mill-
karatteristiċi ikollok tad-database.

477
00:23:54,020 --> 00:23:55,750
A lott ta 'mibnija fil-funzjonalità.

478
00:23:55,750 --> 00:23:57,950
Jirriżulta li meta
ħolqot din it-tabella,

479
00:23:57,950 --> 00:24:01,390
I preconfigured huwa awtomatikament
tassenja ID b'tali mod

480
00:24:01,390 --> 00:24:02,480
li inkrementi.

481
00:24:02,480 --> 00:24:05,470
Mela jekk inti stajt qatt poked madwar,
u ħares lejn Facebook ID dak tiegħek

482
00:24:05,470 --> 00:24:09,292
numru huwa, dawn il-jiem mhuwiex verament
ħaġa li tagħmel, imma Facebook bħala API,

483
00:24:09,292 --> 00:24:11,750
Programmazzjoni Applikazzjoni Interface,
fejn inti tista 'tikseb lura

484
00:24:11,750 --> 00:24:14,430
mazz sħiħ ta 'data dwar
yourself, dwar il-ħbieb tiegħek,

485
00:24:14,430 --> 00:24:15,347
u l-konnessjonijiet tiegħek.

486
00:24:15,347 --> 00:24:17,430
U dak użat biex jkun it-tip
ta 'kessaħ, lura fil-ġurnata,

487
00:24:17,430 --> 00:24:19,510
kien li tfittex up dak tiegħek
Numru ID Facebook kien.

488
00:24:19,510 --> 00:24:22,390
Mark Zuckerberg, il
per eżempju, huwa ta 'tliet

489
00:24:22,390 --> 00:24:23,890
peress li huwa kien l-awtur tas-sit.

490
00:24:23,890 --> 00:24:27,610
U kif l-istorja tmur, hu ħoloq
żewġ kontijiet tat-test, utent wieħed u żewġ,

491
00:24:27,610 --> 00:24:28,690
li huwa mbagħad mħassra.

492
00:24:28,690 --> 00:24:32,780
U għalhekk, ZUCK, kif username tiegħu
fuq Facebook, huwa numru ID tlieta,

493
00:24:32,780 --> 00:24:36,110
u lkoll jkollhom numri ferm
akbar minn tlett dawn il-jiem.

494
00:24:36,110 --> 00:24:37,980
Fil-fatt, f'xi punt
Facebook tbiegħdu

495
00:24:37,980 --> 00:24:42,410
minn anki bl-użu ta 'int, li
huwa valur 32-bit, għall-użu

496
00:24:42,410 --> 00:24:44,480
il-up-pass li jmiss,
essenzjalment twil twil hekk

497
00:24:44,480 --> 00:24:47,150
li dawn setgħu jakkomodaw
Saħansitra aktar utenti li jirreġistraw.

498
00:24:47,150 --> 00:24:49,420
Allura fatt storiku ftit gost.

499
00:24:49,420 --> 00:24:51,660
>> Allura dan huwa biss l-
sintassi bażika magħhom

500
00:24:51,660 --> 00:24:54,470
nistgħu tesegwixxi koppja ta '
mistoqsijiet, iżda nistgħu attwalment

501
00:24:54,470 --> 00:24:56,744
do mazz aktar affarijiet ma SQL.

502
00:24:56,744 --> 00:24:58,910
U tkun taf tara, finalment,
fil-problema stabbilita seba

503
00:24:58,910 --> 00:25:01,034
li inti għandek tagħmel
numru ta 'deċiżjonijiet tad-disinn,

504
00:25:01,034 --> 00:25:03,290
fosthom se tkun
liema tipi ta 'data jużaw.

505
00:25:03,290 --> 00:25:08,240
Hekk biss bħal fis-C, hemm dejta
tipi fil database, bħal MySQL,

506
00:25:08,240 --> 00:25:12,640
u t-tipi ta 'data inti għandek tagħżel
minn jinkludu dawn l-oqsma hawn.

507
00:25:12,640 --> 00:25:17,287
Char, varchar, Int, int big, deċimali
u d-data ħin, u ħafna oħrajn.

508
00:25:17,287 --> 00:25:18,370
Mela ejja fil-fatt jagħmlu dan.

509
00:25:18,370 --> 00:25:21,060
Ejja nippretendu li aħna ma
idejn inti tabella dan l-utent

510
00:25:21,060 --> 00:25:25,080
u let me imorru quddiem u joħolqu, għal
myself, fil-lekċers database--

511
00:25:25,080 --> 00:25:31,000
attwalment let me imorru quddiem u ħassar
-tabella I jkollhom fil hawn diġà

512
00:25:31,000 --> 00:25:32,940
sabiex inkunu nistgħu attwalment joħolqu din.

513
00:25:32,940 --> 00:25:33,550
Whoops.

514
00:25:33,550 --> 00:25:35,970
Jien ser qatra dan
mejda, u issa jien

515
00:25:35,970 --> 00:25:38,337
se jmorru mill-ġdid għall-
lecture database minn hawn,

516
00:25:38,337 --> 00:25:40,420
Jien ser tinħoloq tabella
imsejħa utenti U ejja

517
00:25:40,420 --> 00:25:43,010
biss tagħmel tliet kolonni
inizjalment u kklikkja Go.

518
00:25:43,010 --> 00:25:44,990
>> Issa, għall-parti l-kbira,
għal darb'oħra, dan huwa biss

519
00:25:44,990 --> 00:25:48,570
tuża din l-għodda grafika imsejħa
phpMyAdmin, u dak li aħna qed tagħmel issa

520
00:25:48,570 --> 00:25:49,600
huwa ħolqien ta 'tabella.

521
00:25:49,600 --> 00:25:53,170
Allura dan huwa simili File tmur, New,
u l-ħolqien ta 'fajl Excel ġdid.

522
00:25:53,170 --> 00:25:55,440
Allura huwa tistaqsi lili ftit
mistoqsijiet, mix-xellug għal-lemin,

523
00:25:55,440 --> 00:25:58,620
x'inhu l-isem tal-ewwel kolonna,
u mbagħad l-isem tat-tieni kolonna,

524
00:25:58,620 --> 00:25:59,560
u l-isem tat-tielet.

525
00:25:59,560 --> 00:26:00,518
Mela ejja jirrikreaw dan.

526
00:26:00,518 --> 00:26:05,460
ID, u mbagħad username kienet waħda,
u mbagħad hash kien ieħor.

527
00:26:05,460 --> 00:26:08,970
Allura dak li għandu l-tip ta 'data
tkun issa għal qasam bħal ID?

528
00:26:08,970 --> 00:26:14,470
>> Hawn hi l-lista sħiħa ta 'tipi ta' data
disponibbli lilek f'database,

529
00:26:14,470 --> 00:26:16,070
u għal issa ejja biss jmorru ma int.

530
00:26:16,070 --> 00:26:18,160
Valur 32-bit, I do not
think realistikament jien

531
00:26:18,160 --> 00:26:21,484
se jkollhom aktar minn 4 biljun
utenti fil-kont tiegħi, fis-servizz tiegħi,

532
00:26:21,484 --> 00:26:23,650
hekk jien ser iżommu jiċċaqilqu
fuq il-mistoqsija li jmiss.

533
00:26:23,650 --> 00:26:25,490
Jien ma jmur biex tispeċifika
tul jew il-valuri,

534
00:26:25,490 --> 00:26:28,540
mhuwiex applikabbli
hawn għal int, per se.

535
00:26:28,540 --> 00:26:30,740
U issa I tista 'tispeċifika,
apparentement, inadempjenza

536
00:26:30,740 --> 00:26:33,970
valur, li jien mhux ser jispeċifika.

537
00:26:33,970 --> 00:26:36,050
A kollazzjoni, I do not know dak li hu.

538
00:26:36,050 --> 00:26:37,290
Attribut.

539
00:26:37,290 --> 00:26:39,455
Issa aħna fil-fatt jagħmlu
jkollhom deċiżjoni disinn.

540
00:26:39,455 --> 00:26:42,580
Allura hemm xi oqsma ftit hawn, mhux kollha
li huma applikabbli, iżda mhux iffirmat

541
00:26:42,580 --> 00:26:43,380
ifisser biss dak?

542
00:26:43,380 --> 00:26:45,400
Li l-int trid tkun?

543
00:26:45,400 --> 00:26:46,210
Just mhux negattiv.

544
00:26:46,210 --> 00:26:48,090
Hekk għandu jkun 0 fuq up.

545
00:26:48,090 --> 00:26:51,120
Le, jien mhux ser jiċċekkja għaliex
Irrid kull utent li jkollu ID,

546
00:26:51,120 --> 00:26:52,470
ma jistax ikun null.

547
00:26:52,470 --> 00:26:55,949
U mbagħad, aħna nikseb xi aktar
deċiżjonijiet tad-disinn interessanti bħal dan.

548
00:26:55,949 --> 00:26:58,990
Aħna ser terga 'lura għal dan fil-mument,
imma dak karatteristika oħra ta 'database

549
00:26:58,990 --> 00:27:04,200
hija, hija li inti tista 'tgħid
l-server database jimxi 'l quddiem

550
00:27:04,200 --> 00:27:07,100
u jottimizzaw lilek innifsek, tiegħek
RAM u l-ispazju tiegħek hard disk,

551
00:27:07,100 --> 00:27:11,770
hekk li jagħżel, u inserts, u
tħassar, u l-aġġornamenti huma verament mgħaġġel.

552
00:27:11,770 --> 00:27:13,250
Dan il-kuntrast ma 'pset5.

553
00:27:13,250 --> 00:27:16,259
>> Jekk int riedu li tfittex up xi ħaġa
fit-tabella hash tiegħek, li

554
00:27:16,259 --> 00:27:18,300
taħseb tal bħala database,
li kellha tagħmel l-

555
00:27:18,300 --> 00:27:21,500
jaħdmu għat-teħid mejda hash tiegħek malajr.

556
00:27:21,500 --> 00:27:22,840
Huwa simili, ovvjament, inti.

557
00:27:22,840 --> 00:27:23,060
Dritt?

558
00:27:23,060 --> 00:27:26,080
Inti kellhom jitqiegħdu fil kollha-multa ħin
irfinar affarijiet, jkollna funzjoni hash

559
00:27:26,080 --> 00:27:27,820
dritt, jidhru kif
ħafna bramel li jkollhom.

560
00:27:27,820 --> 00:27:29,611
>> Imma x'hemm sbieħ, għal darb'oħra,
dwar database hija

561
00:27:29,611 --> 00:27:31,762
inti biss Punt kollha ta '
dan għal nies oħra

562
00:27:31,762 --> 00:27:33,720
li jkunu ħasbu li dan
permezz għalik, u liema

563
00:27:33,720 --> 00:27:37,170
Jien se ngħid hawnhekk taħt
indiċi huwa f'dak il-qasam ID tiegħi

564
00:27:37,170 --> 00:27:41,149
se tkun il-mezz primarju ta '
tidentifika l-utenti f'dan id-database.

565
00:27:41,149 --> 00:27:42,940
Jien ma jmur biex jaħsbu
ta Zamyla bħala Zamyla,

566
00:27:42,940 --> 00:27:45,800
Jien ser jaħseb ta '
tagħha bħala l-numru 6.

567
00:27:45,800 --> 00:27:49,814
>> Għaliex huwa, forsi, aħjar
intuwittivament biex jaħsbu u l-mudell

568
00:27:49,814 --> 00:27:52,480
kull wieħed mill ringieli individwali tiegħek billi tuża
numru minflok ta 'xi ħaġa

569
00:27:52,480 --> 00:27:56,480
bħal string, bħall-Zamyla
jew Gabe jew string itwal għadhom?

570
00:27:56,480 --> 00:27:57,444
Yeah?

571
00:27:57,444 --> 00:28:00,117
>> UDJENZA: An ID huwa uniku?

572
00:28:00,117 --> 00:28:01,200
DAVID J. Malan: Say mill-ġdid?

573
00:28:01,200 --> 00:28:02,283
UDJENZA: An ID huwa uniku?

574
00:28:02,283 --> 00:28:04,400
DAVID J. Malan: An ID
huwa uniku, iżda suppose--

575
00:28:04,400 --> 00:28:06,320
skond il-każ b'mod ġenerali
ma usernames, jissoponi

576
00:28:06,320 --> 00:28:10,110
I qal ukoll jista 'jkun hemm biss wieħed
Zamyla fid-dinja, u Gabe wieħed biss.

577
00:28:10,110 --> 00:28:13,730
I jistgħu jimponu l-uniċità
restrizzjoni fuq kordi, wisq, jekk jien ridt.

578
00:28:13,730 --> 00:28:15,550
Allura mhux maħsub ħażin.

579
00:28:15,550 --> 00:28:16,500
>> UDJENZA: Aktar sigura.

580
00:28:16,500 --> 00:28:17,874
>> DAVID J. Malan: Aktar sigura, għaliex?

581
00:28:17,874 --> 00:28:20,705
UDJENZA: Inti ma tistax tgħid li
huwa li, bħal fil-utent.

582
00:28:20,705 --> 00:28:22,580
DAVID J. Malan: OK, inti
ma tistax tgħid li l-utent

583
00:28:22,580 --> 00:28:24,380
huwa li hekk hemm
aspett privatezza lilha,

584
00:28:24,380 --> 00:28:27,810
speċjalment jekk l-IDs forsi
jidhru fil-URLs.

585
00:28:27,810 --> 00:28:29,960
Hekk żgur, li jista tip ta 'xogħol, wisq.

586
00:28:29,960 --> 00:28:30,640
Ħsibijiet oħra?

587
00:28:30,640 --> 00:28:31,383
Yeah?

588
00:28:31,383 --> 00:28:34,316
>> UDJENZA: Huwa aktar faċli biex
iwettqu operazzjonijiet fuq int.

589
00:28:34,316 --> 00:28:35,940
DAVID J. Malan: Dik hija l-kicker reali.

590
00:28:35,940 --> 00:28:38,850
Huwa biss aktar effiċjenti,
jew aktar faċli għall-kompjuter,

591
00:28:38,850 --> 00:28:40,431
biex iwettqu ħidmiet fuq integer.

592
00:28:40,431 --> 00:28:40,930
Dritt?

593
00:28:40,930 --> 00:28:43,905
An int huwa garantit
jkun 32-bit, billi Zamyla

594
00:28:43,905 --> 00:28:47,660
huwa ftit karattri twil, Gabriel
huwa ftit aktar karattri fit-tul,

595
00:28:47,660 --> 00:28:51,930
Davenport huwa verament twila, u għalhekk huwa
mhux partikolarment effiċjenti għall-użu

596
00:28:51,930 --> 00:28:55,860
kordi li jqabblu valuri u ħarsa
għall-oqsma, u jaġġorna l-oqsma,

597
00:28:55,860 --> 00:28:57,790
jekk inti tista 'tikseb bogħod
b'sett wieħed biss numru sħiħ.

598
00:28:57,790 --> 00:28:59,090
Just 32 bits.

599
00:28:59,090 --> 00:29:02,570
Allura usernames, wisq, dan il-mod,
ma għandekx tkun unika,

600
00:29:02,570 --> 00:29:05,040
għalkemm probabbilment għandhom
jkun, u anke f'dan il-mod wisq

601
00:29:05,040 --> 00:29:07,520
utent jistgħu jitħallew
tibdel username tiegħu jew tagħha.

602
00:29:07,520 --> 00:29:10,810
>> Mela ejja issa jħallu dan bħala l-
mezz primarju ta 'identifikazzjoni tal-utent.

603
00:29:10,810 --> 00:29:13,510
Dan huwa javżak-database
imorru quddiem u jottimizzaw yourself

604
00:29:13,510 --> 00:29:17,065
hekk li tfittex ups fuq ID huma super fast.

605
00:29:17,065 --> 00:29:19,620
AI, horribly jismu, biss
ifisser Auto Żieda,

606
00:29:19,620 --> 00:29:21,500
u dan huwa l-kontroll
kaxxa għandna bżonn li jiċċekkja

607
00:29:21,500 --> 00:29:24,614
biex jispeċifika li l-qasam identità biex
jiġu aġġornati awtomatikament għalija,

608
00:29:24,614 --> 00:29:26,530
u mbagħad jien ser
iscroll lejn il-lemin hawn

609
00:29:26,530 --> 00:29:29,279
u franchement jien ma verament interessati
fi kwalunkwe aktar ta 'dawn l-oqsma.

610
00:29:29,279 --> 00:29:30,630
Ċertament mhux illum.

611
00:29:30,630 --> 00:29:33,770
>> Hekk jien se jmorru lura hawn,
l-ewwel kolonna, fejn

612
00:29:33,770 --> 00:29:35,830
I bżonn li jispeċifikaw username
u hash, u ejja

613
00:29:35,830 --> 00:29:38,080
inqas enfasi fuq il-
tieni wieħed għal issa.

614
00:29:38,080 --> 00:29:41,498
Int probabbilment ma jkunx l-sejħa dritt,
Allura dak li jagħmel aktar sens forsi?

615
00:29:41,498 --> 00:29:42,741
>> UDJENZA: Test.

616
00:29:42,741 --> 00:29:43,824
DAVID J. Malan: Say mill-ġdid?

617
00:29:43,824 --> 00:29:44,710
UDJENZA: Test.

618
00:29:44,710 --> 00:29:44,980
DAVID J. Malan: Test?

619
00:29:44,980 --> 00:29:45,590
OK, I smajt test.

620
00:29:45,590 --> 00:29:46,090
X'iktar?

621
00:29:46,090 --> 00:29:50,520

622
00:29:50,520 --> 00:29:53,860
Aħna tip ta 'jkollhom mazz ta' għażliet
li huma testwali fin-natura.

623
00:29:53,860 --> 00:29:55,990
Allura meta, u għaliex, do
tuża xi wħud minn dawn?

624
00:29:55,990 --> 00:29:59,560
Ukoll char, kuntrarjament għal dak li inti tista '
think, mhuwiex karattru wieħed.

625
00:29:59,560 --> 00:30:01,550
Huwa numru speċifiku ta 'karattri.

626
00:30:01,550 --> 00:30:04,600
Hekk jekk nafu li usernames kollha
għandu jkun simili tmien karattri,

627
00:30:04,600 --> 00:30:08,490
kif użati biex tkun komuni fl-anzjani
sistemi tal-kompjuter, nista 'ngħid char

628
00:30:08,490 --> 00:30:09,830
u mbagħad nista 'ngħid 8 hawn.

629
00:30:09,830 --> 00:30:12,930
Li meta t-tielet kolonna isir
applikabbli meta jinħoloq tabella.

630
00:30:12,930 --> 00:30:15,450
>> Imma dak li tip ta 'annoying
minħabba li xi nies jistgħu

631
00:30:15,450 --> 00:30:17,660
tixtieq li jkollok username itwal
minn tmien karattri,

632
00:30:17,660 --> 00:30:19,743
xi nies tista 'tixtieq li
jkollhom username iqsar,

633
00:30:19,743 --> 00:30:22,210
hekk għaliex jimpenjaw myself
għal numru speċifiku?

634
00:30:22,210 --> 00:30:24,710
Għaliex ma jkollhom varjabbli
numru ta 'Chars u biss

635
00:30:24,710 --> 00:30:28,580
jgħidu li t-tul massimu ta 'isem
huwa, I do not know, bħal 64 karattri.

636
00:30:28,580 --> 00:30:31,780
I can not think ta 'xi ħbieb li
għandhom ismijiet itwal minn 64 karattri,

637
00:30:31,780 --> 00:30:34,810
u anki jekk dan huwa qasir wisq inti tista
ċertament bump up arbitrarju.

638
00:30:34,810 --> 00:30:37,330
>> Allura varchar hija varjabbli
numru ta 'Chars.

639
00:30:37,330 --> 00:30:41,010
Test mhix istint ħażin, u
franchement dik it-tip ta 'ma dak li jgħid,

640
00:30:41,010 --> 00:30:45,460
iżda qasam tat-test jista 'jkun
bħall 65,000 bytes mill-inqas.

641
00:30:45,460 --> 00:30:50,790
Li probabbilment overkill għal
qasam, u fil-fatt, Yup, 65535.

642
00:30:50,790 --> 00:30:53,740
Li probabbilment overkill għal
isem, hekk aħna ser twaħħal, tipikament,

643
00:30:53,740 --> 00:30:56,910
ma varchars għall testwali
qasam u hash, wisq.

644
00:30:56,910 --> 00:30:59,990
Hash, jirriżulta, stajna nagħmlu a
varchar kif ukoll jew xi ħaġa bħal dik,

645
00:30:59,990 --> 00:31:03,080
iżda aħna mhux se jiffoka llum fuq il-
kriptografija hemm u n-numri

646
00:31:03,080 --> 00:31:05,210
li aħna tista 'attwalment
tixtieq li tuża għat-tul tagħha.

647
00:31:05,210 --> 00:31:07,430
>> Iżda let me iscroll lejn il-lemin.

648
00:31:07,430 --> 00:31:11,280
Inti tista 'biss ikollha waħda
indiċi primarja għal tabella,

649
00:31:11,280 --> 00:31:16,380
imma ma nixtieq li tapplika kwalunkwe minn dawn,
issa, biex username, kieku inti tgħid?

650
00:31:16,380 --> 00:31:21,980
X'għandu username tkun ibbażata fuq vaga
fehim ta 'dawn l-erba' għażliet?

651
00:31:21,980 --> 00:31:23,340
Just billi l-ismijiet tagħhom?

652
00:31:23,340 --> 00:31:24,140
>> UDJENZA: Unique.

653
00:31:24,140 --> 00:31:25,100
>> DAVID J. Malan: Allura uniku, id-dritt?

654
00:31:25,100 --> 00:31:28,190
Għalhekk jirriżulta li mhux biss tista '
inti tgħid database, bil-quddiem,

655
00:31:28,190 --> 00:31:30,380
dan huwa l-mezz primarju
jidentifika oqsma.

656
00:31:30,380 --> 00:31:32,990
Tista 'wkoll tgħid li dan huwa
se jkunu qasam uniku.

657
00:31:32,990 --> 00:31:34,700
Huwa mhux se tkun
il-ħaġa I jiddependu fuq,

658
00:31:34,700 --> 00:31:38,490
imma nixtieq-database li
essenzjalment ikollhom li jekk il-kundizzjoni, hekk

659
00:31:38,490 --> 00:31:42,340
li jekk jien qatt ppruvaw li jirreġistraw
żewġ utenti bl-istess isem,

660
00:31:42,340 --> 00:31:44,360
database qatigħ
mhux se let me.

661
00:31:44,360 --> 00:31:47,490
I jista 'jkollhom xi kodiċi addizzjonali
fil-PHP li jipprevjeni kemm,

662
00:31:47,490 --> 00:31:50,640
iżda l-database, wisq, tista 'tiżgura
li dan qatt ma jiġri.

663
00:31:50,640 --> 00:31:53,370
>> Issa, bħala twarrib, speċjalment fir-
taħseb dwar proġetti finali,

664
00:31:53,370 --> 00:31:57,030
iżomm indiċi moħħ u sħiħa
test huma attwalment pjuttost utli.

665
00:31:57,030 --> 00:32:01,080
Jekk ikollok xi database akbar, mhux ma
għexieren, iżda ma 'mijiet jew eluf

666
00:32:01,080 --> 00:32:05,270
jew saħansitra miljuni ta 'oqsma, inti tista
ukoll tgħid il-database bil-quddiem

667
00:32:05,270 --> 00:32:07,980
dan huwa qasam jien ser
li tkun tiftix fuq lott.

668
00:32:07,980 --> 00:32:10,520
Forsi username tagħha,
forsi huwa bijo, jekk int

669
00:32:10,520 --> 00:32:13,750
teħid ta 'websajt Facebook simili li
għandha paragrafi li l-utent tal-permessi

670
00:32:13,750 --> 00:32:16,799
biex jiffrankaw, u jekk inti tixtieq li
tell-database bil-quddiem

671
00:32:16,799 --> 00:32:20,090
Jien ser tkun tiftix fuq il-qasam
ħafna, iżda mhux neċessarjament uniku,

672
00:32:20,090 --> 00:32:22,800
inti tista 'tispeċifika toħloq me indiċi.

673
00:32:22,800 --> 00:32:27,990
Or, inti tista 'tgħid ukoll ippermettuli li tagħmel
tip ta 'tfittxijiet arbitrarji bħall Kmand

674
00:32:27,990 --> 00:32:30,420
jew Control F, bħalek
jista fil-Word Processor,

675
00:32:30,420 --> 00:32:34,184
sabiex inti tista 'tfittex kordi arbitrarji
jew substrings f'dan il-qasam.

676
00:32:34,184 --> 00:32:36,600
Fi kliem ieħor, aħna qed jkollna
sal-punt fil-semestru

677
00:32:36,600 --> 00:32:40,720
fejn inti ma għandekx għalfejn tinkwieta dwar
kif jimplimentaw l-affarijiet b'mod effiċjenti.

678
00:32:40,720 --> 00:32:44,540
Inti biss bżonn tkun taf dwar liema
deċiżjonijiet tad-disinn biex tagħmel hekk li int

679
00:32:44,540 --> 00:32:48,470
jużaw l-għodod adattati għall-
kummerċ sabiex lieva karatteristiċi

680
00:32:48,470 --> 00:32:50,380
li nies oħra bnew għalik.

681
00:32:50,380 --> 00:32:54,240
Allura biex terġa, primarji għandhom biss
jkollhom waħda, inti tista 'biss għandek wieħed,

682
00:32:54,240 --> 00:32:59,630
u huwa l-ħaġa int tikkommetti
jużaw biex jidentifika oqsma unikament.

683
00:32:59,630 --> 00:33:02,710
Unique huwa biss simili fl-ispirtu, imma
inti tista 'biss okkażjonalment jużaha,

684
00:33:02,710 --> 00:33:04,530
imma inti tixtieq-database li timponih.

685
00:33:04,530 --> 00:33:08,050
Indiċi ifisser biss preemptively
tħaffef affarijiet up fil-futur

686
00:33:08,050 --> 00:33:10,230
hekk li I tista 'tfittex għal
affarijiet f'dan il-qasam.

687
00:33:10,230 --> 00:33:13,700
U allura test sħiħ huwa ġeneralment għal
paragrafi, jew esejs, jew korpi kbar

688
00:33:13,700 --> 00:33:16,270
ta 'test fejn inti
tista 'ukoll tixtieq li jkollok

689
00:33:16,270 --> 00:33:19,420
karti selvaġġi bħall-ekwivalenti ta 'stilla.

690
00:33:19,420 --> 00:33:19,920
Dritt.

691
00:33:19,920 --> 00:33:22,580
>> Allura li kien tip ta '
ħafna li kollha f'daqqa.

692
00:33:22,580 --> 00:33:25,220
Ejja naraw jekk aħna ma tistax jiddistillaw
koppja ta 'dawn il-karatteristiċi

693
00:33:25,220 --> 00:33:29,540
u mbagħad jibnu xi ħaġa
pjuttost sempliċi, imma qawwija.

694
00:33:29,540 --> 00:33:31,380
Allura fost l-oħrajn
deċiżjonijiet tad-disinn int

695
00:33:31,380 --> 00:33:34,005
finalment ser ikollhom hu flimkien
il-linji ta 'magni ta' ħażna.

696
00:33:34,005 --> 00:33:37,370
U let me biss tagħmel referenza ta 'din
fl-antiċipazzjoni ta 'proġetti finali,

697
00:33:37,370 --> 00:33:42,020
u l-antiċipazzjoni tal ejja
say-- ebda ejja tagħmel dan.

698
00:33:42,020 --> 00:33:43,820
Ejjew nibnu dan ftit
ewwel applikazzjoni.

699
00:33:43,820 --> 00:33:48,070
Jien se jmorru fil terminali tiegħi
tieqa, u hawnhekk mhix

700
00:33:48,070 --> 00:33:52,500
biss counter.php, li aħna issa qed tmur
biex jeħles mill bħala li m'għadhomx germane,

701
00:33:52,500 --> 00:33:54,570
iżda aħna għandna mazz sħiħ
ta 'direttorji u dan

702
00:33:54,570 --> 00:33:58,080
se tkun simili ħafna fl-ispirtu
li dak li inti ser tara fil-problema sett sebgħa.

703
00:33:58,080 --> 00:34:00,980
>> Allura għandna tliet direttorji
jinkludi pubblika u templates, li

704
00:34:00,980 --> 00:34:05,040
huwa eżattament fejn aħna jitħalla 'off fuq
It-tnejn ma 'paradigma tagħna MVC kollu.

705
00:34:05,040 --> 00:34:09,290
U biex terġa, fil-pubbliku se jmorru
kwalunkwe fajl li nixtieq utenti li attwalment

706
00:34:09,290 --> 00:34:12,969
v tkun kapaċi li jżuru fil
browser tagħhom permezz URL.

707
00:34:12,969 --> 00:34:13,502
Template.

708
00:34:13,502 --> 00:34:14,710
What did nitfgħu fl templates?

709
00:34:14,710 --> 00:34:17,070
Liema tip ta 'għalf?

710
00:34:17,070 --> 00:34:21,659
Ma kienx hemm ħafna iżda ftit
fajls Tnejn.

711
00:34:21,659 --> 00:34:22,619
Yeah.

712
00:34:22,619 --> 00:34:23,100
>> UDJENZA: Header u Footer?

713
00:34:23,100 --> 00:34:24,516
>> DAVID J. Malan: Header u Footer.

714
00:34:24,516 --> 00:34:26,679
Allura aħna għandna xi ħaġa llum simili, wisq.

715
00:34:26,679 --> 00:34:30,330
Imxejna ltqajna ftit fajls aktar iżda
Footer nara, Header nara,

716
00:34:30,330 --> 00:34:31,909
u mbagħad mazz ta 'fajls oħra.

717
00:34:31,909 --> 00:34:35,482
Allura dan huwa l-ekwivalenti
tal-fehma V MVC, li,

718
00:34:35,482 --> 00:34:37,690
għal darb'oħra, se jkun xi ftit aktar
ċar il-problema stabbiliti seba,

719
00:34:37,690 --> 00:34:40,380
iżda din hija biss folder jien
tqegħid ħafna estetika tiegħi.

720
00:34:40,380 --> 00:34:42,840
A lott ta 'HTML tiegħi, lott ta' forom tiegħi.

721
00:34:42,840 --> 00:34:46,899
Sadanittant, jinkludi, hija ieħor
direttorju li għandha dawn it-tliet fajls

722
00:34:46,899 --> 00:34:48,440
u ejja tagħti ħarsa lejn dawn.

723
00:34:48,440 --> 00:34:51,699
>> Jien ser jimxi 'l quddiem
u jiftħu config.php.

724
00:34:51,699 --> 00:34:54,610
Kif jirriżulta, ħafna
bħall kmieni fit-terminu,

725
00:34:54,610 --> 00:34:57,850
inti qawwija inklużi
CS50 dot h bil pset7.

726
00:34:57,850 --> 00:35:00,780
Fl-eżempju tal-lum, int ser
biex jagħmlu l-ekwivalenti ta 'dak

727
00:35:00,780 --> 00:35:03,600
bi stqarrija jeħtieġu
li effettivament

728
00:35:03,600 --> 00:35:05,340
jinkludi dawn diversi linji.

729
00:35:05,340 --> 00:35:08,225
Allura biex tkun ċara, dan huwa
fajl imsejjaħ config.php.

730
00:35:08,225 --> 00:35:09,350
U avviż dak li qed jagħmel.

731
00:35:09,350 --> 00:35:11,970
Huwa apparentement tagħmel xi ħaġa
cryptic, tidwir fuq messaġġi ta 'żball

732
00:35:11,970 --> 00:35:13,680
sabiex inti tista 'tara minnhom fil-browser.

733
00:35:13,680 --> 00:35:15,860
Huwa, imbagħad, apparentement
jeħtieġu żewġ fajls oħra

734
00:35:15,860 --> 00:35:19,530
għalhekk dan huwa simili #include fis-C,
u allura dan wieħed aħna ma tara,

735
00:35:19,530 --> 00:35:22,720
u konna invokati, din tiddependi fuq
li shopping cart bħal funzjonalità.

736
00:35:22,720 --> 00:35:25,610
>> Dan ifisser cookie rieda
jintbagħtu quddiem u lura.

737
00:35:25,610 --> 00:35:27,290
Allura għaliex dan huwa interessanti?

738
00:35:27,290 --> 00:35:32,460
Ukoll, jekk immorru lura għal dan
direttorju u jiftħu, per eżempju,

739
00:35:32,460 --> 00:35:33,741
constance.php.

740
00:35:33,741 --> 00:35:38,840
Avviż li PHP ma kostanti ta 'appoġġ,
mhuwiex pjuttost simili #define fil C.

741
00:35:38,840 --> 00:35:41,290
Minflok, inti litteralment
jgħidu definit, u avviż

742
00:35:41,290 --> 00:35:44,110
li stajt maħżuna bil-quddiem
erba kostanti f'dan il-fajl.

743
00:35:44,110 --> 00:35:47,020
Waħda għal database tal-lum, għal
password tiegħi, għal username tiegħi,

744
00:35:47,020 --> 00:35:48,690
u għall-isem tas-server.

745
00:35:48,690 --> 00:35:51,644
Allura dawn huma fil-fatt se tkun
pjuttost simili fil-problema sett sebgħa.

746
00:35:51,644 --> 00:35:54,560
U fl-aħħarnett, u dan huwa fejn jien
se tikseb xi funzjonalità sbieħ

747
00:35:54,560 --> 00:35:59,000
mill-persunal, fl functions.php
huwa mazz ta 'kodiċi konna bil-miktub,

748
00:35:59,000 --> 00:36:01,040
u I seraq xi ftit minn dan
minn problema stabbiliti seba

749
00:36:01,040 --> 00:36:05,920
għal-lum, li ma mazz ta 'affarijiet
u ejja biss ħarsa lejn waħda minnhom

750
00:36:05,920 --> 00:36:07,270
b'mod partikolari.

751
00:36:07,270 --> 00:36:09,720
Din il-funzjoni hawn,
query, se tkun

752
00:36:09,720 --> 00:36:13,600
il-funzjoni PHP nitolbu
sabiex tesegwixxi SQL.

753
00:36:13,600 --> 00:36:16,070
A mument ilu konna jużaw
phpMyAdmin, iżda li biss

754
00:36:16,070 --> 00:36:18,720
għal tip ta 'skopijiet ta' tagħlim
u skopijiet dijanjostiċi

755
00:36:18,720 --> 00:36:20,494
u jinsa sett database tiegħek.

756
00:36:20,494 --> 00:36:22,660
Meta inti attwalment jużaw tiegħek
database, inti, il-bniedem,

757
00:36:22,660 --> 00:36:24,100
huma ovvjament mhux se
li għandha ġbid up a web

758
00:36:24,100 --> 00:36:25,740
paġna kull darba li xi ħadd reġistri.

759
00:36:25,740 --> 00:36:29,870
Int ser jikteb il-kodiċi li
inserzjonijiet u tħassar utenti fuq talba,

760
00:36:29,870 --> 00:36:32,490
u aħna qed tmur biex tagħmel dan
permezz tal-funzjoni query.

761
00:36:32,490 --> 00:36:35,360
Jekk I issa iscroll, hemm
se jkun ftit aktar karatteristiċi.

762
00:36:35,360 --> 00:36:37,170
Idawwru se
tkun funzjoni we kiteb

763
00:36:37,170 --> 00:36:40,160
għall ninformak li tippermetti li inti
jibagħtu lill-utent biex URL ieħor,

764
00:36:40,160 --> 00:36:43,780
u jirrendi hija funzjoni, pjuttost simili
rajna nhar it-Tnejn, li attwalment jirrendi

765
00:36:43,780 --> 00:36:48,000
template, iżda aktar fuq dawn fil-
forma ta 'mixja stess pset7 permezz.

766
00:36:48,000 --> 00:36:50,500
Għal issa, ejja imorru quddiem u tagħmel dan.

767
00:36:50,500 --> 00:36:54,860
>> Let me go fis mejda lectures tiegħi u
tara li bħalissa hemm xejn

768
00:36:54,860 --> 00:36:59,640
hawn biss għadhom, u let me wkoll tmur
fis f'direttorju pubbliku tiegħi, fejn

769
00:36:59,640 --> 00:37:02,780
hemm waħda biss fajl, index.php.

770
00:37:02,780 --> 00:37:06,920
Dan il-fajl jidher li sempliċi super
fil-mument, jidher biss bħal din.

771
00:37:06,920 --> 00:37:09,110
Simili ħafna kif aħna
jitħalla 'off nhar it-Tnejn.

772
00:37:09,110 --> 00:37:11,945
Jien jeħtieġu dan il-fajl,
config.php, li hija fil-

773
00:37:11,945 --> 00:37:15,160
l tinkludi direttorju, li
huwa dot dot, ġenituri tiegħi,

774
00:37:15,160 --> 00:37:17,650
u mbagħad huwa biss tirrendi dan il-fajl.

775
00:37:17,650 --> 00:37:18,960
Allura dak li huwa dan il-fajl?

776
00:37:18,960 --> 00:37:24,700
>> Ejja jiftħu fl tiegħi templates
form.php, u aħna ser tara dan.

777
00:37:24,700 --> 00:37:28,500
Super sempliċi, apparentement dan il-formola hija
se jissottomettu minn $ _GET jew $ _POST.

778
00:37:28,500 --> 00:37:29,320
Verifika sanità malajr.

779
00:37:29,320 --> 00:37:33,760

780
00:37:33,760 --> 00:37:35,690
Litteralment viżwalment tfittex il-fajl.

781
00:37:35,690 --> 00:37:36,610
Metodu ugwali post.

782
00:37:36,610 --> 00:37:39,280
Allura huwa mhux ser tuża l-URL, bħal
Google ma, li għaddej biex issolvi ta hide

783
00:37:39,280 --> 00:37:41,030
l-informazzjoni wara
l-kwinti u huwa

784
00:37:41,030 --> 00:37:43,580
se jissottomettu lil
fajl imsejħa register.php,

785
00:37:43,580 --> 00:37:45,660
u dak l-fajl
aħna għadhom ma miktub

786
00:37:45,660 --> 00:37:47,610
iżda dak li dan qed jiġri
lill-dehra huwa dan.

787
00:37:47,610 --> 00:37:52,670
>> Jekk immur għal paġna separata Dan huwa
dak localhost / index.php Dehra.

788
00:37:52,670 --> 00:37:56,930
U għal darb'oħra, il-server
biss jekk wieħed jassumi index.php.

789
00:37:56,930 --> 00:37:57,910
Ikteb.

790
00:37:57,910 --> 00:37:59,870
Allura dak fejn aħna qed
fil, u dak I trid tagħmel

791
00:37:59,870 --> 00:38:02,450
huwa jkun kapaċi affarijiet tip
bħal David, u mbagħad

792
00:38:02,450 --> 00:38:08,050
numru tat-telefon tiegħi, li se ngħid
617-555-1212 għal issa, reġistru

793
00:38:08,050 --> 00:38:09,910
u issa register.php ma nstabx.

794
00:38:09,910 --> 00:38:11,440
So I ħtieġa li jimplimentaw dan.

795
00:38:11,440 --> 00:38:13,320
Mela ejja malajr Whip
xi ħaġa bħal dan up.

796
00:38:13,320 --> 00:38:18,640
Let me go fis direttorju pubbliku tiegħi
u jagħmlu gedit ta register.php,

797
00:38:18,640 --> 00:38:22,300
u issa jien ser jimxi 'l quddiem u
tibda modalità PHP, bħal għamilna nhar it-Tnejn,

798
00:38:22,300 --> 00:38:25,430
u tag PHP qrib, u
Ejja nagħmlu ftit affarijiet.

799
00:38:25,430 --> 00:38:28,336
>> Allura wieħed, I know, mill-
wara li bil-miktub li forma,

800
00:38:28,336 --> 00:38:29,960
li nixtieq li jiċċekkja għal dan li ġej.

801
00:38:29,960 --> 00:38:35,670
Jekk huwa vojt, ikun x'ikun l-utent
ittajpjat fil lill-qasam isem, imbagħad

802
00:38:35,670 --> 00:38:39,860
Jien se ngħid xi ħaġa
bħal Ruhna nieqsa isem.

803
00:38:39,860 --> 00:38:42,380
Ruhna, sadanittant, hija
mhux mibnija ħaġa PHP,

804
00:38:42,380 --> 00:38:45,970
huwa funzjoni we kiteb
fil functions.php għall pset7

805
00:38:45,970 --> 00:38:47,940
sabiex ikollok aċċess għaliha.

806
00:38:47,940 --> 00:38:53,830
Else jekk il-qasam ieħor
tkun vojta, numru, allura jien

807
00:38:53,830 --> 00:38:58,370
ser ruhna għall-
utent u jgħidu numru nieqsa.

808
00:38:58,370 --> 00:38:59,320
Jiffranka dan il-fajl.

809
00:38:59,320 --> 00:39:02,640
>> Issa ejja mur lura lill-browser tiegħi,
mur lura għall-forum erġa 'pprova.

810
00:39:02,640 --> 00:39:04,070
Reġistru.

811
00:39:04,070 --> 00:39:05,090
OK.

812
00:39:05,090 --> 00:39:06,730
Ma ġara xejn, li hija tajba.

813
00:39:06,730 --> 00:39:08,120
I ma jiksbu messaġġ ta 'żball.

814
00:39:08,120 --> 00:39:11,651
Iżda jekk minflok, ejja rikarigu dan
paġna, u ma jipprovdux xejn.

815
00:39:11,651 --> 00:39:12,150
Kkritikat dan.

816
00:39:12,150 --> 00:39:15,350

817
00:39:15,350 --> 00:39:17,140
Tagħmel dan.

818
00:39:17,140 --> 00:39:18,810
Reġistru.

819
00:39:18,810 --> 00:39:20,350
What did I do wrong?

820
00:39:20,350 --> 00:39:24,860
Jekk vojta, isem $ _POST.

821
00:39:24,860 --> 00:39:26,350
Say mill-ġdid?

822
00:39:26,350 --> 00:39:27,670
>> Oh, tal-kors.

823
00:39:27,670 --> 00:39:30,919
I nesa l-aktar parti importanti, li
huwa jeħtieġu ("../ jinkludi / config.php.").

824
00:39:30,919 --> 00:39:34,210

825
00:39:34,210 --> 00:39:36,460
I-ħtieġa li jkollhom aċċess għall-
ruhna funzjoni, li

826
00:39:36,460 --> 00:39:37,770
huwa għaliex xejn li kien qed jiġri.

827
00:39:37,770 --> 00:39:39,460
Il-funzjoni ma jeżistu attwalment.

828
00:39:39,460 --> 00:39:40,640
Mela ejja tipprova dan mill-ġdid.

829
00:39:40,640 --> 00:39:42,350
Ejja rikarigu-paġna, ikklikkja Reġistru.

830
00:39:42,350 --> 00:39:43,060
OK.

831
00:39:43,060 --> 00:39:43,770
Hemm hu.

832
00:39:43,770 --> 00:39:45,700
Allura, l-output aħna qed
jaraw hawnhekk hija r-riżultat

833
00:39:45,700 --> 00:39:47,685
ta 'sejħa għal ruhna
funzjoni, sempliċi super,

834
00:39:47,685 --> 00:39:50,060
u hija biss prints out x'ikun
I tagħtiha bħala argument.

835
00:39:50,060 --> 00:39:51,370
>> Kull dritt, hekk ejja jikkooperaw.

836
00:39:51,370 --> 00:39:54,240
Ejja jipprovdu l-isem tiegħi
bħal David, reġistru,

837
00:39:54,240 --> 00:39:56,890
nieqsa numru OK li let
jipprovdu li, wisq.

838
00:39:56,890 --> 00:39:58,650
617-555-1212.

839
00:39:58,650 --> 00:39:59,250
Reġistru.

840
00:39:59,250 --> 00:39:59,750
OK.

841
00:39:59,750 --> 00:40:02,760
Allura kollox huwa tajjeb issa, biss xejn
interessanti li qed jiġri.

842
00:40:02,760 --> 00:40:06,000
Allura issa ejja jagħmlu xi ħaġa aktar
interessanti jiġri bħal dan.

843
00:40:06,000 --> 00:40:09,980
Let me go fis phpMyAdmin, u ejja
attwalment joħolqu tabella msejħa utenti,

844
00:40:09,980 --> 00:40:12,330
Jien ser tagħtiha tlieta
kolonni, u jien ser malajr

845
00:40:12,330 --> 00:40:16,250
joħolqu ID, u mbagħad
isem, u mbagħad numru,

846
00:40:16,250 --> 00:40:18,832
u l-qasam ID jien
ser jitilqu bħala int.

847
00:40:18,832 --> 00:40:20,790
Il-qasam isem jien ser
li jħallu bħala varchar,

848
00:40:20,790 --> 00:40:23,257
u aħna ser ngħidu 64, kemmxejn arbitrarju.

849
00:40:23,257 --> 00:40:25,090
In-numru Jien ser
biex tagħmel, inti taf liema?

850
00:40:25,090 --> 00:40:27,350
Aħna qed tmur fis
appoġġ numri Amerikani hawn,

851
00:40:27,350 --> 00:40:31,510
hekk jien se jagħmlu xi ħaġa
bħall char u mbagħad 10 karattri

852
00:40:31,510 --> 00:40:34,540
max għal kodiċi taż-żona
u mbagħad seba numri.

853
00:40:34,540 --> 00:40:37,870
U mbagħad minn hawn, jien ser
tispeċifika inkrement auto f'dan il-qasam,

854
00:40:37,870 --> 00:40:40,550
jagħmlu dan kodiċi primarju, u
Jien ser jimxi 'l quddiem u mhux

855
00:40:40,550 --> 00:40:42,240
check kwalunkwe minn dawn il-kaxxi l-oħra.

856
00:40:42,240 --> 00:40:48,030
>> Allura meta I issa finalment ikklikkja Save,
u mmur lura għall-utenti tiegħi,

857
00:40:48,030 --> 00:40:52,270
dan huwa dak li jidher qisu jekk I
issa ikklikkja struttura ġdida Tab.

858
00:40:52,270 --> 00:40:54,550
Allura dan, li jkun ċar,
huwa biss mod phpMyAdmin ta

859
00:40:54,550 --> 00:40:58,570
ta 'tgħid tabella database tiegħek
għandha ID, isem, u numru

860
00:40:58,570 --> 00:41:02,040
ma 'dawk il-konfigurazzjonijiet partikolari
u aħna ser jinjora l-bqija tal-oqsma

861
00:41:02,040 --> 00:41:03,140
hemm għal issa.

862
00:41:03,140 --> 00:41:04,810
>> Allura issa dak li nixtieq do?

863
00:41:04,810 --> 00:41:09,060
Hekk jekk immur issa fis tiegħi
kodiċi tas-sors, jekk kollox huwa tajjeb

864
00:41:09,060 --> 00:41:11,190
Irrid li tesegwixxi l-mistoqsija li ġejja.

865
00:41:11,190 --> 00:41:14,970
Daħħal in, u nista 'biss
jgħidu utenti jien ma strettament

866
00:41:14,970 --> 00:41:18,620
bżonn dawk back-qurdien jekk huwa
mhijiex kelma perikolużi bħal utenti.

867
00:41:18,620 --> 00:41:22,810
Jien se ngħid isem,
numru, u allura hawnhekk jien

868
00:41:22,810 --> 00:41:24,960
mhux se kodiċi iebsa l-
ċifri tal-valuri għadhom.

869
00:41:24,960 --> 00:41:26,760
Jien ser tpoġġi żewġ trade marks in kwistjoni.

870
00:41:26,760 --> 00:41:29,320
U dan hija konvenzjoni
f'ħafna lingwi

871
00:41:29,320 --> 00:41:31,730
li biha jekk inti tixtieq li jkollok
placeholder għal string

872
00:41:31,730 --> 00:41:34,105
int ser tuża l-kwistjoni
marki, għal raġunijiet Aħna ser

873
00:41:34,105 --> 00:41:36,370
terga 'lura għal chat dwar
sigurtà, u hawn

874
00:41:36,370 --> 00:41:39,420
Jien ser jgħaddu f'dawk
iż-żewġ oqsma post isem,

875
00:41:39,420 --> 00:41:44,850
u mbagħad wara numru,
u issa tiffranka l-fajl.

876
00:41:44,850 --> 00:41:47,090
>> U issa jien ser
jinżlu hawnhekk huwa super

877
00:41:47,090 --> 00:41:55,690
sempliċement jgħidu rendersuccess.php, li
se tkun template ieħor.

878
00:41:55,690 --> 00:41:57,380
Jien ser toħloq verament mgħaġġel.

879
00:41:57,380 --> 00:42:06,270
Geditsuccess.php u jien biss jmorru
li jgħidu suċċess H1 f'dak il-fajl.

880
00:42:06,270 --> 00:42:06,990
Kull dritt.

881
00:42:06,990 --> 00:42:11,312
Allura issa, ejja jmorru lura għall-
browser, fejn I miżjura qabel.

882
00:42:11,312 --> 00:42:14,270
Ejja imorru quddiem u jikkonfermaw I kiteb
fl David, I kiteb fl-numru tat-telefon,

883
00:42:14,270 --> 00:42:15,390
reġistru.

884
00:42:15,390 --> 00:42:16,100
Kkritikat dan.

885
00:42:16,100 --> 00:42:17,420
What did I do wrong?

886
00:42:17,420 --> 00:42:20,850
Hekk jien jaraw żball hawn, inti
għandek żball fil-sintassi SQL tiegħek.

887
00:42:20,850 --> 00:42:24,900
Let me jaqbżu lura lill gedit, let
me jmorru lura għall register.php,

888
00:42:24,900 --> 00:42:28,830
u dak ma I tħalli barra li
kien l-aħħar darba importanti?

889
00:42:28,830 --> 00:42:29,722
I bżonn dan.

890
00:42:29,722 --> 00:42:32,930
Inti trid tkun taf li minbarra minn
li ndunat qabel, iżda I bżonn dan.

891
00:42:32,930 --> 00:42:35,596
>> Allura issa ejja mmorru lura, u dan
kien utli biex tara fil-browser

892
00:42:35,596 --> 00:42:37,680
u hu għalhekk li fl config.php
aħna bżiq out żbalji.

893
00:42:37,680 --> 00:42:41,770
Ejja imorru quddiem u rikarigu,
ikklikkja Kompli, is-suċċess.

894
00:42:41,770 --> 00:42:47,060
Allura issa let me jmorru fuq biex tiegħi
database hawn u kklikkja fuq l-utenti,

895
00:42:47,060 --> 00:42:51,680
u jibbrawżjaw, u l-avviż I issa
jkollhom David fid-database tiegħi hawn.

896
00:42:51,680 --> 00:42:55,810
Issa teknikament din il-websajt huwa
li għadha ma ġietx fuq l-internet pubbliku,

897
00:42:55,810 --> 00:42:57,890
so I ma jista 'jkollhom l-oħra
nies fil-tqegħid hawn,

898
00:42:57,890 --> 00:43:01,120
imma jekk jien issa riedu, għal
eżempju, tibgħat lili nnifsi messaġġ test.

899
00:43:01,120 --> 00:43:03,920
Ejja jmorru fuq parti hawn
u ara jekk dan attwalment xogħlijiet.

900
00:43:03,920 --> 00:43:07,331
Jien ser jimxi 'l quddiem
u ħassar dan ringiela

901
00:43:07,331 --> 00:43:09,080
u aħna ser ċċajpar dan
fl-video aktar tard

902
00:43:09,080 --> 00:43:11,900
hekk aħna ma jkollhomx il-
internet kollu SMSs lili,

903
00:43:11,900 --> 00:43:17,270
u aħna issa se jitla 'sa l-
browser u aħna ser jmorru fuq għal taħdita

904
00:43:17,270 --> 00:43:22,040
u aħna ser tip fil differenti
Numru hawnhekk, jirreġistraw, is-suċċess.

905
00:43:22,040 --> 00:43:25,550
>> Allura issa, numru tiegħi stess preżumibbilment
database, u issa l-parti gost.

906
00:43:25,550 --> 00:43:28,774
Ejja attwalment jużaw PHP biex tagħmel
xi ħaġa programmatically,

907
00:43:28,774 --> 00:43:30,940
jew mill-kmand
linja jew minn x'imkien ieħor,

908
00:43:30,940 --> 00:43:32,773
u għal issa jien biss
se jżommha sempliċi

909
00:43:32,773 --> 00:43:36,230
u jien se jmorru fil tiegħi
direttorju hawn u jagħmlu dan li ġej.

910
00:43:36,230 --> 00:43:44,920
Iskrittura gedit ejja ngħidu, aħna ser
sejħa hija test, #! / utent / PHP bin / ENV,

911
00:43:44,920 --> 00:43:46,700
bħal rajna aħħar darba.

912
00:43:46,700 --> 00:43:47,950
PHP.

913
00:43:47,950 --> 00:43:55,055
>> Issa jien ser ma jkunux jeħtieġu
jinkludi config.php,

914
00:43:55,055 --> 00:43:57,360
anki jekk dan jista '
jinduċi żball żgħir.

915
00:43:57,360 --> 00:44:03,960
U issa jien ser jimxi 'l quddiem u jgħidu
ringieli, query, star tagħżel mill-utenti,

916
00:44:03,960 --> 00:44:08,149
u issa hawn jien se jagħmlu teknika
mill-aħħar darba għal kull ringieli kif filliera.

917
00:44:08,149 --> 00:44:09,690
U jien se jagħmlu xi ħaġa sempliċi.

918
00:44:09,690 --> 00:44:19,090
Printf ejja ngħidu isem huwa dan,
u n-numru huwa dan, backslash n.

919
00:44:19,090 --> 00:44:23,320
U issa jien ser jgħaddu
ringiela nikkwota isem unquote,

920
00:44:23,320 --> 00:44:28,140
u n-numru ringiela unquote kwotazzjoni,
u issa ejja imorru quddiem

921
00:44:28,140 --> 00:44:31,430
u tieqa terminal tiegħi
chmod dan a + x biex jagħmlu

922
00:44:31,430 --> 00:44:33,970
din l-iskrittura imsejħa eżekutibbli test.

923
00:44:33,970 --> 00:44:36,080
U issa ejja run test.

924
00:44:36,080 --> 00:44:37,590
>> OK, hekk progress.

925
00:44:37,590 --> 00:44:39,960
Hekk stajt issa miktub
linja tal-kmand iskrittura,

926
00:44:39,960 --> 00:44:43,300
f'lingwa imsejjaħ PHP, li,
minħabba li jeħtieġu linja,

927
00:44:43,300 --> 00:44:46,380
għandu aċċess għal dawk kollha konfigurazzjoni
kostanti li I speċifikati.

928
00:44:46,380 --> 00:44:48,177
L-isem tad-database u ibqa 'sejjer hekk.

929
00:44:48,177 --> 00:44:50,260
Fil-fatt, biss biex tkun ċara
li dan mhux fluke,

930
00:44:50,260 --> 00:44:54,730
let me imorru quddiem u jirreġistraw,
verament mgħaġġel, xi ħadd ieħor bħal Rob

931
00:44:54,730 --> 00:44:58,890
u se jagħtih l-għadd 555-1212.

932
00:44:58,890 --> 00:45:01,557
>> U issa, jekk I run-iskrittura
għal darb'oħra, avviż-qawwa

933
00:45:01,557 --> 00:45:03,140
ta 'dak li aħna qed jagħmlu mal-database.

934
00:45:03,140 --> 00:45:07,680
Issa stajt immedjatament raw dak li l-
żewġ ringieli oħra huma fid-database tiegħi.

935
00:45:07,680 --> 00:45:10,699
Allura issa ejja jipprova jagħmel xi ħaġa
anki fancier ġewwa ta ',

936
00:45:10,699 --> 00:45:12,740
u dan huwa l-parti konna
mhux ittestjati bil-quddiem,

937
00:45:12,740 --> 00:45:15,910
hekk l-aħħar darba I ma 'dan
affarijiet marru horribly awry,

938
00:45:15,910 --> 00:45:17,120
għandna video għal dan l-effett.

939
00:45:17,120 --> 00:45:18,286
>> Attwalment, yeah, umoristiċi aside.

940
00:45:18,286 --> 00:45:20,480
Allura l-aħħar darba, fil-
lecture bħal sentejn ilu,

941
00:45:20,480 --> 00:45:23,230
aħna iddeċieda, I iddeċieda, li jkun
dan kollu tkun idea kbira

942
00:45:23,230 --> 00:45:28,150
li dinamikament jiġġeneraw emails fil
klassi, bl-użu CS50 database kollu

943
00:45:28,150 --> 00:45:33,390
istudenti, li kien mogħti lilna n-numri tagħhom
u t-trasportaturi cellphone tagħhom li inti

944
00:45:33,390 --> 00:45:36,290
jista recall minn pset0,
kif raġuni, jirriżulta

945
00:45:36,290 --> 00:45:40,650
I kellhom bug minuri fil-programm tiegħi u
għamlet żbalji koppja fl-2012, I think.

946
00:45:40,650 --> 00:45:43,997
>> Li biha, wieħed kelli għal loop li
għamlet eżattament dan it-tip ta 'ħaġa,

947
00:45:43,997 --> 00:45:46,580
mtennija fuq l-database,
jkollna isem mid-database,

948
00:45:46,580 --> 00:45:49,940
isem mid-database, u mbagħad fuq kull
iterazzjoni ta 'dak loop I bagħtet email.

949
00:45:49,940 --> 00:45:54,130
Iżda minflok jibgħatu email wieħed, I
bagħat wieħed email l-ewwel iterazzjoni,

950
00:45:54,130 --> 00:45:58,200
u żewġ emails tieni iterazzjoni, mibgħuta
tliet emails tieni iterazzjoni, li

951
00:45:58,200 --> 00:46:01,230
kif inti tista 'recall minn tagħna
diskussjoni ta 'notazzjoni asintotika

952
00:46:01,230 --> 00:46:06,400
din O big bad, bħal n kwadrat
huwa kif ħafna messaġġi I mibgħuta,

953
00:46:06,400 --> 00:46:08,560
iżda ma kienx anke emails
kien messaġġi.

954
00:46:08,560 --> 00:46:12,070
>> U kif tafu, attendenza mhuwiex
għolja super lejn it-tmiem tal-semestru

955
00:46:12,070 --> 00:46:15,360
u so I had ħelu fil
il-ħin li jgħidu, "Għaliex mhumiex inti klassi?"

956
00:46:15,360 --> 00:46:17,880
Fil-messaġġ test I
mibgħuta lill-klassi kollha,

957
00:46:17,880 --> 00:46:22,140
u kien umoristiċi li tixtieq 50% tal-
klassi, iżda l-oħra ta '50%, li wħud minnhom

958
00:46:22,140 --> 00:46:26,102
freaked, I bagħtet oerhört
noti ħelu apologetic

959
00:46:26,102 --> 00:46:28,560
għall-persunal apologizing għal
wara li tilef l-lecture biss

960
00:46:28,560 --> 00:46:29,530
dan darba, id-dritt?

961
00:46:29,530 --> 00:46:32,790

962
00:46:32,790 --> 00:46:34,030
>> Allura li kieku horribly awry.

963
00:46:34,030 --> 00:46:37,030
Għalhekk fl-ispirtu, ejja ipprova din
darb'oħra iżda biss bin-numru tiegħi.

964
00:46:37,030 --> 00:46:41,940
Minn qabel, b'mod functions.php,
Stajt bil-miktub din il-funzjoni hawn.

965
00:46:41,940 --> 00:46:44,250
Huwa sejjaħ test, u
jieħu fi tliet argumenti.

966
00:46:44,250 --> 00:46:46,360
A numru, trasportatur, u messaġġ.

967
00:46:46,360 --> 00:46:50,390
>> Jien jużaw dikjarazzjoni swiċċ, li
wonderfully PHP tieħu kordi, mhux biss

968
00:46:50,390 --> 00:46:53,350
interi, u jien ma implimentatx
l-appoġġ kollu għal dan suġġett s'issa,

969
00:46:53,350 --> 00:46:55,370
Stajt biss għamlu AT & T u Verizon.

970
00:46:55,370 --> 00:46:57,610
Għaliex jirriżulta
li ma 'dawn it-trasportaturi

971
00:46:57,610 --> 00:47:00,570
huma għandhom email biex gateways SMS,
fejn inti tista 'attwalment

972
00:47:00,570 --> 00:47:05,529
ibgħat email lill-indirizz
bħal numru tat-telefon fuq vtext.com

973
00:47:05,529 --> 00:47:08,070
u jekk l-utent ma jkunx imblukkat
il-messaġġi, dan ser jgħaddu

974
00:47:08,070 --> 00:47:09,340
huwa messaġġ b'test.

975
00:47:09,340 --> 00:47:13,270
>> Issa biex tagħmel dan, jien ser ikollhom iżidu
qasam wieħed verament mgħaġġel għad-database tiegħi.

976
00:47:13,270 --> 00:47:15,470
Jien se jmorru fil
istruttura tiegħi, u jien

977
00:47:15,470 --> 00:47:21,880
se jmorru 'l quddiem u żid
qasam fl-aħħar tat-tabella.

978
00:47:21,880 --> 00:47:25,227
Ejja ikklikkja Go, u jien
ser sejħa dan it-trasportatur

979
00:47:25,227 --> 00:47:27,310
u għal issa jien ser
jħallu dan bħala test bar,

980
00:47:27,310 --> 00:47:29,320
iżda nistgħu nkunu fancier fil-futur.

981
00:47:29,320 --> 00:47:31,961
Jien se jmorru malajr
fis mejda tiegħi, u jien

982
00:47:31,961 --> 00:47:34,210
se jeħles Rob,
għaliex thats numru foloz,

983
00:47:34,210 --> 00:47:38,540
Jien se jmorru fil jeditjaw hawn u jien
se jibdlu trasportatur tiegħi manwalment

984
00:47:38,540 --> 00:47:43,410
li jkun Verizon, li
hija, u issa hawn.

985
00:47:43,410 --> 00:47:44,980
>> Ejja tagħmel verifika sanità malajr.

986
00:47:44,980 --> 00:47:52,730
Ejja jiftħu iskrittura test tagħna, li
tidher bħal dan, trasportatur huwa% s.

987
00:47:52,730 --> 00:47:58,230
Li aħna qed tagħmel żball ħafna aktar
verifika minn I ma fl-2012, trasportatur.

988
00:47:58,230 --> 00:48:01,160
U issa, jien se jmorru
quddiem u mill-ġdid għaddi l-iskrittura.

989
00:48:01,160 --> 00:48:01,660
OK.

990
00:48:01,660 --> 00:48:06,100
Trasportatur huwa Verizon, li jfisser
issa nisperaw I tista 'tagħmel dan.

991
00:48:06,100 --> 00:48:08,360
Korrett din is-sena,
nisperaw, here we go.

992
00:48:08,360 --> 00:48:12,200
>> Allura ġewwa ta 'dan għal loop, jien
ser mhux biss ikollhom dan printf,

993
00:48:12,200 --> 00:48:15,990
Jien ukoll ser sejħa test u
l-użu ta 'dan recall funzjoni

994
00:48:15,990 --> 00:48:19,670
kien li tieħu numru, a
trasportatur, u messaġġ.

995
00:48:19,670 --> 00:48:23,310
Mela ejja ara, numru se
jkun ringiela quote unquote "numru,"

996
00:48:23,310 --> 00:48:31,660
ringiela kwotazzjoni unquote "trasportatur,"
u l-aħħar wieħed kien messaġġ.

997
00:48:31,660 --> 00:48:36,250
Ma screw up din is-sena, punto virgola.

998
00:48:36,250 --> 00:48:36,780
>> OK.

999
00:48:36,780 --> 00:48:38,280
Swaba qasmu.

1000
00:48:38,280 --> 00:48:39,970
Ejja naraw jekk dan jaħdem.

1001
00:48:39,970 --> 00:48:41,720
Kull dritt, hekk.

1002
00:48:41,720 --> 00:48:43,000
Here we go.

1003
00:48:43,000 --> 00:48:47,380
Ejja nisfruttaw-telefon,
cross fingers tiegħek, kkritikat dan.

1004
00:48:47,380 --> 00:48:50,300
May-- varjabbli undefined oh
stenna, stenna, stenna, reali fast.

1005
00:48:50,300 --> 00:48:51,340
Real fast, reali fast.

1006
00:48:51,340 --> 00:48:53,380
Dan huwa totalment worth it.

1007
00:48:53,380 --> 00:48:57,710
Let me grab, let me grab, UH-oh.

1008
00:48:57,710 --> 00:48:59,965
Nirringrazzjak, it-testi jkollhom
beda minn xi ħadd ieħor.

1009
00:48:59,965 --> 00:49:04,770

1010
00:49:04,770 --> 00:49:11,650
Let me imorru quddiem u tiftaħ reali
fast, dropbox.php / posta fil hawn.

1011
00:49:11,650 --> 00:49:12,660
Standby.

1012
00:49:12,660 --> 00:49:14,455
Totalment worth it.

1013
00:49:14,455 --> 00:49:17,430
Downloads.

1014
00:49:17,430 --> 00:49:18,560
OK, src8m sors.

1015
00:49:18,560 --> 00:49:19,700
OK.

1016
00:49:19,700 --> 00:49:21,380
>> Bżonn wieħed linja aktar hawn.

1017
00:49:21,380 --> 00:49:24,530
Oh hemm hu, huwa fil Frosh
IMs, huwa fir reġistru fl tlieta.

1018
00:49:24,530 --> 00:49:28,820
Oh hello, Margo, nirringrazzjak ħafna.

1019
00:49:28,820 --> 00:49:31,130
OK, u I kienet nieqsa din il-linja hawn.

1020
00:49:31,130 --> 00:49:33,010
So let me malajr grab
din il-linja tal-kodiċi,

1021
00:49:33,010 --> 00:49:36,200
li tinkludi l-posta jew il-librerija
li I attwalment tixtieq li tuża,

1022
00:49:36,200 --> 00:49:38,300
Jien ser malajr
jmorru lura fis-funzjonijiet,

1023
00:49:38,300 --> 00:49:42,337
Jien ser tmur għall-quċċata ta 'din
fajl u jeħtieġu dan il-fajl kif ukoll,

1024
00:49:42,337 --> 00:49:45,420
u issa jien ser verament jaqsmu tiegħi
swaba meta I jmorru lura għall-kmand

1025
00:49:45,420 --> 00:49:49,530
linja iskrittura, li huwa ġewwa ta '
direttorju ospitanti lokali lum.

1026
00:49:49,530 --> 00:49:50,610
Test run.

1027
00:49:50,610 --> 00:49:52,720
Ikteb.

1028
00:49:52,720 --> 00:49:53,220
Mail.

1029
00:49:53,220 --> 00:49:53,719
Standby.

1030
00:49:53,719 --> 00:49:58,850

1031
00:49:58,850 --> 00:49:59,600
Standby.

1032
00:49:59,600 --> 00:50:01,680
Mail.

1033
00:50:01,680 --> 00:50:02,290
Oh, OK.

1034
00:50:02,290 --> 00:50:03,870
Here we go.

1035
00:50:03,870 --> 00:50:06,880
>> Mail gets mailer PHP ġdid.

1036
00:50:06,880 --> 00:50:09,970
Ma nagħmel dan id-dritt?

1037
00:50:09,970 --> 00:50:11,067
Kkritikat dan.

1038
00:50:11,067 --> 00:50:12,150
To-- oh, stenna, stenna, stenna.

1039
00:50:12,150 --> 00:50:12,649
Stand by.

1040
00:50:12,649 --> 00:50:15,820

1041
00:50:15,820 --> 00:50:18,630
I wegħda, dan huwa
se jkun hekk worth it.

1042
00:50:18,630 --> 00:50:20,340
Indirizz.

1043
00:50:20,340 --> 00:50:24,390
Dan huwa għaliex I ma jagħmlu l-
Eżempji dritt qabel klassi.

1044
00:50:24,390 --> 00:50:26,350
Ugh.

1045
00:50:26,350 --> 00:50:27,910
Ir-riċevituri li ġejjin fallew.

1046
00:50:27,910 --> 00:50:31,500

1047
00:50:31,500 --> 00:50:33,040
Ejja nippruvaw aħħar ħaġa waħda.

1048
00:50:33,040 --> 00:50:40,660
SMTP stabbiliti minn, żid l-indirizz,
l-indirizz huwa tabilħaqq dak.

1049
00:50:40,660 --> 00:50:43,980
Ejja nippruvaw dan l-aħħar sehem indirizz.

1050
00:50:43,980 --> 00:50:47,210
Aw, Ninsab verament imdejjaq dritt issa.

1051
00:50:47,210 --> 00:50:47,854
Grazzi.

1052
00:50:47,854 --> 00:50:50,270
Imma jien verament japprezzaw kollha
it-testi inti kont qed jibgħat.

1053
00:50:50,270 --> 00:50:53,130

1054
00:50:53,130 --> 00:50:56,320
You ħadthom ltqajna dan David.

1055
00:50:56,320 --> 00:50:59,310
Inti blowing dan.

1056
00:50:59,310 --> 00:51:01,720
Ejja ħalliha hemm u
aħna se jiffissaw nhar it-Tnejn.

1057
00:51:01,720 --> 00:51:04,290
Ara inti mbagħad.

1058
00:51:04,290 --> 00:51:08,090
>> DAVEN FARNHAM: U issa Deep
Ħsibijiet mill Daven Farnham.

1059
00:51:08,090 --> 00:51:11,340

1060
00:51:11,340 --> 00:51:17,590
Jekk siġra binarju jaqa fil-foresti u
ebda wieħed huwa madwar biex Ċ [chuckling] it--.

1061
00:51:17,590 --> 00:51:18,998