1
00:00:00,000 --> 00:00:08,802

2
00:00:08,802 --> 00:00:11,140
>> JASON Hirschhorn: Welcome
kulħadd tmien ġimgħat.

3
00:00:11,140 --> 00:00:13,420
Għandna ġimgħa eċċitanti li għandna quddiemna.

4
00:00:13,420 --> 00:00:21,390
You guys dove f'dan koppja passat
ta 'lectures għall PHP, SQL, HTML, CSS, hekk

5
00:00:21,390 --> 00:00:27,270
erba marka ġdida lingwi li huma għaddejjin
biex jieħu l-bqija dan il-kors.

6
00:00:27,270 --> 00:00:30,750
Aħna ser jitgħallmu wkoll koppja ta 'oħrajn
lingwi qabel l-aħħar kors tal.

7
00:00:30,750 --> 00:00:35,200
Iżda xorta waħda, m'hemmx għalfejn ngħidu, din hija
żmien eċċitanti ħafna fil CS50, issa int

8
00:00:35,200 --> 00:00:41,200
mhaddma C, apparentement, u huma
jimxu fuq l-ipprogrammar għall-websajts.

9
00:00:41,200 --> 00:00:45,320
>> Għalhekk din il-ġimgħa, aħna se jmorru fuq
tour whirlwind permezz tal-erba '

10
00:00:45,320 --> 00:00:50,200
lingwi I biss imsemmija,
HTML, CSS, PHP, u SQL.

11
00:00:50,200 --> 00:00:53,340
U wieħed jittama, aħna se jħallu ħafna
ħin fl-aħħar tas-sezzjoni biex jitkellmu

12
00:00:53,340 --> 00:00:58,800
dwar sett u tweġiba P din il-ġimgħa
xi mistoqsijiet li inti kollha għandhom.

13
00:00:58,800 --> 00:01:03,500
>> Kull ġimgħa, l-istess lista ta 'riżorsi
għalik, biex jgħinuk mal-ġimgħa

14
00:01:03,500 --> 00:01:05,780
problema stabbiliti u jmorru
fuq il-materjal -

15
00:01:05,780 --> 00:01:09,440
iżda din il-ġimgħa b'mod partikolari, għal dawn
web-based settijiet problema, hemm

16
00:01:09,440 --> 00:01:12,350
għadd ta 'riżorsi oħra barra
hemmhekk li inti x'aktarx se

17
00:01:12,350 --> 00:01:13,500
isibu oerhört utli.

18
00:01:13,500 --> 00:01:14,670
Jien lilhom up here.

19
00:01:14,670 --> 00:01:17,570
I ser email inti dan wara it-taqsima,
u dan ikun ukoll online.

20
00:01:17,570 --> 00:01:21,700
>> Iżda b'mod partikolari, hemm bosta
riżorsi tas kbira hemmhekk.

21
00:01:21,700 --> 00:01:24,380
Hemm ukoll xi mhux daqshekk kbir
dawk, sabiex tkun attenta ta 'dawk.

22
00:01:24,380 --> 00:01:28,210
Imma fuq dan slide, I jkollhom erba tajba
riżorsi, wieħed għal kull

23
00:01:28,210 --> 00:01:30,600
lingwi li inti ser tkun ħidma
ma 'din il-ġimgħa -

24
00:01:30,600 --> 00:01:35,090
folja ta 'referenza waħda għall-HTML,
folja referenza għal CSS.

25
00:01:35,090 --> 00:01:38,320
Dan id-dritt hawnhekk huwa l-manwal PHP.

26
00:01:38,320 --> 00:01:42,110
>> Allura minflok bniedem typing u mbagħad PHP
kmand, dan huwa fejn inti

27
00:01:42,110 --> 00:01:46,980
mur tfittex l-prototip funzjoni
u eżempji u wkoll xi tips u

28
00:01:46,980 --> 00:01:48,770
tricks għall-użu funzjonijiet PHP.

29
00:01:48,770 --> 00:01:51,590
Inti se tuża dan is-sit spiss,
so I ninkoraġġukom biex issir

30
00:01:51,590 --> 00:01:52,280
familjari magħha.

31
00:01:52,280 --> 00:01:55,860
Hija tista 'tkun ftit teknika, iżda
jipprovdi wkoll ton ta 'riżorsi u

32
00:01:55,860 --> 00:02:00,440
eżempji għall-funzjonijiet kollha u
anki oħra, bħal kif tuża arrays jew

33
00:02:00,440 --> 00:02:01,500
tipi differenti ta 'varjabbli.

34
00:02:01,500 --> 00:02:03,480
Dan is-sit huwa utli ħafna għall PHP.

35
00:02:03,480 --> 00:02:07,160
>> U mbagħad, għall SQL, jekk inti dove fis dan
sett problema ġimgħa, inti ser tkun taf

36
00:02:07,160 --> 00:02:09,160
li aħna qed jużaw database.

37
00:02:09,160 --> 00:02:13,340
U aħna jaċċessaw din id-database permezz
user interface relattivament sbieħ.

38
00:02:13,340 --> 00:02:15,760
Jew li l-mod wieħed biex aċċess
din id-database.

39
00:02:15,760 --> 00:02:19,670
Il-user interface huwa
imsejħa phpMyAdmin.

40
00:02:19,670 --> 00:02:23,400
Hemm tab SQL, li aħna ser
tħares lejn aktar tard illum.

41
00:02:23,400 --> 00:02:28,230
>> U inti tista tip fil SQL kampjun tagħhom
mistoqsijiet, biex tagħmel affarijiet tiegħek fid-database

42
00:02:28,230 --> 00:02:29,780
u mbagħad jimxu dawk id-domandi.

43
00:02:29,780 --> 00:02:31,850
U jekk dawn qed korretta, dan ser
jgħidu, dan wieħed korrett.

44
00:02:31,850 --> 00:02:33,480
Jekk dawn qed żbaljata, dan ser
jiġifieri, huwa żbaljat.

45
00:02:33,480 --> 00:02:37,260
C'est post kbir għall-prattika tiegħek
SQL mistoqsijiet qabel bil-miktub tagħhom fiċ-

46
00:02:37,260 --> 00:02:39,990
kodiċi tiegħek, sabiex tagħmel żgur li int
jkollu l-format korrett.

47
00:02:39,990 --> 00:02:42,080
>> Fl-aħħarnett, websajt ieħor hawn fuq.

48
00:02:42,080 --> 00:02:45,390
Dan huwa l-websajt fejn tista '
mur u jivverifika sabiex ikun żgur tiegħek

49
00:02:45,390 --> 00:02:47,520
HTML code huwa validu.

50
00:02:47,520 --> 00:02:51,250
Allura qabel ma ddawwar l-problemi tiegħek stabbiliti
din il-ġimgħa, kun żgur kollha ta '

51
00:02:51,250 --> 00:02:52,690
HTML tiegħek huwa validu.

52
00:02:52,690 --> 00:02:55,840
>> Last week, inti kienu amministraw valgrind, li
aċċerta ruħek li kellu l-ebda tnixxijiet memorja.

53
00:02:55,840 --> 00:02:59,050
Din il-ġimgħa, inti għandek bżonn tagħmel ċert kollha
tal-kodiċi tiegħek huwa HTML5 valida.

54
00:02:59,050 --> 00:03:02,140
Jekk mhuwiex HTML5 valida, int
se tikseb punti off.

55
00:03:02,140 --> 00:03:03,110
>> Sabiex tagħmel ċert -

56
00:03:03,110 --> 00:03:05,700
sempliċiment minħabba li taħdem ma
jfissirx li huwa kompletament validu.

57
00:03:05,700 --> 00:03:09,770
Mexxi kodiċi tiegħek permezz dan is-sit
qabel ma ddawwar hija pulzieri

58
00:03:09,770 --> 00:03:10,810
Għal darb'oħra, hawnhekk l-website.

59
00:03:10,810 --> 00:03:15,150
>> Jekk għandek xi feedback għalija, għandna
koppja ta 'aktar sezzjonijiet xellug,

60
00:03:15,150 --> 00:03:18,100
u jien dejjem trid tagħmel dak li nista 'biex
jagħtuk kollha bl-aħjar taqsima

61
00:03:18,100 --> 00:03:19,460
esperjenza possibbli.

62
00:03:19,460 --> 00:03:22,115
So let me know jekk hemm xi ħaġa I
jistgħu jagħmlu biex itejbu jew jekk ikun hemm

63
00:03:22,115 --> 00:03:24,730
affarijiet li inti tara dak I jistgħu jagħmlu aħjar.

64
00:03:24,730 --> 00:03:25,710
Grazzi, Avi.

65
00:03:25,710 --> 00:03:27,610
Poġġih fuq il-websajt.

66
00:03:27,610 --> 00:03:31,870
>> Dan kien il-bike kelli meta I
kien, ejja ngħidu, erba fid-dar.

67
00:03:31,870 --> 00:03:34,500
Huwa adoloxxenti mutazzjoni Ninja Fekruna
ċikliżmu, fil-każ li inti ma tistax tgħid,

68
00:03:34,500 --> 00:03:35,345
għaliex dan huwa ftit blurry.

69
00:03:35,345 --> 00:03:38,900
Tista 'tikseb dan issa fil ToysRUs
għal, I think, madwar $ 100.

70
00:03:38,900 --> 00:03:42,690
>> Iżda l-karatteristika ta 'din bike li nixtieq
inti tagħti attenzjoni lill huma dawn

71
00:03:42,690 --> 00:03:43,480
dritt hawn.

72
00:03:43,480 --> 00:03:44,980
Dawn huma l-roti ta 'taħriġ.

73
00:03:44,980 --> 00:03:50,230
Sa issa, ġejt handheld
permezz C. U aħna ħadt twil

74
00:03:50,230 --> 00:03:53,610
time, xahrejn plus,
jgħaddu C.

75
00:03:53,610 --> 00:03:55,440
>> Għal dawn koppja li jmiss ta 'lingwi,
aħna qed mhux se

76
00:03:55,440 --> 00:03:56,600
jqattgħu ħafna ħin.

77
00:03:56,600 --> 00:03:58,350
Ir-roti ta 'taħriġ huma ġejjin off.

78
00:03:58,350 --> 00:04:01,360
U aħna qed tmur biex adsa fis dawn
lingwi malajr u jiċċaqalqu permezz

79
00:04:01,360 --> 00:04:04,720
malajr, li ma jfissirx li
aħna qed biss ser tħallik għawm

80
00:04:04,720 --> 00:04:07,590
hemmhekk bl-ebda mod l-appoġġ
yourself jew figura kif dawn

81
00:04:07,590 --> 00:04:08,270
lingwi xogħol.

82
00:04:08,270 --> 00:04:10,750
I biss wera inti lista ta '
riżorsi biex jgħinek.

83
00:04:10,750 --> 00:04:14,560
>> Iżda jżomm f'moħħu li PHP huwa oerhört
simili għal C. Aħna ser jmorru fuq

84
00:04:14,560 --> 00:04:15,970
illum u xi wħud mill-differenzi.

85
00:04:15,970 --> 00:04:17,990
Iżda għall-parti l-kbira,
hemm għall-loops.

86
00:04:17,990 --> 00:04:18,750
Hemm jekk il-kondizzjonijiet.

87
00:04:18,750 --> 00:04:20,680
>> Meta inti tixtieq li issolvi problema,
int ser tuża

88
00:04:20,680 --> 00:04:22,029
kombinazzjoni ta 'dawn.

89
00:04:22,029 --> 00:04:22,920
Huwa simili ħafna.

90
00:04:22,920 --> 00:04:26,040
Il-loġika għandu jkun simili ħafna għal
dak li inti ghamilt fil-passat.

91
00:04:26,040 --> 00:04:29,810
X'hemm verament ġdid din il-ġimgħa hija l-
sintassi u kif inti tesprimi ruħek.

92
00:04:29,810 --> 00:04:32,850
U inti tixtieq li jiktbu għall-loop, iżda
tista 'tidher xi ftit differenti.

93
00:04:32,850 --> 00:04:35,910
Jew inti tixtieq li toħloq firxa, iżda
tista 'tidher xi ftit differenti.

94
00:04:35,910 --> 00:04:39,920
>> Allura wieħed iżomm f'moħħu li, timxi 'l quddiem,
il-loġika hija simili ħafna għal dak

95
00:04:39,920 --> 00:04:41,020
inti ghamilt fil-passat.

96
00:04:41,020 --> 00:04:44,030
Imma int issa ser niltaqgħu ma '
ħafna ta 'sintassi ġdid.

97
00:04:44,030 --> 00:04:47,600
U aħna mhux se jimxu miegħek permezz
elementi kollha tal-sintassi.

98
00:04:47,600 --> 00:04:53,020
Allura huwa verament sa inti biex insemmu,
online jew permezz jilħaq fuq

99
00:04:53,020 --> 00:04:58,770
Iddiskuti jew email lili jew tkellem lil
xulxin, kif jiktbu affarijiet fil-

100
00:04:58,770 --> 00:05:02,580
PHP u kif jiktbu mistoqsijiet SQL
u kif tuża HTML u CSS.

101
00:05:02,580 --> 00:05:06,160
>> Imma hekk biss tafu, dan m'huwiex
aħna qed jippruvaw biex tarmi inti hemmhekk

102
00:05:06,160 --> 00:05:07,630
darb'oħra li jgħum l-klieb il-baħar.

103
00:05:07,630 --> 00:05:10,600
Dan huwa dak li inti x'aktarx se tagħmel ma
proġett finali tiegħek, jekk inti tagħżel

104
00:05:10,600 --> 00:05:15,150
lingwa differenti, bħall-IOS u
Objettiv C, jew jekk inti tiddeċiedi li tibda

105
00:05:15,150 --> 00:05:17,580
programmazzjoni fil-futur u
adsa f'lingwi oħrajn,

106
00:05:17,580 --> 00:05:19,210
bħal Python jew Ruby.

107
00:05:19,210 --> 00:05:23,380
>> Oftentimes, il-loġika hija simili ħafna
madwar kollha ta 'dawn il-lingwi, u l-

108
00:05:23,380 --> 00:05:24,560
sintassi hija x'hemm differenti.

109
00:05:24,560 --> 00:05:27,560
U se jkun sa inti, bħala l-
programmer, li jmorru jużaw l-internet

110
00:05:27,560 --> 00:05:30,790
riżorsi disponibbli lilek u l-figura
kif biex jesprimu dak li taf kif

111
00:05:30,790 --> 00:05:33,200
biex jesprimu Ċ,
lingwa differenti.

112
00:05:33,200 --> 00:05:36,410
Allura dan huwa prattika tajba, kemm għall tiegħek
proġett finali, u għal darb'oħra, għall-

113
00:05:36,410 --> 00:05:40,150
dak li inti x'aktarx se tagħmel
wara titlaq CS50.

114
00:05:40,150 --> 00:05:42,550
>> Qabel nimxu fuq, ma xi ħadd
xi mistoqsijiet dwar dak li

115
00:05:42,550 --> 00:05:43,800
I ghamilt s'issa?

116
00:05:43,800 --> 00:05:52,450

117
00:05:52,450 --> 00:05:53,120
Great.

118
00:05:53,120 --> 00:05:53,910
Ejja jimxu fuq.

119
00:05:53,910 --> 00:05:59,090
>> L-ewwel, aħna qed tmur biex jitkellmu fil-qosor
dwar il-kmand chmod.

120
00:05:59,090 --> 00:06:02,420
Dan, aħna ser nagħmlu fil-bidu
problemi tiegħek stabbiliti.

121
00:06:02,420 --> 00:06:05,050
Waħda mill-ewwel istruzzjonijiet
għalik, wara li inti tniżżel il-

122
00:06:05,050 --> 00:06:09,280
kodiċi ta 'distribuzzjoni, huwa li jibdlu l-
permessi tal-fajls u

123
00:06:09,280 --> 00:06:11,350
direttorji li tirċievi.

124
00:06:11,350 --> 00:06:16,430
>> Jista 'xi ħadd jipprova jikkalkola jew jafu
għaliex huwa importanti li jibdlu l-

125
00:06:16,430 --> 00:06:20,012
permessi ta 'ċerti fajls u
direttorji fuq il-kompjuter tiegħek?

126
00:06:20,012 --> 00:06:20,956
Avi -

127
00:06:20,956 --> 00:06:24,796
>> UDJENZA: Imbagħad ħadd ħlief għall-
inti tista tara dak li qed tagħmel?

128
00:06:24,796 --> 00:06:25,470
>> JASON Hirschhorn: OK.

129
00:06:25,470 --> 00:06:28,330
Mela jekk irridu li xi ħaġa fuq il-
web u inti għandek l-permessi stabbiliti li

130
00:06:28,330 --> 00:06:30,960
biss tista 'tara xi ħaġa,
allura ħadd ieħor jista '

131
00:06:30,960 --> 00:06:32,530
tara dak li inti stajt maħluqa.

132
00:06:32,530 --> 00:06:33,380
X'aktar?

133
00:06:33,380 --> 00:06:34,320
Yeah.

134
00:06:34,320 --> 00:06:37,360
>> UDJENZA: Prevenzjoni xi ħadd ieħor li inti
ma tridx tara xi ħaġa, minn

135
00:06:37,360 --> 00:06:37,870
jaraw xi ħaġa.

136
00:06:37,870 --> 00:06:38,820
>> JASON Hirschhorn: Dak veru wkoll.

137
00:06:38,820 --> 00:06:40,730
Hemm probabbilment xi kodiċi li
tikteb, li inti ma

138
00:06:40,730 --> 00:06:42,690
tixtieq nies biex tara.

139
00:06:42,690 --> 00:06:46,190
Inti probabbilment OK ma 'nies jaraw
HTML tiegħek u tiegħek JavaScript.

140
00:06:46,190 --> 00:06:50,360
Iżda PHP tiegħek, kodiċi back-end, lott ta '
l-loġika għall-kodiċi tiegħek, forsi l-

141
00:06:50,360 --> 00:06:53,200
affarijiet li jaħżnu xi wħud passwords tiegħek
għal database tiegħek, inti ma

142
00:06:53,200 --> 00:06:55,880
tixtieq nies biex tara li
tip ta 'informazzjoni.

143
00:06:55,880 --> 00:06:59,420
>> Allura huwa importanti li, kull fajl u
direttorju noħolqu għandu permessi

144
00:06:59,420 --> 00:07:03,660
applikabbli jew le irridu
nies biex tara dawk it-tipi ta 'fajls u

145
00:07:03,660 --> 00:07:08,030
direttorji u jkunu jistgħu jkollhom aċċess għalihom
u potenzjalment anki bidla minnhom.

146
00:07:08,030 --> 00:07:09,920
>> Allura hemm tliet tipi
tal-permessi.

147
00:07:09,920 --> 00:07:14,980
Hemm permess jaqra, li jfisser
inti tista 'taqra fajl jew lista tal-

148
00:07:14,980 --> 00:07:16,490
kontenut tad-direttorju.

149
00:07:16,490 --> 00:07:20,820
Hemm il-permess write, li
ifisser li inti tista 'tibdel fajl jew bidla

150
00:07:20,820 --> 00:07:24,910
direttorju u allura l tesegwixxi
permess, li jfisser li inti tista '

151
00:07:24,910 --> 00:07:31,060
tesegwixxi fajl jew pjuttost, inti
tista 'timxi ġo direttorju.

152
00:07:31,060 --> 00:07:34,470
Allura CD xi ħaġa, jekk inti għandek l-
permess li jiġi esegwit, inti tista 'timxi

153
00:07:34,470 --> 00:07:37,300
fis dan id-direttorju.

154
00:07:37,300 --> 00:07:38,510
>> Dan huwa eżempju qasira.

155
00:07:38,510 --> 00:07:40,700
Għal darb'oħra, inti ħadthom marret matul dan
fil-problema stabbiliti.

156
00:07:40,700 --> 00:07:44,630
Imma I toħloq direttorju
mal-kmand mkdir.

157
00:07:44,630 --> 00:07:46,320
I jibdlu l-permessi.

158
00:07:46,320 --> 00:07:48,505
Dawn iż-żewġ linji fil-fatt jagħmlu
l-istess ħaġa eżatt.

159
00:07:48,505 --> 00:07:52,580
Huwa biex juri li s-sintassi għall-
jinbidlu permessi, jekk inti tagħmel

160
00:07:52,580 --> 00:07:55,600
l-a + x jew 711, dawk huma l-istess.

161
00:07:55,600 --> 00:07:57,550
>> Aħna nħarsu stabbiliti fuq din it-tabella sbieħ.

162
00:07:57,550 --> 00:07:59,960
Naraw li hemm utent
permessi ewwel.

163
00:07:59,960 --> 00:08:03,280
Li inti, l-individwu, u
server tiegħek, potenzjalment.

164
00:08:03,280 --> 00:08:05,070
U allura hemm grupp u oħrajn.

165
00:08:05,070 --> 00:08:09,350
Id-differenzi bejn dawk
tnejn huma relattivament trivjali.

166
00:08:09,350 --> 00:08:11,170
Allura ġeneralment, aħna ser f'daqqa
dawk flimkien.

167
00:08:11,170 --> 00:08:14,380
>> Iżda essenzjalment, jekk aħna jkollhom fajl
imsejħa jinkludi li irridu nkunu

168
00:08:14,380 --> 00:08:18,760
kapaċi li jeditjaw nfusna u li aħna rridu
oħrajn biex ikunu jistgħu jeżegwixxu,

169
00:08:18,760 --> 00:08:20,560
huwa l-permess 711.

170
00:08:20,560 --> 00:08:22,390
U naraw li jistabbilixxi
hawn f'din it-tabella.

171
00:08:22,390 --> 00:08:24,730
Għandna jaqraw, jiktbu, u jesegwixxi.

172
00:08:24,730 --> 00:08:26,790
Għal kull wieħed minna, irridu
ikunu jistgħu jagħmlu dawk.

173
00:08:26,790 --> 00:08:30,160
Group u oħrajn, aħna biss rridu
biex tkun tista 'tesegwixxi.

174
00:08:30,160 --> 00:08:33,860
>> Il-mod aħna tittraduċi li
f'numru ta '

175
00:08:33,860 --> 00:08:36,870
permess huwa permezz binarja.

176
00:08:36,870 --> 00:08:41,780
Mela jekk għandna tliet dawk, li l-1
fil-kolonna dawk, ta '1 fil-twos

177
00:08:41,780 --> 00:08:43,049
kolonna, kolonna 1 l-fours.

178
00:08:43,049 --> 00:08:45,180
Dak 7 hemm dritt.

179
00:08:45,180 --> 00:08:47,450
U dan il-permess huwa 1.

180
00:08:47,450 --> 00:08:48,390
Dan il-permess huwa 1.

181
00:08:48,390 --> 00:08:54,200
Allura 711 meta huwa l-istess bħala li jagħti
nfusna jaqraw, jiktbu, u jesegwixxi,

182
00:08:54,200 --> 00:08:56,660
u kulħadd tesegwixxi privileġġi.

183
00:08:56,660 --> 00:08:59,180
>> Din il-linja dritt hawn, aħna ġeneralment
se jkunu jaqraw u jiktbu meta aħna

184
00:08:59,180 --> 00:09:00,250
toħloq direttorju.

185
00:09:00,250 --> 00:09:04,650
Allura din il-linja hawn biss iżid tesegwixxi
privileġġi għal kulħadd.

186
00:09:04,650 --> 00:09:07,450
Allura li jkunu jixbhu lil, fil-
Minbarra dak li għandna,

187
00:09:07,450 --> 00:09:09,930
żżid 1, 1, 1 għal kulħadd.

188
00:09:09,930 --> 00:09:13,880
>> Billi dan, huwa inutli
li żżid jaqraw u jiktbu.

189
00:09:13,880 --> 00:09:16,130
Imma jekk int ser jintużaw in-numri,
inti ma tistax żid ftit xi ħaġa.

190
00:09:16,130 --> 00:09:19,070
You jissostitwixxu kwalunkwe permess kienu
hemm u jimplimentawhom mal-ġdid

191
00:09:19,070 --> 00:09:20,920
numru inti tagħti.

192
00:09:20,920 --> 00:09:21,930
Dan kien pjuttost malajr.

193
00:09:21,930 --> 00:09:24,115
Ħadd ma jkollu xi mistoqsijiet
dwar tibdil permessi?

194
00:09:24,115 --> 00:09:28,460

195
00:09:28,460 --> 00:09:28,950
>> OK.

196
00:09:28,950 --> 00:09:32,480
Jekk I jkollhom fajl PHP, liema permessi
do Irrid li jkollhom?

197
00:09:32,480 --> 00:09:36,638

198
00:09:36,638 --> 00:09:38,780
Dan huwa fl-spec sett problema.

199
00:09:38,780 --> 00:09:41,590
Allura inti tista 'tħares lejn l-spec u
mbagħad jaqra me-risposta.

200
00:09:41,590 --> 00:09:45,820

201
00:09:45,820 --> 00:09:48,605
>> UDJENZA: Trid li l-utent li
jkollhom read-write permessi.

202
00:09:48,605 --> 00:09:51,080
U inti tixtieq kulħadd
inkella li jkollhom xejn.

203
00:09:51,080 --> 00:09:53,060
>> JASON Hirschhorn: U liema
numri huwa li?

204
00:09:53,060 --> 00:09:53,480
>> UDJENZA: 600.

205
00:09:53,480 --> 00:09:54,840
>> JASON Hirschhorn: 600.

206
00:09:54,840 --> 00:09:59,550
Allura chmod 600 - kull meta inti print
fajl PHP, chmod dan sa 600.

207
00:09:59,550 --> 00:10:00,370
OK.

208
00:10:00,370 --> 00:10:01,890
I jkollhom direttorju.

209
00:10:01,890 --> 00:10:04,870
Xi ħadd minbarra Jeff,
I jkollhom fajl folder.

210
00:10:04,870 --> 00:10:08,060
What permessi irrid
li jagħti għal dik folder -

211
00:10:08,060 --> 00:10:11,620
wkoll fil-problema stabbilita spec,
dritt taħt din it-tweġiba jew

212
00:10:11,620 --> 00:10:14,840
ir-risposta preċedenti?

213
00:10:14,840 --> 00:10:16,160
Wkoll potenzjalment fuq il-pjastra -

214
00:10:16,160 --> 00:10:16,450
Marcus.

215
00:10:16,450 --> 00:10:17,230
>> UDJENZA: Għall-

216
00:10:17,230 --> 00:10:18,180
folder, huwa 711.

217
00:10:18,180 --> 00:10:19,590
JASON Hirschhorn: 711 -

218
00:10:19,590 --> 00:10:21,230
hekk folder, inti tixtieq li tagħti 711.

219
00:10:21,230 --> 00:10:25,280
Inti trid tkun kapaċi li jaqra dak folder,
bidla direttorji, jersqu lejn

220
00:10:25,280 --> 00:10:25,785
li folder.

221
00:10:25,785 --> 00:10:28,865
U inti tixtieq kulħadd biex ikunu jistgħu
biex jinnaviga fi ħdan dak folder, imma

222
00:10:28,865 --> 00:10:30,790
mhux neċessarjament tbiddel il-kontenut tiegħu.

223
00:10:30,790 --> 00:10:33,720
What about fajl mhux PHP,
jiġifieri, fajl JavaScript?

224
00:10:33,720 --> 00:10:36,090
What permessi irridu
li tagħti dak it-tip tal-fajl?

225
00:10:36,090 --> 00:10:37,020
>> UDJENZA: 644.

226
00:10:37,020 --> 00:10:38,030
>> JASON Hirschhorn: 644 -

227
00:10:38,030 --> 00:10:40,010
għaliex irridu li tagħtiha 644?

228
00:10:40,010 --> 00:10:42,880
>> UDJENZA: Biex let nies oħra taqraha.

229
00:10:42,880 --> 00:10:44,840
U taqra jew tikteb.

230
00:10:44,840 --> 00:10:48,540
>> JASON Hirschhorn: Allura dritt, kulħadd
inkella tista 'taqra dak JavaScript fajl.

231
00:10:48,540 --> 00:10:51,420
U tista 'tbiddel li, flimkien
li jkunu kapaċi biex taqraha.

232
00:10:51,420 --> 00:10:54,970
Allura wieħed mill-persuni bugs aktar komuni
jkollhom din il-problema stabbiliti u tagħhom

233
00:10:54,970 --> 00:10:58,880
proġett finali, jekk huwa finali fuq l-internet
proġett huwa, dawn mhux se jkunu stabbilew

234
00:10:58,880 --> 00:11:00,170
l-permessi korretta.

235
00:11:00,170 --> 00:11:03,180
U dawn mhux se jkunu kapaċi
ara l-websajt tagħhom.

236
00:11:03,180 --> 00:11:04,840
Jew parti partikolari tal-websajt tagħhom.

237
00:11:04,840 --> 00:11:06,930
>> Sabiex tagħmel żgur li int tkun qed tissettja l-
permessi korrett.

238
00:11:06,930 --> 00:11:10,730
Ma biss wieħed jassumi li se
jagħmlu dan awtomatikament għalik.

239
00:11:10,730 --> 00:11:11,500
>> OK.

240
00:11:11,500 --> 00:11:15,100
Li kienet ħaġa żgħira li qattajna
ammont tajjeb ta 'ħin fuq, sabiex

241
00:11:15,100 --> 00:11:16,190
nistgħu dwiefer dan.

242
00:11:16,190 --> 00:11:18,000
Ejja jimxu fuq HTML.

243
00:11:18,000 --> 00:11:20,430
>> U għal darb'oħra, għal dawn l-erba 'suġġetti li ġejjin,
aħna qed tmur biex jgħaddu minnhom

244
00:11:20,430 --> 00:11:21,600
relattivament malajr.

245
00:11:21,600 --> 00:11:24,980
Allura nitolbok li tħossok liberu li tieqaf lili fi kwalunkwe
ħin, jekk għandek xi mistoqsijiet,

246
00:11:24,980 --> 00:11:27,900
jekk dawn qed relatati ma 'dak I ikopru
jew xi ħaġa minn lecture jew

247
00:11:27,900 --> 00:11:29,440
anke mill-problema stabbilita.

248
00:11:29,440 --> 00:11:31,690
Stop me meta għandek bżonn.

249
00:11:31,690 --> 00:11:34,370
Meta irridu jiksbu l-għan, aħna ser biss
tibda tmur matul is-sett problema.

250
00:11:34,370 --> 00:11:38,100
>> Allura HTML stands għall HyperText
Lingwa Markup.

251
00:11:38,100 --> 00:11:41,360
Mhuwiex lingwa ta 'programmar.

252
00:11:41,360 --> 00:11:45,800
Kull ma huwa istruttura kontenut tiegħek
u wkoll jipprovdu xi metadata.

253
00:11:45,800 --> 00:11:52,340
Hekk per eżempju, preżumibbilment, ħafna
inti użajt Facebook qabel.

254
00:11:52,340 --> 00:11:56,810
U inti tista 'tinkludi links fi, jew inti
tista 'tpoġġi link bħala status tiegħek.

255
00:11:56,810 --> 00:11:59,070
>> U mbagħad, inti ser ikollok avviż li rabta
dejjem jkollu stampa sbieħ

256
00:11:59,070 --> 00:12:00,450
lilha u xi test.

257
00:12:00,450 --> 00:12:03,040
Ġeneralment, jiġifieri xi metadata
għal paġna web.

258
00:12:03,040 --> 00:12:05,250
U huwa metadata speċifiku Facebook.

259
00:12:05,250 --> 00:12:07,780
U mbagħad, meta Facebook huwa qari li
paġna u daħħal din ir-rabta, dan

260
00:12:07,780 --> 00:12:10,780
jistenna għall-metadata speċifiku, u għalhekk
jaf liema stampa biex juru, liema

261
00:12:10,780 --> 00:12:13,820
titolu għall-wiri, u liema
test astratta li display.

262
00:12:13,820 --> 00:12:17,760
>> Allura aħna jistgħu jinkludu metadata ma
paġna web tagħna jużaw HTML.

263
00:12:17,760 --> 00:12:21,190
U wkoll jgħinna istruttura
il-kontenut, ġeneralment, liema

264
00:12:21,190 --> 00:12:25,400
irridu imorru fejn.

265
00:12:25,400 --> 00:12:28,240
>> Kollox fil HTML huwa element.

266
00:12:28,240 --> 00:12:30,690
U l-elementi dritt hawn -

267
00:12:30,690 --> 00:12:33,410
dan CS50, it-test huwa l-element.

268
00:12:33,410 --> 00:12:35,140
U għandha xi tags.

269
00:12:35,140 --> 00:12:36,690
Dan ikollu din tag.

270
00:12:36,690 --> 00:12:41,730
U aħna Avviż hemm a fil-
bidu u mbagħad slash a, hekk

271
00:12:41,730 --> 00:12:43,960
għeluq tal-tikketta fl-aħħar.

272
00:12:43,960 --> 00:12:46,800
Kultant, hemm mhux miftuħ
tag u tag qrib.

273
00:12:46,800 --> 00:12:49,040
Hemm wieħed biss ħaġa.

274
00:12:49,040 --> 00:12:50,640
>> Ser naraw eżempju ta 'dik
fuq il-pjastra jmiss.

275
00:12:50,640 --> 00:12:52,640
Allura inti m'għandekx bżonn miftuħ
u tag qrib.

276
00:12:52,640 --> 00:12:59,570
Iżda għal dan, aħna encasing dan
Element CS50 fil-tag ankra.

277
00:12:59,570 --> 00:13:03,270
U essenzjalment, dawn it-tags tell
il-browser x'għandek tagħmel ma

278
00:13:03,270 --> 00:13:04,700
l-element partikolari.

279
00:13:04,700 --> 00:13:07,380
>> Għalhekk għal darb'oħra, CS50 huwa t-test
aħna qed tmur biex tara.

280
00:13:07,380 --> 00:13:10,060
U se tkun
tip ta 'ankra.

281
00:13:10,060 --> 00:13:13,920
Ankra huwa essenzjalment użat
għal links għal xi ħaġa.

282
00:13:13,920 --> 00:13:16,000
B'mod partikolari, kif tista '
diġà tell, dan huwa

283
00:13:16,000 --> 00:13:18,950
link għall-homepage CS50.

284
00:13:18,950 --> 00:13:23,160
>> Il-parti li jmiss tal-lametta - jew b'mod ġenerali,
parti ta 'tags huma

285
00:13:23,160 --> 00:13:24,290
attributi.

286
00:13:24,290 --> 00:13:27,080
U aħna tara dritt hawn, li
l-tikketta għandha wieħed

287
00:13:27,080 --> 00:13:29,680
attribut, dan l-attribut href.

288
00:13:29,680 --> 00:13:32,000
U huma timmodifika tag partikolari.

289
00:13:32,000 --> 00:13:36,100
Fil-fatt, jekk inti tmur lil wieħed mill-
websajts jew ir-referenzi I ħadt

290
00:13:36,100 --> 00:13:39,480
qabel jew tfittex l-tikketta online,
inti ser ikollok avviż li hemm ton ta '

291
00:13:39,480 --> 00:13:41,010
attributi potenzjali.

292
00:13:41,010 --> 00:13:42,310
>> Dan huwa probabilment waħda
mill-aktar komuni.

293
00:13:42,310 --> 00:13:46,090
Dan huwa javżak me li jinħoloq
link għall-websajt speċifika.

294
00:13:46,090 --> 00:13:50,260
U attributi ġeneralment huma mogħtija,
jekk mhux esklużivament,

295
00:13:50,260 --> 00:13:52,350
f'pari valur ewlenin.

296
00:13:52,350 --> 00:13:55,380
>> Allura hawnhekk l-ewlenin, href.

297
00:13:55,380 --> 00:13:57,320
U l-valur huwa dan id-dritt hawn.

298
00:13:57,320 --> 00:14:01,960
U li se jidħlu fil handy aktar tard,
meta aħna tibda tuża xi libreriji biex

299
00:14:01,960 --> 00:14:07,280
tgħinna kodiċi JavaScript
jew tikteb kontenut HTML.

300
00:14:07,280 --> 00:14:11,120
Aħna ta 'spiss ser ikunu - bħad we
ser jagħmlu firxa bracket 0 u li

301
00:14:11,120 --> 00:14:12,340
tagħtina xi valur.

302
00:14:12,340 --> 00:14:17,190
>> Fil-futur, aħna ser tkun qiegħda tagħmel ħafna ta '
affarijiet bħal href bracket xi ħaġa.

303
00:14:17,190 --> 00:14:21,180
U li ser tagħtina l-valur tal-
href, jew jekk irridu li taġġorna l-href

304
00:14:21,180 --> 00:14:23,980
ewlenin u mbagħad tagħti
valur partikolari.

305
00:14:23,980 --> 00:14:28,915
Hekk biss bħal ma 'arrays fejn kellna
ċavetta 0 jew ċavetta 1 jew ċavetta 2 jew anke bi

306
00:14:28,915 --> 00:14:33,480
hash tabella, ukoll, ma 'tabelli hash tiegħek
kif ukoll, inti probabilment kellha - hija

307
00:14:33,480 --> 00:14:35,790
kien array, hekk ewlieni 0, ewlenin 1, ewlenin 2.

308
00:14:35,790 --> 00:14:38,480
>> Dik l-indiċi hemm, nistgħu
jaħsbu li bħala prinċipali.

309
00:14:38,480 --> 00:14:40,180
U l-valur ikun x'ikun
kien maħżun hemmhekk.

310
00:14:40,180 --> 00:14:42,760
Kollha ta 'dawn l-attributi
huma pari b'valur ċavetta.

311
00:14:42,760 --> 00:14:47,370
U li se jkun importanti għall-bdil
minnhom jew aġġornati jew

312
00:14:47,370 --> 00:14:51,020
dawn jiddaħħlu aktar tard.

313
00:14:51,020 --> 00:14:53,990
>> Finalment, inti stajt tidher din l-istruttura
qabel, iżda dan huwa l-aktar bażika

314
00:14:53,990 --> 00:14:55,350
istruttura tal-paġna HTML.

315
00:14:55,350 --> 00:14:58,700
Fil-quċċata, aħna jgħidlek li
dan huwa fil-fatt HTML.

316
00:14:58,700 --> 00:15:01,910
U allura għandna HTML miftuħ
tag u tag HTML qrib.

317
00:15:01,910 --> 00:15:04,940
Allura kollox ġewwa tal
dan huwa l-HTML.

318
00:15:04,940 --> 00:15:08,960
>> Naraw il-kap u l-korp.

319
00:15:08,960 --> 00:15:12,350
Il-kap tad-dokument tiegħek
ġeneralment tinkludi dak?

320
00:15:12,350 --> 00:15:16,980

321
00:15:16,980 --> 00:15:20,995
Kwalunkwe guesses għal dak li
jitqiegħdu fil-ras?

322
00:15:20,995 --> 00:15:23,060
>> UDJENZA: Inti tpoġġi t-titolu u l-istil.

323
00:15:23,060 --> 00:15:23,790
>> JASON Hirschhorn: It-titolu.

324
00:15:23,790 --> 00:15:26,110
Dan kien raden kbir.

325
00:15:26,110 --> 00:15:27,200
I jista 'jkollhom tipped inti off għall-.

326
00:15:27,200 --> 00:15:28,150
Liema huma xi affarijiet oħra?

327
00:15:28,150 --> 00:15:30,351
Aħna msemmija wieħed minnhom li
jista 'jmur fil-ras.

328
00:15:30,351 --> 00:15:33,057

329
00:15:33,057 --> 00:15:35,225
>> UDJENZA: Huwa qal, stili.

330
00:15:35,225 --> 00:15:36,240
>> JASON Hirschhorn: Stili -

331
00:15:36,240 --> 00:15:41,050
hekk jekk inti tixtieq li link fil-JavaScript
jew saħansitra CSS, li qed jitkellem

332
00:15:41,050 --> 00:15:42,610
dwar meta inti qed jitkellem
dwar stili.

333
00:15:42,610 --> 00:15:45,670
Fajl ieħor, inti tixtieq li rabta fil-
barra minn fajl, li probabbilment se jmorru

334
00:15:45,670 --> 00:15:46,920
fir-ras.

335
00:15:46,920 --> 00:15:48,660

336
00:15:48,660 --> 00:15:51,070
>> X'aktar?

337
00:15:51,070 --> 00:15:52,960
Aħna msemmija koppja ta 'slides
ilu wieħed mill-affarijiet li

338
00:15:52,960 --> 00:15:54,510
HTML jista 'jagħmel għalik.

339
00:15:54,510 --> 00:15:58,180

340
00:15:58,180 --> 00:16:01,240
Huwa jista 'jipprovdi -

341
00:16:01,240 --> 00:16:02,874
jibda bil-M -

342
00:16:02,874 --> 00:16:03,820
>> UDJENZA: Metadata.

343
00:16:03,820 --> 00:16:06,170
>> JASON Hirschhorn: Metadata - hekk ħafna
tal-metadata se jmorru fir-ras,

344
00:16:06,170 --> 00:16:08,990
minħabba li mhux neċessarjament se jkollhom bżonn
li jkun parti mill-korp ta 'kodiċi tiegħek.

345
00:16:08,990 --> 00:16:11,820
Dik hija ġeneralment - l-korp huwa l-
kontenut, dak xi ħadd jara.

346
00:16:11,820 --> 00:16:14,210
U so I biss taw bogħod ir-risposta
mistoqsija li jmiss tiegħi.

347
00:16:14,210 --> 00:16:17,770
Iżda fil-ġisem hija ġeneralment l-kontenut
li għaddej biex jintwerew

348
00:16:17,770 --> 00:16:19,750
fuq il-paġna web.

349
00:16:19,750 --> 00:16:26,120
>> Kif se naraw, websajts kkumplikata
tendenza li intermingle jew tibdil sa liema

350
00:16:26,120 --> 00:16:27,170
li jqiegħdu fir-ras u l-ġisem.

351
00:16:27,170 --> 00:16:30,360
Iżda ġeneralment, il-kap fih affarijiet
li l-utent mhux se

352
00:16:30,360 --> 00:16:31,290
tara fuq l-iskrin.

353
00:16:31,290 --> 00:16:34,150
Torbot fil-fajls l-oħra
u jipprovdu l-metadejta.

354
00:16:34,150 --> 00:16:37,690
Billi, il-korp fiha dak kollu li
l-utent se tara.

355
00:16:37,690 --> 00:16:39,270
Kull idea dak li dan tag p ifisser?

356
00:16:39,270 --> 00:16:41,660
>> UDJENZA: Il-paragrafu?

357
00:16:41,660 --> 00:16:42,780
>> UDJENZA: Stampa.

358
00:16:42,780 --> 00:16:44,120
>> UDJENZA: Ma jfissirx print.

359
00:16:44,120 --> 00:16:45,380
>> UDJENZA: Ma jfisser paragrafu?

360
00:16:45,380 --> 00:16:47,620
>> JASON Hirschhorn: Paragrafu -
għalhekk dan huwa punt.

361
00:16:47,620 --> 00:16:50,920
U dan tag p, I setgħet biss ittajpjat
dan fuq l-iskrin u mbagħad

362
00:16:50,920 --> 00:16:52,630
inklużi pawża linja
fl-aħħar ta 'dan.

363
00:16:52,630 --> 00:16:54,380
Xi ħadd jaf kif tinkludi
pawża linja?

364
00:16:54,380 --> 00:16:55,240
>> UDJENZA: pr -

365
00:16:55,240 --> 00:16:55,700
>> JASON Hirschhorn: pr -

366
00:16:55,700 --> 00:16:57,080
>> UDJENZA: Slash pr?

367
00:16:57,080 --> 00:17:00,120
>> JASON Hirschhorn: slash pr
stands għall break linja.

368
00:17:00,120 --> 00:17:03,270
Iżda paragrafi jkollhom speċifiku
ifformattjar.

369
00:17:03,270 --> 00:17:06,060
U aħna ser tingħata biex ifformattjar fil-
tieni, meta nitkellmu dwar CSS.

370
00:17:06,060 --> 00:17:09,900
Imma kollox ġewwa dawn it-tags p
se jkollhom xi ifformattjar default

371
00:17:09,900 --> 00:17:13,210
assoċjat miegħu, probabbilment xi
ispazjar bejn differenti

372
00:17:13,210 --> 00:17:15,069
paragrafi.

373
00:17:15,069 --> 00:17:19,410
U dan ser ikun mod wieħed biex jiddifferenzjaw
blokki ta 'kodiċi.

374
00:17:19,410 --> 00:17:20,980
>> Kwalunkwe tags oħra -

375
00:17:20,980 --> 00:17:24,584
liema huma tags oħra li inti stajt tidher?

376
00:17:24,584 --> 00:17:26,609
>> JASON Hirschhorn: H1 permezz H6.

377
00:17:26,609 --> 00:17:28,460
h1 permezz h6, u dak li?

378
00:17:28,460 --> 00:17:31,560
>> UDJENZA: Huwa se juri kemm hu kbir
u kuraġġużi l-ittri huma.

379
00:17:31,560 --> 00:17:32,650
>> JASON Hirschhorn: Dritt,
stands għall header.

380
00:17:32,650 --> 00:17:34,960
U għalhekk header1 huwa header big.

381
00:17:34,960 --> 00:17:40,840
Inneħħu probabbilment, awtomatikament, jkunu kuraġġużi, a
Tipa kbira, probabbilment ċċentrata fuq

382
00:17:40,840 --> 00:17:44,030
l-iskrin, it-triq kollha sa h6,
li hija font daqs iżgħar, inqas

383
00:17:44,030 --> 00:17:44,780
enfasizzata.

384
00:17:44,780 --> 00:17:50,290
Of course, inti tista ', fil int fajl CSS
jew x'imkien fil-kodiċi tiegħek - li,

385
00:17:50,290 --> 00:17:53,830
għal darb'oħra, aħna ser jiksbu għal dak fit-tieni -
bidla dak l-imġieba default

386
00:17:53,830 --> 00:17:55,780
ta 'tag H1 huwa.

387
00:17:55,780 --> 00:18:01,040
>> Iżda jżomm f'moħħu li Chrome, Safari,
Firefox, Internet Explorer kollha għandhom

388
00:18:01,040 --> 00:18:04,030
default jistenna għal ħafna
dawn it-tags standard.

389
00:18:04,030 --> 00:18:07,110
Tista ', għal darb'oħra, dejjem bidla
dak li look like.

390
00:18:07,110 --> 00:18:09,955
Kwalunkwe tags oħra li kulħadd
rat?

391
00:18:09,955 --> 00:18:10,350
Yeah -

392
00:18:10,350 --> 00:18:11,530
>> UDJENZA: A site div.

393
00:18:11,530 --> 00:18:15,830
>> JASON Hirschhorn: A div tag - div tag
m'għandha l-ebda format built-in, per

394
00:18:15,830 --> 00:18:21,850
se, li jintuża biex jimblokka off
tipi differenti ta 'kodiċi.

395
00:18:21,850 --> 00:18:22,980
Kwalunkwe tags oħra?

396
00:18:22,980 --> 00:18:23,390
Iva.

397
00:18:23,390 --> 00:18:24,333
>> UDJENZA: li -

398
00:18:24,333 --> 00:18:24,850
>> JASON Hirschhorn: li -

399
00:18:24,850 --> 00:18:25,580
x'hemm LI għall?

400
00:18:25,580 --> 00:18:26,210
>> UDJENZA: Lista.

401
00:18:26,210 --> 00:18:26,930
>> UDJENZA: Lista

402
00:18:26,930 --> 00:18:29,510
>> JASON Hirschhorn: li huwa
għall-elementi lista.

403
00:18:29,510 --> 00:18:30,720
Hemm żewġ tipi ta 'listi.

404
00:18:30,720 --> 00:18:31,970
Liema huma l-żewġ tipi?

405
00:18:31,970 --> 00:18:34,165

406
00:18:34,165 --> 00:18:35,806
>> UDJENZA: Ordnat u unordered.

407
00:18:35,806 --> 00:18:37,780
>> JASON Hirschhorn: Ordnat u
stands hekk UL - unordered

408
00:18:37,780 --> 00:18:38,560
għal lista unordered.

409
00:18:38,560 --> 00:18:41,120
Li jekk inti tixtieq bulit
punt, lista ta 'balal.

410
00:18:41,120 --> 00:18:43,180
Lista ordnat hija lista nnumerati.

411
00:18:43,180 --> 00:18:47,930
U għalhekk inti ser tagħmel xi tag ul miftuħa u mbagħad
tunnellata ta 'elementi lista u mbagħad

412
00:18:47,930 --> 00:18:50,450
tagħlaq il tag ul. u li se
tinħoloq lista unordered.

413
00:18:50,450 --> 00:18:52,380
>> Aħna qed tmur biex tara xi eżempji
ta HTML fil-daqsxejn.

414
00:18:52,380 --> 00:18:55,800
Iżda qabel dakinhar, I rridu nġibu lill CSS.

415
00:18:55,800 --> 00:18:58,530
U CSS stands għall Cascading
Sheets Style.

416
00:18:58,530 --> 00:19:03,010
U dan huwa ferm qrib relatat
HTML imma kemmxejn differenti.

417
00:19:03,010 --> 00:19:06,920
Dan jgħinek format l-kontenut kollu
li l-istrutturi HTML.

418
00:19:06,920 --> 00:19:14,940
>> Għalhekk fl CSS, aħna ġeneralment ma jridux
stil kull header waħda jew kull

419
00:19:14,940 --> 00:19:17,250
immaġini waħda jew kull
paragrafu wieħed.

420
00:19:17,250 --> 00:19:21,210
Aħna rridu li l-istil xi elementi
jew forsi element speċifiku.

421
00:19:21,210 --> 00:19:25,250
U l-mod aħna stil speċifiku
element huwa li tagħtiha ID.

422
00:19:25,250 --> 00:19:26,070
>> Allura dan huwa attribut.

423
00:19:26,070 --> 00:19:27,960
Hija għandha ewlenin u valur.

424
00:19:27,960 --> 00:19:29,130
ID hija ċ-ċavetta.

425
00:19:29,130 --> 00:19:30,220
Logo huwa l-valur.

426
00:19:30,220 --> 00:19:32,410
I telgħet logo b'mod każwali.

427
00:19:32,410 --> 00:19:36,780
U jekk inti tagħti xi ħaġa ID,
ġenerali, li għandha tingħata biss

428
00:19:36,780 --> 00:19:38,800
li element wieħed.

429
00:19:38,800 --> 00:19:42,340
>> U mbagħad, fil-karta tal-istil tiegħek, inti tista '
stil li element partikolari, madankollu

430
00:19:42,340 --> 00:19:44,090
inti tixtieq li tfittex.

431
00:19:44,090 --> 00:19:49,560
Jekk inti tixtieq li l-istil numru ta '
elementi, forsi huwa ċerta klassi

432
00:19:49,560 --> 00:19:51,310
ta headers, biss xi wħud headers tiegħek.

433
00:19:51,310 --> 00:19:56,780
Forsi huwa header u ta 'immaġini u
paragrafu inti kollha jridu jiġu ċċentrata.

434
00:19:56,780 --> 00:20:00,700
Imbagħad inti tista 'tagħti dawk il-gruppi
elementi kollha ta 'klassi.

435
00:20:00,700 --> 00:20:04,300
U inti tista 'tagħti l-klassi
stili speċifiċi.

436
00:20:04,300 --> 00:20:08,860
Allura ID u klassi huma żewġ modi biex
ikissru kodiċi tiegħek, sabiex inti tista 'tgħin tkun

437
00:20:08,860 --> 00:20:11,990
aktar speċifiku dak li inti stil.

438
00:20:11,990 --> 00:20:13,830
>> Hemm tliet modi biex istil.

439
00:20:13,830 --> 00:20:17,530
L-ewwel waħda hija, bil-
dan l-attribut istil.

440
00:20:17,530 --> 00:20:21,200
Allura inti tara, il-muftieħ istil huwa stil.

441
00:20:21,200 --> 00:20:24,370
Il-valur istil huwa attwalment
ieħor lista valur ewlieni.

442
00:20:24,370 --> 00:20:26,570
>> F'dan il-każ, I telgħet
ċavetta waħda, fit-test tallinja.

443
00:20:26,570 --> 00:20:27,730
And I said, center.

444
00:20:27,730 --> 00:20:30,280
Inti tista 'tistaqsi lilek innifsek f'dan
punt, kif għamlet I taf dwar

445
00:20:30,280 --> 00:20:31,230
test tallinja.

446
00:20:31,230 --> 00:20:32,280
Dak li ma anki tagħmel?

447
00:20:32,280 --> 00:20:35,350
Li hija mistoqsija kbira li jistaqsu, u
aħna qed tmur biex tikseb hemm fit-tieni.

448
00:20:35,350 --> 00:20:39,740
Allura dak mod wieħed biex stil xi ħaġa,
biss jagħtu l-attribut stil.

449
00:20:39,740 --> 00:20:43,490
>> Mod ieħor biex stil xi ħaġa -
dan huwa Akshar imsemmi qabel.

450
00:20:43,490 --> 00:20:49,660
Tista 'tuża tags stil u li jitqiegħdu
fil-kap ta 'dokument HTML tiegħek.

451
00:20:49,660 --> 00:20:52,220
Allura int bażikament qal,
il-kontenut ġewwa hawn

452
00:20:52,220 --> 00:20:53,870
huwa xi kontenut stil.

453
00:20:53,870 --> 00:20:59,520
U l-format li huwa l-ħaġa inti
jixtiequ stil u mbagħad, ġewwa ta '

454
00:20:59,520 --> 00:21:03,460
braces kaboċċi, il-par valur ewlieni ta '
attributi li inti tixtieq li tagħti li

455
00:21:03,460 --> 00:21:05,920
dak it-tip partikolari ta 'element.

456
00:21:05,920 --> 00:21:07,370
>> Finalment, u dan huwa l-
aktar mod komuni.

457
00:21:07,370 --> 00:21:10,320
U dan huwa l-mod aħna
tagħmel dan fil sett p 7.

458
00:21:10,320 --> 00:21:12,370
Huwa ta 'karta tal-istil esterna.

459
00:21:12,370 --> 00:21:14,370
Hekk ikollok. Fajl css.

460
00:21:14,370 --> 00:21:18,050
U ġewwa ta 'dan, inti tara ħafna ta'
affarijiet li jixbhu dan, l-isem

461
00:21:18,050 --> 00:21:22,730
ta 'xi tip ta' element jew ID jew
klassi u mbagħad, ġewwa ta 'kaboċċi

462
00:21:22,730 --> 00:21:28,040
braces, lista ta 'pari valur ewlenin.

463
00:21:28,040 --> 00:21:30,065
>> Of course, jekk inti toħloq esterna
file, int ser

464
00:21:30,065 --> 00:21:31,310
jeħtieġ li jinkludu dan -

465
00:21:31,310 --> 00:21:34,860
sharp jinkludu, li kieku
jkun l-analoġija C -

466
00:21:34,860 --> 00:21:36,250
fil-file HTML tiegħek.

467
00:21:36,250 --> 00:21:39,820
Allura inti għandek tinkludi din
kodiċi fil-fajl HTML tiegħek.

468
00:21:39,820 --> 00:21:46,080
Dan huwa l-isem tal-fajl u
jekk wieħed jassumi huwa fl-istess direttorju.

469
00:21:46,080 --> 00:21:47,100
>> OK.

470
00:21:47,100 --> 00:21:48,200
Dan kien ħafna.

471
00:21:48,200 --> 00:21:52,440
U aħna issa qed tmur biex tieħu n-nifs u jfittxu
f'xi reali, website ħajjin u

472
00:21:52,440 --> 00:21:53,720
tesplora dan aktar.

473
00:21:53,720 --> 00:21:55,470
Iżda qabel ma nagħmlu dan, ma xi ħadd
xi mistoqsijiet?

474
00:21:55,470 --> 00:22:00,830

475
00:22:00,830 --> 00:22:04,970
>> Mela jekk inti tixtieq li tagħmel dan flimkien ma '
me, nistgħu mmorru għall-appliance.

476
00:22:04,970 --> 00:22:08,950
And I għażlet l-home page CS50.

477
00:22:08,950 --> 00:22:10,020
Tista 'tagħmel dan ma' kwalunkwe website.

478
00:22:10,020 --> 00:22:13,070
Iżda għaliex ma we tibda bil
il-homepage CS50?

479
00:22:13,070 --> 00:22:14,650
>> Ejja jġedded.

480
00:22:14,650 --> 00:22:18,030
I attwalment jirrakkomanda ħafna li inti tagħmel
dan flimkien miegħi, għaliex dak li aħna

481
00:22:18,030 --> 00:22:22,720
huma se jagħmlu issa se tkun
oerhört handy għalik, mhux biss fl-

482
00:22:22,720 --> 00:22:24,450
P-Set 7, iżda P-Set 8 kif ukoll.

483
00:22:24,450 --> 00:22:24,810
Yeah.

484
00:22:24,810 --> 00:22:29,560
>> UDJENZA: Hemm mod biex tagħmel kummenti
fil HTML, mingħajr l-użu PHP?

485
00:22:29,560 --> 00:22:31,130
>> JASON Hirschhorn: Iva, tista '
jagħmlu kummenti HTML.

486
00:22:31,130 --> 00:22:32,690
>> UDJENZA: X'hemm-sintassi?

487
00:22:32,690 --> 00:22:34,340
>> UDJENZA: marka Exclamation sing sing.

488
00:22:34,340 --> 00:22:36,125
>> UDJENZA: OK.

489
00:22:36,125 --> 00:22:37,100
>> JASON Hirschhorn: Iva.

490
00:22:37,100 --> 00:22:38,350
Dan huwa l-sintassi.

491
00:22:38,350 --> 00:22:40,630

492
00:22:40,630 --> 00:22:41,900
Inti tista 'tagħmel kummenti HTML.

493
00:22:41,900 --> 00:22:43,310
Inti tista 'tagħmel kummenti bil-PHP.

494
00:22:43,310 --> 00:22:46,590
>> Kif tkun taf tara, jikkummentaw fl HTML se
għadhom juru up, meta nħarsu lejn l-

495
00:22:46,590 --> 00:22:49,960
Kodiċi sors HTML ta 'sit partikolari.

496
00:22:49,960 --> 00:22:51,610
Allura dan cs50.net.

497
00:22:51,610 --> 00:22:57,360
Jekk inti dritt ikklikkja fil-aktar moderni
browsers fuq ħafna kull paġna, inti ħsieb

498
00:22:57,360 --> 00:22:58,820
is-sors paġna.

499
00:22:58,820 --> 00:23:01,480
Mela ejja tagħmel dan fuq CS50.

500
00:23:01,480 --> 00:23:05,060
>> U lo u behold, aħna
ara ħaġa ġgant.

501
00:23:05,060 --> 00:23:07,420
CS50 attwalment jistenna pretty sbieħ.

502
00:23:07,420 --> 00:23:08,920
A lott ta 'websajts mhux se
tħares dan sbieħ.

503
00:23:08,920 --> 00:23:10,540
Jekk inti tmur għall-homepage tal-Google
u tiftaħ it up.

504
00:23:10,540 --> 00:23:11,960
Dan mhux ser tfittex dan sbieħ.

505
00:23:11,960 --> 00:23:13,830
>> Iżda tinnota li, fil-quċċata -

506
00:23:13,830 --> 00:23:16,650
dan huwa tip ta 'intrapriżi żgħar.

507
00:23:16,650 --> 00:23:17,900
Ejja jagħmlu dan akbar.

508
00:23:17,900 --> 00:23:22,660

509
00:23:22,660 --> 00:23:23,570
OK.

510
00:23:23,570 --> 00:23:26,660
Fil-quċċata, DOCTYPE HTML,
li l-familjari.

511
00:23:26,660 --> 00:23:30,650
Imbagħad naraw l-tikketta HTML miftuħ u
ir-ras, dritt hawn, kollha

512
00:23:30,650 --> 00:23:34,350
ta 'dawn meta tags.

513
00:23:34,350 --> 00:23:38,000
U inti tista 'tara dan og, mhux
se jmorru fil dak issa.

514
00:23:38,000 --> 00:23:42,110
Imma I am kważi pożittiv f'dak
dawk tkun Facebook.

515
00:23:42,110 --> 00:23:42,900
>> Dan huwa effettivament il-Facebook.

516
00:23:42,900 --> 00:23:44,870
Naħseb li stands għal grafika miftuħa.

517
00:23:44,870 --> 00:23:48,930
Mela ftakar, I kien isemmi hemm
Metadata speċifiċi għall Faceboook tista

518
00:23:48,930 --> 00:23:49,800
jagħtu għal paġna.

519
00:23:49,800 --> 00:23:51,150
Dak hu li huwa dritt hawn.

520
00:23:51,150 --> 00:23:54,580
>> Allura meta inti link f'din il-paġna fuq Facebook,
l-immaġni li għaddej biex juru

521
00:23:54,580 --> 00:23:56,630
huwa dan image dritt hawn.

522
00:23:56,630 --> 00:23:58,310
U inti attwalment tara li huwa
Facebook, għaliex dan huwa

523
00:23:58,310 --> 00:23:59,470
l-immaġni Facebook.

524
00:23:59,470 --> 00:24:00,880
>> Iżda xorta waħda, aħna jkollna aside.

525
00:24:00,880 --> 00:24:03,220
Allura aħna għandna xi tags metadejta hawn.

526
00:24:03,220 --> 00:24:05,570
Naraw it-titolu CS50.

527
00:24:05,570 --> 00:24:09,830
U għal darb'oħra, it-titolu huwa dak li tmur
up hawn fil-tab browser.

528
00:24:09,830 --> 00:24:14,770
Naraw dan huwa li tgħaqqad, dritt hawn,
fajl JavaScript esterna.

529
00:24:14,770 --> 00:24:17,640
>> Aħna ma tkellem dwar JavaScript ħafna,
iżda ġimgħa d-dieħla - u ċertament jekk

530
00:24:17,640 --> 00:24:20,350
int tagħmel sett problema fuq l-internet,
tkun se tuża JavaScript.

531
00:24:20,350 --> 00:24:23,540
Dan huwa kif inti link fl esterna
JavaScript fajls.

532
00:24:23,540 --> 00:24:31,970
Naraw dritt hawn, finalment, il-CSS
karta tal-istil, li jiddokumenta dawn

533
00:24:31,970 --> 00:24:32,830
stili ta 'dan il-kodiċi.

534
00:24:32,830 --> 00:24:37,190
>> Ejja attwalment miftuħa li sa u
tagħti ħarsa verament malajr.

535
00:24:37,190 --> 00:24:38,440
Dan jistenna crazy.

536
00:24:38,440 --> 00:24:40,840

537
00:24:40,840 --> 00:24:42,790
M'hemm l-ebda mod inkun
kapaċi li tinqara permezz.

538
00:24:42,790 --> 00:24:46,930
Allura inti tista 'attwalment għalkemm, jekk tieħu
ħarsa, inti tista 'tip ta' tara li

539
00:24:46,930 --> 00:24:48,650
- hemm

540
00:24:48,650 --> 00:24:49,790
hemm immorru.

541
00:24:49,790 --> 00:24:53,440
>> Li qisu xi ħaġa li aħna stajt tidher
qabel, kulur fl-isfond, dan ikun iffissat

542
00:24:53,440 --> 00:24:55,550
daqs xi valur aħmar-aħdar-blu.

543
00:24:55,550 --> 00:24:59,070
Dan Jittieħed tip ta m'għandhomx jidhru li
barrani, anki jekk, meta jkun ippreżentat

544
00:24:59,070 --> 00:25:00,850
bħal dan, jista 'jkun
daqsxejn qawwija.

545
00:25:00,850 --> 00:25:03,340
Aħna mhux qed tmur biex tħares lejn dan il-fajl CSS
jew iqattgħu ħafna ħin fuq dan, għaliex

546
00:25:03,340 --> 00:25:06,030
huwa, għal darb'oħra, pjuttost diffiċli biex jinqara.

547
00:25:06,030 --> 00:25:09,090
>> Ejja ħa mmorru lura għal dan
Paġna HTML għall CS50.

548
00:25:09,090 --> 00:25:10,930
U ejja iscroll lill-korp.

549
00:25:10,930 --> 00:25:14,730
U ġewwa naraw dan il-tikketta div.

550
00:25:14,730 --> 00:25:18,370
Naraw header dritt hawn.

551
00:25:18,370 --> 00:25:21,060
Naraw l-tikketta ankra.

552
00:25:21,060 --> 00:25:26,050
>> U dan l-element il-lista hija
mogħtija klassi speċifika.

553
00:25:26,050 --> 00:25:28,370
U naraw dik il-klassi ripetut
aktar u aktar mill-ġdid.

554
00:25:28,370 --> 00:25:29,730
Hemm inti Curtis.

555
00:25:29,730 --> 00:25:32,730
Hemm il-kumment fil HTML5.

556
00:25:32,730 --> 00:25:36,280
>> U kif tinnota, nistgħu xorta tara
dan, iżda huwa ma juru up.

557
00:25:36,280 --> 00:25:37,960
Huwa fil-fatt tassew interessanti.

558
00:25:37,960 --> 00:25:40,760
Jidher qisu din il-lista punteġġi
element huwa ikkummenta out.

559
00:25:40,760 --> 00:25:45,110
Jekk immorru din il-paġna, għal darb'oħra, xorta
jidher hemm, hekk interessanti.

560
00:25:45,110 --> 00:25:47,830
>> Oh, hu għalhekk li, minħabba
ta 'din il-linja li jmiss.

561
00:25:47,830 --> 00:25:50,680

562
00:25:50,680 --> 00:25:52,735
What do inkella naraw ta 'interess?

563
00:25:52,735 --> 00:25:56,640

564
00:25:56,640 --> 00:26:00,180
Il-bqija ta 'dan huwa aktar konfużjoni, b'mod
jittrattaw din il-nofs tal-lemin ta 'l-

565
00:26:00,180 --> 00:26:03,280
website, li hija ftit
daqsxejn aktar kumplessi.

566
00:26:03,280 --> 00:26:08,890
>> Allura dan huwa dak li xi wħud HTML
se look like.

567
00:26:08,890 --> 00:26:10,990
Għalija għalkemm, dan huwa ftit
kbira, u dan ma

568
00:26:10,990 --> 00:26:12,350
għinni li ħafna.

569
00:26:12,350 --> 00:26:16,560
Madankollu, hemm xi ħaġa li
ma, fil-fatt, għinni ħafna.

570
00:26:16,560 --> 00:26:20,490
>> U dan huwa dak I-użu kull meta jien
jippruvaw figura kif xi ħaġa

571
00:26:20,490 --> 00:26:24,270
jistenna l-mod li ma, jew kif jista '
I jagħmlu bidliet għall-website tiegħi.

572
00:26:24,270 --> 00:26:29,280
U li hija għodda iżviluppatur
li hija mibnija fis Chrome.

573
00:26:29,280 --> 00:26:33,960
Mela jekk inti tmur għal dan tliet bars dritt
hawn u jinżlu għal għodod ikklikkja fuq

574
00:26:33,960 --> 00:26:40,120
Developer Tools, tieqa ftit se
pop up fil-qiegħ tal-paġna.

575
00:26:40,120 --> 00:26:46,910
U b'mod partikolari, Chrome, peress li huwa
meraviljuża, se format il-tieqa u

576
00:26:46,910 --> 00:26:49,580
jieħdu l-HTML u jagħmluha ħarsa
ħafna nicer għalik.

577
00:26:49,580 --> 00:26:54,860
Allura issa huwa attwalment ftit kollassabbli
HTML li inti tista 'tesplora biex jispezzjonaw

578
00:26:54,860 --> 00:26:56,620
l-elementi tal-paġna.

579
00:26:56,620 --> 00:26:59,400
>> Jekk irridu li nħarsu lejn il-ġisem,
fil-fatt jenfasizza.

580
00:26:59,400 --> 00:27:03,240
Meta inti iscroll fuq parti mill-HTML,
stabbiliti f'dan tieqa, se

581
00:27:03,240 --> 00:27:06,530
jenfasizzaw il-parti li jitkellem
dwar fit-tieqa kbira.

582
00:27:06,530 --> 00:27:10,800
So let me darb'oħra jippruvaw u
blow dan up a bit.

583
00:27:10,800 --> 00:27:12,170
OK.

584
00:27:12,170 --> 00:27:13,550
>> Mela ejja tiftaħ il-ġisem.

585
00:27:13,550 --> 00:27:17,280
U jien scrolling matul dan div xellug.

586
00:27:17,280 --> 00:27:21,420
U tinnota li huwa tenfasizza
Din it-taqsima tax-xellug tal-iskrin.

587
00:27:21,420 --> 00:27:25,710
Mela ejja ikklikkja fuq dik
u jespandu dan.

588
00:27:25,710 --> 00:27:27,280
>> Ġewwa ta 'dan, jidher qisu
hemm żewġ divs.

589
00:27:27,280 --> 00:27:29,790
Hemm dan l-ewwel div.

590
00:27:29,790 --> 00:27:30,760
I ma tara li enfasizzati.

591
00:27:30,760 --> 00:27:35,900
I do not know, iżda jidher qisu dan
tieni waħda, xellug ta 'ġewwa, huwa l-kontenut

592
00:27:35,900 --> 00:27:37,700
fuq in-naħa tax-xellug tal-iskrin.

593
00:27:37,700 --> 00:27:39,360
>> Imbagħad hemm dan ħaġa imsejħa header.

594
00:27:39,360 --> 00:27:41,890
Jidher qisu thats jenfasizzaw
il-parti CS50.

595
00:27:41,890 --> 00:27:46,600
Jekk aħna miftuħa li up, naraw li huwa
xejn aktar minn header 1.

596
00:27:46,600 --> 00:27:51,140
Huwa mogħti ID, u huwa
minħabba l-cs50 test.

597
00:27:51,140 --> 00:27:57,240
>> Għalhekk għal darb'oħra, tħares lejn dan permezz ta 'dan
console jew jużaw l-għodod iżviluppatur

598
00:27:57,240 --> 00:28:00,710
pane fil-qiegħ ta 'jagħmel iskrin
esplorazzjoni din il-websajt, wieħed jittama, a

599
00:28:00,710 --> 00:28:02,990
ħafna inqas intimidanti u
ħafna aktar aċċessibbli.

600
00:28:02,990 --> 00:28:06,360
Hija tippermetti wkoll li nifhmu li
din il-websajt, għalkemm huwa jistenna ħafna

601
00:28:06,360 --> 00:28:09,210
pretty u sbieħ, mhux kollha li ħafna
aktar minn dak li int ser tkun

602
00:28:09,210 --> 00:28:10,430
tagħmel fuq Problem Set 7.

603
00:28:10,430 --> 00:28:13,080
U dan huwa totalment fi ħdan
ħila tiegħek biex joħolqu.

604
00:28:13,080 --> 00:28:14,110
>> Jekk irridu li -

605
00:28:14,110 --> 00:28:18,270
il-ħaġa jibred oħra dwar l-użu dawn
għodod, jekk inti dritt ikklikkja fuq il-

606
00:28:18,270 --> 00:28:22,270
titolu, inti tista 'jeditjaw il-HTML.

607
00:28:22,270 --> 00:28:25,660
Mela ejja sejħa hija Jason.

608
00:28:25,660 --> 00:28:28,990
U issa inti taf Avviż I inbidlu
HTML f'din il-paġna.

609
00:28:28,990 --> 00:28:31,020
>> Of course, I ma nbidlux
b'mod permanenti.

610
00:28:31,020 --> 00:28:34,570
Jekk I jġedded browser tiegħi, allura
jmorru lura għall-HTML oriġinali.

611
00:28:34,570 --> 00:28:38,860
Imma kultant nixtieq li debug kodiċi tiegħi,
u jien ma tixtieq tfittex biss ikollhom tiegħi

612
00:28:38,860 --> 00:28:41,370
tieqa gedit u jippruvaw jifhmu
x'inhu għaddej.

613
00:28:41,370 --> 00:28:42,705
>> Irrid nara x'se jiġri ħajjin.

614
00:28:42,705 --> 00:28:45,880
So I ser jeditjaw kodiċi bħal dan u jiksbu
dan il-mod I tixtieq li tfittex.

615
00:28:45,880 --> 00:28:47,960
U mbagħad I ser tagħmel l-
bidliet fil-kodiċi tiegħi.

616
00:28:47,960 --> 00:28:50,010
>> U nsib li huwa ħafna aktar faċli
meta inti tista 'tagħmel l-affarijiet

617
00:28:50,010 --> 00:28:52,400
istantanju, bħal dik.

618
00:28:52,400 --> 00:28:58,410
Say, għal darb'oħra, irridu li jagħmlu ieħor
ċans, għaliex aħna qed tesplora flimkien ma

619
00:28:58,410 --> 00:29:00,340
HTML u CSS dritt issa.

620
00:29:00,340 --> 00:29:02,600
I tista 'jeditjaw il-HTML dritt issa.

621
00:29:02,600 --> 00:29:06,680
U jien ser jinkludi rabta.

622
00:29:06,680 --> 00:29:10,650
>> Hekk jien se jibdlu dar CS50 tal
paġna, u għalhekk se link -

623
00:29:10,650 --> 00:29:12,060
ejja ngħidu - home page tiegħi.

624
00:29:12,060 --> 00:29:16,700
X'inhu l-isem, jekk xi ħadd ifakkar, jew
x'inhu l-attribut I jridu jagħtu

625
00:29:16,700 --> 00:29:18,850
għal tab ankra meta I jridu
li tkun marbuta x'imkien ieħor?

626
00:29:18,850 --> 00:29:19,562
>> UDJENZA: href?

627
00:29:19,562 --> 00:29:20,812
>> JASON Hirschhorn: href -

628
00:29:20,812 --> 00:29:32,520

629
00:29:32,520 --> 00:29:35,750
Allura issa, int ser tara li hemm
huwa jenfasizzaw taħt Jason.

630
00:29:35,750 --> 00:29:40,170
Dak għax Chrome, awtomatikament,
tagħti ankri li jenfasizzaw.

631
00:29:40,170 --> 00:29:41,990
You ħadthom probabbilment jidhru li qabel
meta inti stajt marret għal paġna web.

632
00:29:41,990 --> 00:29:44,200
Affarijiet li huma konnessjonijiet huma
enfasizzat u blu.

633
00:29:44,200 --> 00:29:47,300
L-istil default għal rabta
huwa biex jenfasizzaw

634
00:29:47,300 --> 00:29:48,830
u poġġih fil-blu.

635
00:29:48,830 --> 00:29:50,050
>> Jekk jien ma simili li,
I jistgħux jibdlu din.

636
00:29:50,050 --> 00:29:51,220
U aħna ser jibdlu fit-tieni.

637
00:29:51,220 --> 00:29:54,660
Imma issa, ukoll avviż li, jekk I imbagħad jerġgħu
matul dan, fil-qiegħ tax-xellug tal-

638
00:29:54,660 --> 00:29:58,580
screen, dritt fuq l-elementi verbali
hija r-rabta li I tatha.

639
00:29:58,580 --> 00:30:03,080
>> Hekk jekk I ma ikklikkja fuq dan - u nistgħu
dritt ikklikkja fuq dan, tiftaħ ġdid tab.

640
00:30:03,080 --> 00:30:04,520
Din mhix attwalment homepage tiegħi.

641
00:30:04,520 --> 00:30:06,700
Huwa biss l-isem tiegħi.

642
00:30:06,700 --> 00:30:07,210
Hemm inti tmur.

643
00:30:07,210 --> 00:30:10,440
Imxejna issa jibdluh link.

644
00:30:10,440 --> 00:30:13,220
>> Ejja tesplora xi wħud CSS ukoll.

645
00:30:13,220 --> 00:30:15,680
Il-ħaġa sabiħa - u jien ser
tagħmel dan ftit iżgħar - madwar

646
00:30:15,680 --> 00:30:19,480
dan console huwa, li l-karta CSS crazy
rajna qabel, dan kien tassew

647
00:30:19,480 --> 00:30:24,130
diffiċli biex parse, issa huwa beautifully
stabbiliti għalina fuq in-naħa tax-xellug

648
00:30:24,130 --> 00:30:25,270
ta 'dan pane.

649
00:30:25,270 --> 00:30:27,230
Allura nistgħu nħarsu.

650
00:30:27,230 --> 00:30:33,690
U jekk aħna jespandu dan tab stili, aħna
tista 'tara l-istili differenti

651
00:30:33,690 --> 00:30:37,940
li huma assoċjati ma ', f'dan il-każ,
dan l-element partikolari, dan

652
00:30:37,940 --> 00:30:39,700
element link.

653
00:30:39,700 --> 00:30:44,240
>> Jekk nagħmlu l-tab stili kompost, li
biss jurina, mhux fejn kollox

654
00:30:44,240 --> 00:30:47,450
ġej minn, iżda essenzjalment kollha ta 'dawn
stili li qed joperaw fuq

655
00:30:47,450 --> 00:30:51,220
dan l-element partikolari dritt issa.

656
00:30:51,220 --> 00:30:55,050
U ejja ngħidu, irridu
biex jibdlu daqsxejn.

657
00:30:55,050 --> 00:30:58,870

658
00:30:58,870 --> 00:31:02,740
Allura dan huwa l-istili li huma
joperaw fuq dan l-element partikolari.

659
00:31:02,740 --> 00:31:04,800
Say irridu li jibdlu dan, għaliex aħna
trid tara kif xi ħaġa jistenna.

660
00:31:04,800 --> 00:31:06,050
U aħna qed biss playing
madwar dritt issa.

661
00:31:06,050 --> 00:31:08,720
Jew irridu li tittestja xi ħaġa out, qabel
kitba fil-kodiċi u l-imbuttar

662
00:31:08,720 --> 00:31:10,150
dan u jagħmilha ħajjin.

663
00:31:10,150 --> 00:31:11,780
>> Aħna tista 'tmur għall-tab stili.

664
00:31:11,780 --> 00:31:14,270
U fl-ewwel kaxxa hija
jgħid, element.style.

665
00:31:14,270 --> 00:31:17,020
U fil hawn, inti tista 'daħħal,
inti tista 'żżid xi ħaġa.

666
00:31:17,020 --> 00:31:18,550
>> So I tixtieq li -

667
00:31:18,550 --> 00:31:22,360
ejja mur rabta tiegħi u l-
jistabbilixxu l-kulur fl-isfond.

668
00:31:22,360 --> 00:31:25,830
U fil-fatt autofills dan għalik,
il-karatteristiċi eventwalment.

669
00:31:25,830 --> 00:31:29,360
Kulur fl-isfond, u nixtieq
biex jagħmlu dak blu.

670
00:31:29,360 --> 00:31:31,520
Blus mhijiex kelma.

671
00:31:31,520 --> 00:31:32,400
Blue hija kelma.

672
00:31:32,400 --> 00:31:34,490
>> Did I jarawha toħroġ?

673
00:31:34,490 --> 00:31:35,800
Oh, huwa li għaliex dan huwa fil-href?

674
00:31:35,800 --> 00:31:36,550
OK.

675
00:31:36,550 --> 00:31:40,220
So I ma tara l-ebda bidla hawnhekk.

676
00:31:40,220 --> 00:31:45,100
U dan għaliex, jekk aħna jenfasizzaw l-
link, inti ser ikollok avviż li l-link

677
00:31:45,100 --> 00:31:48,430
mhix attwalment jikkontrollaw in
proprjetajiet ta 'dan l-element partikolari.

678
00:31:48,430 --> 00:31:52,430
Huwa fil-fatt, jekk aħna tiftaħ il-link,
din header dritt hawn li l-

679
00:31:52,430 --> 00:31:53,590
jikkontrollaw dak li jidher qisu.

680
00:31:53,590 --> 00:31:56,380
>> Mela jekk jien tixtieq li tagħmel l-isfond
blu, I attwalment jkollhom bidla

681
00:31:56,380 --> 00:31:59,640
kulur fl-isfond fuq il-
element header.

682
00:31:59,640 --> 00:32:02,700
U issa naraw li l-
isfond huwa blu.

683
00:32:02,700 --> 00:32:06,770
>> Għalhekk għal darb'oħra, dan malajr jista 'jkun għaddej
permezz ta dan il-materjal pretty malajr.

684
00:32:06,770 --> 00:32:08,580
Iżda dan huwa essenzjalment dak
int se tkun qed twettaq.

685
00:32:08,580 --> 00:32:10,860
Huwa mhux fuq Problem Set 7,
iżda ċertament meta int

686
00:32:10,860 --> 00:32:12,080
kodifikazzjoni fuq il-web.

687
00:32:12,080 --> 00:32:12,360
>> OK.

688
00:32:12,360 --> 00:32:13,780
I jixtiequ jagħmlu l-blu isfond.

689
00:32:13,780 --> 00:32:16,180
Anki jekk, f'dan il-każ,
blu jistenna pretty ikrah.

690
00:32:16,180 --> 00:32:17,740
I tista 'tmur fil hawn, play madwar.

691
00:32:17,740 --> 00:32:20,515
Nara li jinbidlu għal blu
ma taħdimx fuq il-a.

692
00:32:20,515 --> 00:32:26,710
I jkollhom biex effettivament jibdel il-header
element li tinkludi l-blu

693
00:32:26,710 --> 00:32:28,200
isfond.

694
00:32:28,200 --> 00:32:34,450
>> U mbagħad, jekk imbagħad immur lura għall CSS tiegħi
file, kif nista attwalment jistabbilixxu dan

695
00:32:34,450 --> 00:32:37,520
isfond li jkun blu u
tagħmel dan stick bidla?

696
00:32:37,520 --> 00:32:44,840
Għaliex jekk aħna Avviż jekk I jġedded il-
paġna, l-bidliet I magħmula huma marret.

697
00:32:44,840 --> 00:32:47,220
So I realizzati, OK, my
isfond huwa blu.

698
00:32:47,220 --> 00:32:51,260
>> I bżonn biex tmur f'dak element header1
u bidla fil-kulur fl-isfond għal ikħal.

699
00:32:51,260 --> 00:32:52,710
Kif nista 'tagħmel attwalment din il-bidla?

700
00:32:52,710 --> 00:32:57,040
Ukoll, ifakkar li, jekk immorru ġewwa
ta 'hawn, din header, il-

701
00:32:57,040 --> 00:32:59,280
titolu għandu ID.

702
00:32:59,280 --> 00:33:00,890
U li titolu.

703
00:33:00,890 --> 00:33:09,010
>> U hekk fil-fajl CSS tagħna, nistgħu ngħidu, OK,
tieħu xejn ma ID ta 'titolu u

704
00:33:09,010 --> 00:33:11,330
tagħtiha din il-proprjetà addizzjonali.

705
00:33:11,330 --> 00:33:18,010
Kif nistgħu referenza ħaġa ma 'l-
ID ta 'titolu, xi ideat, jew xi ħadd

706
00:33:18,010 --> 00:33:24,406
taf kif aħna referenza
IDs fil-fajl CSS tagħna?

707
00:33:24,406 --> 00:33:26,290
>> A hash, dan huwa eżattament id-dritt.

708
00:33:26,290 --> 00:33:28,710
U inti ltqajna ħjiel ta 'dak id-dritt hawn.

709
00:33:28,710 --> 00:33:32,810
Allura x'imkien f'dan il-fajl CSS,
hemm din il-linja tal-kodiċi -

710
00:33:32,810 --> 00:33:34,150
# Xellug # left-ġewwa # header # titolu.

711
00:33:34,150 --> 00:33:36,810

712
00:33:36,810 --> 00:33:40,590
U huwa jtuha qiegħ marġini,
tiddefinixxi l-qiegħ marġni ta 'din

713
00:33:40,590 --> 00:33:42,220
partikolari element.

714
00:33:42,220 --> 00:33:46,580
>> Ukoll, jekk I riedu bidla li,
I imur fis dan il-fajl CSS.

715
00:33:46,580 --> 00:33:49,510
And I tista 'jew isibu din
parti mill-fajl CSS.

716
00:33:49,510 --> 00:33:50,300
Jew I tista 'tikteb tiegħi stess.

717
00:33:50,300 --> 00:33:54,670
>> I tista 'tagħmel hash Brace kaboċċi titolu u
imbagħad kolon kulur fl-isfond ikħal

718
00:33:54,670 --> 00:33:57,250
virgola u qrib li kaboċċi Brace.

719
00:33:57,250 --> 00:34:02,790
U li tkun tista tbiddel l-isfond
kulur ta 'dan l-element għal ikħal.

720
00:34:02,790 --> 00:34:06,690
Ir-raġuni li jagħtuk tant hawnhekk huwa
dan, huwa neċessarju f'dan il-każ,

721
00:34:06,690 --> 00:34:08,690
għaliex it-titolu huwa ID unika.

722
00:34:08,690 --> 00:34:11,190
>> Imma dak li inti tista 'tagħmel huwa affarijiet bejta.

723
00:34:11,190 --> 00:34:14,760
Allura dan huwa qal, OK, mur lejn ix-xellug.

724
00:34:14,760 --> 00:34:15,350
C'est żgħir ħafna.

725
00:34:15,350 --> 00:34:16,150
I ruhna għal dan.

726
00:34:16,150 --> 00:34:17,750
>> Iżda jmorru għall-ħaġa ma ID xellug.

727
00:34:17,750 --> 00:34:20,420
Ġewwa ta 'dan, tfittex l-
ħaġa ma ID xellug ta 'ġewwa.

728
00:34:20,420 --> 00:34:22,630
Ġewwa ta 'li tfittex, tfittex
il-ħaġa ma header ID.

729
00:34:22,630 --> 00:34:27,560
Ġewwa ta 'dan, tfittex il-ħaġa
Titolu ID u ibiddel it-titolu ID.

730
00:34:27,560 --> 00:34:29,120
Allura dan huwa biss mod
affarijiet nesting.

731
00:34:29,120 --> 00:34:32,719
Xi nies bħal bejta dan, għaliex
jagħmilha daqsxejn aktar ċara.

732
00:34:32,719 --> 00:34:37,980
>> Int ser ikollok tara stabbiliti hawnhekk ukoll, id-dritt
hawn, hemm ebda hash.

733
00:34:37,980 --> 00:34:39,449
Huwa biss H1.

734
00:34:39,449 --> 00:34:44,060
Dak għax h1 jingħata l-
isem ta 'tag ġeneriku.

735
00:34:44,060 --> 00:34:48,080
U hemm xi proprjetajiet CSS
assoċjati ma 'kull h1 waħda.

736
00:34:48,080 --> 00:34:51,889
Mela jekk sibt h1 ieħor f'din il-paġna,
I se jaraw ukoll li dan l-istil kien

737
00:34:51,889 --> 00:34:54,280
applikati għal dan ukoll.

738
00:34:54,280 --> 00:34:59,290
>> Jekk jien ridt li japplikaw stil għal klassi,
kif nista jagħmlu riferenza għal klassi jew

739
00:34:59,290 --> 00:35:02,469
jitkellmu dwar klassi fil-fajl CSS?

740
00:35:02,469 --> 00:35:03,315
>> UDJENZA: Dot.

741
00:35:03,315 --> 00:35:05,340
>> JASON Hirschhorn: Huwa bit-tikka.

742
00:35:05,340 --> 00:35:08,630
Mela ejja mmorru lura għal din il-paġna qabel.

743
00:35:08,630 --> 00:35:11,160
Jekk I do ID hash.

744
00:35:11,160 --> 00:35:14,760
Li jinbidlu l-istil
tal-ħaġa ma ID.

745
00:35:14,760 --> 00:35:21,390
Jew sorry, jekk I do logo hash, li l-
konstatazzjoni tal-ħaġa ma 'l-ID tal-logo

746
00:35:21,390 --> 00:35:24,010
u jtuha stil CSS partikolari.

747
00:35:24,010 --> 00:35:28,280
>> Jekk nagħmel xi ħaġa. Top, thats konstatazzjoni
kollox mal-klassi ta 'fuq u

748
00:35:28,280 --> 00:35:30,190
jinbidlu stili tagħha.

749
00:35:30,190 --> 00:35:35,950
Jekk jien sempliċiment H1, li ssib kull
h1 waħda u jagħtiha l-kwalunkwe

750
00:35:35,950 --> 00:35:37,940
stil Irrid li tagħtiha.

751
00:35:37,940 --> 00:35:43,260
Jekk I do ispazju h1 u mbagħad. Top.

752
00:35:43,260 --> 00:35:47,670
Li se jmorru jsibu l-h1s u mbagħad
kollha dawk bl-klassi ta 'fuq u

753
00:35:47,670 --> 00:35:51,690
allura biss bidla dawk stili li
x'ikun nixtieq li tagħtiha.

754
00:35:51,690 --> 00:35:54,600
>> U għal darb'oħra, jista 'jkollna bil-miktub
xi wħud minn dan waħedna.

755
00:35:54,600 --> 00:35:55,790
Iżda aħna ma gotten li s'issa.

756
00:35:55,790 --> 00:35:59,180
Ħafna aħjar, jidher li fil-fatt imorru
fuq websajt ħajjin reali u tara kif

757
00:35:59,180 --> 00:36:02,800
huma jagħmlu dan u ħarsa fil-livelli kollha tal-
affarijiet meraviljuż ikollok tagħmel.

758
00:36:02,800 --> 00:36:06,570
>> Ejja nħarsu lejn wieħed aktar website
qabel nimxu fuq.

759
00:36:06,570 --> 00:36:10,150
U dan huwa wieħed li inti probabilment
jsiru familjari magħhom.

760
00:36:10,150 --> 00:36:12,310
Dan huwa CS50 Finanzi.

761
00:36:12,310 --> 00:36:16,120
Għalhekk għal darb'oħra, inti tista 'attwalment tmur fi u
josservaw dan il-fajl CSS fuq tiegħek

762
00:36:16,120 --> 00:36:19,390
kompjuter, għaliex inti ħadthom jitniżżel dan
Fajl CSS, jekk inti jitniżżel l-

763
00:36:19,390 --> 00:36:20,270
problema stabbiliti.

764
00:36:20,270 --> 00:36:26,850
>> Nistgħu mur Għodod u
Developer Tools.

765
00:36:26,850 --> 00:36:30,280
U naraw tqassim HTML ferm aktar sempliċi.

766
00:36:30,280 --> 00:36:32,020
Għandna fuq, nofs u isfel.

767
00:36:32,020 --> 00:36:34,490
U għal darb'oħra, xi ħaġa inti għandek tkun
familjari ma ', għaliex inti stajt ħares

768
00:36:34,490 --> 00:36:37,680
permezz tal-kodiċi ta 'distribuzzjoni
għal problema din il-ġimgħa stabbiliti.

769
00:36:37,680 --> 00:36:43,360
>> Fil-quċċata hija, per-kodiċi,
immaġini waħda msejħa.

770
00:36:43,360 --> 00:36:47,170
U li huwa sors ta 'l-immaġini.

771
00:36:47,170 --> 00:36:52,170
Say I spiċċajt kollha ta 'dak
Jien ridt li għal Problem Set 7.

772
00:36:52,170 --> 00:36:55,500
U huwa jaħdem sew, iżda
Irrid li bidla kif jidher.

773
00:36:55,500 --> 00:36:58,900
U nixtieq li jibdlu l-isfond
tal-quċċata tal-paġna biex,

774
00:36:58,900 --> 00:37:01,000
per eżempju, blu.

775
00:37:01,000 --> 00:37:04,860
Kieku kien me, I kien jidħol fil-
hawn u ċifra barra, OK liema

776
00:37:04,860 --> 00:37:05,890
do I trid tibdel.

777
00:37:05,890 --> 00:37:08,700
>> Ejja naraw, div ID top, li jistenna
bħall-quċċata tal-paġna.

778
00:37:08,700 --> 00:37:09,910
Mela ejja jmorru hemm.

779
00:37:09,910 --> 00:37:13,940
Ejja nippruvaw jinbidlu l-
kulur fl-isfond.

780
00:37:13,940 --> 00:37:16,360
Ejja ħa mmorru nagħmlu Alice blu, għaliex
thats wieħed nicer.

781
00:37:16,360 --> 00:37:18,010
>> U inti ser ikollok avviż li -

782
00:37:18,010 --> 00:37:19,190
inti probabilment ma tistax tara dan.

783
00:37:19,190 --> 00:37:23,430
Iżda hemm dawl blu,
flimkien mal-logo CS50.

784
00:37:23,430 --> 00:37:25,810
Ejja bidla minflok għal aħmar.

785
00:37:25,810 --> 00:37:28,790
U inti taf Avviż issa I biss mibdula
isfond bil-kulur aħmar.

786
00:37:28,790 --> 00:37:37,050
>> Allura issa I ser imorru għall-fajl CSS tiegħi u
tip # paren kaboċċi top dritt hawn.

787
00:37:37,050 --> 00:37:42,170
Tista 'tara d-dritt kodiċi
hawn, kaboċċi Brace.

788
00:37:42,170 --> 00:37:44,530
U mbagħad, nixtieq inżid isfond
kulur, aħmar.

789
00:37:44,530 --> 00:37:47,500
U mbagħad, hemm kieku
jkun Brace kaboċċi.

790
00:37:47,500 --> 00:37:52,230
Allura dan huwa kif I se tesplora u
esperiment ma ifformattjar fuq il-CS50

791
00:37:52,230 --> 00:37:53,070
Sit finanzi.

792
00:37:53,070 --> 00:37:55,060
>> I tista 'tagħmel dan hawn u test
it out fuq il-browser tiegħi.

793
00:37:55,060 --> 00:37:58,130
U mbagħad, I tista 'tmur fil-kodiċi attwali tiegħi
u jagħmlu l-bidliet li se

794
00:37:58,130 --> 00:38:01,940
fil-fatt imorru jgħixu u li n-nies
attwalment ara, kieku kellhom jaslu għal

795
00:38:01,940 --> 00:38:04,280
sit speċifiku tiegħi.

796
00:38:04,280 --> 00:38:05,390
>> OK.

797
00:38:05,390 --> 00:38:06,850
Dan kien ħafna.

798
00:38:06,850 --> 00:38:09,380
I ruhna ghall għaddejjin
hekk malajr.

799
00:38:09,380 --> 00:38:12,560
Ħadd ma jkollu xi mistoqsijiet
fil-livelli kollha dwar HTML jew CSS?

800
00:38:12,560 --> 00:38:15,830

801
00:38:15,830 --> 00:38:24,728
>> UDJENZA: Tista 'biss tmur fuq kif inti
marbuta dak li sar Jason, għal darb'oħra?

802
00:38:24,728 --> 00:38:26,180
>> JASON Hirschhorn: What
do inti tfisser marbut?

803
00:38:26,180 --> 00:38:29,765
>> UDJENZA: You ipprovdut link għal oħra
website, bl-użu ankra.

804
00:38:29,765 --> 00:38:32,980
>> JASON Hirschhorn: Allura inti tistaqsi,
biss ġenerikament, kif inti tagħmel link?

805
00:38:32,980 --> 00:38:33,560
>> UDJENZA: Yeah.

806
00:38:33,560 --> 00:38:34,150
>> JASON Hirschhorn: OK.

807
00:38:34,150 --> 00:38:35,575
Il-kodiċi għat-teħid ta 'rabta -

808
00:38:35,575 --> 00:38:38,180

809
00:38:38,180 --> 00:38:40,590
>> UDJENZA: Le, bħal fil-HTML.

810
00:38:40,590 --> 00:38:43,140
>> JASON Hirschhorn: Down hawn, inti jfisser?

811
00:38:43,140 --> 00:38:46,960
Mela jekk jien tixtieq li jinkludi rabta
x'imkien, ngħidu aħna, dan huwa l-HTML fuq tiegħi

812
00:38:46,960 --> 00:38:50,210
paġna dritt hawn.

813
00:38:50,210 --> 00:38:51,010
Dan huwa l-HTML.

814
00:38:51,010 --> 00:38:53,720
Forsi huwa miftuħ fil-fajl, index.html.

815
00:38:53,720 --> 00:38:56,100
I go pulzieri

816
00:38:56,100 --> 00:38:58,990
>> Ejja jkollhom din awtur John
Link Harvard għal xi ħaġa.

817
00:38:58,990 --> 00:39:02,230
Allura aħna ser jeditjaw dan kollu bħala HTML.

818
00:39:02,230 --> 00:39:08,480
Kulma għandek tagħmel huwa jinkludu l-a, hekk
jibbrakitjaw bracket mill-qrib lejn l-

819
00:39:08,480 --> 00:39:12,700
bidu, u mbagħad bracket slash
bracket qrib fl-aħħar.

820
00:39:12,700 --> 00:39:13,930
>> Allura issa stajt inkludiet tag ankra.

821
00:39:13,930 --> 00:39:15,475
U fil-fatt, jekk tikklikkja
minn dan, issa se

822
00:39:15,475 --> 00:39:22,110
format jeditjaw bħala HTML.

823
00:39:22,110 --> 00:39:24,020
U jgħidu, irridu li tintrabat.

824
00:39:24,020 --> 00:39:25,760
Aħna'd inti l-attribut href.

825
00:39:25,760 --> 00:39:27,010
U aħna ngħidu -

826
00:39:27,010 --> 00:39:42,600

827
00:39:42,600 --> 00:39:47,600
>> U issa, kif tinnota, l-awtur
John Harvard huwa blu.

828
00:39:47,600 --> 00:39:50,870
U meta I iscroll fuq
dan, huwa issa ż rabta.

829
00:39:50,870 --> 00:39:53,140
Allura inti tista 'tikteb il-kodiċi.

830
00:39:53,140 --> 00:39:57,030
Tista jdawru xi ħaġa pjuttost ħafna
inti tixtieq fi tag ankra u jibdluh

831
00:39:57,030 --> 00:39:57,700
fi link.

832
00:39:57,700 --> 00:39:58,246
>> UDJENZA: OK.

833
00:39:58,246 --> 00:39:58,520
Ltqajna.

834
00:39:58,520 --> 00:40:01,300
>> JASON Hirschhorn: U jekk I ma riedx
huwa - naturalment, xi kultant in-nies għandhom tendenza

835
00:40:01,300 --> 00:40:04,090
biex jaħsbu dawn l-affarijiet li tfittex biss
blue ġeneriku u enfasizza huma

836
00:40:04,090 --> 00:40:05,860
mhux l-prettiest mod biex tagħmel link.

837
00:40:05,860 --> 00:40:11,380
Mela jekk nasal hawn fuq, tara li,
x'imkien fil-fajl CSS, hemm

838
00:40:11,380 --> 00:40:14,500
bil-miktub dan u mbagħad
żewġ ċineg kaboċċi.

839
00:40:14,500 --> 00:40:20,700
Mela ejja ngħidu li, għal rabtiet, I ma
tixtieq li ssir blu, pjuttost I

840
00:40:20,700 --> 00:40:23,645
jridu li l-kulur ta 'rabta li
jkun dan maġenta sbieħ.

841
00:40:23,645 --> 00:40:28,320

842
00:40:28,320 --> 00:40:30,640
>> Ejja jagħtuh il-kulur.

843
00:40:30,640 --> 00:40:34,060

844
00:40:34,060 --> 00:40:35,110
Ejja pick maġenta.

845
00:40:35,110 --> 00:40:38,440
Issa, l-links fuq il-paġna tiegħi jkollhom
sar dan il-kulur sbieħ ta maġenta.

846
00:40:38,440 --> 00:40:40,170
Xi nies ma simili kuluri fil-livelli kollha.

847
00:40:40,170 --> 00:40:41,340
Xi nies ma simili jenfasizza.

848
00:40:41,340 --> 00:40:42,510
Ikollok li pick.

849
00:40:42,510 --> 00:40:44,990
>> Bil links, inti tista 'stil kif dawn
tħares ladarba inti ħadthom żar minnhom.

850
00:40:44,990 --> 00:40:47,820
Kif tkun taf Avviż fuq lott ta 'paġni,
links dawran vjola fuq inti żjara tagħhom.

851
00:40:47,820 --> 00:40:49,190
Tista 'bidla li l-kulur ukoll.

852
00:40:49,190 --> 00:40:49,450
Yeah.

853
00:40:49,450 --> 00:40:51,790
>> UDJENZA: Allura inti bidla
għal kull link waħda.

854
00:40:51,790 --> 00:40:56,310
Imma jekk inti biss riedu jagħmlu din ir-rabta
innifsu, kieku inti biss tagħmel fil-ID

855
00:40:56,310 --> 00:40:58,720
qiegħ jew xi ħaġa?

856
00:40:58,720 --> 00:41:01,070
>> JASON Hirschhorn: mistoqsija So kbira.

857
00:41:01,070 --> 00:41:05,090
Kif inti ndunat hawn, I mibdula xi
parti mill-CSS li tapplika

858
00:41:05,090 --> 00:41:11,530
kollox thats A. Jekk jien ridt li
biss tagħmel din ir-rabta fil-qiegħ, I

859
00:41:11,530 --> 00:41:14,500
imur għall-fajl CSS tiegħi u probabbilment
do biss bħalek qal, hash

860
00:41:14,500 --> 00:41:16,040
qiegħ ispazju a.

861
00:41:16,040 --> 00:41:18,400
U li jagħti me
kollha Bħal fil-qiegħ.

862
00:41:18,400 --> 00:41:30,720
>> Jew I tista ', alternattivament, tagħtiha a
ID unika u mbagħad biss tagħmel link hash.

863
00:41:30,720 --> 00:41:32,050
U li tippermetti me
li jbiddlu dan out.

864
00:41:32,050 --> 00:41:36,170
Madankollu, ftit doling IDs Willy-nilly
huwa ġeneralment ħażin

865
00:41:36,170 --> 00:41:37,730
prattika, għaliex dawk
għandu jkun uniku.

866
00:41:37,730 --> 00:41:40,940
U l-aktar ikollok dawn, dan
jistgħu jiksbu ftit konfuża.

867
00:41:40,940 --> 00:41:41,270
Yeah.

868
00:41:41,270 --> 00:41:43,725
>> UDJENZA: Tista 'tagħti l-istess
ID lis-sidien multipli?

869
00:41:43,725 --> 00:41:45,820
>> JASON Hirschhorn: Teknikament, iva.

870
00:41:45,820 --> 00:41:50,700
Xejn għaddej biex tieqaf int, imma int
m'għandhomx Għandek tagħtiha klassi.

871
00:41:50,700 --> 00:41:55,330

872
00:41:55,330 --> 00:41:57,655
OK, kwalunkwe mistoqsijiet oħra
dwar HTML jew CSS?

873
00:41:57,655 --> 00:42:05,660

874
00:42:05,660 --> 00:42:06,310
>> OK.

875
00:42:06,310 --> 00:42:09,950
Let us jimxu fuq PHP.

876
00:42:09,950 --> 00:42:10,575
Oh, iva.

877
00:42:10,575 --> 00:42:13,800
>> UDJENZA: X'inhu dwar dawn
websajts li jfisser li nistgħu jeditjaw

878
00:42:13,800 --> 00:42:15,440
lilhom qabel we jġedded.

879
00:42:15,440 --> 00:42:18,270
Imma ladarba aħna jġedded jaqleb lura
Lura għall-HTML inizjali?

880
00:42:18,270 --> 00:42:19,900
>> JASON Hirschhorn: kwistjoni Gran -

881
00:42:19,900 --> 00:42:24,810
hekk meta konna mgħobbija din
paġna web, huwa HTML.

882
00:42:24,810 --> 00:42:25,900
U huwa JavaScript.

883
00:42:25,900 --> 00:42:29,060
PHP tagħha hija esegwita li tagħtina kwalunkwe
tip ta 'website naraw.

884
00:42:29,060 --> 00:42:33,130
U huwa ħolqot xi HTML, xi
JavaScript, u ​​xi CSS.

885
00:42:33,130 --> 00:42:35,990
U li issa huwa aċċessibbli
mill-kompjuter tagħna.

886
00:42:35,990 --> 00:42:40,700
>> U kopja ta 'dawn il-fajls jiġi ffrankat
lokalment fuq il-kompjuter tagħna,

887
00:42:40,700 --> 00:42:41,910
għalissa.

888
00:42:41,910 --> 00:42:44,030
Allura nistgħu jeditjaw dik il-kopja lokali.

889
00:42:44,030 --> 00:42:46,530
Iżda naturalment, aħna mhux qed editjar
il-kopja server.

890
00:42:46,530 --> 00:42:49,420
>> U meta aħna jġedded il-paġna,
irridu jiksbu ieħor kopja server.

891
00:42:49,420 --> 00:42:51,250
U hekk naraw affarijiet
lura kif kienu.

892
00:42:51,250 --> 00:42:55,200
Jekk konna kapaċi, minn hawn, li jeditjaw il-
websajt uffiċjali, aħna'd jkollhom ħafna

893
00:42:55,200 --> 00:42:55,800
ta 'problemi.

894
00:42:55,800 --> 00:42:58,670
>> UDJENZA: Yeah, hekk aħna tista 'taqra
u jiktbu dik il-kopja.

895
00:42:58,670 --> 00:43:00,140
>> JASON Hirschhorn: Dritt.

896
00:43:00,140 --> 00:43:04,380
Aħna biss tagħmel bidliet lokali hawnhekk,
iżda għal darb'oħra, ferm utli għall-esplorazzjoni,

897
00:43:04,380 --> 00:43:05,690
oftentimes.

898
00:43:05,690 --> 00:43:08,900
Meta jien Kitba proġett finali tiegħi, għall-
eżempju, Irrid nara kif xi whud

899
00:43:08,900 --> 00:43:11,270
website magħmula ħarsa xi ħaġa
il-mod kif għamlet.

900
00:43:11,270 --> 00:43:17,350
I se jmorru fi u jużaw dan pane isfel
hawn, li tħares lejn dak CSS li taw biex

901
00:43:17,350 --> 00:43:20,890
jew liema kulur li qabad jew kif
ltqajna sabiex, meta inti hovered

902
00:43:20,890 --> 00:43:24,180
fuq xi ħaġa, il-lista niżlet
b'mod cascading sbieħ.

903
00:43:24,180 --> 00:43:27,220
Huwa mod tajjeb ħafna biex jispezzjonaw dak oħra
websajts tagħmel u tissellef minnhom.

904
00:43:27,220 --> 00:43:30,590

905
00:43:30,590 --> 00:43:33,690
>> Ejja jimxu fuq PHP.

906
00:43:33,690 --> 00:43:38,560
PHP stands għal, f'sens rikursivi,
Processor PHP Portugues.

907
00:43:38,560 --> 00:43:42,060
U PHP, dak li għaddej biex tagħmel
huwa tesegwixxi kodiċi server sekondarji.

908
00:43:42,060 --> 00:43:44,490
Allura aħna qed qatt ser tara kodiċi PHP.

909
00:43:44,490 --> 00:43:47,210
>> Madankollu, dan ma jilagħbu nicely ma
HTML u ħafna drabi jiġġenera

910
00:43:47,210 --> 00:43:48,210
ħafna HTML code.

911
00:43:48,210 --> 00:43:52,570
Imma kif inti ser ikunu familjari ma Problem
Set 7, kodiċi PHP tiegħek se tesegwixxi,

912
00:43:52,570 --> 00:43:56,200
jiġġeneraw xi HTML, u dak hu li
l-utent se jispiċċaw jaraw.

913
00:43:56,200 --> 00:44:00,510
>> PHP huwa oerhört simili għal C.
Madankollu, hemm koppja ta '

914
00:44:00,510 --> 00:44:04,400
differenzi, u dawk id-differenzi
huma importanti li wieħed jinnota.

915
00:44:04,400 --> 00:44:09,420
Wieħed differenza hija li varjabbli
fil-PHP huma laxk ittajpjat.

916
00:44:09,420 --> 00:44:11,275
Ħadd ma jkollu sens
ta 'dak li tfisser?

917
00:44:11,275 --> 00:44:14,245
>> UDJENZA: Ebda ħtieġa biex jitfa 'it yourself.

918
00:44:14,245 --> 00:44:16,400
Bħall-ebda ħtieġa li tikteb fit-test.

919
00:44:16,400 --> 00:44:19,070
>> JASON Hirschhorn: I ma jużaw il-
mitfugħa kelma, imma iva, l-ebda bżonn li jiddikjaraw

920
00:44:19,070 --> 00:44:20,930
tip għal varjabbli speċifiku.

921
00:44:20,930 --> 00:44:22,300
Kif minflok nistgħu tiddikjara varjabbli?

922
00:44:22,300 --> 00:44:23,860
>> UDJENZA: Uża sinjal dollaru.

923
00:44:23,860 --> 00:44:25,270
>> JASON Hirschhorn: Uża sinjal dollaru.

924
00:44:25,270 --> 00:44:27,540
Allura $ x hija varjabbli.

925
00:44:27,540 --> 00:44:29,580
$ 1 hija varjabbli.

926
00:44:29,580 --> 00:44:31,910
$ String hija varjabbli.

927
00:44:31,910 --> 00:44:36,280
>> Dawk varjabbli, $ x jista
ikun numru sħiħ.

928
00:44:36,280 --> 00:44:38,010
Imbagħad, din tista 'tkun string.

929
00:44:38,010 --> 00:44:39,420
Imbagħad, jista 'jkun karattru.

930
00:44:39,420 --> 00:44:40,790
Hija ma verament kwistjoni.

931
00:44:40,790 --> 00:44:46,360
>> Ukoll, il-ħaġa jibred dwar PHP hija,
jiġifieri, $ x hija l-waħda sekwenza.

932
00:44:46,360 --> 00:44:48,920
U $ y huwa l-karattru wieħed.

933
00:44:48,920 --> 00:44:54,370
Inti tista 'żżid $ x u $ y, u inneħħu
jagħtuk 2, dak youd jistennew.

934
00:44:54,370 --> 00:44:56,160
Allura hemm operazzjonijiet PHP.

935
00:44:56,160 --> 00:45:00,810
Għaliex dan huwa laxk varjabbli ittajpjat,
xi casting impliċita isir għalik

936
00:45:00,810 --> 00:45:02,330
u xi operazzjonijiet.

937
00:45:02,330 --> 00:45:04,240
>> Tista 'tagħmel operazzjonijiet fuq affarijiet
tipi ta 'differenti.

938
00:45:04,240 --> 00:45:08,740
Billi qabel, inti spiss tikseb żball
Jgħidu C, dan mhuwiex il-tip

939
00:45:08,740 --> 00:45:09,610
li suppost li jmorru hawn.

940
00:45:09,610 --> 00:45:11,510
Affarijiet biss ta 'dan it-tip tista' tmur hawn.

941
00:45:11,510 --> 00:45:14,900
Int mhux se tikseb dak it-tip
ta 'żball, ġeneralment, fil-PHP.

942
00:45:14,900 --> 00:45:17,420
Allura dak differenza waħda kbira -
kif nittrattaw varjabbli.

943
00:45:17,420 --> 00:45:20,850
>> Id-differenza kbira tieni hija li
Kodiċi PHP huwa interpretat.

944
00:45:20,850 --> 00:45:23,110
Billi d-kodiċi C hija miġbura.

945
00:45:23,110 --> 00:45:23,910
X'hemm li jfisser?

946
00:45:23,910 --> 00:45:26,700
>> Well, għall-kodiċi C għalik dam
permezz kompilatur.

947
00:45:26,700 --> 00:45:29,010
You ġġenerat fajl binarju.

948
00:45:29,010 --> 00:45:30,770
U inti dam dan il-fajl binarju.

949
00:45:30,770 --> 00:45:35,500
Inti ħadt kura ta 'l-iżbalji kollha qabel
inti ġġenerat l-fajl binarju.

950
00:45:35,500 --> 00:45:37,810
>> Of course, seta 'kien hemm
Segmentazzjoni difetti, meta inti mexxa l-

951
00:45:37,810 --> 00:45:39,020
fajl binarju.

952
00:45:39,020 --> 00:45:45,780
Iżda mhuwiex simili inti nesa li jinkludu
id-definizzjoni ta 'printf, jew

953
00:45:45,780 --> 00:45:48,735
inti ma tuża varjabbli u biss
ħolqot varjabbli ħela.

954
00:45:48,735 --> 00:45:51,830
Jew inti ma tiddefinixxi
prototip funzjoni.

955
00:45:51,830 --> 00:45:53,590
>> Dak kollu li ġara qabel ma ikkumpilata.

956
00:45:53,590 --> 00:45:56,830
Dan ħadt kollha ta 'l-iżbalji jew ħażina
affarijiet li ħsibt jista 'jiġri.

957
00:45:56,830 --> 00:45:59,900
U mbagħad, kellek 0 tiegħek u
1 fajl li inti dam.

958
00:45:59,900 --> 00:46:01,690
Kodiċi PHP ma jaħdimx bħal dik.

959
00:46:01,690 --> 00:46:03,750
>> Int ser jikteb il-kodiċi PHP tiegħek.

960
00:46:03,750 --> 00:46:05,820
Imbagħad, int ser
ħlief, preżumibbilment.

961
00:46:05,820 --> 00:46:09,160
U għallinqas fis P-Set 7, int ser
li jġedded web browser tiegħek, u

962
00:46:09,160 --> 00:46:11,110
int ser tara dak li ġara.

963
00:46:11,110 --> 00:46:14,110
Int ser tara l-output
tal-istess kodiċi PHP.

964
00:46:14,110 --> 00:46:17,450
>> Inti tista 'ara wkoll, fil-quċċata
tal-paġna tiegħek, żball.

965
00:46:17,450 --> 00:46:19,960
Għaliex inti kellhom xi
żball PHP tiegħek.

966
00:46:19,960 --> 00:46:22,390
Inti xorta tista 'tara l-bqija ta'
il-paġna web qed tfittex multa.

967
00:46:22,390 --> 00:46:25,130
Iżda parti waħda hija żbaljata, u hemm
żball f'dak il-post.

968
00:46:25,130 --> 00:46:28,320
U dan għaliex dik il-parti ta '
kodiċi PHP tiegħek ma taħdimx.

969
00:46:28,320 --> 00:46:31,680
>> Tabilħaqq, meta inti teżegwixxi, meta inti
jmorru għal xi ħaġa bħal by.php.

970
00:46:31,680 --> 00:46:34,950
Huwa ser jgħaddu PHP tiegħek
fajl linja b'linja u esegwit

971
00:46:34,950 --> 00:46:36,210
Imbagħad biss u mbagħad.

972
00:46:36,210 --> 00:46:39,890
Hija mhux ser josservawha quddiem ta '
time jew jikkompila kopja waħda u mbagħad tagħti

973
00:46:39,890 --> 00:46:41,570
li ikkumpilata kopja lil kulħadd.

974
00:46:41,570 --> 00:46:43,830
Kull darba, li għaddej biex jgħaddu
linja b'linja u esegwit.

975
00:46:43,830 --> 00:46:46,620
>> Allura xi linji jistgħu jaħdmu u
output xi ħaġa korretta.

976
00:46:46,620 --> 00:46:49,500
U linji oħra jistgħu jkunu maqsuma
u output żball minflok.

977
00:46:49,500 --> 00:46:52,650
Allura meta debugging ma PHP, konna mogħtija
inti ftit affarijiet utli

978
00:46:52,650 --> 00:46:54,580
biex jgħinuk debug, bħal
il-funzjoni dump.

979
00:46:54,580 --> 00:46:56,900
>> Iżda ġeneralment, int ser
biex tara dawn l-iżbalji.

980
00:46:56,900 --> 00:46:58,340
U li kif int ser
taf li inti għamilt xi ħaġa ħażina.

981
00:46:58,340 --> 00:47:00,740
Imma int biss ser tara l-iżball
ladarba inti tmexxi effettivament l-kodiċi.

982
00:47:00,740 --> 00:47:03,420

983
00:47:03,420 --> 00:47:08,880
>> Aspett ieħor importanti ta 'PHP u
web iżvilupp huwa l-idea ta get

984
00:47:08,880 --> 00:47:09,920
versus post.

985
00:47:09,920 --> 00:47:13,250
Jista 'xi ħadd jispjega x'inhi d-differenza
bejn jiksbu u post huma?

986
00:47:13,250 --> 00:47:17,530

987
00:47:17,530 --> 00:47:18,780
Nobody -

988
00:47:18,780 --> 00:47:21,710

989
00:47:21,710 --> 00:47:21,970
iva.

990
00:47:21,970 --> 00:47:24,495
>> UDJENZA: Ma wieħed minnhom
ħalli l-utent jara l-informazzjoni,

991
00:47:24,495 --> 00:47:26,080
u wieħed minnhom ma?

992
00:47:26,080 --> 00:47:27,310
>> JASON Hirschhorn: Great.

993
00:47:27,310 --> 00:47:28,400
Yeah, do ikollok xi ħaġa li żżid?

994
00:47:28,400 --> 00:47:32,622
>> UDJENZA: I post rqiqa hija
varjabbli super-globali.

995
00:47:32,622 --> 00:47:34,740
>> JASON Hirschhorn: Allura kemm ta 'dawn
varjabbli huma mogħtija lilek.

996
00:47:34,740 --> 00:47:35,630
Dawn huma biss varjabbli.

997
00:47:35,630 --> 00:47:37,740
U inti taf li qed varjabbli,
minħabba dritt hawn I

998
00:47:37,740 --> 00:47:38,780
jużaw is-sinjal dollaru.

999
00:47:38,780 --> 00:47:41,950
>> Dawn huma varjabbli mogħtija
lilek mill PHP.

1000
00:47:41,950 --> 00:47:45,990
U meta inti timxi bejn paġni tal-web,
inti tixtieq li tiffranka xi informazzjoni.

1001
00:47:45,990 --> 00:47:47,960
Inti probabilment tixtieq li jiffrankaw jekk
l-utent huwa logged pulzieri

1002
00:47:47,960 --> 00:47:49,270
Li mhux ffrankata fil IKOLLOK u POST.

1003
00:47:49,270 --> 00:47:51,390
Li ffrankata fil xi ħaġa oħra,
varjabbli differenti.

1004
00:47:51,390 --> 00:47:55,170
>> Kulmin jafu liema varjabbli li salvati
fi, jew dak varjabbli tuża fil-

1005
00:47:55,170 --> 00:47:57,728
P-Set 7, biex tiżgura li
l-utent ikun illoggjat?

1006
00:47:57,728 --> 00:48:00,360

1007
00:48:00,360 --> 00:48:03,690
$ _session, Dan huwa eżattament id-dritt,
probabbilment importanti biex ikunu familjari ma

1008
00:48:03,690 --> 00:48:06,060
l-ismijiet ta 'dawn l-affarijiet
tuża spiss.

1009
00:48:06,060 --> 00:48:10,070
>> Allura inti tuża l-varjabbli sessjoni li jiffrankaw
informazzjoni minn paġna għal paġna.

1010
00:48:10,070 --> 00:48:11,075
Li l-varjabbli super.

1011
00:48:11,075 --> 00:48:15,250
Hija teżisti fuq kull paġna, forsi bħal
varjabbli globali, jekk inti tixtieq li jaħsbu

1012
00:48:15,250 --> 00:48:16,900
dwar dan bħal dik.

1013
00:48:16,900 --> 00:48:19,260
>> Hemm ftit ta 'varjabbli oħrajn
li jippermettu li inti tittrasferixxi informazzjoni

1014
00:48:19,260 --> 00:48:20,710
minn paġna għal paġna.

1015
00:48:20,710 --> 00:48:24,260
B'mod partikolari, dawk li aħna ser tiffoka fuq
huma l-IKOLLOK u l-varjabbli POST.

1016
00:48:24,260 --> 00:48:29,330
Fil PHP huma look like
$ _GET U $ _POST.

1017
00:48:29,330 --> 00:48:33,610
U d-differenza, kif Marcus osservat
out, bejn it-tnejn minnhom hija li,

1018
00:48:33,610 --> 00:48:37,670
informazzjoni fil $ _GET hija
murija fil-URL.

1019
00:48:37,670 --> 00:48:41,380
>> Mela jekk inħarsu stabbiliti hawn,
naraw rabta YouTube.

1020
00:48:41,380 --> 00:48:43,760
Naraw din il-marka kwistjoni.

1021
00:48:43,760 --> 00:48:47,730
Naraw v = u mbagħad xi valur.

1022
00:48:47,730 --> 00:48:53,460
Lura għall-din l-idea ta 'valur ewlieni
pair, il-v hija ċ-ċavetta.

1023
00:48:53,460 --> 00:48:56,970
U hawn huwa l-valur.

1024
00:48:56,970 --> 00:49:01,030
>> Hekk jekk konna biex tmur din il-paġna jew
kodifikazzjoni f'din il-paġna, rridu naraw

1025
00:49:01,030 --> 00:49:04,000
varjabbli imsejħa $ _GET.

1026
00:49:04,000 --> 00:49:11,030
Jekk aħna marru għal $ _GET parentesi miftuħa "v"
parentesi magħluqa, simili ħafna għal firxa

1027
00:49:11,030 --> 00:49:15,000
notazzjoni, dan huwa firxa assoċjat
għaliex aħna ma tkunx qed tużah indiċi.

1028
00:49:15,000 --> 00:49:16,710
Kienu qed jużaw kordi bħala keys.

1029
00:49:16,710 --> 00:49:17,940
Iżda idea simili ħafna.

1030
00:49:17,940 --> 00:49:20,520
Jekk aħna marru aħna, se tikseb dan il-valur.

1031
00:49:20,520 --> 00:49:23,276
>> Fuq din il-paġna, aħna'd ikunu jistgħu
biex jużaw dan il-valur.

1032
00:49:23,276 --> 00:49:32,200
Jekk aħna fil-fatt tfittex, ejja
jmorru għal paġna YouTube.

1033
00:49:32,200 --> 00:49:35,140
What video għandna watch?

1034
00:49:35,140 --> 00:49:37,350
Dan wieħed, huma nies Hobbit fannijiet?

1035
00:49:37,350 --> 00:49:40,731
>> UDJENZA: Iva.

1036
00:49:40,731 --> 00:49:44,750
>> JASON Hirschhorn: So jien ikkupjar
URL sehem tagħhom u

1037
00:49:44,750 --> 00:49:46,000
pasta fil-tieqa ġdida.

1038
00:49:46,000 --> 00:49:48,550

1039
00:49:48,550 --> 00:50:00,470
U issa, jekk inti tfittex up hawn, inti ser
avviż li, għal darb'oħra -

1040
00:50:00,470 --> 00:50:03,170
Jien ser kopja u paste dan in
gedit, hekk aħna tista 'tara akbar.

1041
00:50:03,170 --> 00:50:16,530

1042
00:50:16,530 --> 00:50:19,720
Int ser ikollok avviż li hija għandha
din il-marka kwistjoni.

1043
00:50:19,720 --> 00:50:22,150
Il-kwistjoni mark tindika li
kollox wara dan se jkun

1044
00:50:22,150 --> 00:50:23,530
ffrankata fil-varjabbli get.

1045
00:50:23,530 --> 00:50:29,130
>> Imbagħad ikollha l-v, dak l-ewwel
ewlenin u dan l-ewwel valur.

1046
00:50:29,130 --> 00:50:30,710
Ampersand huwa speċjali.

1047
00:50:30,710 --> 00:50:34,340
Ampersand huwa qal, OK, aħna
lest l-ewwel valur.

1048
00:50:34,340 --> 00:50:37,170
Aħna issa jimxu fuq ieħor
par Il-valur ewlieni.

1049
00:50:37,170 --> 00:50:41,135
Hawnhekk, il-muftieħ huwa msejjaħ karatteristika,
u il-valur huwa youtu.be.

1050
00:50:41,135 --> 00:50:44,010

1051
00:50:44,010 --> 00:50:50,710
>> Hekk jekk I kien kodifikazzjoni din il-paġna u
xi ħadd marru għal dan URL u kelli

1052
00:50:50,710 --> 00:50:53,190
forsi watch.php.

1053
00:50:53,190 --> 00:50:54,150
U I kien kodifikazzjoni dan.

1054
00:50:54,150 --> 00:50:57,060
And I jistgħu jużaw l-varjabbli $ _GET.

1055
00:50:57,060 --> 00:51:02,740
U jien jkollha v, u
I jkollhom karatteristika.

1056
00:51:02,740 --> 00:51:07,080
>> U jekk I jużaw il-v ewlenin, I
se tikseb dan il-valur.

1057
00:51:07,080 --> 00:51:14,145
U jekk jien ma $ _GET parentesi "karatteristika"
parentesi magħluqa, nixtieq nikseb dan il-valur.

1058
00:51:14,145 --> 00:51:17,530
Għal darb'oħra, dan ma jfissirx neċessarjament
japplikaw għal -

1059
00:51:17,530 --> 00:51:21,460
Ovvjament, il-keys YouTube u l-valuri
u jiksbu l-informazzjoni ma japplikax għal

1060
00:51:21,460 --> 00:51:22,700
Problema tagħna Set 7.

1061
00:51:22,700 --> 00:51:28,450
Iżda hemm ċerti affarijiet li aħna
jgħaddu permezz IKOLLOK fil Problem tagħna Set 7.

1062
00:51:28,450 --> 00:51:33,120
U ċertament, meta inti tmur għal paġna web
jew huma kodifikazzjoni page tiegħek stess, l-

1063
00:51:33,120 --> 00:51:36,440
$ _GET Se jidħlu fil handy
waqt il-kodifika tiegħek.

1064
00:51:36,440 --> 00:51:41,030
>> X'inhu raġuni waħda għall-użu $ _GET imbagħad,
jekk joffri ebda privatezza?

1065
00:51:41,030 --> 00:51:43,170
You see din l-informazzjoni
thats tiġi trasferita.

1066
00:51:43,170 --> 00:51:44,170
Dan kollu murija lill-utent.

1067
00:51:44,170 --> 00:51:49,060
Imma x'hemm raġuni waħda li inti tista '
tixtieq li jiffrankaw xi ħaġa fil $ _GET, kif

1068
00:51:49,060 --> 00:51:50,310
kuntrarju $ _POST?

1069
00:51:50,310 --> 00:51:52,650

1070
00:51:52,650 --> 00:51:53,900
Għaliex jista inti tixtieq li tagħmel dan?

1071
00:51:53,900 --> 00:51:58,065

1072
00:51:58,065 --> 00:51:58,540
>> Kull dritt.

1073
00:51:58,540 --> 00:52:00,310
I talab li inti fil Quiz 1.

1074
00:52:00,310 --> 00:52:02,210
X'inhu l-pro ta '$ _GET?

1075
00:52:02,210 --> 00:52:04,250
X'hemm pro wieħed?

1076
00:52:04,250 --> 00:52:04,700
Yeah -

1077
00:52:04,700 --> 00:52:06,180
>> UDJENZA: Huwa aktar faċli li
jaqsmu l-informazzjoni.

1078
00:52:06,180 --> 00:52:07,040
>> JASON Hirschhorn: Naħseb
li l-kbir.

1079
00:52:07,040 --> 00:52:07,870
Huwa aktar faċli li jaqsmu l-informazzjoni.

1080
00:52:07,870 --> 00:52:09,360
Huwa aktar faċli li bookmark.

1081
00:52:09,360 --> 00:52:15,260
>> Tista bookmark issa,
YouTube.com / watch? V = ħaġa u jmorru

1082
00:52:15,260 --> 00:52:16,900
għal dak video speċifiku.

1083
00:52:16,900 --> 00:52:22,020
Jekk YouTube dejjem għamlet talbiet POST biex
paġni differenti, kull URL YouTube

1084
00:52:22,020 --> 00:52:22,985
ikun YouTube.com.

1085
00:52:22,985 --> 00:52:25,750
Inti ma tistax bookmark video waħda.

1086
00:52:25,750 --> 00:52:28,160
Għaliex jekk inti tgħidli maqsuma din ir-rabta
ma 'xi ħadd ieħor, dawn ma

1087
00:52:28,160 --> 00:52:30,160
awtomatikament jiksbu varjabbli post tiegħek.

1088
00:52:30,160 --> 00:52:33,570
Huma qed biss jkollna din ir-rabta, u l-
rabta hija l-istess għal kulħadd.

1089
00:52:33,570 --> 00:52:35,180
>> Allura dan huwa pro wieħed.

1090
00:52:35,180 --> 00:52:38,850
Huwa jippermettilek li bookmark din
informazzjoni jew jaqsmu din l-informazzjoni

1091
00:52:38,850 --> 00:52:40,840
jew jagħmilha ftit
aktar faċli għall-utent.

1092
00:52:40,840 --> 00:52:43,890
Of course, m'hemm l-ebda privatezza,
hekk aħna jkollhom din varjabbli post.

1093
00:52:43,890 --> 00:52:47,570
U l-informazzjoni post mhix
murija fil-URL.

1094
00:52:47,570 --> 00:52:49,200
>> Mhuwiex kompletament privata.

1095
00:52:49,200 --> 00:52:51,710
Iżda huwa marġinalment aktar privat.

1096
00:52:51,710 --> 00:52:55,030
U hekk tkun taf tara dan il-URL
stabbiliti hawn, cs50.net.

1097
00:52:55,030 --> 00:52:59,200
Jekk jew le inti qed logged fil-
website, li għaddej biex ikollhom l-istess

1098
00:52:59,200 --> 00:53:02,600
URL, cs50.net.

1099
00:53:02,600 --> 00:53:05,940
>> Ovvjament, xi ħaġa huwa differenti, jekk
int logged in-websajt.

1100
00:53:05,940 --> 00:53:08,690
Għandek, waħda, probabbilment
input PIN tiegħek.

1101
00:53:08,690 --> 00:53:10,600
U kkonfermat li
mal-server.

1102
00:53:10,600 --> 00:53:12,650
U huwa probabbilment iffrankar
xi informazzjoni oħra.

1103
00:53:12,650 --> 00:53:14,810
Iżda l-URL ma bidlet xejn.

1104
00:53:14,810 --> 00:53:17,080
>> U hekk dan huwa l-każ, meta
xi ħaġa hija mibgħuta bil-posta.

1105
00:53:17,080 --> 00:53:18,800
Il-URL ma tinbidilx.

1106
00:53:18,800 --> 00:53:21,100
Din l-informazzjoni POST mhix
murija fil-URL.

1107
00:53:21,100 --> 00:53:26,150
Iżda xi stat inbidlet, u forsi
hemm xi informazzjoni ffrankata fil-

1108
00:53:26,150 --> 00:53:27,400
POST varjabbli.

1109
00:53:27,400 --> 00:53:30,460

1110
00:53:30,460 --> 00:53:36,880
>> Jiddispjacini. qabel ma mmur fis SQL, kwalunkwe
mistoqsijiet dwar PHP, b'mod partikolari,

1111
00:53:36,880 --> 00:53:41,850
mistoqsijiet dwar affarijiet aħna ma jmorru fuq
li inti ħadthom misjuba jew xi sintassi jew

1112
00:53:41,850 --> 00:53:43,855
mistoqsijiet loġika dwar PHP?

1113
00:53:43,855 --> 00:53:49,300

1114
00:53:49,300 --> 00:53:50,050
OK.

1115
00:53:50,050 --> 00:53:54,400
>> Il-lingwa finali inti tkun
interazzjoni ma 'din il-ġimgħa hija l-

1116
00:53:54,400 --> 00:53:58,920
Strutturat Mistoqsija Lingwa, SQL,
segwiment ppronunzjata spiss.

1117
00:53:58,920 --> 00:54:01,740
Li jippermettilek li jinteraġixxu ma 'l-
database b'mod formalizzat.

1118
00:54:01,740 --> 00:54:04,390
Filwaqt li jilgħab ħafna nicely mal-PHP.

1119
00:54:04,390 --> 00:54:09,950
>> Kif tkun taf tara fil Problem Set 7, konna
tak funzjoni msejħa query.

1120
00:54:09,950 --> 00:54:14,990
U li tieħu string SQL u tesegwixxi
li query fuq id-database.

1121
00:54:14,990 --> 00:54:17,470
Fl-aħħar snin, inti ma kinux
minħabba din il-funzjoni.

1122
00:54:17,470 --> 00:54:22,250
You kellhom jużaw funzjonijiet PHP biex tagħmel
il-mistoqsija fid-database u l-kontroll

1123
00:54:22,250 --> 00:54:24,230
għal żbalji u mbagħad tikseb ir-riżultati.

1124
00:54:24,230 --> 00:54:26,120
>> U fil-fatt, mhuwiex li iebes,
għaliex għal darb'oħra, din tilgħab

1125
00:54:26,120 --> 00:54:27,080
nicely ħafna ma PHP.

1126
00:54:27,080 --> 00:54:31,240
U PHP jagħtik ħafna ta 'funzjonijiet
li jinteraġixxu ma 'database SQL.

1127
00:54:31,240 --> 00:54:34,810
Allura ta 'spiss, l-tnejn
dawn imorru flimkien.

1128
00:54:34,810 --> 00:54:37,090
Of course, inti tista 'jinteraġixxu ma'
l-database SQL ma 'kwalunkwe

1129
00:54:37,090 --> 00:54:38,400
numru ta 'lingwi oħra.

1130
00:54:38,400 --> 00:54:41,420
Iżda PHP hija waħda kbira li jagħżlu.

1131
00:54:41,420 --> 00:54:42,290
>> A database -

1132
00:54:42,290 --> 00:54:46,030
aħna ser jmorru fuq dan malajr, għaliex
din hija kelma buzz aħna qed tmur biex

1133
00:54:46,030 --> 00:54:48,030
tibda tuża spiss -

1134
00:54:48,030 --> 00:54:50,140
hija ġabra ta 'tabelli.

1135
00:54:50,140 --> 00:54:53,960
Allura nistgħu jaħsbu li
bħala fajl Excel.

1136
00:54:53,960 --> 00:54:57,260
Fajl Excel għandha tabs multipli
fuq il-qiegħ tal-iskrin.

1137
00:54:57,260 --> 00:55:03,090
Kull tab aħna issa ser sejħa tabella, fejn
tabella hija ġabra ta 'ringieli.

1138
00:55:03,090 --> 00:55:04,060
>> U dak li huwa filliera?

1139
00:55:04,060 --> 00:55:06,890
Well, ringiela hija l-istess ħaġa
fil-fajl Excel.

1140
00:55:06,890 --> 00:55:10,380
Li biss għandu ċerti valuri għal kull
mogħti qasam jew kull kolonna partikolari.

1141
00:55:10,380 --> 00:55:12,010
Huwa simili entrata fit-tabella.

1142
00:55:12,010 --> 00:55:16,570
Huwa student, li għandu identità, a
ID speċifiku, u l-isem u speċifiku

1143
00:55:16,570 --> 00:55:17,910
house speċifiku.

1144
00:55:17,910 --> 00:55:19,790
>> Allura database hija ġabra
ta 'tabelli.

1145
00:55:19,790 --> 00:55:22,685
U tabelli infushom huma
numru ta 'fillieri jew rekords.

1146
00:55:22,685 --> 00:55:25,470

1147
00:55:25,470 --> 00:55:28,280
Hemm ukoll, f'kull
mejda, f'ċerti oqsma.

1148
00:55:28,280 --> 00:55:32,130
U li jispeċifika dak li kull rekord
ser ikollhom, oqsma ġieli msejjaħ

1149
00:55:32,130 --> 00:55:33,890
kolonni imma ġeneralment imsejħa oqsma.

1150
00:55:33,890 --> 00:55:38,270
>> F'din it-tabella sempliċi ħafna, għandi tliet
oqsma, qasam ID, username

1151
00:55:38,270 --> 00:55:39,780
qasam, u qasam hash.

1152
00:55:39,780 --> 00:55:41,300
U għandi tliet ringieli.

1153
00:55:41,300 --> 00:55:42,100
Dritt issa, dawn qed vojta.

1154
00:55:42,100 --> 00:55:44,850
Huma probabbilment ma tkunx vojta
jekk dan kien database tiegħi reali.

1155
00:55:44,850 --> 00:55:50,530
>> Mela jekk inti ħadthom użati Excel, idea simili
għal dak li inti tagħmel fl-Excel, għalkemm,

1156
00:55:50,530 --> 00:55:54,300
ovvjament, issa aħna qed tmur biex tkun tista '
tagħmel affarijiet ferm aktar b'saħħitha fuq il-

1157
00:55:54,300 --> 00:55:56,430
informazzjoni li hija maħżuna
fid-database tagħna.

1158
00:55:56,430 --> 00:56:00,270
Inti ser tkun ħolqien yourself wieħed
database għall Problem Set 7.

1159
00:56:00,270 --> 00:56:02,820
Imma inti ser tkun ħolqien multipli
tabelli fid-database.

1160
00:56:02,820 --> 00:56:06,950
>> Int ser tkun ħolqien ta 'database
jew tabella għall-utenti.

1161
00:56:06,950 --> 00:56:12,830
Int ser tkun ukoll ħolqien ta 'tabella għal
probabbilment transazzjonijiet istokk, li jżomm

1162
00:56:12,830 --> 00:56:15,580
track minnhom, għaliex ikollok bżonn li
jimplimentaw karatteristika istorja.

1163
00:56:15,580 --> 00:56:18,370
Kemm dawn it-tabelli se jkollhom
oqsma differenti.

1164
00:56:18,370 --> 00:56:22,190
Per eżempju, fil-qasam utent, int
probabilment tixtieq isem l-utent tagħhom u

1165
00:56:22,190 --> 00:56:24,220
ID u hash tal-password tagħhom.

1166
00:56:24,220 --> 00:56:28,450
>> Fit-tabella Stocks li żżomm kont ta '
istorja jew il-mejda Storja, inti

1167
00:56:28,450 --> 00:56:31,620
probabbilment ma bżonn l-isem l-utent
u l-hash u l-ID.

1168
00:56:31,620 --> 00:56:34,460
Inti probabilment ikollok bżonn wieħed minn dawk biss
valuri li huma uniċi, biex jassoċjaw

1169
00:56:34,460 --> 00:56:35,830
dan ma 'utent partikolari.

1170
00:56:35,830 --> 00:56:38,100
>> Iżda mbagħad, inti tixtieq li taħżen l-oħra
affarijiet simili, liema żmien

1171
00:56:38,100 --> 00:56:40,630
kienet transazzjoni magħmula.

1172
00:56:40,630 --> 00:56:42,380
What istokk kien mixtrija jew mibjugħa?

1173
00:56:42,380 --> 00:56:44,150
Kemm ishma tal-ħażniet
kienet mixtrija jew mibjugħa?

1174
00:56:44,150 --> 00:56:48,360
Dak kien il-prezz li bih il-
istokk kien mixtrija jew mibjugħa?

1175
00:56:48,360 --> 00:56:50,180
>> Għalhekk għal darb'oħra, int se tkun interazzjoni
ma 'databases C'est

1176
00:56:50,180 --> 00:56:51,350
ser ikollhom tabelli multipli.

1177
00:56:51,350 --> 00:56:54,340
Kull tabella huwa se jkollu
tagħha sett ta 'oqsma.

1178
00:56:54,340 --> 00:56:58,430
Madankollu, x'aktarx se jkun hemm simili
qasam ta 'kull tabella, li

1179
00:56:58,430 --> 00:57:00,130
tirrigwarda minnhom ma 'xulxin.

1180
00:57:00,130 --> 00:57:02,660
Normalment, dan huwa qasam ID.

1181
00:57:02,660 --> 00:57:07,000
>> Għaliex jekk kull utent ikollu ID unika
u inti tassoċja li ID ma 'kull

1182
00:57:07,000 --> 00:57:09,365
transazzjoni li utent jagħmel jew
kollha tal-istorja li utent.

1183
00:57:09,365 --> 00:57:12,760

1184
00:57:12,760 --> 00:57:13,830
U inti għandek ID tal-utent.

1185
00:57:13,830 --> 00:57:15,365
Tista 'tikseb informazzjoni
jew mill-mejda.

1186
00:57:15,365 --> 00:57:19,770
Tista 'tikseb username tagħhom, u int
tista 'tikseb kollha ta' transazzjonijiet tagħhom.

1187
00:57:19,770 --> 00:57:24,410
>> Xi mistoqsijiet dwar databases,
jew mistoqsijiet speċifiċi?

1188
00:57:24,410 --> 00:57:25,240
Attwalment, ejja tiddeċiedi li.

1189
00:57:25,240 --> 00:57:27,410
Aħna ser jkun hemm f'żewġ naħat.

1190
00:57:27,410 --> 00:57:31,210
>> Allura hemm erba 'operazzjonijiet fuq
databases li inti se tkun qed tuża fil-

1191
00:57:31,210 --> 00:57:34,790
Problema Issettja 7 u li x'aktarx
qatt tuża.

1192
00:57:34,790 --> 00:57:38,040
L-ewwel ħaġa li trid tagħmel huwa daħħal
rekord ġdid fis-tabella jew

1193
00:57:38,040 --> 00:57:39,960
ringiela ġdida fis-tabella.

1194
00:57:39,960 --> 00:57:46,070
Din hija l-funzjoni ġeneriku, l-
forma ġenerika, ta 'dik mistoqsija SQL.

1195
00:57:46,070 --> 00:57:52,240
>> DAĦĦAL FIS-tabella, tkun xi tkun kolonni
inti tixtieq li daħħal u mbagħad

1196
00:57:52,240 --> 00:57:58,740
il-valuri li int tmur jridu
jitqiegħed fis dawk kolonni jew oqsma.

1197
00:57:58,740 --> 00:58:03,980
Jekk għandek tabelli multipli
database jew databases multipli, inti

1198
00:58:03,980 --> 00:58:06,630
jistgħu wkoll jeħtieġu li tispeċifika l-database
u t-tabella li tixtieq

1199
00:58:06,630 --> 00:58:07,980
biex l-affarijiet fis.

1200
00:58:07,980 --> 00:58:11,390
Iżda sempliċi ħafna, jekk inti tixtieq li daħħal
fis xi ħaġa, inti tgħidli, hawn huma l-

1201
00:58:11,390 --> 00:58:12,890
oqsma nixtieq li daħħal fis.

1202
00:58:12,890 --> 00:58:14,740
U hawn huma l-valuri.

1203
00:58:14,740 --> 00:58:18,840
>> F'xi tabelli, wkoll, u l-dan l-utent
tabella hija eżempju tajjeb.

1204
00:58:18,840 --> 00:58:21,940
Probabbilment fit-tabella dan l-utent u
probabbilment fit-tabella utent tiegħek fil-P-Set

1205
00:58:21,940 --> 00:58:24,200
7, hemm mhux biss valur username.

1206
00:58:24,200 --> 00:58:27,100
Hemm mhux biss valur fi flus,
jew il-qasam, pjuttost.

1207
00:58:27,100 --> 00:58:29,140
Hemm ukoll kamp ID.

1208
00:58:29,140 --> 00:58:31,110
>> Jien ma jmur biex daħħal il-qasam ID.

1209
00:58:31,110 --> 00:58:34,020
Li għaddej biex tingħata
me awtomatikament, meta

1210
00:58:34,020 --> 00:58:35,810
rekord ġdid huwa mdaħħal.

1211
00:58:35,810 --> 00:58:37,820
Allura hemm xi qasam li inti
tista 'tistabbilixxi li jkun awtomatiku.

1212
00:58:37,820 --> 00:58:41,740
>> Forsi inti tixtieq li tagħti kull utent
$ 10,000 ta 'flus kontanti barra l-BAT.

1213
00:58:41,740 --> 00:58:43,470
So I m'għandhomx bżonn li daħħal
għadd ta 'flus kontanti hawn.

1214
00:58:43,470 --> 00:58:45,860
All I bżonn li daħħal hija l-isem l-utent.

1215
00:58:45,860 --> 00:58:49,230
U mbagħad, il-qasam flus se jkunu
pre-popolati, u l-qasam ID ser

1216
00:58:49,230 --> 00:58:50,590
tkun pre-popolati.

1217
00:58:50,590 --> 00:58:53,640
>> Allura oftentimes, aħna mhux ddaħħal
xi ħaġa fis-kull qasam, għax

1218
00:58:53,640 --> 00:58:55,400
f'dawk l-oqsma l-oħra huma pre-popolati.

1219
00:58:55,400 --> 00:58:58,320
Minħabba li kif aħna
stabbilit f'dik it-tabella.

1220
00:58:58,320 --> 00:59:01,280
>> It-tieni ħaġa int ser
trid tagħmel hu li tħassar rekord.

1221
00:59:01,280 --> 00:59:02,900
Tħassar xi ħaġa hija sempliċi ħafna.

1222
00:59:02,900 --> 00:59:05,660
Inti tagħti l-tabella fejn inti tixtieq
biex tħassar xi ħaġa minn.

1223
00:59:05,660 --> 00:59:11,202
U inti tgħidli, OK, I tixtieq li tħassar l-
rekord li għandha username ta 'Milo.

1224
00:59:11,202 --> 00:59:16,180
Jew I tixtieq li tħassar rekords kollha li
jkollhom username ta 'Milo jew li kienu

1225
00:59:16,180 --> 00:59:18,700
transazzjoni minn numru user ID 2.

1226
00:59:18,700 --> 00:59:21,950

1227
00:59:21,950 --> 00:59:24,809
Kwalunkwe mistoqsijiet dwar dawn
żewġ tipi ta 'mistoqsijiet?

1228
00:59:24,809 --> 00:59:26,059
>> UDJENZA: [inaudible].

1229
00:59:26,059 --> 00:59:28,721

1230
00:59:28,721 --> 00:59:30,770
>> JASON Hirschhorn: Iva.

1231
00:59:30,770 --> 00:59:33,530
Hekk jien ser tuża ringiela u record
xulxin u xi

1232
00:59:33,530 --> 00:59:35,400
kolonna u l-qasam.

1233
00:59:35,400 --> 00:59:37,650
Iżda ringiela waħda hija rekord wieħed.

1234
00:59:37,650 --> 00:59:40,080
Kolonna waħda huwa qasam wieħed, li jmorru
lura din it-tabella.

1235
00:59:40,080 --> 00:59:44,210

1236
00:59:44,210 --> 00:59:45,420
>> OK.

1237
00:59:45,420 --> 00:59:47,310
Il-ħaġa li jmiss int probabilment
se tagħmel huwa nikseb xi

1238
00:59:47,310 --> 00:59:48,400
informazzjoni mit-tabella.

1239
00:59:48,400 --> 00:59:50,090
Din hija mistoqsija Agħżel.

1240
00:59:50,090 --> 00:59:52,330
U għal darb'oħra, liema tabella
am I tagħżel minn?

1241
00:59:52,330 --> 00:59:58,370
U dak kolonna irrid li tagħżel, jew
liema valur irrid biex jagħżlu u

1242
00:59:58,370 --> 00:59:59,530
minnu ringiela?

1243
00:59:59,530 --> 01:00:01,120
>> Allura l Select hija speċifika ftit.

1244
01:00:01,120 --> 01:00:03,620
I say, OK, nixtieq din it-tabella.

1245
01:00:03,620 --> 01:00:09,350
U mbagħad I jridu li l-username kolonna, u
I jriduhom mill-ringiela ma ID 2.

1246
01:00:09,350 --> 01:00:11,030
Li mod wieħed biex tagħmel Agħżel.

1247
01:00:11,030 --> 01:00:14,180
>> Jew nista 'ngħid, agħti lili kull
username uniku.

1248
01:00:14,180 --> 01:00:18,200
Jew nista 'ngħid, tagħti me kollu
ringiela minn din it-tabella, fejn

1249
01:00:18,200 --> 01:00:19,460
il-username huwa 1.

1250
01:00:19,460 --> 01:00:22,300
Allura hemm koppja modi differenti għall-
jagħmlu mistoqsijiet Agħżel skont kif

1251
01:00:22,300 --> 01:00:24,130
ħafna informazzjoni trid,

1252
01:00:24,130 --> 01:00:29,410
>> Inti tista 'dejjem jagħżlu biss kollox
minn dik it-tabella speċifika u mbagħad loop

1253
01:00:29,410 --> 01:00:31,320
permezz tagħha, picking
l-affarijiet trid.

1254
01:00:31,320 --> 01:00:33,940
Iżda jżomm f'moħħu, jekk int tagħżel
ħafna affarijiet minn tabella u int

1255
01:00:33,940 --> 01:00:37,400
jkollhom tabella verament kbir, li se jieħdu
xi żmien, hekk aħjar biex tagħżel biss

1256
01:00:37,400 --> 01:00:40,000
affarijiet li int ser
li tispiċċa bl-użu.

1257
01:00:40,000 --> 01:00:43,580
>> Ukoll, ma Select u kollha ta 'dawn
SQL oħra jikkmanda kif ukoll, jien

1258
01:00:43,580 --> 01:00:45,760
giving you l-verżjoni bare-għadam.

1259
01:00:45,760 --> 01:00:51,600
Imma ngħid, jien għażla utenti u nixtieq
biex tipprintjahom alfabetikament,

1260
01:00:51,600 --> 01:00:56,710
I tista 'tagħżel l-utenti kollha u mbagħad sort
lilhom alfabetikament fil-kodiċi tiegħi.

1261
01:00:56,710 --> 01:01:01,990
>> Jew hemm mod li tikteb il tagħżel
mistoqsija, li jagħżel l-affarijiet fil-

1262
01:01:01,990 --> 01:01:06,580
moda alfabetika, bbażata off ta '
kolonna speċifika, jew axxendenti jew

1263
01:01:06,580 --> 01:01:07,490
dixxendenti.

1264
01:01:07,490 --> 01:01:11,660
Allura wieħed iżomm f'moħħu li, lott ta 'dak li
trid tagħmel probabbilment jista 'jsir fil-

1265
01:01:11,660 --> 01:01:15,070
il-mistoqsija permezz addizzjonali
attribut.

1266
01:01:15,070 --> 01:01:19,120
So do ħarsa up dawn mistoqsijiet online jew
l-affarijiet oħra li tista 'tagħmel ma' dawn

1267
01:01:19,120 --> 01:01:21,410
mistoqsijiet li jespandu lilhom.

1268
01:01:21,410 --> 01:01:25,020
>> Fl-aħħarnett, l-aħħar ħaġa li trid tagħmel
mhuwiex daħħal xi ħaġa jew tħassar

1269
01:01:25,020 --> 01:01:26,700
xi ħaġa, iżda pjuttost
taġġorna xi ħaġa.

1270
01:01:26,700 --> 01:01:30,380
U li qed isir bl-aġġornament
query, u għal darb'oħra, liema tabella.

1271
01:01:30,380 --> 01:01:32,530
U dak il-bidla ma Irrid nagħmel?

1272
01:01:32,530 --> 01:01:35,915
U li għalihom ringiela jew rekord tagħmel
Irrid nagħmel din il-bidla?

1273
01:01:35,915 --> 01:01:38,720

1274
01:01:38,720 --> 01:01:40,300
Kwalunkwe mistoqsijiet dwar SQL?

1275
01:01:40,300 --> 01:01:47,070

1276
01:01:47,070 --> 01:01:47,310
>> OK.

1277
01:01:47,310 --> 01:01:49,080
Allura aħna għandna madwar 15 minuta.

1278
01:01:49,080 --> 01:01:51,460
U dan huwa l-aħħar slide I jkollhom.

1279
01:01:51,460 --> 01:01:55,380
U wieħed jittama, f'dan l-aħħar slide hija
segue tajba fil-problema stabbiliti,

1280
01:01:55,380 --> 01:01:58,820
għaliex fehim fejn irridu
daħħal rekords, iħassarha, tagħżel

1281
01:01:58,820 --> 01:02:03,420
minnhom, u taġġornahom se tgħinna
jifhmu l-loġika akbar u l-fluss

1282
01:02:03,420 --> 01:02:05,570
tas Problema Set 7.

1283
01:02:05,570 --> 01:02:08,330
>> So I jafu l-tweġibiet
għal dawn il-mistoqsijiet.

1284
01:02:08,330 --> 01:02:10,570
Jien mhux ser jgħidlek
kollha ta 'l-tweġibiet.

1285
01:02:10,570 --> 01:02:15,530
Imma jekk xi ħadd ieħor jixtieq
tippreżenta mistoqsija lill-grupp jew

1286
01:02:15,530 --> 01:02:18,700
tweġiba għal waħda minn dawn kwistjoni, nistgħu
użu li bħala jaqbeż off point għal

1287
01:02:18,700 --> 01:02:20,311
jitkellmu dwar is-sett problema.

1288
01:02:20,311 --> 01:02:24,159

1289
01:02:24,159 --> 01:02:27,260
Jew jekk xi ħadd ikollu aktar ġeneriku
kwistjoni off-sett problema, tħossok

1290
01:02:27,260 --> 01:02:28,210
liberu li jitlob dan ukoll.

1291
01:02:28,210 --> 01:02:29,460
U nistgħu tibda hemmhekk.

1292
01:02:29,460 --> 01:02:32,840

1293
01:02:32,840 --> 01:02:35,973
Wieħed iżomm f'moħħu li inti tkun siekta
huwa dannu kulħadd.

1294
01:02:35,973 --> 01:02:36,376
Yeah.

1295
01:02:36,376 --> 01:02:39,540
>> UDJENZA: Għalhekk hija l-uniku mod biex jgħaddu
varjabbli lejn u mill web differenti

1296
01:02:39,540 --> 01:02:44,532
paġni, jew l-aktar konvenjenti
mod, bl-użu POST jew IKOLLOK?

1297
01:02:44,532 --> 01:02:52,380
>> JASON Hirschhorn: Allura iva, li hija l-
aktar mod konvenjenti biex jgħidu - meta

1298
01:02:52,380 --> 01:02:53,970
xi ħadd jimla formola -

1299
01:02:53,970 --> 01:02:57,540
jiksbu informazzjoni dwar web ieħor
paġna, bl-użu IKOLLOK jew POST.

1300
01:02:57,540 --> 01:03:00,400

1301
01:03:00,400 --> 01:03:04,320
Minħabba l-qafas aħna qed jużaw
f'dan is-sett problema, inti ser ikollok avviż

1302
01:03:04,320 --> 01:03:08,630
li, ħafna drabi, aħna
tirrendi paġna oħra.

1303
01:03:08,630 --> 01:03:12,420
aħna Jew aħna jagħtu fajl ieħor, mhux
neċessarjament ieħor page.

1304
01:03:12,420 --> 01:03:14,050
>> Allura aħna jgħaddu fil-varjabbli.

1305
01:03:14,050 --> 01:03:16,400
U mbagħad, dan jirrendi
Paġna HTML, bl-użu

1306
01:03:16,400 --> 01:03:18,220
informazzjoni minn dak il-varjabbli.

1307
01:03:18,220 --> 01:03:20,790
Dan mhuwiex teknikament tgħaddi
informazzjoni bejn

1308
01:03:20,790 --> 01:03:21,910
paġni web differenti.

1309
01:03:21,910 --> 01:03:24,600
Li hija tgħaddi informazzjoni
bejn fajls differenti.

1310
01:03:24,600 --> 01:03:26,710
>> U hekk aħna tista 'tuża kwalunkwe
varjabbli li jagħmlu dan.

1311
01:03:26,710 --> 01:03:33,230
Imma iva, jekk ridna li jgħaddu
informazzjoni minn paġna partikolari biex

1312
01:03:33,230 --> 01:03:36,850
paġna oħra, IKOLLOK u POST kieku
jkun il-mod biex tagħmel dan.

1313
01:03:36,850 --> 01:03:43,060

1314
01:03:43,060 --> 01:03:45,765
Kwalunkwe mistoqsijiet oħra dwar
l-problema iffissati?

1315
01:03:45,765 --> 01:03:49,490

1316
01:03:49,490 --> 01:03:50,150
>> OK.

1317
01:03:50,150 --> 01:03:53,660
Ejja jgħaddu, imbagħad, speċifiku
parti mill-problema stabbiliti.

1318
01:03:53,660 --> 01:04:00,260
Inti ser jeħtieġ li, fuq punt wieħed,
juru portafoll ta 'xi ħadd fuq

1319
01:04:00,260 --> 01:04:01,710
l-iskrin.

1320
01:04:01,710 --> 01:04:06,454
What do I jfisser meta ngħidilhom portfolio,
fil-kuntest ta 'din il-problema iffissati?

1321
01:04:06,454 --> 01:04:11,350
>> UDJENZA: Huwa simili l-istokkijiet li huma
jkollhom sengħa, ħafna ishma huma stess,

1322
01:04:11,350 --> 01:04:13,760
il-prezz, u kemm
flus li jkunu ħallew.

1323
01:04:13,760 --> 01:04:15,235
>> JASON Hirschhorn: Dan ħsejjes kbar.

1324
01:04:15,235 --> 01:04:19,640
So I jridu juru l-istokkijiet
huma stess għal kull kumpanija istokk

1325
01:04:19,640 --> 01:04:23,770
ishma u probabbilment kemm hu
jiswew, u mbagħad varjabbli separata,

1326
01:04:23,770 --> 01:04:25,960
kemm flus huma stess.

1327
01:04:25,960 --> 01:04:27,150
Allura ngħid nixtieq li jiddeskrivu dan.

1328
01:04:27,150 --> 01:04:29,660
Nibdew jitkellem dwar kif I tista '
tmur dwar kif isir dan, dak tabelli jien

1329
01:04:29,660 --> 01:04:31,210
ser jeħtieġ li jkollhom
ikunu jistgħu jagħmlu dan.

1330
01:04:31,210 --> 01:04:34,070

1331
01:04:34,070 --> 01:04:34,460
Yeah -

1332
01:04:34,460 --> 01:04:37,970
>> UDJENZA: utenti Well, u mbagħad, I raden
inti tista 'tagħmel tabella msejħa

1333
01:04:37,970 --> 01:04:41,920
Ishma jew xi ħaġa bħal dik, li
Ikun kemm ħadthom mixtrija.

1334
01:04:41,920 --> 01:04:42,660
>> JASON Hirschhorn: OK.

1335
01:04:42,660 --> 01:04:46,530
Hekk jien ser jeħtieġu tabella msejħa
Utenti, li jżomm track tal-

1336
01:04:46,530 --> 01:04:50,640
username, preżumibbilment, probabbilment xi ID,
probabbilment password ta 'individwu.

1337
01:04:50,640 --> 01:04:52,850
X'inhu xi ħaġa oħra li inti
biss qal li huma assoċjati?

1338
01:04:52,850 --> 01:04:55,510
Xi ħadd minbarra Michael, dak li huwa
xi ħaġa oħra li huma assoċjati ma '

1339
01:04:55,510 --> 01:04:58,270
kull utent, uniku lilhom?

1340
01:04:58,270 --> 01:05:00,050
>> UDJENZA: ID.

1341
01:05:00,050 --> 01:05:01,170
>> JASON Hirschhorn: ID -

1342
01:05:01,170 --> 01:05:03,540
x'hemm ħaġa waħda oħra li aħna qed
probabbilment se jridu

1343
01:05:03,540 --> 01:05:05,685
display fuq din il-paġna?

1344
01:05:05,685 --> 01:05:06,990
>> UDJENZA: L-isem tagħhom.

1345
01:05:06,990 --> 01:05:10,550
>> JASON Hirschhorn: isem tagħhom - x'hemm
Ħaġa oħra relatati ma 'din

1346
01:05:10,550 --> 01:05:11,420
partikolari problema iffissati?

1347
01:05:11,420 --> 01:05:14,110
>> UDJENZA: Liema istokks huma stess -

1348
01:05:14,110 --> 01:05:16,650
>> JASON Hirschhorn: Hemm ser
jkun hemm ħafna ta 'dak ħażniet huma stess.

1349
01:05:16,650 --> 01:05:19,670
X'hemm waħda l-valur speċifiku għalkemm,
li huma ser ikollhom

1350
01:05:19,670 --> 01:05:22,640
assoċjati magħhom?

1351
01:05:22,640 --> 01:05:25,709
Kif huma ser jixtru
u jbigħu l-ħażniet tagħhom?

1352
01:05:25,709 --> 01:05:26,595
>> UDJENZA: Cash.

1353
01:05:26,595 --> 01:05:28,100
>> JASON Hirschhorn: Huma qed
se jkollhom flus.

1354
01:05:28,100 --> 01:05:31,020
Allura kull utent huwa se jkollu
valur wieħed għall-flus kontanti.

1355
01:05:31,020 --> 01:05:32,360
U li għaddej biex tkun
uniku għal kull utent.

1356
01:05:32,360 --> 01:05:35,040
Allura fit-tabella tal-utent, jagħmel
sens li tpoġġi fi flus kontanti.

1357
01:05:35,040 --> 01:05:39,100
>> Inti tista ', naturalment, joħolqu ieħor
tabella li għandha IDs utent u tagħhom

1358
01:05:39,100 --> 01:05:40,200
valur ta 'kontanti.

1359
01:05:40,200 --> 01:05:41,070
Iżda dan ma jagħmilx sens.

1360
01:05:41,070 --> 01:05:43,410
Jagħmel sens li biss jitqiegħed
kollha ta 'dik fit-tabella waħda.

1361
01:05:43,410 --> 01:05:46,860
>> Allura aħna qed tmur biex jkollhom tabella
ma 'dik l-informazzjoni.

1362
01:05:46,860 --> 01:05:48,360
U mbagħad, x'inhu l-tabella l-oħra
aħna qed tmur biex ikollhom?

1363
01:05:48,360 --> 01:05:49,430
Inti qal, tabella Ħażniet.

1364
01:05:49,430 --> 01:05:50,680
Liema huma aħna tqegħid fil-
il-mejda Ħażniet?

1365
01:05:50,680 --> 01:05:55,860

1366
01:05:55,860 --> 01:05:57,530
Kulħadd, ideat -

1367
01:05:57,530 --> 01:05:58,796
>> UDJENZA: Il-kumpanija.

1368
01:05:58,796 --> 01:06:00,020
>> JASON Hirschhorn: Aħna qed tmur
biex jitqiegħdu fil-isem tal-

1369
01:06:00,020 --> 01:06:03,620
kumpannija, hekk AAPL għall Apple.

1370
01:06:03,620 --> 01:06:04,050
Yeah.

1371
01:06:04,050 --> 01:06:05,390
>> UDJENZA: Kemm ishma u
kemm qed jiswew.

1372
01:06:05,390 --> 01:06:08,590
>> JASON Hirschhorn: Kemm ishma,
kemm qed jiswew -

1373
01:06:08,590 --> 01:06:10,630
x'hemm xi ħaġa oħra we
bżonn f'dik it-tabella?

1374
01:06:10,630 --> 01:06:12,770
>> UDJENZA: A user ID sabiex indiċi.

1375
01:06:12,770 --> 01:06:14,000
>> JASON Hirschhorn: A User ID.

1376
01:06:14,000 --> 01:06:16,070
Allura f'dik it-tabella, aħna ser
probabilment jkollhom -

1377
01:06:16,070 --> 01:06:18,610
ejja ngħidu, jekk huwa xi ħadd li tippossjedi
tliet ħażniet, tliet fillieri, kull ma

1378
01:06:18,610 --> 01:06:23,730
li ID utent jew l-utent li individwu
ID, iżda isem kumpanija differenti, a

1379
01:06:23,730 --> 01:06:28,570
numru differenti ta 'ishma preżumibilment,
u valur differenti prezz għal kull

1380
01:06:28,570 --> 01:06:29,820
ta 'dawk l-istokkijiet.

1381
01:06:29,820 --> 01:06:34,690

1382
01:06:34,690 --> 01:06:37,130
Għal darb'oħra, dak li jien tgħid issa mhux
neċessarjament l-implimentazzjoni,

1383
01:06:37,130 --> 01:06:39,150
għaliex inti tirrealizza hemm xi aktar
modi effiċjenti biex jimplimentawh.

1384
01:06:39,150 --> 01:06:41,020
Iżda dan huwa post tajjeb fejn tibda.

1385
01:06:41,020 --> 01:06:41,430
>> OK.

1386
01:06:41,430 --> 01:06:42,830
Għalhekk dawn huma l-żewġ tabelli għandna.

1387
01:06:42,830 --> 01:06:44,470
Issa rridu li juru din il-paġna.

1388
01:06:44,470 --> 01:06:48,510
X'inhu l-ewwel tip ta 'mistoqsija
aħna se bżonn tagħmel.

1389
01:06:48,510 --> 01:06:52,190
Fuq kull paġna, preżunt li huwa utent
illoggjat, għandna user ID tagħhom.

1390
01:06:52,190 --> 01:06:55,480
Allura x'inhi l-ewwel tip ta '
mistoqsija li għandna bżonn nagħmlu?

1391
01:06:55,480 --> 01:06:55,910
Yeah.

1392
01:06:55,910 --> 01:06:56,936
>> UDJENZA: utent tagħhom ID.

1393
01:06:56,936 --> 01:07:00,090
>> JASON Hirschhorn: Għandna user ID tagħhom,
meta aħna qed jibdew kodiċi fil-

1394
01:07:00,090 --> 01:07:01,340
bidu tal-paġna tagħna.

1395
01:07:01,340 --> 01:07:03,880

1396
01:07:03,880 --> 01:07:06,470
Allura x'inhu l-ewwel tip ta 'mistoqsija we
bżonn tagħmel, peress ID ta 'utent?

1397
01:07:06,470 --> 01:07:09,580

1398
01:07:09,580 --> 01:07:10,530
Aħna marru matul l-erba 'tipi.

1399
01:07:10,530 --> 01:07:11,860
Hemm biss erba 'risposti possibbli.

1400
01:07:11,860 --> 01:07:13,230
>> UDJENZA: Huwa tagħżel rekord.

1401
01:07:13,230 --> 01:07:14,710
>> JASON Hirschhorn: A Agħżel -

1402
01:07:14,710 --> 01:07:19,110
irridu li tagħżel mill-l-utent
mejda biex tikseb, ejja ngħidu,

1403
01:07:19,110 --> 01:07:20,040
ammont ta 'flus tagħhom.

1404
01:07:20,040 --> 01:07:22,450
U nistgħu jistampaw l-ammont ta 'flus
fuq il-quċċata 'l-iskrin.

1405
01:07:22,450 --> 01:07:22,720
OK.

1406
01:07:22,720 --> 01:07:24,210
X'hemm-tip li jmiss ta '
mistoqsija li rridu nagħmlu?

1407
01:07:24,210 --> 01:07:34,650

1408
01:07:34,650 --> 01:07:36,160
>> Għandna xi affarijiet oħra
għandna bżonn li juri.

1409
01:07:36,160 --> 01:07:37,480
Dawk huma salvati fit-tabella ieħor.

1410
01:07:37,480 --> 01:07:38,300
Allura kif huma aħna se tikseb dan?

1411
01:07:38,300 --> 01:07:40,106
>> UDJENZA: Tista tagħżel għalihom.

1412
01:07:40,106 --> 01:07:42,490
>> JASON Hirschhorn: A Select - għal darb'oħra,
hemm biss erba 'għażliet.

1413
01:07:42,490 --> 01:07:44,180
Agħżel probabbilment ħsejjes
bħall-dritt wieħed.

1414
01:07:44,180 --> 01:07:47,510
Allura rridu nagħmlu mistoqsija tagħżel ieħor,
darb'oħra bl-użu din user ID.

1415
01:07:47,510 --> 01:07:50,370
U issa, aħna rridu li jirritornaw mhux wieħed biss
ringiela, bu ringieli kollha li jaqblu tagħna

1416
01:07:50,370 --> 01:07:53,200
kriterji, fejn utent ID huwa daqs 1.

1417
01:07:53,200 --> 01:07:56,790
>> U allura aħna tista 'tmur u let loop biss
jistampa dawk kollha fuq l-iskrin,

1418
01:07:56,790 --> 01:07:59,250
forsi jistampa l-kumpanija minn
kull wieħed minn dawk fuq l-iskrin.

1419
01:07:59,250 --> 01:08:02,430
Great, li tinstema 'li l-
wiri portafoll, mhux aktar

1420
01:08:02,430 --> 01:08:03,810
ikkumplikati minn dak.

1421
01:08:03,810 --> 01:08:07,460
>> OK, l-utent imbagħad tiddeċiedi li
għandhom ħafna ta 'flus fadal.

1422
01:08:07,460 --> 01:08:09,900
U huma jridu jixtru xi
ishma aktar ta 'stokk.

1423
01:08:09,900 --> 01:08:12,580
Ejja ngħidu, huma diġà stess
istokk din il-kumpanija wisq.

1424
01:08:12,580 --> 01:08:14,110
>> Allura jmorru għall-paġna jixtru tiegħek.

1425
01:08:14,110 --> 01:08:16,830
Huma input isem tal-kumpanija.

1426
01:08:16,830 --> 01:08:20,380
X'inhu l-mistoqsija, wara li tiddaħħal l-
isem tal-kumpanija, li inti jeħtieġ li

1427
01:08:20,380 --> 01:08:22,819
tesegwixxi jmiss?

1428
01:08:22,819 --> 01:08:23,180
Yeah.

1429
01:08:23,180 --> 01:08:23,960
>> UDJENZA: Update.

1430
01:08:23,960 --> 01:08:26,670
>> JASON Hirschhorn: Aġġornament - u dak
tabella tridu li taġġorna?

1431
01:08:26,670 --> 01:08:29,018
>> UDJENZA: tabella tagħhom, ibbażata
fuq numru ta 'ID tagħhom?

1432
01:08:29,018 --> 01:08:31,880
>> JASON Hirschhorn: So taġġorna
ma l-utent tabella -

1433
01:08:31,880 --> 01:08:36,029

1434
01:08:36,029 --> 01:08:40,899
hekk aġġornata t-tabella Stocks, fejn il-
user ID logħbiet mhux biss, iżda l-

1435
01:08:40,899 --> 01:08:43,160
Isem istokk wkoll logħbiet.

1436
01:08:43,160 --> 01:08:45,660
Int ser tingħata xi valur.

1437
01:08:45,660 --> 01:08:48,270
U mbagħad, inneħħu inti tixtieq li tieħu dan il-valur
u żid madankollu ħafna stokkijiet huma

1438
01:08:48,270 --> 01:08:49,890
jridu jixtru minnu.

1439
01:08:49,890 --> 01:08:53,420
>> Allura inti ma tridx li bl-addoċċ
jissostitwixxu dak il-valur.

1440
01:08:53,420 --> 01:08:56,330
Iżda int tista ', fil-fatt, jieħdu dik inizjali
valur u biss taġġornah.

1441
01:08:56,330 --> 01:09:00,790
Tista 'tagħmel bħal plus ugwali,
pjuttost milli sempliċement ugwali.

1442
01:09:00,790 --> 01:09:03,689
>> X'inhu xi ħaġa għalkemm - jekk aħna qed
ħsieb dwar dan u irridu nkunu

1443
01:09:03,689 --> 01:09:08,090
kemm jista 'jkun sodi - għandna nagħmlu
qabel we run li query aġġornament?

1444
01:09:08,090 --> 01:09:09,859
Huma jridu jixtru ħames snin ta 'Apple.

1445
01:09:09,859 --> 01:09:11,030
Kull sehem ta 'Apple huwa $ 200.

1446
01:09:11,030 --> 01:09:12,762
>> UDJENZA: Aħna tiċċekkja flus ewwel.

1447
01:09:12,762 --> 01:09:15,130
>> JASON Hirschhorn: Aħna għandhom
check flus ewwel.

1448
01:09:15,130 --> 01:09:16,680
Għandna niżguraw li
jkollhom flus biżżejjed.

1449
01:09:16,680 --> 01:09:20,766
X'tip ta 'mistoqsija nistgħu tesegwixxi li
kun żgur li għandek flus biżżejjed?

1450
01:09:20,766 --> 01:09:22,143
>> UDJENZA: Ieħor Agħżel.

1451
01:09:22,143 --> 01:09:23,680
>> JASON Hirschhorn: A Agħżel -

1452
01:09:23,680 --> 01:09:26,580
aħna tagħżel ibbażata fuq user ID tagħhom,
biex jiksbu valur tagħhom fi flus kontanti.

1453
01:09:26,580 --> 01:09:27,620
Do xi matematika malajr.

1454
01:09:27,620 --> 01:09:30,279
U jekk dan jgħaddi ġemgħa,
dawn ikollhom biżżejjed flus.

1455
01:09:30,279 --> 01:09:31,580
Imbagħad nistgħu run aġġornament tagħna.

1456
01:09:31,580 --> 01:09:33,850
Jew forsi, jekk le, aħna jgħaddu imbagħad.

1457
01:09:33,850 --> 01:09:35,370
Aħna tagħtihom twissija.

1458
01:09:35,370 --> 01:09:35,710
>> OK.

1459
01:09:35,710 --> 01:09:36,560
Jgħidu li ma jkollhom kumpanija.

1460
01:09:36,560 --> 01:09:37,310
Huma qed jixtru kumpannija ġdida.

1461
01:09:37,310 --> 01:09:39,910
Huma qed jixtru Microsoft.

1462
01:09:39,910 --> 01:09:41,910
X'tip ta 'mistoqsijiet ma rridu nagħmlu,
jekk huma jixtiequ li jixtru Microsoft?

1463
01:09:41,910 --> 01:09:43,350
U dawn ma jipposjedi l-ebda Microsoft.

1464
01:09:43,350 --> 01:09:47,520
Mhux Manu, ħaddieħor, xi ħadd
minbarra Marcus?

1465
01:09:47,520 --> 01:09:48,229
Carlos -

1466
01:09:48,229 --> 01:09:50,870
>> UDJENZA: A Select, tagħmel żgur
huma għandhom biżejjed flus.

1467
01:09:50,870 --> 01:09:51,770
>> JASON Hirschhorn: Ħsejjes tajba.

1468
01:09:51,770 --> 01:09:54,815
>> UDJENZA: U allura inti daħħal
fuq il-[inaudible].

1469
01:09:54,815 --> 01:09:56,500
>> JASON Hirschhorn: Eżattament, aħna qed
tmur jridu li daħħal

1470
01:09:56,500 --> 01:09:57,800
fit-tabella Stocks.

1471
01:09:57,800 --> 01:09:59,370
U aħna qed tmur jridu li daħħal.

1472
01:09:59,370 --> 01:10:02,510
Nistgħu daħħal user ID tagħhom, l-isem
tal-kumpanija, u kemm ishma

1473
01:10:02,510 --> 01:10:03,940
li jridu jixtru.

1474
01:10:03,940 --> 01:10:08,040
>> Liema huma xi operazzjonijiet oħra li
huma paġni jew funzjonalità int

1475
01:10:08,040 --> 01:10:10,420
se jkollhom jimplimentaw P-Set
7, li għandna jmorru fuq?

1476
01:10:10,420 --> 01:10:12,160
>> UDJENZA: Attwalment, I tip ta 'jkollu
mistoqsija dwar dan wieħed.

1477
01:10:12,160 --> 01:10:18,000
Qabel ma juru l-portafoll, jekk
inti tiċċekkja websajt Yahoo biex

1478
01:10:18,000 --> 01:10:19,920
Kun żgur li l-prezzijiet istokk
ma nbidlux?

1479
01:10:19,920 --> 01:10:21,660
>> JASON Hirschhorn: Li ħsejjes
bħal idea tajba.

1480
01:10:21,660 --> 01:10:27,260
Allura dak Marcus qed tgħid hi, OK, stokk
prezzijiet qed jinbidlu.

1481
01:10:27,260 --> 01:10:32,840
Fil-istokkijiet li huma stess it-tabella, tagħna
tabella msejħa ħażniet, nistgħu tiffranka l-

1482
01:10:32,840 --> 01:10:35,360
prezz ta 'l-istokk huma mixtrija dan fil.

1483
01:10:35,360 --> 01:10:37,990
>> Iżda dan ma jidhirx li robusta,
minħabba li l-prezz ta 'l-istokk huwa

1484
01:10:37,990 --> 01:10:39,490
kontinwament se jibdlu.

1485
01:10:39,490 --> 01:10:41,990
Allura fil-fatt, inti probabilment ma bżonn
biex isalva l-prezz ta 'l-istokk.

1486
01:10:41,990 --> 01:10:45,230
Imma kull darba li inti display tagħhom
portafoll, inti jġedded jew jaġġorna l-

1487
01:10:45,230 --> 01:10:46,280
prezz tal-istokk.

1488
01:10:46,280 --> 01:10:48,720
>> U jekk ikollok - u
għandek diġà.

1489
01:10:48,720 --> 01:10:51,330
Naf li inti stajt kollha ħares fil-
problema settijiet lura diġà.

1490
01:10:51,330 --> 01:10:55,410
Inti għandek induna li konna bil-miktub
xi kodiċi għalik li inti se tippermetti

1491
01:10:55,410 --> 01:10:57,650
biex jiksbu l-prezz ta 'stokk,
isem mogħti kumpanija.

1492
01:10:57,650 --> 01:10:59,620
>> Allura iva, li probabbilment ħsejjes
daqsxejn aktar robust.

1493
01:10:59,620 --> 01:11:04,260
Iżda dik it-tabella ma għandhiex neċessarjament
biex isalva l-prezz ta 'l-istokk.

1494
01:11:04,260 --> 01:11:04,720
OK.

1495
01:11:04,720 --> 01:11:07,590
Liema huma xi funzjonalitajiet oħra li
bżonn biex jimplimentaw din il-ġimgħa li

1496
01:11:07,590 --> 01:11:10,340
nistgħu nitkellmu dwar?

1497
01:11:10,340 --> 01:11:11,590
I trid titkellem dwarhom.

1498
01:11:11,590 --> 01:11:14,342

1499
01:11:14,342 --> 01:11:16,516
>> What do inti tixtieq li nitkellmu dwar?

1500
01:11:16,516 --> 01:11:17,810
Huwa probabbilment f'dan spec.

1501
01:11:17,810 --> 01:11:20,600
Nixtieq biss iscroll sal-qiegħ
tal-spec u jistaqsu lili l-ewwel kelma

1502
01:11:20,600 --> 01:11:21,850
tara li ma jagħmilx sens.

1503
01:11:21,850 --> 01:11:55,130

1504
01:11:55,130 --> 01:11:56,960
Funzjonalità waħda oħra -

1505
01:11:56,960 --> 01:11:57,840
ejja nitkellmu dwar wieħed.

1506
01:11:57,840 --> 01:12:00,775
Aħna ser tibda hemmhekk.

1507
01:12:00,775 --> 01:12:02,065
>> UDJENZA: Reġistrazzjoni l-istorja.

1508
01:12:02,065 --> 01:12:03,960
>> JASON Hirschhorn: Reġistrazzjoni
l-istorja, waħda kbira.

1509
01:12:03,960 --> 01:12:06,920
Allura int ser jkollhom iżommu rekord
ta 'l-istorja ta' tranżazzjonijiet.

1510
01:12:06,920 --> 01:12:10,840

1511
01:12:10,840 --> 01:12:14,270
Allura inti tixtieq li jżommu rekord ta 'kull
darba li jixtru jew ibigħu l-istokk.

1512
01:12:14,270 --> 01:12:15,160
>> I mixtrija istokk tiegħi.

1513
01:12:15,160 --> 01:12:18,580
Aħna biss qal, huwa probabbilment jagħmel sens
li jinkludu Agħżel, biex jiksbu tagħhom

1514
01:12:18,580 --> 01:12:20,220
ammont ta 'flus u iċċekkja lura.

1515
01:12:20,220 --> 01:12:25,270
Huwa probabbilment smart allura li tinkludi
daħħal jew aġġornament, jiddependi fuq

1516
01:12:25,270 --> 01:12:27,720
jekk huma stess dak l-istokk.

1517
01:12:27,720 --> 01:12:32,740
Jekk aħna rridu wkoll li jżommu rekord ta '
storja, kif nistgħu nagħmlu dan?

1518
01:12:32,740 --> 01:12:37,530

1519
01:12:37,530 --> 01:12:38,720
Does li jmorru fit-tabella Ħażniet?

1520
01:12:38,720 --> 01:12:39,822
>> UDJENZA: Le

1521
01:12:39,822 --> 01:12:42,130
>> JASON Hirschhorn: Nru probabbilment
tmur f'tabella differenti.

1522
01:12:42,130 --> 01:12:44,040
Għaliex ngħidu li inti tixtri 10
ishma ta 'Apple.

1523
01:12:44,040 --> 01:12:45,370
Imbagħad inti tixtri 10-ishma ieħor.

1524
01:12:45,370 --> 01:12:46,610
Inti tixtieq tirmonka records separati.

1525
01:12:46,610 --> 01:12:47,610
Dawk huma żewġ operazzjonijiet distinti.

1526
01:12:47,610 --> 01:12:50,510
>> Allura aħna għandna ieħor tabella,
tabella History.

1527
01:12:50,510 --> 01:12:51,880
Għalhekk għal darb'oħra, nixtru.

1528
01:12:51,880 --> 01:12:54,080
Aħna tesegwixxi Agħżel, imbagħad
l Daħħal jew Update.

1529
01:12:54,080 --> 01:12:56,410
Dak li nagħmlu jmiss?

1530
01:12:56,410 --> 01:13:00,410
X'hemm l-mistoqsija li jmiss aħna iwettaq
meta aħna qed jixtru xi ħaġa?

1531
01:13:00,410 --> 01:13:01,430
Aħna rridu li jżommu rekord ta 'storja.

1532
01:13:01,430 --> 01:13:01,570
Yeah.

1533
01:13:01,570 --> 01:13:05,195
>> UDJENZA: Inti tixtieq li żżomm rekord
ta 'tranżazzjonijiet naqas wisq.

1534
01:13:05,195 --> 01:13:07,700
>> JASON Hirschhorn: Well, qabel we
jgħidu liema tip ta 'transazzjoni,

1535
01:13:07,700 --> 01:13:11,080
dak li rridu -

1536
01:13:11,080 --> 01:13:13,910
Liema tip ta 'mistoqsija, Carlos, kieku
inessu li jżommu rekord

1537
01:13:13,910 --> 01:13:16,216
affarijiet b'mod ġenerali?

1538
01:13:16,216 --> 01:13:17,860
Għandek erba guesses.

1539
01:13:17,860 --> 01:13:18,660
Liema waħda taħseb?

1540
01:13:18,660 --> 01:13:20,835
>> UDJENZA: Aġġornament.

1541
01:13:20,835 --> 01:13:22,400
>> JASON Hirschhorn: Mhux aġġornament.

1542
01:13:22,400 --> 01:13:25,250
X'hemm tieni raden tiegħek?

1543
01:13:25,250 --> 01:13:26,730
>> UDJENZA: Għażla.

1544
01:13:26,730 --> 01:13:30,020
>> JASON Hirschhorn: Jekk inti tixtieq li żżomm
track ta 'xi ħaġa, inti probabilment tixtieq

1545
01:13:30,020 --> 01:13:33,310
biex iktibha x'imkien
jew ħlief għal aktar tard.

1546
01:13:33,310 --> 01:13:37,054
Hekk jekk ma aġġornament, allura -

1547
01:13:37,054 --> 01:13:38,310
>> UDJENZA: Daħħal dan.

1548
01:13:38,310 --> 01:13:39,553
>> JASON Hirschhorn: Daħħal, hemm immorru.

1549
01:13:39,553 --> 01:13:44,230
Iva, sabiex inti tagħżel l-ammont ta '
flus kontanti huma għandhom, ħsejjes kbar.

1550
01:13:44,230 --> 01:13:45,320
Huma ma jkollhomx biżżejjed flus.

1551
01:13:45,320 --> 01:13:46,720
Din it-tranżazzjoni mhuwiex sejjer jaħdem.

1552
01:13:46,720 --> 01:13:49,440
Le, inti m'għandekx bżonn li jżommu rekord ta '
transazzjoni jekk din ma taħdimx.

1553
01:13:49,440 --> 01:13:52,280
Jew tista ', jekk inti tixtieq li
tagħtihom hard time.

1554
01:13:52,280 --> 01:13:53,430
Imma inti ma għandekx.

1555
01:13:53,430 --> 01:13:55,820
>> Imbagħad, inti daħħal jew aġġornament
fit-tabella Ħażniet tagħhom.

1556
01:13:55,820 --> 01:13:57,260
U issa, inti għandek tabella oħra tiegħek.

1557
01:13:57,260 --> 01:13:59,790
Inti għandek mejda istorja tiegħek jew
tkun xi tkun tixtieq li hija sejħa.

1558
01:13:59,790 --> 01:14:02,920
U f'dik it-tabella, int ser
daħħal ringiela ġdida.

1559
01:14:02,920 --> 01:14:04,205
>> Li probabbilment se
ikollhom ID tal-utent.

1560
01:14:04,205 --> 01:14:05,840
Huwa probabbilment se jkollhom
l-isem tal-istokk.

1561
01:14:05,840 --> 01:14:08,760
Huwa probabbilment se jkollhom
żmien li huma għamlu dan.

1562
01:14:08,760 --> 01:14:11,500
U f'dan il-każ, inti ll probabbilment
tixtieq li daħħal il-prezz.

1563
01:14:11,500 --> 01:14:13,960
Għaliex għal storja, inti ma
kura dak il-prezz attwali.

1564
01:14:13,960 --> 01:14:17,140
Inti kura dak il-prezz huwa meta
huma mixtrija jew mibjugħa xi ħaġa.

1565
01:14:17,140 --> 01:14:21,530
>> Allura li ħsejjes simili, li jimplimentaw ix-xiri
jinvolvi bis-sħiħ għadd ta 'differenti

1566
01:14:21,530 --> 01:14:25,530
Mistoqsijiet SQL, Iżda onestament, ma
kodiċi ġenerali li ħafna.

1567
01:14:25,530 --> 01:14:26,330
OK.

1568
01:14:26,330 --> 01:14:28,840
U li jieħu ħsieb ta 'l-istorja.

1569
01:14:28,840 --> 01:14:30,450
>> Ejja ngħidu, irridu
juru l-istorja tagħna.

1570
01:14:30,450 --> 01:14:31,670
Tkellimna dwar wiri
portafoll tagħna.

1571
01:14:31,670 --> 01:14:33,902
Kif aħna wiri istorja tagħna?

1572
01:14:33,902 --> 01:14:36,312
>> UDJENZA: Preżumibbilment kronoloġikament.

1573
01:14:36,312 --> 01:14:37,920
>> JASON Hirschhorn: Preżumibbilment
kronoloġikament -

1574
01:14:37,920 --> 01:14:39,400
liema query taħseb aħna'd użu?

1575
01:14:39,400 --> 01:14:40,675
>> UDJENZA: A tagħżel.

1576
01:14:40,675 --> 01:14:41,840
>> JASON Hirschhorn: A Agħżel -

1577
01:14:41,840 --> 01:14:46,590
jagħżlu forsi ringieli kollha minn dik it-tabella
li jaqblu mal-user ID u mbagħad

1578
01:14:46,590 --> 01:14:49,510
jesponihom kronoloġiku,
ħsejjes tajba.

1579
01:14:49,510 --> 01:14:52,590
Għandna bżonn biex jikteb il-kodiċi li
sort permezz dik il-lista?

1580
01:14:52,590 --> 01:14:55,084
>> UDJENZA: Le, għaliex inti told
us hemm axxendenti

1581
01:14:55,084 --> 01:14:57,320
u ħaġa dixxendenti.

1582
01:14:57,320 --> 01:14:58,230
>> JASON Hirschhorn: Thing?

1583
01:14:58,230 --> 01:14:59,190
>> UDJENZA: Yeah.

1584
01:14:59,190 --> 01:15:01,270
>> JASON Hirschhorn: Yeah.

1585
01:15:01,270 --> 01:15:09,300
OK, ma jduru kodiċi lili, li
manwalment xorta permezz mistoqsijiet tiegħek,

1586
01:15:09,300 --> 01:15:09,820
biex sort lilhom.

1587
01:15:09,820 --> 01:15:12,480
Dan il-kodiċi huwa diġà mogħti.

1588
01:15:12,480 --> 01:15:15,310
Tista 'tikteb query Select
li xorta affarijiet.

1589
01:15:15,310 --> 01:15:18,900
Sort lilhom minn qabel u
mbagħad tipprintjahom.

1590
01:15:18,900 --> 01:15:22,070
Hija tagħmel hekk ħafna aktar sens li jagħmlu
dan il-mod, milli l-mod ieħor.

1591
01:15:22,070 --> 01:15:22,375
Iva.

1592
01:15:22,375 --> 01:15:23,925
>> UDJENZA: Do we bżonn li
sort lilhom minn qabel?

1593
01:15:23,925 --> 01:15:25,976
Ma jfissirx li inti sort
lilhom fid-database?

1594
01:15:25,976 --> 01:15:30,510
>> JASON Hirschhorn: Il-query Select
prospetti lilek Issortjati.

1595
01:15:30,510 --> 01:15:34,990
Allura tagħmel dan, aktar milli biss jkollhom magħhom
ritorn lilek f'ordni każwali u

1596
01:15:34,990 --> 01:15:36,150
imbagħad sort lilhom yourself.

1597
01:15:36,150 --> 01:15:36,405
Yeah.

1598
01:15:36,405 --> 01:15:39,925
>> UDJENZA: Hemm mod biex jżommha
magħżula fid-database nfisha, sabiex

1599
01:15:39,925 --> 01:15:41,355
inti ma għandekx biex issolvi
dan kull darba li inti -

1600
01:15:41,355 --> 01:15:43,065
>> UDJENZA: Tista daħħalha Issortjati?

1601
01:15:43,065 --> 01:15:45,740
>> JASON Hirschhorn: Mistoqsija -

1602
01:15:45,740 --> 01:15:49,796
ma jimpurtax li l-affarijiet
magħżula fid-database?

1603
01:15:49,796 --> 01:15:50,700
>> UDJENZA: Le

1604
01:15:50,700 --> 01:15:52,240
>> JASON Hirschhorn: Well,
huma magħżula.

1605
01:15:52,240 --> 01:15:53,100
Huma qed magħżula kronoloġikament.

1606
01:15:53,100 --> 01:15:55,060
Imma ejja nassumu li l-affarijiet huma magħżula

1607
01:15:55,060 --> 01:15:57,640
kronoloġiku, minn fuq għal isfel.

1608
01:15:57,640 --> 01:15:58,930
Għandna forma Google.

1609
01:15:58,930 --> 01:16:01,400
Kull meta xi ħadd jirrispondi għall Google tagħna
forma, hija biss gets jitqiegħdu fil-

1610
01:16:01,400 --> 01:16:02,480
qiegħ ta 'dik it-tabella.

1611
01:16:02,480 --> 01:16:07,318
Ma jimpurtax li l-affarijiet
magħżula ma kronoloġikament?

1612
01:16:07,318 --> 01:16:11,290
>> UDJENZA: Jekk mhuwiex kronoloġika,
ma inti għandek sort dan kull darba

1613
01:16:11,290 --> 01:16:12,920
tieħu info out.

1614
01:16:12,920 --> 01:16:16,730
Imma jekk huwa diġà magħżula, ma tista 'inti
ma għandekx tagħmel dan addizzjonali

1615
01:16:16,730 --> 01:16:17,570
sejħa funzjoni?

1616
01:16:17,570 --> 01:16:20,690
>> JASON Hirschhorn: Allura dak
attwalment punt tajjeb.

1617
01:16:20,690 --> 01:16:23,690
Għalina bħala programmaturi,
jista jimpurtax.

1618
01:16:23,690 --> 01:16:26,190
U aħna tista 'tixtieq li ssib database
li ma issolvi l-affarijiet

1619
01:16:26,190 --> 01:16:26,900
kronoloġikament.

1620
01:16:26,900 --> 01:16:30,100
Jew jistabbilixxu database tagħna, sabiex iżomm
affarijiet magħżula mill user ID.

1621
01:16:30,100 --> 01:16:34,060
>> Allura mod, ngħidu aħna, għandna
1,000 IDs utent.

1622
01:16:34,060 --> 01:16:36,690
Jew Facebook, għandna miljuni
ta 'IDs utent.

1623
01:16:36,690 --> 01:16:39,560
Aħna ma rridux mejda tagħna li jkun biss
każwali jew database tagħna li tkun bl-addoċċ.

1624
01:16:39,560 --> 01:16:41,630
Ikun sbieħ jekk l-
IDs utent ġew magħżula.

1625
01:16:41,630 --> 01:16:46,020
Mela allura aħna tista 'tmexxi tfittxijiet binarji
fuq il-mejda tagħna u mbagħad biss issib il-

1626
01:16:46,020 --> 01:16:47,050
blokki speċifiċi.

1627
01:16:47,050 --> 01:16:50,640
>> Allura iva, jiddependi fuq - jekk aħna jitkabbru,
aħna tista 'tixtieq li ssib database

1628
01:16:50,640 --> 01:16:53,370
li l-affarijiet jinżammu magħżula b'mod differenti
mod, sabiex dawn mistoqsijiet

1629
01:16:53,370 --> 01:16:54,140
se tieħu anqas ħin.

1630
01:16:54,140 --> 01:16:56,820
U aħna ma jkollhom jgħaddu tagħna
database kollu f'kull ringiela waħda fil-

1631
01:16:56,820 --> 01:16:58,260
tabella partikulari.

1632
01:16:58,260 --> 01:17:01,640
Iżda l-livell aħna qed jaħdmu fuq, aħna
ma bżonn ninkwetaw dwar iż-żamma

1633
01:17:01,640 --> 01:17:02,270
affarijiet magħżula.

1634
01:17:02,270 --> 01:17:06,100
Aħna jista 'jassumi li l-ħin li tieħu
li query jiddekorri se tkun

1635
01:17:06,100 --> 01:17:08,910
negliġibbli, meta jitqies dak
aħna qed jittrattaw.

1636
01:17:08,910 --> 01:17:13,550
Iżda iva, idea kbira - kif aħna żżid up,
jista 'jagħmel sens li disinn tagħna

1637
01:17:13,550 --> 01:17:15,390
database fil-daqsxejn ta 'mod differenti.

1638
01:17:15,390 --> 01:17:18,520
>> Wieħed finali ħaġa disinn database nixtieq
nsemmux kif ukoll, għaliex inti se

1639
01:17:18,520 --> 01:17:22,660
jiġu gradati, jew skorja pjuttost, fuq
id-disinn ta 'database tiegħek.

1640
01:17:22,660 --> 01:17:24,160
Aħna tkellimna dwar dan.

1641
01:17:24,160 --> 01:17:27,490
Cash hija unika għal kull utent.

1642
01:17:27,490 --> 01:17:30,820
Allura inti ħadthom ltqajna tabella msejħa flus li
għandha user ID tagħhom u l-ammont tagħhom ta '

1643
01:17:30,820 --> 01:17:33,370
flus kontanti u mbagħad tabella msejħa
utenti li għandha l-utent tagħhom

1644
01:17:33,370 --> 01:17:34,810
ID u username tagħhom.

1645
01:17:34,810 --> 01:17:37,390
>> Dawn it-tabelli mappa fuq kull
ieħor wieħed għal wieħed.

1646
01:17:37,390 --> 01:17:39,520
Huwa probabbilment jagħmel sens
li jkunu tabella waħda.

1647
01:17:39,520 --> 01:17:42,750

1648
01:17:42,750 --> 01:17:44,830
Mela ejja nassumu għandek utent
tabella li żżomm kont ta '

1649
01:17:44,830 --> 01:17:46,220
ismijiet utent u flus kontanti.

1650
01:17:46,220 --> 01:17:49,960
Inti issa għandhom tabella li għandha l-
ħażniet individwu tippossjedi.

1651
01:17:49,960 --> 01:17:52,130
>> U individwu jista stess
aktar minn stokk wieħed.

1652
01:17:52,130 --> 01:17:54,900
Allura dawn ma mappa fuq
kull wieħed għal ieħor.

1653
01:17:54,900 --> 01:18:00,140
Ma jagħmilx sens li jkun ġgant wieħed
tabella li għandha 30-rekords li

1654
01:18:00,140 --> 01:18:02,960
kollha jirrepetu username, li kollha
jirrepetu password, li kollha

1655
01:18:02,960 --> 01:18:04,680
irrepeti numru ta 'flus kontanti.

1656
01:18:04,680 --> 01:18:08,360
Iżda kull waħda għandha forsi stokk differenti
isem jew prezz tat-titoli differenti.

1657
01:18:08,360 --> 01:18:11,310
>> Ma jagħmilx sens li jkun
li ħafna reġistri kbar.

1658
01:18:11,310 --> 01:18:14,880
Be smart dwar meta inti toħloq dawn
databases, sabiex inti mhux qed jagħmlu

1659
01:18:14,880 --> 01:18:20,050
xi ħaġa iblah bħal dik, tirrepeti
ħafna informazzjoni żejda.

1660
01:18:20,050 --> 01:18:20,570
>> OK.

1661
01:18:20,570 --> 01:18:22,570
Għandna żewġ minuti xellug.

1662
01:18:22,570 --> 01:18:26,580
Persuni barra huma eċċitati biex jissieħbu
us jew probabbilment, preżumibbilment,

1663
01:18:26,580 --> 01:18:27,650
jibdew klassi tagħhom stess.

1664
01:18:27,650 --> 01:18:30,110
Ħadd ma jkollu xi mistoqsijiet
qabel we finish up?

1665
01:18:30,110 --> 01:18:35,520

1666
01:18:35,520 --> 01:18:38,620
>> OK, dan kien tabilħaqq whirlwind
permezz kollox.

1667
01:18:38,620 --> 01:18:43,510
I ruhna li kellu jkun hekk malajr
u li aħna ma jista 'jkun bħala hands-on

1668
01:18:43,510 --> 01:18:46,640
din il-ġimgħa kif nixtieq stajt
xtaqu li ġew.

1669
01:18:46,640 --> 01:18:50,610
Imma jekk għandek xi mistoqsijiet dwar
xejn aħna marru fuq jew xejn

1670
01:18:50,610 --> 01:18:52,090
din il-problema sett -

1671
01:18:52,090 --> 01:18:54,900
tippreżumi inti stajt taqra u poġġih
fi sforz bona fide -

1672
01:18:54,900 --> 01:18:57,920
tħossok liberu li email lili jew tikkuntattjani.

1673
01:18:57,920 --> 01:19:00,960
Jien aktar minn kuntenti li jaħdmu permezz
kodiċi tiegħek miegħek jew tirrispondi xi

1674
01:19:00,960 --> 01:19:02,330
mistoqsijiet li għandek.

1675
01:19:02,330 --> 01:19:06,160
>> Wieħed iżomm f'moħħu li, din il-ġimgħa, lott ta '
ħin tiegħek se jintefqu tagħlim tal-

1676
01:19:06,160 --> 01:19:10,730
sintassi ġdida u jippruvaw jifhmu
kif jiktbu mistoqsijiet SQL jew PHP

1677
01:19:10,730 --> 01:19:14,280
funzjonijiet jew jittrattaw
qafas MVC.

1678
01:19:14,280 --> 01:19:17,290
A ħafna ħin tiegħek din il-ġimgħa probabbilment
mhux se tkun qed tipprova figura l-

1679
01:19:17,290 --> 01:19:19,380
loġika crazy li aħna qed
inti titlob sabiex tagħmel.

1680
01:19:19,380 --> 01:19:23,820
A lott ta 'dan aħna biss marru fuq huwa
relattivament sempliċi.

1681
01:19:23,820 --> 01:19:25,790
>> Allura dan ma jfissirx li tistenna
sa l-aħħar minuta.

1682
01:19:25,790 --> 01:19:29,710
Iżda dan ma jfissirx jaġġustaw kif inti tagħmel tiegħek
jaħdmu kif xieraq, tagħmel żgur

1683
01:19:29,710 --> 01:19:30,970
int fehim u
tagħlim tal-sintassi.

1684
01:19:30,970 --> 01:19:33,640
Allura int mhux, kollha f'daqqa, li jafu
eżattament dak li inti trid tagħmel,

1685
01:19:33,640 --> 01:19:37,200
iżda bl-ebda idea kif
eżattament tiktibha.

1686
01:19:37,200 --> 01:19:38,450
OK, jien ser tara int ġimgħa d-dieħla.

1687
01:19:38,450 --> 01:19:40,438