1
00:00:00,000 --> 00:00:03,000
[Powered by Google Translate] [Walkthrough Tatizo Set 7]

2
00:00:03,000 --> 00:00:04,400
[Zamyla Chan] [Chuo Kikuu cha Harvard]

3
00:00:04,400 --> 00:00:07,640
[Hii ni CS50] [CS50.TV]

4
00:00:07,640 --> 00:00:12,090
>> Hello kila mtu, na kuwakaribisha kwa walkthrough 7, CS50 Fedha.

5
00:00:12,090 --> 00:00:15,090
Sasa sisi ni rasmi kufanyika na yote ya psets katika CS50,

6
00:00:15,090 --> 00:00:19,380
na sisi ni kushoto tu na moja zaidi ambayo ni kwenda kuwa utekelezaji furaha

7
00:00:19,380 --> 00:00:23,770
wa tovuti ambapo watumiaji wanaweza kuingia kwenye Fedha CS50

8
00:00:23,770 --> 00:00:25,830
na kununua na kuuza hisa.

9
00:00:25,830 --> 00:00:32,280
>> Leo, sisi tunaenda kuwa na zana chache tulizonazo.

10
00:00:32,280 --> 00:00:34,320
Sisi ni kwenda kuzungumza kuhusu ruhusa.

11
00:00:34,320 --> 00:00:36,380
Wakati wowote na folder mtandao,

12
00:00:36,380 --> 00:00:40,800
utaenda wanataka kuruhusu watumiaji kutekeleza files fulani

13
00:00:40,800 --> 00:00:42,500
lakini pia kusoma tu wale wengine,

14
00:00:42,500 --> 00:00:45,150
hivyo tutaweza kuangalia ndani ya ruhusa na jinsi gani unaweza kuweka wale.

15
00:00:45,150 --> 00:00:49,630
Kisha sisi ni kwenda kuangalia ndani ya PHP, HTML, na SQL code.

16
00:00:49,630 --> 00:00:51,990
>> Kwanza, permissions.

17
00:00:51,990 --> 00:00:56,060
Wakati uko katika terminal katika saraka fulani,

18
00:00:56,060 --> 00:01:00,430
basi nini unataka kufanya ni unataka kukimbia amri chmod.

19
00:01:00,430 --> 00:01:03,750
Hiyo ikifuatiwa na herufi au namba aidha

20
00:01:03,750 --> 00:01:08,100
sambamba na yale kimsingi wanataka kuona dunia,

21
00:01:08,100 --> 00:01:09,830
wewe mwenyewe ili kuona, nk

22
00:01:09,830 --> 00:01:13,350
Kwa mfano, wakati wowote una folder,

23
00:01:13,350 --> 00:01:15,560
kisha unataka folder kwamba kuwa executable na kwamba kila mtu anaona ni,

24
00:01:15,560 --> 00:01:19,500
hivyo nini ungependa kufanya ni wewe inaweza kuendesha chmod amri + x

25
00:01:19,500 --> 00:01:21,050
na kisha jina la folda.

26
00:01:21,050 --> 00:01:28,110
Wakati una faili kama vile files CSS au files picha -

27
00:01:28,110 --> 00:01:33,060
kama JPEGs na bitmaps, mambo kama hayo, au yoyote code JavaScript -

28
00:01:33,060 --> 00:01:36,440
unataka kuwa na someka na kila mtu,

29
00:01:36,440 --> 00:01:39,880
hivyo basi nini kufanya ni unaweza kutumia wildcard -

30
00:01:39,880 --> 00:01:41,650
ambayo ni kinyota -

31
00:01:41,650 --> 00:01:46,190
na kimsingi zinaonyesha katika folder CSS - kila kitu katika folder kwamba -

32
00:01:46,190 --> 00:01:48,740
 Mimi nina kwenda kusema kwamba itakuja kuwa someka kwa kila mtu.

33
00:01:48,740 --> 00:01:54,220
Na vibali, wakati sisi kutumia barua,

34
00:01:54,220 --> 00:01:57,610
tunaweza pia kutumia namba badala yake.

35
00:01:57,610 --> 00:02:00,900
Hivyo, unaweza kuona kwamba hatimaye wakati unataka kitu kuwa executable -

36
00:02:00,900 --> 00:02:02,810
hiyo ni kuwakilishwa na idadi 1 -

37
00:02:02,810 --> 00:02:08,340
kitu kuwa ni someka namba 4 na kisha -

38
00:02:08,340 --> 00:02:10,590
writable ni namba 2 -

39
00:02:10,590 --> 00:02:13,670
na hivyo kimsingi wakati unataka macho ya wale, basi kuwaongeza.

40
00:02:13,670 --> 00:02:15,860
Kama unataka kitu kuwa someka, writable, na executable,

41
00:02:15,860 --> 00:02:21,970
basi ingekuwa kuongeza hadi 4, 2, na 1 na kwamba bila kutoa 7,

42
00:02:21,970 --> 00:02:26,230
kisha wakati wowote una folder unataka kwamba kuwa executable na kila mtu -

43
00:02:26,230 --> 00:02:31,380
kama vile someka na writable - basi wewe kufanya 7, 1, 1.

44
00:02:31,380 --> 00:02:38,140
Hiyo itakuwa 7 kwa ajili yenu, basi 1 kwa watu wengine.

45
00:02:38,140 --> 00:02:42,870
Wakati una spec, itabidi kweli bayana folders ambayo na ambayo files

46
00:02:42,870 --> 00:02:45,040
haja ya kuwa chmod-ed hasa.

47
00:02:45,040 --> 00:02:47,920
Kwa mfano, wakati una folders - wale ni 7-1-1 -

48
00:02:47,920 --> 00:02:52,690
wakati una picha, au HTML, CSS, JavaScript,

49
00:02:52,690 --> 00:02:55,870
kisha wale wanaenda kuwa 6, 0, 4 - au 6, 4, 4 -

50
00:02:55,870 --> 00:03:00,030
na kisha files PHP ni kwenda kuwa 6, 0, 0.

51
00:03:00,030 --> 00:03:04,940
Dhana ya kwamba ni kwamba watumiaji lazima si kweli kuona yako PHP kificho,

52
00:03:04,940 --> 00:03:08,370
lakini tu kuwa na uwezo wa kuona pato.

53
00:03:08,370 --> 00:03:11,030
>> Mkuu! Kuhamia katika PHP.

54
00:03:11,030 --> 00:03:18,850
Tu, kila unataka faili PHP, suffix faili ni php..

55
00:03:18,850 --> 00:03:22,000
Unaweza pia kuchanganya HTML kwa PHP code.

56
00:03:22,000 --> 00:03:24,880
Kama una faili HTML, kwa mfano,

57
00:03:24,880 --> 00:03:32,520
basi unaweza enclose kwa angle kushoto, swali alama, php -

58
00:03:32,520 --> 00:03:39,320
kuweka code yako php - na kisha karibu kwamba pamoja na mwingine alama swali na angle haki.

59
00:03:39,320 --> 00:03:45,020
Vigezo katika PHP ni rahisi sana kuliko kushughulika na vigezo katika C.

60
00:03:45,020 --> 00:03:50,310
Variable yoyote tu ya kuanza kwa ishara ya dola mbele yake, na wao ni weakly typed.

61
00:03:50,310 --> 00:03:53,470
Hiyo ina maana kwamba huna haja ya kuwa na wasiwasi kuhusu kuweka kitu

62
00:03:53,470 --> 00:03:55,020
sawa na kamba au integer.

63
00:03:55,020 --> 00:03:57,710
Unaweza tu tu kusema, hii ni jina yangu ya kutofautiana

64
00:03:57,710 --> 00:04:00,390
na basi hii ni ya thamani yake,

65
00:04:00,390 --> 00:04:03,280
hivyo ni kwenda kuwa rahisi kukabiliana na pale.

66
00:04:03,280 --> 00:04:08,220
>> Kitu kingine ni kwamba PHP utapata kutumia arrays associative.

67
00:04:08,220 --> 00:04:11,330
Unaweza tu tu define safu kama wewe ungekuwa katika C

68
00:04:11,330 --> 00:04:14,900
kwa kusema, dola ishara-ya jina yako safu-sawa,

69
00:04:14,900 --> 00:04:22,600
na kisha katika mabano mraba kuwa kimsingi tu orodha ya maadili ya mambo yote katika safu.

70
00:04:22,600 --> 00:04:27,160
Lakini, katika PHP nini unaweza pia kufanya ni bayana kimsingi -

71
00:04:27,160 --> 00:04:31,050
ni aina ya kama kazi hash.

72
00:04:31,050 --> 00:04:34,410
Unaweza kutaja index - nini wewe kwenda kumwita -

73
00:04:34,410 --> 00:04:37,030
na kisha kwamba sambamba na thamani.

74
00:04:37,030 --> 00:04:42,880
Kama kweli kupita katika = 1, b = 2, c = 3,

75
00:04:42,880 --> 00:04:50,820
kisha safu yako katika index awajalieni 1.

76
00:04:50,820 --> 00:04:56,600
Pset Hii joto ninyi mahakamani na baadhi PHP katika sehemu ya maswali,

77
00:04:56,600 --> 00:04:59,240
na kisha sisi kupiga mbizi katika Fedha CS50.

78
00:04:59,240 --> 00:05:02,650
>> Sisi kuwa wanandoa wa - tuna baadhi ya utendaji, kimsingi,

79
00:05:02,650 --> 00:05:05,130
kutekeleza katika tovuti hii.

80
00:05:05,130 --> 00:05:10,440
Tunataka kuruhusu watumiaji kujiandikisha katika tovuti yetu kwa jina la mtumiaji na nywila.

81
00:05:10,440 --> 00:05:13,670
Tunataka kuruhusu kwao kwa kuangalia juu quote,

82
00:05:13,670 --> 00:05:19,330
na kisha tunataka magazeti nje jina la quote kwamba kama vile bei ya sasa ya kwamba ni saa.

83
00:05:19,330 --> 00:05:26,830
Tunataka kuruhusu yao kuona kwingineko ya yote ya hisa kwamba wana kununuliwa hivi sasa.

84
00:05:26,830 --> 00:05:34,240
Tunataka pia kuwaruhusu kununua hisa kama vile kuuza yao.

85
00:05:34,240 --> 00:05:37,540
Na kisha hatimaye, tunataka kuwaruhusu kuona historia

86
00:05:37,540 --> 00:05:39,490
wa wote wa mashirikiano kwamba wameweza alifanya.

87
00:05:39,490 --> 00:05:41,540
Kisha, hatimaye, baada ve kutekelezwa yote ya kwamba,

88
00:05:41,540 --> 00:05:45,110
basi wewe ni bure kutekeleza moja ya ziada kipengele.

89
00:05:45,110 --> 00:05:46,610
Tutaweza kwenda katika hizo.

90
00:05:46,610 --> 00:05:51,330
Wale inaweza kuwa ama kuruhusu watumiaji kupata fedha ya ziada kwa kuweka fedha ya ziada,

91
00:05:51,330 --> 00:05:54,550
au unaweza kuruhusu kwao kubadili password yao, au kitu kama hicho,

92
00:05:54,550 --> 00:06:00,590
email risiti wakati wao kununua au kuuza hisa.

93
00:06:00,590 --> 00:06:05,370
Kuna orodha mdogo wa makala kwamba unaweza kutekeleza mwenyewe,

94
00:06:05,370 --> 00:06:08,340
hivyo kwamba moja ya mwisho huko.

95
00:06:08,340 --> 00:06:13,430
>> Tangu hii ni tovuti, you guys pia kuwa na mengi ya uhuru wa Customize yake.

96
00:06:13,430 --> 00:06:20,960
Sisi kufanya kutoa baadhi code CSS, lakini wewe ni dhahiri bure tweak yake,

97
00:06:20,960 --> 00:06:26,680
kufanya ni kuangalia nicer, lakini msingi ni utendaji ya msingi

98
00:06:26,680 --> 00:06:30,310
hivyo daima rejea spec kuhusu nini hasa haja kwa pamoja huko.

99
00:06:30,310 --> 00:06:39,940
Kufuatia spec, sisi ni kwenda kuwa na kutumia appliance kama pia server.

100
00:06:39,940 --> 00:06:43,910
Ni kwenda kuwa mwenyeji wa tovuti yetu kwa ajili yetu, juu ya server yake ya ndani.

101
00:06:43,910 --> 00:06:49,750
Kama wewe kufuata maelekezo haya na unzip pset 7 usambazaji code

102
00:06:49,750 --> 00:06:53,500
ndani ya virtual yako jeshi / mitaa folder jeshi,

103
00:06:53,500 --> 00:07:02,470
 basi unaweza tu kutembelea http://localhost/ katika Google Chrome katika appliance,

104
00:07:02,470 --> 00:07:09,120
na basi ingekuwa kufikia code ambayo umefanya imeandikwa pset 7.

105
00:07:09,120 --> 00:07:14,490
>> Pset 7 kuja na rundo la code usambazaji,

106
00:07:14,490 --> 00:07:18,330
na hopefully we've - kwa njia zote za psets kabla ya hii -

107
00:07:18,330 --> 00:07:21,700
Wanahudhuria sisi kusoma kwa njia ya kificho usambazaji,

108
00:07:21,700 --> 00:07:25,650
kuelewa nini majukumu tayari zinazotolewa, na jinsi sisi inaweza kuwa na uwezo wa kutumia

109
00:07:25,650 --> 00:07:29,470
wale na kazi nyingine kwamba sisi ni kwenda kuwa utekelezaji.

110
00:07:29,470 --> 00:07:31,570
Katika kesi hiyo, tuna folders 3.

111
00:07:31,570 --> 00:07:36,350
Tuna folder HTML, pamoja na folder, na folder templates.

112
00:07:36,350 --> 00:07:40,630
Nini sisi ni kwenda kufanya na pset hii ni aina ya kutenganisha kufikiri -

113
00:07:40,630 --> 00:07:45,580
kufikiri programu - ya PHP code na kipengele halisi Visual.

114
00:07:45,580 --> 00:07:52,690
Tutaweza kuwa moja PHP faili kwamba anafanya yote ya kufikiri, anayesoma katika database,

115
00:07:52,690 --> 00:07:55,620
prints nje mambo, ina kama kauli - mambo kama hayo -

116
00:07:55,620 --> 00:08:02,140
na kisha kuwa itabidi kupita data katika faili template yetu - au faili template.php.

117
00:08:02,140 --> 00:08:05,710
Nini kwamba kufanya ni kusoma data na basi itakuwa magazeti nje.

118
00:08:05,710 --> 00:08:09,550
>> Tunaweza kutibu templates kama "bubu" kwa kuwa sisi si kweli unataka yao

119
00:08:09,550 --> 00:08:12,370
kuwa kufanya kazi nyingi katika kuhesabu mambo.

120
00:08:12,370 --> 00:08:16,330
Tunataka controllers wetu kufanya hivyo.

121
00:08:16,330 --> 00:08:21,610
kidogo juu ya hilo - hebu tuangalie baadhi ya maadili ya usambazaji.

122
00:08:21,610 --> 00:08:28,250
Hapa tuna faili wetu index.html, na ni pretty tupu.

123
00:08:28,250 --> 00:08:34,429
Kimsingi kile yake - anasema, vizuri, nina kwenda zinahitaji faili configuration.php.

124
00:08:34,429 --> 00:08:40,120
Hatuoni kwamba haki pale, lakini kimsingi ni wito faili configuration.php,

125
00:08:40,120 --> 00:08:42,240
na utekelezaji huo.

126
00:08:42,240 --> 00:08:45,130
Baada ni gani kwamba, ni kwenda kutoa kwingineko.

127
00:08:45,130 --> 00:08:49,310
Utoaji ni kazi, hivyo wakati tuko katika mtawala,

128
00:08:49,310 --> 00:08:56,490
Tutamwita asimlipe, tutaweza kuwapa faili na kisha data kwamba sisi ni kupita katika,

129
00:08:56,490 --> 00:09:04,570
hivyo kwamba nitakuita katika portfolio.php aina-ya kupita katika taarifa hizo ili kwamba kwingineko ambayo inaweza kukabiliana na kwamba.

130
00:09:04,570 --> 00:09:10,540
>> Na sasa, hapa, tuna aina yetu login.php.

131
00:09:10,540 --> 00:09:17,540
 Hii ni mtawala kwamba kimsingi inachukua huduma ya magogo in

132
00:09:17,540 --> 00:09:29,090
Hapa, ni hundi ikiwa fomu lade kwa faili hii na mikataba na validering kuwasilisha.

133
00:09:29,090 --> 00:09:31,990
Tutaweza kuangalia katika kazi hii kuomba msamaha.

134
00:09:31,990 --> 00:09:35,100
Wakati tunataka kuchapa nje ujumbe wa kosa,

135
00:09:35,100 --> 00:09:39,550
sisi kutumia msamaha na kwamba itakuwa redirect mtumiaji ukurasa maalum

136
00:09:39,550 --> 00:09:42,530
ambayo magazeti nje maalum makosa ujumbe kwamba sisi zinaonyesha.

137
00:09:42,530 --> 00:09:47,860
Kuendelea juu, itakuwa swala database - we'll kupata ndani zaidi ya baadaye.

138
00:09:47,860 --> 00:09:54,180
Kisha, unaweza kuona kwamba chini hapa ikiwa fomu hakuwa in, basi ni mithili ya fomu.

139
00:09:54,180 --> 00:10:01,360
Hiyo ina maana kwamba huenda kwa login_form.php, hivyo hebu angalia hiyo.

140
00:10:01,360 --> 00:10:09,400
>> Login.php ni kweli ambapo tunaona kushughulika HTML na kipengele halisi Visual.

141
00:10:09,400 --> 00:10:15,130
Hapa tuna tag pembejeo kwa jina la mtumiaji, pembejeo kwa password,

142
00:10:15,130 --> 00:10:16,630
kama vile kifungo kuwasilisha.

143
00:10:16,630 --> 00:10:22,660
Hiyo ni kweli ambapo nyanja Visual na HTML fomu ni kwenda kuwa uliofanyika.

144
00:10:22,660 --> 00:10:27,550
Hapa, inasema kwamba ni kwenda kuwasilishwa kwa njia fulani, kuitwa post.

145
00:10:27,550 --> 00:10:30,190
Tutaweza kupata katika tofauti kati ya mbinu -

146
00:10:30,190 --> 00:10:33,240
post dhidi kupata, pia kuna kitu kinachoitwa kuweka -

147
00:10:33,240 --> 00:10:36,160
tutaweza kupata katika njia hizo za baadaye, lakini kwa maslahi ya pset hii,

148
00:10:36,160 --> 00:10:37,810
Napenda sana moyo kutumia post.

149
00:10:37,810 --> 00:10:42,210
>> Tunajua kwamba kimsingi mara moja fomu hii ni in -

150
00:10:42,210 --> 00:10:44,650
kutoka login_form.php--

151
00:10:44,650 --> 00:10:50,850
basi itakuwa kwenda action - login.php--

152
00:10:50,850 --> 00:10:56,070
kimsingi kupita katika wale vigezo vyote kutoka fomu hizo katika login.php.

153
00:10:56,070 --> 00:11:04,900
matokeo kutoka fomu kuwa ni zilizomo ndani ya safu hii post associative.

154
00:11:04,900 --> 00:11:11,710
bahati ya mambo mbalimbali katika safu post

155
00:11:11,710 --> 00:11:15,290
ni nini hasa bayana hapa.

156
00:11:15,290 --> 00:11:19,240
Unaweza kusema kwamba jina la pembejeo hii ni jina la mtumiaji. jina la moja hii ni siri.

157
00:11:19,240 --> 00:11:26,840
Vilevile, unaweza kuona jina la mtumiaji kama index ya safu associative huko.

158
00:11:26,840 --> 00:11:35,110
Kama sisi kwenda kwa folda pamoja, tuna faili hii kazi ambayo ni kwenda kuwa muhimu sana.

159
00:11:35,110 --> 00:11:37,570
>> Kwa haya yote ni kutekelezwa kwa ajili yenu.

160
00:11:37,570 --> 00:11:41,870
Huna haja ya kutekeleza hasa yoyote ya hizi wewe mwenyewe,

161
00:11:41,870 --> 00:11:43,140
lakini wao wanaenda muhimu kabisa.

162
00:11:43,140 --> 00:11:49,450
Tuna msamaha, ambayo kama nilivyosema hapo kabla, itakuwa kimsingi magazeti nje ujumbe wa makosa

163
00:11:49,450 --> 00:11:52,920
kwa wewe juu ya ukurasa maalum - apology.php.

164
00:11:52,920 --> 00:11:59,890
Kisha sisi kuwa dampo, hivyo kama wewe piga tu dampo na kisha kupita katika variable,

165
00:11:59,890 --> 00:12:04,930
kisha itakuwa kuleta kwa ukurasa kuonyesha kwamba kutofautiana kwa ajili yenu.

166
00:12:04,930 --> 00:12:09,950
Kisha sisi logout, ambayo kimsingi mwisho kikao mtumiaji fulani ya.

167
00:12:09,950 --> 00:12:12,240
Luke ni kwenda kuwa na manufaa.

168
00:12:12,240 --> 00:12:15,870
Tangu sisi ni kushughulika na quotes na hifadhi, tunakwenda na kuwa na uwezo -

169
00:12:15,870 --> 00:12:17,650
na ni kimsingi muda halisi.

170
00:12:17,650 --> 00:12:21,380
Tunahitaji kujua nini maadili hisa hizo ni,

171
00:12:21,380 --> 00:12:28,210
hivyo tuna kazi lookup ambayo inahusika na nyaraka Yahoo wa hifadhi.

172
00:12:28,210 --> 00:12:37,700
Mara baada ya kuangalia juu ishara fulani ya hisa, itakuwa kurejea wewe ishara hisa

173
00:12:37,700 --> 00:12:41,480
kama vile jina na bei ya sasa ya hisa kwamba.

174
00:12:41,480 --> 00:12:44,330
Hiyo ni kazi Luke.

175
00:12:44,330 --> 00:12:48,350
>> Kisha sisi ni kushughulika na MySQL,

176
00:12:48,350 --> 00:12:53,970
hivyo sisi ni kwenda kuwa kutaka kutekeleza maswali fulani katika database yetu SQL.

177
00:12:53,970 --> 00:12:58,890
Tuna hoja ya kukabiliana - kwa baadhi ya aina ya kufikirika ya nje kwamba.

178
00:12:58,890 --> 00:13:03,200
Sisi wanaenda kupita katika string nzima ya swala zetu SQL -

179
00:13:03,200 --> 00:13:05,360
na wote wa vigezo kwamba kwenda katika hilo -

180
00:13:05,360 --> 00:13:09,480
na nini hii haina ni kweli kwamba nitafanya kwa ajili yetu.

181
00:13:09,480 --> 00:13:15,070
Badala ya kuwa na kuandika haya yote nje kila wakati kwamba unataka query -

182
00:13:15,070 --> 00:13:21,740
na kupata yote ya matokeo kutoka swala kwamba -

183
00:13:21,740 --> 00:13:24,740
basi unaweza kuwaita tu kazi swala, na hivyo itabidi kurudi wewe -

184
00:13:24,740 --> 00:13:28,750
kutegemea juu ya nini wewe kutumia kwa ajili ya swala yako -

185
00:13:28,750 --> 00:13:33,000
pengine mstari wa wote wa matokeo wanaofanana swala au sawa.

186
00:13:33,000 --> 00:13:34,690
Zaidi juu ya kwamba baadaye ingawa.

187
00:13:34,690 --> 00:13:41,200
>> Hatimaye, tuna redirect ambayo kama jina linavyosema, redirects wewe ukurasa tofauti.

188
00:13:41,200 --> 00:13:46,280
Na kisha tuna asimlipe, ambayo sisi mtaenda wito michache ya nyakati.

189
00:13:46,280 --> 00:13:51,010
Wakati uko katika mtawala, wewe piga atatoa katika ukurasa template

190
00:13:51,010 --> 00:13:55,390
na kisha kupita katika maadili ambayo template atashughulika na.

191
00:13:55,390 --> 00:13:59,540
Wale maadili ni pengine kwenda kushughulika na aina ya pato kwamba unataka

192
00:13:59,540 --> 00:14:01,050
kuonyeshwa kwenye template ukurasa wako.

193
00:14:01,050 --> 00:14:09,370
Sawa. Wale ni kazi, na kuna mengi zaidi kwa code hii usambazaji.

194
00:14:09,370 --> 00:14:12,930
Mimi moyo kwenda kwa njia hii na kuchunguza ni wewe mwenyewe.

195
00:14:12,930 --> 00:14:17,050
Pia, spec pengine kutembea wewe kupitia baadhi ya vipengele nyingine ya code usambazaji.

196
00:14:17,050 --> 00:14:27,360
Hapa ni muhtasari wa kazi hupatikana katika functions.php.

197
00:14:27,360 --> 00:14:31,710
>> Sawa. Kazi ya kwanza ni kuruhusu watumiaji kwa kujiandikisha katika tovuti.

198
00:14:31,710 --> 00:14:34,860
Hivi sasa, kuna aina login katika tovuti,

199
00:14:34,860 --> 00:14:40,080
na wewe ni zinazotolewa na watumiaji wachache pamoja na nywila.

200
00:14:40,080 --> 00:14:42,130
Unaweza kutumia majina ya watumiaji na wale logi katika,

201
00:14:42,130 --> 00:14:45,140
lakini unataka kuruhusu watu kufanya wao wenyewe usernames

202
00:14:45,140 --> 00:14:47,390
na kuongeza wenyewe na tovuti.

203
00:14:47,390 --> 00:14:53,070
layout kwa ajili ya usajili ni pretty sawa kwa ajili ya kuingia,

204
00:14:53,070 --> 00:14:56,340
ila jina la mtumiaji si ya awali iliyopo,

205
00:14:56,340 --> 00:14:59,430
na mtumiaji pia mahitaji ya kutoa siri mpya,

206
00:14:59,430 --> 00:15:02,440
na kisha kawaida tuna uthibitisho password.

207
00:15:02,440 --> 00:15:06,580
Mara pembejeo zote za watumiaji wa habari kwamba,

208
00:15:06,580 --> 00:15:10,620
tunataka kuongeza yao database yetu ya watumiaji.

209
00:15:10,620 --> 00:15:12,970
Sisi ni kwenda kuwa na database - database SQL -

210
00:15:12,970 --> 00:15:14,470
kwamba sisi ni kwenda kwa rejea.

211
00:15:14,470 --> 00:15:18,140
Katika orodha hiyo, tutaweza kuwa na meza na yote ya watumiaji

212
00:15:18,140 --> 00:15:23,850
zenye jina la mtumiaji yao, password zao, na pia jinsi fedha kiasi walichonacho.

213
00:15:23,850 --> 00:15:28,480
>> Katika daftari, tunataka kuwaruhusu kuingia kwamba taarifa.

214
00:15:28,480 --> 00:15:29,740
Tunataka kuonyesha kwamba fomu.

215
00:15:29,740 --> 00:15:32,210
Tunataka kuhakikisha kuwa password yao -

216
00:15:32,210 --> 00:15:37,490
kwamba waliingia moja, na kisha pia kwamba nywila mechi wanapoingia ni mara mbili.

217
00:15:37,490 --> 00:15:42,240
Baada ya yote ya kwamba ni kufanyika - kuchukua kwamba makosa hayo ni checked -

218
00:15:42,240 --> 00:15:45,120
kisha tunataka kuongeza watumiaji hao kwa database yetu.

219
00:15:45,120 --> 00:15:49,630
Hatimaye, mara moja umefanya kusajiliwa, ni pretty rahisi kama huna haja ya kuingia tena

220
00:15:49,630 --> 00:15:51,000
mara moja umefanya kusajiliwa,

221
00:15:51,000 --> 00:15:54,000
hivyo sisi ni kwenda kuingia kwao katika tovuti kama wameweza amesajiliwa katika mafanikio.

222
00:15:54,000 --> 00:16:00,360
>> Kazi ya kwanza ni kuonyesha fomu, na hii ni kweli kwenda kuwa -

223
00:16:00,360 --> 00:16:04,920
huu wote mchakato wa usajili ni kwenda kuwa inatokana pretty karibu baada ya kuingia

224
00:16:04,920 --> 00:16:10,510
isipokuwa badala ya login.php unaweza kuwa register.php.

225
00:16:10,510 --> 00:16:14,300
Badala ya login_form.php-ambayo ni template -

226
00:16:14,300 --> 00:16:16,030
utasikia kuwa kujiandikisha fomu.

227
00:16:16,030 --> 00:16:19,680
Utasikia wanataka kuongeza moja zaidi shamba - uthibitisho password shamba -

228
00:16:19,680 --> 00:16:23,450
badala ya jina la mtumiaji moja na nenosiri moja.

229
00:16:23,450 --> 00:16:28,120
Next, tunataka kuangalia kama nywila mechi au ni tupu.

230
00:16:28,120 --> 00:16:38,560
Tuna mtawala - register.php-ambayo ni kwenda kuchukua huduma ya kufanya hundi hizo.

231
00:16:38,560 --> 00:16:41,690
Wakati fomu ni kuwasilishwa kupitia njia ya posta,

232
00:16:41,690 --> 00:16:47,050
basi wote wa vigezo wale zilizomo ndani ya safu ya posta.

233
00:16:47,050 --> 00:16:52,280
Wewe unataka kuhakikisha kwamba baada ya safu thamani katika password index

234
00:16:52,280 --> 00:16:58,080
mechi ya kipengele uthibitisho.

235
00:16:58,080 --> 00:16:59,410
Wewe unataka kuhakikisha kwamba wao si tupu,

236
00:16:59,410 --> 00:17:01,650
na wewe unataka kuhakikisha kwamba wao ni sawa.

237
00:17:01,650 --> 00:17:05,960
>> Moja rahisi kitu kuhusu PHP ni kwamba hatuna haja ya kutumia kamba kulinganisha tena.

238
00:17:05,960 --> 00:17:08,410
Tunaweza kutumia operator sawa-sawa

239
00:17:08,410 --> 00:17:11,470
 kuangalia kama masharti ni sawa na mtu mwingine.

240
00:17:11,470 --> 00:17:14,960
Kwa utunzaji makosa, utasikia wanataka radhi.

241
00:17:14,960 --> 00:17:17,150
Kuomba radhi, wewe tu piga kazi

242
00:17:17,150 --> 00:17:21,910
 na kisha kutaja aina ya ujumbe kwamba unataka pato.

243
00:17:21,910 --> 00:17:24,630
Wewe kisha unataka kuongeza mtumiaji database.

244
00:17:24,630 --> 00:17:30,880
Hadi sasa, kila tumekuwa kufanya ni kushughulika tu ndani ya nchi na matokeo ya fomu.

245
00:17:30,880 --> 00:17:33,940
Sasa, sisi kweli unataka kuongeza yao database yetu.

246
00:17:33,940 --> 00:17:38,890
Kwa hili, sisi kwanza unataka kuhakikisha kwamba username si tupu.

247
00:17:38,890 --> 00:17:44,550
Kuelewa kwamba katika tovuti, huwezi kuwa na watumiaji mbalimbali kwa jina la mtumiaji sawa,

248
00:17:44,550 --> 00:17:50,010
hivyo utasikia wanataka kuhakikisha kwamba wakati wewe Insert kitu katika orodha yako -

249
00:17:50,010 --> 00:17:56,650
Insert mtumiaji mpya - basi huwezi kupata mgongano kati ya jina la mtumiaji kabla zilizopo

250
00:17:56,650 --> 00:17:59,150
na jina la mtumiaji kwamba mtumiaji ni kujaribu kuwasilisha.

251
00:17:59,150 --> 00:18:02,250
Kwa hili, mara moja wewe nitafanya query -

252
00:18:02,250 --> 00:18:08,760
inserting mtumiaji fulani na password yao na kiasi awali ya fedha -

253
00:18:08,760 --> 00:18:15,140
mara moja wito kwamba swala, kisha MySQL mapenzi kweli kurudi uongo iwapo itashindwa.

254
00:18:15,140 --> 00:18:21,050
>> muundo wa watumiaji ni vile kwamba jina la mtumiaji ni thamani ya kipekee,

255
00:18:21,050 --> 00:18:22,540
hivyo huwezi kuwa na zaidi ya moja.

256
00:18:22,540 --> 00:18:30,080
Unapojaribu na Insert mstari mpya yenye jina la mtumiaji kwamba tayari ipo,

257
00:18:30,080 --> 00:18:34,470
ambayo inaenda kurudi uongo - kama uongo Boolean-thamani.

258
00:18:34,470 --> 00:18:45,320
Jambo gumu hapa ni kwamba utasikia wanataka kuangalia kama matokeo ni matokeo ya hoja yako.

259
00:18:45,320 --> 00:18:52,320
Kama inashindwa, basi utasikia wanataka kuangalia na operator mara tatu-sawa.

260
00:18:52,320 --> 00:18:55,420
Hiyo kweli kwenda kuangalia kama kuna ni kushindwa au la,

261
00:18:55,420 --> 00:19:02,760
ambapo, katika rahisi tu sawa sawa-, itakuwa kweli kama mstari ilikuwa tupu.

262
00:19:02,760 --> 00:19:06,000
matokeo ya kushindwa kama kuna mgongano kati ya majina ya watumiaji

263
00:19:06,000 --> 00:19:10,350
ni halisi uongo thamani.

264
00:19:10,350 --> 00:19:15,230
>> Hapa ni jinsi gani Insert katika database.

265
00:19:15,230 --> 00:19:19,220
Hapa ni swala ambalo ungependa kukimbia madhubuti katika SQL.

266
00:19:19,220 --> 00:19:25,750
Jambo moja ni kwamba unaweza kweli kwenda kwenye tovuti yako kwamba itaweza database SQL

267
00:19:25,750 --> 00:19:31,070
na kucheza kote huko kwa kuingia manually maadili ama au safu.

268
00:19:31,070 --> 00:19:34,540
Itakuwa pato nini pato SQL ni.

269
00:19:34,540 --> 00:19:38,870
Unaweza pia kuendesha amri SQL ndani ya hifadhidata yako

270
00:19:38,870 --> 00:19:42,200
 na kisha kuona nini syntax ili kuwa,

271
00:19:42,200 --> 00:19:46,790
na kisha kutafsiri kwamba katika kazi swala kwamba sisi katika pset 7,

272
00:19:46,790 --> 00:19:51,120
ambayo ni kwenda kuwa ni sawa na maswali kwamba kweli kukimbia.

273
00:19:51,120 --> 00:19:54,570
>> Kama nilitaka Insert mstari mpya katika meza yangu watumiaji,

274
00:19:54,570 --> 00:20:01,240
basi napenda kutaja Insert ndani ya watumiaji, ambayo ni jina la meza yangu.

275
00:20:01,240 --> 00:20:06,870
Kisha napenda kutaja majina ya safu.

276
00:20:06,870 --> 00:20:13,230
Kisha napenda kutoa maadili pamoja na password yangu.

277
00:20:13,230 --> 00:20:17,080
Nywila katika meza yetu watumiaji si kuhifadhiwa kama kamba tu.

278
00:20:17,080 --> 00:20:19,440
Wao ni kuhifadhiwa kama toleo encrypted,

279
00:20:19,440 --> 00:20:24,560
hivyo utasikia wanataka kuendesha crypt kazi juu ya password halisi,

280
00:20:24,560 --> 00:20:29,680
na kwamba nitakupa aina sahihi ya kuhifadhi kwa ajili ya safu watumiaji.

281
00:20:29,680 --> 00:20:34,960
Mbio hii Insert mstari mpya katika meza yako watumiaji.

282
00:20:34,960 --> 00:20:39,020
>> Ili kukabiliana na kazi swala,

283
00:20:39,020 --> 00:20:43,100
kabla katika C sisi kutumika ishara asilimia kama placeholder.

284
00:20:43,100 --> 00:20:47,670
Vilevile, dhana hiyo ya placeholder inatumika hapa.

285
00:20:47,670 --> 00:20:50,720
Pamoja na swala, wewe taja swala zima,

286
00:20:50,720 --> 00:20:55,510
ila wakati wowote wewe ni kushughulika na vigezo kama mchango wako ndani ya swala,

287
00:20:55,510 --> 00:21:00,490
basi badala ya kweli kuweka ndani - kama wakati tulikuwa na kauli printf katika C.

288
00:21:00,490 --> 00:21:03,740
Tunataka kuweka kamba na kisha kuwa placeholder huko, na kisha baada ya kila

289
00:21:03,740 --> 00:21:06,990
comma, bayana ambayo variable tulikuwa.

290
00:21:06,990 --> 00:21:14,480
Hapa, sisi ni kwenda kutumia alama swali ishara kama placeholder wetu

291
00:21:14,480 --> 00:21:21,670
na kisha kupita katika variable kila, kwa mtiririko huo ili, kwa placeholders -

292
00:21:21,670 --> 00:21:24,420
ambapo wale vigezo anatakiwa kwenda.

293
00:21:24,420 --> 00:21:29,470
Hivyo hapa, kwanza swali alama itakuwa kubadilishwa na jina la mtumiaji halisi

294
00:21:29,470 --> 00:21:33,610
kisha pili swali alama na password.

295
00:21:33,610 --> 00:21:37,000
>> Kisha hatimaye, mara moja umefanya kusajiliwa kwao na aliongeza yao kwa database,

296
00:21:37,000 --> 00:21:40,510
kisha unataka kuingia kwao katika tovuti.

297
00:21:40,510 --> 00:21:45,320
Tuna aina ya kikao super-kimataifa variable kuitwa.

298
00:21:45,320 --> 00:21:48,160
Kikao inachukua id fulani,

299
00:21:48,160 --> 00:21:51,750
na id kwamba sambamba na user hiyo sasa logged in

300
00:21:51,750 --> 00:21:56,380
Nini utasikia wanataka kufanya ni kupata kile mtumiaji yao id ni

301
00:21:56,380 --> 00:22:03,710
na kisha kuweka kwamba id kikao kama id kwamba mtumiaji fulani.

302
00:22:03,710 --> 00:22:07,560
kazi kwamba utasikia wanataka kutumia hapa ni amri SQL

303
00:22:07,560 --> 00:22:15,150
ambayo retrieve mwisho kuingizwa id idadi kutoka meza yako.

304
00:22:15,150 --> 00:22:24,560
Kisha safu nitakuita - it'll kuwaita id - it'll hawawajui jina kwa idadi hiyo kuirudisha.

305
00:22:24,560 --> 00:22:27,900
Ni nitakuita kwamba id.

306
00:22:27,900 --> 00:22:33,370
Sasa tumekuwa kumaliza kujiandikisha, na tunaweza kuendelea kunukuu.

307
00:22:33,370 --> 00:22:36,610
>> Quote inaruhusu mtumiaji pembejeo jina la hisa fulani,

308
00:22:36,610 --> 00:22:41,940
na kisha utakuwa kurudi sifa ya hisa kwamba.

309
00:22:41,940 --> 00:22:48,410
Nini utasikia wanataka kufanya hapa ni kuwa mtawala na templates baadhi.

310
00:22:48,410 --> 00:22:53,380
Katika kesi hiyo, sisi itawabidi mtawala ambayo ni kwenda kufanya yote ya kufikiri kwa ajili yetu.

311
00:22:53,380 --> 00:23:01,210
Ni kwenda kuangalia juu ishara na kisha kupita katika maadili kwa templates ambayo magazeti nje.

312
00:23:01,210 --> 00:23:03,060
Sisi itawabidi templates 2 hapa.

313
00:23:03,060 --> 00:23:07,260
Sisi itawabidi 1 template ambayo hutoa aina ambayo watumiaji ni kwenda

314
00:23:07,260 --> 00:23:09,920
pembejeo jina la hisa - jina la hisa.

315
00:23:09,920 --> 00:23:16,030
Kisha sisi ni pia atataka mwingine template kwamba maonyesho maadili hayo.

316
00:23:16,030 --> 00:23:27,450
Unaweza kuangalia ndani ya kuingia kwa ajili ya mfano wa jinsi ungependa kuwa fomu kuwa anapokea pembejeo,

317
00:23:27,450 --> 00:23:30,060
isipokuwa katika hapa, sisi tu wanataka 1 shamba.

318
00:23:30,060 --> 00:23:31,630
Hatutaki username na password shamba.

319
00:23:31,630 --> 00:23:37,110
Sisi tu wanataka 1 Nakala shamba ambayo inaruhusu user pembejeo jina la hisa fulani.

320
00:23:37,110 --> 00:23:40,110
Kisha unataka kutuma data kwamba - mara moja kuwa akatazama kwamba hisa -

321
00:23:40,110 --> 00:23:45,550
kwa quote_form.php.

322
00:23:45,550 --> 00:23:50,780
Luke atarudi ishara ya hisa, jina, na bei.

323
00:23:50,780 --> 00:23:53,910
Wale ni zilizomo ndani ya safu associative.

324
00:23:53,910 --> 00:24:01,390
Angalia kazi lookup ndani functions.php kwa habari zaidi

325
00:24:01,390 --> 00:24:04,010
juu ya aina ya kurudi kwa wale.

326
00:24:04,010 --> 00:24:08,520
>> Mkuu! Hivyo basi hatimaye, utasikia wanataka kuonyesha taarifa hisa.

327
00:24:08,520 --> 00:24:14,110
Utasikia wanataka pengine kuonyesha - you'll wanataka kupata vigezo wale.

328
00:24:14,110 --> 00:24:17,610
Mara baada ya kuwa bei katika variable -

329
00:24:17,610 --> 00:24:20,860
kama vile jina na alama -

330
00:24:20,860 --> 00:24:25,550
basi utasikia wanataka kuonyesha wale katika template ukurasa wako.

331
00:24:25,550 --> 00:24:31,540
Ukurasa kwamba template inaweza kuitwa show_quote.php au kitu.

332
00:24:31,540 --> 00:24:39,660
Quote.php yako ukurasa ingekuwa atatoa show quote na kisha kupita katika yote ya maadili hayo.

333
00:24:39,660 --> 00:24:47,170
Kisha katika ukurasa wako php, wewe kweli magazeti nje maadili hayo kwa kipengele HTML ya ukurasa.

334
00:24:47,170 --> 00:24:53,800
Wewe tu kutumia kazi magazeti na kupita katika bei.

335
00:24:53,800 --> 00:24:57,990
Kuna njia 2 - unaweza ama concatenate kwa operator dot,

336
00:24:57,990 --> 00:25:02,230
au kutumia placeholder.

337
00:25:07,580 --> 00:25:12,750
>> watumiaji hatimaye itakuwa ni kununua na kuuza hisa.

338
00:25:12,750 --> 00:25:18,450
Tunataka kuruhusu yao baadhi ya njia ya kuona yote ya hifadhi ya kwamba sasa kuwa.

339
00:25:18,450 --> 00:25:21,350
Sisi ni kwenda kuwaita kwamba kwingineko yao.

340
00:25:21,350 --> 00:25:26,180
Kwingineko itakuwa, labda kwa mtumiaji kila, vyenye rundo la safu

341
00:25:26,180 --> 00:25:31,760
kuorodhesha aina ya hisa ya kwamba wana na kisha jinsi wengi wa wale wana.

342
00:25:31,760 --> 00:25:36,500
Meza yetu zilizopo - sasa hivi tuna meza watumiaji katika database yetu.

343
00:25:36,500 --> 00:25:41,780
Hiyo ina jina la mtumiaji mtumiaji nywila vilevile yao na kiasi gani cha pesa walichonacho.

344
00:25:41,780 --> 00:25:50,390
Hakuna njia ya halisi ya hifadhi yote ya hifadhi yao ndani ya kwamba.

345
00:25:50,390 --> 00:25:58,010
Siyo kama tunaweza kuingiza nguzo mpya kwa ajili ya hisa zote.

346
00:25:58,010 --> 00:26:03,650
Hiyo itakuwa mstari sana, mrefu sana kwa sababu tuna kiasi usio

347
00:26:03,650 --> 00:26:06,200
ya aina ya hifadhi ya kwamba wanaweza kuwa.

348
00:26:06,200 --> 00:26:09,150
Hivyo, badala yale tutaweza kufanya ni ndani ya database huo,

349
00:26:09,150 --> 00:26:15,000
tutaweza kuwa na meza watumiaji, lakini basi tutaweza pia kuwa meza kwingineko.

350
00:26:15,000 --> 00:26:18,430
meza kwingineko itakuwa dhahiri wanaohusishwa na meza watumiaji,

351
00:26:18,430 --> 00:26:24,600
lakini badala meza kwingineko muundo itakuwa na habari hisa,

352
00:26:24,600 --> 00:26:27,780
hisa ngapi ya kwamba hisa mtumiaji ana,

353
00:26:27,780 --> 00:26:31,620
kama vile ya mtumiaji fulani id idadi.

354
00:26:31,620 --> 00:26:34,620
Una meza ambayo ina watumiaji id kama vile jina la mtumiaji, hash -

355
00:26:34,620 --> 00:26:40,130
ambayo ni password, password encrypted -

356
00:26:40,130 --> 00:26:42,130
na kisha kiasi cha fedha wana.

357
00:26:42,130 --> 00:26:47,900
idadi id itakuwa wanaohusishwa na idadi id kutoka kwingineko.

358
00:26:47,900 --> 00:26:52,490
kwingineko ingekuwa tu kuwa ishara ya hisa kama vile hisa -

359
00:26:52,490 --> 00:26:55,410
idadi ya hisa ya kwamba hisa kwamba mtumiaji ana.

360
00:26:55,410 --> 00:26:58,520
Katika meza hiyo kwingineko ungependa kuwa kimsingi

361
00:26:58,520 --> 00:27:03,760
wote hisa amepagawa na yote ya watumiaji kwenye tovuti yako.

362
00:27:03,760 --> 00:27:10,550
Baadaye, kwa kutaja tu hisa mtumiaji fulani wa - tu portfolio yao -

363
00:27:10,550 --> 00:27:15,360
ungependa retrieve maadili ya kutoka meza kwingineko yako ambayo vile

364
00:27:15,360 --> 00:27:19,930
idadi id ni maalum kwa mtumiaji huyo.

365
00:27:26,520 --> 00:27:34,890
>> Wakati wewe kuonyesha kwingineko, utasikia wanataka kuripoti kila hisa katika kwingineko mtumiaji.

366
00:27:34,890 --> 00:27:41,670
Utasikia wanataka ripoti ya idadi ya hisa na thamani ya sasa ya hisa hizo.

367
00:27:41,670 --> 00:27:45,950
Thamani ya hisa kwamba sasa wale si kuhifadhiwa katika meza kwingineko

368
00:27:45,950 --> 00:27:51,640
kwa sababu hiyo ni kwenda kuwa uppdatering - katika kima cha chini - kila siku na Yahoo.

369
00:27:51,640 --> 00:27:58,550
Ili kupata taarifa kwamba, huwezi rejea kwamba kutoka hoja yako SQL.

370
00:27:58,550 --> 00:28:02,400
Nini kazi hutoa kwamba sisi? Nini kazi kupata bei?

371
00:28:02,400 --> 00:28:09,110
Hiyo lookup, hivyo kwa kutumia alama ya lookup fulani nitakupa mengi ya habari.

372
00:28:09,110 --> 00:28:13,710
Ni nitakupa vipande 3 wa habari - jina, alama, kama vile bei.

373
00:28:13,710 --> 00:28:17,490
Mara baada ya Luke ishara fulani, basi unaweza kupata bei,

374
00:28:17,490 --> 00:28:20,460
na basi unaweza kutumia bei kuonyeshwa katika kwingineko yako.

375
00:28:20,460 --> 00:28:26,190
>> kwingineko lazima pia kuonyesha mtumiaji wa sasa wa fedha mizani.

376
00:28:26,190 --> 00:28:30,310
Shamba hilo ni kuhifadhiwa ndani ya meza yako watumiaji.

377
00:28:30,310 --> 00:28:33,400
Hivyo basi wakikumbuka jinsi sisi ni kimsingi ya kuwa na -

378
00:28:33,400 --> 00:28:36,850
sisi ni kuwa aina tofauti ya files PHP.

379
00:28:36,850 --> 00:28:40,160
Sisi itawabidi mtawala ambayo kimsingi haina kufikiri yote kwa ajili yenu.

380
00:28:40,160 --> 00:28:45,940
Na kisha tuna template ambayo template mikataba na data outputting.

381
00:28:45,940 --> 00:28:50,790
Una kufikiria nini vigezo mtawala haja ya kuchukua in

382
00:28:50,790 --> 00:29:01,630
Kama sisi ni kushughulika na kwingineko ambayo matokeo ya kila jina, alama, na idadi ya hisa,

383
00:29:01,630 --> 00:29:03,730
kama vile bei ya sasa ya hisa,

384
00:29:03,730 --> 00:29:06,950
basi utasikia wanataka kupata baadhi ya njia ya kimsingi ya kupita katika -

385
00:29:06,950 --> 00:29:12,070
unaweza kupita katika safu ya maadili wanaofanana kwamba.

386
00:29:15,250 --> 00:29:24,360
>> Hebu kwenda katika mfano wa jinsi unaweza retrieve yote ya hifadhi ya

387
00:29:24,360 --> 00:29:26,210
inayomilikiwa na mtumiaji fulani.

388
00:29:26,210 --> 00:29:31,400
Hii si kushughulika - bado - kwa bei ya hisa.

389
00:29:31,400 --> 00:29:33,520
Nini hii itakuwa kufanya ni kukimbia swala.

390
00:29:33,520 --> 00:29:37,070
Ingekuwa kupata alama kama vile hisa kutoka -

391
00:29:37,070 --> 00:29:42,770
Mimi nina wito huu meza, lakini katika kesi hii itakuwa ya namna gani?

392
00:29:42,770 --> 00:29:49,400
Nini jina la meza ya kwamba sisi ni kushughulika na kwamba ina alama na hisa

393
00:29:49,400 --> 00:29:52,280
kwa mtumiaji fulani?

394
00:29:52,280 --> 00:29:56,410
Ni aidha watumiaji au kwingineko.

395
00:29:56,410 --> 00:29:57,820
Kwingineko.

396
00:29:57,820 --> 00:30:03,220
Nini hii itakuwa kufanya ni swala kwingineko kwa ishara na hisa

397
00:30:03,220 --> 00:30:04,920
kwa mtumiaji fulani.

398
00:30:04,920 --> 00:30:09,260
Hapa, nasema, (CHAGUA ishara, hisa kutoka TBL -

399
00:30:09,260 --> 00:30:12,280
lakini badala ya meza, utaenda kuchukua nafasi ya kuwa na kwingineko.

400
00:30:12,280 --> 00:30:15,220
'Wapi' kimsingi ni hali yangu.

401
00:30:15,220 --> 00:30:21,050
Mimi kusema mimi tu wanataka kupata arrays wale associative kwamba yanahusiana

402
00:30:21,050 --> 00:30:23,850
 kwa hali hii yafuatayo - id sawa.

403
00:30:23,850 --> 00:30:27,600
 Kisha mimi nina kuweka placeholder hapo na kisha id kikao.

404
00:30:27,600 --> 00:30:36,720
Nini hii itakuwa kufanya ni kusema kwa kila mstari katika safu.

405
00:30:36,720 --> 00:30:40,940
Hii ni njia nadhifu badala ya kweli kuwa kuanzisha kwa kitanzi

406
00:30:40,940 --> 00:30:47,450
kwamba iterates juu ya yote ya bahati, kisha katika PHP unaweza kuwa kwa-kila kitanzi.

407
00:30:47,450 --> 00:30:53,520
>> Kama una safu aliyopewa, basi unaweza kusema mimi naenda kuwaita kila kipengele mfululizo -

408
00:30:53,520 --> 00:30:57,930
Mimi naenda kuwaita kila kipengele hiki jina.

409
00:30:57,930 --> 00:31:02,780
Hivyo, kwa kila moja ya mambo haya, mimi naenda kuwaita hii,

410
00:31:02,780 --> 00:31:04,500
basi naweza kufanya hili.

411
00:31:04,500 --> 00:31:10,370
Katika hili kwa ajili ya kila mmoja, una safu kama safu yako halisi, na kila mstari wewe ni kwenda kuwaita mfululizo.

412
00:31:10,370 --> 00:31:12,420
Kila wakati ni executes mwili,

413
00:31:12,420 --> 00:31:16,960
itakuwa kwenda juu na itakuwa update mstari kipengele ijayo katika safu.

414
00:31:18,900 --> 00:31:25,260
>> Sasa, katika suala la kununua hisa,

415
00:31:25,260 --> 00:31:29,500
nini tunataka kufanya ni kupata hisa kwamba mtumiaji anataka kununua

416
00:31:29,500 --> 00:31:35,300
na kiasi cha hisa kwamba mtumiaji anataka kununua, na kisha - kama wanataka -

417
00:31:35,300 --> 00:31:38,120
kuongeza kwamba hisa na kwingineko yao.

418
00:31:38,120 --> 00:31:40,310
Ni wazi, kama wao ni kununua kitu, basi, kwamba kinaendelea kupungua

419
00:31:40,310 --> 00:31:43,520
kiasi cha fedha, hivyo kwamba kinaendelea kupungua fedha zao.

420
00:31:43,520 --> 00:31:48,380
Sisi ni kwenda kushughulika na uppdatering kwingineko kama vile meza watumiaji,

421
00:31:48,380 --> 00:31:50,300
ambayo ina fedha taslimu.

422
00:31:50,300 --> 00:31:54,920
Lakini kwanza, unahitaji kupata hisa halisi na kiasi cha hisa kwamba mtumiaji anataka.

423
00:31:54,920 --> 00:32:00,010
Kwa maana kwamba, itabidi HTML fomu ambayo kuuliza kwa ishara ya hisa

424
00:32:00,010 --> 00:32:03,360
kwamba unataka kununua kama vile idadi ya hisa.

425
00:32:03,360 --> 00:32:08,300
Ndipo utasikia wanataka kuongeza.

426
00:32:08,300 --> 00:32:13,750
Utasikia wanataka kuchagua maadili fulani.

427
00:32:13,750 --> 00:32:19,670
Tumeenda kupitia kidogo hiki kidogo tayari, lakini wakati wewe ni kujaribu kupata safu fulani -

428
00:32:19,670 --> 00:32:22,020
retrieve safu fulani kutoka meza ya SQL,

429
00:32:22,020 --> 00:32:24,290
hii ni syntax zifuatazo.

430
00:32:24,290 --> 00:32:28,400
Wewe kuchagua, na kisha kama wewe taja nyota,

431
00:32:28,400 --> 00:32:31,830
kwamba kutakuwa na kimsingi kurudi mzima, mzima mstari kwa ajili yenu.

432
00:32:31,830 --> 00:32:36,890
Kisha tena, una hali ambapo, na kisha wewe taja -

433
00:32:36,890 --> 00:32:39,990
Mimi nataka tu jina la mtumiaji kwa kuwa sawa na mail-katika,

434
00:32:39,990 --> 00:32:46,660
hivyo itakuwa tu retrieve mfululizo katika watumiaji kwamba sambamba na mail-katika.

435
00:32:46,660 --> 00:32:52,860
>> Wakati mtumiaji anataka kuongeza hisa na kwingineko,

436
00:32:52,860 --> 00:32:54,400
unahitaji kuangalia kwa makosa kadhaa.

437
00:32:54,400 --> 00:32:57,680
Wewe unataka kuhakikisha kwamba mtumiaji unaweza kweli kumudu hisa,

438
00:32:57,680 --> 00:33:00,810
hivyo utasikia wanataka kuangalia fedha zao.

439
00:33:00,810 --> 00:33:05,810
Kabla ya hapo, sisi kutumika nyota retrieve safu nzima kutoka meza SQL.

440
00:33:05,810 --> 00:33:08,930
Lakini hapa, tunaweza kweli tu kutaja kwamba mimi nataka tu 1 thamani -

441
00:33:08,930 --> 00:33:10,080
Mimi nataka tu fedha taslimu.

442
00:33:10,080 --> 00:33:17,970
Hivyo hapa, ingekuwa kurudi fedha kwa mtumiaji na id namba 1.

443
00:33:17,970 --> 00:33:25,940
Kama mtumiaji tayari kununuliwa hisa fulani lakini basi hununua zaidi ya hisa kwamba,

444
00:33:25,940 --> 00:33:30,440
kisha katika kwingineko yako - hutaki line tofauti,

445
00:33:30,440 --> 00:33:34,770
mwingine mstari kwamba ina kwamba shughuli mpya.

446
00:33:34,770 --> 00:33:37,950
Wewe kweli wanataka update kiasi.

447
00:33:37,950 --> 00:33:42,530
Yote yale kubadilisha kweli ni kiasi cha hisa kwamba mtumiaji kwamba anamiliki.

448
00:33:42,530 --> 00:33:47,730
Kama matumizi ya Insert katika swala - hivyo ni tu Insert katika kwingineko yako yote ya maadili haya -

449
00:33:47,730 --> 00:33:51,710
id mtumiaji idadi kama vizuri kama ishara ya hisa kwamba wao ni kununua

450
00:33:51,710 --> 00:33:57,750
na hisa, basi utasikia pia wanataka bayana, vizuri, ikiwa mimi kukimbia katika ufunguo duplicate -

451
00:33:57,750 --> 00:34:00,750
katika kesi hii, muhimu ni duplicate si tu mtumiaji id lakini pia ni ishara ya hisa -

452
00:34:00,750 --> 00:34:08,340
kwa sababu unaweza tu kuwa - Nguzo yetu ni kwamba unaweza tu kuwa na mstari 1

453
00:34:08,340 --> 00:34:10,699
 kwamba sambamba na alama 1 maalum.

454
00:34:10,699 --> 00:34:13,659
Hivyo, juu ya ufunguo duplicate - kama wewe kukimbia katika mgongano hapo -

455
00:34:13,659 --> 00:34:18,520
wewe ni kwenda tu update hisa kwa thamani yake mpya.

456
00:34:18,520 --> 00:34:23,290
Hisa sawa chochote sisi alikuwa mbele pamoja na idadi ya hisa kwamba mtumiaji ni kununua.

457
00:34:27,790 --> 00:34:31,090
>> Sasa kwa kuwa tumekuwa updated meza kwingineko,

458
00:34:31,090 --> 00:34:34,730
tutaweza wanataka update fedha mtumiaji.

459
00:34:34,730 --> 00:34:40,300
Hiyo ni katika meza ya watumiaji, hivyo sisi ni kwenda kuwa subtracting kiasi fulani kutoka fedha taslimu.

460
00:34:40,300 --> 00:34:46,270
Labda, ni kwenda kuwa fedha ni sawa na fedha taslimu minus - na kisha kiasi fulani.

461
00:34:46,270 --> 00:34:50,560
Update ya fedha taslimu, wewe ungekuwa -

462
00:34:50,560 --> 00:34:55,699
kama alitaka kuchukua fedha kutoka kwa barua-katika, basi napenda kukimbia hoja hii -

463
00:34:55,699 --> 00:35:00,220
'Update watumiaji' na kisha kuweka safu ya fedha kwa fedha -

464
00:35:00,220 --> 00:35:07,300
>> Ningependa kuondoa dola 9,999 tu kama jina la mtumiaji ni sawa na barua-katika.

465
00:35:07,300 --> 00:35:12,020
Lakini, katika kesi hii, sisi hawataki Ondoa 9999 hasa.

466
00:35:12,020 --> 00:35:17,610
Tunataka kubainisha, vizuri, tunataka Ondoa bei ya sasa ya hisa

467
00:35:17,610 --> 00:35:22,400
kuyagawa kwa idadi ya hisa kwamba wao ni kununua.

468
00:35:25,260 --> 00:35:29,910
>> Sasa tumekuwa aliwaruhusu kuona yote ya hifadhi ya kwamba wana,

469
00:35:29,910 --> 00:35:33,080
kama vile kununua hisa zaidi.

470
00:35:33,080 --> 00:35:37,430
Sisi pia awali aliwaruhusu kuangalia bei ya sasa ya hisa.

471
00:35:37,430 --> 00:35:40,030
Hapa tunataka kuwaruhusu kuuza yao.

472
00:35:40,030 --> 00:35:42,160
Kwanza tunataka kuonyesha kimsingi -

473
00:35:42,160 --> 00:35:45,270
tunataka kuwaruhusu kuona yote ya hifadhi ya kwamba wana,

474
00:35:45,270 --> 00:35:53,170
hivyo hapa tunataka kuonyesha wote wa safu kutoka kwingineko.

475
00:35:53,170 --> 00:35:56,650
Kama wao kuchagua kuuza hisa fulani,

476
00:35:56,650 --> 00:35:59,140
basi sisi ni kwenda kudhani kwamba wanataka kuuza yote.

477
00:35:59,140 --> 00:36:04,350
Wao si tu kwenda kuuza 50% ya hisa zao, wao wanaenda kuuza 100% ya hiyo.

478
00:36:04,350 --> 00:36:08,630
Tunaweza tu kufuta mstari mzima kutoka kwingineko.

479
00:36:08,630 --> 00:36:17,520
Tunaweza kufuta hisa mtumiaji aliyopewa ya alama fulani.

480
00:36:17,520 --> 00:36:21,410
Kuna syntax kwa ajili hiyo.

481
00:36:21,410 --> 00:36:22,710
>> Kisha tunataka update fedha taslimu.

482
00:36:22,710 --> 00:36:30,930
Sisi ni kwenda kuwa na kuongeza fedha taslimu sawa na kiasi cha hisa wao ni kuuza

483
00:36:30,930 --> 00:36:34,640
kuyagawa kwa bei ya sasa ya hisa -

484
00:36:34,640 --> 00:36:38,610
si bei ambayo wao kununuliwa, lakini badala ya bei ambayo ni -

485
00:36:38,610 --> 00:36:40,500
bei ya sasa wakati wao ni kuuza hivyo.

486
00:36:40,500 --> 00:36:43,660
Kwa rejea bei ya sasa ya hisa,

487
00:36:43,660 --> 00:36:49,120
wewe unataka kutumia lookup, ambayo nitakupa bei ya hisa

488
00:36:50,030 --> 00:36:52,650
wakati wa sasa.

489
00:36:52,650 --> 00:36:55,930
>> Sasa sisi ni wa kushoto na historia,

490
00:36:55,930 --> 00:37:00,170
ambayo unataka kuruhusu user kuweka wimbo wa wote wa shughuli zao -

491
00:37:00,170 --> 00:37:03,040
anataka kuona wakati wao kuuzwa kitu, wakati wowote kununuliwa hisa.

492
00:37:03,040 --> 00:37:08,870
Tunataka kubainisha wakati ambapo wao walifanya kama vile jinsi wengi wao kununuliwa

493
00:37:08,870 --> 00:37:11,650
na nini hisa ilikuwa.

494
00:37:11,650 --> 00:37:17,800
Je, tuna yoyote sasa, zilizopo muundo kwamba unasema kuwa?

495
00:37:17,800 --> 00:37:25,230
Naam, sisi kuwa na kwingineko ambayo inaonyesha idadi ya hifadhi kwamba mtumiaji ana

496
00:37:25,230 --> 00:37:26,470
kwa ajili ya kushiriki aliyopewa.

497
00:37:26,470 --> 00:37:34,060
Lakini sisi ni jinsia kwingineko katika njia ambayo ni updates wakati sisi kununua nyingi,

498
00:37:34,060 --> 00:37:40,190
ambapo historia lazima - kama wewe kununua Apple, 10 hisa yake, na kisha baadaye kuuza 5,

499
00:37:40,190 --> 00:37:44,040
basi wewe unataka kuona wale tofauti, kama vitendo tofauti, tofauti mistari.

500
00:37:44,040 --> 00:37:48,520
Wakati hatua kwamba visualize kwamba katika meza yetu na kwingineko

501
00:37:48,520 --> 00:37:52,540
ingekuwa tu kuwa update kwa mstari fulani,

502
00:37:52,540 --> 00:37:55,740
 hivyo sisi ni pengine atataka mwingine meza.

503
00:37:55,740 --> 00:38:00,460
Katika database yetu, tuna watumiaji wetu meza, tuna kwingineko wetu meza,

504
00:38:00,460 --> 00:38:04,090
na sasa sisi itabidi pengine wanataka meza historia.

505
00:38:04,090 --> 00:38:08,070
Kwamba meza historia unaweza kuweka wimbo wa tarehe ya sasa,

506
00:38:08,070 --> 00:38:12,800
kama vile fulani hisa alama, kama vile hisa ngapi,

507
00:38:12,800 --> 00:38:15,410
na kisha nini action ni -

508
00:38:15,410 --> 00:38:18,800
kama wewe walikuwa kununua hisa hizo au kama wewe walikuwa kuziuza.

509
00:38:20,660 --> 00:38:25,720
>> Ili kukabiliana na tarehe, kuna wanandoa wa njia ambazo unaweza kufanya kazi hii.

510
00:38:25,720 --> 00:38:28,820
PHP ina njia ya kuweka wimbo wa tarehe, ambayo unaweza kuangalia up mwenyewe.

511
00:38:28,820 --> 00:38:33,990
Katika SQL unaweza pia kutumia aidha sasa au timestamp sasa. Hiyo ni juu yako.

512
00:38:33,990 --> 00:38:40,720
Tu kuhakikisha kwamba kila wakati mtumiaji hununua au anauza, wewe utakuwa uppdatering fedha zao

513
00:38:40,720 --> 00:38:46,750
katika meza watumiaji, wewe utakuwa uppdatering safu katika meza portfolios,

514
00:38:46,750 --> 00:38:50,900
basi utasikia pia kuwa uppdatering historia,

515
00:38:50,900 --> 00:38:56,260
hivyo kuna ni kwenda kuwa 3 tofauti SQL maswali kwamba wewe utakuwa wito huko.

516
00:38:58,640 --> 00:39:01,530
Sisi kuwa na rundo la utendaji sasa.

517
00:39:01,530 --> 00:39:10,600
>> Michache tu ya kuwakumbusha kwamba katika ripoti ya faili yako, utasikia wanataka zilizounganishwa na angalau yako -

518
00:39:10,600 --> 00:39:15,550
lakini utasikia wanataka kuruhusu user zilizounganishwa na ukurasa buy.php.

519
00:39:15,550 --> 00:39:23,560
Hiyo kwenda kuruhusu user - buy.php ni mtawala, ili kwenda aidha

520
00:39:23,560 --> 00:39:29,170
kutuma wewe - ambayo inaenda kutuma wewe kwa ajili ya kwamba utapata kuangalia mambo juu.

521
00:39:29,170 --> 00:39:34,420
Tuna historia. Sisi magogo nje, kupata quote na kisha kuuza.

522
00:39:34,420 --> 00:39:37,350
Wale ni katika kiwango cha chini nini unataka kuonyesha.

523
00:39:37,350 --> 00:39:43,640
Katika suala la kwingineko, na kwingineko ni kweli inavyoonekana katika ukurasa index.

524
00:39:43,640 --> 00:39:52,050
Kama sisi kwenda index, hapa tunaona kwamba ni mithili portfolio.php

525
00:39:52,050 --> 00:40:00,050
na hupita katika safu associative - kimsingi cheo sawa na kwingineko.

526
00:40:00,050 --> 00:40:02,610
Kwa hiyo, hili ni mtawala.

527
00:40:02,610 --> 00:40:08,000
Kama sisi kwenda kwa template ya portfolio.php,

528
00:40:08,000 --> 00:40:18,060
kisha wote ina ni - maonyesho ya kimsingi picha kwamba anasema, oh, tovuti hii ni chini ya ujenzi.

529
00:40:18,060 --> 00:40:23,810
Baadaye, mara moja, unaweza kupita katika - you'll kuwa kupita katika taarifa kimsingi maalum zaidi.

530
00:40:23,810 --> 00:40:27,400
Badala ya jina tu, pengine utasikia kuwa kupita katika mambo zaidi.

531
00:40:27,400 --> 00:40:32,010
Mara baada ya kuwa maadili hayo, basi portfolio.php inaweza kukabiliana na maadili hayo

532
00:40:32,010 --> 00:40:34,490
na uchapishaji yao nje katika aina yoyote ya utaratibu.

533
00:40:34,490 --> 00:40:41,660
>> Mara ve kutekelezwa wote wa wale, wewe pia haja ya kutekeleza 1 zaidi kipengele.

534
00:40:41,660 --> 00:40:44,890
Hii inaweza ama kuwa kuruhusu user kubadili password yao,

535
00:40:44,890 --> 00:40:50,110
upya nywila zao kama wameweza wamesahau hiyo - hivyo kwa nenosiri, basi

536
00:40:50,110 --> 00:40:54,560
pengine utasikia pia wanataka hariri kujiandikisha ili inaruhusu yao bayana barua pepe,

537
00:40:54,560 --> 00:40:57,910
hivyo kama wao kusahau nywila zao, basi wanaweza kupata hiyo.

538
00:40:57,910 --> 00:41:02,870
Wao pengine unaweza kuingia katika jina la mtumiaji zao, na kisha barua pepe utatumwa kwao

539
00:41:02,870 --> 00:41:06,180
na kiungo kuweza upya nywila zao.

540
00:41:06,180 --> 00:41:10,980
Unaweza kuwa na kitu ambayo inaruhusu watumiaji kupata stakabadhi

541
00:41:10,980 --> 00:41:12,380
kila wakati wao kununua au kuuza kitu,

542
00:41:12,380 --> 00:41:19,910
na kisha hatimaye, kuwaruhusu kuongeza fedha kwa tovuti yao.

543
00:41:19,910 --> 00:41:24,970
Tu kwenda nyuma katika dhana ya controllers na templates kidogo.

544
00:41:24,970 --> 00:41:31,170
Wewe utakuwa na kitu kama - hivyo itabidi mtawala hapa.

545
00:41:31,170 --> 00:41:35,080
Hivi sasa, sisi ni kuangalia mfano login.php.

546
00:41:35,080 --> 00:41:38,220
Wakati tuna mtawala, kimsingi ni ya kwenda kuchukua kesi 2.

547
00:41:38,220 --> 00:41:42,090
Wakati tuna controllers, tuko katika kipande hiki kwamba sisi ni pia aina ya kushughulika na

548
00:41:42,090 --> 00:41:43,880
wakati tuna aina kama vile.

549
00:41:43,880 --> 00:41:47,500
mtawala mapenzi kimsingi kuwa vitendo tofauti -

550
00:41:47,500 --> 00:41:53,880
moja ikiwa fomu tayari kuwasilishwa, na kisha mbili kama mtumiaji ni kuja kuwa ukurasa

551
00:41:53,880 --> 00:41:56,870
kwa mara ya kwanza na bado anahitaji pembejeo kwamba fomu.

552
00:41:56,870 --> 00:42:02,820
>> Mimi naenda kuruka kwa kesi hiyo ya kwanza kabla ya kwenda hadi kesi ya kwanza ya kuwa na fomu in

553
00:42:02,820 --> 00:42:12,640
Hapa tunasema, ikiwa fomu imekuwa na post in mbinu -

554
00:42:12,640 --> 00:42:13,580
msiwe na wasiwasi juu ya kuwa kidogo.

555
00:42:13,580 --> 00:42:19,780
Usijali kuhusu kwamba sana lakini kuelewa kwamba kimsingi kazi hii inahusika na

556
00:42:19,780 --> 00:42:22,430
kama fomu imekuwa in au la.

557
00:42:22,430 --> 00:42:25,640
Hali hii ni ya kweli kama mtumiaji ina in fomu.

558
00:42:25,640 --> 00:42:45,940
Kama siyo, basi tunakwenda unataka simu asimlipe login_form.php, na kisha kupita katika cheo.

559
00:42:45,940 --> 00:42:48,010
Hii ni cheo tu kimsingi kwenda itaonekana katika header.

560
00:42:48,010 --> 00:42:54,990
Nini hii kimsingi anasema, okay - vizuri, kama mtumiaji inakwenda login.php

561
00:42:54,990 --> 00:43:00,310
na si kweli umeingia, basi nataka kuwatuma ukurasa ambayo ina kuwa fomu

562
00:43:00,310 --> 00:43:03,160
ambayo inaruhusu yao pembejeo username na password.

563
00:43:03,160 --> 00:43:07,590
Kisha mimi kwenda login_form, na kisha kuwa ina fomu halisi.

564
00:43:07,590 --> 00:43:13,750
Basi, mara moja user elekeza kwamba fomu, wao wanaenda kuwasilisha kwa login.php

565
00:43:13,750 --> 00:43:15,840
na baada ya mbinu.

566
00:43:15,840 --> 00:43:21,560
Kisha mimi nina kweli kwenda kuingia sehemu hii ya kitanzi yangu kama-kingine.

567
00:43:21,560 --> 00:43:29,560
Basi ni katika hapa kwamba sisi kushughulika na maadili aliingia katika fomu.

568
00:43:29,560 --> 00:43:32,800
Ni hapa kwamba sisi kushughulika na wale.

569
00:43:32,800 --> 00:43:40,860
>> Kisha mara moja kukabiliana na maadili hayo - kama wewe ni kushughulika na -

570
00:43:40,860 --> 00:43:46,640
wanasema sisi ni kushughulika na ukurasa quote.php ambapo mtu anaweza pembejeo hisa kwamba

571
00:43:46,640 --> 00:43:49,950
wanataka kuangalia juu, na kisha kuona kwamba kuonyesha -

572
00:43:49,950 --> 00:43:52,850
kwamba aina ya sawa hapa.

573
00:43:52,850 --> 00:43:56,070
Hapa tuna fomu login - you'd pengine fomu quote -

574
00:43:56,070 --> 00:44:00,290
lakini kisha mara moja user ina kweli in kwamba habari,

575
00:44:00,290 --> 00:44:04,810
basi utasikia wanataka mtawala kupita katika template mwingine

576
00:44:04,810 --> 00:44:07,430
ambayo kuwaonyesha kuwa habari halisi.

577
00:44:07,430 --> 00:44:11,250
Hivyo basi haki kote hapa, basi itabidi pengine -

578
00:44:11,250 --> 00:44:18,830
karibu mwisho wa hali yako hapa - kama njia sawa na post -

579
00:44:18,830 --> 00:44:22,520
basi pengine utasikia wanataka atatoa ukurasa mwingine - quote show -

580
00:44:22,520 --> 00:44:28,040
ambayo hutuma wewe ukurasa kwamba - show_quote.php--

581
00:44:28,040 --> 00:44:34,120
na kisha katika faili ambazo kumbukumbu maadili hayo.

582
00:44:34,120 --> 00:44:36,480
Je, hiyo mantiki?

583
00:44:36,480 --> 00:44:40,390
>> Tuna mtawala kwamba kimsingi inahusika na kesi 2 -

584
00:44:40,390 --> 00:44:42,710
kama uliyoingiza fomu katika au la.

585
00:44:42,710 --> 00:44:43,950
Kama si aliingia fomu,

586
00:44:43,950 --> 00:44:47,300
basi itakuwa redirect wewe kwa ajili ya kwamba, ambayo hatimaye kuweka wewe nyuma kwenye ukurasa huo.

587
00:44:47,300 --> 00:44:54,020
Basi, mara moja una habari katika mtawala, mwili kuwa atapambana na kwamba

588
00:44:54,020 --> 00:44:59,750
habari kama ni muhimu - ama kuangalia juu ya maadili kwa hisa,

589
00:44:59,750 --> 00:45:04,150
na kisha mara moja ni akatazama maadili hayo na ina yao katika safu nicely formatted,

590
00:45:04,150 --> 00:45:08,180
basi wanaweza kupitisha kwamba safu katika ukurasa template

591
00:45:08,180 --> 00:45:10,330
 ambayo inahusika na outputting kwamba habari.

592
00:45:10,330 --> 00:45:14,680
>> Tena, tangu mtandao ni, ni kwenda kuwa fun.

593
00:45:14,680 --> 00:45:20,310
Sisi ni nje ya C hivyo sisi ni mdogo si ASCII na kwamba pato terminal,

594
00:45:20,310 --> 00:45:21,800
hivyo kuwa na furaha na hii.

595
00:45:21,800 --> 00:45:24,920
Unaweza kufanya hivyo kama Visual kama unataka.

596
00:45:24,920 --> 00:45:31,860
Unaweza kuruhusu watumiaji mamilioni ya dola pembejeo kwa wakati,

597
00:45:31,860 --> 00:45:34,730
au kikomo yao na kuwa kweli maana na kuwaruhusu tu kuingia 1 senti wakati

598
00:45:34,730 --> 00:45:36,330
au kitu kama hicho.

599
00:45:36,330 --> 00:45:38,550
Dhahiri kuwa na uhakika wa kuwa na furaha na hii.

600
00:45:38,550 --> 00:45:47,030
>> PHP code ni rahisi kidogo kwa kuwa ni kidogo rahisi ramani nje pseudocode yako

601
00:45:47,030 --> 00:45:50,070
katika utekelezaji.

602
00:45:50,070 --> 00:45:56,320
Hivyo, dhahiri kuwa na furaha na hii kwa sababu ni kweli kipande yetu ya mwisho katika CS50.

603
00:45:56,320 --> 00:46:01,150
Pamoja na kwamba, hii ilikuwa walkthrough 7.

604
00:46:01,150 --> 00:46:04,640
Mara wewe ni kumaliza kuangalia walkthrough na kumaliza pset yako,

605
00:46:04,640 --> 00:46:09,590
basi hawa walikuwa pia psets, na sasa sisi ni juu ya bidhaa ya mwisho -

606
00:46:09,590 --> 00:46:12,330
baada ya sisi kupata njia ya chemsha bongo 1.

607
00:46:12,330 --> 00:46:16,200
Basi pengine unaweza kutumia zana kwamba wameweza kujifunza kutoka psets -

608
00:46:16,200 --> 00:46:21,980
si tu syntax, lakini zaidi dhana ya kufikirika ya jinsi ya kuchukua baadhi ya -

609
00:46:21,980 --> 00:46:24,950
kama, nataka kufanya hili na kisha kutekeleza kweli kwamba.

610
00:46:24,950 --> 00:46:28,740
Kujifunza jinsi ya mapambano kwa njia ya kisintaksia na code usambazaji.

611
00:46:28,740 --> 00:46:33,020
Masomo code ya watu wengine, na kisha kutafsiri kwamba kwa kutumia kazi ya awali iliyopo.

612
00:46:33,020 --> 00:46:37,360
>> Hivyo, bahati nzuri na pset mwisho.

613
00:46:37,360 --> 00:46:39,930
Imekuwa ni furaha ya kuongoza walkthroughs.

614
00:46:39,930 --> 00:46:40,940
Natumaini wao tumekuwa kusaidia kwa ajili yenu.

615
00:46:40,940 --> 00:46:46,560
Haya yalikuwa Walkthroughs, na shukrani sana.

616
00:46:52,580 --> 00:46:56,200
[CS50.TV]