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

2
00:00:10,075 --> 00:00:11,629

3
00:00:11,629 --> 00:00:14,420
ALLISON BUCHHOLTZ-UA: Kull dritt,
kulħadd, merħba lura għat-taqsima.

4
00:00:14,420 --> 00:00:17,420
Nisperaw inti kollha kellhom kbir
Weekend Halloween, jew Halloweekend,

5
00:00:17,420 --> 00:00:20,009
kif Jien inħobb ngħid, kollha
mistrieħa u rkuprati.

6
00:00:20,009 --> 00:00:21,675
U Thankfully mhuwiex snowing jibqgħalu.

7
00:00:21,675 --> 00:00:23,230
Huwa attwalment xemxija barra.

8
00:00:23,230 --> 00:00:25,040
I kienet kuntenta reali dwar dan.

9
00:00:25,040 --> 00:00:28,420
Mhux lest li ttawwal il boots xitwa tiegħi.

10
00:00:28,420 --> 00:00:31,820
Nisperaw, pset6 marru pretty ukoll.

11
00:00:31,820 --> 00:00:35,040
>> Jekk inti għajjien ta 'C, jien kuntent
li jgħidu inti qed isir ma 'C għal issa.

12
00:00:35,040 --> 00:00:37,550
Aħna kompletament transitioned
fil-programmazzjoni web,

13
00:00:37,550 --> 00:00:42,030
sabiex tkun taf tkun qed taħdem fil-HTML, PHP,
forsi xi ftit ta 'JavaScript.

14
00:00:42,030 --> 00:00:44,650
I do not know dak ġimgħa d-dieħla
pset huwa, so I ma jistgħux jiggarantixxu

15
00:00:44,650 --> 00:00:47,820
liema pset jmiss tiegħek se
jkun, iżda pset din il-ġimgħa

16
00:00:47,820 --> 00:00:52,290
huwa CS50 Finanzi, li hi bażikament
timplimenta l-tip ta 'web page

17
00:00:52,290 --> 00:00:57,222
li jippermetti li inti jixtru u jbiegħu
istokk, u jsegwuhom.

18
00:00:57,222 --> 00:00:59,930
U huwa pretty jibred, minħabba kollha
ta 'dan huwa dinamikament iġġenerat.

19
00:00:59,930 --> 00:01:02,320
Inti jista 'jkollhom l-utenti differenti li
kull wieħed ikollhom informazzjoni tagħhom stess,

20
00:01:02,320 --> 00:01:04,580
u int se tkun
implimentazzjoni kollha ta 'dak.

21
00:01:04,580 --> 00:01:05,970
Hija tieħu filwaqt.

22
00:01:05,970 --> 00:01:13,030
I definitely naħseb dan huwa aktar faċli
minn psets Ċ, iżda tieħu itwal.

23
00:01:13,030 --> 00:01:17,370
Int tagħlim ta 'lingwa ġdida,
PHP, li hija simili ħafna għal C,

24
00:01:17,370 --> 00:01:21,390
imma ovvjament se jeħtieġu
inti tfittex up sintassi u jifhmu

25
00:01:21,390 --> 00:01:23,360
kif jikkonvertu bejn il-lingwi.

26
00:01:23,360 --> 00:01:27,960
>> Imma jien ma naħsibx hemm xi ħaġa
super kunċettwalment diffiċli dwar dan pset.

27
00:01:27,960 --> 00:01:30,087
Huwa biss tagħlim l-
lingwa ġdida u jkollna

28
00:01:30,087 --> 00:01:31,420
permezz kollha dawn il-biċċiet ftit.

29
00:01:31,420 --> 00:01:34,850
Jekk inti guys taqra permezz
l-spec, huwa pjuttost twil.

30
00:01:34,850 --> 00:01:38,200
Naħseb li dan wieħed huwa simili 21
paġni, jekk niftakar sewwa.

31
00:01:38,200 --> 00:01:40,130
Huwa spec twil.

32
00:01:40,130 --> 00:01:42,218
Hekk jekk int ma taqra it-- 22.

33
00:01:42,218 --> 00:01:43,520
32.

34
00:01:43,520 --> 00:01:44,410
>> WoW.

35
00:01:44,410 --> 00:01:46,280
So I kien off b'50% hemmhekk.

36
00:01:46,280 --> 00:01:48,550
Allura, 32 paġni.

37
00:01:48,550 --> 00:01:49,820
Allura huwa twil.

38
00:01:49,820 --> 00:01:54,070
Hemm lottijiet ta 'biċċiet, iżda ħadd
tal-biċċiet għandu jkun li ħażina.

39
00:01:54,070 --> 00:01:55,650
Huwa biss ta 'lott.

40
00:01:55,650 --> 00:02:00,310
Allura definittivament tibda kmieni
jekk possibbli, kif kull soltu,

41
00:02:00,310 --> 00:02:05,480
imma naħseb li għandu jħossu ftit
nicer minn speċjalment il-psets simili

42
00:02:05,480 --> 00:02:10,250
jirkupraw u resize li huma biss
diffiċli ħafna biex nagħlaq ras tiegħek madwar.

43
00:02:10,250 --> 00:02:12,550
>> Allura ma 'dan, aħna qed tmur biex adsa.

44
00:02:12,550 --> 00:02:14,840
I ma jkollhomx l-aġenda tiegħek
slide illum, iżda aħna qed

45
00:02:14,840 --> 00:02:17,920
ser tkun jitkellem dwar PHP.

46
00:02:17,920 --> 00:02:20,790
I ser tkun giving you tip ta '
kors tiġrifa fuq xi affarijiet

47
00:02:20,790 --> 00:02:23,040
li inti tista 'tixtieq tkun taf dwar PHP.

48
00:02:23,040 --> 00:02:26,470
Affarijiet differenti sintassi,
affarijiet li għandek toqgħod attent għall-.

49
00:02:26,470 --> 00:02:29,400
Aħna qed tmur biex jitkellem
ftit dwar SQL.

50
00:02:29,400 --> 00:02:33,020
Affarijiet biss sempliċi ħafna
hemm, u allura wkoll MVC

51
00:02:33,020 --> 00:02:36,380
hija Mudell View Kontrollur, li
huwa kif pset tiegħek huwa stabbilit,

52
00:02:36,380 --> 00:02:39,801
sabiex nifhem kif dak
xogħlijiet se jkun super utli.

53
00:02:39,801 --> 00:02:40,300
Kull dritt.

54
00:02:40,300 --> 00:02:42,030
Hekk PHP.

55
00:02:42,030 --> 00:02:45,050
Inti guys għandu jkollu jsir
xi ħaġa ħafna, sempliċi ħafna

56
00:02:45,050 --> 00:02:48,680
ma PHP, li huwa
dan il-ħaġa qiegħ hawn,

57
00:02:48,680 --> 00:02:53,700
fejn inti ppreżenta xi forma fuq il-
top hawnhekk li kellhom xi isem li inti

58
00:02:53,700 --> 00:02:58,860
input, u ngħid simili hello, Ben,
jew hello, Allison, u kien pop up.

59
00:02:58,860 --> 00:03:02,570
Allura dan huwa fil-fatt dak li
għandhom ħadthom dehru qishom minn pset tiegħek,

60
00:03:02,570 --> 00:03:06,040
fil-każ inti guys riedu jkunu jafu
jew ma pjuttost figura hija out.

61
00:03:06,040 --> 00:03:14,520
>> Imma għandna dawn trade marks in kwistjoni
hawnhekk li jindikaw li dan huwa PHP.

62
00:03:14,520 --> 00:03:18,850
Huma wrap, u mbagħad
htmlspecialcharge, ftakar, huwa biss,

63
00:03:18,850 --> 00:03:22,450
kun żgur li int bla periklu
minn kwalunkwe attakk injezzjoni crazy

64
00:03:22,450 --> 00:03:26,550
jew jekk xi ħadd jipprova li tqiegħed
karattri malizzjużi crazy

65
00:03:26,550 --> 00:03:30,780
fis-qasam isem tiegħek, dan ma
bħall up server tiegħek jew whatnot.

66
00:03:30,780 --> 00:03:37,590
>> U mbagħad jekk aħna Avviż, dan HTML
forma kellhom metodu ta '$ _GET, li,

67
00:03:37,590 --> 00:03:42,050
jekk aħna niftakru superglobals tagħna
minn PHP, $ _GET, $ _POST,

68
00:03:42,050 --> 00:03:44,530
aħna ser tkun nidħlu
dawk ftit.

69
00:03:44,530 --> 00:03:50,390
Iżda nafu li għandna xi isem
hawnhekk li tikkorrispondi għall-isem

70
00:03:50,390 --> 00:03:51,920
li aħna sottomessa.

71
00:03:51,920 --> 00:03:56,930
Allura dan huwa biss tip ta bħall-
sempliċi ħafna kollaborazzjoni PHP HTML

72
00:03:56,930 --> 00:04:00,080
li inti guys kellhom minn pset sitta.

73
00:04:00,080 --> 00:04:02,410
>> Iżda dan ma verament
twieġeb dak li huwa PHP.

74
00:04:02,410 --> 00:04:04,850
Ovvjament huwa lingwa,
iżda aħna ma verament

75
00:04:04,850 --> 00:04:08,260
tkellem dwar dan f'din it-taqsima,
hekk hemm ftit aktar

76
00:04:08,260 --> 00:04:09,740
dwar dak PHP attwalment hu.

77
00:04:09,740 --> 00:04:14,270
Allura PHP huwa biss PHP
Preprocessor Portugues.

78
00:04:14,270 --> 00:04:16,399
>> Huwa attwalment meqjusa
lingwa ta 'programmar

79
00:04:16,399 --> 00:04:20,500
minħabba li għandha loġika, billi jekk
aħna niftakru jitkellem dwar HTML,

80
00:04:20,500 --> 00:04:24,980
we called li lingwa markup versus
lingwa ta 'programmar minħabba HTML

81
00:04:24,980 --> 00:04:27,790
huwa strettament timmodifika kif
affarijiet jidhru fuq il-paġna.

82
00:04:27,790 --> 00:04:30,650
Huwa biss jimmodifikaw
jekk xi ħaġa huwa bold,

83
00:04:30,650 --> 00:04:35,280
jew jekk huwa forma,
element, jew xi ħaġa bħal dik.

84
00:04:35,280 --> 00:04:36,750
Huwa ma jkollu ebda loġika.

85
00:04:36,750 --> 00:04:38,770
Huwa ma jkollu loops jew kundizzjonijiet.

86
00:04:38,770 --> 00:04:40,940
Inti ma tistax żball check affarijiet.

87
00:04:40,940 --> 00:04:44,810
Int tkun jew wiri affarijiet
b'ċertu mod jew jistaqsu għall-affarijiet

88
00:04:44,810 --> 00:04:45,490
mill-utent.

89
00:04:45,490 --> 00:04:47,180
Thats it.

90
00:04:47,180 --> 00:04:51,780
>> Allura ma PHP, attwalment ma inessu
biex jagħmlu kollha ta 'dawn l-affarijiet aktar loġiku,

91
00:04:51,780 --> 00:04:56,840
bħall jivvalida l-input jew
jimmanipulaw dan b'xi mod.

92
00:04:56,840 --> 00:05:02,570
Nistgħu jikkombinaw dan ma HTML, kif aħna biss
raw fil aħħar pset tiegħek u d-dritt issa,

93
00:05:02,570 --> 00:05:05,280
u jippermetti li tinħoloq
dawn il-paġni web dinamiku.

94
00:05:05,280 --> 00:05:08,900
Hekk jekk inti guys ever-- I do not know jekk
inti kienu simili me, iżda fl-iskola tan-nofs

95
00:05:08,900 --> 00:05:13,820
huma kienu nieħdu din il-klassi IT fejn
ħloqna biss paġni tal-web HTML,

96
00:05:13,820 --> 00:05:20,160
u kienu statiċi u kklikkja madwar
għal affarijiet oħra, iżda dawn qatt ma nbidlu.

97
00:05:20,160 --> 00:05:25,960
>> Ma 'dawk dinamiċi, dak li nistgħu
tagħmel huwa, bħal ma CS50 Finanzi,

98
00:05:25,960 --> 00:05:27,870
int se jkollhom l-utenti differenti.

99
00:05:27,870 --> 00:05:30,992
Jiddependi fuq dawk l-utenti "
preferenzi, u dak li qed jixtru

100
00:05:30,992 --> 00:05:32,700
jew dak li qed bejgħ
għall-istokkijiet tagħhom,

101
00:05:32,700 --> 00:05:35,050
int ser display
affarijiet differenti.

102
00:05:35,050 --> 00:05:38,110
Mela jekk hemm xi
karatteristika li tidentifika

103
00:05:38,110 --> 00:05:41,990
għall-utent tiegħek billi tuża din
paġna tal-web, nistgħu dinamikament

104
00:05:41,990 --> 00:05:44,720
tiddeċiedi x'għandek display għalihom.

105
00:05:44,720 --> 00:05:49,720
Mhuwiex l-istess ħaġa għal kull waħda
persuna, li jekk aħna biss kellhom HTML,

106
00:05:49,720 --> 00:05:52,400
il-paġna se jkun l-istess għal
kull persuna waħda li żaru.

107
00:05:52,400 --> 00:05:55,790
PHP jippermetti li personalize paġni.

108
00:05:55,790 --> 00:06:01,670
>> U allura aħna tista 'jew tpoġġihom fil
l-istess fajl, li, bħal fil-każ

109
00:06:01,670 --> 00:06:06,670
qabel hawnhekk, rajna li
għandna HTML kollha hawn

110
00:06:06,670 --> 00:06:09,760
u allura għandna dan ftit ta 'PHP.

111
00:06:09,760 --> 00:06:12,690
Nistgħu nagħmlu bħal dik,
jew CS50 Finanzi,

112
00:06:12,690 --> 00:06:16,310
jekk inti guys ħarsu lejn l-
files-- u għandu jkollna ħin

113
00:06:16,310 --> 00:06:19,541
pass permezz ta 'koppja minnhom
flimkien fl-aħħar tal-section-- aħna

114
00:06:19,541 --> 00:06:21,540
tista 'tara kif tista'
attwalment jżommhom separati,

115
00:06:21,540 --> 00:06:24,720
li huwa attwalment ħaġa aħjar biex tagħmel.

116
00:06:24,720 --> 00:06:26,550
>> So.

117
00:06:26,550 --> 00:06:27,680
Crash kors.

118
00:06:27,680 --> 00:06:32,860
L-affarijiet sempliċi malajr
jista 'jkollok bżonn li jkunu jafu għal PHP.

119
00:06:32,860 --> 00:06:34,470
Tiddikjara varjabbli.

120
00:06:34,470 --> 00:06:37,970
Li l-ikħal l-ftit annoying,
iżda nisperaw li int guys tista 'tara.

121
00:06:37,970 --> 00:06:39,850
Jekk le, jien ser jiktbu
fuq il-bord ġibs.

122
00:06:39,850 --> 00:06:41,370
Il-varjabbli li tiddikjara.

123
00:06:41,370 --> 00:06:46,710
Ħaġa waħda li tkun taf li, b'differenza C,
PHP huwa laxk jew dinamikament ittajpjat,

124
00:06:46,710 --> 00:06:50,870
li jfisser li inti m'għandekx bżonn li
tell varjabbli liema tip huwa.

125
00:06:50,870 --> 00:06:55,710
Inti tista 'biss sempliċement jgħidu xi varjabbli
hija ugwali għal dak kollu li inti tixtieq li,

126
00:06:55,710 --> 00:07:00,440
u se tiddeċiedi-tip ta '
dak il-varjabbli fi żmien run għalik.

127
00:07:00,440 --> 00:07:05,410
>> Kif tkun taf tara, dan jista 'joħloq
xi affarijiet interessanti ħafna.

128
00:07:05,410 --> 00:07:09,130
Iżda għall-aktar skopijiet, inti
m'għandhomx bżonn li tispeċifika t-tip.

129
00:07:09,130 --> 00:07:12,580
Inti tista ', u inti tista tip
mitfugħa affarijiet simili inti normalment

130
00:07:12,580 --> 00:07:15,900
ma tara jekk inti tixtieq li
forza li tkun ċertu tip,

131
00:07:15,900 --> 00:07:17,090
imma inti ma għandekx.

132
00:07:17,090 --> 00:07:19,810
Huwa mhux se Yell fi inti
jekk inti biss tiddikjara varjabbli

133
00:07:19,810 --> 00:07:21,910
u ma jispeċifikawx it-tip għaliha.

134
00:07:21,910 --> 00:07:25,199
>> Allura fil-każ inti ma tistax taqra
this-- Naf mhuwiex l-aħjar.

135
00:07:25,199 --> 00:07:28,490
Ħsibt li juru up better-- l
mod inti initialize xi varjabbli huwa biss

136
00:07:28,490 --> 00:07:31,270
b'sinjal dollaru, liema
inti tixtieq li jiġu msejħa,

137
00:07:31,270 --> 00:07:33,240
u mbagħad dak li qed assenjazzjoni tiegħu.

138
00:07:33,240 --> 00:07:36,520
Allura f'dan il-każ, dan huwa xi $ var = 3.

139
00:07:36,520 --> 00:07:40,450
Mela jekk aħna qatt tuża $ var
x'imkien, se biss

140
00:07:40,450 --> 00:07:42,760
jkun l-istess bħal tqegħid 3 hemmhekk.

141
00:07:42,760 --> 00:07:43,650
OK?

142
00:07:43,650 --> 00:07:46,480
>> Allura, kwalunkwe varjabbli, biss
sinjal dollaru, ikun x'ikun

143
00:07:46,480 --> 00:07:50,210
inti tixtieq li sejħa varjabbli tiegħek,
u tkun xi tkun tixtieq li ugwali.

144
00:07:50,210 --> 00:07:51,430
Little cooler.

145
00:07:51,430 --> 00:07:56,156
Inqas li tikteb għall initializing
varjabbli, id-dritt?

146
00:07:56,156 --> 00:07:57,530
Ma li jagħmel sens għal kulħadd?

147
00:07:57,530 --> 00:08:02,280
Just quick differenza sintassi
bejn C u PHP.

148
00:08:02,280 --> 00:08:06,440
>> Arrays huma ħafna cooler fil-PHP.

149
00:08:06,440 --> 00:08:09,620
Nistgħu nagħtuhom ċwievet.

150
00:08:09,620 --> 00:08:13,180
Allura l-mod biex jaħsbu dwar
huwa li, jekk aħna qatt

151
00:08:13,180 --> 00:08:16,610
riedu biex ikollhom aċċess għal
element fi ħdan firxa,

152
00:08:16,610 --> 00:08:19,290
aħna meħtieġa biex tkun taf l-
indiċi ta 'dan, id-dritt?

153
00:08:19,290 --> 00:08:24,290
Allura aħna nafu li ma C, aħna
tista 'aċċess għall-ewwel element

154
00:08:24,290 --> 00:08:28,650
billi tagħmel bracket firxa żero, jew jekk aħna
jridu li l-ewwel element, parentesi firxa

155
00:08:28,650 --> 00:08:29,360
wieħed.

156
00:08:29,360 --> 00:08:31,910
U jekk ridna xi ħaġa
fil hemm, nistgħu biss

157
00:08:31,910 --> 00:08:35,850
jkollhom jtenni permezz, sakemm
għandna attwalment jafu l-indiċi.

158
00:08:35,850 --> 00:08:38,320
>> Ħaġa waħda li hija verament
jibred arrays PHP

159
00:08:38,320 --> 00:08:40,850
hija li dawn qed liema
nitolbu assoċjattiva.

160
00:08:40,850 --> 00:08:44,970
Allura nistgħu jassoċjaw
xi muftieħ għall xi valur,

161
00:08:44,970 --> 00:08:47,340
u aħna qed attwalment għaddejjin
to-- I ser nuruk

162
00:08:47,340 --> 00:08:50,370
kif nistgħu nużaw dan fit-tieni.

163
00:08:50,370 --> 00:08:54,330
Imma bażikament, jekk inti qatt tixtieq
initialize firxa bħal dik,

164
00:08:54,330 --> 00:08:56,020
għandek xi $ array.

165
00:08:56,020 --> 00:08:59,622
>> Allura bl-istess mod, huwa biss
xi varjabbli li aħna qed jinħolqu.

166
00:08:59,622 --> 00:09:01,330
Dan jista 'jissejjaħ
kwalunkwe int riedu.

167
00:09:01,330 --> 00:09:03,310
Dan jista 'jkun $ eżempju.

168
00:09:03,310 --> 00:09:04,930
Biss ieħor varjabbli.

169
00:09:04,930 --> 00:09:09,510
Dak li jagħmilha firxa hija l-
sintassi bracket li għandna hawnhekk.

170
00:09:09,510 --> 00:09:14,560
Eżatt bħal C. normali U aħna
għandhom xi muftieħ għall xi valur.

171
00:09:14,560 --> 00:09:19,480
Allura key1 tmur għall value1,
key2 tnejn tmur għall value2.

172
00:09:19,480 --> 00:09:25,080
Dawn il-pari huma separati bi
comma, bħad arrays normali.

173
00:09:25,080 --> 00:09:25,810
>> Madankollu.

174
00:09:25,810 --> 00:09:26,520
Big wieħed.

175
00:09:26,520 --> 00:09:27,270
Ċwievet huma fakultattivi.

176
00:09:27,270 --> 00:09:28,510
Inti ma għandekx li jużawhom.

177
00:09:28,510 --> 00:09:30,850
U jekk inti ma, allura huwa biss normali.

178
00:09:30,850 --> 00:09:32,030
Mistoqsija?

179
00:09:32,030 --> 00:09:33,540
Jew, oh.

180
00:09:33,540 --> 00:09:37,829
>> UDJENZA: Well, dwar id-dritt.

181
00:09:37,829 --> 00:09:39,120
Fejn hi l-memorja ġejjin minn?

182
00:09:39,120 --> 00:09:43,425
Jista 'jkun ukoll l-istess bħal
[Inaudible] u mill-munzell?

183
00:09:43,425 --> 00:09:45,277
Hija li wkoll jużaw PHP?

184
00:09:45,277 --> 00:09:46,485
Bħal meta aħna qed jgħaqqdu lilhom?

185
00:09:46,485 --> 00:09:49,070
>> ALLISON BUCHHOLTZ-UA:
Ma PHP, Aħna ma tendenza

186
00:09:49,070 --> 00:09:52,670
għalfejn tinkwieta dwar fejn tagħna
memorja s ġejjin minn.

187
00:09:52,670 --> 00:09:54,670
Aħna ma jqattgħu ħafna
ħin jitkellem dwar dan,

188
00:09:54,670 --> 00:09:58,450
dan mhuwiex verament xejn
għandek bżonn ninkwetaw dwar.

189
00:09:58,450 --> 00:10:00,620
Allura ċwievet huma fakultattivi.

190
00:10:00,620 --> 00:10:04,780
Bl-istess mod, jekk inti ma
tixtieq li tagħmel dan assoċjata,

191
00:10:04,780 --> 00:10:09,910
inti biss tixtieq firxa normali fejn
firxa żero hija l-ewwel element

192
00:10:09,910 --> 00:10:13,190
u firxa waħda hija t-tieni
element, inti tista 'tagħmel dan eżattament

193
00:10:13,190 --> 00:10:17,886
kif inti fil C. Għandek xi
varjabbli li għaddej biex tkun array tiegħek,

194
00:10:17,886 --> 00:10:20,110
u huwa ugwali dawn parentesi hawn.

195
00:10:20,110 --> 00:10:20,610
Iva.

196
00:10:20,610 --> 00:10:22,693
>> UDJENZA: Ma jkollu l-
istess punt biex notazzjoni.

197
00:10:22,693 --> 00:10:26,250
Bħal, I tista 'tagħmel bħal firxa ++,
u li l-punti għat-tieni waħda.

198
00:10:26,250 --> 00:10:30,260
>> ALLISON BUCHHOLTZ-UA: Tista do--
Well, inti jista 'jkollhom xi iterator, i,

199
00:10:30,260 --> 00:10:34,300
li inti tista 'tagħmel i ++ u do a
firxa ta 'i bl-istess mod.

200
00:10:34,300 --> 00:10:35,680
Iżda li dan.

201
00:10:35,680 --> 00:10:39,630
Allura, bħal f'dan il-każ,
firxa ta '1 jkun indaqs 20.

202
00:10:39,630 --> 00:10:42,530
Istess tip ta 'notazzjoni indiċjar.

203
00:10:42,530 --> 00:10:51,330
Dan huwa bażikament biss ħaġa impliċitu
hawn, fejn jgħid żero, żero sa 10,

204
00:10:51,330 --> 00:10:54,640
għal 1 sa 20, 2-30.

205
00:10:54,640 --> 00:10:56,760
Huwa biss ċwievet impliċiti għal dan.

206
00:10:56,760 --> 00:10:59,990
Liema bidliet ma PHP huwa
li inti issa għandhom il-poter

207
00:10:59,990 --> 00:11:02,660
li jassenja mill-ġdid dawk imfietaħ għal
jagħmlu dak kollu li tixtieq.

208
00:11:02,660 --> 00:11:13,820
>> Allura ħaġa waħda hija hawnhekk.

209
00:11:13,820 --> 00:11:18,230
So I jkollhom biss xi eżempji
hawn li I kiteb up għalik guys

210
00:11:18,230 --> 00:11:22,010
għaliex inħoss bħal eżempji dejjem
jgħin aktar minn sempliċiment il-astratt.

211
00:11:22,010 --> 00:11:26,590
Allura, f'dan il-każ hawnhekk, aħna
għandhom xi firxa assoċjattiva

212
00:11:26,590 --> 00:11:31,990
li hija l-ewwel isem tiegħi,
tiegħi isem l-aħħar, u I

213
00:11:31,990 --> 00:11:35,390
am b'repetizzjoni, li huwa biss
għall-iskopijiet kollha hawn

214
00:11:35,390 --> 00:11:38,500
ser jistampa mal-output hawn.

215
00:11:38,500 --> 00:11:39,300
>> U jgħid, OK.

216
00:11:39,300 --> 00:11:46,680
Jistampa l-valur li
jikkorrispondi għal firxa fil ċavetta Allison.

217
00:11:46,680 --> 00:11:50,860
U nista 'wkoll tibgħat inti guys
dan kollu kodiċi wara klassi.

218
00:11:50,860 --> 00:11:53,700
Allura, meta aħna run dan, liema do
taħseb jiġri?

219
00:11:53,700 --> 00:11:56,239
X'inhu għaddej li jistampa?

220
00:11:56,239 --> 00:11:57,280
UDJENZA: isem l-aħħar tiegħek.

221
00:11:57,280 --> 00:11:58,738
ALLISON BUCHHOLTZ-UA: l-isem aħħar My.

222
00:11:58,738 --> 00:12:00,000
Hija ma.

223
00:12:00,000 --> 00:12:00,960
Dritt hawn.

224
00:12:00,960 --> 00:12:02,400
Jistampa.

225
00:12:02,400 --> 00:12:07,000
Hekk jekk konna li jbiddlu dan u aħna
kienu li jżidu xi ħadd ieħor biex list-- tagħna

226
00:12:07,000 --> 00:12:11,919
Mela ejja ngħidu li għandna Emma hawn,
u aħna jassoċjaw aħħar name-- tiegħek

227
00:12:11,919 --> 00:12:13,252
Ejja naraw jekk I jespliċitaw dan id-dritt.

228
00:12:13,252 --> 00:12:13,714
>> UDJENZA: Yeah.

229
00:12:13,714 --> 00:12:14,640
>> ALLISON BUCHHOLTZ-UA: Iva.

230
00:12:14,640 --> 00:12:15,010
>> UDJENZA: Tajba tax-xogħol.

231
00:12:15,010 --> 00:12:16,218
>> ALLISON BUCHHOLTZ-UA: sabiħ.

232
00:12:16,218 --> 00:12:25,370
Allura issa jekk ikollna dan hawn u
ridna li ssib isem l-aħħar tiegħek,

233
00:12:25,370 --> 00:12:26,290
ikollok hemmhekk.

234
00:12:26,290 --> 00:12:31,270
Allura inti tista 'biss jaħsbu li
bħala li jissostitwixxu dan ċavetta hawn.

235
00:12:31,270 --> 00:12:33,190
Int biss tissostitwixxi l-indiċi.

236
00:12:33,190 --> 00:12:36,845
Għalhekk iħallik tfittex biss
permezz ta 'firxa ferm aktar faċli.

237
00:12:36,845 --> 00:12:38,220
Inti ma għandekx bżonn li jkunu jafu l-indiċi.

238
00:12:38,220 --> 00:12:43,470
Sakemm dan ewlenin li qed tfittex
għall teżisti x'imkien fil-firxa,

239
00:12:43,470 --> 00:12:47,660
PHP se jsibuha u ser jirritorna
il-valur assoċjat miegħu.

240
00:12:47,660 --> 00:12:49,840
Għalhekk tagħtik ħafna aktar
enerġija bl arrays tiegħek.

241
00:12:49,840 --> 00:12:50,340
Iva.

242
00:12:50,340 --> 00:12:53,131
>> UDJENZA: Jekk għandek żewġ ċwievet il-
istess, se jtik żball?

243
00:12:53,131 --> 00:12:55,830
ALLISON BUCHHOLTZ-UA: Hija
għandu jtik żball, yeah.

244
00:12:55,830 --> 00:12:58,520
Ma li jagħmlu ftit
aktar sens għalik guys?

245
00:12:58,520 --> 00:13:07,640
U fl-istess mod, għandna firxa
hawnhekk li ma jkollu ebda ċwievet.

246
00:13:07,640 --> 00:13:10,910
Wkoll dan huwa sintassi
li inti tista 'tixtieq

247
00:13:10,910 --> 00:13:13,550
li jkun konxju ta ', għaliex inti ser
għandek tuża dan fil pset tiegħek.

248
00:13:13,550 --> 00:13:17,317
>> Kull meta inti qed tagħmel xi
eku, inti għandek dawn il-kwotazzjonijiet,

249
00:13:17,317 --> 00:13:19,400
u kull meta int jirreferu
għal parti minn firxa,

250
00:13:19,400 --> 00:13:22,180
inti trid li jkollha dawn
braces kaboċċi madwarhom.

251
00:13:22,180 --> 00:13:25,630
Huwa tip ta 'annoying, iżda
inti biss għandek tagħmel dan.

252
00:13:25,630 --> 00:13:28,010
Hekk biss xi ħaġa li wieħed iżomm f'moħħu.

253
00:13:28,010 --> 00:13:31,490
Jekk int taħdem fis żbalji ta ',
Naf li dan jeżisti fil-firxa tiegħi

254
00:13:31,490 --> 00:13:34,523
imma hija jitfg żbalji fil lili,
Ipprova tqegħid ċingi madwaru

255
00:13:34,523 --> 00:13:37,180
u għandha taħdem.

256
00:13:37,180 --> 00:13:40,810
>> Allura f'dan il-każ hawnhekk, dan huwa
firxa normali C li aħna qed jintużaw biex.

257
00:13:40,810 --> 00:13:45,810
Għandha tliet, ħames, u sitt, u aħna biss
tixtieq li jistampa l-ewwel element,

258
00:13:45,810 --> 00:13:47,850
għalhekk dan għandu jistampa tlieta.

259
00:13:47,850 --> 00:13:51,830
And I ma run dawn kollha, hekk
nisperaw xejn inbidlet.

260
00:13:51,830 --> 00:13:54,460
Naraw fil-qiegħ hawn,
hija biss prints out tlieta.

261
00:13:54,460 --> 00:13:57,050

262
00:13:57,050 --> 00:13:58,040
Kessaħ.

263
00:13:58,040 --> 00:14:00,000
Li jagħmel sens għal kulħadd?

264
00:14:00,000 --> 00:14:01,280
Arrays assoċjattiva.

265
00:14:01,280 --> 00:14:03,150
Ferm aktar kiesħa milli arrays normali.

266
00:14:03,150 --> 00:14:09,640
>> Dan huwa why-- Kont David nuruk
l-implimentazzjoni PHP ta pset6

267
00:14:09,640 --> 00:14:11,751
matul taħdita fil-livelli kollha?

268
00:14:11,751 --> 00:14:12,250
OK.

269
00:14:12,250 --> 00:14:13,300
So, I ser nuruk.

270
00:14:13,300 --> 00:14:13,770
I do not know barra mis-t--

271
00:14:13,770 --> 00:14:14,680
>> UDJENZA: Huwa ma aħħar ġimgħa.

272
00:14:14,680 --> 00:14:15,560
>> ALLISON BUCHHOLTZ-UA: Giet aħħar ġimgħa?

273
00:14:15,560 --> 00:14:15,870
>> UDJENZA: Yeah.

274
00:14:15,870 --> 00:14:16,995
>> ALLISON BUCHHOLTZ-UA: Yeah.

275
00:14:16,995 --> 00:14:20,800
Allura speller jista 'jsir fil bħall sitt linji
ma PHP, u parti mill-enerġija ta 'dak

276
00:14:20,800 --> 00:14:25,640
huwa dan array assoċjattiva fejn
inti tista 'biss it-tagħbija kull kelma fil,

277
00:14:25,640 --> 00:14:28,290
u ikollok ugwali għal veru jew falza.

278
00:14:28,290 --> 00:14:31,410
U għalhekk inti tista 'tgħid, oh.

279
00:14:31,410 --> 00:14:39,130
Ritorn dizzjunarju f'xi kelma, u
jekk huwa hemmhekk, huwa ser jerġa veru.

280
00:14:39,130 --> 00:14:42,130
Inkella, dan mhux se ssib
u dan ser jirritorna falza.

281
00:14:42,130 --> 00:14:45,810
Għalhekk tip ta 'ħaġa ftit jibred.

282
00:14:45,810 --> 00:14:46,750
>> Kull dritt.

283
00:14:46,750 --> 00:14:48,990
Għalhekk dawn huma arrays assoċjattiva.

284
00:14:48,990 --> 00:14:50,150
Huma qed pretty jibred.

285
00:14:50,150 --> 00:14:51,830
I really simili għalihom.

286
00:14:51,830 --> 00:14:55,340
U ovvjament this-- Ah.

287
00:14:55,340 --> 00:14:56,290
OK.

288
00:14:56,290 --> 00:14:57,880
Issa huwa xogħol.

289
00:14:57,880 --> 00:15:00,700
Forsi.

290
00:15:00,700 --> 00:15:01,537
OK.

291
00:15:01,537 --> 00:15:02,120
Ħaġa oħra.

292
00:15:02,120 --> 00:15:07,680
Allura, ma 'l-ugwaljanza, biss
jibred ħaġa li wieħed iżomm f'moħħu.

293
00:15:07,680 --> 00:15:12,140
Ma PHP, minħabba li
huwa dinamikament ittajpjat,

294
00:15:12,140 --> 00:15:16,110
it-tip tista 'tbiddel skond meta
inti run, kif int running.

295
00:15:16,110 --> 00:15:19,890
I attwalment għandhom xi jibred
eżempji li jien ser jurik guys.

296
00:15:19,890 --> 00:15:23,350
>> Iżda == kontrolli biss għall
ugwaljanza wara juggling tip.

297
00:15:23,350 --> 00:15:28,890
Mela jekk għandek xi ħaġa li
bħall-karattru 1 u n-numru 1,

298
00:15:28,890 --> 00:15:31,890
PHP se jgħidlek li
dawk huma ugwali minħabba li

299
00:15:31,890 --> 00:15:35,990
tista juggle-tipi ta 'l-
tnejn minnhom sakemm huwa ugwali,

300
00:15:35,990 --> 00:15:38,480
li forsi għall-każ tiegħek huwa multa.

301
00:15:38,480 --> 00:15:44,170
>> Jekk għandek bżonn biex tara jekk huma l-
istess tip ta 'valur u l-istess tip,

302
00:15:44,170 --> 00:15:45,305
inti tixtieq dan ===.

303
00:15:45,305 --> 00:15:48,150
U jien ma naħsibx għandek xi
każ fejn għandek bżonn tuża dik

304
00:15:48,150 --> 00:15:52,570
fil pset tiegħek, iżda għal ħafna
inti li se jmorru biex tagħmel paġni web

305
00:15:52,570 --> 00:15:57,340
għall-proġetti finali tiegħek u affarijiet, huwa
ħaġa tajba li tkun taf li == u ===

306
00:15:57,340 --> 00:16:01,690
huma differenti, u huwa tajjeb
distinzjoni li jifhmu.

307
00:16:01,690 --> 00:16:02,400
>> OK.

308
00:16:02,400 --> 00:16:02,980
So.

309
00:16:02,980 --> 00:16:04,460
Loops foreach.

310
00:16:04,460 --> 00:16:07,920
Dawn huma mod biex
jtenni permezz ta 'firxa.

311
00:16:07,920 --> 00:16:11,714
Allura, bħad arrays sar
tant cooler fil-PHP,

312
00:16:11,714 --> 00:16:13,630
mod tiegħek biex jtenni
permezz ta 'firxa, I think,

313
00:16:13,630 --> 00:16:16,250
wkoll isir ferm aktar kiesħa
u ferm aktar b'saħħitha.

314
00:16:16,250 --> 00:16:22,710
Allura minflok li joħolqu
xi wħud għall-i huwa ugwali 0 u tkun xi tkun,

315
00:16:22,710 --> 00:16:24,890
u mbagħad taġġorna dak
i kif tmur permezz,

316
00:16:24,890 --> 00:16:27,730
għandna dan loop foreach biża.

317
00:16:27,730 --> 00:16:36,340
>> Allura hawnhekk-ġenerali standard
istruttura ta 'dawn iż-żewġ.

318
00:16:36,340 --> 00:16:41,180
Allura inti jew ikollhom foreach xi firxa
bħala l-valur inti tixtieq li jtenni bħala.

319
00:16:41,180 --> 00:16:46,750
Allura dan huwa l-isem ta 'l-array
varjabbli li inti tixtieq li referenza,

320
00:16:46,750 --> 00:16:50,600
u dan huwa dak li trid
li hija sejħa fi ħdan il-linja.

321
00:16:50,600 --> 00:16:51,420
OK?

322
00:16:51,420 --> 00:16:56,810
Allura dan jikkorrispondi għal
kull element tal-firxa,

323
00:16:56,810 --> 00:16:59,500
u tuża dan il-valur fi ħdan dan loop.

324
00:16:59,500 --> 00:17:00,675
>> Għandi eżempju.

325
00:17:00,675 --> 00:17:02,930
Naf eżempji huma tant aħjar.

326
00:17:02,930 --> 00:17:05,119
U għalhekk dan huwa jekk ikun hemm
ebda ċwievet, għalhekk dan huwa simili

327
00:17:05,119 --> 00:17:11,170
jekk aħna biss għandhom wieħed fejn il-keys
huma l-indiċijiet normali għal firxa tiegħek.

328
00:17:11,170 --> 00:17:14,770
Jew dan huwa wkoll fil-każ jekk
ikollok l-ebda użu għall-ċwievet.

329
00:17:14,770 --> 00:17:16,690
Jekk inti ma jimpurtahom dwar
l-ċwievet u inti biss

330
00:17:16,690 --> 00:17:20,260
tixtieq li jtenni permezz ta 'mal-valuri
għal kull wieħed minn dawk fi kwalunkwe ordni,

331
00:17:20,260 --> 00:17:20,950
li l-multa.

332
00:17:20,950 --> 00:17:22,609
>> Inti tista 'tuża l-istruttura.

333
00:17:22,609 --> 00:17:28,640
Inkella, jekk ikun hemm ċwievet, tagħna
Valur $ biss bidliet sa $ valur ewlieni.

334
00:17:28,640 --> 00:17:30,660
Allura hija biss bidliet għall par valur ewlieni.

335
00:17:30,660 --> 00:17:34,780
U allura nistgħu jirreferu għal $ ċavetta
u $ valur fi ħdan loop tagħna.

336
00:17:34,780 --> 00:17:35,900
OK?

337
00:17:35,900 --> 00:17:36,660
So.

338
00:17:36,660 --> 00:17:37,810
Eżempju.

339
00:17:37,810 --> 00:17:38,610
Jagħmluha nicer.

340
00:17:38,610 --> 00:17:48,910

341
00:17:48,910 --> 00:17:49,410
OK.

342
00:17:49,410 --> 00:17:56,780
>> Allura aħna għandna dan wieħed
hawn, li aħna għandna xi

343
00:17:56,780 --> 00:18:01,460
are-- Tista 'wkoll
toħloq firxa bħal din

344
00:18:01,460 --> 00:18:05,690
billi jkollhom xi ugwali varjabbli
biex array ma parentesi,

345
00:18:05,690 --> 00:18:08,340
jew tista 'biss tagħmel bracket.

346
00:18:08,340 --> 00:18:11,890
Għandek tagħmel l-parentesi, iżda
dan huwa mod ieħor biex tagħmel dan.

347
00:18:11,890 --> 00:18:16,220
Allura hawnhekk għandna xi firxa ta 'tlieta
elementi ta 'wieħed, tnejn, u tlieta,

348
00:18:16,220 --> 00:18:18,300
u għandna foreach tagħna.

349
00:18:18,300 --> 00:18:23,510
>> Avviż dan wieħed jikkorrispondi għall-
firxa li aħna qed jiġu mtennija fuq,

350
00:18:23,510 --> 00:18:28,330
u dan huwa dak li aħna qed ssejjaħ
kull ħaġa fil-firxa tagħna.

351
00:18:28,330 --> 00:18:32,670
U dan kollu qed tagħmel huwa huwa
ser jistampa kull valur.

352
00:18:32,670 --> 00:18:45,590
Hekk jekk aħna run, aħna Avviż li aħna
għandhom valur wieħed, valur tnejn, valur tlieta.

353
00:18:45,590 --> 00:18:54,080
>> U fl-istess mod li tipikament
arrays jeħtieġ li tkun ta 'tip wieħed,

354
00:18:54,080 --> 00:18:57,570
arrays ma għandekx kollha
jkun l-istess tip hawnhekk.

355
00:18:57,570 --> 00:18:58,690
Allura issa għandna xi int.

356
00:18:58,690 --> 00:19:00,910
Għandna żewġ kordi.

357
00:19:00,910 --> 00:19:05,332
Allura arrays tiegħek jista
nikseb ferm aktar b'saħħitha

358
00:19:05,332 --> 00:19:07,040
u forsi ftit
daqsxejn Messier, jiddependi

359
00:19:07,040 --> 00:19:08,500
fuq il-mod inti tixtieq li tħares lejn din.

360
00:19:08,500 --> 00:19:10,970
Allura nistgħu nbiddlu dan
għal dak kollu li rridu.

361
00:19:10,970 --> 00:19:12,860
Aħna nużaw valur.

362
00:19:12,860 --> 00:19:14,630
Dik hija biss il-ħaġa standard nużaw.

363
00:19:14,630 --> 00:19:19,650
Iżda, biss importanti li tkun taf li nistgħu
sejħa dan counter simili jekk ridna.

364
00:19:19,650 --> 00:19:25,070
U sakemm dawn jaqblu,
ovvjament kulħadd kuntent.

365
00:19:25,070 --> 00:19:30,600
Jekk inti qatt tixtieq li tmexxi PHP
run xi ħaġa bħal dan il-kmand

366
00:19:30,600 --> 00:19:33,800
linja tafu dan
hawn, inti biss tagħmel PHP,

367
00:19:33,800 --> 00:19:36,090
u mbagħad tkun xi fajl inti tixtieq li run.

368
00:19:36,090 --> 00:19:39,130
>> Mela jekk inti tixtieq li mess madwar
ma PHP, u aktar il-loġika

369
00:19:39,130 --> 00:19:42,710
u inti ma verament bżonn li
tara bħal fil-web browser,

370
00:19:42,710 --> 00:19:44,830
inti tista 'sempliċement run fil
kmand tal-linja bħal dik

371
00:19:44,830 --> 00:19:48,290
u eku se print
out tkun xi tkun tixtieq.

372
00:19:48,290 --> 00:19:50,880
OK.

373
00:19:50,880 --> 00:20:00,640
Il-mod ieħor li għandna huwa bħal dan.

374
00:20:00,640 --> 00:20:06,974
Allura dan huwa każ fejn forsi inti tixtieq
li jużaw kemm-ċavetta u l-valur,

375
00:20:06,974 --> 00:20:08,890
Naf li dawn huma simili
eżempji super artifiċjali

376
00:20:08,890 --> 00:20:11,950
imma nispera li jagħmlu
hija ftit aktar ċara.

377
00:20:11,950 --> 00:20:14,940
Allura hawnhekk għandna xi firxa
darb'oħra, iżda din id-darba,

378
00:20:14,940 --> 00:20:19,450
minflok sempliċiment li jkollhom
inti taf hemm l-ebda ċavetta.

379
00:20:19,450 --> 00:20:20,870
Għandna ċwievet għal kull wieħed minn dawn.

380
00:20:20,870 --> 00:20:24,670
Allura huwa gonna jkun wieħed, b se jikkorrispondu
għal tnejn, u ċ se jikkorrispondu għal tlieta.

381
00:20:24,670 --> 00:20:27,030
U f'dan il-każ, jekk
aħna tikteb dan il-mod,

382
00:20:27,030 --> 00:20:31,580
ikollna aċċess għal kemm ċavetta
u l-valur għal kull wieħed minn dawn.

383
00:20:31,580 --> 00:20:36,570
>> Allura meta aħna run dan,
irridu jiksbu kull wieħed minn dawk.

384
00:20:36,570 --> 00:20:41,530
Allura prints out ċwievet tagħna
u l-valuri korrispondenti.

385
00:20:41,530 --> 00:20:46,940
Ħaġa oħra jibred hija li, u naf
qal bħal dan wieħed ma kellux ċwievet,

386
00:20:46,940 --> 00:20:51,540
imma dejjem impliċitament għandha
ċavetta għaliex jekk inti ma tiddelega

387
00:20:51,540 --> 00:20:54,050
ewlieni, ta 'kors, tiegħek
ċwievet huma biss indiċi tiegħek

388
00:20:54,050 --> 00:20:59,230
jew indiċijiet hekk nistgħu
dejjem wkoll jagħmlu dan wieħed.

389
00:20:59,230 --> 00:20:59,730
Bħal dan.

390
00:20:59,730 --> 00:21:02,500

391
00:21:02,500 --> 00:21:03,400
I se jistampa.

392
00:21:03,400 --> 00:21:09,240

393
00:21:09,240 --> 00:21:13,420
Allura f'dan il-każ, jekk tinnota,
għandna ċwievet impliċiti tagħna

394
00:21:13,420 --> 00:21:15,930
ta 'żero, wieħed, u tnejn hawn.

395
00:21:15,930 --> 00:21:20,020

396
00:21:20,020 --> 00:21:25,600
>> U l-istess mod ma 'dan wieħed,
inti tista 'dejjem biss jgħidu r bħala valur,

397
00:21:25,600 --> 00:21:27,910
u inti biss għandek aċċess għall-valur.

398
00:21:27,910 --> 00:21:30,685
Inti ma jimpurtahom tiegħek
ċwievet, anki jekk tiegħek ċwievet,

399
00:21:30,685 --> 00:21:32,810
jekk inti ma jimpurtahom dwar
minnhom, inti ma neċessarjament

400
00:21:32,810 --> 00:21:35,970
bżonn li jpoġġuhom fil loop foreach tiegħek.

401
00:21:35,970 --> 00:21:37,953
Does li jagħmel sens għal kulħadd?

402
00:21:37,953 --> 00:21:39,764
>> UDJENZA: Tista 'biss
sejħa l-ċwievet, wisq?

403
00:21:39,764 --> 00:21:42,180
ALLISON BUCHHOLTZ-UA: Yeah inti
jista totalment jagħmlu dan, wisq.

404
00:21:42,180 --> 00:21:44,945

405
00:21:44,945 --> 00:21:45,570
Attwalment, stenna.

406
00:21:45,570 --> 00:21:45,840
Żomm fuq.

407
00:21:45,840 --> 00:21:46,630
kieku it-- No

408
00:21:46,630 --> 00:21:49,663
Jekk inti tixtieq-ċavetta, allura
inti għandek bżonn tagħmel muftieħ għall-valur.

409
00:21:49,663 --> 00:21:50,496
UDJENZA: Żid il-valur.

410
00:21:50,496 --> 00:21:50,870
ALLISON BUCHHOLTZ-UA: Yeah.

411
00:21:50,870 --> 00:21:52,530
U inti biss qatt tuża valur huwa kollha.

412
00:21:52,530 --> 00:21:53,236
>> UDJENZA: OK.

413
00:21:53,236 --> 00:21:55,610
ALLISON BUCHHOLTZ-UA: Jekk inti
biss jitqiegħed ħaġa waħda fil hemm,

414
00:21:55,610 --> 00:22:00,010
li għaddej biex jassumi li int
jitkellem dwar il-valur, mhux il-ċavetta.

415
00:22:00,010 --> 00:22:02,070
Kwistjoni kbira.

416
00:22:02,070 --> 00:22:02,600
Kull dritt.

417
00:22:02,600 --> 00:22:06,390

418
00:22:06,390 --> 00:22:08,170
Kessaħ.

419
00:22:08,170 --> 00:22:09,032
Attwalment, iżżomm fuq.

420
00:22:09,032 --> 00:22:09,990
Let me ara dak I jkollhom.

421
00:22:09,990 --> 00:22:13,600

422
00:22:13,600 --> 00:22:18,260
Allura qabel we jsibu rwieħhom post u jiksbu, I
biss trid biex turi li inti guys ftit

423
00:22:18,260 --> 00:22:23,680
dwar kif huwa dinamikament
ittajpjat, li huwa tip ta 'kessaħ.

424
00:22:23,680 --> 00:22:24,450
Għandi dawn kollha.

425
00:22:24,450 --> 00:22:28,160
Għandi bħal erba 'eżempji up here,
u jien inti se tibgħat dan kollu kodiċi

426
00:22:28,160 --> 00:22:30,580
wara klassi.

427
00:22:30,580 --> 00:22:34,440
>> Allura hawnhekk għandna xi varjabbli a.

428
00:22:34,440 --> 00:22:36,500
Li jinsab biss 1 flimkien ma '1, id-dritt?

429
00:22:36,500 --> 00:22:40,930
U aħna qed tmur biex jistampa dak li l-
ugwali għal, u allura għandna xi tip.

430
00:22:40,930 --> 00:22:46,066
U ħadd xi guesses
dwar liema tip li għaddej biex tkun?

431
00:22:46,066 --> 00:22:46,890
>> UDJENZA: An int.

432
00:22:46,890 --> 00:22:48,560
>> ALLISON BUCHHOLTZ-UA: Yeah, huwa ta 'int.

433
00:22:48,560 --> 00:22:49,890
Allura hija biss iżid flimkien.

434
00:22:49,890 --> 00:22:51,671
Huwa ta 'int.

435
00:22:51,671 --> 00:22:52,170
Kollha tajba.

436
00:22:52,170 --> 00:22:56,440

437
00:22:56,440 --> 00:23:05,590
Allura dan wieħed li jmiss, aħna għandna
dak look like kordi.

438
00:23:05,590 --> 00:23:11,000
Meta aħna run dan, jidhirlu, oh.

439
00:23:11,000 --> 00:23:13,720
Int fil-fatt tipprova
biex żid ftit affarijiet.

440
00:23:13,720 --> 00:23:15,140
Inti biss ltqajna konfuż.

441
00:23:15,140 --> 00:23:17,410
Hekk jien biss se jiffissaw dan għalik.

442
00:23:17,410 --> 00:23:18,090
Inti fisser int.

443
00:23:18,090 --> 00:23:19,160
Naf li inti fisser int.

444
00:23:19,160 --> 00:23:25,190
>> Allura dan huwa wieħed mill-modi kif inti tista '
tara, PHP għandu moħħ tal tagħha stess.

445
00:23:25,190 --> 00:23:28,800
Anki jekk aħna espliċitament qal,
tfittex, dawn dawk huma kordi.

446
00:23:28,800 --> 00:23:30,120
I tfisser il-sekwenza waħda.

447
00:23:30,120 --> 00:23:32,160
Iżda huwa jgħid, oh, iżda
inti qed tipprova żidhom,

448
00:23:32,160 --> 00:23:34,460
sabiex inti trid jfissirx integer.

449
00:23:34,460 --> 00:23:35,950
Just trust me fuq dan.

450
00:23:35,950 --> 00:23:38,920
Allura huwa jgħid huwa integer,
u żżid minnhom bħal normali.

451
00:23:38,920 --> 00:23:42,460
Għalhekk tip ta 'kessaħ jekk int ser
biex tikseb għażżien ma 'affarijiet tiegħek,

452
00:23:42,460 --> 00:23:45,470
jew tixtieq iżżid xi ħaġa.

453
00:23:45,470 --> 00:23:48,690
>> A ħaġa kbira hija li, jekk
taħseb lura għal pset2,

454
00:23:48,690 --> 00:23:51,840
xi ħaġa li kienet utent
inputted, id-dritt, li aħna naħsbu

455
00:23:51,840 --> 00:23:54,010
huwa char jew string fl-ewwel.

456
00:23:54,010 --> 00:23:57,950
Issa aħna ma jkollhomx biex espliċitu
jgħidu, oh, dan isir int.

457
00:23:57,950 --> 00:23:59,790
PHP kien biss tkun simili, oh yeah.

458
00:23:59,790 --> 00:24:01,215
Naf li inti fisser int.

459
00:24:01,215 --> 00:24:01,830
Iblah inti.

460
00:24:01,830 --> 00:24:04,640
Inti ma jfissirx string.

461
00:24:04,640 --> 00:24:12,596
>> Allura f'dak il-każ, issa
li għandna dan, liema

462
00:24:12,596 --> 00:24:14,330
Do you guys think li għaddej biex tagħmel hawn?

463
00:24:14,330 --> 00:24:17,220

464
00:24:17,220 --> 00:24:20,495
Għandna string u int issa.

465
00:24:20,495 --> 00:24:21,980
>> UDJENZA: Huwa għadu int.

466
00:24:21,980 --> 00:24:24,040
>> ALLISON BUCHHOLTZ-UA: Huwa għadu int.

467
00:24:24,040 --> 00:24:26,790
U r-raġuni is-- I iqiegħed
aktar eżempji, iżda gost dan wieħed.

468
00:24:26,790 --> 00:24:30,110
Ir-raġuni li qed jagħmel dan hu minħabba
huwa simili inti qed tipprova żżid affarijiet.

469
00:24:30,110 --> 00:24:33,310
Mela jekk inti qed tipprova li jżidu
affarijiet, jien ser tassumi,

470
00:24:33,310 --> 00:24:36,030
raġonevolment, għandek xi ħaġa
raġonevoli li inti tista 'żżid.

471
00:24:36,030 --> 00:24:40,032
Jien biss ser jagħmilha int, u
aħna qed biss se jżidu, bħal tas-soltu.

472
00:24:40,032 --> 00:24:42,240
U allura l-istess mod, I
think inti guys jiksbu l-idea.

473
00:24:42,240 --> 00:24:47,400
Għandna wkoll dan wieħed hawn, li hija
biss jaħraq, u dan ma l-istess ħaġa.

474
00:24:47,400 --> 00:24:49,210
Huwa simili, inti utent iblah.

475
00:24:49,210 --> 00:24:51,400
inti taf li inti tixtieq int.

476
00:24:51,400 --> 00:24:54,491
>> UDJENZA: Jekk nistaqsu ittra, se
dan jagħmlu l-[inaudible] Valur jew le?

477
00:24:54,491 --> 00:24:56,532
ALLISON BUCHHOLTZ-UA: Oh,
li hija mistoqsija tajba.

478
00:24:56,532 --> 00:24:57,518
Ejja naraw.

479
00:24:57,518 --> 00:25:00,480

480
00:25:00,480 --> 00:25:03,430
Nope, xorta huwa int.

481
00:25:03,430 --> 00:25:06,700
Hekk huwa ftit crazy.

482
00:25:06,700 --> 00:25:12,170
Dan huwa biss tip ta 'biex turi li inti PHP
xi kultant jista 'jġib ruħu irrational-- Mhux

483
00:25:12,170 --> 00:25:16,670
totalment irrazzjonali, iżda jista 'jġib ruħu
b'modi li inti ma verament jistennew.

484
00:25:16,670 --> 00:25:18,970
Allura, meta fid-dubju, iċċekkja
it-tipi ta 'affarijiet.

485
00:25:18,970 --> 00:25:22,570
Dan gettype funzjoni
jista 'jkun super utli.

486
00:25:22,570 --> 00:25:26,930
>> Tipikament, jekk int tagħmel xi ħaġa ma '
plusses jew kull operatur matematiċi,

487
00:25:26,930 --> 00:25:32,010
li għaddej biex tassumi xejn
raġonevoli huwa biss int.

488
00:25:32,010 --> 00:25:36,530
Allura, inti għandek char 1, jew
string 1, jew l-int attwali 1,

489
00:25:36,530 --> 00:25:38,200
li għaddej biex jassumi li.

490
00:25:38,200 --> 00:25:41,410
Jekk inti tixtieq li typecast
xejn, inti totalment tista '.

491
00:25:41,410 --> 00:25:46,540
Inti tista 'tagħmel xi ħaġa simili
double hawn, nemmen.

492
00:25:46,540 --> 00:25:50,370

493
00:25:50,370 --> 00:25:53,420
U f'dak il-każ, li għaddej biex jgħidu, oh.

494
00:25:53,420 --> 00:25:56,550
I ser tagħmel dan doppju għaliex
inti espliċitament qal huwa doppju.

495
00:25:56,550 --> 00:26:00,370
Inti tista 'dejjem espliċitament
jagħmlu PHP tagħmel xi ħaġa, iżda.

496
00:26:00,370 --> 00:26:02,174
>> UDJENZA: Stenna, għaliex huwa plus 1 hemmhekk?

497
00:26:02,174 --> 00:26:03,215
>> ALLISON BUCHHOLTZ-UA: Oh.

498
00:26:03,215 --> 00:26:06,512

499
00:26:06,512 --> 00:26:07,490
Hemmhekk.

500
00:26:07,490 --> 00:26:08,400
Kien biss eku.

501
00:26:08,400 --> 00:26:10,820
Li kien tort tiegħi.

502
00:26:10,820 --> 00:26:14,240
Allura, inti tista 'espliċitament għid li
jagħmlu xi ħaġa ta 'ċertu tip,

503
00:26:14,240 --> 00:26:17,980
imma ħafna mill-ħin, li għaddej biex
dinamikament tiddeċiedi li fil runtime.

504
00:26:17,980 --> 00:26:20,730
Allura li għaddej biex iżommu għaddejjin
u li għaddej biex tkun simili, OK.

505
00:26:20,730 --> 00:26:23,229
Dak li jagħmel l-aktar
sens biex dan jiġi?

506
00:26:23,229 --> 00:26:24,520
Jekk ikun fil-fatt tkun string?

507
00:26:24,520 --> 00:26:25,090
Jekk ikun ta 'int?

508
00:26:25,090 --> 00:26:25,770
M'għandha tkun float?

509
00:26:25,770 --> 00:26:26,810
M'għandha tkun doppja?

510
00:26:26,810 --> 00:26:29,456
U se tiddeċiedi li għalik.

511
00:26:29,456 --> 00:26:31,980
>> Inti tista 'seħħ li tagħmel
dak li trid, but--

512
00:26:31,980 --> 00:26:35,032
>> UDJENZA: Does li jagħmluha aktar bil-mod?

513
00:26:35,032 --> 00:26:37,365
ALLISON BUCHHOLTZ-UA: Well,
I mean, C hija effiċjenti ħafna.

514
00:26:37,365 --> 00:26:41,760
Naħseb li huwa definittivament kajman minħabba
hija għandha għall-proċess kif li għaddej.

515
00:26:41,760 --> 00:26:45,200
C, jien kważi ċert huwa aktar mgħaġġel.

516
00:26:45,200 --> 00:26:47,620
Imma ovvjament hemm
ħafna affarijiet jibred fil hawn

517
00:26:47,620 --> 00:26:49,190
li aħna ma jkollhomx għalfejn tinkwieta dwar.

518
00:26:49,190 --> 00:26:50,981
Allura, jekk aħna qed tiftix
permezz ta 'firxa, aħna

519
00:26:50,981 --> 00:26:54,290
ma għandekx biex effettivament joħolqu
xi wħud tfittxija permezz tal-firxa.

520
00:26:54,290 --> 00:26:56,920
Nistgħu staqsi għall-ċavetta
u PHP se jieħu kura ta 'dan.

521
00:26:56,920 --> 00:26:59,510

522
00:26:59,510 --> 00:27:00,630
>> Kessaħ.

523
00:27:00,630 --> 00:27:01,130
Biża.

524
00:27:01,130 --> 00:27:03,937
Qisu l-aħħar ta 'eżempji tiegħi.

525
00:27:03,937 --> 00:27:05,770
Inti guys huma qatt ser
li ninsew li issa.

526
00:27:05,770 --> 00:27:08,450
Inti se tkun simili, oh, PHP huwa biss
bħal dik mom li simili no, no, no.

527
00:27:08,450 --> 00:27:09,325
Naf dak li jfisser.

528
00:27:09,325 --> 00:27:11,000
Naf dak li trid.

529
00:27:11,000 --> 00:27:11,580
OK.

530
00:27:11,580 --> 00:27:15,040
Allura dan huwa, wieħed jittama, utli għall tiegħek
pset, għall-inqas fil-bidu nett,

531
00:27:15,040 --> 00:27:20,290
għaliex inti huma kollha dwar jittrattaw
ma 'forom u l-affarijiet mill-utent.

532
00:27:20,290 --> 00:27:24,460
>> Allura hemm żewġ modi li aħna
jgħaddu madwar info ma PHP u HTML

533
00:27:24,460 --> 00:27:26,700
meta aħna qed tgħaddi
bejn dawn iż-żewġ affarijiet.

534
00:27:26,700 --> 00:27:32,330
Allura aħna għandna $ _GET, li tgħaddi
permezz tal-URL, u għandna $ _POST,

535
00:27:32,330 --> 00:27:36,600
li tgħaddi fil-messaġġ
ġisem, u għalhekk aħna nqisu li hu moħbija.

536
00:27:36,600 --> 00:27:41,660
Iżda ħaġa waħda li jifhem li
la ta 'dawn huma kkunsidrati siguri.

537
00:27:41,660 --> 00:27:45,580
>> Jekk għandek xi ħadd li huwa
interċettazzjoni l-messaġġi sejrin

538
00:27:45,580 --> 00:27:49,180
quddiem u lura bejn inti u l-
server, xorta jistgħu jiksbu din id-data.

539
00:27:49,180 --> 00:27:50,810
Huma sempliċiment għandek tfittex ftit diffiċli.

540
00:27:50,810 --> 00:27:54,690
Mhuwiex verament that-- huwa
biss moħbija mill-URL.

541
00:27:54,690 --> 00:27:58,820
Huwa għadu fil-ġisem messaġġ,
għalkemm, hekk jekk ikollhom aċċess għal dak,

542
00:27:58,820 --> 00:27:59,920
huwa verament ftit like--

543
00:27:59,920 --> 00:28:01,710
>> Huwa bħall-differenza
bejn xi ħaġa

544
00:28:01,710 --> 00:28:05,010
jiġi miktub fuq barra ta '
pakkett u xi ħaġa benesseri

545
00:28:05,010 --> 00:28:06,980
miktub fuq biċċa karta ġewwa.

546
00:28:06,980 --> 00:28:10,270
Mhuwiex li diffiċli biex tiftaħ l-envelop
u jiksbu l-biċċa karta ġewwa.

547
00:28:10,270 --> 00:28:12,414
Mogħtija, huwa d jkun ferm aktar faċli
aqra biss il-barra.

548
00:28:12,414 --> 00:28:14,330
Imma dak li kif inti tista '
tip ta 'jaħsbu minn dawn.

549
00:28:14,330 --> 00:28:16,940
La ta 'dawn huma
verament meqjusa sikuri.

550
00:28:16,940 --> 00:28:17,790
OK?

551
00:28:17,790 --> 00:28:19,750
>> Mogħtija, ma verament
kwistjoni għall pset tiegħek

552
00:28:19,750 --> 00:28:22,050
għaliex int ma jittrattaw
ma sigrieti kummerċjali,

553
00:28:22,050 --> 00:28:25,850
imma hija tipikament waħda
ħaġa li aħna verament

554
00:28:25,850 --> 00:28:29,260
tixtieq tenfasizza għaliex in-nies
think, oh, ukoll, huwa moħbija.

555
00:28:29,260 --> 00:28:30,610
Għandu jkun super sigura.

556
00:28:30,610 --> 00:28:31,140
No

557
00:28:31,140 --> 00:28:32,570
Mhuwiex siguri.

558
00:28:32,570 --> 00:28:35,808
Huwa biss ftit
inqas prekarju, I raden.

559
00:28:35,808 --> 00:28:38,500
Jew unsecure.

560
00:28:38,500 --> 00:28:41,625
>> Allura għandna attwalment ikollhom eżempju.

561
00:28:41,625 --> 00:28:43,500
Kif tafu, I love
jgħallmu aktar b'eżempji.

562
00:28:43,500 --> 00:28:45,070
Inħoss bħal dan jgħin aħjar.

563
00:28:45,070 --> 00:28:49,590
Allura, aħna għandna xi forma sempliċi hawn
li attwalment, jekk inti guys qatt

564
00:28:49,590 --> 00:28:51,940
konfuż dwar PHP,
dan huwa verament żgħir,

565
00:28:51,940 --> 00:28:55,630
iżda php.net huwa attwalment
dokumentazzjoni verament tajba.

566
00:28:55,630 --> 00:28:56,500
I really bhalu.

567
00:28:56,500 --> 00:29:02,900
I kienet qed tuża biex jippreparaw għal din
taqsima, so I jista 'vet għalik.

568
00:29:02,900 --> 00:29:07,760
>> Dan huwa eżempju minnhom
dwar kif $ _POST u $ _GET xogħol.

569
00:29:07,760 --> 00:29:09,970
L-unika differenza
bejn it-tnejn ta 'dawn,

570
00:29:09,970 --> 00:29:13,285
minbarra fejn l-informazzjoni hija
murija, kemm jekk huwa fil-URL

571
00:29:13,285 --> 00:29:16,430
jew fil-ġisem, huwa wkoll
dak il-metodu huwa.

572
00:29:16,430 --> 00:29:21,350
Allura fil-formola tiegħek għall HTML-- Dan
hija forma HTML sempliċi ħafna.

573
00:29:21,350 --> 00:29:22,760
Jista 'xi ħadd tell me dak li tagħmel?

574
00:29:22,760 --> 00:29:29,471

575
00:29:29,471 --> 00:29:30,970
UDJENZA: Staqsi għall-isem tiegħek u l-età.

576
00:29:30,970 --> 00:29:31,230
ALLISON BUCHHOLTZ-UA: Eżattament.

577
00:29:31,230 --> 00:29:33,330
Allura aħna għandna xi azzjonijiet jiffurmaw.

578
00:29:33,330 --> 00:29:36,260
Li tikri us taf huwa xi forma att.

579
00:29:36,260 --> 00:29:39,330
U x'hemm jiġri
huwa, meta aħna hit Issottometti,

580
00:29:39,330 --> 00:29:44,280
li għaddej biex sejħa action.php,
li huwa dak li din hija,

581
00:29:44,280 --> 00:29:47,180
u li għaddej biex hija sejħa
ma 'metodu ta' $ _POST.

582
00:29:47,180 --> 00:29:51,340
Allura f'dan il-każ, tiegħek
informazzjoni hija moħbija.

583
00:29:51,340 --> 00:29:57,020
u huwa biss l-isem tiegħek, xi
tip input imsejħa isem, xi età,

584
00:29:57,020 --> 00:30:01,270
tip input = "test" li aħna wkoll sejħa età.

585
00:30:01,270 --> 00:30:05,110
U allura jekk aħna hit Issottometti,
Issottometti se sejħa action.php.

586
00:30:05,110 --> 00:30:09,800
>> Allura meta aħna attwalment hit Issottometti, aħna
taf li tkun stazzjonati, per se,

587
00:30:09,800 --> 00:30:15,290
u aħna ser attwalment tara dan fil tiegħek
problema jistabbilixxu li nisperaw aħna ser

588
00:30:15,290 --> 00:30:16,760
jiksbu jimxu permezz ftit.

589
00:30:16,760 --> 00:30:21,690
U kull ma qed jagħmel hawnhekk hija POST
xi varjabbli superglobal

590
00:30:21,690 --> 00:30:23,300
li tkellimna dwar matul lecture.

591
00:30:23,300 --> 00:30:30,170
U kif inti tista 'taħseb dwar $ _POST huwa
li huwa biss firxa assoċjattiva.

592
00:30:30,170 --> 00:30:30,960
OK?

593
00:30:30,960 --> 00:30:35,930
Allura dan huwa xi importanza ewlenija, dan
hija xi ewlenin, u tkun xi tkun

594
00:30:35,930 --> 00:30:39,270
l-input utent isir
valur għal kull waħda minn dawk.

595
00:30:39,270 --> 00:30:39,960
OK?

596
00:30:39,960 --> 00:30:47,240
>> Hekk jekk konna biex jiktbu dak li dan array
attwalment dehru qishom dritt wara we

597
00:30:47,240 --> 00:30:56,000
sottomessa l-formola, aħna kieku
jkollhom, dan huwa tagħna $ _POST,

598
00:30:56,000 --> 00:31:04,380
u xi firxa fejn għandna xi isem.

599
00:31:04,380 --> 00:31:17,670
Ejja ngħidu biss aħna ser nagħmlu l-isem tiegħi,
u allura għandna xi età, 21.

600
00:31:17,670 --> 00:31:19,420
Woo.

601
00:31:19,420 --> 00:31:23,550
Allura din hija kollha $ _POST huwa. $ _POST
huwa biss firxa assoċjattiva, OK?

602
00:31:23,550 --> 00:31:24,807
>> Hija biss jgħid, OK.

603
00:31:24,807 --> 00:31:26,890
X'inhuma l-affarijiet konna
talab għal mill-utent?

604
00:31:26,890 --> 00:31:28,889
Liema huma l-varjabbli
li aħna qed tgħaddi madwar

605
00:31:28,889 --> 00:31:30,730
li konna mitluba f'din il-forma?

606
00:31:30,730 --> 00:31:33,830
U allura liema huma l-
valuri assoċjati ma 'dak?

607
00:31:33,830 --> 00:31:38,750
Allura f'dan il-każ, jekk I sottomessi lilha
ma 'isem ta Ally u età ta' 21,

608
00:31:38,750 --> 00:31:40,890
dan huwa dak $ _POST Dehra.

609
00:31:40,890 --> 00:31:41,570
OK?

610
00:31:41,570 --> 00:31:45,150
U dan huwa dak li din
Fajl PHP għandha aċċess għall.

611
00:31:45,150 --> 00:31:46,680
Kull dritt?

612
00:31:46,680 --> 00:31:51,730
>> Allura f'dan il-każ, dan huwa bħad
jkollna xi ħaġa oħra minn firxa tagħna.

613
00:31:51,730 --> 00:31:55,370
Minflok ta 'indiċi fil tagħna
firxa, aħna għandna xi ċavetta.

614
00:31:55,370 --> 00:32:00,790
Allura dan huwa ser jagħti
lili l-valur fil-isem ċavetta.

615
00:32:00,790 --> 00:32:05,400
Allura dan se tkun Ally, u
dan id-dritt hawn huwa ser jagħti lili

616
00:32:05,400 --> 00:32:08,840
il-valur fil $ _POST fejn il-
muftieħ huwa l-età, li se jkun 21.

617
00:32:08,840 --> 00:32:12,541

618
00:32:12,541 --> 00:32:14,290
Inti qed tmur biex tkun
tagħmel dan pjuttost ftit.

619
00:32:14,290 --> 00:32:18,920

620
00:32:18,920 --> 00:32:21,590
Yeah, minn liema parti?

621
00:32:21,590 --> 00:32:24,235
>> UDJENZA: Meta inti kienu
tipponta lejn il-parti t'isfel.

622
00:32:24,235 --> 00:32:25,860
ALLISON BUCHHOLTZ-UA: Din il-parti tal-qiegħ?

623
00:32:25,860 --> 00:32:26,359
OK.

624
00:32:26,359 --> 00:32:31,897
Allura, inti tifhem dan huwa HTML tagħna
forma, u aħna għandna xi metodu $ _POST,

625
00:32:31,897 --> 00:32:32,480
li kwistjonijiet.

626
00:32:32,480 --> 00:32:35,410
Dan jista 'wkoll jkun $ _GET,
iżda għal dan il-għan,

627
00:32:35,410 --> 00:32:36,910
aħna qed biss se ngħid huwa $ _POST.

628
00:32:36,910 --> 00:32:42,700
Meta aħna jissottomettu din il-formola, dan huwa
parti minn fajl PHP li sejjaħ.

629
00:32:42,700 --> 00:32:48,530
Allura dan il-fajl PHP issa se tesegwixxi
minħabba l-informazzjoni mill HTML tagħna

630
00:32:48,530 --> 00:32:49,840
forma.

631
00:32:49,840 --> 00:32:52,670
>> Allura dak li qed jagħmel huwa, meta aħna
hit Issottometti fuq il-formola HTML tagħna,

632
00:32:52,670 --> 00:32:59,220
huwa tgħaddi inti dan superglobal,
li huwa biss firxa assoċjattiva.

633
00:32:59,220 --> 00:33:00,306
Huwa dan.

634
00:33:00,306 --> 00:33:02,840
Huwa biss bħal li tgħaddi dik għall-fajl.

635
00:33:02,840 --> 00:33:04,540
U dak li jgħid hu, OK, hawnhekk $ _POST.

636
00:33:04,540 --> 00:33:05,706
Huwa firxa assoċjattiva tiegħek.

637
00:33:05,706 --> 00:33:07,000
Tagħmel miegħu dak li trid.

638
00:33:07,000 --> 00:33:08,980
U aħna qed tgħid, OK.

639
00:33:08,980 --> 00:33:13,620
Agħtini l-valur fil-isem,
u jagħtu me l-valur fl-età.

640
00:33:13,620 --> 00:33:18,150
>> Allura dawn huma biss ċwievet,
u dan huwa firxa tagħna.

641
00:33:18,150 --> 00:33:19,190
Does li jagħmel sens?

642
00:33:19,190 --> 00:33:19,815
>> UDJENZA: Mhmm.

643
00:33:19,815 --> 00:33:21,266
ALLISON BUCHHOLTZ-UA: biża.

644
00:33:21,266 --> 00:33:24,432
UDJENZA: Jekk għandek terġa 'tissottometti l-
forma ma biss jiktbu fuq id-data?

645
00:33:24,432 --> 00:33:25,557
ALLISON BUCHHOLTZ-UA: Yeah.

646
00:33:25,557 --> 00:33:26,160
Mhmm?

647
00:33:26,160 --> 00:33:30,300
>> UDJENZA: Għaliex għandek
li jiġi speċifikat li huwa ta 'int?

648
00:33:30,300 --> 00:33:34,950
>> ALLISON BUCHHOLTZ-UA: F'dan il-każ, il-
utent huwa biss jisforzaw li din tkun int.

649
00:33:34,950 --> 00:33:35,749
>> UDJENZA: OK.

650
00:33:35,749 --> 00:33:38,540
ALLISON BUCHHOLTZ-UA: I do not know
jekk inti fil-fatt bżonn li,

651
00:33:38,540 --> 00:33:43,850
iżda għall-finijiet tagħhom, huma ddeċidew
li huma riedu li din tkun int.

652
00:33:43,850 --> 00:33:45,590
Huma qed biss typecasting dan.

653
00:33:45,590 --> 00:33:47,760
Forsi dawn qed jużawha bħala
xi ħaġa oħra aktar tard.

654
00:33:47,760 --> 00:33:49,872
Dan huwa biss wieħed snippet.

655
00:33:49,872 --> 00:33:50,372
Iva?

656
00:33:50,372 --> 00:33:57,246
>> UDJENZA: X'jiġri jekk huma ittajpjat
12, T-W-E-L-V-E, għall-età?

657
00:33:57,246 --> 00:33:59,704
ALLISON BUCHHOLTZ-UA: Jekk dawn
ppruvaw tip li bħala int?

658
00:33:59,704 --> 00:34:00,160
UDJENZA: Yeah.

659
00:34:00,160 --> 00:34:02,076
ALLISON BUCHHOLTZ-UA: I
tinsa dak li ma.

660
00:34:02,076 --> 00:34:05,540
Naħseb li tista 'tipprova li jikkonvertu
l-ewwel karattru għal int,

661
00:34:05,540 --> 00:34:11,360
jew jieħdu l-valur u jikkonvertu
dan, imma ninsa eżattament dak li.

662
00:34:11,360 --> 00:34:14,570
Tkun ħaġa gost li tikteb
programm u jippruvaw.

663
00:34:14,570 --> 00:34:16,389
Do linji koppja.

664
00:34:16,389 --> 00:34:21,310
OK, għalhekk dan huwa wieħed mill-prinċipali
affarijiet li int ser tkun qiegħda tagħmel.

665
00:34:21,310 --> 00:34:23,969
Jien ser nisperaw jimxu
permezz ta 'koppja tal-fajls

666
00:34:23,969 --> 00:34:25,260
mill-pset miegħek guys.

667
00:34:25,260 --> 00:34:28,850
Jidher qisu aħna qed tmur biex
jkollhom il-ħin, hekk aħna tista 'tagħmel dan.

668
00:34:28,850 --> 00:34:31,190
>> Imma int ser tkun
tagħmel ħafna affarijiet

669
00:34:31,190 --> 00:34:36,130
bħal dan, fejn int tgħaddi
affarijiet mill-formola HTML

670
00:34:36,130 --> 00:34:42,130
fis din il-formola PHP li se mbagħad
tesegwixxi xi sett ta 'struzzjonijiet

671
00:34:42,130 --> 00:34:44,460
fuq id-data li ġiet ipprovduta.

672
00:34:44,460 --> 00:34:46,864
Dik hija litteralment l-gist ta pset tiegħek.

673
00:34:46,864 --> 00:34:48,130
Yeah.

674
00:34:48,130 --> 00:34:52,040
>> UDJENZA: It-tip = "tippreżenta", li
jagħmel buttuna fuq il-formola HTML.

675
00:34:52,040 --> 00:34:54,280
Hemm mod biex sejħa
li xi ħaġa buttuna?

676
00:34:54,280 --> 00:34:56,040
Allura kieku inti tkun bħall-isem = "tippreżenta"?

677
00:34:56,040 --> 00:34:59,170
Jew huwa li buttuna biss se tkun
vojta dritt issa, għaliex inti biss

678
00:34:59,170 --> 00:35:00,970
tatha tip, ma isem.

679
00:35:00,970 --> 00:35:03,803
>> ALLISON BUCHHOLTZ-UA: Naħseb li huwa
biss se jkunu vojta dritt issa.

680
00:35:03,803 --> 00:35:07,320
Nistgħu definittivament tfittex fil-
pset, għaliex aħna se definittivament

681
00:35:07,320 --> 00:35:10,265
tkun tħares lejn il-
reġistru tip ta 'ħaġa.

682
00:35:10,265 --> 00:35:14,610
Iżda yeah, inti tista 'definittivament tispeċifika
it-test li tixtieq fuq buttuna tiegħek.

683
00:35:14,610 --> 00:35:17,560
OK, hekk SQL.

684
00:35:17,560 --> 00:35:21,880
>> Meta inti qed jixtru u jbiegħu ħażniet,
ikollok bżonn li jżommu rekord ta 'dawk.

685
00:35:21,880 --> 00:35:25,760
Allura l-mod kif aħna qed tmur biex tagħmel dan huwa
ma SQL, li huwa biss database.

686
00:35:25,760 --> 00:35:29,200
Jaħsbu li bħala mejda fejn
int jżommu din l-informazzjoni kollha

687
00:35:29,200 --> 00:35:30,649
dwar l-utenti differenti tiegħek.

688
00:35:30,649 --> 00:35:32,940
U inti guys huma attwalment
se toħloq wieħed minn dawn.

689
00:35:32,940 --> 00:35:34,290
Huwa pretty jibred.

690
00:35:34,290 --> 00:35:38,470
>> U hemm biss erba 'affarijiet ewlenin
li għandek bżonn tkun taf għal dan pset,

691
00:35:38,470 --> 00:35:43,120
u huma aġġornament, sabiex inti
bażikament taġġorna d-data.

692
00:35:43,120 --> 00:35:45,190
Li jassumi li huwa diġà hemmhekk.

693
00:35:45,190 --> 00:35:48,320
Jekk mhuwiex hemmhekk, huwa se
biex hit inti ma żball,

694
00:35:48,320 --> 00:35:51,300
hekk forsi inti tixtieq li jiċċekkjaw.

695
00:35:51,300 --> 00:35:55,882
U int se taġġorna on-- I
għandu actually- I jkollhom il-ħin,

696
00:35:55,882 --> 00:35:57,090
I ser jiktbu koppja ta 'dawn.

697
00:35:57,090 --> 00:36:03,370
I attwalment daré guys a
Koppja ta 'kampjun, jikkmanda SQL sħiħ,

698
00:36:03,370 --> 00:36:06,530
minħabba li dawn huma biss il-prinċipali
dawk, imma int tista jingħaqdu magħhom flimkien.

699
00:36:06,530 --> 00:36:09,780
So I ser tagħmel dan u ser nibgħatlek
li out lilek ma dawn in-noti.

700
00:36:09,780 --> 00:36:14,580
>> Mela jekk inti tixtieq li taġġorna xi ħaġa,
jeħtieġ li għid dak li qed aġġornament

701
00:36:14,580 --> 00:36:16,390
u fejn int aġġornament tiegħu.

702
00:36:16,390 --> 00:36:27,770
Allura kmand SQL tipiku ikun aġġornament
ID fejn xi ħaġa ugwali ħaġa.

703
00:36:27,770 --> 00:36:31,490
Jew bħal indirizz aġġornament
fejn ID ugwali 3,

704
00:36:31,490 --> 00:36:37,040
u dan ikun taġġorna l-qasam indirizz
tal-utent tiegħek li għandu ID ta 'tlieta.

705
00:36:37,040 --> 00:36:37,630
OK?

706
00:36:37,630 --> 00:36:44,300
>> Mela jekk inti tmur biex SQL u w3schools,
huma għandhom eżempji tal-biża.

707
00:36:44,300 --> 00:36:46,880
Fil-fatt, I jista pull
xi up fi ftit.

708
00:36:46,880 --> 00:36:49,810
U mbagħad daħħal fis, int biss
ddaħħal ċerti valuri hemmhekk.

709
00:36:49,810 --> 00:36:56,810
Mela jekk inti qed tipprova toħloq xi ġdida
dħul, hekk int ħolqien ta 'utent ġdid,

710
00:36:56,810 --> 00:37:00,970
inti tista 'tagħmel daħħal fis
tkun xi tkun database tiegħek huwa msejjaħ,

711
00:37:00,970 --> 00:37:03,540
u inti jkollok dawn il-valuri kollha.

712
00:37:03,540 --> 00:37:06,250
>> Imbagħad għandek tagħżel,
tagħżel valuri biex tara.

713
00:37:06,250 --> 00:37:09,640
Mela jekk inti qed tipprova tikkontrolla biex
ara jekk teżisti utent jew int

714
00:37:09,640 --> 00:37:12,030
jippruvaw grab speċifiku
informazzjoni dwar l-utent

715
00:37:12,030 --> 00:37:13,790
int se tkun qed tuża tagħżel.

716
00:37:13,790 --> 00:37:17,564
U imbagħad tħassar, I think,
hija pjuttost sempliċi hemmhekk.

717
00:37:17,564 --> 00:37:19,480
Int biss tħassar
xi ħaġa mit-tabella.

718
00:37:19,480 --> 00:37:25,960
U fil-fatt, let me attwalment pull
up xi eżempji għall inti guys.

719
00:37:25,960 --> 00:37:29,350
Oh ħarsa, huwa paġna tiegħi 61.

720
00:37:29,350 --> 00:37:32,940
>> Hekk jekk immorru w3schools,
nisperaw huwa up again.

721
00:37:32,940 --> 00:37:35,640
Iva, Imħabba tiegħu.

722
00:37:35,640 --> 00:37:37,680
Immorru SQL.

723
00:37:37,680 --> 00:37:39,160
Allura, din hija xi ħaġa hawn.

724
00:37:39,160 --> 00:37:42,548
Allura, dan huwa TAGĦŻEL sempliċi ħafna.

725
00:37:42,548 --> 00:37:45,620
Man, I imħabba din il-funzjoni.

726
00:37:45,620 --> 00:37:50,030
Allura, inti jista 'jkollhom SELECT
f'xi qasam mill-klijenti.

727
00:37:50,030 --> 00:37:55,340
F'dan il-każ, il-klijenti jirreferi għall-
database online li inti qed tuża,

728
00:37:55,340 --> 00:38:00,480
sabiex ikun x'ikun mejda tiegħek huwa msejjaħ, u
star ifisser biss tagħżel kollox.

729
00:38:00,480 --> 00:38:01,710
Agħti me kull wieħed.

730
00:38:01,710 --> 00:38:05,810

731
00:38:05,810 --> 00:38:10,720
>> So, I biss jridu jagħtuk guys a
Koppja ta 'eżempji ta' fejn dan huwa.

732
00:38:10,720 --> 00:38:15,570

733
00:38:15,570 --> 00:38:17,960
Allura aħna għandna SELECT, AĠĠORNAMENT.

734
00:38:17,960 --> 00:38:21,460

735
00:38:21,460 --> 00:38:25,420
Allura hawnhekk huwa tip ta 'l-sintassi ġenerali.

736
00:38:25,420 --> 00:38:31,080
Allura aġġornament, ikun x'ikun tiegħek
isem mejda huwa, u mbagħad stabbiliti

737
00:38:31,080 --> 00:38:35,060
huwa fejn int attwalment għaddejjin
li jkun liema data qed jinbidlu.

738
00:38:35,060 --> 00:38:38,340
Allura dan jista be-- Ħalli
me jagħmlu eżempju hawn.

739
00:38:38,340 --> 00:38:44,146

740
00:38:44,146 --> 00:38:45,145
Allura dan se be--

741
00:38:45,145 --> 00:39:10,250

742
00:39:10,250 --> 00:39:10,750
>> OK.

743
00:39:10,750 --> 00:39:13,585
So I ħolqot database ftit għalina.

744
00:39:13,585 --> 00:39:16,260
Aħna qed tmur biex ikollhom xi ID,
xi sena, u xi jismu.

745
00:39:16,260 --> 00:39:23,022
Allura wieħed ID ser tkun sena '15,
u aħna qed biss jmorru biex jagħmilha me.

746
00:39:23,022 --> 00:39:24,980
Min jixtieq li jkun it-tieni
persuna fit-tabella tagħna?

747
00:39:24,980 --> 00:39:25,480
Kulħadd.

748
00:39:25,480 --> 00:39:28,192

749
00:39:28,192 --> 00:39:30,525
Jien biss ser jagħżlu Emma
minħabba l-isem tiegħek malajr.

750
00:39:30,525 --> 00:39:32,220
Emma, ​​liema sena int?

751
00:39:32,220 --> 00:39:33,180
>> UDJENZA: Liema sena?

752
00:39:33,180 --> 00:39:33,600
>> ALLISON BUCHHOLTZ-UA: Yeah.

753
00:39:33,600 --> 00:39:34,183
>> UDJENZA: '16.

754
00:39:34,183 --> 00:39:35,780
ALLISON BUCHHOLTZ-UA: '16.

755
00:39:35,780 --> 00:39:37,920
Int biss se tkun
guinea pig tiegħi għal-lum.

756
00:39:37,920 --> 00:39:40,490
OK, hekk aħna jkollhom dawn iż-żewġ persuni.

757
00:39:40,490 --> 00:39:42,194
Attwalment, let me tagħmel dan.

758
00:39:42,194 --> 00:39:45,110
Ejja ngħidu I smajt tagħha ħażin, u I
fatt qal hi tal sena iżgħar.

759
00:39:45,110 --> 00:39:46,980
Hi tal '17.

760
00:39:46,980 --> 00:39:50,790
Dak li rridu nagħmlu hawnhekk, jekk aħna
riedu sena Emma taġġorna

761
00:39:50,790 --> 00:39:57,480
li tkun korretta jużaw dik, dak aħna'd
tagħmel huwa aħna'd ngħidu data UPDATE hawn fuq.

762
00:39:57,480 --> 00:40:05,140

763
00:40:05,140 --> 00:40:09,130
>> U dan kollu jista 'jkun fuq linja waħda, iżda
peress li jien ikkompressat għall-ispazju hawn,

764
00:40:09,130 --> 00:40:11,450
Jien ser jikteb hawn.

765
00:40:11,450 --> 00:40:12,740
U rridu li jistabbilixxu.

766
00:40:12,740 --> 00:40:16,770
Allura dan huwa l-tabella aħna qed aġġornament.

767
00:40:16,770 --> 00:40:21,600
SET se tkun liema kolonna jew
liema dejta hija aħna fil-fatt jinbidlu.

768
00:40:21,600 --> 00:40:30,670
Dak li aħna qed jinbidlu hija s-sena, hekk
aħna qed tmur biex ngħid sena SET = 16,

769
00:40:30,670 --> 00:40:39,470
u mbagħad FEJN tgħidilna li utent jew
dak ringiela aħna attwalment aġġornament dan.

770
00:40:39,470 --> 00:40:40,980
>> Għalhekk, fejn?

771
00:40:40,980 --> 00:40:42,600
Għandna żewġ għażliet hawn.

772
00:40:42,600 --> 00:40:43,450
X'inhuma l-tnejn?

773
00:40:43,450 --> 00:40:44,580
Dawn huma uniċi, id-dritt?

774
00:40:44,580 --> 00:40:47,150
Allura ismijiet tagħna huma uniċi
u ID tagħna huwa uniku,

775
00:40:47,150 --> 00:40:50,880
iva, liema huma ż-żewġ għażliet
għal fejn nistgħu nagħmlu dan?

776
00:40:50,880 --> 00:40:51,970
I ser jagħtuk waħda.

777
00:40:51,970 --> 00:40:57,450
Stajna nagħmlu FEJN ID =
2, jew stajna nagħmlu dak

778
00:40:57,450 --> 00:41:00,920
jekk aħna qed tmur off dan paradigma hawn.

779
00:41:00,920 --> 00:41:02,180
>> UDJENZA: [inaudible].

780
00:41:02,180 --> 00:41:03,430
ALLISON BUCHHOLTZ-UA: Eżattament.

781
00:41:03,430 --> 00:41:07,300
Allura nistgħu wkoll tagħmel isem = Emma.

782
00:41:07,300 --> 00:41:10,189

783
00:41:10,189 --> 00:41:11,480
U waħda minn dawn tkun taħdem.

784
00:41:11,480 --> 00:41:14,040
U aħna dam dan, d tkun simili, OK.

785
00:41:14,040 --> 00:41:15,300
Aħna ser jibdlu.

786
00:41:15,300 --> 00:41:17,680
Inti fil-fatt 16, hekk
issa int dritt għal darb'oħra.

787
00:41:17,680 --> 00:41:21,410
OK, għalhekk dan ikun
super utli fil pset tiegħek

788
00:41:21,410 --> 00:41:25,157
fejn forsi xi ħadd iddeċieda
li jixtru 100 ishma ta 'Apple,

789
00:41:25,157 --> 00:41:26,740
u allura dawn kienu simili, biss kidding.

790
00:41:26,740 --> 00:41:28,320
I jridux biss 90-ishma.

791
00:41:28,320 --> 00:41:33,630
U hekk huma jbiegħu 10 minnhom, sabiex inti
bżonn li taġġorna l-ammont ta 'ħażniet

792
00:41:33,630 --> 00:41:34,330
li huma għandhom.

793
00:41:34,330 --> 00:41:39,050
Allura, aġġornament ħażniet, aġġornament tabella.

794
00:41:39,050 --> 00:41:39,950
>> OK.

795
00:41:39,950 --> 00:41:42,710
Allura dak eżempju wieħed hemmhekk.

796
00:41:42,710 --> 00:41:45,131
Dik hija l-sintassi aġġornament.

797
00:41:45,131 --> 00:41:45,630
Ħassar.

798
00:41:45,630 --> 00:41:50,391

799
00:41:50,391 --> 00:41:50,890
Oh.

800
00:41:50,890 --> 00:41:53,580
Daħħal in hija waħda oħra tagħna.

801
00:41:53,580 --> 00:41:57,950
Allura, dan wieħed hawn huwa simili ħafna.

802
00:41:57,950 --> 00:42:00,430
Nistgħu biss jgħidu, f'dan
każ ejja żid xi ħadd.

803
00:42:00,430 --> 00:42:02,310
Nistgħu żid Ben dan iż-żmien.

804
00:42:02,310 --> 00:42:13,300
We do ddaħħal fil, u aħna
jridu li l-isem ta 'tabella tagħna.

805
00:42:13,300 --> 00:42:16,580
F'dan il-każ huwa d-data.

806
00:42:16,580 --> 00:42:25,790
>> U allura aħna biss jixtiequ, int ser
jgħidu VALURI, u dak li int se tagħmel

807
00:42:25,790 --> 00:42:29,147
huwa, inti fil-fatt bżonn tagħmel ċert
li inti għandek xi ħaġa għal kull ringiela

808
00:42:29,147 --> 00:42:29,730
li tixtieq.

809
00:42:29,730 --> 00:42:31,090
Inti biss jpoġġuhom fl-ordni.

810
00:42:31,090 --> 00:42:33,920
Allura f'dan il-każ, aħna ngħid 3.

811
00:42:33,920 --> 00:42:35,280
Inti 18, id-dritt Ben?

812
00:42:35,280 --> 00:42:36,439
>> UDJENZA: 19.

813
00:42:36,439 --> 00:42:37,480
ALLISON BUCHHOLTZ-UA: 19?

814
00:42:37,480 --> 00:42:38,360
UDJENZA: 19.

815
00:42:38,360 --> 00:42:39,943
ALLISON BUCHHOLTZ-UA: '19 sena Tiegħek?

816
00:42:39,943 --> 00:42:41,459
Inti gradwati fil '18, id-dritt?

817
00:42:41,459 --> 00:42:42,000
UDJENZA: Oh.

818
00:42:42,000 --> 00:42:42,870
ALLISON BUCHHOLTZ-UA: sena Gradwazzjoni.

819
00:42:42,870 --> 00:42:43,842
UDJENZA: OK.

820
00:42:43,842 --> 00:42:46,070
ALLISON BUCHHOLTZ-UA:
I kien simili, huma inti

821
00:42:46,070 --> 00:42:48,550
diġà qed jippjanaw li
jieħu sena 'l barra hawn?

822
00:42:48,550 --> 00:42:52,590
Allura, '18, għandna Ben.

823
00:42:52,590 --> 00:43:01,950
Allura f'dan il-każ, ikun jgħaddu,
din kienet toħloq dħul ġdid hawn.

824
00:43:01,950 --> 00:43:04,520

825
00:43:04,520 --> 00:43:05,750
Kessaħ.

826
00:43:05,750 --> 00:43:07,570
Mhux wisq ħażina, right?

827
00:43:07,570 --> 00:43:09,850
A lott ta 'dan se
jkun sintassi għalik guys.

828
00:43:09,850 --> 00:43:13,280
Il-kunċetti għandhom jiġu,
nisperaw, relattivament faċilment.

829
00:43:13,280 --> 00:43:17,270
Is-sintassi hija l-unika ħaġa
li jista 'jkun ftit delikata.

830
00:43:17,270 --> 00:43:20,590
>> U allura l-aħħar wieħed tagħna huwa
Ħassar, u kif tinnota,

831
00:43:20,590 --> 00:43:22,260
I jirrakkomanda ħafna din il-websajt.

832
00:43:22,260 --> 00:43:24,110
Huwa kbir.

833
00:43:24,110 --> 00:43:25,620
Hemm ton ta 'għalf.

834
00:43:25,620 --> 00:43:30,550
Allura, bl-istess mod li kellna
xi jaġġornaw, iħassru huwa simili ħafna.

835
00:43:30,550 --> 00:43:33,800
Minflok għandna Ħassar minn Data.

836
00:43:33,800 --> 00:43:37,506
Allura f'dan il-każ, l-aħħar tagħna
wieħed I ser jikteb hawn.

837
00:43:37,506 --> 00:43:38,880
Ejja ngħidu aħna ried iħassar lili.

838
00:43:38,880 --> 00:43:44,670

839
00:43:44,670 --> 00:43:48,750
I ma tistax tikteb illum.

840
00:43:48,750 --> 00:43:51,720
Ħassar minn liema
tabella aħna qed fil, data.

841
00:43:51,720 --> 00:43:56,160

842
00:43:56,160 --> 00:44:02,128
U fil-fatt hemm tliet modi
nistgħu jagħżlu li jitħassar lili.

843
00:44:02,128 --> 00:44:06,040

844
00:44:06,040 --> 00:44:09,780
>> Tista guys tell me dak il-tlieta
modi huma, kif inti tista 'tħassar me?

845
00:44:09,780 --> 00:44:12,880

846
00:44:12,880 --> 00:44:15,400
ID ugwali 1, fejn ID ugwali 1.

847
00:44:15,400 --> 00:44:19,470
Stajna nagħmlu fejn sena ugwali
15, jew fejn l-isem ugwali Allison.

848
00:44:19,470 --> 00:44:21,540
naturalment, hemm biss
tliet modi differenti,

849
00:44:21,540 --> 00:44:24,570
minħabba li dawn huma kollha uniċi.

850
00:44:24,570 --> 00:44:28,000
Tipikament fit-tabella tiegħek,
u speċjalment fil-pset tiegħek,

851
00:44:28,000 --> 00:44:32,105
int ser sett wieħed ta '
dawn il-kolonni li jkun uniku.

852
00:44:32,105 --> 00:44:36,252
>> Huwa probabbilment se jkun hemm xi ID unika
numru, għaliex jekk inti have-- attwalment,

853
00:44:36,252 --> 00:44:37,710
għandu mnejn attwalment let ikollok tnejn.

854
00:44:37,710 --> 00:44:40,520
I ma tistax tiftakar jekk inneħħu let
għandek żewġ ta 'l-istess ħaġa.

855
00:44:40,520 --> 00:44:42,000
>> UDJENZA: allura
jbiddlu l-imġiba tagħhom.

856
00:44:42,000 --> 00:44:43,291
>> ALLISON BUCHHOLTZ-UA: Ikun.

857
00:44:43,291 --> 00:44:46,280
Hija ser jikkawża mġiba li hija mistennija,
li inti ma tistax verament ibassar.

858
00:44:46,280 --> 00:44:53,040
Allura inti definittivament se jkollhom kolonna waħda
fid-database tiegħek li se tkun unika,

859
00:44:53,040 --> 00:44:55,760
u huwa tipikament inti tista 'tistabbilixxi
hekk li huwa simili ID unika,

860
00:44:55,760 --> 00:44:59,884
u se biss taġġorna kull
ħin li inti daħħal fit-tabella.

861
00:44:59,884 --> 00:45:02,050
Kwalunkwe ħin li inti toħloq ġdid
ringiela, se awtomatikament

862
00:45:02,050 --> 00:45:04,190
inkrement u jagħtuh xi ID unika.

863
00:45:04,190 --> 00:45:05,960
Allura ħjiel għall pset tiegħek.

864
00:45:05,960 --> 00:45:08,560

865
00:45:08,560 --> 00:45:09,160
OK.

866
00:45:09,160 --> 00:45:11,575
B'tali mod li huwa SQL.

867
00:45:11,575 --> 00:45:18,170

868
00:45:18,170 --> 00:45:22,140
>> Allura issa aħna qed tmur biex jitkellmu dwar
l-aħħar ħaġa, li torbot

869
00:45:22,140 --> 00:45:24,770
attwalment pretty ukoll mal tiegħek
pset, jekk dan imur quddiem.

870
00:45:24,770 --> 00:45:28,210
Allura MVC, kontrollur fehma mudell.

871
00:45:28,210 --> 00:45:32,480
Dan huwa verament biss mod
li żżomm affarijiet organizzata.

872
00:45:32,480 --> 00:45:36,910
Bl-istess mod ma 'C aħna nitolbuk guys
biex joħolqu funzjonijiet u affarijiet separati

873
00:45:36,910 --> 00:45:42,350
out, dan huwa biss mod biex tiġi sseparata
kodiċi meta int tagħmel web iżvilupp.

874
00:45:42,350 --> 00:45:46,850
>> Għalhekk jagħmel affarijiet ferm
aktar eleganti u simplifikat,

875
00:45:46,850 --> 00:45:49,310
u dan huwa effettivament il-mod
li pset tiegħek huwa attwalment

876
00:45:49,310 --> 00:45:52,460
twaqqaf, iva jekk inti bhalu
jew le, int ser jitgħallmu,

877
00:45:52,460 --> 00:45:54,251
anki jekk inti ma taħsibx
int tagħlim dan.

878
00:45:54,251 --> 00:45:56,580

879
00:45:56,580 --> 00:46:01,950
U ħaġa waħda hija, tippermetti wkoll li inti biex
tagħmel ħafna aktar bħal kollaborazzjoni utent.

880
00:46:01,950 --> 00:46:05,770
>> Allura meta I ħa CS50, I ma '
websajt għall-proġett finali tiegħi,

881
00:46:05,770 --> 00:46:09,190
u I kien simili, jien ser
jimmaniġġjaw l-għalf database.

882
00:46:09,190 --> 00:46:12,450
I ser tagħmel lura Jittieħed aħħar, u tiegħi
roommate li I kienet qed tieħu magħha

883
00:46:12,450 --> 00:46:14,270
kien artsy ħafna.

884
00:46:14,270 --> 00:46:17,370
Hi ma disinn istadju, u hi
riedu jagħmlu dan kollu pretty.

885
00:46:17,370 --> 00:46:18,435
Hekk jien simili, OK.

886
00:46:18,435 --> 00:46:20,310
Inti tista 'tieħu kura ta'
l-għalf tarf ta 'quddiem.

887
00:46:20,310 --> 00:46:22,660
>> U l-ħaġa hija, bħala
Ser naraw malajr ħafna,

888
00:46:22,660 --> 00:46:26,130
dak il-kontrollur fehma mudell ihallik
kompletament separati li kodiċi sabiex

889
00:46:26,130 --> 00:46:29,260
li I jistgħu jaħdmu fuq
implimentazzjoni paġni tagħna,

890
00:46:29,260 --> 00:46:31,266
u l-informazzjoni timmanipula
fid-databases tagħna,

891
00:46:31,266 --> 00:46:34,140
u hi tista 'biss tagħmel affarijiet
pretty, u konna tnejn verament kuntenta,

892
00:46:34,140 --> 00:46:36,750
għaliex aħna ltqajna biex jagħmlu dak
aħna kemm riedu u aħna

893
00:46:36,750 --> 00:46:38,400
ma jkollhomx għalfejn jinnegozjaw ma 'l-ieħor.

894
00:46:38,400 --> 00:46:40,377
>> Allura aħna mdendla flimkien.

895
00:46:40,377 --> 00:46:41,210
Aħna nixtiequ li hang out.

896
00:46:41,210 --> 00:46:45,649
I biss ma riedx li jittrattaw
l-CSS u l-għalf HTML.

897
00:46:45,649 --> 00:46:46,940
I kien simili, inti tagħmel dan pretty.

898
00:46:46,940 --> 00:46:49,420
I ser jittrattaw mad-database.

899
00:46:49,420 --> 00:46:52,620
Allura aħna għandna dan verament
jibred, ftit mejda kbira.

900
00:46:52,620 --> 00:46:55,440
I love tabelli.

901
00:46:55,440 --> 00:46:59,680
U bażikament, il-mudell inti tista
jaħsbu dwar huwa biss database tiegħek.

902
00:46:59,680 --> 00:47:03,630
>> I kien l-persuna mudell għall-proġett tiegħi.

903
00:47:03,630 --> 00:47:06,800
Dan kollu dwar il-ħażna ta '
informazzjoni u l-organizzazzjoni li d-data.

904
00:47:06,800 --> 00:47:09,790
Allura huwa dak li aħna simili għal sejħa lura aħħar.

905
00:47:09,790 --> 00:47:13,260
Allura inti guys se jkunu jittrattaw
database SQL u l-fajls tad-data.

906
00:47:13,260 --> 00:47:14,650
C'est mudell tiegħek.

907
00:47:14,650 --> 00:47:17,800
>> Fehma tiegħek, kif inti tista '
think, tip ta 'jagħmel sens,

908
00:47:17,800 --> 00:47:20,610
huwa dak l-utent tiegħek attwalment jara.

909
00:47:20,610 --> 00:47:22,110
Hu l-user interface.

910
00:47:22,110 --> 00:47:24,359
Huwa dak front tiffaċċja komponent.

911
00:47:24,359 --> 00:47:26,650
Allura dak hu roommate tiegħi
ltqajna biex jaħdmu fuq il-ħin kollu.

912
00:47:26,650 --> 00:47:27,660
Hija kienet super kuntenti.

913
00:47:27,660 --> 00:47:31,580
Allura li kollox tal-HTML,
u hemm ftit li xejn PHP.

914
00:47:31,580 --> 00:47:34,420
>> Jekk int biss jitkellem dwar
dak li qed murija lill-utent,

915
00:47:34,420 --> 00:47:36,576
aħna qed jitkellem dwar Portugues.

916
00:47:36,576 --> 00:47:37,950
Aħna qed jitkellem dwar kif jidher.

917
00:47:37,950 --> 00:47:41,400
Aħna ma jitkellem dwar il-loġika,
jew kondizzjonijiet, jew whatnot.

918
00:47:41,400 --> 00:47:45,620
Kollha ta 'dak gets mmaniġġjati
mill-kontrollur, OK?

919
00:47:45,620 --> 00:47:49,470
Allura li mankijiet-talbiet utent
u gets l-informazzjoni.

920
00:47:49,470 --> 00:47:54,750
>> Allura ħaġa waħda għandek tkun taf dwar
pset tiegħek hija li, fil-fehma tiegħek,

921
00:47:54,750 --> 00:47:57,650
xi ħaġa li huwa attwalment
informazzjoni wiri

922
00:47:57,650 --> 00:48:00,530
għandhom qatt ikunu jagħmlu
jitlob lill-mudell tiegħek.

923
00:48:00,530 --> 00:48:02,570
Kollha ta 'li huwa mmaniġġjat
fil kontrollur tiegħek.

924
00:48:02,570 --> 00:48:06,950
Kontrollur tiegħek hi l-waħda
medjazzjoni bejn dawn iż-żewġ.

925
00:48:06,950 --> 00:48:10,280
Hija se titlob lill-mudell
għal ċerta informazzjoni.

926
00:48:10,280 --> 00:48:12,610
Hija tista 'jtenni fuq dik
informazzjoni, insemmu

927
00:48:12,610 --> 00:48:15,110
dak li inti fil-fatt bżonn minn
dan, x'għandek tagħmel magħha,

928
00:48:15,110 --> 00:48:17,860
u mbagħad se jgħaddu fuq
biss l-informazzjoni li inti

929
00:48:17,860 --> 00:48:24,670
bżonn għall-fehma għalik biex jistampaw
jew juru lill-utent, OK?

930
00:48:24,670 --> 00:48:28,690
>> Għaliex aħna tara l-opinjoni bħala
x'ikun qed tiffaċċja l-utent,

931
00:48:28,690 --> 00:48:31,340
u għalhekk se jkun ferm aktar faċli
għalihom biex insemmu,

932
00:48:31,340 --> 00:48:34,980
oh, jekk int tagħmel
xi sejħa biex mudell tiegħek

933
00:48:34,980 --> 00:48:39,152
u inti qed tistaqsi għall-utenti kollha
li jibdew bl-ittra A,

934
00:48:39,152 --> 00:48:41,985
u qed tagħmel li fil-fehma tiegħek,
kulmin jista ara l-paġna web tiegħek

935
00:48:41,985 --> 00:48:43,350
tista 'potenzjalment jidħlu f'dik.

936
00:48:43,350 --> 00:48:44,740
>> Inti ma neċessarjament jixtiequ li.

937
00:48:44,740 --> 00:48:48,560
Inti ma tridx nies biex jaraw
aktar fid-database minn dak

938
00:48:48,560 --> 00:48:49,800
dawn għandhom jiġu jaraw.

939
00:48:49,800 --> 00:48:51,560
Just preferenzi speċifiċi tagħhom.

940
00:48:51,560 --> 00:48:53,840
Allura l-kontrollur mankijiet kollha ta 'dak.

941
00:48:53,840 --> 00:48:59,800
Allura kollha ta 'fajls PHP tiegħek li aħna ser tara
inti tista 'tikkunsidra fajls kontrollur tiegħek.

942
00:48:59,800 --> 00:49:02,710
U li fejn int
verament se jkun

943
00:49:02,710 --> 00:49:06,500
titlob għall-affarijiet mid-database tiegħek,
u mtennija jew timmanipula

944
00:49:06,500 --> 00:49:10,670
bħala meħtieġa qabel
jgħaddiha lill jitqiesu.

945
00:49:10,670 --> 00:49:12,830
>> Huwa pset verament jibred, fl-opinjoni tiegħi.

946
00:49:12,830 --> 00:49:15,580
Naħseb li huwa ftit aktar
bħal gratification instant,

947
00:49:15,580 --> 00:49:17,990
għaliex inti jimplimentaw
ħafna affarijiet ftit żgħira,

948
00:49:17,990 --> 00:49:20,250
u kull ħaġa għandha taħdem fuq tagħha stess.

949
00:49:20,250 --> 00:49:24,180
Ma simili, tagħmel dak kollu
u mbagħad tara jekk din taħdem.

950
00:49:24,180 --> 00:49:26,570
Bħal ma 'softwer
fejn int simili, jien

951
00:49:26,570 --> 00:49:28,910
verament bit-tama li dan huwa
dritt, għaliex jekk mhuwiex,

952
00:49:28,910 --> 00:49:30,743
hemm ħafna ta '
jpoġġih jista 'jkun żbaljat.

953
00:49:30,743 --> 00:49:34,220

954
00:49:34,220 --> 00:49:35,110
>> Kull dritt.

955
00:49:35,110 --> 00:49:39,744
Just jagħmlu ċert li għidt
kollox I meħtieġa biex jgħidu dwar MVC.

956
00:49:39,744 --> 00:49:40,680
Yeah.

957
00:49:40,680 --> 00:49:41,347
Kessaħ.

958
00:49:41,347 --> 00:49:47,340
>> Allura fil CS50 Finanzi, għandna
mudell tagħna, kif I biss qal hawn.

959
00:49:47,340 --> 00:49:51,810
Li għaddej biex tkun MySQL u phpMyAdmin.

960
00:49:51,810 --> 00:49:55,130
I definittivament jistgħu pull dawk up so
inti guys jiksbu opportunità li tħares lejn din.

961
00:49:55,130 --> 00:49:59,250
Like I said qabel, dan SQL tiegħek
database taġixxi bħala mudell tiegħek,

962
00:49:59,250 --> 00:50:03,600
u inti tista 'tibgħat nsejħu mistoqsijiet,
li huma biss dawn it-tipi ta 'affarijiet.

963
00:50:03,600 --> 00:50:04,914
Dawn huma msejħa query.

964
00:50:04,914 --> 00:50:07,830
Din hija mistoqsija, fejn int biss
tistaqsi database tiegħek għal xi ħaġa,

965
00:50:07,830 --> 00:50:09,810
jew int jinbidlu tiegħek
database b'xi mod.

966
00:50:09,810 --> 00:50:11,470
Li kollox huwa.

967
00:50:11,470 --> 00:50:16,040
U inti tagħmel dan ma 'l-
funzjonijiet konna tak hawn.

968
00:50:16,040 --> 00:50:20,500
>> Inti tista 'wkoll timmanipola
bl-idejn permezz phpMyAdmin,

969
00:50:20,500 --> 00:50:22,170
li nistgħu definittivament tagħti ħarsa lejn.

970
00:50:22,170 --> 00:50:25,160
I ser toħloq kampjun
database miegħek guys.

971
00:50:25,160 --> 00:50:25,660
OK.

972
00:50:25,660 --> 00:50:26,680
Allura, kontrollur.

973
00:50:26,680 --> 00:50:30,730
Allura f'dan il-każ, jekk inti
avviż, din hija kollha PHP.

974
00:50:30,730 --> 00:50:33,430
Avviż li tip ta 'tiegħek
ħaġa prinċipali ta 'kontrollur tiegħek

975
00:50:33,430 --> 00:50:35,410
huwa li għandu jkun l-aktar PHP.

976
00:50:35,410 --> 00:50:39,590
Jekk għandek HTML fil kontrollur tiegħek,
mhux verament ċert x'inhu għaddej hemmhekk.

977
00:50:39,590 --> 00:50:42,495
Bl-istess mod kif għidt, jekk inti
jirnexxilhom [inaudible] ma HTML,

978
00:50:42,495 --> 00:50:43,810
Jien interessat reali.

979
00:50:43,810 --> 00:50:49,150
>> Allura dak li għandna hawnhekk
huwa inti jkollok xi mistoqsija.

980
00:50:49,150 --> 00:50:53,700
Mistoqsija hija funzjoni li
aħna mibnija għalik guys.

981
00:50:53,700 --> 00:50:56,935
Huwa simili ppakkjar li jagħmlu mistoqsijiet
għad-database tiegħek ftit aktar faċli.

982
00:50:56,935 --> 00:51:01,441
Jekk inti ma kellhiex dak, l-sintassi għall
attwalment tkellem lil database SQL tiegħek

983
00:51:01,441 --> 00:51:03,690
ikun differenti, hekk aħna
biss jipprovdiha għalik guys.

984
00:51:03,690 --> 00:51:05,490
Aħna nixtiequ li jagħmlu l-ħajja faċli.

985
00:51:05,490 --> 00:51:09,050
>> Allura f'dan il-każ, jista 'inti guys
tell me dak li din il-linja qed tagħmel?

986
00:51:09,050 --> 00:51:11,860

987
00:51:11,860 --> 00:51:13,487
SELECT * minn xi tabella.

988
00:51:13,487 --> 00:51:15,320
UDJENZA: Agħżel
kollox minn din it-tabella.

989
00:51:15,320 --> 00:51:16,570
ALLISON BUCHHOLTZ-UA: Eżattament.

990
00:51:16,570 --> 00:51:18,750
Allura huwa qal, agħti lili
kollox minn din it-tabella.

991
00:51:18,750 --> 00:51:22,430
U huwa maħżuna fil
xi riżultat varjabbli.

992
00:51:22,430 --> 00:51:27,720
U dan jgħid, jekk riżultat mhuwiex ugwali
biex falza, allura nagħmlu kull ta 'dan.

993
00:51:27,720 --> 00:51:32,390
Hekk jekk hemm xejn hawn, jekk tiegħek
tal vojta mejda jew hija biss ma teżistix,

994
00:51:32,390 --> 00:51:33,640
li għaddej biex jirritorna falza.

995
00:51:33,640 --> 00:51:36,431
Allura f'dan il-każ, aħna qed biss tagħmel
żgur li xi ħaġa kien effettivament

996
00:51:36,431 --> 00:51:37,520
lura lilna.

997
00:51:37,520 --> 00:51:40,070
>> U allura hawnhekk, għandna
loop tagħna foreach kbir

998
00:51:40,070 --> 00:51:44,380
li aħna qed jiġu mtennija fuq tagħna
riżultat, u aħna qed ssejjaħ dan ringiela,

999
00:51:44,380 --> 00:51:51,080
u aħna ngħidu jirrendu din it-template
fejn id-data tiegħek huwa dan ir-riżultat.

1000
00:51:51,080 --> 00:51:52,170
OK?

1001
00:51:52,170 --> 00:51:54,440
Allura huwa biss l-ipproċessar
il-filliera tar-riżultat.

1002
00:51:54,440 --> 00:51:56,790
Inkella, dan yells.

1003
00:51:56,790 --> 00:51:59,770
Allura, dan huwa eżempju
tal-kontrollur.

1004
00:51:59,770 --> 00:52:02,842
Kif qed taraw, dan huwa l-
place-- biss Yeah, sorry?

1005
00:52:02,842 --> 00:52:04,960
>> UDJENZA: Għaliex hemm
l ampersand qabel ringiela?

1006
00:52:04,960 --> 00:52:07,000
>> ALLISON BUCHHOLTZ-UA:
An ampersand qabel ringiela.

1007
00:52:07,000 --> 00:52:11,000
Aħna biss mtennija.

1008
00:52:11,000 --> 00:52:13,490
Li wkoll l-indirizz of--

1009
00:52:13,490 --> 00:52:16,400
>> UDJENZA: Allura huwa simili referenzar C.

1010
00:52:16,400 --> 00:52:22,080
>> ALLISON BUCHHOLTZ-UA: Huwa
jagħmlu ċert li int attwalment

1011
00:52:22,080 --> 00:52:24,730
timmodifika l-oriġinali u mhux kopja.

1012
00:52:24,730 --> 00:52:28,580
Huwa bl-istess mod ma 'C fejn
aħna qed tgħaddi permezz ta 'referenza hawn, biss

1013
00:52:28,580 --> 00:52:30,449
tagħmel żgur.

1014
00:52:30,449 --> 00:52:33,530
>> UDJENZA: Huwa mhux ==
minflok ma = fil-PHP?

1015
00:52:33,530 --> 00:52:35,400
>> ALLISON BUCHHOLTZ-UA: Mhuwiex l-==.

1016
00:52:35,400 --> 00:52:37,240
>> UDJENZA: Minħabba ugwali fis-C huwa just--

1017
00:52:37,240 --> 00:52:37,970
>> ALLISON BUCHHOLTZ-UA: Huwa biss mhux =.

1018
00:52:37,970 --> 00:52:38,470
Yeah, no.

1019
00:52:38,470 --> 00:52:39,656
Mhuwiex ==.

1020
00:52:39,656 --> 00:52:45,610
Minħabba == fil-PHP kontrolli għal
ugwaljanza ma toggling, mogħtija,

1021
00:52:45,610 --> 00:52:47,650
iżda l-kwalità extra.

1022
00:52:47,650 --> 00:52:51,050
Allura, mhuwiex == fil-PHP.

1023
00:52:51,050 --> 00:52:53,025
Huwa wieħed mill-ftit
differenzi sintassi.

1024
00:52:53,025 --> 00:52:55,330

1025
00:52:55,330 --> 00:52:55,830
Yeah.

1026
00:52:55,830 --> 00:52:57,538
Allura aħna qed biss mtennija
permezz ta 'kull ringiela,

1027
00:52:57,538 --> 00:53:00,850
u jirrendi, jekk inti guys
tinqara permezz spec tiegħek,

1028
00:53:00,850 --> 00:53:05,360
huwa biss xi funzjoni oħra li hija
attwalment għaddejjin biex jipproċessaw l-HTML

1029
00:53:05,360 --> 00:53:09,760
u l-wiri fil tiegħek
web browser għalik.

1030
00:53:09,760 --> 00:53:10,610
>> OK.

1031
00:53:10,610 --> 00:53:15,360
Allura, aħna simili biex jaħsbu ta 'kontrolluri tiegħek
bħal dak li juża l-loġika tan-negozju.

1032
00:53:15,360 --> 00:53:18,550
Kif qed taraw hawn, dan huwa fejn aħna qed
teħid ta 'data tagħna mit-tabella,

1033
00:53:18,550 --> 00:53:23,530
aħna ipproċessar li b'xi mod,
u allura aħna qed tgħaddi off.

1034
00:53:23,530 --> 00:53:27,930
Meta nagħmlu jirrendu xi template,
xi template hija fehma tagħna,

1035
00:53:27,930 --> 00:53:31,810
u aħna qed jgħaddiha biss
id-data li għandha tikseb.

1036
00:53:31,810 --> 00:53:33,340
Mhux id-data kollha.

1037
00:53:33,340 --> 00:53:35,340
Biss l-informazzjoni li aħna rridu li tikseb.

1038
00:53:35,340 --> 00:53:37,520
OK?

1039
00:53:37,520 --> 00:53:40,270
Bażikament id-data wara l-ipproċessar.

1040
00:53:40,270 --> 00:53:44,780
>> Allura dan huwa tal-fehma, dan huwa
il-mudell somma li għandna,

1041
00:53:44,780 --> 00:53:49,810
u dan kollu qed tagħmel jiġifieri, inti tista '
jkollhom PHP ftit fil-fehma tiegħek.

1042
00:53:49,810 --> 00:53:52,620
Mhuwiex simili no PHP fil-fehma.

1043
00:53:52,620 --> 00:53:55,650
Għandek sempliċiment għandek
ħafna PHP minima fid-dawl,

1044
00:53:55,650 --> 00:53:58,860
u int qatt ma għandhom ikunu
juri dubji fil-fehma tiegħek.

1045
00:53:58,860 --> 00:54:01,580
Inti qatt ma għandhom jiġu jitkellem
għad-database tiegħek fil-fehma tiegħek.

1046
00:54:01,580 --> 00:54:02,760
Dik hija d-differenza kbira.

1047
00:54:02,760 --> 00:54:07,886
>> Allura x'inhu għaddej hawnhekk huwa, għandna
PHP thats mtennija permezz tal-filliera.

1048
00:54:07,886 --> 00:54:10,260
Allura f'dan il-każ, peress li aħna kienu
mtennija permezz ta 'kull ringiela

1049
00:54:10,260 --> 00:54:14,370
u tirrendi xi ħaġa, dan kien
probabbilment bħal żewġ firxa dimensjonali

1050
00:54:14,370 --> 00:54:18,240
fejn għandna xi ringiela li
hija, fiha nnifisha, firxa,

1051
00:54:18,240 --> 00:54:20,520
għaliex aħna qed jiġu mtennija
permezz ta 'dan mill-ġdid.

1052
00:54:20,520 --> 00:54:26,730
U aħna qed biss istampar out
l-isem ringiela, mbagħad jispiċċaw dan.

1053
00:54:26,730 --> 00:54:28,470
>> Inti m'għandekx bżonn dan fil-foreach.

1054
00:54:28,470 --> 00:54:30,560
Stajt qatt li qabel attwalment.

1055
00:54:30,560 --> 00:54:33,160
I biss do foreach.

1056
00:54:33,160 --> 00:54:35,140
OK, b'tali mod li l-opinjoni.

1057
00:54:35,140 --> 00:54:40,170
Ejja naraw jekk nistgħu jimxu permezz
xi ftit ta 'pset tiegħek.

1058
00:54:40,170 --> 00:54:45,380
Għandna 15 minuta, hekk jien ċert li inti
guys tixtieq li aktar minn sempliċiment

1059
00:54:45,380 --> 00:54:45,935
jispiċċa kmieni.

1060
00:54:45,935 --> 00:54:48,980

1061
00:54:48,980 --> 00:54:52,680
Let me ara jekk I tista 'ġġib dan up.

1062
00:54:52,680 --> 00:54:57,130
>> So I do not know kif ħafna minnkom guys
niżżilt u għadhom whatnot,

1063
00:54:57,130 --> 00:55:00,660
iżda aħna għandna username hawn,
u aħna għandna xi password.

1064
00:55:00,660 --> 00:55:05,310
U sfortunatament, id-dritt
issa l-database hija vojta,

1065
00:55:05,310 --> 00:55:10,390
hekk aħna attwalment ħtieġa
li tinħoloq database.

1066
00:55:10,390 --> 00:55:13,470
Ukoll, li stramb.

1067
00:55:13,470 --> 00:55:14,450
Ma jistennew li.

1068
00:55:14,450 --> 00:55:15,375
Żbalji tekniċi.

1069
00:55:15,375 --> 00:55:17,139
Diffikultajiet tekniċi.

1070
00:55:17,139 --> 00:55:17,930
Għandna xi pset7.

1071
00:55:17,930 --> 00:55:22,470

1072
00:55:22,470 --> 00:55:23,180
Kessaħ.

1073
00:55:23,180 --> 00:55:29,660
>> Allura, ħaġa waħda inti tista 'tagħmel huwa, ma
a query-- I ser tinħoloq tabella.

1074
00:55:29,660 --> 00:55:38,570
Allura dan se jkun users-- liema
inti tista 'tagħmel hawn jiġifieri, jekk ikollna some--

1075
00:55:38,570 --> 00:55:39,830
Really issa?

1076
00:55:39,830 --> 00:55:40,330
OK.

1077
00:55:40,330 --> 00:55:44,510
Ovvjament jien ma nagħmilx hekk hot.

1078
00:55:44,510 --> 00:55:45,010
Oh.

1079
00:55:45,010 --> 00:55:45,740
Naf għaliex.

1080
00:55:45,740 --> 00:55:49,070
Minħabba I qatt maħluqa
tabelli attwali tiegħi.

1081
00:55:49,070 --> 00:55:52,400
Allura meta inti l-ewwel tibda bil
database, inti ovvjament

1082
00:55:52,400 --> 00:55:56,550
għandek tiddeċiedi liema huma l-
affarijiet I bżonn li jkollhom fil hawn?

1083
00:55:56,550 --> 00:56:00,850
>> Hekk jekk aħna biss jmorru off
tabella tad-data tagħna hawn,

1084
00:56:00,850 --> 00:56:06,410
kellna xi ID, li
tista 'biss tissospendi l int.

1085
00:56:06,410 --> 00:56:12,460
U jekk inħarsu hawn fuq, hemm
ħaġa jibred that-- indiċi So.

1086
00:56:12,460 --> 00:56:18,060
Jekk inti tagħmel primarja, dan jagħmilha l-
ħaġa li mejda tiegħek hija organizzata minn,

1087
00:56:18,060 --> 00:56:19,410
u wkoll se jagħmilha unika.

1088
00:56:19,410 --> 00:56:25,790
Allura f'dan il-każ, aħna ser jagħmilha primarja,
u jien ser jagħmlu dan l-isem,

1089
00:56:25,790 --> 00:56:34,500
allura aħna ser biss jagħmilha varchar
ta 'prodotti simili 26 ittri, għaliex għaliex le?

1090
00:56:34,500 --> 00:56:39,060
>> U allura inti tista 'tmur għall Save, u mbagħad
jekk tara, aħna għandna xi utenti hawn.

1091
00:56:39,060 --> 00:56:42,950
Hekk jekk ridna li tagħmel
daħħal, stajna nagħmlu dan

1092
00:56:42,950 --> 00:56:51,807
B'dan il-mod, jew jekk int riedu prattika
bil tiegħek queries-- Oh boy.

1093
00:56:51,807 --> 00:56:53,140
I ma jkunux użati dan għal dejjem.

1094
00:56:53,140 --> 00:56:53,980
Nieħu din lura.

1095
00:56:53,980 --> 00:56:57,620

1096
00:56:57,620 --> 00:57:04,030
>> Inti tista 'editjar dan fuq tiegħek jew
biss billi manwalment ddaħħal informazzjoni

1097
00:57:04,030 --> 00:57:08,270
ma 'xi ħaġa simili, inti
tista 'tibdel kwalunkwe minn dawn

1098
00:57:08,270 --> 00:57:13,730
jekk int riedu make-- Jekk inti tixtieq li
f'daqqa jeħles isem, inti tista 'qatra,

1099
00:57:13,730 --> 00:57:15,220
inti tista 'tagħmel dawk kollha affarijiet.

1100
00:57:15,220 --> 00:57:17,560
Jekk għandek bżonn biex qatt
manwalment bidla mejda tiegħek,

1101
00:57:17,560 --> 00:57:20,200
Nissuġġerixxi tagħmel dan fil
phpMyAdmin versus jippruvaw

1102
00:57:20,200 --> 00:57:24,475
biex insemmu l-SQL
mistoqsijiet b'mod ġenerali.

1103
00:57:24,475 --> 00:57:27,350
Meta inti l-ewwel tibda pset tiegħek,
int ser jkollhom jaħdmu fil hawn,

1104
00:57:27,350 --> 00:57:29,650
hekk jidraw dan.

1105
00:57:29,650 --> 00:57:35,650
U mbagħad meta inti fil-fatt tixtieq
li daħħal l-affarijiet fis table-- tiegħek

1106
00:57:35,650 --> 00:57:38,310
I really wonder fejn dan huwa,
għaliex there's-- Hawnhekk huwa.

1107
00:57:38,310 --> 00:57:39,310
Dan huwa dak li ridt.

1108
00:57:39,310 --> 00:57:44,320
Mela jekk inti tmur biex SQL, inti tista
attwalment ara, kif naraw hawn,

1109
00:57:44,320 --> 00:57:45,870
għandna mistoqsijiet SQL.

1110
00:57:45,870 --> 00:57:54,100
>> Hekk jekk ridna li tagħżel xi ħaġa
jew jekk ridna li daħħal xi ħaġa,

1111
00:57:54,100 --> 00:58:00,320
nistgħu nagħmlu daħħal fis-utenti, id-dritt?

1112
00:58:00,320 --> 00:58:04,460

1113
00:58:04,460 --> 00:58:07,230
Naħseb li għandek bżonn l-backslash.

1114
00:58:07,230 --> 00:58:10,210
Ħaġa waħda li tkun taf, jekk
inti qed qatt tuża dan,

1115
00:58:10,210 --> 00:58:14,800
inti għandek tuża dawn lura
apostrophes, li huma tipikament,

1116
00:58:14,800 --> 00:58:16,790
jekk int fuq Mac, dritt fuq tab.

1117
00:58:16,790 --> 00:58:17,840
Allura ħaġa tajba li tkun taf.

1118
00:58:17,840 --> 00:58:23,330
>> Inti tista 'daħħal fis utenti,
u għandna l-valuri tagħna, id-dritt?

1119
00:58:23,330 --> 00:58:29,700
Allura aħna għandhom valuri, u l-valuri tagħna
f'dan il-każ ikun biss,

1120
00:58:29,700 --> 00:58:33,910
aħna biss ikollhom ID hekk aħna
tista 'tagħmel wieħed jekk ridna.

1121
00:58:33,910 --> 00:58:35,320
C'est stramb.

1122
00:58:35,320 --> 00:58:36,730
OK.

1123
00:58:36,730 --> 00:58:41,800
Allura dak biss bħal fil-qosor
ftit ħaġa ma SQL,

1124
00:58:41,800 --> 00:58:48,300
iżda jista 'jkun aktar utli li fil-fatt
ħarsa lejn uħud mill-fajls fil hawn.

1125
00:58:48,300 --> 00:58:50,985
>> Allura jmorru għall Downloads.

1126
00:58:50,985 --> 00:58:51,950
Oh, mhux Downloads.

1127
00:58:51,950 --> 00:58:55,260

1128
00:58:55,260 --> 00:58:58,690
Allura, biss walkthrough malajr ta '
x'hemm f'kull wieħed minn dawn folders.

1129
00:58:58,690 --> 00:59:03,090
Dan jinkludi, aħna biss għandhom affarijiet
li kkonfigurat browser tiegħek,

1130
00:59:03,090 --> 00:59:05,370
għandna dawn kostanti,
u għandna dawn il-funzjonijiet.

1131
00:59:05,370 --> 00:59:10,470
Jekk int interessat fi kwalunkwe wieħed minnhom,
I jirrakkomandaw tħares lejn funzjonijiet.

1132
00:59:10,470 --> 00:59:17,400
Wieħed minnhom li huwa super utli,
attwalment huwa dan wieħed hawn, dump.

1133
00:59:17,400 --> 00:59:20,020
>> Mela jekk inti tuża din,
li se attwalment biss

1134
00:59:20,020 --> 00:59:23,120
jistampa kwalunkwe varjabbli
li tixtieq li.

1135
00:59:23,120 --> 00:59:29,000
Mela jekk qed ikollok trouble jidhru
out dak li dan array Dehra,

1136
00:59:29,000 --> 00:59:31,920
jew dak li din id-data fil-fatt,
kif huwa formattjati,

1137
00:59:31,920 --> 00:59:33,280
din hija ħaġa kbira għall-użu.

1138
00:59:33,280 --> 00:59:39,889
Speċjalment meta jkollok
utent b'ħażna multipla,

1139
00:59:39,889 --> 00:59:41,680
dan se jkun
xi ħaġa kbira għall-użu.

1140
00:59:41,680 --> 00:59:42,890
Minħabba li jista 'jkun formatted--

1141
00:59:42,890 --> 00:59:45,806
>> Naf inqas għalija meta I did
dan pset, kien formattjati b'mod

1142
00:59:45,806 --> 00:59:47,210
li jien ma pjuttost jistennew.

1143
00:59:47,210 --> 00:59:49,960
So I kien qed jipprova jtenni fuq
dan u jippruvaw jimmanipulaw,

1144
00:59:49,960 --> 00:59:52,350
imma jien ma verament
jifhmu dak I kien isir.

1145
00:59:52,350 --> 00:59:56,830
Mela jekk inti biss dump hija, li se
ipprintjaha għall-browser,

1146
00:59:56,830 --> 00:59:59,220
u tista 'tara eżattament
kif huwa formattjati.

1147
00:59:59,220 --> 01:00:03,530
Hija ser tipikament ipprintjaha bħala
array ma ċwievet u l-valuri tagħha.

1148
01:00:03,530 --> 01:00:04,637
Allura dan jista 'jgħin hemmhekk.

1149
01:00:04,637 --> 01:00:06,720
Hija tista 'wkoll tgħin biex tagħmel
żgur li int attwalment

1150
01:00:06,720 --> 01:00:09,070
ħtif d-data li
int ħsibt inti kienu.

1151
01:00:09,070 --> 01:00:12,950
Mela jekk inti kienu simili, mejda tiegħi definittivament
jgħid hemm utent ma dan ID,

1152
01:00:12,950 --> 01:00:15,260
imma meta inti tmur li jifqgħu l-
varjabbli, mhuwiex hemmhekk,

1153
01:00:15,260 --> 01:00:17,551
inti ovvjament taf li l-
meta żball għaddej biex tkun.

1154
01:00:17,551 --> 01:00:22,180
Dan huwa wieħed mill-aqwa għodod
għall debugging, fl-opinjoni tiegħi.

1155
01:00:22,180 --> 01:00:24,480
U allura hemm
koppja affarijiet oħra hawn,

1156
01:00:24,480 --> 01:00:27,660
iżda għall-parti l-kbira, dak l-
wieħed Irrid li tiġbed l-attenzjoni tiegħek għal,

1157
01:00:27,660 --> 01:00:31,060
minħabba li huwa utli ħafna.

1158
01:00:31,060 --> 01:00:35,800
>> Pubbliku, dak li għandna hawnhekk jiġifieri,
din hija kollha ta 'għalf CSS tagħna.

1159
01:00:35,800 --> 01:00:40,520
Allura CSS, fonts, stampi tagħna, whatnot.

1160
01:00:40,520 --> 01:00:43,255
Dan huwa Jittieħed kollu li
inti ma għandekx biex jimmodifika.

1161
01:00:43,255 --> 01:00:46,070

1162
01:00:46,070 --> 01:00:50,080
Can You guys jaħsbu dwar jekk dan
għandha affarijiet simili CSS fil-fonts,

1163
01:00:50,080 --> 01:00:54,039
kieku dan ikun mudell, jew
ħsieb, jew kontrollur?

1164
01:00:54,039 --> 01:00:54,914
UDJENZA: [inaudible]

1165
01:00:54,914 --> 01:00:57,080
ALLISON BUCHHOLTZ-UA: Hija d
tkun aktar ta 'fehma, id-dritt?

1166
01:00:57,080 --> 01:01:00,510
Dan huwa immaniġġjar kollha
affarijiet, kif l-affarijiet tfittex.

1167
01:01:00,510 --> 01:01:03,500
Hekk jekk aħna miftuħa dan hawn, naraw
li dak kollu li qed jiġri hawn

1168
01:01:03,500 --> 01:01:05,060
hija aħna qed tirrendi xi ħaġa.

1169
01:01:05,060 --> 01:01:05,820
OK?

1170
01:01:05,820 --> 01:01:09,710
Għalhekk dan ikun ferm
jikkwalifikaw bħala għan għal dan.

1171
01:01:09,710 --> 01:01:14,810
Allura dan huwa biss tieħu xi wħud,
huwa ssejjaħ xi portfolio.php

1172
01:01:14,810 --> 01:01:19,430
li għandna, u huwa tgħaddi
fit-titolu u l-portafoll.

1173
01:01:19,430 --> 01:01:20,696
U huwa biss tirrendi dak.

1174
01:01:20,696 --> 01:01:21,820
Attwalment, I jieħdu dik lura.

1175
01:01:21,820 --> 01:01:27,890
Din hija kontrollur, għaliex
tirrendi, ftakar, jirrendi l-opinjoni.

1176
01:01:27,890 --> 01:01:30,832
Allura portfolio.php f'dan
każ ikun fehma tiegħek.

1177
01:01:30,832 --> 01:01:32,480
Jiddispjacini, guys.

1178
01:01:32,480 --> 01:01:36,160
Portfolio.php se tkun
fehma tiegħek, u dan kien biss

1179
01:01:36,160 --> 01:01:38,730
jkun kontrollur tiegħek għal dak.

1180
01:01:38,730 --> 01:01:43,120
U jekk nieħdu ħarsa lejn din
aħħar wieħed hawn, templates,

1181
01:01:43,120 --> 01:01:47,330
templates huma kollha ta 'fehmiet tiegħek hawn.

1182
01:01:47,330 --> 01:01:52,420
Mela jekk inħarsu, ovvjament
naraw ħafna ta 'HTML hawn.

1183
01:01:52,420 --> 01:01:58,920
>> Allura dan huwa wieħed biss turi li inti liema
il-paġna login għandu look like.

1184
01:01:58,920 --> 01:02:04,810
Tinnota għandna xi
jiffurmaw gruppi, ikollhom jissottomettu.

1185
01:02:04,810 --> 01:02:08,510
Ara kif inti tiddeċiedi liema
hija murija fuq hemmhekk.

1186
01:02:08,510 --> 01:02:14,320
Inti għandek xi tip buttuna = "tippreżenta",
u imbagħad inti għandek dak li trid

1187
01:02:14,320 --> 01:02:16,670
li juri fil-buttuna.

1188
01:02:16,670 --> 01:02:19,860
Allura li kif inti tagħmel dan
juru up kif tkun xi tkun tixtieq.

1189
01:02:19,860 --> 01:02:24,520
>> U naraw hawnhekk għandna xi
username, xi password,

1190
01:02:24,520 --> 01:02:30,590
u meta aħna attwalment hit Issottometti,
li għaddej biex jkun hemm xi post,

1191
01:02:30,590 --> 01:02:33,346
u li għaddej biex post għal liema?

1192
01:02:33,346 --> 01:02:35,430
X'hemm-kontrollur għal din il-fehma?

1193
01:02:35,430 --> 01:02:38,040

1194
01:02:38,040 --> 01:02:40,940
Meta aħna hit Issottometti,
x'inhu għaddej li għandu jissejjaħ?

1195
01:02:40,940 --> 01:02:42,990
Inkunu nafu?

1196
01:02:42,990 --> 01:02:45,560
Huwa dritt hawn, hekk login.php.

1197
01:02:45,560 --> 01:02:47,600
Xi ħaġa inti guys huma
ser jimplimentaw.

1198
01:02:47,600 --> 01:02:50,580
>> Sabiex inti dejjem jistgħu jgħidu
dak li għaddej biex tkun

1199
01:02:50,580 --> 01:02:53,740
imsejħa wara inti hit Issottometti
minn din l-ewwel linja hawn.

1200
01:02:53,740 --> 01:02:55,440
X'inhu l-azzjoni formola hija.

1201
01:02:55,440 --> 01:02:58,350
Meta din il-formola tiġi sottomessa,
x'azzjoni do nieħdu?

1202
01:02:58,350 --> 01:03:01,440
Aħna nsejħu login.php, u aħna
sejħa hija b'dan il-metodu

1203
01:03:01,440 --> 01:03:05,500
ta 'posta, li għandha l-
informazzjoni moħbija.

1204
01:03:05,500 --> 01:03:06,210
OK?

1205
01:03:06,210 --> 01:03:14,485
Allura dan huwa l-fehma tiegħek, u mbagħad ovvjament
jekk aħna marru għall login.php-- Do aħna għandna hija

1206
01:03:14,485 --> 01:03:16,025
għadhom?

1207
01:03:16,025 --> 01:03:17,970
Yeah.

1208
01:03:17,970 --> 01:03:21,950
>> Allura kif naraw hawn, dan
għandha ħafna aktar loġika.

1209
01:03:21,950 --> 01:03:23,570
Dan kollu PHP tagħna hawn.

1210
01:03:23,570 --> 01:03:28,870
Aħna qed jippruvaw biex tara jekk kien $ _GET,
jekk kien $ _POST, validazzjoni affarijiet,

1211
01:03:28,870 --> 01:03:31,370
mistoqsi, dan kollu Jittieħed.

1212
01:03:31,370 --> 01:03:34,950

1213
01:03:34,950 --> 01:03:40,200
Għalhekk dawn huma biss l-tlieta
affarijiet differenti hawn.

1214
01:03:40,200 --> 01:03:43,750
inti ma għandekx li jibdlu l-affarijiet.

1215
01:03:43,750 --> 01:03:46,540
Int ser tkun ħolqien affarijiet
fl template, possibilment,

1216
01:03:46,540 --> 01:03:51,350
imma safejn HTML jew l-
grafika ta 'xi parti minn din tmur,

1217
01:03:51,350 --> 01:03:54,550
inti tista 'tħalli bħala plain jew
kif kkomplikata kif inti tixtieq.

1218
01:03:54,550 --> 01:03:59,800
>> Xi nies jiksbu verament inkorporat fih u
tagħmel xi websites pretty biża.

1219
01:03:59,800 --> 01:04:00,940
Inti ma għandekx tagħmel dan.

1220
01:04:00,940 --> 01:04:03,750
Jekk ikollok ħin, huwa
ħaġa verament jibred.

1221
01:04:03,750 --> 01:04:08,260
Inti tista mess mal-madwar CSS u HTML
u jiksbu jħossu ferm aħjar għaliha,

1222
01:04:08,260 --> 01:04:10,810
iżda ma jħossux ppressati biex.

1223
01:04:10,810 --> 01:04:14,760
Hemm ħafna għalik li tagħmel fuq il-
back-end bl-implimentazzjoni login,

1224
01:04:14,760 --> 01:04:17,170
u jirreġistraw, u kollha ta 'dawn l-affarijiet.

1225
01:04:17,170 --> 01:04:20,490
>> Hekk nisperaw li tgħin ftit.

1226
01:04:20,490 --> 01:04:23,430
do inti guys xi mistoqsijiet
dwar xi ħaġa konna marret fuq,

1227
01:04:23,430 --> 01:04:25,690
kull riżors ieħor?

1228
01:04:25,690 --> 01:04:31,160
I definittivament se tibgħat kollha ta '
tiegħi eżempju kodiċi PHP biex inti guys,

1229
01:04:31,160 --> 01:04:35,020
u mbagħad tħossok liberu li tagħti
stampi jew whatnot ta 'dan.

1230
01:04:35,020 --> 01:04:36,180
Wkoll huwa online.

1231
01:04:36,180 --> 01:04:39,010
Inti tista 'dejjem biss jaraw mill-ġdid.

1232
01:04:39,010 --> 01:04:42,190
Hekk jekk thats it, kulħadd tajba?

1233
01:04:42,190 --> 01:04:42,690
Iva.

1234
01:04:42,690 --> 01:04:44,523
>> UDJENZA: I biss trid
biex jikkonfermaw, meta nkunu

1235
01:04:44,523 --> 01:04:47,447
tagħmel tagħżel fl SQL, il-
star tfisser dak kollu, id-dritt?

1236
01:04:47,447 --> 01:04:48,530
ALLISON BUCHHOLTZ-UA: Iva.

1237
01:04:48,530 --> 01:04:50,446
UDJENZA: U mbagħad jekk
inti ma għandekx l-istilla,

1238
01:04:50,446 --> 01:04:53,732
jekk inti tixtieq li tieħu minn speċifiku
ringiela, allura inti biss jitqiegħed l-isem of--

1239
01:04:53,732 --> 01:04:55,440
ALLISON BUCHHOLTZ-UA:
L-isem tar-ringiela

1240
01:04:55,440 --> 01:04:56,240
u dak li trid li inti tixtieq l-valur tal-.

1241
01:04:56,240 --> 01:04:57,577
>> UDJENZA: U allura l-data.

1242
01:04:57,577 --> 01:04:59,910
ALLISON BUCHHOLTZ-UA: Tkun xi tkun
inti qed tfittex, yeah.

1243
01:04:59,910 --> 01:05:05,100
Bl-istess mod, jekk inti tagħmel Ħassar * minn
xi tabella, inneħħu ħassar kollox.

1244
01:05:05,100 --> 01:05:08,896
Allura, * huwa biss selvaġġi
karta għal kollox.

1245
01:05:08,896 --> 01:05:09,788
>> UDJENZA: OK.

1246
01:05:09,788 --> 01:05:10,930
>> ALLISON BUCHHOLTZ-UA: Kessaħ.

1247
01:05:10,930 --> 01:05:11,430
Biża.

1248
01:05:11,430 --> 01:05:12,800
Ukoll, jkollhom kbira Tnejn, guys.

1249
01:05:12,800 --> 01:05:13,760
I ser tara inti ġimgħa d-dieħla.

1250
01:05:13,760 --> 01:05:15,530
Xorti tajba fuq pset tiegħek.

1251
01:05:15,530 --> 01:05:16,992