1 00:00:00,000 --> 00:00:10,393 >> [Music kucheza] 2 00:00:10,393 --> 00:00:11,037 3 00:00:11,037 --> 00:00:12,120 DAVID J. Malan: zote haki. 4 00:00:12,120 --> 00:00:12,830 Karibu tena. 5 00:00:12,830 --> 00:00:13,890 Hii ni CS50. 6 00:00:13,890 --> 00:00:15,570 Hii ni ya mwisho wa wiki 8. 7 00:00:15,570 --> 00:00:18,360 Na kama unajua, tuna pretty masaa ya kawaida ya ofisi katika chache 8 00:00:18,360 --> 00:00:21,090 ya kumbi dining, ikiwa ni pamoja na Annenberg. 9 00:00:21,090 --> 00:00:23,860 Na baadhi ya timu kindly alichukua photos baadhi siku za hivi karibuni. 10 00:00:23,860 --> 00:00:26,230 Na kwa heshima ya Halloween, sisi mawazo tunatarajia 11 00:00:26,230 --> 00:00:30,160 kushiriki moja kwamba badala hawakupata nasi kwa mshangao hapa katika Annenberg Hall tu 12 00:00:30,160 --> 00:00:31,490 nyingine usiku. 13 00:00:31,490 --> 00:00:36,300 Classmate wako Jacob vinavyotokana kwa picha hii, lakini ilikuwa zaidi amusing 14 00:00:36,300 --> 00:00:39,760 alikuwa kwenye Facebook, iliyofuata mazungumzo yaliyotokea baadaye. 15 00:00:39,760 --> 00:00:43,020 >> Wadhifa wake wa kwanza katika kukabiliana kwa picha yake ilikuwa hii. 16 00:00:43,020 --> 00:00:46,740 Dakika chache baadaye, aliamua kwa moja juu yake mwenyewe na hii. 17 00:00:46,740 --> 00:00:53,800 Ni aliendelea kisha kwenda hii, na kisha, hata zaidi amusingly 18 00:00:53,800 --> 00:00:55,320 ni wakati mama yake chimed katika. 19 00:00:55,320 --> 00:00:59,240 20 00:00:59,240 --> 00:01:01,800 Na kisha hatimaye, inaonekana huyu alikuwa tu 21 00:01:01,800 --> 00:01:04,860 ruse ajabu kwa kucheza kwamba kinaendelea. 22 00:01:04,860 --> 00:01:07,080 >> Hivyo, kama ungependa kuona Jacob na wengine, 23 00:01:07,080 --> 00:01:10,880 kati yao Cynthia Meng, ambaye ni nyuma ya pazia la wafanyakazi CS50 zone, 24 00:01:10,880 --> 00:01:13,970 kichwa na URL hii na kucheza hii hapa. 25 00:01:13,970 --> 00:01:18,810 Hivyo bila wasiwasi zaidi, leo sisi kuendelea kuangalia hii katika programu ya mtandao, 26 00:01:18,810 --> 00:01:21,810 na viumbe halisi ya programu kwamba si kukimbia katika mstari amri yako, 27 00:01:21,810 --> 00:01:24,080 lakini badala kukimbia ndani ya browser. 28 00:01:24,080 --> 00:01:26,320 >> Takribani sasa, au sana muda mfupi, wewe kwenda 29 00:01:26,320 --> 00:01:30,200 kuwa katikati ya utekelezaji mtandao yako mwenyewe server, ambayo 30 00:01:30,200 --> 00:01:31,700 ni tofauti na programu ya mtandao. 31 00:01:31,700 --> 00:01:36,210 server mtandao katika pset6 ni wote kuhusu kuandika programu kwamba anajua jinsi ya kuchukua 32 00:01:36,210 --> 00:01:39,300 Maombi HTTP kutoka browser, au hata kutoka kwenu, ya binadamu, 33 00:01:39,300 --> 00:01:42,340 na mpango ujulikanao Telnet, na kisha kujibu ama maombi ya wale 34 00:01:42,340 --> 00:01:48,600 na mate nje HTML faili, au a jpeg, gif au, au hata faili .php. 35 00:01:48,600 --> 00:01:52,490 >> Lakini pamoja na mtandao wa kompyuta, si wanatakiwa tu kufungua PHP faili, 36 00:01:52,490 --> 00:01:55,260 kitu kuishia katika .php, na kisha mate nje yaliyomo. 37 00:01:55,260 --> 00:01:58,440 Ni walidhani kufanya nini kwamba faili ya kwanza? 38 00:01:58,440 --> 00:01:59,390 Hivyo kusema. 39 00:01:59,390 --> 00:02:04,060 Si kukusanya yake, sisi alisema Jumatatu, lakini rather-- Hivyo, kutafsiri. 40 00:02:04,060 --> 00:02:08,070 >> PHP ni lugha yake, na hivyo moja ya vipengele muhimu katika mtandao wako 41 00:02:08,070 --> 00:02:11,550 server, angalau kutekelezwa na sisi, ni uwezo huu kwa mtandao kompyuta yako 42 00:02:11,550 --> 00:02:12,490 taarifa, oh. 43 00:02:12,490 --> 00:02:14,580 Hii ni faili kuishia katika .php. 44 00:02:14,580 --> 00:02:17,970 Napenda si tu kutuma kwa user kama ni bidhaa tuli, 45 00:02:17,970 --> 00:02:20,970 lakini badala ya basi mimi kusoma mstari kwa line, kushoto na kulia, na kutafsiri. 46 00:02:20,970 --> 00:02:23,030 >> Na kufanya, kwamba guys mapenzi kimsingi 47 00:02:23,030 --> 00:02:26,520 Punt mpango katika appliance, na juu ya mengi ya mifumo ya kompyuta, 48 00:02:26,520 --> 00:02:27,500 tu kuitwa PHP. 49 00:02:27,500 --> 00:02:30,579 Hiyo ni jina la PHP Lugha ya mwenyewe mkalimani. 50 00:02:30,579 --> 00:02:33,120 Hivyo, kwamba kipande sisi kutekeleza kwa wewe, na nini kushoto kwa ajili yenu, 51 00:02:33,120 --> 00:02:35,240 hatimaye, ni idadi ya vipande, kati ya ambayo 52 00:02:35,240 --> 00:02:37,960 inatekeleza msaada kwa maudhui tuli. 53 00:02:37,960 --> 00:02:40,180 >> Lakini sasa, na kwa tatizo kuweka saba, wewe ni 54 00:02:40,180 --> 00:02:43,660 kwenda kuanza mpito kwa kweli kuandika PHP kificho 55 00:02:43,660 --> 00:02:45,970 kwamba anapata kutafsiriwa katika kuzungumza na mwisho nyuma 56 00:02:45,970 --> 00:02:47,960 Mbegu kwamba maduka ya habari. 57 00:02:47,960 --> 00:02:51,020 Basi hebu kuelewa kwanza michache ya superglobals haya 58 00:02:51,020 --> 00:02:53,720 na tu nguvu kiasi gani kupata nje ya sanduku kwa ajili ya bure 59 00:02:53,720 --> 00:02:55,250 na lugha kama PHP. 60 00:02:55,250 --> 00:02:57,350 Mambo huna kutekeleza mwenyewe. 61 00:02:57,350 --> 00:03:01,700 >> Hivyo, tuliona Jumatatu $ _GET, ambayo ni superglobal, 62 00:03:01,700 --> 00:03:05,496 ambayo ni PHP tu kusema kwa ajili ya kimataifa kutofautiana unaweza kupata mahali popote. 63 00:03:05,496 --> 00:03:06,620 Na nini ndani ya $ _GET? 64 00:03:06,620 --> 00:03:09,930 65 00:03:09,930 --> 00:03:12,110 Nini ndani ya hii superglobal kwamba sisi kuona? 66 00:03:12,110 --> 00:03:15,900 67 00:03:15,900 --> 00:03:19,020 Hakika kitakwimu katika angalau mtu mmoja anajua. 68 00:03:19,020 --> 00:03:21,590 Nini ndani ya $ _GET? 69 00:03:21,590 --> 00:03:22,426 Yeah? 70 00:03:22,426 --> 00:03:24,130 >> Watazamaji: Ni vigezo kuweka katika kamba swala. 71 00:03:24,130 --> 00:03:24,530 >> DAVID J. Malan: Perfect. 72 00:03:24,530 --> 00:03:26,488 Ni vigezo you kuweka katika kamba swala. 73 00:03:26,488 --> 00:03:29,910 Hivyo, katika mfano wetu wakubwa wa reimplementing Google wakati tulikuwa 74 00:03:29,910 --> 00:03:34,130 URL, na kisha swali alama, ambayo demarcates mwanzo wa HTTP 75 00:03:34,130 --> 00:03:37,950 vigezo, basi tulikuwa q sawa kitu, kama q ni sawa na paka, 76 00:03:37,950 --> 00:03:41,500 nini ingekuwa moja kwa moja kwenda ndani ya kwamba $ _GET super kimataifa kwa ajili yenu, 77 00:03:41,500 --> 00:03:47,430 kwa sababu ya PHP, ni muhimu ya Q, na ya thamani yake ya paka. 78 00:03:47,430 --> 00:03:51,250 >> Kwa maneno mengine, $ _GET na wote wa mambo haya ni arrays associative, 79 00:03:51,250 --> 00:03:54,530 meza hash ya kila aina, kwamba funguo kuhifadhi na maadili. 80 00:03:54,530 --> 00:03:57,980 Sasa, nyuma katika pset5, hash meza unaweza kuwa kutekelezwa, 81 00:03:57,980 --> 00:04:00,220 au kujaribu unaweza kuwa kutekelezwa, kwa kweli 82 00:04:00,220 --> 00:04:04,010 ilikuwa ufanisi associative safu, muundo data 83 00:04:04,010 --> 00:04:07,220 ambapo unaweza kujiunga funguo na maadili. 84 00:04:07,220 --> 00:04:09,690 >> Lakini katika pset5, maadili walikuwa duni. 85 00:04:09,690 --> 00:04:12,430 thamani alikuwa kimsingi kweli au uongo. 86 00:04:12,430 --> 00:04:13,900 Ni neno katika kamusi? 87 00:04:13,900 --> 00:04:18,279 Hivyo, wakati wewe heshi neno kama apple kuona kama apple ni katika kamusi, 88 00:04:18,279 --> 00:04:21,820 hundi yako ya kazi labda akarudi kweli au uongo. 89 00:04:21,820 --> 00:04:24,120 Hivyo, hiyo ni ufanisi thamani sisi ni kupata nyuma. 90 00:04:24,120 --> 00:04:26,456 >> Lakini tuliona Jumatatu kwa ufupi, unaweza hakika 91 00:04:26,456 --> 00:04:28,830 kujiunga zaidi ya kuvutia maadili kuliko tu kweli au uongo 92 00:04:28,830 --> 00:04:30,790 na funguo, kama apple. 93 00:04:30,790 --> 00:04:33,909 Unaweza kweli kurudi kamba kiholela, na kwa kweli, 94 00:04:33,909 --> 00:04:36,200 kwamba ni nini $ _GET na hizi vigezo vingine basi wewe kufanya. 95 00:04:36,200 --> 00:04:40,595 >> Hivyo $ _POST ni sawa katika roho, lakini kama wewe kuwasilisha fomu kupitia post, 96 00:04:40,595 --> 00:04:44,490 tofauti HTTP njia hiyo ni kutumika kwa ajili ya mambo kama mkopo, 97 00:04:44,490 --> 00:04:48,410 na habari binafsi, na hata habari binary kama photos, 98 00:04:48,410 --> 00:04:51,840 mambo hayo kuishia ndani ya $ _POST. 99 00:04:51,840 --> 00:04:53,770 Na kwa kweli kwa files kama jpegs na whatnot, 100 00:04:53,770 --> 00:04:58,290 kuna hata mwingine si kwamba hapa aitwaye $ _FILES vilevile. 101 00:04:58,290 --> 00:05:01,280 >> Hivyo, server sisi si kukaa juu ya sana sana, lakini inakupa upatikanaji 102 00:05:01,280 --> 00:05:04,860 kutatua wa maelezo ya ngazi ya chini kuhusu server yenyewe kwamba unatumia. 103 00:05:04,860 --> 00:05:07,430 Cookie na kikao, ingawa, tutaweza kwa ufanisi kuona sasa. 104 00:05:07,430 --> 00:05:10,940 mwisho ni nini sisi kutumia ili kutekeleza dhana ya gari ununuzi. 105 00:05:10,940 --> 00:05:14,480 moja super rahisi, lakini wanakumbuka kwamba tulikuwa mfano huu hapa, 106 00:05:14,480 --> 00:05:17,640 kuhesabu mara ngapi alikuwa alitembelea ukurasa hii kabla. 107 00:05:17,640 --> 00:05:20,850 >> Lakini leo, badala ya kuangalia athari ya hii, hebu kufungua 108 00:05:20,850 --> 00:05:22,640 Chrome Inspekta, ambayo unaweza kawaida 109 00:05:22,640 --> 00:05:25,740 kufanya kwa kubofya kulia au Kudhibiti kubonyeza mahali popote kwenye mtandao, 110 00:05:25,740 --> 00:05:27,250 na kisha kuchagua kukagua kipengele. 111 00:05:27,250 --> 00:05:31,600 Au unaweza kwenda kwa njia ya menus kwamba sisi kuelezea katika spec pset6 ya. 112 00:05:31,600 --> 00:05:35,020 Na mimi nina kwenda tab Mtandao hapa, na hebu kuangalia kwa muda 113 00:05:35,020 --> 00:05:37,590 HTTP trafiki kwamba kwenda na kurudi. 114 00:05:37,590 --> 00:05:40,929 >> Hebu kwanza kwenda mbele na cache wazi Chrome. 115 00:05:40,929 --> 00:05:43,470 Hivyo baadhi ya unaweza kuwa familiar na mbinu hii tayari, 116 00:05:43,470 --> 00:05:45,790 na sisi ni kwenda kuitumia kwa debugging madhumuni hapa. 117 00:05:45,790 --> 00:05:48,890 118 00:05:48,890 --> 00:05:50,890 Sasa sisi kama kompyuta wanasayansi ni kwenda kuanza 119 00:05:50,890 --> 00:05:53,920 kufanya hivyo kwa debugging madhumuni, ambapo 120 00:05:53,920 --> 00:05:55,910 sisi wazi cache, kawaida, ili tuweze 121 00:05:55,910 --> 00:05:57,670 Unaweza kujikwamua mambo aitwaye cookies. 122 00:05:57,670 --> 00:06:01,700 Hivyo wewe ni pengine kwa ujumla ukoo na kile cookies ni, au angalau 123 00:06:01,700 --> 00:06:04,370 kwamba zipo, lakini nini uelewa wako wa kwao, 124 00:06:04,370 --> 00:06:06,920 kama tu user ya kompyuta, ni nini kuki? 125 00:06:06,920 --> 00:06:09,490 126 00:06:09,490 --> 00:06:09,990 Yeah. 127 00:06:09,990 --> 00:06:14,391 >> Watazamaji: Ni kidogo ni of-- vizuri, si kidogo katika muda wa sayansi ya kompyuta. 128 00:06:14,391 --> 00:06:18,303 Ni kipande cha data kwamba tovuti zituma kwenu ili 129 00:06:18,303 --> 00:06:20,209 kuwa na uwezo wa kurekodi takwimu juu ya wewe. 130 00:06:20,209 --> 00:06:21,250 DAVID J. Malan: Sawa, nzuri. 131 00:06:21,250 --> 00:06:24,980 Hivyo ni kipande cha data kwamba server, unaweka kwenye kompyuta yako, 132 00:06:24,980 --> 00:06:28,840 na hebu kujumlisha hata zaidi, ni muhimu value-- vizuri, 133 00:06:28,840 --> 00:06:30,064 hiyo ni kupata sahihi zaidi. 134 00:06:30,064 --> 00:06:31,980 Ni kipande cha habari, kipande cha data, 135 00:06:31,980 --> 00:06:34,430 kwamba server ni uwezo kuweka kwenye kompyuta yako 136 00:06:34,430 --> 00:06:38,592 na mara nyingi sana, server gani hii ili kukumbuka wewe ni nani. 137 00:06:38,592 --> 00:06:40,300 Hivyo kwa mfano, ni tabia mbaya ni wewe pengine 138 00:06:40,300 --> 00:06:42,982 watumiaji katika maeneo kama Facebook, au Gmail, au wengine kabla, 139 00:06:42,982 --> 00:06:44,940 na wewe kuingia katika na yako username na password, 140 00:06:44,940 --> 00:06:49,000 na kisha baada ya kuwa, kwa baadhi ya simu ya dakika au masaa au siku hata, 141 00:06:49,000 --> 00:06:52,970 server anakumbuka kwamba wewe ni, kwa kweli, watumiaji katika. 142 00:06:52,970 --> 00:06:54,600 Sasa, jinsi ni kwamba kweli kinachotokea? 143 00:06:54,600 --> 00:06:58,630 Kwa sababu wewe ni hakika si retyping username na password yako kila wakati 144 00:06:58,630 --> 00:07:00,760 navigate kwa ukurasa tofauti kwenye Facebook. 145 00:07:00,760 --> 00:07:02,570 Hivyo ni zamu nje cookies ni jibu. 146 00:07:02,570 --> 00:07:05,360 >> kuki unaweza kufikiria kama, aina ya kama, mkono digital 147 00:07:05,360 --> 00:07:09,200 muhuri kwamba unaweza kupata katika pumbao Hifadhi au klabu kwamba kimsingi 148 00:07:09,200 --> 00:07:11,740 inaonyesha umekuwa hapa kabla, na wameweza tayari 149 00:07:11,740 --> 00:07:16,070 umeonyesha ID yako bouncer, kwa mfano, na kwamba klabu au Hifadhi 150 00:07:16,070 --> 00:07:19,050 lazima sasa kudhani kuwa wewe kuwa kuthibitishwa tayari. 151 00:07:19,050 --> 00:07:21,270 Wewe tayari kutambuliwa na yake. 152 00:07:21,270 --> 00:07:24,740 >> Hivyo, pamoja na kwamba katika akili, hebu kufungua kukabiliana hapa. 153 00:07:24,740 --> 00:07:27,220 Basi mimi kwenda mbele, mimi tu alifanya, na wazi yote ya cookies yangu. 154 00:07:27,220 --> 00:07:29,970 Na sasa nini mimi kwenda kufanya ni kushikilia kuhama, tu kwa ajili ya hatua nzuri, 155 00:07:29,970 --> 00:07:31,740 na kwa nguvu upya ukurasa. 156 00:07:31,740 --> 00:07:34,170 Kuhama tu kuhakikisha kwamba hakuna kitu anapata cached. 157 00:07:34,170 --> 00:07:36,850 Na hapa ni ombi kwamba alikwenda na kurudi. 158 00:07:36,850 --> 00:07:41,560 Hivyo hapa tuna ombi, na basi mimi kuvuta chini hapa, na mengi ya hii 159 00:07:41,560 --> 00:07:44,710 ni maelezo ya aina ya uninteresting kwa sasa kwamba browser ina moja kwa moja 160 00:07:44,710 --> 00:07:47,800 alimtuma, lakini hebu bonyeza Mtazamo Chanzo kuona headers ghafi. 161 00:07:47,800 --> 00:07:51,700 >> Na kama wameweza dived katika pset6 tayari, utasikia hakika kutambua mambo 162 00:07:51,700 --> 00:07:54,990 kama hii, na labda baadhi ya mistari haya mengine hapa, 163 00:07:54,990 --> 00:07:59,040 lakini nini kuvutia zaidi kwa leo kama mimi kitabu chini, si kwa ombi 164 00:07:59,040 --> 00:08:02,870 lakini kinachojulikana majibu, mstari huu pengine inaonekana familiar. 165 00:08:02,870 --> 00:08:04,977 Kwamba ni jambo jema wakati unaweza kuona 200 sawa. 166 00:08:04,977 --> 00:08:07,060 Inavyoonekana hii ni tarehe na wakati juu ya server 167 00:08:07,060 --> 00:08:08,268 na kuna rundo la mambo. 168 00:08:08,268 --> 00:08:09,290 Oh, hii ni ya kuvutia. 169 00:08:09,290 --> 00:08:13,430 >> Zinageuka wakati wowote kutumia PHP, angalau katika kompyuta hii, 170 00:08:13,430 --> 00:08:16,360 server akimtemea nini toleo la PHP unatumia. 171 00:08:16,360 --> 00:08:18,962 Ambayo, kwa kweli, kwa ajili ya usalama madhumuni, si jambo zuri. 172 00:08:18,962 --> 00:08:21,170 Lakini, tutaweza kuja nyuma na kwamba baadhi ya wakati mwingine labda. 173 00:08:21,170 --> 00:08:25,740 Lakini sasa hii ni line Juicy leo, na tuliona kwa ufupi baadhi ya haya, 174 00:08:25,740 --> 00:08:29,240 Nadhani na Facebook wakati sisi poked karibu Inspekta wakati huo, 175 00:08:29,240 --> 00:08:33,380 kuweka kuki ni nini kupanda kipande kidogo cha habari 176 00:08:33,380 --> 00:08:34,890 kwenye kompyuta yako. 177 00:08:34,890 --> 00:08:37,490 >> Hii ni header HTTP hiyo ni ufanisi 178 00:08:37,490 --> 00:08:39,970 kuwaambia browser yako, Chrome, IE, chochote, 179 00:08:39,970 --> 00:08:44,480 hey browser kuhifadhi juu ya mtumiaji kuendesha gari kwa bidii, au katika mtumiaji RAM, 180 00:08:44,480 --> 00:08:49,680 ufunguo aitwaye PHPSESSID, ambayo ni nukuu shorthand kwa ajili ya kikao ID, 181 00:08:49,680 --> 00:08:53,670 na kuwapa thamani ya 0vlk8t, dot, dot, dot. 182 00:08:53,670 --> 00:08:56,480 Pseudo kweli kwa muda mrefu random alphanumeric kamba. 183 00:08:56,480 --> 00:08:59,480 Ni tu idadi kubwa kweli kweli, lakini ni encoded na barua na idadi 184 00:08:59,480 --> 00:09:03,550 hivyo kwamba ukubwa wa inaweza kuwa hata kubwa kuliko namba peke yake. 185 00:09:03,550 --> 00:09:06,947 Na kisha, kwa njia, Njia = /, kwamba tu ina maana kwamba kuki hii inapaswa kuwa 186 00:09:06,947 --> 00:09:08,780 kuhusishwa na ukamilifu wa tovuti, 187 00:09:08,780 --> 00:09:11,150 si tu maalum ukurasa jambo zima. 188 00:09:11,150 --> 00:09:12,930 Hivyo hii ni kwamba virtual mkono stempu. 189 00:09:12,930 --> 00:09:16,330 Ni kana kwamba server, Facebook, au katika kesi yetu appliance, 190 00:09:16,330 --> 00:09:21,140 ina 0vlk8t halisi ya maandishi na kadhalika, kwa upande wako. 191 00:09:21,140 --> 00:09:24,360 Taarifa ya nini server ya, si kufanya ni siyo 192 00:09:24,360 --> 00:09:27,730 kuhifadhi jina la mtumiaji yangu, hakika si kuhifadhi password yangu. 193 00:09:27,730 --> 00:09:31,710 >> Badala yake, inaonekana kuwa kuhifadhi habari Pseudo random 194 00:09:31,710 --> 00:09:35,010 hivyo kwamba hakuna mtu anayeweza nadhani nini mkono wangu muhuri ni. 195 00:09:35,010 --> 00:09:37,590 Upande server, wakati huo huo, server 196 00:09:37,590 --> 00:09:40,370 ni kwenda kukumbuka, pengine katika orodha ya au kitu, 197 00:09:40,370 --> 00:09:46,490 kwamba mtumiaji, ambaye katika siku zijazo inatoa mkono muhuri wa 0vlk8t, dot, 198 00:09:46,490 --> 00:09:51,440 dot, dot, lazima kuhusishwa na hii gari ununuzi fulani, hivyo kusema. 199 00:09:51,440 --> 00:09:55,060 Kwa maneno mengine, kama mimi sasa kwenda nyuma hapa na upya ukurasa huu, 200 00:09:55,060 --> 00:09:58,020 jinsi gani server kujua kwamba mimi alitembelea mara moja? 201 00:09:58,020 --> 00:10:01,730 >> Au kama mimi kufanya hivyo tena, jinsi gani server kujua kwamba nimepata alitembelea mara mbili? 202 00:10:01,730 --> 00:10:04,680 Vizuri kama mimi kwenda chini kwa hii ombi hivi karibuni, ambayo 203 00:10:04,680 --> 00:10:09,150 sasa ya tatu kwamba nimepata alimtuma kwa jumla, taarifa ya ombi yangu sasa. 204 00:10:09,150 --> 00:10:11,300 Bado kuna hii kuomba hapa, sawa 205 00:10:11,300 --> 00:10:15,040 kama kabla, bado kuna rundo zima ya mambo ambayo tumekuwa kupuuzwa kama kabla, 206 00:10:15,040 --> 00:10:19,350 lakini header mwisho sana, hii muda, kwa sababu nimekuwa hapa kabla, 207 00:10:19,350 --> 00:10:21,980 ni toleo la hii virtual mkono stempu. 208 00:10:21,980 --> 00:10:28,957 >> Ambapo mstari huu hapa, si kuweka kuki lakini kuki COLON PHPSESSI = 0vlk8t, 209 00:10:28,957 --> 00:10:32,040 kwamba tu browser yangu moja kwa moja kuwasilisha hii stempu mkono ili 210 00:10:32,040 --> 00:10:37,910 sasa server, kwa haraka kama anatambua, ooh, hii ni user 0vlk8t dot, dot, dot, 211 00:10:37,910 --> 00:10:42,010 Sasa naweza kukumbuka yeye au yeye ni nani na reassociate na user kwamba chochote 212 00:10:42,010 --> 00:10:46,450 habari nataka, na wote wa habari ambazo zinaweza kuhifadhiwa na wewe, 213 00:10:46,450 --> 00:10:50,130 programu, katika $ _SESSION. 214 00:10:50,130 --> 00:10:57,170 >> Hivyo kuwa wazi, kama mimi kufungua halisi ya haraka katika gedit kwamba faili halisi, counter.php, 215 00:10:57,170 --> 00:11:02,340 katika jeshi mitaa yangu directory umma kama kabla, taarifa kwamba, kwa kweli, 216 00:11:02,340 --> 00:11:06,860 Mimi hatimaye kuhifadhi katika $ _SESSION Kunukuu unquote "counter," 217 00:11:06,860 --> 00:11:10,110 thamani ya kukabiliana uliopita ambayo Mimi kupata kutoka mistari haya hapa kwamba sisi 218 00:11:10,110 --> 00:11:13,010 inaonekana katika wakati wa mwisho pamoja na moja. 219 00:11:13,010 --> 00:11:14,980 Hivyo chini ya Hood, hiyo ni kuki zote ni. 220 00:11:14,980 --> 00:11:17,563 Ni tu aina ya digital mkono stempu kwenda na kurudi, 221 00:11:17,563 --> 00:11:20,450 na kusema ukweli kama wewe kufungua Chrome Inspekta kwenye tovuti yoyote 222 00:11:20,450 --> 00:11:22,580 wewe kutembelea leo, pamoja na super uwezekano mkubwa, 223 00:11:22,580 --> 00:11:25,450 wewe ni kwenda kuona labda moja, kuki labda nusu dazeni 224 00:11:25,450 --> 00:11:26,650 kuwa kukumbukwa na wewe. 225 00:11:26,650 --> 00:11:29,500 >> Na bado mbaya, kama wale tovuti wewe ni kutembelea 226 00:11:29,500 --> 00:11:32,640 wote wana matangazo, ambayo ni hakika ya kawaida kabisa leo, 227 00:11:32,640 --> 00:11:36,100 na kama matangazo hayo ni kuja kutoka kwa baadhi ya chama kati, mtu 228 00:11:36,100 --> 00:11:39,000 kama Google au AdWords kama wao kuwaita moja ya bidhaa zao 229 00:11:39,000 --> 00:11:42,880 au nyingine wachuuzi kama kwamba kuuza matangazo, nini kuvutia, 230 00:11:42,880 --> 00:11:46,510 na kusema ukweli kile kidogo inatia mashaka, kuhusu jinsi HTTP kazi, 231 00:11:46,510 --> 00:11:50,855 ni kwamba kama una ad iliyoingia katika Facebook.com, na Google.com, 232 00:11:50,855 --> 00:11:54,240 na Harvard.edu, idadi yoyote ya Nje, hivyo ni kama 233 00:11:54,240 --> 00:11:58,130 kwamba kuna mtu kati ambaye ni kuwahudumia up matangazo kwa ajili ya wote watatu wa tovuti hizo, 234 00:11:58,130 --> 00:12:02,110 zinageuka kuwa cookies ni kwa uwanja. 235 00:12:02,110 --> 00:12:05,910 >> Hivyo kama una ad kuja kutoka kampuni hiyo kwenye tovuti mbalimbali, 236 00:12:05,910 --> 00:12:11,140 kampuni ambayo inaweza ufanisi kufuatilia ambao wewe ni katika tovuti hizo. 237 00:12:11,140 --> 00:12:13,140 Harvard wanaweza kujua wewe kutembelea Facebook. 238 00:12:13,140 --> 00:12:15,306 Facebook wanaweza kujua na wewe kutembelea Harvard. 239 00:12:15,306 --> 00:12:18,160 Lakini chochote tangazo huduma wao ni kutumia kama kwamba domain ni 240 00:12:18,160 --> 00:12:21,710 sasa katika wawili Harvard.edu mtandao kurasa na Facebook.com webpages, 241 00:12:21,710 --> 00:12:26,850 huyu katikati anaijua wewe ni nani kwa sababu ya biskuti hizi kuwa pamoja 242 00:12:26,850 --> 00:12:30,910 hela, au tuseme, kwamba kinachojulikana middleman. 243 00:12:30,910 --> 00:12:33,820 >> Hivyo tutaweza kuja nyuma hii katika athari usalama wake, 244 00:12:33,820 --> 00:12:37,170 lakini kuna mengi ya habari kuwa kuhifadhiwa kuhusu wewe wakati wowote 245 00:12:37,170 --> 00:12:40,120 kutembelea zaidi ukurasa yoyote mtandao juu ya biashara na ni kweli 246 00:12:40,120 --> 00:12:42,877 inapunguza kwa hii utaratibu rahisi sana. 247 00:12:42,877 --> 00:12:44,710 Nini kinatokea, basi, kama wewe ni super Paranoid 248 00:12:44,710 --> 00:12:48,190 na kuamua kwenda katika Chrome au IE au chochote na kuzima cookies yako? 249 00:12:48,190 --> 00:12:49,365 Nini kitatokea? 250 00:12:49,365 --> 00:12:50,790 Yeah? 251 00:12:50,790 --> 00:12:53,170 Wewe really-- umefanya kosa haki hii? 252 00:12:53,170 --> 00:12:54,350 OK. 253 00:12:54,350 --> 00:12:55,994 Hakuna, kwenda mbele. 254 00:12:55,994 --> 00:12:59,645 >> Watazamaji: Baadhi ya Nje hawana kazi bila kama Facebook. 255 00:12:59,645 --> 00:13:00,520 DAVID J. Malan: Yeah! 256 00:13:00,520 --> 00:13:02,311 Nje hivyo baadhi ya tu kuacha kufanya kazi. 257 00:13:02,311 --> 00:13:05,520 Na katika tovuti wengi siku hizi kwamba kimsingi kutegemea biskuti, 258 00:13:05,520 --> 00:13:08,360 hasa kama wana wewe kuingia katika, wao ni kwenda tu kuvunja. 259 00:13:08,360 --> 00:13:10,360 Kwa sababu kufikiria mbadala, kama tovuti 260 00:13:10,360 --> 00:13:14,480 hana njia ya kukumbuka wewe ni nani, na kwa hiyo kivinjari yako si 261 00:13:14,480 --> 00:13:16,949 anayewakilisha pamoja na kila HTTP ombi la hii stempu mkono, 262 00:13:16,949 --> 00:13:18,740 ufanisi tovuti kama wanaokwenda Facebook 263 00:13:18,740 --> 00:13:22,050 kuwa na haraka wewe kuingia katika kila wakati darn 264 00:13:22,050 --> 00:13:26,200 mabadiliko ya kurasa, au bonyeza kiungo, ambayo ni hakika si user hasa nzuri 265 00:13:26,200 --> 00:13:26,920 uzoefu. 266 00:13:26,920 --> 00:13:30,020 >> Hivyo kwamba kuna, pia, ni miongoni mwa awamu ya pili ya biashara. 267 00:13:30,020 --> 00:13:34,140 Hivyo bila wasiwasi zaidi, hebu kuchukua nafasi ya kwamba kwa programu ya mtandao, 268 00:13:34,140 --> 00:13:37,630 katika lugha kama PHP, unaweza kukumbuka habari kama kwamba katika tatizo kuweka 269 00:13:37,630 --> 00:13:41,550 saba wakati wewe kutekeleza yako mwenyewe E * Biashara-kama tovuti ambayo kununua 270 00:13:41,550 --> 00:13:45,710 na kuuza hisa, itabidi kukumbuka hasa nini user imekuwa kununuliwa na kuuzwa 271 00:13:45,710 --> 00:13:49,110 na yeye au yeye ni nani kwa njia ya kikao hiki. 272 00:13:49,110 --> 00:13:51,110 Lakini sisi ni kwenda haja njia fancier kuliko email 273 00:13:51,110 --> 00:13:52,640 kuanza kuweka kote habari. 274 00:13:52,640 --> 00:13:53,140 Haki? 275 00:13:53,140 --> 00:13:56,780 >> Siku ya Jumatatu, sisi aliyesema kuhusu Frosh IMS na jinsi katika toleo moja ya tovuti ya kwamba, 276 00:13:56,780 --> 00:14:00,250 miaka iliyopita, sisi alifanya alikuwa email Proctor ambaye ni 277 00:14:00,250 --> 00:14:04,250 katika malipo ya michezo intramural programu, jina, na jinsia, 278 00:14:04,250 --> 00:14:07,330 na kama au wao ni nahodha, na Dorm ya mtu ambaye ni 279 00:14:07,330 --> 00:14:10,136 kusajili kwa intramural mchezo. 280 00:14:10,136 --> 00:14:13,010 Hivyo si mbaya, lakini yeye au yeye basi alikuwa na Troll kupitia email zao, 281 00:14:13,010 --> 00:14:16,010 kufanya spreadsheet au kitu kama kwamba, kuweka kila kitu kupangwa. 282 00:14:16,010 --> 00:14:19,750 Hivyo hakika sisi kama programmers Unaweza kufanya hivyo kwa kuwa mwangalizi. 283 00:14:19,750 --> 00:14:22,970 Na hivyo kuingia katika SQL, Uliza muundo lugha, 284 00:14:22,970 --> 00:14:26,050 ambayo ni kwenda kuangalia pretty tofauti na wote wawili C na PHP, 285 00:14:26,050 --> 00:14:30,990 na wewe utakuwa mbizi katika mikono mengi zaidi juu ya PHP na tatizo kuweka saba lakini pia SQL, 286 00:14:30,990 --> 00:14:35,310 au SQL, hii ni lugha ambayo matumizi ya kuzungumza na database. 287 00:14:35,310 --> 00:14:36,480 >> Lakini nini database? 288 00:14:36,480 --> 00:14:38,440 Vizuri unafikiri ya Mbegu, angalau kwa sasa, 289 00:14:38,440 --> 00:14:41,750 kama tu kuwa kama Excel faili, au kama wewe ni Mac namba user a file, 290 00:14:41,750 --> 00:14:44,400 au kama wewe ni Google Apps user spreadsheet Google, 291 00:14:44,400 --> 00:14:49,120 ni ufanisi database, au kweli hasa database kimahusiano. 292 00:14:49,120 --> 00:14:53,070 Mbegu kimahusiano ni tu kitu ambacho ina safu na nguzo, 293 00:14:53,070 --> 00:14:56,440 na unaweza kuhifadhi aina yoyote ya habari katika safu hizi au nguzo. 294 00:14:56,440 --> 00:15:00,480 >> Lakini nini ni nzuri kuhusu SQL, na kuhusu database halisi, si tu 295 00:15:00,480 --> 00:15:04,910 spreadsheets au spreadsheets Google, ni kwamba unaweza kutumia lugha 296 00:15:04,910 --> 00:15:09,000 kwa kweli nitafanya maswali kwa kuingiza data, kuondoa data, 297 00:15:09,000 --> 00:15:11,620 kuangalia kwa data, hata muhimu zaidi, na wewe 298 00:15:11,620 --> 00:15:16,110 hawana kuitumia haki manually Kama unaweza kawaida Google 299 00:15:16,110 --> 00:15:17,690 spreadsheet kama hii. 300 00:15:17,690 --> 00:15:22,217 >> Hivyo katika SQL, kuna rundo la kauli ya msingi au vipande 301 00:15:22,217 --> 00:15:23,300 ya utendaji kujengwa katika. 302 00:15:23,300 --> 00:15:26,450 Kuna wengi zaidi kuliko haya, lakini unaweza kwenda umbali mkubwa 303 00:15:26,450 --> 00:15:28,620 tu kwa kujua kwamba Lugha hii inaitwa 304 00:15:28,620 --> 00:15:30,840 SQL ina angalau nne kauli unaweza kujiinua. 305 00:15:30,840 --> 00:15:34,420 >> Kufuta, kwa ajili ya kuondoa data, Kuingiza, kwa ajili ya kuongeza safu, 306 00:15:34,420 --> 00:15:37,340 Mwisho, kwa ajili ya kubadilisha safu, na kuchagua, 307 00:15:37,340 --> 00:15:39,860 kwa ajili ya kupata nyuma mistari na hiyo ni kweli nini SQL gani. 308 00:15:39,860 --> 00:15:43,810 Ni kazi kabisa juu ya safu hivyo kwamba wakati wewe kuingiza, au kuondoa, 309 00:15:43,810 --> 00:15:47,470 au update, au kuchagua nini wewe kupata nyuma kama kinachojulikana matokeo ya kuweka, 310 00:15:47,470 --> 00:15:49,690 kama safu ya safu. 311 00:15:49,690 --> 00:15:51,700 rundo la safu kutoka meza. 312 00:15:51,700 --> 00:15:54,050 >> Hivyo nyuma katika siku, na hata leo hii, 313 00:15:54,050 --> 00:15:56,560 unaweza kuingiliana na Mbegu kutumia mstari amri, 314 00:15:56,560 --> 00:15:59,691 lakini siyo hasa furaha ya kutumia hii dirisha nyeusi na nyeupe style 315 00:15:59,691 --> 00:16:02,190 na kwa kweli kutekeleza amri na poke kuzunguka Mbegu yako. 316 00:16:02,190 --> 00:16:06,054 graphical user interface, au GUI, ni zaidi vyema, arguably, 317 00:16:06,054 --> 00:16:08,970 na hivyo chombo sisi kupendekeza na preinstalled kwa ajili yenu juu ya appliance 318 00:16:08,970 --> 00:16:10,580 inaitwa phpMyAdmin. 319 00:16:10,580 --> 00:16:14,060 Ni bahati mbaya kwamba jumla jina la jambo hili ina PHP katika hilo, 320 00:16:14,060 --> 00:16:17,430 ni tu ina maana kwamba watu ambaye aliandika mpango huu wenyewe 321 00:16:17,430 --> 00:16:18,670 aliandika katika PHP. 322 00:16:18,670 --> 00:16:23,740 >> Lakini ni hatimaye kuhusu kuendesha server database, kama server MySQL 323 00:16:23,740 --> 00:16:26,589 kwamba unaweza kuwa, kama wewe kufanya, katika CS50 appliance. 324 00:16:26,589 --> 00:16:29,130 Hivyo kuna undani zaidi hapa kuliko tunahitaji huduma ya juu ya leo, 325 00:16:29,130 --> 00:16:33,280 lakini nini muhimu ni kwamba upande wa kushoto upande ni orodha ya databaser 326 00:16:33,280 --> 00:16:36,040 kwamba una kwenye kompyuta yako, juu ya CS50 yako appliance, 327 00:16:36,040 --> 00:16:40,090 au kuja miradi ya mwisho kwamba huenda kuwa juu ya upande wa tatu, kampuni ya 328 00:16:40,090 --> 00:16:43,415 tovuti au mtandao wa kompyuta, kwamba unaweza kuwa kulipa kwa ajili ya nafasi. 329 00:16:43,415 --> 00:16:45,290 Hivyo upande wa kushoto ni database, moja ambayo 330 00:16:45,290 --> 00:16:48,750 ni pset7 ambayo mimi zilizokopwa kutoka ijayo wiki pset, na kisha juu 331 00:16:48,750 --> 00:16:51,570 kuna taarifa kuna rundo la tabo, moja ambayo 332 00:16:51,570 --> 00:16:55,150 ni database, SQL, hadhi, watumiaji, kuuza nje na kadhalika. 333 00:16:55,150 --> 00:16:56,900 Hivyo unaweza kwenda kwa muda mrefu njia tu kwa kutambua 334 00:16:56,900 --> 00:16:59,770 kwamba wengi wa interface user ni katika safu ya kushoto juu 335 00:16:59,770 --> 00:17:02,650 na hela ya juu haki juu huko. 336 00:17:02,650 --> 00:17:04,980 Hivyo nini tunaweza kweli kufanya na hii? 337 00:17:04,980 --> 00:17:08,609 Naam, hebu kuanza kujenga kidogo ya habari kama ifuatavyo. 338 00:17:08,609 --> 00:17:11,760 >> Tuseme zifuatazo ni kesi, kama itakuwa katika siku chache tu, 339 00:17:11,760 --> 00:17:14,440 unataka kutekeleza tovuti, iitwayo CS50 Fedha, 340 00:17:14,440 --> 00:17:17,328 na tovuti hii inakuwezesha kununua kunukuu unquote na kuuza hisa. 341 00:17:17,328 --> 00:17:19,619 Na ni kwenda kufikiri bei ya wale hifadhi, 342 00:17:19,619 --> 00:17:22,380 hatimaye kama utaona, kwa kuzungumza na Yahoo Fedha. 343 00:17:22,380 --> 00:17:26,250 Ambayo, ajabu, ina huduma ya bure ambapo unaweza kupita katika hisa ticker 344 00:17:26,250 --> 00:17:29,830 kama GOOG kwa Google, na itakuwa kukupa nyuma ya hisa ya sasa ya Google 345 00:17:29,830 --> 00:17:32,250 bei ndani ya siku za nyuma dakika chache angalau. 346 00:17:32,250 --> 00:17:35,080 >> Hivyo itabidi kutumia kwamba, hatimaye, kujifanya kwa mtumiaji 347 00:17:35,080 --> 00:17:37,750 kununua na kuuza halisi hifadhi kwa kutumia fedha virtual, 348 00:17:37,750 --> 00:17:39,750 lakini jambo la kwanza kabisa user kwenda kuona 349 00:17:39,750 --> 00:17:43,850 ni hii screen login ambayo anauliza yao kwa jina la mtumiaji yao na password. 350 00:17:43,850 --> 00:17:46,540 Na hivyo, moja ya kwanza changamoto kwa ajili yenu katika pset7 351 00:17:46,540 --> 00:17:50,460 ni kwenda kuwa na kutekeleza ya mwisho ya nyuma Mbegu, spreadsheet kama wewe, 352 00:17:50,460 --> 00:17:53,369 hiyo ni kwenda kuhifadhi majina ya watumiaji na nywila 353 00:17:53,369 --> 00:17:56,660 na hatimaye kile hifadhi wao wenyewe, na wangapi, na kiasi gani fedha wana, 354 00:17:56,660 --> 00:18:00,110 hivyo rundo ya mambo mengine katika meza nyingine, au Spreadsheets. 355 00:18:00,110 --> 00:18:05,020 >> Basi hebu tuangalie jinsi hii wapate kuonekana katika mtazamo wa kwanza. 356 00:18:05,020 --> 00:18:06,980 Mimi nina kwenda nyuma appliance na mimi nina 357 00:18:06,980 --> 00:18:14,102 kwenda kwa URL hii hapa phpMyAdmin localhost / phpmyadmin 358 00:18:14,102 --> 00:18:16,060 na utaona kwamba inachukua mimi interface 359 00:18:16,060 --> 00:18:18,520 hasa kama tuliona juu ya screen risasi, na hapa mimi 360 00:18:18,520 --> 00:18:21,560 kuwa database ya ziada aitwaye hotuba kwa leo 361 00:18:21,560 --> 00:18:24,280 na basi mimi kwenda mbele kwanza na bonyeza pset7. 362 00:18:24,280 --> 00:18:27,940 >> Mimi wanaonekana kuwa wanandoa wa chaguzi, moja kwa mwezi, kwa ajili ya kujenga meza mpya, 363 00:18:27,940 --> 00:18:30,770 na kiungo kwa watumiaji, ambayo meza Mimi tayari kuundwa. 364 00:18:30,770 --> 00:18:31,790 Basi nini meza? 365 00:18:31,790 --> 00:18:33,740 Hivyo kama wewe kutumika Excel kabla, na kama wameweza 366 00:18:33,740 --> 00:18:37,110 namba kutumika au Google Spreadsheets, wewe kufungua dirisha 367 00:18:37,110 --> 00:18:39,350 na wewe kupata rundo zima ya safu na nguzo, 368 00:18:39,350 --> 00:18:43,120 lakini basi kwa kawaida kuwa karatasi pamoja chini, au tabo tofauti. 369 00:18:43,120 --> 00:18:46,140 Unaweza kufikiri ya kila karatasi kama meza 370 00:18:46,140 --> 00:18:51,150 hivyo kwamba database, hatimaye, ni mchanganyiko wa meza moja au zaidi, moja 371 00:18:51,150 --> 00:18:54,064 au karatasi zaidi, katika dunia ya spreadsheet ya kawaida. 372 00:18:54,064 --> 00:18:55,980 Hivyo basi mimi kwenda mbele na click kwenye karatasi hii ya mazoezi 373 00:18:55,980 --> 00:18:59,420 kwamba mimi premade, aitwaye watumiaji, a.k.a. 374 00:18:59,420 --> 00:19:00,700 Mbegu meza. 375 00:19:00,700 --> 00:19:04,130 Na kama mimi kitabu chini hapa, napenda kuvuta nje kidogo, 376 00:19:04,130 --> 00:19:08,479 hii ni nini phpMyAdmin ni kuwaambia sisi ni ndani ya meza hii hivi sasa. 377 00:19:08,479 --> 00:19:11,020 Ni utata kidogo kwa mara ya kwanza mtazamo kwa sababu UI ni si 378 00:19:11,020 --> 00:19:15,140 Jambo prettiest katika dunia, lakini nini ni ya kuvutia ni sehemu hii hapa. 379 00:19:15,140 --> 00:19:17,970 ID, jina la mtumiaji, na hash. 380 00:19:17,970 --> 00:19:20,510 >> Mapema, na wewe utakuwa mitupu hii katika tatizo kuweka saba, 381 00:19:20,510 --> 00:19:25,050 sisi kukupa faili zenye super ndogo meza database, alikopa kweli 382 00:19:25,050 --> 00:19:27,070 kutoka hacker toleo tatizo kuweka mbili, 383 00:19:27,070 --> 00:19:29,480 ndani ya ambayo kuna safu sita. 384 00:19:29,480 --> 00:19:32,720 Moja kwa Belinda wote njia ya chini kwa moja kwa Zamyla, 385 00:19:32,720 --> 00:19:35,980 na taarifa ya kushoto ya wale majina ya watumiaji ni vitambulisho kipekee kama moja, 386 00:19:35,980 --> 00:19:39,410 mbili, tatu, nne, tano, sita, integers, na kisha na haki ni hashes. 387 00:19:39,410 --> 00:19:42,780 >> Na kama, ni tabia mbaya, wewe hakufanya tatizo hacker toleo kuweka mbili, 388 00:19:42,780 --> 00:19:46,560 lakini hash ni kama encrypted password na caveats wachache. 389 00:19:46,560 --> 00:19:49,470 Na hivyo, nini kuona hapa ni matoleo encrypted ya yote sita 390 00:19:49,470 --> 00:19:52,950 wa nywila yetu na tatizo kuweka mbili ya hacker toleo. 391 00:19:52,950 --> 00:19:56,500 Sasa kwa upande wa kushoto ni baadhi tu ya mambo GUI, editing safu hii, kuiga safu hii, 392 00:19:56,500 --> 00:19:57,630 kufuta safu hii. 393 00:19:57,630 --> 00:19:59,840 >> Lakini nini kuvutia sasa ni yafuatayo. 394 00:19:59,840 --> 00:20:03,810 Siwezi kweli kuanza majaribio na meza hii. 395 00:20:03,810 --> 00:20:07,330 Hivyo kama mimi kwenda na click SQL tab, mimi kupata hii sanduku kubwa maandishi. 396 00:20:07,330 --> 00:20:10,190 Na hii si jinsi tunakwenda kufanya hivyo wakati kweli kuandika code. 397 00:20:10,190 --> 00:20:12,700 Kuwa wazi, phpMyAdmin ni chombo tu kwamba 398 00:20:12,700 --> 00:20:16,450 kwenda hebu poke kuzunguka database na hebu majaribio na maswali. 399 00:20:16,450 --> 00:20:19,430 >> Hivyo kwa mfano, tuseme Mimi nitafanya hasa hili. 400 00:20:19,430 --> 00:20:22,820 Kuchagua, ambayo ni moja ya wale maneno nilivyoeleza awali, nyota, 401 00:20:22,820 --> 00:20:25,900 ambayo inawakilisha wote nguzo katika meza. 402 00:20:25,900 --> 00:20:26,820 Kutokana na kile meza? 403 00:20:26,820 --> 00:20:27,990 Vizuri, watumiaji. 404 00:20:27,990 --> 00:20:29,950 Na ilani kuna hii weird mkataba katika SQL 405 00:20:29,950 --> 00:20:32,140 ambapo wewe kweli kutumia nyuma ticks, kawaida, 406 00:20:32,140 --> 00:20:35,940 quotes si moja na quotes si mara mbili wakati majadiliano juu ya majina ya meza, 407 00:20:35,940 --> 00:20:38,990 hivyo nyuma kunukuu ni jambo juu ya mkono juu ya kushoto ya keyboard yako zaidi 408 00:20:38,990 --> 00:20:39,720 uwezekano. 409 00:20:39,720 --> 00:20:41,850 >> Hivyo basi mimi kwenda mbele sasa na kuondoka tu peke yake 410 00:20:41,850 --> 00:20:46,020 na kitabu chini na click Go, na sisi ni kweli kwenda kuona kitu kimoja. 411 00:20:46,020 --> 00:20:52,410 Sisi tu kunyongwa SQL query akisema kuchagua kila kitu nyota 412 00:20:52,410 --> 00:20:55,610 kutoka meza inayoitwa watumiaji, na nini kupata nyuma ni hii. 413 00:20:55,610 --> 00:20:58,400 Hatimaye, tutaweza kuwa na uwezo wa kufanya jambo sawa katika kanuni, 414 00:20:58,400 --> 00:21:02,109 lakini kwa sasa yote nilitaka je alikuwa kuona katika browser yangu. 415 00:21:02,109 --> 00:21:03,900 Naam hebu kufanya kitu tofauti kidogo. 416 00:21:03,900 --> 00:21:08,330 Napenda kwenda nyuma SQL tab, na hebu tu kusema kwamba nini? 417 00:21:08,330 --> 00:21:11,520 Zamyla amepoteza yote ya yake fedha, na kwa hiyo ni 418 00:21:11,520 --> 00:21:13,190 wakati kwa sisi kufuta yake kama mtumiaji. 419 00:21:13,190 --> 00:21:14,630 Yeye ni tena kuingia ndani. 420 00:21:14,630 --> 00:21:18,870 >> Hivyo mimi nina kwenda kusema kufuta from-- vizuri, kudumisha mtaji 421 00:21:18,870 --> 00:21:23,080 kwa uthabiti, kufuta kutoka kwa watumiaji ambapo. 422 00:21:23,080 --> 00:21:25,430 Na hivyo, tunaweza kuwa na hizi predicates, au hizi 423 00:21:25,430 --> 00:21:31,180 kufuzu, mwisho wa kauli yangu wapi na jinsi gani mimi kufuta Zamyla? 424 00:21:31,180 --> 00:21:34,190 Kwa jina lake Zamyla, hivyo safu, moja ya nguzo 425 00:21:34,190 --> 00:21:37,950 ilikuwa jina, hivyo ambapo jina = "Zamyla". 426 00:21:37,950 --> 00:21:40,000 Na hapa mimi kutumia mara mbili quotes au quotes moja, 427 00:21:40,000 --> 00:21:42,958 wewe tu kutumia nyuma ticks wakati kuzungumza juu ya majina, kwa mfano, 428 00:21:42,958 --> 00:21:45,130 ya meza au mashamba. 429 00:21:45,130 --> 00:21:47,440 Na napenda bonyeza Nenda hapa. 430 00:21:47,440 --> 00:21:50,400 Na sasa, ukurasa wa mtandao ni kuwa kidogo uptight. 431 00:21:50,400 --> 00:21:53,620 >> Au, je kweli wanataka nitafanya kufuta kutoka kwa watumiaji ambapo jina sawa Zamyla? 432 00:21:53,620 --> 00:21:54,680 Ndiyo. 433 00:21:54,680 --> 00:22:01,900 Hivyo sasa, kama sisi kurudi nyuma kwa meza yangu kwa kubonyeza watumiaji, taarifa kwamba Hm. 434 00:22:01,900 --> 00:22:02,530 Mimi goofed. 435 00:22:02,530 --> 00:22:04,070 Na kwa kweli, mimi aina ya clicked mbali hivyo kufunga 436 00:22:04,070 --> 00:22:06,195 hakuwa hata kuona nyekundu kosa ujumbe, labda. 437 00:22:06,195 --> 00:22:07,649 Nini mimi kufanya makosa? 438 00:22:07,649 --> 00:22:09,690 Watazamaji: Wewe hakuwa na haja capitalize jina lake. 439 00:22:09,690 --> 00:22:11,260 DAVID J. Malan: Yeah mimi mtaji jina lake, 440 00:22:11,260 --> 00:22:13,770 lakini yake Jina la mtumiaji kweli mimi alifanya makosa kadhaa, haki? 441 00:22:13,770 --> 00:22:16,720 Moja, jina la mtumiaji wake ni zamyla, lowercase Z, 442 00:22:16,720 --> 00:22:20,140 na jina safu ni jina la mtumiaji, si jina, hivyo hebu kufanya hili tena. 443 00:22:20,140 --> 00:22:25,750 Basi mimi kwenda mbele na kufuta kutoka kwa watumiaji ambapo 444 00:22:25,750 --> 00:22:28,990 jina la mtumiaji sawa kunukuu unquote "Zamyla". 445 00:22:28,990 --> 00:22:29,490 Wote haki? 446 00:22:29,490 --> 00:22:32,600 Hivyo hii inaonekana kidogo bora, basi niende kitabu chini na click Go. 447 00:22:32,600 --> 00:22:34,730 Ni bado kwenda yell saa yangu kwa kuwa na uhakika. 448 00:22:34,730 --> 00:22:37,500 Mimi bonyeza Ndiyo, na sasa tunaona, kusema ukweli hii kilichotokea, kwa kweli 449 00:22:37,500 --> 00:22:39,870 haraka, chini ya moja pili shaka, hii 450 00:22:39,870 --> 00:22:41,720 ni hasa swala kwamba got kuuawa. 451 00:22:41,720 --> 00:22:45,617 Kuthibitisha, basi mimi bonyeza watumiaji na kwa kweli sasa Zamyla ni gone. 452 00:22:45,617 --> 00:22:46,700 Sasa hebu kufanya kinyume. 453 00:22:46,700 --> 00:22:49,320 Tuseme kwamba Gabe anataka kujiandikisha kwa ajili ya tovuti. 454 00:22:49,320 --> 00:22:52,825 Nini SQL query, nini amri ningeweza aina kuongeza Gabe? 455 00:22:52,825 --> 00:22:54,200 Naam ni pretty moja kwa moja. 456 00:22:54,200 --> 00:22:58,260 Kuingiza ndani ya watumiaji, na sasa anapata kidogo cryptic. 457 00:22:58,260 --> 00:23:03,190 Mimi haja ya kutaja, kwa server, nini mashamba nataka kuwapa. 458 00:23:03,190 --> 00:23:06,630 Mimi si kweli huduma ya kile Gabe ya ID idadi ni, hivyo mimi nina kwenda ruka hiyo. 459 00:23:06,630 --> 00:23:11,360 Mimi badala kwenda kusema jina la mtumiaji, hash, na kisha 460 00:23:11,360 --> 00:23:14,960 maadili nataka kuweka kuna ni kwenda kuwa na Gabe. 461 00:23:14,960 --> 00:23:16,800 Na kisha hash yake, mimi sijui. 462 00:23:16,800 --> 00:23:19,900 Hivyo kwa sasa, mimi nina kwenda kuondoka kwamba kama kubwa ya kufanya. 463 00:23:19,900 --> 00:23:21,650 Tutaweza kuja nyuma kwamba katika tatizo kuweka 464 00:23:21,650 --> 00:23:23,390 spec kama jinsi wewe kweli kufanya hivyo. 465 00:23:23,390 --> 00:23:24,630 >> Hivyo taarifa, tena, syntax. 466 00:23:24,630 --> 00:23:28,430 Kuingiza ndani ya jina meza, kisha parenthesized orodha ya mashamba, 467 00:23:28,430 --> 00:23:30,980 nguzo unataka kuongeza maadili kwa, na kisha tu 468 00:23:30,980 --> 00:23:34,495 sawa halisi kuagiza kushoto haki ya maadili, unataka kuongeza, 469 00:23:34,495 --> 00:23:36,870 na ni kwa sababu tu wrapping Nakala ni kidogo kwa muda mrefu. 470 00:23:36,870 --> 00:23:38,520 Hivyo sasa napenda bonyeza Go. 471 00:23:38,520 --> 00:23:39,830 Mstari mmoja kuingizwa. 472 00:23:39,830 --> 00:23:43,020 Na sasa kama mimi kwenda nyuma watumiaji, nini kuvutia 473 00:23:43,020 --> 00:23:48,960 ni kwamba si tu ni Gabe sasa katika Mbegu, ni nini inaonekana ID wake? 474 00:23:48,960 --> 00:23:49,820 >> Naam ni saba. 475 00:23:49,820 --> 00:23:51,479 Kwa nini ni saba wakati sikuweza kuongeza? 476 00:23:51,479 --> 00:23:54,020 Hivyo hii, pia, ni moja ya makala ya kupata database. 477 00:23:54,020 --> 00:23:55,750 mengi ya kujengwa katika utendaji. 478 00:23:55,750 --> 00:23:57,950 Ni zinageuka kuwa wakati kuundwa meza hii, 479 00:23:57,950 --> 00:24:01,390 Mimi preconfigured ni moja kwa moja hawawajui ID kwa namna 480 00:24:01,390 --> 00:24:02,480 kuwa ni nyongeza. 481 00:24:02,480 --> 00:24:05,470 Hivyo kama wameweza milele poked karibu, na inaonekana katika kile yako Facebook ID 482 00:24:05,470 --> 00:24:09,292 idadi ni, siku hizi si kweli Jambo la kufanya, lakini kama Facebook API, 483 00:24:09,292 --> 00:24:11,750 Maombi Programming Interface, ambapo unaweza kupata nyuma 484 00:24:11,750 --> 00:24:14,430 rundo zima la data juu ya mwenyewe, kuhusu rafiki yako, 485 00:24:14,430 --> 00:24:15,347 na uhusiano wako. 486 00:24:15,347 --> 00:24:17,430 Na kile kutumika kuwa aina ya baridi, nyuma katika siku, 487 00:24:17,430 --> 00:24:19,510 ilikuwa kuangalia juu nini yako Facebook ID simu mara. 488 00:24:19,510 --> 00:24:22,390 Mark Zuckerberg wa, kwa mfano, ni tatu 489 00:24:22,390 --> 00:24:23,890 tangu yeye alikuwa mwandishi wa tovuti. 490 00:24:23,890 --> 00:24:27,610 Na kama hadithi inakwenda, yeye kuundwa mtihani akaunti mbili, watumiaji moja na mbili, 491 00:24:27,610 --> 00:24:28,690 ambayo yeye kisha ilifutwa. 492 00:24:28,690 --> 00:24:32,780 Na hivyo, Zuck, kama ni jina la mtumiaji wake juu ya Facebook, ni ID namba tatu, 493 00:24:32,780 --> 00:24:36,110 na sisi sote tuna namba sana siku kubwa kuliko tatu hizi. 494 00:24:36,110 --> 00:24:37,980 Kwa kweli, katika baadhi ya uhakika Facebook wakiongozwa mbali 495 00:24:37,980 --> 00:24:42,410 kutoka hata kwa kutumia int, ambayo ni thamani ya 32-bit, kwa kutumia 496 00:24:42,410 --> 00:24:44,480 ijayo hatua ya juu, kimsingi kwa muda mrefu kwa muda mrefu hivyo 497 00:24:44,480 --> 00:24:47,150 waweze kubeba hata zaidi ya watumiaji kusajili. 498 00:24:47,150 --> 00:24:49,420 Hivyo furaha kidogo ukweli wa kihistoria. 499 00:24:49,420 --> 00:24:51,660 >> Ili tu syntax ya msingi na ambayo 500 00:24:51,660 --> 00:24:54,470 tupate nitafanya michache maswali, lakini tunaweza kweli 501 00:24:54,470 --> 00:24:56,744 kufanya mambo rundo zaidi na SQL. 502 00:24:56,744 --> 00:24:58,910 Na utaona, hatimaye, katika tatizo kuweka saba 503 00:24:58,910 --> 00:25:01,034 kwamba una kufanya idadi ya maamuzi ya kubuni, 504 00:25:01,034 --> 00:25:03,290 kati yao ni kwenda kuwa na aina gani data kutumia. 505 00:25:03,290 --> 00:25:08,240 Hivyo tu kama katika C, kuna data aina katika database, kama MySQL, 506 00:25:08,240 --> 00:25:12,640 na aina data una kuchagua kutoka mashamba hayo ni pamoja na hapa. 507 00:25:12,640 --> 00:25:17,287 Char, varchar, Int, big int, alisema na tarehe ya muda, na wengine wengi. 508 00:25:17,287 --> 00:25:18,370 Basi hebu kweli kufanya hii. 509 00:25:18,370 --> 00:25:21,060 Hebu kujifanya kuwa hatukuwa mkono, wewe ni mtumiaji huyu meza 510 00:25:21,060 --> 00:25:25,080 na basi mimi kwenda mbele na kujenga, kwa mwenyewe, katika mihadhara database-- 511 00:25:25,080 --> 00:25:31,000 kweli basi mimi kwenda mbele na kufuta meza nina katika hapa tayari 512 00:25:31,000 --> 00:25:32,940 ili tuweze kweli kujenga hii. 513 00:25:32,940 --> 00:25:33,550 Whoops. 514 00:25:33,550 --> 00:25:35,970 Mimi nina kwenda kuacha hii meza, na sasa mimi nina 515 00:25:35,970 --> 00:25:38,337 kwenda tena hotuba database zaidi ya hapa, 516 00:25:38,337 --> 00:25:40,420 Mimi nina kwenda kujenga meza watumiaji kuitwa na hebu 517 00:25:40,420 --> 00:25:43,010 tu kufanya nguzo tatu awali na click Go. 518 00:25:43,010 --> 00:25:44,990 >> Sasa, kwa sehemu kubwa, tena, hii ni 519 00:25:44,990 --> 00:25:48,570 kutumia chombo hiki graphical aitwaye phpMyAdmin, na kile sisi ni kufanya sasa 520 00:25:48,570 --> 00:25:49,600 ni kujenga meza. 521 00:25:49,600 --> 00:25:53,170 Hivyo hii ni kama kwenda Picha, New, na kujenga mpya Excel faili. 522 00:25:53,170 --> 00:25:55,440 Hivyo ni kuuliza mimi chache maswali, kutoka kushoto kwenda kulia, 523 00:25:55,440 --> 00:25:58,620 nini jina la safu ya kwanza, na kisha jina la safu ya pili, 524 00:25:58,620 --> 00:25:59,560 na jina la tatu. 525 00:25:59,560 --> 00:26:00,518 Basi hebu recreate hii. 526 00:26:00,518 --> 00:26:05,460 ID, na kisha jina la mtumiaji alikuwa mmoja, na kisha hash alikuwa mwingine. 527 00:26:05,460 --> 00:26:08,970 Hivyo kile lazima aina data kuwa sasa kwa ajili ya shamba kama ID? 528 00:26:08,970 --> 00:26:14,470 >> Hapa ni orodha nzima ya aina data inapatikana na wewe katika database, 529 00:26:14,470 --> 00:26:16,070 na kwa sasa hebu tu kwenda na int. 530 00:26:16,070 --> 00:26:18,160 Thamani ya 32-bit, sijui kufikiri realistically mimi nina 531 00:26:18,160 --> 00:26:21,484 kwenda na zaidi ya bilioni 4 watumiaji katika akaunti yangu, katika huduma yangu, 532 00:26:21,484 --> 00:26:23,650 hivyo mimi nina kwenda kuweka kusonga juu ya swali ijayo. 533 00:26:23,650 --> 00:26:25,490 Mimi si kwenda kutaja urefu au maadili, 534 00:26:25,490 --> 00:26:28,540 si husika hapa kwa int, per se. 535 00:26:28,540 --> 00:26:30,740 Na sasa siwezi kutaja, inaonekana, default 536 00:26:30,740 --> 00:26:33,970 thamani, ambayo mimi si kwenda kwa bayana. 537 00:26:33,970 --> 00:26:36,050 kulinganishwa, sijui nini kwamba ni. 538 00:26:36,050 --> 00:26:37,290 sifa. 539 00:26:37,290 --> 00:26:39,455 Sasa sisi kwa kweli kufanya kuwa na kubuni maamuzi. 540 00:26:39,455 --> 00:26:42,580 Hivyo kuna mashamba chache hapa, si wote ambayo ni husika unsigned, lakini 541 00:26:42,580 --> 00:26:43,380 tu ina maana gani? 542 00:26:43,380 --> 00:26:45,400 Kwamba int lazima? 543 00:26:45,400 --> 00:26:46,210 Tu zisizo hasi. 544 00:26:46,210 --> 00:26:48,090 Hivyo ina kuwa 0 juu juu. 545 00:26:48,090 --> 00:26:51,120 Hapana, mimi si kwenda kuangalia sababu Nataka kila mtumiaji kuwa kitambulisho, 546 00:26:51,120 --> 00:26:52,470 haiwezi kuwa null. 547 00:26:52,470 --> 00:26:55,949 Na kisha, sisi kupata baadhi zaidi kubuni maamuzi ya kuvutia kama hii. 548 00:26:55,949 --> 00:26:58,990 Tutaweza kuja nyuma hii katika wakati huu, lakini kile kingine hulka ya database 549 00:26:58,990 --> 00:27:04,200 ni, ni kwamba unaweza kuwaambia server database kwenda mbele 550 00:27:04,200 --> 00:27:07,100 na kuongeza mwenyewe, yako RAM na wako nafasi ngumu disk, 551 00:27:07,100 --> 00:27:11,770 ili huchagua, na kuwekeza, na deletes, na updates ni kweli haraka. 552 00:27:11,770 --> 00:27:13,250 Tofauti hii kwa pset5. 553 00:27:13,250 --> 00:27:16,259 >> Kama alitaka kuangalia juu kitu katika hash meza yako, ambayo 554 00:27:16,259 --> 00:27:18,300 unafikiri ya kama database, ambaye alikuwa na kufanya yote 555 00:27:18,300 --> 00:27:21,500 kazi kwa ajili ya kufanya hash meza yako haraka. 556 00:27:21,500 --> 00:27:22,840 Ni kama, ni wazi, wewe. 557 00:27:22,840 --> 00:27:23,060 Haki? 558 00:27:23,060 --> 00:27:26,080 Alikuwa na kuweka katika faini wakati wote Mitsubishi mambo, kupata kazi hash 559 00:27:26,080 --> 00:27:27,820 haki, kuhesabia nje ya jinsi ndoo wengi kuwa. 560 00:27:27,820 --> 00:27:29,611 >> Lakini nini ni nzuri, tena, kuhusu database ni 561 00:27:29,611 --> 00:27:31,762 you Punt tu yote ya hii kwa watu wengine 562 00:27:31,762 --> 00:27:33,720 ambao walidhani huu kupitia kwa wewe, na kile 563 00:27:33,720 --> 00:27:37,170 Mimi nina kwenda kusema hapa chini ripoti ni kwamba shamba langu ID 564 00:27:37,170 --> 00:27:41,149 ni kwenda kuwa njia ya msingi ya kutambua watumiaji katika orodha hii. 565 00:27:41,149 --> 00:27:42,940 Mimi si kwenda kufikiri ya Zamyla kama Zamyla, 566 00:27:42,940 --> 00:27:45,800 Mimi nina kwenda kufikiria yake kama namba 6. 567 00:27:45,800 --> 00:27:49,814 >> Kwa nini ni, pengine, bora intuitively kufikiria na mfano 568 00:27:49,814 --> 00:27:52,480 kila mmoja wa safu yako binafsi kwa kutumia idadi badala ya kitu 569 00:27:52,480 --> 00:27:56,480 kama kamba, kama Zamyla au Gabe au kamba tena bado? 570 00:27:56,480 --> 00:27:57,444 Yeah? 571 00:27:57,444 --> 00:28:00,117 >> Watazamaji: ID ni ya kipekee? 572 00:28:00,117 --> 00:28:01,200 DAVID J. Malan: Sema tena? 573 00:28:01,200 --> 00:28:02,283 Watazamaji: ID ni ya kipekee? 574 00:28:02,283 --> 00:28:04,400 DAVID J. Malan: ID ni ya kipekee, lakini suppose-- 575 00:28:04,400 --> 00:28:06,320 kama kesi kwa ujumla na majina ya watumiaji, tuseme 576 00:28:06,320 --> 00:28:10,110 Mimi pia alisema kuna inaweza tu moja Zamyla katika dunia, na moja tu Gabe. 577 00:28:10,110 --> 00:28:13,730 Mimi naweza kulazimisha pekee kikwazo juu ya masharti, pia, kama mimi alitaka. 578 00:28:13,730 --> 00:28:15,550 Hivyo si wazo mbaya. 579 00:28:15,550 --> 00:28:16,500 >> Watazamaji: Zaidi salama. 580 00:28:16,500 --> 00:28:17,874 >> DAVID J. Malan: Zaidi salama, kwa nini? 581 00:28:17,874 --> 00:28:20,705 Watazamaji: Huwezi kuwaambia ambayo ni ambayo, kama katika user. 582 00:28:20,705 --> 00:28:22,580 DAVID J. Malan: Sawa, wewe siwezi kusema ambayo mtumiaji 583 00:28:22,580 --> 00:28:24,380 ni ambayo hivyo kuna faragha nyanja hiyo, 584 00:28:24,380 --> 00:28:27,810 hasa kama vitambulisho labda kuonekana katika URLs. 585 00:28:27,810 --> 00:28:29,960 Hivyo uhakika, kwamba inaweza aina ya kazi, pia. 586 00:28:29,960 --> 00:28:30,640 Mawazo mengine? 587 00:28:30,640 --> 00:28:31,383 Yeah? 588 00:28:31,383 --> 00:28:34,316 >> Watazamaji: Ni rahisi kufanya shughuli juu ya int. 589 00:28:34,316 --> 00:28:35,940 DAVID J. Malan: Hiyo ni kicker halisi. 590 00:28:35,940 --> 00:28:38,850 Ni ufanisi zaidi tu, au rahisi kwa kompyuta, 591 00:28:38,850 --> 00:28:40,431 kutekeleza shughuli juu ya integer. 592 00:28:40,431 --> 00:28:40,930 Haki? 593 00:28:40,930 --> 00:28:43,905 int ni uhakika kuwa 32-bit, ambapo Zamyla 594 00:28:43,905 --> 00:28:47,660 ni wahusika wachache kwa muda mrefu, Gabriel ni wahusika wachache zaidi ya muda mrefu, 595 00:28:47,660 --> 00:28:51,930 Davenport ni kweli kwa muda mrefu, na hivyo ni si hasa ufanisi kwa kutumia 596 00:28:51,930 --> 00:28:55,860 masharti kulinganisha maadili na kuangalia kwa ajili ya mashamba, na mashamba ya update, 597 00:28:55,860 --> 00:28:57,790 kama unaweza kupata mbali na integer moja tu. 598 00:28:57,790 --> 00:28:59,090 Bits 32 tu. 599 00:28:59,090 --> 00:29:02,570 Hivyo majina ya watumiaji, pia, kwa njia hii, hawana kuwa ya kipekee, 600 00:29:02,570 --> 00:29:05,040 ingawa pengine lazima kuwa, na hata katika njia hii pia 601 00:29:05,040 --> 00:29:07,520 user inaweza kuruhusiwa kubadili jina la mtumiaji wake. 602 00:29:07,520 --> 00:29:10,810 >> Basi hebu sasa kuondoka hii kama njia ya msingi ya kutambua mtumiaji. 603 00:29:10,810 --> 00:29:13,510 Hii ni kuwaambia database kwenda mbele na kuongeza mwenyewe 604 00:29:13,510 --> 00:29:17,065 ili kuangalia ups juu ya ID ni super haraka. 605 00:29:17,065 --> 00:29:19,620 Ai, horribly jina lake, tu ina maana Auto ya nyongeza, 606 00:29:19,620 --> 00:29:21,500 na hii ni hundi sanduku sisi haja ya kuangalia 607 00:29:21,500 --> 00:29:24,614 kutaja kwamba uwanja ID kwa kuwa moja kwa moja updated kwa ajili yangu, 608 00:29:24,614 --> 00:29:26,530 na kisha mimi nina kwenda kitabu na haki hapa 609 00:29:26,530 --> 00:29:29,279 na kusema ukweli mimi si kweli nia katika yoyote zaidi ya mashamba hayo. 610 00:29:29,279 --> 00:29:30,630 Hakika si leo. 611 00:29:30,630 --> 00:29:33,770 >> Hivyo mimi nina kwenda nyuma hapa, safu ya kwanza, ambapo 612 00:29:33,770 --> 00:29:35,830 Mimi haja ya kutaja jina la mtumiaji na hash, na hebu 613 00:29:35,830 --> 00:29:38,080 angalau kuzingatia pili moja kwa sasa. 614 00:29:38,080 --> 00:29:41,498 Int ni pengine si wito haki, hivyo nini mantiki zaidi labda? 615 00:29:41,498 --> 00:29:42,741 >> Watazamaji: Nakala. 616 00:29:42,741 --> 00:29:43,824 DAVID J. Malan: Sema tena? 617 00:29:43,824 --> 00:29:44,710 Watazamaji: Nakala. 618 00:29:44,710 --> 00:29:44,980 DAVID J. Malan: Nakala? 619 00:29:44,980 --> 00:29:45,590 OK, nikasikia maandishi. 620 00:29:45,590 --> 00:29:46,090 Nini kingine? 621 00:29:46,090 --> 00:29:50,520 622 00:29:50,520 --> 00:29:53,860 Sisi aina ya kuwa na rundo la uchaguzi kwamba ni textual katika asili. 623 00:29:53,860 --> 00:29:55,990 Hivyo wakati, na kwa nini, je, kutumia baadhi ya haya? 624 00:29:55,990 --> 00:29:59,560 Vizuri Char, kinyume na nini unaweza kufikiri, si tabia moja. 625 00:29:59,560 --> 00:30:01,550 Ni idadi maalum ya wahusika. 626 00:30:01,550 --> 00:30:04,600 Hivyo kama sisi kujua kwamba majina ya watumiaji wote lazima kama wahusika nane, 627 00:30:04,600 --> 00:30:08,490 kama kutumika kuwa kawaida katika umri mkubwa mifumo ya kompyuta, mimi naweza kusema Char 628 00:30:08,490 --> 00:30:09,830 na kisha mimi naweza kusema 8 hapa. 629 00:30:09,830 --> 00:30:12,930 Hiyo wakati safu ya tatu inakuwa husika wakati kujenga meza. 630 00:30:12,930 --> 00:30:15,450 >> Lakini hiyo ni aina ya annoying kwa sababu baadhi ya watu wangewapiga 631 00:30:15,450 --> 00:30:17,660 wanataka kuwa jina la mtumiaji tena kuliko wahusika nane, 632 00:30:17,660 --> 00:30:19,743 baadhi ya watu kutaka kuwa jina la mtumiaji mfupi, 633 00:30:19,743 --> 00:30:22,210 hivyo kwa nini kufanya mwenyewe kwa idadi maalum? 634 00:30:22,210 --> 00:30:24,710 Nini kuwa kutofautiana idadi ya chars na tu 635 00:30:24,710 --> 00:30:28,580 kusema kwamba urefu upeo wa jina ni, mimi sijui, kama wahusika 64. 636 00:30:28,580 --> 00:30:31,780 Siwezi kufikiria marafiki wowote ambao kuwa na majina zaidi ya wahusika 64, 637 00:30:31,780 --> 00:30:34,810 na hata kama kwamba ni fupi mno unaweza hakika mapema it up kiholela. 638 00:30:34,810 --> 00:30:37,330 >> Hivyo varchar ni kutofautiana idadi ya chars. 639 00:30:37,330 --> 00:30:41,010 Nakala sio silika mbaya, na kusema ukweli kwamba aina ya anafanya nini anasema, 640 00:30:41,010 --> 00:30:45,460 lakini uwanja wa maandishi inaweza kuwa kama 65,000 ka angalau. 641 00:30:45,460 --> 00:30:50,790 Kwamba pengine overkill kwa shamba, na kwa kweli, yup, 65535. 642 00:30:50,790 --> 00:30:53,740 Kwamba pengine overkill kwa jina, hivyo tutaweza fimbo, kawaida, 643 00:30:53,740 --> 00:30:56,910 na varchars kwa textual uwanja na hash, pia. 644 00:30:56,910 --> 00:30:59,990 Hash, ni zamu nje, tunaweza kufanya varchar pamoja au kitu kama hicho, 645 00:30:59,990 --> 00:31:03,080 lakini sisi si kuzingatia leo juu ya cryptography huko na namba 646 00:31:03,080 --> 00:31:05,210 ili tupate kweli wanataka kutumia kwa urefu wake. 647 00:31:05,210 --> 00:31:07,430 >> Lakini ngoja kitabu chini na haki. 648 00:31:07,430 --> 00:31:11,280 Unaweza tu moja msingi index kwa meza, 649 00:31:11,280 --> 00:31:16,380 lakini nataka kuomba yoyote ya hizi, sasa, kwa jina la mtumiaji, unaweza kusema? 650 00:31:16,380 --> 00:31:21,980 Nini lazima jina la mtumiaji kuwa na misingi ya hazieleweki uelewa wa chaguzi hizi nne? 651 00:31:21,980 --> 00:31:23,340 Tu kwa majina yao? 652 00:31:23,340 --> 00:31:24,140 >> Watazamaji: Unique. 653 00:31:24,140 --> 00:31:25,100 >> DAVID J. Malan: Hivyo kipekee, haki? 654 00:31:25,100 --> 00:31:28,190 Hivyo ni zamu nje kwamba si tu inaweza kumweleza database, mapema, 655 00:31:28,190 --> 00:31:30,380 hii ni njia ya msingi ya kutambua mashamba. 656 00:31:30,380 --> 00:31:32,990 Unaweza pia kusema hii ni itakuwa uwanja kipekee. 657 00:31:32,990 --> 00:31:34,700 Ni si kwenda kuwa Jambo Mimi kuwategemea, 658 00:31:34,700 --> 00:31:38,490 lakini napenda orodha ya kimsingi kuwa na kwamba kama hali, hivyo 659 00:31:38,490 --> 00:31:42,340 kwamba kama mimi milele walijaribu kujiandikisha watumiaji mbili kwa jina moja, 660 00:31:42,340 --> 00:31:44,360 Mbegu gorofa ya nje si kwenda basi mimi. 661 00:31:44,360 --> 00:31:47,490 Nipate kuwa baadhi ya kanuni za ziada katika PHP kwamba kuzuia kama kiasi, 662 00:31:47,490 --> 00:31:50,640 lakini database, pia, wanaweza kuhakikisha kwamba kamwe kwenda kutokea. 663 00:31:50,640 --> 00:31:53,370 >> Sasa, kama kando, hasa kama unafikiri kuhusu miradi ya mwisho, 664 00:31:53,370 --> 00:31:57,030 kukumbuka ni ripoti kamili na Nakala ni muhimu kabisa kwa kweli. 665 00:31:57,030 --> 00:32:01,080 Kama una database kubwa, si kwa kadhaa, lakini pamoja na mamia au maelfu 666 00:32:01,080 --> 00:32:05,270 au hata mamilioni ya mashamba, unaweza pia kuwaambia database mapema 667 00:32:05,270 --> 00:32:07,980 hii ni uwanja mimi nina kwenda kuwa ya kutafuta juu ya mengi. 668 00:32:07,980 --> 00:32:10,520 Labda jina la mtumiaji wake, labda ni bio, kama wewe ni 669 00:32:10,520 --> 00:32:13,750 kufanya tovuti Facebook-kama kwamba ina aya kwamba mtumiaji kuruhusiwa 670 00:32:13,750 --> 00:32:16,799 kuokoa, na kama unataka kuwaambia database mapema 671 00:32:16,799 --> 00:32:20,090 Mimi nina kwenda kuwa kutafuta kwenye uwanja huu mengi, lakini ni si lazima kipekee, 672 00:32:20,090 --> 00:32:22,800 unaweza bayana kujenga mimi index. 673 00:32:22,800 --> 00:32:27,990 Au, unaweza kusema pia naomba kufanya aina ya upekuzi holela kama amri 674 00:32:27,990 --> 00:32:30,420 au Kudhibiti F, kama wewe ili katika neno Processor, 675 00:32:30,420 --> 00:32:34,184 hivyo unaweza kuangalia masharti holela au substrings katika uwanja huu. 676 00:32:34,184 --> 00:32:36,600 Kwa maneno mengine, sisi ni kupata kwa uhakika katika muhula 677 00:32:36,600 --> 00:32:40,720 ambapo huna kuwa na wasiwasi kuhusu jinsi ya kutekeleza mambo kwa ufanisi. 678 00:32:40,720 --> 00:32:44,540 Wewe tu haja ya kujua nini maamuzi kubuni kufanya hivyo kwamba wewe ni 679 00:32:44,540 --> 00:32:48,470 kutumia zana haki kwa biashara ili kujiinua makala 680 00:32:48,470 --> 00:32:50,380 kwamba watu wengine wamejenga kwa ajili yenu. 681 00:32:50,380 --> 00:32:54,240 Hivyo kwa kurejea, msingi lazima tu kuwa moja, unaweza tu kuwa moja, 682 00:32:54,240 --> 00:32:59,630 na ni jambo wewe ni kufanya kwa kutumia kwa kutambua mashamba ya kipekee. 683 00:32:59,630 --> 00:33:02,710 Kipekee ni sawa katika roho, lakini unaweza mara chache tu matumizi yake, 684 00:33:02,710 --> 00:33:04,530 lakini unataka orodha ya kulazimisha yake. 685 00:33:04,530 --> 00:33:08,050 Ripoti tu ina maana preemptively kasi ya mambo juu katika siku zijazo 686 00:33:08,050 --> 00:33:10,230 ili niweze kutafuta mambo katika uwanja huu. 687 00:33:10,230 --> 00:33:13,700 Na kisha Nakala kamili ujumla kwa aya, au insha, au miili kubwa 688 00:33:13,700 --> 00:33:16,270 Nakala ya ambapo wewe ili pia wanataka kuwa na 689 00:33:16,270 --> 00:33:19,420 kadi pori kama sawa ya nyota. 690 00:33:19,420 --> 00:33:19,920 Haki. 691 00:33:19,920 --> 00:33:22,580 >> Ili kwamba ilikuwa aina ya mengi ya wote mara moja. 692 00:33:22,580 --> 00:33:25,220 Hebu angalia kama hatuwezi distill michache ya makala haya 693 00:33:25,220 --> 00:33:29,540 na kisha kujenga kitu haki rahisi, lakini kwa nguvu. 694 00:33:29,540 --> 00:33:31,380 Hivyo kati ya mengine maamuzi kubuni wewe ni 695 00:33:31,380 --> 00:33:34,005 hatimaye kwenda kuwa ni pamoja mistari ya injini ya hifadhi. 696 00:33:34,005 --> 00:33:37,370 Na napenda tu kufanya kutaja ya hii kwa kutarajia miradi ya mwisho, 697 00:33:37,370 --> 00:33:42,020 na kutarajia hebu say-- hakuna hebu kufanya hili. 698 00:33:42,020 --> 00:33:43,820 Hebu kujenga hii kidogo maombi ya kwanza. 699 00:33:43,820 --> 00:33:48,070 Mimi nina kwenda katika terminal yangu dirisha, na katika hapa si 700 00:33:48,070 --> 00:33:52,500 tu counter.php, ambayo sisi ni sasa kwenda kujikwamua kama hakuna tena germane, 701 00:33:52,500 --> 00:33:54,570 lakini tuna rundo zima ya Directories na hii 702 00:33:54,570 --> 00:33:58,080 ni kwenda kuwa sawa sana katika roho kwa nini utaona katika tatizo kuweka saba. 703 00:33:58,080 --> 00:34:00,980 >> Hivyo tuna Directories tatu pamoja ya umma na templates, ambayo 704 00:34:00,980 --> 00:34:05,040 ni hasa ambapo sisi kushoto mbali juu ya Jumatatu na MVC yetu yote dhana. 705 00:34:05,040 --> 00:34:09,290 Na kwa kurejea, katika umma ni kwenda kwenda faili yoyote kwamba nataka watumiaji kweli 706 00:34:09,290 --> 00:34:12,969 v kuwa na uwezo wa kutembelea katika browser yao kupitia URL. 707 00:34:12,969 --> 00:34:13,502 Kigezo. 708 00:34:13,502 --> 00:34:14,710 Nini sisi kuweka katika templates? 709 00:34:14,710 --> 00:34:17,070 Ni aina gani ya mambo? 710 00:34:17,070 --> 00:34:21,659 Hapakuwa na kiasi lakini wanandoa files angalau siku ya Jumatatu. 711 00:34:21,659 --> 00:34:22,619 Yeah. 712 00:34:22,619 --> 00:34:23,100 >> Watazamaji: Header na footer? 713 00:34:23,100 --> 00:34:24,516 >> DAVID J. Malan: Header na footer. 714 00:34:24,516 --> 00:34:26,679 Hivyo tuna kitu sawa leo, pia. 715 00:34:26,679 --> 00:34:30,330 Sisi tumepewa chache mafaili zaidi lakini Footer naona, Header naona, 716 00:34:30,330 --> 00:34:31,909 na kisha rundo la files nyingine. 717 00:34:31,909 --> 00:34:35,482 Hivyo hii ni sawa ya maoni V MVC, ambayo, 718 00:34:35,482 --> 00:34:37,690 tena, itakuwa kidogo zaidi wazi katika tatizo kuweka saba, 719 00:34:37,690 --> 00:34:40,380 lakini hii ni tu folder mimi nina kuweka mengi ya aesthetics wangu. 720 00:34:40,380 --> 00:34:42,840 mengi ya HTML wangu, mengi ya aina yangu. 721 00:34:42,840 --> 00:34:46,899 Wakati huo huo, pamoja na, ni mwingine directory ambayo ina mafaili hizi tatu 722 00:34:46,899 --> 00:34:48,440 na hebu kuchukua haraka kuangalia hizi. 723 00:34:48,440 --> 00:34:51,699 >> Mimi nina kwenda mbele na kufungua config.php. 724 00:34:51,699 --> 00:34:54,610 Kama ni zamu nje, kiasi kama mapema katika mrefu, 725 00:34:54,610 --> 00:34:57,850 you mkali pamoja CS50 dot h na pset7. 726 00:34:57,850 --> 00:35:00,780 Katika mfano wa leo, wewe kwenda kufanya sawa kwamba 727 00:35:00,780 --> 00:35:03,600 na kuhitaji kauli kwamba ufanisi 728 00:35:03,600 --> 00:35:05,340 pamoja mistari haya kadhaa. 729 00:35:05,340 --> 00:35:08,225 Hivyo kuwa wazi, hii ni faili inayoitwa config.php. 730 00:35:08,225 --> 00:35:09,350 Na taarifa ya nini ni kufanya. 731 00:35:09,350 --> 00:35:11,970 Ni inaonekana kufanya kitu cryptic, kugeuka juu ya ujumbe wa makosa 732 00:35:11,970 --> 00:35:13,680 hivyo kwamba unaweza kuona katika browser. 733 00:35:13,680 --> 00:35:15,860 Ni, basi, inaonekana wanaohitaji files nyingine mbili 734 00:35:15,860 --> 00:35:19,530 hivyo hii ni kama #include katika C, na kisha hii moja hatukuwa kuona, 735 00:35:19,530 --> 00:35:22,720 na tumekuwa kutegemewa, hii zamu ya gari ununuzi kama utendaji kwamba. 736 00:35:22,720 --> 00:35:25,610 >> Hii ina maana mapenzi kuki kutumwa na kurudi. 737 00:35:25,610 --> 00:35:27,290 Hivyo hii ni kwa nini ni ya kuvutia? 738 00:35:27,290 --> 00:35:32,460 Naam, kama sisi kurudi nyuma kwa hii directory na kufungua, kwa mfano, 739 00:35:32,460 --> 00:35:33,741 constance.php. 740 00:35:33,741 --> 00:35:38,840 Taarifa kwamba PHP gani msaada constants, si kabisa kama #define katika C. 741 00:35:38,840 --> 00:35:41,290 Badala yake, literally kusema defined, na notisi 742 00:35:41,290 --> 00:35:44,110 kwamba nimepata kuhifadhiwa katika mapema constants nne katika faili hii. 743 00:35:44,110 --> 00:35:47,020 Moja kwa database ya leo, kwa password yangu, kwa jina la mtumiaji yangu, 744 00:35:47,020 --> 00:35:48,690 na kwa jina la server. 745 00:35:48,690 --> 00:35:51,644 Hivyo hawa ni kweli kwenda kuwa pretty sawa katika tatizo kuweka saba. 746 00:35:51,644 --> 00:35:54,560 Na mwisho, na hii ni ambapo mimi nina kwenda kupata baadhi ya utendaji mzuri 747 00:35:54,560 --> 00:35:59,000 kutoka kwa wafanyakazi, katika functions.php ni kundi la kificho tumekuwa imeandikwa, 748 00:35:59,000 --> 00:36:01,040 na mimi aliiba baadhi ya hii kutokana na tatizo kuweka saba 749 00:36:01,040 --> 00:36:05,920 kwa leo, kwamba hana rundo la mambo na hebu tu kuangalia mmoja wao 750 00:36:05,920 --> 00:36:07,270 hasa. 751 00:36:07,270 --> 00:36:09,720 Kazi hii hapa, swala, ni kwenda kuwa na 752 00:36:09,720 --> 00:36:13,600 PHP kazi sisi kuwaita ili kutekeleza SQL. 753 00:36:13,600 --> 00:36:16,070 wakati iliyopita tulikuwa kutumia phpMyAdmin, lakini kwamba tu 754 00:36:16,070 --> 00:36:18,720 kwa aina ya madhumuni ya kujifunza na madhumuni ya uchunguzi 755 00:36:18,720 --> 00:36:20,494 na kusahau kuweka database yako. 756 00:36:20,494 --> 00:36:22,660 Wakati wewe kweli kutumia yako Mbegu, wewe, mwanadamu, 757 00:36:22,660 --> 00:36:24,100 ni wazi si kwenda kuwa kuunganisha juu ya mtandao 758 00:36:24,100 --> 00:36:25,740 ukurasa kila wakati mtu madaftari. 759 00:36:25,740 --> 00:36:29,870 Wewe ni kwenda kuandika kificho kwamba kuwekeza na deletes watumiaji juu ya mahitaji, 760 00:36:29,870 --> 00:36:32,490 na sisi ni kwenda kufanya hili kwa njia ya kazi ya swala. 761 00:36:32,490 --> 00:36:35,360 Kama mimi sasa kitabu chini, kuna itakuwa makala chache zaidi. 762 00:36:35,360 --> 00:36:37,170 Kuelekeza ni kwenda kuwa kazi tuliandika 763 00:36:37,170 --> 00:36:40,160 kwa wewe kwamba utapata kutuma mtumiaji mwingine URL, 764 00:36:40,160 --> 00:36:43,780 na atatoa ni kazi, kabisa kama tuliona juu ya Jumatatu, kwamba kweli mithili 765 00:36:43,780 --> 00:36:48,000 template, lakini zaidi juu ya haya katika aina ya pset7 ya kutembea mwenyewe kupitia. 766 00:36:48,000 --> 00:36:50,500 Kwa sasa, hebu kwenda mbele na kufanya hili. 767 00:36:50,500 --> 00:36:54,860 >> Napenda kwenda katika mihadhara yangu meza na kuona kwamba kuna sasa hakuna kitu 768 00:36:54,860 --> 00:36:59,640 hapa bado tu, na napenda pia kwenda katika saraka yangu ya umma, ambapo 769 00:36:59,640 --> 00:37:02,780 kuna faili moja tu ndiyo, index.php. 770 00:37:02,780 --> 00:37:06,920 Faili hili inaonekana kuwa super rahisi kwa wakati huu, inaonekana kama hii. 771 00:37:06,920 --> 00:37:09,110 Sana kama jinsi sisi kushoto mbali juu ya Jumatatu. 772 00:37:09,110 --> 00:37:11,945 Mimi wanaohitaji faili hili, config.php, ambayo ni katika 773 00:37:11,945 --> 00:37:15,160 An pamoja directory, ambayo ni katika nukta nukta, wazazi wangu, 774 00:37:15,160 --> 00:37:17,650 na kisha tu utoaji faili hii. 775 00:37:17,650 --> 00:37:18,960 Hivyo kile faili hili ni? 776 00:37:18,960 --> 00:37:24,700 >> Hebu kufungua katika templates yangu form.php, na tutaweza kuona hii. 777 00:37:24,700 --> 00:37:28,500 Super rahisi, inaonekana aina hii ni kwenda kuwasilisha kwa $ _GET au $ _POST. 778 00:37:28,500 --> 00:37:29,320 Haraka sanity hundi. 779 00:37:29,320 --> 00:37:33,760 780 00:37:33,760 --> 00:37:35,690 Halisi kuibua kutafuta faili. 781 00:37:35,690 --> 00:37:36,610 Njia sawa ya mwisho. 782 00:37:36,610 --> 00:37:39,280 Hivyo si kwenda kutumia URL, kama Google gani, ni kwenda kutatua ya kujificha 783 00:37:39,280 --> 00:37:41,030 habari nyuma scenes na ni 784 00:37:41,030 --> 00:37:43,580 kwenda kuwasilisha kwa faili inayoitwa register.php, 785 00:37:43,580 --> 00:37:45,660 na kwamba faili sisi bado imeandikwa 786 00:37:45,660 --> 00:37:47,610 lakini nini hii ni kwenda kuangalia kama ni hii. 787 00:37:47,610 --> 00:37:52,670 >> Kama mimi kwenda kwenye ukurasa tofauti Hii ni nini localhost / index.php inaonekana kama. 788 00:37:52,670 --> 00:37:56,930 Na tena, server ya tu kuchukua index.php. 789 00:37:56,930 --> 00:37:57,910 Kuingia. 790 00:37:57,910 --> 00:37:59,870 Hivyo hiyo ni ambapo sisi ni saa, na kile nataka kufanya 791 00:37:59,870 --> 00:38:02,450 ni kuwa na uwezo wa aina ya mambo kama Daudi, na kisha 792 00:38:02,450 --> 00:38:08,050 simu yangu ya simu, ambayo itakuwa kusema 617-555-1212 kwa sasa, kujiandikisha 793 00:38:08,050 --> 00:38:09,910 na sasa register.php haikupatikana. 794 00:38:09,910 --> 00:38:11,440 Hivyo mimi haja ya kutekeleza hili. 795 00:38:11,440 --> 00:38:13,320 Basi hebu haraka mjeledi kitu kama up hii. 796 00:38:13,320 --> 00:38:18,640 Napenda kwenda katika saraka yangu ya umma na kufanya gedit ya register.php, 797 00:38:18,640 --> 00:38:22,300 na sasa mimi nina kwenda mbele na kuanza PHP mode, kama tulivyofanya Jumatatu, 798 00:38:22,300 --> 00:38:25,430 na tag karibu PHP, na hebu kufanya michache ya mambo. 799 00:38:25,430 --> 00:38:28,336 >> Hivyo moja, najua, kutoka baada ya kuandika aina hiyo, 800 00:38:28,336 --> 00:38:29,960 kwamba mimi unataka kuangalia kwa yafuatayo. 801 00:38:29,960 --> 00:38:35,670 Kama ni tupu, chochote mtumiaji typed katika uwanja jina, basi 802 00:38:35,670 --> 00:38:39,860 Mimi nina kwenda kusema kitu kama kuomba msamaha kukosa jina. 803 00:38:39,860 --> 00:38:42,380 Kuomba msamaha, wakati huo huo, ni si kujengwa katika PHP kitu, 804 00:38:42,380 --> 00:38:45,970 ni kazi tuliandika katika functions.php kwa pset7 805 00:38:45,970 --> 00:38:47,940 ili kuwa na huduma hiyo. 806 00:38:47,940 --> 00:38:53,830 Mwingine kama uwanja mengine ni tupu, idadi, basi mimi nina 807 00:38:53,830 --> 00:38:58,370 kwenda kuomba msamaha kwa user na kusema namba inayokosekana. 808 00:38:58,370 --> 00:38:59,320 Kuokoa faili hii. 809 00:38:59,320 --> 00:39:02,640 >> Sasa hebu kwenda nyuma ya browser yangu, kwenda nyuma ya jukwaa kujaribu tena. 810 00:39:02,640 --> 00:39:04,070 Kujiandikisha. 811 00:39:04,070 --> 00:39:05,090 OK. 812 00:39:05,090 --> 00:39:06,730 Hakuna kilichotokea, ambayo ni nzuri. 813 00:39:06,730 --> 00:39:08,120 Sikuweza kupata ujumbe wa makosa. 814 00:39:08,120 --> 00:39:11,651 Lakini kama badala, hebu upya hii ukurasa, na si kutoa kitu chochote. 815 00:39:11,651 --> 00:39:12,150 Damn it. 816 00:39:12,150 --> 00:39:15,350 817 00:39:15,350 --> 00:39:17,140 Kufanya hivyo. 818 00:39:17,140 --> 00:39:18,810 Kujiandikisha. 819 00:39:18,810 --> 00:39:20,350 Nini mimi kufanya makosa? 820 00:39:20,350 --> 00:39:24,860 Kama tupu, jina $ _POST. 821 00:39:24,860 --> 00:39:26,350 Kusema tena? 822 00:39:26,350 --> 00:39:27,670 >> Oh, bila shaka. 823 00:39:27,670 --> 00:39:30,919 I forgot sehemu muhimu, ambayo ni zinahitaji ("../ pamoja / config.php."). 824 00:39:30,919 --> 00:39:34,210 825 00:39:34,210 --> 00:39:36,460 Mimi haja ya kuwa na upatikanaji wa kuomba msamaha kazi, ambayo 826 00:39:36,460 --> 00:39:37,770 ni kwa nini hakuna kitu kinachotokea. 827 00:39:37,770 --> 00:39:39,460 kazi haina kweli zipo. 828 00:39:39,460 --> 00:39:40,640 Basi hebu jaribu hii tena. 829 00:39:40,640 --> 00:39:42,350 Hebu upya ukurasa, click Daftari. 830 00:39:42,350 --> 00:39:43,060 OK. 831 00:39:43,060 --> 00:39:43,770 Kuna ni. 832 00:39:43,770 --> 00:39:45,700 Hivyo, pato tuko kuona hapa ni matokeo 833 00:39:45,700 --> 00:39:47,685 wito kuomba msamaha kazi, super rahisi, 834 00:39:47,685 --> 00:39:50,060 na ni tu Prints nje chochote Mimi kuwapa kama hoja. 835 00:39:50,060 --> 00:39:51,370 >> Haki zote, hivyo hebu kushirikiana. 836 00:39:51,370 --> 00:39:54,240 Hebu kutoa jina langu kama Daudi, kujiandikisha, 837 00:39:54,240 --> 00:39:56,890 kukosa simu OK hebu kutoa kwamba, pia. 838 00:39:56,890 --> 00:39:58,650 617-555-1212. 839 00:39:58,650 --> 00:39:59,250 Kujiandikisha. 840 00:39:59,250 --> 00:39:59,750 OK. 841 00:39:59,750 --> 00:40:02,760 Hivyo wote ni vizuri sasa, kitu tu kuvutia kinachotokea. 842 00:40:02,760 --> 00:40:06,000 Hivyo sasa hebu kufanya kitu zaidi kuvutia kutokea kama hii. 843 00:40:06,000 --> 00:40:09,980 Napenda kwenda katika phpMyAdmin, na hebu kweli kujenga meza inayoitwa watumiaji, 844 00:40:09,980 --> 00:40:12,330 Mimi nina kwenda kuwapa tatu nguzo, na mimi itabidi haraka 845 00:40:12,330 --> 00:40:16,250 kujenga ID, na kisha jina, na kisha posta, 846 00:40:16,250 --> 00:40:18,832 na uwanja ID mimi nina ataondoka kama int. 847 00:40:18,832 --> 00:40:20,790 uwanja jina mimi nina kwenda kuondoka kama varchar, 848 00:40:20,790 --> 00:40:23,257 na tutaweza kusema 64, kiasi fulani kiholela. 849 00:40:23,257 --> 00:40:25,090 idadi mimi nina kwenda kufanya, unajua nini? 850 00:40:25,090 --> 00:40:27,350 Tunakwenda katika kusaidia namba Marekani hapa, 851 00:40:27,350 --> 00:40:31,510 hivyo mimi nina kwenda kufanya kitu kama Char na kisha wahusika 10 852 00:40:31,510 --> 00:40:34,540 max kwa ajili ya eneo kificho na kisha tatu saba. 853 00:40:34,540 --> 00:40:37,870 Na kisha juu hapa, mimi nina kwenda bayana auto nyongeza uwanja huu, 854 00:40:37,870 --> 00:40:40,550 kufanya hii muhimu ya msingi, na Mimi nina kwenda mbele na si 855 00:40:40,550 --> 00:40:42,240 kuangalia yoyote ya masanduku hayo mengine. 856 00:40:42,240 --> 00:40:48,030 >> Hivyo wakati mimi sasa hatimaye bonyeza Save, na mimi kurejea watumiaji yangu meza, 857 00:40:48,030 --> 00:40:52,270 hii ni inaonekana kama kama kile sasa bonyeza muundo Tab Mpya. 858 00:40:52,270 --> 00:40:54,550 Hivyo hii, kuwa wazi, ni njia tu phpMyAdmin ya 859 00:40:54,550 --> 00:40:58,570 ya kusema Mbegu yako meza ina ID, jina, na idadi 860 00:40:58,570 --> 00:41:02,040 na mazungumzo hayo hasa na tutaweza kupuuza mapumziko ya mashamba 861 00:41:02,040 --> 00:41:03,140 huko kwa sasa. 862 00:41:03,140 --> 00:41:04,810 >> Hivyo sasa nini nataka kufanya? 863 00:41:04,810 --> 00:41:09,060 Hivyo kama mimi kwenda sasa katika wangu chanzo code, ikiwa wote ni vizuri 864 00:41:09,060 --> 00:41:11,190 Nataka nitafanya swala yafuatayo. 865 00:41:11,190 --> 00:41:14,970 Kuingiza ndani, na naweza tu kusema watumiaji mimi si madhubuti 866 00:41:14,970 --> 00:41:18,620 haja ya wale nyuma ticks kama ni si neno hatari kama watumiaji. 867 00:41:18,620 --> 00:41:22,810 Mimi nina kwenda kusema jina, idadi, na kisha hapa mimi nina 868 00:41:22,810 --> 00:41:24,960 si kwenda kificho kwa bidii tarakimu ya maadili bado. 869 00:41:24,960 --> 00:41:26,760 Mimi nina kwenda kuweka alama swali mbili. 870 00:41:26,760 --> 00:41:29,320 Na hii ni mkataba katika lugha nyingi 871 00:41:29,320 --> 00:41:31,730 ambapo kama unataka kuwa placeholder kwa kamba 872 00:41:31,730 --> 00:41:34,105 wewe ni kwenda kutumia swali alama, kwa sababu tutaweza 873 00:41:34,105 --> 00:41:36,370 kurudi kuzungumza kuhusu usalama, na hapa 874 00:41:36,370 --> 00:41:39,420 Mimi nina kwenda kupita katika wale mashamba mbili baada ya jina, 875 00:41:39,420 --> 00:41:44,850 na kisha baada ya simu, na sasa kuokoa faili. 876 00:41:44,850 --> 00:41:47,090 >> Na sasa mimi nina kwenda kwenda chini hapa ni super 877 00:41:47,090 --> 00:41:55,690 tu kusema rendersuccess.php, ambayo ni kwenda kuwa na template mwingine. 878 00:41:55,690 --> 00:41:57,380 Mimi nina kwenda kujenga kweli kasi. 879 00:41:57,380 --> 00:42:06,270 Geditsuccess.php na mimi nina kwenda tu kusema H1 mafanikio katika faili hilo. 880 00:42:06,270 --> 00:42:06,990 Wote haki. 881 00:42:06,990 --> 00:42:11,312 Hivyo sasa, hebu kwenda nyuma browser, ambapo mimi alitembelea kabla. 882 00:42:11,312 --> 00:42:14,270 Hebu kwenda mbele na kuthibitisha niliandika katika David, mimi aliandika katika idadi ya simu, 883 00:42:14,270 --> 00:42:15,390 kujiandikisha. 884 00:42:15,390 --> 00:42:16,100 Damn it. 885 00:42:16,100 --> 00:42:17,420 Nini mimi kufanya makosa? 886 00:42:17,420 --> 00:42:20,850 Hivyo mimi nina kuona makosa hapa, kuwa makosa katika SQL syntax yako. 887 00:42:20,850 --> 00:42:24,900 Napenda kuruka nyuma gedit, basi mimi kwenda nyuma register.php, 888 00:42:24,900 --> 00:42:28,830 na nini mimi saza kwamba Ilikuwa ni muhimu wakati wa mwisho? 889 00:42:28,830 --> 00:42:29,722 Mimi haja hii. 890 00:42:29,722 --> 00:42:32,930 Unataka kujua kwamba wengine kuliko kutoka kuwa niliona kabla, lakini mimi haja hii. 891 00:42:32,930 --> 00:42:35,596 >> Hivyo sasa hebu kwenda nyuma, na hii ilikuwa na manufaa kwa kuona katika browser 892 00:42:35,596 --> 00:42:37,680 na kwamba ni kwa nini katika config.php sisi mate nje makosa. 893 00:42:37,680 --> 00:42:41,770 Hebu kwenda mbele na Reload, bofya Endelea, mafanikio. 894 00:42:41,770 --> 00:42:47,060 Hivyo sasa napenda kwenda juu na yangu Mbegu hapa na bonyeza Watumiaji, 895 00:42:47,060 --> 00:42:51,680 na kuvinjari, na taarifa mimi sasa kuwa Daudi katika database yangu hapa. 896 00:42:51,680 --> 00:42:55,810 Sasa kitaalam tovuti hii ni bado kwenye mtandao wa umma, 897 00:42:55,810 --> 00:42:57,890 hivyo siwezi kuwa na mengine watu katika kuweka hapa, 898 00:42:57,890 --> 00:43:01,120 lakini kama mimi sasa alitaka, kwa mfano, kutuma ujumbe wa maandishi mwenyewe. 899 00:43:01,120 --> 00:43:03,920 Hebu kwenda nje ya kiungo hapa na kuona kama hii kweli kazi. 900 00:43:03,920 --> 00:43:07,331 Mimi nina kwenda mbele na kufuta safu hii 901 00:43:07,331 --> 00:43:09,080 na tutaweza blur hii nje katika video baadaye 902 00:43:09,080 --> 00:43:11,900 hivyo hatuna biashara nzima texting yangu, 903 00:43:11,900 --> 00:43:17,270 na sisi sasa kwenda hadi browser na tutaweza kwenda juu kwa hotuba 904 00:43:17,270 --> 00:43:22,040 na tutaweza aina katika tofauti idadi hapa, kujiandikisha, mafanikio. 905 00:43:22,040 --> 00:43:25,550 >> Hivyo sasa, idadi yangu mwenyewe ni labda katika database, na sasa ni sehemu ya kujifurahisha. 906 00:43:25,550 --> 00:43:28,774 Hebu kweli matumizi PHP kufanya kitu programmatically, 907 00:43:28,774 --> 00:43:30,940 ama kutoka amri line au kutoka mahali pengine, 908 00:43:30,940 --> 00:43:32,773 na kwa sasa mimi nina tu kwenda kushika ni rahisi 909 00:43:32,773 --> 00:43:36,230 na mimi nina kwenda katika wangu directory hapa na kufanya yafuatayo. 910 00:43:36,230 --> 00:43:44,920 Gedit script hebu sema, tutaweza kuiita maandishi, #! / user / bin / env PHP, 911 00:43:44,920 --> 00:43:46,700 kama tuliona wakati wa mwisho. 912 00:43:46,700 --> 00:43:47,950 PHP. 913 00:43:47,950 --> 00:43:55,055 >> Sasa mimi nina kwenda kufanya zinahitaji pamoja config.php, 914 00:43:55,055 --> 00:43:57,360 ingawa nguvu hii kutumika makosa kidogo. 915 00:43:57,360 --> 00:44:03,960 Na sasa mimi nina kwenda mbele na kusema safu, swala, kuchagua nyota kutoka kwa watumiaji, 916 00:44:03,960 --> 00:44:08,149 na sasa hapa mimi nina kwenda kufanya mbinu kutoka wakati wa mwisho kwa kila safu kama mfululizo. 917 00:44:08,149 --> 00:44:09,690 Na mimi nina kwenda kufanya kitu rahisi. 918 00:44:09,690 --> 00:44:19,090 Printf hebu sema jina ni hii, na idadi ni hii, backslash n. 919 00:44:19,090 --> 00:44:23,320 Na sasa mimi nina kwenda kupita katika mstari kunukuu jina unquote, 920 00:44:23,320 --> 00:44:28,140 na mstari quote unquote posta, na sasa hebu kwenda mbele 921 00:44:28,140 --> 00:44:31,430 na terminal dirisha yangu chmod + x a hii kufanya 922 00:44:31,430 --> 00:44:33,970 script hii inaitwa Nakala kutekelezwa. 923 00:44:33,970 --> 00:44:36,080 Na sasa hebu kukimbia maandishi. 924 00:44:36,080 --> 00:44:37,590 >> OK, hivyo maendeleo. 925 00:44:37,590 --> 00:44:39,960 Hivyo nimekuwa sasa imeandikwa a mstari amri script, 926 00:44:39,960 --> 00:44:43,300 katika lugha inayoitwa PHP, kwamba, sababu ya kwamba zinahitaji line, 927 00:44:43,300 --> 00:44:46,380 ina kupata kwa wale wote Configuration constants kwamba mimi maalum. 928 00:44:46,380 --> 00:44:48,177 jina la database na kadhalika. 929 00:44:48,177 --> 00:44:50,260 Kwa kweli, tu kuwa wazi kwamba hii si fluke, 930 00:44:50,260 --> 00:44:54,730 basi mimi kwenda mbele na kujiandikisha, kweli kasi, mtu mwingine kama Rob 931 00:44:54,730 --> 00:44:58,890 Nitawapa idadi 555-1212. 932 00:44:58,890 --> 00:45:01,557 >> Na sasa, kama mimi kukimbia script tena, taarifa ya nguvu 933 00:45:01,557 --> 00:45:03,140 ya nini sisi ni kufanya na database. 934 00:45:03,140 --> 00:45:07,680 Sasa nimekuwa mara moja kuona nini mengine safu mbili katika database yangu. 935 00:45:07,680 --> 00:45:10,699 Hivyo sasa hebu jaribu kufanya kitu hata fancier ndani ya, 936 00:45:10,699 --> 00:45:12,740 na hii ni sehemu tumekuwa si kupimwa mapema, 937 00:45:12,740 --> 00:45:15,910 hivyo mara ya mwisho mimi alifanya hivyo mambo akaenda horribly awry, 938 00:45:15,910 --> 00:45:17,120 tuna video na athari hiyo. 939 00:45:17,120 --> 00:45:18,286 >> Kweli, yeah, funny kando. 940 00:45:18,286 --> 00:45:20,480 Hivyo mara ya mwisho, katika hotuba kama miaka miwili iliyopita, 941 00:45:20,480 --> 00:45:23,230 tuliamua, niliamua, kuwa yote hii itakuwa ni wazo kubwa 942 00:45:23,230 --> 00:45:28,150 dynamically kuzalisha barua pepe katika darasa, kwa kutumia database nzima CS50 943 00:45:28,150 --> 00:45:33,390 wanafunzi, ambaye alikuwa ametupa idadi yao na Mkono flygbolag yao ambayo 944 00:45:33,390 --> 00:45:36,290 wapate kukumbuka kutoka pset0, jinsi ya kufikiri, ni zamu nje 945 00:45:36,290 --> 00:45:40,650 Mimi nilikuwa mdudu mdogo katika mpango wangu na alifanya makosa kadhaa katika 2012, nadhani. 946 00:45:40,650 --> 00:45:43,997 >> Ambapo, moja nilikuwa kwa kitanzi kwamba alifanya hasa aina hii ya kitu, 947 00:45:43,997 --> 00:45:46,580 iterating juu ya database, kupata jina kutoka orodha, 948 00:45:46,580 --> 00:45:49,940 jina kutoka orodha, na kisha juu ya kila iteration ya kitanzi mimi alimtuma email. 949 00:45:49,940 --> 00:45:54,130 Lakini badala ya kutuma barua pepe moja, mimi alimtuma moja email iteration kwanza, 950 00:45:54,130 --> 00:45:58,200 na barua pepe mbili iteration pili, alimtuma barua pepe tatu iteration pili, ambayo 951 00:45:58,200 --> 00:46:01,230 kama unaweza kukumbuka kutoka wetu mjadala wa nukuu asymptotic 952 00:46:01,230 --> 00:46:06,400 O hii kubwa ya mbaya, kama n mraba ni wangapi ujumbe mimi alimtuma, 953 00:46:06,400 --> 00:46:08,560 lakini haikuwa hata barua pepe ilikuwa ujumbe wa maandishi. 954 00:46:08,560 --> 00:46:12,070 >> Na kama unajua, mahudhurio ni si super juu ya kutolewa mwisho wa muhula 955 00:46:12,070 --> 00:46:15,360 na hivyo mimi walidhani itakuwa cute katika wakati wa kusema, "Kwa nini si darasani wewe?" 956 00:46:15,360 --> 00:46:17,880 Katika ujumbe wa maandishi mimi alimtuma darasa zima, 957 00:46:17,880 --> 00:46:22,140 na ilikuwa funny na kama 50% ya darasa, lakini wengine 50%, ambao baadhi yao 958 00:46:22,140 --> 00:46:26,102 freaked nje, i alimtuma incredibly kuomba msamaha maelezo tamu 959 00:46:26,102 --> 00:46:28,560 kwa wafanyakazi kuomba msamaha kwa kuwa amekosa hotuba tu 960 00:46:28,560 --> 00:46:29,530 hii mara moja, haki? 961 00:46:29,530 --> 00:46:32,790 962 00:46:32,790 --> 00:46:34,030 >> Hivyo kwamba ingekuwa horribly awry. 963 00:46:34,030 --> 00:46:37,030 Hivyo katika roho kwamba, hebu jaribu hii tena lakini tu na idadi wangu. 964 00:46:37,030 --> 00:46:41,940 Mapema, katika functions.php, Nimekuwa imeandikwa kazi hii hapa. 965 00:46:41,940 --> 00:46:44,250 Ni wito wa maandishi, na inachukua katika hoja ya tatu. 966 00:46:44,250 --> 00:46:46,360 idadi, carrier, na ujumbe. 967 00:46:46,360 --> 00:46:50,390 >> Mimi nina kutumia kubadili kauli, ambayo ajabu PHP kuchukua masharti, si tu 968 00:46:50,390 --> 00:46:53,350 integers, na mimi haikutekeleza msaada wote kwa hii bado, 969 00:46:53,350 --> 00:46:55,370 Mimi tumefanya tu AT & T na Verizon. 970 00:46:55,370 --> 00:46:57,610 Kwa sababu ni zamu nje kwamba pamoja na hayo flygbolag 971 00:46:57,610 --> 00:47:00,570 wana email SMS gateways, ambapo unaweza kweli 972 00:47:00,570 --> 00:47:05,529 kutuma barua pepe kwa anwani kama namba ya simu katika vtext.com 973 00:47:05,529 --> 00:47:08,070 na kama mtumiaji hana imefungwa ujumbe, utakuwa kwenda kupitia 974 00:47:08,070 --> 00:47:09,340 ni ujumbe wa maandishi. 975 00:47:09,340 --> 00:47:13,270 >> Sasa kwa kufanya hivyo, mimi nina kwenda kuwa na kuongeza shamba moja kweli kwa haraka na orodha yangu. 976 00:47:13,270 --> 00:47:15,470 Mimi nina kwenda katika Muundo yangu, na mimi nina 977 00:47:15,470 --> 00:47:21,880 kwenda mbele na kuongeza uwanja mwishoni mwa meza. 978 00:47:21,880 --> 00:47:25,227 Hebu bonyeza Go, na mimi nina kwenda kuwaita carrier hii 979 00:47:25,227 --> 00:47:27,310 na kwa sasa mimi nina kwenda kuondoka hii kama bar maandishi, 980 00:47:27,310 --> 00:47:29,320 lakini tunaweza kuwa fancier katika siku zijazo. 981 00:47:29,320 --> 00:47:31,961 Mimi nina kwenda haraka kwenda ndani ya meza yangu, na mimi nina 982 00:47:31,961 --> 00:47:34,210 kwenda kujikwamua Rob, kwa sababu hiyo ni idadi bandia, 983 00:47:34,210 --> 00:47:38,540 Mimi nina kwenda katika hariri hapa na mimi nina kwenda na mabadiliko carrier yangu manually 984 00:47:38,540 --> 00:47:43,410 kuwa Verizon, ambayo ni ni, na sasa zaidi ya hapa. 985 00:47:43,410 --> 00:47:44,980 >> Hebu kufanya haraka sanity hundi. 986 00:47:44,980 --> 00:47:52,730 Hebu kufungua andiko letu script, ambayo Inaonekana kama hii, carrier ni% s. 987 00:47:52,730 --> 00:47:58,230 Sisi ni kufanya makosa mengi zaidi kuangalia zaidi kuliko mimi mwaka 2012, carrier. 988 00:47:58,230 --> 00:48:01,160 Na sasa, mimi nina kwenda mbele na re-kukimbia script. 989 00:48:01,160 --> 00:48:01,660 OK. 990 00:48:01,660 --> 00:48:06,100 Carrier ni Verizon, ambayo ina maana sasa hopefully naweza kufanya tu hii. 991 00:48:06,100 --> 00:48:08,360 Usahihi mwaka huu, hopefully, hapa sisi kwenda. 992 00:48:08,360 --> 00:48:12,200 >> Hivyo ndani ya hii kwa kitanzi, mimi nina kwenda si tu kuwa printf hii, 993 00:48:12,200 --> 00:48:15,990 Mimi pia kwenda kuwaita maandishi na matumizi ya hii wanakumbuka kazi 994 00:48:15,990 --> 00:48:19,670 ilikuwa inachukua posta, carrier, na ujumbe. 995 00:48:19,670 --> 00:48:23,310 Basi hebu angalia, idadi ni kwenda kuwa mstari quote unquote "idadi" 996 00:48:23,310 --> 00:48:31,660 mstari quote unquote "carrier," na moja ya mwisho ilikuwa ujumbe. 997 00:48:31,660 --> 00:48:36,250 Je, si screw up mwaka huu, semicolon. 998 00:48:36,250 --> 00:48:36,780 >> OK. 999 00:48:36,780 --> 00:48:38,280 Vidole walivuka. 1000 00:48:38,280 --> 00:48:39,970 Hebu angalia kama hii kazi. 1001 00:48:39,970 --> 00:48:41,720 Haki wote, hivyo. 1002 00:48:41,720 --> 00:48:43,000 Hapa sisi kwenda. 1003 00:48:43,000 --> 00:48:47,380 Hebu kufungua simu, kuvuka vidole, damn it. 1004 00:48:47,380 --> 00:48:50,300 Kisichojulikana variable may-- oh kusubiri, kusubiri, kusubiri, halisi haraka. 1005 00:48:50,300 --> 00:48:51,340 Halisi haraka, halisi haraka. 1006 00:48:51,340 --> 00:48:53,380 Hii ni kabisa thamani yake. 1007 00:48:53,380 --> 00:48:57,710 Napenda kunyakua, napenda kunyakua, uh-oh. 1008 00:48:57,710 --> 00:48:59,965 Asante, maandiko na ilianza kutoka mtu mwingine. 1009 00:48:59,965 --> 00:49:04,770 1010 00:49:04,770 --> 00:49:11,650 Basi mimi kwenda mbele na kufungua halisi haraka, dropbox.php / mail hapa. 1011 00:49:11,650 --> 00:49:12,660 Kusubiri. 1012 00:49:12,660 --> 00:49:14,455 Kabisa thamani yake. 1013 00:49:14,455 --> 00:49:17,430 Mkono. 1014 00:49:17,430 --> 00:49:18,560 OK, chanzo src8m. 1015 00:49:18,560 --> 00:49:19,700 OK. 1016 00:49:19,700 --> 00:49:21,380 >> Haja moja zaidi line hapa. 1017 00:49:21,380 --> 00:49:24,530 Oh kuna ni, ni katika Frosh IMS, ni katika daftari saa tatu. 1018 00:49:24,530 --> 00:49:28,820 Oh hello, Margo, asante sana. 1019 00:49:28,820 --> 00:49:31,130 OK, na mimi nilikuwa kukosa mstari huu hapa. 1020 00:49:31,130 --> 00:49:33,010 Hivyo basi mimi haraka kunyakua mstari wa kanuni, 1021 00:49:33,010 --> 00:49:36,200 ambayo ni pamoja na barua au maktaba kwamba mimi kwa kweli wanataka kutumia, 1022 00:49:36,200 --> 00:49:38,300 Mimi nina kwenda haraka kurudi nyuma katika kazi, 1023 00:49:38,300 --> 00:49:42,337 Mimi nina kwenda juu ya hii faili na kuhitaji faili hili pia, 1024 00:49:42,337 --> 00:49:45,420 na sasa mimi nina kwenda kweli kuvuka yangu vidole wakati mimi kurejea amri 1025 00:49:45,420 --> 00:49:49,530 line script, ambayo ni ndani ya jeshi directory ya leo mitaa. 1026 00:49:49,530 --> 00:49:50,610 Kukimbia maandishi. 1027 00:49:50,610 --> 00:49:52,720 Kuingia. 1028 00:49:52,720 --> 00:49:53,220 Barua. 1029 00:49:53,220 --> 00:49:53,719 Kusubiri. 1030 00:49:53,719 --> 00:49:58,850 1031 00:49:58,850 --> 00:49:59,600 Kusubiri. 1032 00:49:59,600 --> 00:50:01,680 Barua. 1033 00:50:01,680 --> 00:50:02,290 Oh, sawa. 1034 00:50:02,290 --> 00:50:03,870 Hapa sisi kwenda. 1035 00:50:03,870 --> 00:50:06,880 >> Barua anapata mpya PHP mailer. 1036 00:50:06,880 --> 00:50:09,970 Je, mimi kufanya haki hii? 1037 00:50:09,970 --> 00:50:11,067 Damn it. 1038 00:50:11,067 --> 00:50:12,150 To-- oh, kusubiri, kusubiri, kusubiri. 1039 00:50:12,150 --> 00:50:12,649 Kusimama kwa. 1040 00:50:12,649 --> 00:50:15,820 1041 00:50:15,820 --> 00:50:18,630 Mimi ahadi, hii ni itakuwa hivyo thamani yake. 1042 00:50:18,630 --> 00:50:20,340 Eneo. 1043 00:50:20,340 --> 00:50:24,390 Hii ni kwa nini mimi si kufanya Mifano haki kabla ya darasa. 1044 00:50:24,390 --> 00:50:26,350 Ugh. 1045 00:50:26,350 --> 00:50:27,910 wapokeaji zifuatazo alishindwa. 1046 00:50:27,910 --> 00:50:31,500 1047 00:50:31,500 --> 00:50:33,040 Hebu jaribu jambo moja iliyopita. 1048 00:50:33,040 --> 00:50:40,660 SMTP kuweka kutoka, kuongeza mitaani, anwani ni kweli kwamba. 1049 00:50:40,660 --> 00:50:43,980 Hebu jaribu hii sehemu ya mwisho katika eneo. 1050 00:50:43,980 --> 00:50:47,210 Aw, mimi nina kweli kusikitisha hivi sasa. 1051 00:50:47,210 --> 00:50:47,854 Asante. 1052 00:50:47,854 --> 00:50:50,270 Lakini mimi kwa kweli kufahamu yote maandiko tumekuwa kutuma. 1053 00:50:50,270 --> 00:50:53,130 1054 00:50:53,130 --> 00:50:56,320 Nimepata hii Daudi. 1055 00:50:56,320 --> 00:50:59,310 Wewe ni kupiga yake. 1056 00:50:59,310 --> 00:51:01,720 Hebu kuondoka humo na sisi kurekebisha juu ya Jumatatu. 1057 00:51:01,720 --> 00:51:04,290 Tazama wewe hapo. 1058 00:51:04,290 --> 00:51:08,090 >> DAVEN FARNHAM: Na sasa Deep Mawazo na Daven Farnham. 1059 00:51:08,090 --> 00:51:11,340 1060 00:51:11,340 --> 00:51:17,590 Kama mti binary iko katika msitu na hakuna mtu ni karibu na C it-- [chuckling]. 1061 00:51:17,590 --> 00:51:18,998