1 00:00:00,000 --> 00:00:10,075 >> [Music kucheza] 2 00:00:10,075 --> 00:00:11,629 3 00:00:11,629 --> 00:00:14,420 ALLISON BUCHHOLTZ-AU: All haki, kila mtu, kuwakaribisha nyuma na sehemu ya. 4 00:00:14,420 --> 00:00:17,420 Hopefully wote walikuwa kubwa Halloween mwishoni mwa wiki, au Halloweekend, 5 00:00:17,420 --> 00:00:20,009 kama mimi kama kusema, kila ulipatikana na zinalipwa. 6 00:00:20,009 --> 00:00:21,675 Na nashiriki siyo snowing tena. 7 00:00:21,675 --> 00:00:23,230 Ni kweli jua nje. 8 00:00:23,230 --> 00:00:25,040 Mimi nilikuwa kweli furaha kuhusu hilo. 9 00:00:25,040 --> 00:00:28,420 Si tayari Drag nje baridi buti wangu. 10 00:00:28,420 --> 00:00:31,820 Hopefully, pset6 akaenda pretty vizuri. 11 00:00:31,820 --> 00:00:35,040 >> Kama wewe ni uchovu wa C, mimi nina furaha kusema wewe ni kosa na C kwa sasa. 12 00:00:35,040 --> 00:00:37,550 Tuna transitioned kikamilifu ndani ya programu ya mtandao, 13 00:00:37,550 --> 00:00:42,030 hivyo wewe utakuwa kufanya kazi katika HTML, PHP, labda kidogo ya JavaScript. 14 00:00:42,030 --> 00:00:44,650 Sijui nini wiki ijayo pset ni, hivyo siwezi kuthibitisha 15 00:00:44,650 --> 00:00:47,820 nini pset yako ijayo itakuwa kuwa, lakini pset wiki hii 16 00:00:47,820 --> 00:00:52,290 ni CS50 Fedha, ambayo kimsingi ni kutekeleza aina ya mtandao ukurasa 17 00:00:52,290 --> 00:00:57,222 kwamba utapata kununua na kuuza hisa, na kuweka wimbo wao. 18 00:00:57,222 --> 00:00:59,930 Na ni pretty baridi, kwa sababu wote yake ni dynamically yanayotokana. 19 00:00:59,930 --> 00:01:02,320 Unaweza kuwa watumiaji mbalimbali ambao kila mmoja kuwa habari zao wenyewe, 20 00:01:02,320 --> 00:01:04,580 na wewe ni kwenda kuwa na kutekeleza yote. 21 00:01:04,580 --> 00:01:05,970 Inachukua muda. 22 00:01:05,970 --> 00:01:13,030 Mimi dhahiri kufikiri hii ni rahisi kuliko C psets, lakini inachukua muda mrefu. 23 00:01:13,030 --> 00:01:17,370 Wewe ni kujifunza lugha mpya, PHP, ambayo ni sawa na C, 24 00:01:17,370 --> 00:01:21,390 lakini bila shaka ni kwenda zinahitaji wewe kuangalia juu syntax na kuelewa 25 00:01:21,390 --> 00:01:23,360 jinsi ya kubadilisha kati ya lugha. 26 00:01:23,360 --> 00:01:27,960 >> Lakini sidhani kuna kitu chochote super conceptually ngumu kuhusu pset hii. 27 00:01:27,960 --> 00:01:30,087 Ni kujifunza tu lugha mpya na kupata 28 00:01:30,087 --> 00:01:31,420 kupitia vipande haya yote kidogo. 29 00:01:31,420 --> 00:01:34,850 Kama wewe guys kuwa na kusoma kupitia spec, ni pretty muda mrefu. 30 00:01:34,850 --> 00:01:38,200 Nadhani hii ni moja ya kama 21 kurasa, kama mimi kukumbuka kwa usahihi. 31 00:01:38,200 --> 00:01:40,130 Ni spec kwa muda mrefu. 32 00:01:40,130 --> 00:01:42,218 Hivyo kama wewe si kusoma it-- 22. 33 00:01:42,218 --> 00:01:43,520 32. 34 00:01:43,520 --> 00:01:44,410 >> Wow. 35 00:01:44,410 --> 00:01:46,280 Hivyo nilikuwa mbali na 50% huko. 36 00:01:46,280 --> 00:01:48,550 Hivyo, 32 kurasa. 37 00:01:48,550 --> 00:01:49,820 Hivyo ni muda mrefu. 38 00:01:49,820 --> 00:01:54,070 Kuna kura ya vipande, lakini hakuna vipande lazima kuwa mbaya. 39 00:01:54,070 --> 00:01:55,650 Ni tu mengi. 40 00:01:55,650 --> 00:02:00,310 Hivyo kupata kuanza mapema dhahiri kama inawezekana, kama kwa kawaida, 41 00:02:00,310 --> 00:02:05,480 lakini nadhani ni lazima kujisikia kidogo nicer kuliko hasa psets kama 42 00:02:05,480 --> 00:02:10,250 kuokoa na resize kwamba ni tu ngumu sana wrap kichwa yako karibu. 43 00:02:10,250 --> 00:02:12,550 >> Hivyo, pamoja na kwamba, tunakwenda kupiga mbizi katika. 44 00:02:12,550 --> 00:02:14,840 Sina ajenda yako slide leo, lakini sisi ni 45 00:02:14,840 --> 00:02:17,920 itakuwa kuzungumza juu ya PHP. 46 00:02:17,920 --> 00:02:20,790 Mimi itakuwa kutoa aina ya ajali ya shaka juu ya baadhi ya mambo 47 00:02:20,790 --> 00:02:23,040 kwamba unaweza kutaka kujua kuhusu PHP. 48 00:02:23,040 --> 00:02:26,470 Tofauti syntax mambo, mambo ya kuangalia nje kwa. 49 00:02:26,470 --> 00:02:29,400 Tunakwenda kuwa na kuzungumza kidogo kuhusu SQL. 50 00:02:29,400 --> 00:02:33,020 Mambo tu rahisi sana huko, na kisha pia MVC 51 00:02:33,020 --> 00:02:36,380 ni Model Mtazamo Mdhibiti, ambayo ni jinsi pset yako ni kuanzisha, 52 00:02:36,380 --> 00:02:39,801 hivyo kuelewa jinsi ya kuwa kazi itakuwa super muhimu. 53 00:02:39,801 --> 00:02:40,300 Wote haki. 54 00:02:40,300 --> 00:02:42,030 Hivyo PHP. 55 00:02:42,030 --> 00:02:45,050 You guys lazima waliofanya kitu sana, rahisi sana 56 00:02:45,050 --> 00:02:48,680 na PHP, ambayo ni jambo hili chini hapa, 57 00:02:48,680 --> 00:02:53,700 ambapo kuwasilishwa fomu baadhi ya juu hapa kwamba alikuwa na baadhi ya jina kwamba wewe 58 00:02:53,700 --> 00:02:58,860 pembejeo, na kusema kama hello, Ben, au hello, Allison, na itakuwa pop up. 59 00:02:58,860 --> 00:03:02,570 Hivyo hii ni nini hasa ni lazima wameweza inaonekana kama kutoka pset yako, 60 00:03:02,570 --> 00:03:06,040 katika kesi wewe guys alitaka kujua au hakuwa kabisa takwimu ni nje. 61 00:03:06,040 --> 00:03:14,520 >> Lakini tuna alama swali haya hapa kwamba zinaonyesha kwamba hii ni PHP. 62 00:03:14,520 --> 00:03:18,850 Wao wrap yake, na kisha htmlspecialcharge, kumbuka, ni tu, 63 00:03:18,850 --> 00:03:22,450 kuhakikisha kwamba wewe ni salama kutoka sindano mashambulizi yoyote mambo 64 00:03:22,450 --> 00:03:26,550 au kama mtu anajaribu kuweka mambo mabaya wahusika 65 00:03:26,550 --> 00:03:30,780 ndani ya uwanja jina lako, haina kama up kompyuta yako au whatnot. 66 00:03:30,780 --> 00:03:37,590 >> Na kisha kama sisi taarifa, hii HTML aina ambayo ilikuwa njia ya $ _GET,, 67 00:03:37,590 --> 00:03:42,050 kama tunakumbuka superglobals wetu kutoka PHP, $ _GET, $ _POST, 68 00:03:42,050 --> 00:03:44,530 tutaweza kuwa kwenda katika wale katika kidogo. 69 00:03:44,530 --> 00:03:50,390 Lakini tunajua kwamba tuna baadhi ya jina hapa kwamba sambamba na jina 70 00:03:50,390 --> 00:03:51,920 kwamba sisi kuwasilishwa. 71 00:03:51,920 --> 00:03:56,930 Hivyo hii ni aina tu ya kama rahisi sana PHP HTML kushirikiana 72 00:03:56,930 --> 00:04:00,080 kwamba wewe guys alikuwa kutoka pset sita. 73 00:04:00,080 --> 00:04:02,410 >> Lakini hiyo haina kweli kujibu nini PHP. 74 00:04:02,410 --> 00:04:04,850 Ni wazi ni lugha, lakini sisi si kweli 75 00:04:04,850 --> 00:04:08,260 aliyesema kuhusu hilo katika sehemu hii, hivyo kuna kidogo zaidi 76 00:04:08,260 --> 00:04:09,740 kuhusu nini PHP kweli ni. 77 00:04:09,740 --> 00:04:14,270 Hivyo PHP PHP ni tu HyperText Preprocessor. 78 00:04:14,270 --> 00:04:16,399 >> Ni kweli kuchukuliwa lugha ya programu 79 00:04:16,399 --> 00:04:20,500 sababu ina mantiki, ambapo kama sisi kumbuka kuzungumza juu ya HTML, 80 00:04:20,500 --> 00:04:24,980 sisi kuitwa kwamba ghafi lugha dhidi ya lugha ya programu kwa sababu HTML 81 00:04:24,980 --> 00:04:27,790 ni madhubuti kubadilisha jinsi mambo kuangalia juu ya ukurasa. 82 00:04:27,790 --> 00:04:30,650 Ni kubadilisha tu kama kitu ni ujasiri, 83 00:04:30,650 --> 00:04:35,280 au kama ni aina, kipengele, au kitu kama hicho. 84 00:04:35,280 --> 00:04:36,750 Haina mantiki yoyote. 85 00:04:36,750 --> 00:04:38,770 Haina loops au masharti. 86 00:04:38,770 --> 00:04:40,940 Huwezi makosa kuangalia mambo. 87 00:04:40,940 --> 00:04:44,810 Ungependa ama kuonyesha mambo kwa njia fulani au kuuliza kwa ajili ya mambo 88 00:04:44,810 --> 00:04:45,490 kutoka kwa mtumiaji. 89 00:04:45,490 --> 00:04:47,180 Hiyo ni. 90 00:04:47,180 --> 00:04:51,780 >> Hivyo pamoja na PHP, ni kweli haina kuruhusu sisi kufanya yote haya mambo mantiki zaidi, 91 00:04:51,780 --> 00:04:56,840 kama kuhalalisha pembejeo au kuendesha katika baadhi ya njia. 92 00:04:56,840 --> 00:05:02,570 Tunaweza kuchanganya pamoja na HTML, kama sisi tu aliona katika pset yako ya mwisho na sasa hivi, 93 00:05:02,570 --> 00:05:05,280 na inaruhusu sisi kujenga hizi nguvu mtandao kurasa. 94 00:05:05,280 --> 00:05:08,900 Hivyo kama wewe guys ever-- Sijui kama ungekuwa kama mimi, lakini katika shule ya kati 95 00:05:08,900 --> 00:05:13,820 walikuwa us kuchukua IT hii darasani ambapo sisi kuundwa tu HTML kurasa za mtandao, 96 00:05:13,820 --> 00:05:20,160 na walikuwa tuli na click kuzunguka na mambo mengine, lakini wao kamwe iliyopita. 97 00:05:20,160 --> 00:05:25,960 >> Na ndio nguvu, nini tunaweza kufanya ni, kama na CS50 Fedha, 98 00:05:25,960 --> 00:05:27,870 wewe ni kwenda kuwa na watumiaji mbalimbali. 99 00:05:27,870 --> 00:05:30,992 Kutegemea wale watumiaji ' upendeleo, na nini re kununua 100 00:05:30,992 --> 00:05:32,700 au nini re kuuza kwa ajili ya hifadhi yao, 101 00:05:32,700 --> 00:05:35,050 wewe kwenda kuonyesha mambo mbalimbali. 102 00:05:35,050 --> 00:05:38,110 Hivyo kama kuna baadhi kutambua tabia 103 00:05:38,110 --> 00:05:41,990 kwa mtumiaji yako kwa kutumia hii mtandao ukurasa, tunaweza dynamically 104 00:05:41,990 --> 00:05:44,720 kuamua nini cha kuonyesha kwa ajili yao. 105 00:05:44,720 --> 00:05:49,720 Ni si kitu kimoja kwa kila moja ni mtu, ambayo kama sisi tu alikuwa HTML, 106 00:05:49,720 --> 00:05:52,400 ukurasa itakuwa sawa kwa kila mtu moja ambaye alitembelea. 107 00:05:52,400 --> 00:05:55,790 PHP inaruhusu sisi kubinafsisha kurasa. 108 00:05:55,790 --> 00:06:01,670 >> Na kisha tunaweza ama kuziweka katika faili moja, ambayo, kama katika kesi 109 00:06:01,670 --> 00:06:06,670 kabla ya hapa, tumeona kwamba tuna HTML hapa 110 00:06:06,670 --> 00:06:09,760 na kisha tuna hii kidogo ya PHP. 111 00:06:09,760 --> 00:06:12,690 Tunaweza kufanya kama kwamba, au na CS50 Fedha, 112 00:06:12,690 --> 00:06:16,310 kama wewe guys inaonekana katika files-- na tunapaswa kuwa na wakati 113 00:06:16,310 --> 00:06:19,541 kwa hatua kupitia wanandoa wao pamoja mwisho wa section-- sisi 114 00:06:19,541 --> 00:06:21,540 unaweza kuona jinsi unaweza kweli kuwaweka tofauti, 115 00:06:21,540 --> 00:06:24,720 ambayo ni kweli jambo bora ya kufanya. 116 00:06:24,720 --> 00:06:26,550 >> Hivyo. 117 00:06:26,550 --> 00:06:27,680 Ajali ya shaka. 118 00:06:27,680 --> 00:06:32,860 Mambo yote ya haraka rahisi unaweza haja ya kujua kwa PHP. 119 00:06:32,860 --> 00:06:34,470 Kutangaza vigezo. 120 00:06:34,470 --> 00:06:37,970 Bluu kwamba ni kidogo annoying, lakini hopefully you guys unaweza kuona. 121 00:06:37,970 --> 00:06:39,850 Kama si, mimi itabidi kuandika juu ya bodi ya chaki. 122 00:06:39,850 --> 00:06:41,370 kutangaza vigezo. 123 00:06:41,370 --> 00:06:46,710 Jambo moja kujua ni kwamba, tofauti na C, PHP ni loosely au dynamically typed, 124 00:06:46,710 --> 00:06:50,870 ambayo ina maana kwamba huna haja ya kuwaambia kutofautiana ni aina gani ni. 125 00:06:50,870 --> 00:06:55,710 Unaweza tu tu kusema baadhi ya kutofautiana ni sawa na chochote unataka kwa, 126 00:06:55,710 --> 00:07:00,440 na itakuwa kuamua aina ya kwamba kutofautiana wakati kukimbia kwa ajili yenu. 127 00:07:00,440 --> 00:07:05,410 >> Kama utaona, hii inaweza kujenga baadhi ya mambo ya kuvutia sana. 128 00:07:05,410 --> 00:07:09,130 Lakini kwa madhumuni ya wengi, hawana haja ya kutaja aina. 129 00:07:09,130 --> 00:07:12,580 Unaweza, na unaweza aina kutupwa mambo kama wewe kawaida 130 00:07:12,580 --> 00:07:15,900 bila kuona kama unataka nguvu kwa kuwa aina fulani, 131 00:07:15,900 --> 00:07:17,090 lakini huna kwa. 132 00:07:17,090 --> 00:07:19,810 Ni si kwenda yell saa wewe kama wewe tu kutangaza variable 133 00:07:19,810 --> 00:07:21,910 na wala kutaja aina kwa ajili yake. 134 00:07:21,910 --> 00:07:25,199 >> Hivyo katika kesi huwezi kusoma this-- Najua ni si bora. 135 00:07:25,199 --> 00:07:28,490 Nilidhani ingekuwa show up better-- njia initialize variable yoyote ni tu 136 00:07:28,490 --> 00:07:31,270 na ishara ya dola, nini unataka kuitwa, 137 00:07:31,270 --> 00:07:33,240 na kisha nini wewe kumshirikisha yake. 138 00:07:33,240 --> 00:07:36,520 Hivyo katika kesi hii, hii ni baadhi var $ = 3. 139 00:07:36,520 --> 00:07:40,450 Hivyo kama sisi milele kutumia $ var mahali fulani, itakuwa tu 140 00:07:40,450 --> 00:07:42,760 kuwa sawa na kuweka 3 huko. 141 00:07:42,760 --> 00:07:43,650 OK? 142 00:07:43,650 --> 00:07:46,480 >> Hivyo, kutofautiana yoyote, tu dola ishara, chochote 143 00:07:46,480 --> 00:07:50,210 unataka simu kutofautiana yako, na chochote unataka kwa sawa. 144 00:07:50,210 --> 00:07:51,430 Kidogo baridi. 145 00:07:51,430 --> 00:07:56,156 Chini ya kuandika kwa initializing kutofautiana, haki? 146 00:07:56,156 --> 00:07:57,530 Je, hiyo mantiki kwa kila mtu? 147 00:07:57,530 --> 00:08:02,280 Tu haraka syntax tofauti kati ya C na PHP. 148 00:08:02,280 --> 00:08:06,440 >> Arrays ni baridi sana katika PHP. 149 00:08:06,440 --> 00:08:09,620 Tunaweza kuwapa funguo. 150 00:08:09,620 --> 00:08:13,180 Hivyo njia ya kufikiria ni kwamba, kama sisi milele 151 00:08:13,180 --> 00:08:16,610 alitaka kupata kipengele ndani ya safu, 152 00:08:16,610 --> 00:08:19,290 sisi zinahitajika kujua ripoti yake, haki? 153 00:08:19,290 --> 00:08:24,290 Hivyo tunajua kwamba pamoja na C, sisi inaweza kupata kipengele kwanza 154 00:08:24,290 --> 00:08:28,650 kwa kufanya safu bracket sifuri, au kama sisi wanataka kipengele kwanza, safu bracket 155 00:08:28,650 --> 00:08:29,360 moja. 156 00:08:29,360 --> 00:08:31,910 Na kama sisi alitaka kitu huko, tupate tu 157 00:08:31,910 --> 00:08:35,850 kuwa iterate kupitia, isipokuwa sisi kweli alijua index. 158 00:08:35,850 --> 00:08:38,320 >> Jambo moja kwamba ni kweli baridi na PHP arrays 159 00:08:38,320 --> 00:08:40,850 ni kwamba wao ni nini sisi kuwaita associative. 160 00:08:40,850 --> 00:08:44,970 Hivyo tunaweza kujiunga baadhi muhimu kwa baadhi ya thamani, 161 00:08:44,970 --> 00:08:47,340 na sisi ni kweli kwenda to-- mimi nitakuonyesha 162 00:08:47,340 --> 00:08:50,370 jinsi gani tunaweza kutumia hii katika pili. 163 00:08:50,370 --> 00:08:54,330 Lakini kimsingi, kama wewe milele unataka initialize safu kama hiyo, 164 00:08:54,330 --> 00:08:56,020 una baadhi ya $ safu. 165 00:08:56,020 --> 00:08:59,622 >> Hivyo katika njia hiyo hiyo, ni tu baadhi ya kutofautiana kwamba sisi ni kujenga. 166 00:08:59,622 --> 00:09:01,330 Hii inaweza kuitwa chochote alitaka. 167 00:09:01,330 --> 00:09:03,310 Hii inaweza kuwa mfano $. 168 00:09:03,310 --> 00:09:04,930 Mwingine tu kutofautiana. 169 00:09:04,930 --> 00:09:09,510 Nini inafanya safu ni bracket syntax kwamba tuna hapa. 170 00:09:09,510 --> 00:09:14,560 Kama kawaida C. Na sisi kuwa na baadhi ya muhimu kwa baadhi ya thamani. 171 00:09:14,560 --> 00:09:19,480 Hivyo key1 inakwenda value1, key2 mbili inakwenda value2. 172 00:09:19,480 --> 00:09:25,080 Jozi hizi ni kutengwa na comma, kama arrays ya kawaida. 173 00:09:25,080 --> 00:09:25,810 >> Hata hivyo. 174 00:09:25,810 --> 00:09:26,520 Moja kubwa. 175 00:09:26,520 --> 00:09:27,270 Funguo ni ya hiari. 176 00:09:27,270 --> 00:09:28,510 Huna kutumia yao. 177 00:09:28,510 --> 00:09:30,850 Na kama huna, basi ni jambo la kawaida tu. 178 00:09:30,850 --> 00:09:32,030 Swali? 179 00:09:32,030 --> 00:09:33,540 Au, oh. 180 00:09:33,540 --> 00:09:37,829 >> Watazamaji: Naam, kuhusu haki. 181 00:09:37,829 --> 00:09:39,120 Ambapo s kumbukumbu kuja kutoka? 182 00:09:39,120 --> 00:09:43,425 Unaweza pia kuwa sawa kama [Inaudible] na kutoka mkusanyiko? 183 00:09:43,425 --> 00:09:45,277 Ni kwamba pia kutumia PHP? 184 00:09:45,277 --> 00:09:46,485 Kama wakati sisi ni kuwaunganisha? 185 00:09:46,485 --> 00:09:49,070 >> ALLISON BUCHHOLTZ-AU: Na PHP, Hatuna huwa 186 00:09:49,070 --> 00:09:52,670 na wasiwasi kuhusu ambapo wetu kumbukumbu kuja kutoka. 187 00:09:52,670 --> 00:09:54,670 Hatuwezi kutumia mengi ya wakati kuzungumza juu ya kwamba, 188 00:09:54,670 --> 00:09:58,450 hivyo si kweli chochote unahitaji na wasiwasi juu. 189 00:09:58,450 --> 00:10:00,620 Hivyo funguo ni ya hiari. 190 00:10:00,620 --> 00:10:04,780 Katika njia sawa, kama huna wanataka kufanya hii inayohusika, 191 00:10:04,780 --> 00:10:09,910 unataka tu safu ya kawaida ambapo safu sifuri ni kipengele kwanza 192 00:10:09,910 --> 00:10:13,190 na safu moja ni ya pili kipengele, unaweza kufanya hivyo hasa 193 00:10:13,190 --> 00:10:17,886 kama wewe ungekuwa katika C. Una baadhi kutofautiana kwamba kinaendelea kuwa safu yako, 194 00:10:17,886 --> 00:10:20,110 na ni sawa na mabano haya hapa. 195 00:10:20,110 --> 00:10:20,610 Ndiyo. 196 00:10:20,610 --> 00:10:22,693 >> Watazamaji: Je, kuwa hatua hiyo kwa nukuu. 197 00:10:22,693 --> 00:10:26,250 Kama, siwezi kufanya kama safu ++, na kwamba pointi kwa moja ya pili. 198 00:10:26,250 --> 00:10:30,260 >> ALLISON BUCHHOLTZ-AU: Unaweza do-- Vizuri, unaweza kuwa na baadhi ya iterator, i, 199 00:10:30,260 --> 00:10:34,300 kwamba unaweza kufanya i ++ na kufanya safu ya i katika njia hiyo hiyo. 200 00:10:34,300 --> 00:10:35,680 Lakini hiyo ni yake. 201 00:10:35,680 --> 00:10:39,630 Hivyo, kama katika kesi hii, safu ya 1 ingekuwa sawa 20. 202 00:10:39,630 --> 00:10:42,530 Same aina ya Indexing nukuu. 203 00:10:42,530 --> 00:10:51,330 Hii ni kimsingi tu jambo thabiti hapa, ambapo anasema sifuri, sifuri hadi 10, 204 00:10:51,330 --> 00:10:54,640 kwa 1 na 20, 2 30. 205 00:10:54,640 --> 00:10:56,760 Ni funguo tu thabiti kwa ajili yake. 206 00:10:56,760 --> 00:10:59,990 Nini mabadiliko kwa PHP ni kwamba sasa una nguvu 207 00:10:59,990 --> 00:11:02,660 kwa reassign funguo hizo kwa kufanya chochote Ningependa. 208 00:11:02,660 --> 00:11:13,820 >> Hivyo jambo moja ni hapa. 209 00:11:13,820 --> 00:11:18,230 Hivyo nina baadhi tu ya mifano hapa kwamba mimi aliandika kwa ajili ya guys 210 00:11:18,230 --> 00:11:22,010 kwa sababu mimi kuhisi kama mifano daima kusaidia zaidi kuliko tu abstract. 211 00:11:22,010 --> 00:11:26,590 Hivyo, katika kesi hii hapa, sisi kuwa na baadhi ya safu associative 212 00:11:26,590 --> 00:11:31,990 kwamba ni jina yangu ya kwanza, jina la mwisho wangu, na mimi 213 00:11:31,990 --> 00:11:35,390 ni akirejea, ambayo ni tu kwa madhumuni yote hapa 214 00:11:35,390 --> 00:11:38,500 kwenda magazeti nje kwa pato hapa. 215 00:11:38,500 --> 00:11:39,300 >> Na inasema, OK. 216 00:11:39,300 --> 00:11:46,680 Magazeti nje thamani kwamba sambamba na safu katika ufunguo Allison. 217 00:11:46,680 --> 00:11:50,860 Na siwezi pia kutuma wewe guys hii yote kificho baada ya darasa. 218 00:11:50,860 --> 00:11:53,700 Hivyo, wakati sisi kukimbia hii, je, unafikiri ni kwenda kutokea? 219 00:11:53,700 --> 00:11:56,239 Nini kinaendelea na magazeti nje? 220 00:11:56,239 --> 00:11:57,280 Watazamaji: jina yako ya mwisho. 221 00:11:57,280 --> 00:11:58,738 ALLISON BUCHHOLTZ-AU: jina langu la mwisho. 222 00:11:58,738 --> 00:12:00,000 Ni gani. 223 00:12:00,000 --> 00:12:00,960 Haki hapa. 224 00:12:00,960 --> 00:12:02,400 Magazeti nje. 225 00:12:02,400 --> 00:12:07,000 Hivyo kama sisi walikuwa na mabadiliko ya hii na sisi walikuwa kuongeza mtu mwingine list-- wetu 226 00:12:07,000 --> 00:12:11,919 Basi hebu kusema tuna Emma hapa, na tujiunge name-- yako ya mwisho 227 00:12:11,919 --> 00:12:13,252 Hebu angalia kama mimi Spell haki hii. 228 00:12:13,252 --> 00:12:13,714 >> Watazamaji: Yeah. 229 00:12:13,714 --> 00:12:14,640 >> ALLISON BUCHHOLTZ-AU: Ndiyo. 230 00:12:14,640 --> 00:12:15,010 >> Watazamaji: Kazi nzuri. 231 00:12:15,010 --> 00:12:16,218 >> ALLISON BUCHHOLTZ-AU: Lovely. 232 00:12:16,218 --> 00:12:25,370 Hivyo sasa kama tuna hii hapa na sisi alitaka kujua jina yako ya mwisho, 233 00:12:25,370 --> 00:12:26,290 una hiyo huko. 234 00:12:26,290 --> 00:12:31,270 Hivyo unaweza tu kufikiria ni kama kuondoa ufunguo hii hapa. 235 00:12:31,270 --> 00:12:33,190 Wewe ni kuondoa tu index. 236 00:12:33,190 --> 00:12:36,845 Hivyo utapata tu kutafuta kupitia safu rahisi zaidi. 237 00:12:36,845 --> 00:12:38,220 Huna haja ya kujua ripoti. 238 00:12:38,220 --> 00:12:43,470 Muda mrefu kama hii muhimu kwamba wewe ni kuangalia kwa lipo mahali fulani katika safu, 239 00:12:43,470 --> 00:12:47,660 PHP utapata yake na atarudi thamani yanayohusiana na hayo. 240 00:12:47,660 --> 00:12:49,840 Hivyo inakupa mengi zaidi nguvu na arrays yako. 241 00:12:49,840 --> 00:12:50,340 Ndiyo. 242 00:12:50,340 --> 00:12:53,131 >> Watazamaji: Kama una funguo mbili huo, itakuwa ni kukupa kosa? 243 00:12:53,131 --> 00:12:55,830 ALLISON BUCHHOLTZ-AU: Ni lazima kukupa makosa, yeah. 244 00:12:55,830 --> 00:12:58,520 Gani kwamba kufanya kidogo maana zaidi kwa nyie? 245 00:12:58,520 --> 00:13:07,640 Na kwa njia hiyo, tuna safu hapa kwamba hana funguo yoyote. 246 00:13:07,640 --> 00:13:10,910 Pia hii ni syntax kwamba unaweza kutaka 247 00:13:10,910 --> 00:13:13,550 kuwa na ufahamu wa, kwa sababu utasikia kutumia hii katika pset yako. 248 00:13:13,550 --> 00:13:17,317 >> Kila wewe ni kufanya echo, una quotes haya, 249 00:13:17,317 --> 00:13:19,400 na wakati wowote wewe ni akimaanisha sehemu ya safu, 250 00:13:19,400 --> 00:13:22,180 unaweza kuwa na haya braces curly karibu nao. 251 00:13:22,180 --> 00:13:25,630 Ni aina ya annoying, lakini wewe tu na kufanya hivyo. 252 00:13:25,630 --> 00:13:28,010 Hivyo tu kitu kukumbuka. 253 00:13:28,010 --> 00:13:31,490 Kama wewe ni mbio katika makosa ya, Najua kwamba hili lipo katika safu yangu 254 00:13:31,490 --> 00:13:34,523 lakini ni kutupa makosa saa yangu, kujaribu kuweka braces kuzunguka 255 00:13:34,523 --> 00:13:37,180 na ni lazima kazi. 256 00:13:37,180 --> 00:13:40,810 >> Hivyo katika kesi hii hapa, hii ni kawaida C safu kwamba sisi ni kutumika. 257 00:13:40,810 --> 00:13:45,810 Ina tatu, tano, na sita, na sisi tu wanataka magazeti nje kipengele kwanza, 258 00:13:45,810 --> 00:13:47,850 hivyo hii lazima magazeti nje ya tatu. 259 00:13:47,850 --> 00:13:51,830 Na mimi kukimbia hizi zote, hivyo hopefully chochote iliyopita. 260 00:13:51,830 --> 00:13:54,460 Tunaona chini hapa, tu Prints nje ya tatu. 261 00:13:54,460 --> 00:13:57,050 262 00:13:57,050 --> 00:13:58,040 Baridi. 263 00:13:58,040 --> 00:14:00,000 Kwamba kufanya maana kwa kila mtu? 264 00:14:00,000 --> 00:14:01,280 Associative arrays. 265 00:14:01,280 --> 00:14:03,150 Baridi sana kuliko arrays ya kawaida. 266 00:14:03,150 --> 00:14:09,640 >> Hii ni why-- Je, Daudi kuonyesha Utekelezaji PHP ya pset6 267 00:14:09,640 --> 00:14:11,751 wakati wa hotuba wakati wote? 268 00:14:11,751 --> 00:14:12,250 OK. 269 00:14:12,250 --> 00:14:13,300 Hivyo, mimi itabidi kuonyesha. 270 00:14:13,300 --> 00:14:13,770 Sijui ni mbali t-- 271 00:14:13,770 --> 00:14:14,680 >> Watazamaji: Yeye alifanya wiki iliyopita. 272 00:14:14,680 --> 00:14:15,560 >> ALLISON BUCHHOLTZ-AU: Ilikuwa ni wiki iliyopita? 273 00:14:15,560 --> 00:14:15,870 >> Watazamaji: Yeah. 274 00:14:15,870 --> 00:14:16,995 >> ALLISON BUCHHOLTZ-AU: Yeah. 275 00:14:16,995 --> 00:14:20,800 Hivyo Speller kifanyike katika kama mistari sita na PHP, na sehemu ya nguvu ya kwamba 276 00:14:20,800 --> 00:14:25,640 ni hii safu associative ambapo unaweza tu mzigo kila neno katika, 277 00:14:25,640 --> 00:14:28,290 na una hiyo sawa na kweli au uongo. 278 00:14:28,290 --> 00:14:31,410 Na hivyo unaweza kusema, oh. 279 00:14:31,410 --> 00:14:39,130 Kurudi kamusi baadhi neno, na kama ni huko, itakuwa kurudi kweli. 280 00:14:39,130 --> 00:14:42,130 Vinginevyo, itakuwa si kupata yake na itabidi kurudi uongo. 281 00:14:42,130 --> 00:14:45,810 Hivyo aina ya baridi kitu kidogo. 282 00:14:45,810 --> 00:14:46,750 >> Wote haki. 283 00:14:46,750 --> 00:14:48,990 Hivyo wale ni arrays associative. 284 00:14:48,990 --> 00:14:50,150 Wao ni pretty cool. 285 00:14:50,150 --> 00:14:51,830 Mimi kwa kweli kama wao. 286 00:14:51,830 --> 00:14:55,340 Na ni wazi this-- Ah. 287 00:14:55,340 --> 00:14:56,290 OK. 288 00:14:56,290 --> 00:14:57,880 Sasa ni kazi. 289 00:14:57,880 --> 00:15:00,700 Labda. 290 00:15:00,700 --> 00:15:01,537 OK. 291 00:15:01,537 --> 00:15:02,120 Kitu kingine. 292 00:15:02,120 --> 00:15:07,680 Hivyo, pamoja na usawa, tu jambo zuri kukumbuka. 293 00:15:07,680 --> 00:15:12,140 Na PHP, kwa sababu ni dynamically typed, 294 00:15:12,140 --> 00:15:16,110 aina inaweza kubadilika kutegemea wakati wewe kukimbia, jinsi wewe ni mbio hiyo. 295 00:15:16,110 --> 00:15:19,890 Mimi kweli kuwa baadhi ya baridi mifano kwamba mimi itabidi kuonyesha guys. 296 00:15:19,890 --> 00:15:23,350 >> Lakini == tu hundi kwa usawa baada ya aina mauzauza. 297 00:15:23,350 --> 00:15:28,890 Hivyo kama una kitu ambacho ni kama tabia ya 1 na namba 1, 298 00:15:28,890 --> 00:15:31,890 PHP waliniambia kwamba wale ni sawa kwa sababu ni 299 00:15:31,890 --> 00:15:35,990 unaweza juggle aina ya wawili wao mpaka ni sawa, 300 00:15:35,990 --> 00:15:38,480 ambayo labda kwa kesi yako ni faini. 301 00:15:38,480 --> 00:15:44,170 >> Kama unahitaji kuona kama ni aina hiyo ya thamani na aina moja, 302 00:15:44,170 --> 00:15:45,305 unataka === hii. 303 00:15:45,305 --> 00:15:48,150 Na sidhani una kesi ambapo unahitaji kutumia kwamba 304 00:15:48,150 --> 00:15:52,570 katika pset yako, lakini kwa ajili ya kura ya wewe ambao kwenda juu ya kufanya kurasa za mtandao 305 00:15:52,570 --> 00:15:57,340 kwa ajili ya miradi yako ya mwisho na mambo, ni jambo zuri kujua kwamba == === na 306 00:15:57,340 --> 00:16:01,690 ni tofauti, na ni vizuri Tofauti kuelewa. 307 00:16:01,690 --> 00:16:02,400 >> OK. 308 00:16:02,400 --> 00:16:02,980 Hivyo. 309 00:16:02,980 --> 00:16:04,460 Foreach loops. 310 00:16:04,460 --> 00:16:07,920 Wao ni njia ya iterate kupitia safu. 311 00:16:07,920 --> 00:16:11,714 Hivyo, tu kama arrays akawa hivyo baridi sana katika PHP, 312 00:16:11,714 --> 00:16:13,630 njia yako iterate kupitia safu, nadhani, 313 00:16:13,630 --> 00:16:16,250 pia inakuwa baridi sana na nguvu zaidi. 314 00:16:16,250 --> 00:16:22,710 Hivyo badala ya kuwa na kujenga baadhi kwa i sawa na 0 chochote, 315 00:16:22,710 --> 00:16:24,890 na kisha update kwamba i kama wewe kwenda kupitia, 316 00:16:24,890 --> 00:16:27,730 tuna hii kutisha kitanzi foreach. 317 00:16:27,730 --> 00:16:36,340 >> Hivyo hapa ni ujumla kiwango muundo wa hizi mbili. 318 00:16:36,340 --> 00:16:41,180 Hivyo aidha una foreach baadhi safu kama thamani unataka iterate kama. 319 00:16:41,180 --> 00:16:46,750 Hivyo hii ni jina la safu kutofautiana kwamba unataka rejea, 320 00:16:46,750 --> 00:16:50,600 na hii ni nini unataka kuiita ndani ya kitanzi. 321 00:16:50,600 --> 00:16:51,420 OK? 322 00:16:51,420 --> 00:16:56,810 Hivyo hii sambamba na kila kipengele cha safu, 323 00:16:56,810 --> 00:16:59,500 na matumizi thamani hii ndani ya kitanzi hii. 324 00:16:59,500 --> 00:17:00,675 >> Nina mfano. 325 00:17:00,675 --> 00:17:02,930 Najua mifano ni hivyo bora zaidi. 326 00:17:02,930 --> 00:17:05,119 Na hivyo hii ni kama kuna hakuna funguo, hivyo hii ni kama 327 00:17:05,119 --> 00:17:11,170 kama sisi tu moja ambapo funguo ni fahirisi ya kawaida kwa ajili ya safu yako. 328 00:17:11,170 --> 00:17:14,770 Au hii pia katika kesi kama wewe huna matumizi kwa funguo. 329 00:17:14,770 --> 00:17:16,690 Kama hawajali funguo na wewe tu 330 00:17:16,690 --> 00:17:20,260 wanataka iterate kupitia na maadili kwa kila mmoja wa wale ili chochote, 331 00:17:20,260 --> 00:17:20,950 hiyo ni faini. 332 00:17:20,950 --> 00:17:22,609 >> Unaweza kutumia muundo. 333 00:17:22,609 --> 00:17:28,640 Vinginevyo, kama kuna funguo, yetu $ Thamani tu mabadiliko kwa $ muhimu thamani. 334 00:17:28,640 --> 00:17:30,660 Hivyo tu mabadiliko kwa jozi ufunguo thamani. 335 00:17:30,660 --> 00:17:34,780 Na kisha tunaweza kutaja $ muhimu na $ thamani ndani ya kitanzi yetu. 336 00:17:34,780 --> 00:17:35,900 OK? 337 00:17:35,900 --> 00:17:36,660 Hivyo. 338 00:17:36,660 --> 00:17:37,810 Mfano. 339 00:17:37,810 --> 00:17:38,610 Kufanya hivyo nicer. 340 00:17:38,610 --> 00:17:48,910 341 00:17:48,910 --> 00:17:49,410 OK. 342 00:17:49,410 --> 00:17:56,780 >> Hivyo tuna hii moja hapa, ambayo sisi kuwa na baadhi ya 343 00:17:56,780 --> 00:18:01,460 are-- Unaweza pia kujenga safu kama hii 344 00:18:01,460 --> 00:18:05,690 kwa kuwa baadhi ya kutofautiana sawa safu na mabano, 345 00:18:05,690 --> 00:18:08,340 au unaweza tu kufanya bracket. 346 00:18:08,340 --> 00:18:11,890 Unapaswa kufanya bracket, lakini hii ni njia nyingine ya kufanya hivyo. 347 00:18:11,890 --> 00:18:16,220 Hivyo hapa tuna baadhi ya safu ya tatu mambo ya moja, mbili, na tatu, 348 00:18:16,220 --> 00:18:18,300 na tuna foreach yetu. 349 00:18:18,300 --> 00:18:23,510 >> Taarifa hii moja sambamba na safu kwamba sisi ni iterating juu, 350 00:18:23,510 --> 00:18:28,330 na hii ni nini sisi ni wito kila kitu katika safu yetu. 351 00:18:28,330 --> 00:18:32,670 Na yote hii ni kufanya ni ni kwenda magazeti nje ya kila thamani. 352 00:18:32,670 --> 00:18:45,590 Hivyo kama sisi kukimbia, sisi taarifa kwamba sisi kuwa na thamani moja, thamani wawili, thamani ya tatu. 353 00:18:45,590 --> 00:18:54,080 >> Na katika njia sawa kwamba kwa kawaida arrays haja ya kuwa ya aina moja, 354 00:18:54,080 --> 00:18:57,570 arrays hawana wote kuwa aina moja hapa. 355 00:18:57,570 --> 00:18:58,690 Hivyo sasa tuna baadhi int. 356 00:18:58,690 --> 00:19:00,910 Tuna masharti mawili. 357 00:19:00,910 --> 00:19:05,332 Hivyo arrays yako unaweza kupata nguvu zaidi 358 00:19:05,332 --> 00:19:07,040 na labda kidogo kidogo Messier, kutegemea 359 00:19:07,040 --> 00:19:08,500 juu ya njia unataka kuangalia saa yake. 360 00:19:08,500 --> 00:19:10,970 Hivyo tunaweza kubadili hii kwa chochote tunataka. 361 00:19:10,970 --> 00:19:12,860 Sisi kutumia thamani. 362 00:19:12,860 --> 00:19:14,630 Hiyo ni jambo la kawaida sisi kutumia. 363 00:19:14,630 --> 00:19:19,650 Lakini, muhimu tu kujua kwamba tunaweza kuwaita kukabiliana hii kama kama sisi alitaka. 364 00:19:19,650 --> 00:19:25,070 Na kama muda wao match up, wazi kila mtu furaha. 365 00:19:25,070 --> 00:19:30,600 Kama wewe milele unataka kukimbia PHP kukimbia kitu kama hii amri 366 00:19:30,600 --> 00:19:33,800 line unajua hii hapa, wewe tu kufanya PHP, 367 00:19:33,800 --> 00:19:36,090 na kisha chochote faili unataka kukimbia. 368 00:19:36,090 --> 00:19:39,130 >> Hivyo kama unataka kwa fujo karibu na PHP, na zaidi mantiki 369 00:19:39,130 --> 00:19:42,710 na wewe si kweli wanahitaji kuona kama katika kivinjari, 370 00:19:42,710 --> 00:19:44,830 unaweza kukimbia tu ni katika mstari amri kama kwamba 371 00:19:44,830 --> 00:19:48,290 na echo magazeti nje chochote kama. 372 00:19:48,290 --> 00:19:50,880 OK. 373 00:19:50,880 --> 00:20:00,640 njia nyingine kwamba sisi ni kama hii. 374 00:20:00,640 --> 00:20:06,974 Hivyo hii ni kesi ambapo labda unataka kutumia wote muhimu na thamani, 375 00:20:06,974 --> 00:20:08,890 Najua haya ni kama Mifano super contrived 376 00:20:08,890 --> 00:20:11,950 lakini natumaini kufanya ni wazi kidogo. 377 00:20:11,950 --> 00:20:14,940 Hivyo hapa tuna baadhi ya safu tena, lakini wakati huu, 378 00:20:14,940 --> 00:20:19,450 badala ya kuwa tu unajua hakuna muhimu. 379 00:20:19,450 --> 00:20:20,870 Tuna funguo kwa kila moja ya haya. 380 00:20:20,870 --> 00:20:24,670 Hivyo ni gonna kuwa moja, b itaendana mbili, na c yanahusiana na tatu. 381 00:20:24,670 --> 00:20:27,030 Na katika kesi hii, kama sisi kuandika njia hii, 382 00:20:27,030 --> 00:20:31,580 sisi kupata wote wawili muhimu na thamani ya kila moja ya haya. 383 00:20:31,580 --> 00:20:36,570 >> Hivyo wakati sisi kukimbia hii, sisi kupata kila mmoja wa wale. 384 00:20:36,570 --> 00:20:41,530 Hivyo Prints nje funguo wetu na sambamba maadili. 385 00:20:41,530 --> 00:20:46,940 Kitu kingine ni kwamba baridi, na mimi kujua Alisema kama hii moja hawakuwa na funguo, 386 00:20:46,940 --> 00:20:51,540 lakini daima inamuunga ina ufunguo kwa sababu kama huna mjumbe 387 00:20:51,540 --> 00:20:54,050 muhimu, bila shaka, yako funguo ni tu bahati yako 388 00:20:54,050 --> 00:20:59,230 au fahirisi hivyo tunaweza daima pia kufanya hii moja. 389 00:20:59,230 --> 00:20:59,730 Kama hii. 390 00:20:59,730 --> 00:21:02,500 391 00:21:02,500 --> 00:21:03,400 Mimi magazeti nje. 392 00:21:03,400 --> 00:21:09,240 393 00:21:09,240 --> 00:21:13,420 Hivyo katika kesi hii, kama taarifa, tuna funguo wetu thabiti 394 00:21:13,420 --> 00:21:15,930 ya sifuri, moja, na mbili hapa. 395 00:21:15,930 --> 00:21:20,020 396 00:21:20,020 --> 00:21:25,600 >> Na kwa njia hiyo hiyo na hii moja, unaweza daima tu kusema r kama thamani, 397 00:21:25,600 --> 00:21:27,910 na wewe tu kupata thamani. 398 00:21:27,910 --> 00:21:30,685 Hawajali kuhusu yako funguo, hata kama wako ana funguo, 399 00:21:30,685 --> 00:21:32,810 kama huna huduma ya juu yao, wewe kufanya si lazima 400 00:21:32,810 --> 00:21:35,970 haja ya kuweka yao katika foreach yako kitanzi. 401 00:21:35,970 --> 00:21:37,953 Gani kwamba mantiki kwa kila mtu? 402 00:21:37,953 --> 00:21:39,764 >> Watazamaji: Je, unaweza tu kuwaita funguo, pia? 403 00:21:39,764 --> 00:21:42,180 ALLISON BUCHHOLTZ-AU: Yeah you inaweza kabisa kufanya hivyo, pia. 404 00:21:42,180 --> 00:21:44,945 405 00:21:44,945 --> 00:21:45,570 Kweli, kusubiri. 406 00:21:45,570 --> 00:21:45,840 Kushikilia. 407 00:21:45,840 --> 00:21:46,630 ingekuwa it-- Hakuna 408 00:21:46,630 --> 00:21:49,663 Kama unataka muhimu, basi unahitaji kufanya muhimu kwa thamani. 409 00:21:49,663 --> 00:21:50,496 Watazamaji: Kuongeza thamani. 410 00:21:50,496 --> 00:21:50,870 ALLISON BUCHHOLTZ-AU: Yeah. 411 00:21:50,870 --> 00:21:52,530 Na wewe tu kamwe kutumia thamani ya wote. 412 00:21:52,530 --> 00:21:53,236 >> Watazamaji: OK. 413 00:21:53,236 --> 00:21:55,610 ALLISON BUCHHOLTZ-AU: Kama tu ya kuweka jambo moja huko, 414 00:21:55,610 --> 00:22:00,010 ni kwenda kwa kudhani kuwa wewe ni kuzungumza juu ya thamani, si muhimu. 415 00:22:00,010 --> 00:22:02,070 Kubwa swali. 416 00:22:02,070 --> 00:22:02,600 Wote haki. 417 00:22:02,600 --> 00:22:06,390 418 00:22:06,390 --> 00:22:08,170 Baridi. 419 00:22:08,170 --> 00:22:09,032 Kweli, kushikilia. 420 00:22:09,032 --> 00:22:09,990 Basi mimi kuona nini nina. 421 00:22:09,990 --> 00:22:13,600 422 00:22:13,600 --> 00:22:18,260 Hivyo kabla ya sisi kupata katika wadhifa na kupata, mimi nataka tu kuonyesha guys kidogo 423 00:22:18,260 --> 00:22:23,680 kuhusu jinsi ni dynamically typed, ambayo ni aina ya baridi. 424 00:22:23,680 --> 00:22:24,450 Nina haya yote. 425 00:22:24,450 --> 00:22:28,160 Nina kama mifano minne hapa, na mimi nitakutuma kificho hii yote 426 00:22:28,160 --> 00:22:30,580 baada ya darasa. 427 00:22:30,580 --> 00:22:34,440 >> Hivyo hapa tuna baadhi ya kutofautiana a. 428 00:22:34,440 --> 00:22:36,500 Hiyo ni 1 tu pamoja na 1, haki? 429 00:22:36,500 --> 00:22:40,930 Na sisi ni kwenda magazeti nje nini kwamba sawa na, na kisha tuna baadhi ya aina. 430 00:22:40,930 --> 00:22:46,066 Na mtu yeyote kuwa guesses yoyote kuhusu nini aina yake kwenda kuwa? 431 00:22:46,066 --> 00:22:46,890 >> Watazamaji: int. 432 00:22:46,890 --> 00:22:48,560 >> ALLISON BUCHHOLTZ-AU: Yeah, ni int. 433 00:22:48,560 --> 00:22:49,890 Hivyo tu anaongeza pamoja. 434 00:22:49,890 --> 00:22:51,671 Ni int. 435 00:22:51,671 --> 00:22:52,170 Wema wote. 436 00:22:52,170 --> 00:22:56,440 437 00:22:56,440 --> 00:23:05,590 Hivyo hii moja ijayo, tuna nini kuangalia kama masharti. 438 00:23:05,590 --> 00:23:11,000 Wakati sisi kukimbia hii, anadhani, oh. 439 00:23:11,000 --> 00:23:13,720 Wewe ni kweli kujaribu kwa kuongeza tu mambo. 440 00:23:13,720 --> 00:23:15,140 Wewe tu got kuchanganyikiwa. 441 00:23:15,140 --> 00:23:17,410 Hivyo mimi nina kwenda tu kurekebisha kwa ajili yenu. 442 00:23:17,410 --> 00:23:18,090 Wewe maana int. 443 00:23:18,090 --> 00:23:19,160 Najua wewe maana int. 444 00:23:19,160 --> 00:23:25,190 >> Hivyo hii ni moja ya njia unaweza kuona, PHP ina akili yake mwenyewe. 445 00:23:25,190 --> 00:23:28,800 Hata ingawa sisi waziwazi alisema, kuangalia, wale hizi ni masharti. 446 00:23:28,800 --> 00:23:30,120 I mean kamba moja. 447 00:23:30,120 --> 00:23:32,160 Lakini anasema, oh, lakini wewe ni kujaribu kuongeza yao, 448 00:23:32,160 --> 00:23:34,460 hivyo ni lazima maana ni integer. 449 00:23:34,460 --> 00:23:35,950 Imani tu mimi juu ya hili. 450 00:23:35,950 --> 00:23:38,920 Hivyo anasema ni integer, na inaongeza yao kama kawaida. 451 00:23:38,920 --> 00:23:42,460 Hivyo aina ya baridi kama wewe ni kwenda kupata wavivu na mambo yako, 452 00:23:42,460 --> 00:23:45,470 au unataka kuongeza kitu. 453 00:23:45,470 --> 00:23:48,690 >> Jambo kubwa ni kwamba, kama unafikiri nyuma pset2, 454 00:23:48,690 --> 00:23:51,840 kitu ambacho alikuwa mtumiaji inputted, haki, kwamba sisi kufikiri 455 00:23:51,840 --> 00:23:54,010 ni Char au kamba kwa mara ya kwanza. 456 00:23:54,010 --> 00:23:57,950 Sasa hatuna kupanga kusema, oh, kufanya hii int. 457 00:23:57,950 --> 00:23:59,790 PHP ingekuwa tu kuwa kama, yeah oh. 458 00:23:59,790 --> 00:24:01,215 Najua wewe maana int. 459 00:24:01,215 --> 00:24:01,830 Silly wewe. 460 00:24:01,830 --> 00:24:04,640 Hakuwa na maana kamba. 461 00:24:04,640 --> 00:24:12,596 >> Hivyo katika kesi hiyo, sasa kwamba tuna hii, nini 462 00:24:12,596 --> 00:24:14,330 guys kufikiri ni kwenda kufanya hapa? 463 00:24:14,330 --> 00:24:17,220 464 00:24:17,220 --> 00:24:20,495 Tuna kamba na int sasa. 465 00:24:20,495 --> 00:24:21,980 >> Watazamaji: Ni bado int. 466 00:24:21,980 --> 00:24:24,040 >> ALLISON BUCHHOLTZ-AU: Ni bado int. 467 00:24:24,040 --> 00:24:26,790 Na sababu is-- napenda kuweka mifano zaidi, lakini furaha hii ya mtu. 468 00:24:26,790 --> 00:24:30,110 Sababu ni kufanya ni kwa sababu ni kama wewe ni kujaribu kuongeza mambo. 469 00:24:30,110 --> 00:24:33,310 Hivyo kama wewe ni kujaribu kuongeza mambo, mimi nina kwenda kwa kudhani, 470 00:24:33,310 --> 00:24:36,030 sababu, una kitu busara kwamba unaweza kuongeza. 471 00:24:36,030 --> 00:24:40,032 Mimi tu kwenda kufanya hivyo int, na sisi ni kwenda tu kuongeza, kama kawaida. 472 00:24:40,032 --> 00:24:42,240 Na kisha kwa njia hiyo hiyo, mimi unafikiri guys kupata wazo. 473 00:24:42,240 --> 00:24:47,400 Sisi pia kuwa hii moja hapa, ambayo ni Chars tu, na ni kitu kimoja gani. 474 00:24:47,400 --> 00:24:49,210 Ni kama, wewe silly mtumiaji. 475 00:24:49,210 --> 00:24:51,400 unajua unataka int. 476 00:24:51,400 --> 00:24:54,491 >> Watazamaji: Kama sisi kuweka barua, mapenzi ni kufanya [inaudible] thamani au la? 477 00:24:54,491 --> 00:24:56,532 ALLISON BUCHHOLTZ-AU: Oh, hiyo ni swali nzuri. 478 00:24:56,532 --> 00:24:57,518 Hebu angalia. 479 00:24:57,518 --> 00:25:00,480 480 00:25:00,480 --> 00:25:03,430 Nope, bado ni int. 481 00:25:03,430 --> 00:25:06,700 Hivyo ni mambo kidogo. 482 00:25:06,700 --> 00:25:12,170 Hii ni aina tu ya kuonyesha PHP wakati mwingine unaweza kuishi katika irrational-- Si 483 00:25:12,170 --> 00:25:16,670 kabisa irrational, lakini inaweza kuishi katika njia ambazo si kweli kutarajia. 484 00:25:16,670 --> 00:25:18,970 Hivyo, wakati katika shaka, kuangalia aina ya mambo. 485 00:25:18,970 --> 00:25:22,570 Hii gettype kazi unaweza kuwa super manufaa. 486 00:25:22,570 --> 00:25:26,930 >> Kwa kawaida, kama wewe ni kufanya kitu chochote na plusses au waendeshaji yoyote ya hisabati, 487 00:25:26,930 --> 00:25:32,010 ni kwenda kwa kudhani chochote busara ni tu int. 488 00:25:32,010 --> 00:25:36,530 Hivyo, una Char 1, au a kamba 1, au halisi int 1, 489 00:25:36,530 --> 00:25:38,200 ni kwenda kwa kudhani kuwa. 490 00:25:38,200 --> 00:25:41,410 Kama unataka typecast chochote, wewe kabisa unaweza. 491 00:25:41,410 --> 00:25:46,540 Unaweza kufanya kitu kama mara mbili hapa, naamini. 492 00:25:46,540 --> 00:25:50,370 493 00:25:50,370 --> 00:25:53,420 Na katika kesi hiyo, ni kwenda kusema, oh. 494 00:25:53,420 --> 00:25:56,550 Mimi itabidi kufanya hii mara mbili kwa sababu you waziwazi alisema ni mara mbili. 495 00:25:56,550 --> 00:26:00,370 Unaweza daima kupanga kufanya PHP kufanya kitu, lakini. 496 00:26:00,370 --> 00:26:02,174 >> Watazamaji: Ngoja, nini ni pamoja na 1 huko? 497 00:26:02,174 --> 00:26:03,215 >> ALLISON BUCHHOLTZ-AU: Oh. 498 00:26:03,215 --> 00:26:06,512 499 00:26:06,512 --> 00:26:07,490 Huko. 500 00:26:07,490 --> 00:26:08,400 Ni mara tu echo. 501 00:26:08,400 --> 00:26:10,820 Hiyo ilikuwa kosa langu. 502 00:26:10,820 --> 00:26:14,240 Hivyo, unaweza kupanga kuwaambia ni kufanya kitu ya aina fulani, 503 00:26:14,240 --> 00:26:17,980 lakini zaidi ya muda, itakuja dynamically kuamua kwamba katika Runtime. 504 00:26:17,980 --> 00:26:20,730 Hivyo ni kwenda kuendelea kupitia na ni kwenda kuwa kama, sawa. 505 00:26:20,730 --> 00:26:23,229 Nini hufanya wengi maana kwa kuwa huu? 506 00:26:23,229 --> 00:26:24,520 Lazima ni kweli kuwa kamba? 507 00:26:24,520 --> 00:26:25,090 Lazima iwe int? 508 00:26:25,090 --> 00:26:25,770 Lazima iwe kuelea? 509 00:26:25,770 --> 00:26:26,810 Lazima ni kuwa mara mbili? 510 00:26:26,810 --> 00:26:29,456 Na itakuwa kuamua kwamba kwa ajili yenu. 511 00:26:29,456 --> 00:26:31,980 >> Unaweza nguvu kwa kufanya unataka nini, but-- 512 00:26:31,980 --> 00:26:35,032 >> Watazamaji: Je kwamba kufanya hivyo polepole? 513 00:26:35,032 --> 00:26:37,365 ALLISON BUCHHOLTZ-AU: Naam, I mean, C ni ufanisi sana. 514 00:26:37,365 --> 00:26:41,760 Nadhani ni dhahiri polepole kwa sababu ina utaratibu kama ni kwenda. 515 00:26:41,760 --> 00:26:45,200 C, mimi nina uhakika ni karibu kasi. 516 00:26:45,200 --> 00:26:47,620 Lakini ni wazi kuna mambo mengi ya baridi katika hapa 517 00:26:47,620 --> 00:26:49,190 kwamba hatuna na wasiwasi juu. 518 00:26:49,190 --> 00:26:50,981 Hivyo, kama sisi ni kutafuta kupitia safu, sisi 519 00:26:50,981 --> 00:26:54,290 hawana kweli kujenga baadhi search kupitia safu. 520 00:26:54,290 --> 00:26:56,920 Tunaweza kuuliza tu kwa ajili ya muhimu na PHP itachukua huduma hiyo. 521 00:26:56,920 --> 00:26:59,510 522 00:26:59,510 --> 00:27:00,630 >> Baridi. 523 00:27:00,630 --> 00:27:01,130 Kutisha. 524 00:27:01,130 --> 00:27:03,937 Inaonekana kama mwisho wa mifano yangu. 525 00:27:03,937 --> 00:27:05,770 You guys ni kamwe kwenda kusahau kwamba sasa. 526 00:27:05,770 --> 00:27:08,450 Wewe ni kwenda kuwa kama, oh, PHP ni tu kama kwamba mama ambao kama hakuna, hakuna, hakuna. 527 00:27:08,450 --> 00:27:09,325 Mimi najua nini maana. 528 00:27:09,325 --> 00:27:11,000 Mimi najua kile unataka. 529 00:27:11,000 --> 00:27:11,580 OK. 530 00:27:11,580 --> 00:27:15,040 Hivyo hii ni, hopefully, muhimu kwa ajili ya yako pset, angalau katika mwanzo, 531 00:27:15,040 --> 00:27:20,290 kwa sababu wewe ni wote kuhusu kushughulika na fomu na mambo kutoka kwa mtumiaji. 532 00:27:20,290 --> 00:27:24,460 >> Hivyo kuna njia mbili kwamba sisi kupita karibu maelezo na PHP na HTML 533 00:27:24,460 --> 00:27:26,700 wakati sisi ni kupita kati ya mambo hayo mawili. 534 00:27:26,700 --> 00:27:32,330 Hivyo tuna $ _GET, ambayo ni kupita kupitia URL, na tuna $ _POST, 535 00:27:32,330 --> 00:27:36,600 ambayo ni kupita katika ujumbe mwili, na hivyo tunaona ni siri. 536 00:27:36,600 --> 00:27:41,660 Lakini jambo moja kuelewa ni kwamba wala ya haya ni kuchukuliwa salama. 537 00:27:41,660 --> 00:27:45,580 >> Kama una mtu ambaye ni kukamata ujumbe kwenda 538 00:27:45,580 --> 00:27:49,180 na kurudi kati ya wewe na server, bado wanaweza kupata data hii. 539 00:27:49,180 --> 00:27:50,810 Wao tu kuangalia vigumu kidogo. 540 00:27:50,810 --> 00:27:54,690 Ni kweli si that-- ni tu siri kutoka URL. 541 00:27:54,690 --> 00:27:58,820 Ni bado katika mwili ujumbe, ingawa, hivyo kama wao kupata kwamba, 542 00:27:58,820 --> 00:27:59,920 ni kweli tu like-- 543 00:27:59,920 --> 00:28:01,710 >> Ni kama tofauti kati ya kitu 544 00:28:01,710 --> 00:28:05,010 kuwa imeandikwa juu ya nje ya bahasha na kitu kiumbe 545 00:28:05,010 --> 00:28:06,980 imeandikwa juu ya kipande cha karatasi ndani. 546 00:28:06,980 --> 00:28:10,270 Siyo kwamba bidii ya kufungua bahasha na kupata kipande cha karatasi ndani. 547 00:28:10,270 --> 00:28:12,414 Nafasi, ni d kuwa rahisi kusoma tu nje. 548 00:28:12,414 --> 00:28:14,330 Lakini hiyo ni jinsi unaweza aina ya kufikiria haya. 549 00:28:14,330 --> 00:28:16,940 Wala ya haya ni kweli kuchukuliwa salama. 550 00:28:16,940 --> 00:28:17,790 OK? 551 00:28:17,790 --> 00:28:19,750 >> Nafasi, haina kweli jambo kwa pset yako 552 00:28:19,750 --> 00:28:22,050 kwa sababu wewe si kushughulika na siri za biashara, 553 00:28:22,050 --> 00:28:25,850 lakini ni kawaida moja Jambo kwamba sisi kweli 554 00:28:25,850 --> 00:28:29,260 kama kusisitiza sababu watu kufikiri, oh, vizuri, ni siri. 555 00:28:29,260 --> 00:28:30,610 Ni lazima kuwa super salama. 556 00:28:30,610 --> 00:28:31,140 Hakuna 557 00:28:31,140 --> 00:28:32,570 Ni si salama. 558 00:28:32,570 --> 00:28:35,808 Ni kidogo tu chini salama, mimi nadhani. 559 00:28:35,808 --> 00:28:38,500 Au unsecure. 560 00:28:38,500 --> 00:28:41,625 >> Hivyo sisi kweli kuwa mfano. 561 00:28:41,625 --> 00:28:43,500 Kama unajua, mimi upendo kufundisha zaidi na mifano. 562 00:28:43,500 --> 00:28:45,070 Najisikia kama hii husaidia bora. 563 00:28:45,070 --> 00:28:49,590 Hivyo, tuna baadhi ya fomu rahisi hapa ambayo kwa kweli, kama wewe guys ni milele 564 00:28:49,590 --> 00:28:51,940 kuchanganyikiwa kuhusu PHP, hii ni kweli ndogo, 565 00:28:51,940 --> 00:28:55,630 lakini php.net ni kweli mzuri nyaraka. 566 00:28:55,630 --> 00:28:56,500 Mimi kwa kweli kama hiyo. 567 00:28:56,500 --> 00:29:02,900 Mimi nilikuwa kutumia kujiandaa kwa ajili ya hii sehemu, ili niweze daktari ni kwa ajili yenu. 568 00:29:02,900 --> 00:29:07,760 >> Huu ni mfano kutoka kwao juu ya jinsi $ _POST na dola _GET kazi. 569 00:29:07,760 --> 00:29:09,970 Tofauti tu kati ya wawili hawa, 570 00:29:09,970 --> 00:29:13,285 badala ambapo habari ni kuonyeshwa, kama ni katika URL 571 00:29:13,285 --> 00:29:16,430 au katika mwili, pia ni nini mbinu ni. 572 00:29:16,430 --> 00:29:21,350 Hivyo katika fomu yako kwa HTML-- Hii ni rahisi sana HTML fomu. 573 00:29:21,350 --> 00:29:22,760 Yeyote anaweza kuniambia nini anafanya? 574 00:29:22,760 --> 00:29:29,471 575 00:29:29,471 --> 00:29:30,970 Watazamaji: Uliza kwa jina lako na umri. 576 00:29:30,970 --> 00:29:31,230 ALLISON BUCHHOLTZ-AU: Hasa. 577 00:29:31,230 --> 00:29:33,330 Hivyo tuna baadhi ya hatua fomu. 578 00:29:33,330 --> 00:29:36,260 Kwamba lets sisi kujua ni aina fulani kitendo. 579 00:29:36,260 --> 00:29:39,330 Na nini kitatokea ni, wakati sisi kugonga Kuwasilisha, 580 00:29:39,330 --> 00:29:44,280 ni kwenda kuwaita action.php, ambayo ni nini hii ni, 581 00:29:44,280 --> 00:29:47,180 na ni kwenda kuiita kwa njia ya $ _POST. 582 00:29:47,180 --> 00:29:51,340 Hivyo katika kesi hii, yako habari ni siri. 583 00:29:51,340 --> 00:29:57,020 na ni tu jina lako, baadhi aina pembejeo kuitwa jina, baadhi ya umri, 584 00:29:57,020 --> 00:30:01,270 pembejeo aina = "Nakala" kwamba sisi pia kuwaita umri. 585 00:30:01,270 --> 00:30:05,110 Na kisha kama sisi hit Kuwasilisha, Kuwasilisha itatoa wito action.php. 586 00:30:05,110 --> 00:30:09,800 >> Hivyo wakati sisi kweli kugonga Kuwasilisha, sisi kujua kwamba ina posted, per se, 587 00:30:09,800 --> 00:30:15,290 na tutaweza kweli kuona hii katika yako tatizo kuweka kwamba hopefully tutaweza 588 00:30:15,290 --> 00:30:16,760 kupata kutembea kwa njia kidogo. 589 00:30:16,760 --> 00:30:21,690 Na wote ni kufanya hapa ni POST ni baadhi ya kutofautiana superglobal 590 00:30:21,690 --> 00:30:23,300 kwamba sisi aliyesema kuhusu wakati wa hotuba. 591 00:30:23,300 --> 00:30:30,170 Na jinsi gani unaweza kufikiria kuhusu $ _POST ni kwamba ni tu safu associative. 592 00:30:30,170 --> 00:30:30,960 OK? 593 00:30:30,960 --> 00:30:35,930 Hivyo hii ni baadhi ya muhimu, hii ni baadhi ya muhimu, na chochote 594 00:30:35,930 --> 00:30:39,270 pembejeo user inakuwa thamani kwa kila ya wale. 595 00:30:39,270 --> 00:30:39,960 OK? 596 00:30:39,960 --> 00:30:47,240 >> Hivyo kama sisi walikuwa kuandika kile safu hii kweli inaonekana kama haki baada ya sisi 597 00:30:47,240 --> 00:30:56,000 kuwasilishwa fomu, tunataka kuwa, hii ni yetu $ _POST, 598 00:30:56,000 --> 00:31:04,380 na baadhi ya safu ambapo tuna baadhi ya jina. 599 00:31:04,380 --> 00:31:17,670 Hebu tu kusema tutaweza kufanya jina langu, na kisha tuna baadhi ya umri, 21. 600 00:31:17,670 --> 00:31:19,420 Woo. 601 00:31:19,420 --> 00:31:23,550 Hivyo hii ni wote $ _POST ni. $ _POST ni tu safu associative, sawa? 602 00:31:23,550 --> 00:31:24,807 >> Ni tu anasema, OK. 603 00:31:24,807 --> 00:31:26,890 Ni mambo tumekuwa nini aliuliza kwa kutoka kwa mtumiaji? 604 00:31:26,890 --> 00:31:28,889 Ni vigezo gani kwamba sisi ni kupita karibu 605 00:31:28,889 --> 00:31:30,730 kwamba tumekuwa aliuliza kwa katika fomu hii? 606 00:31:30,730 --> 00:31:33,830 Na ni basi kile maadili ya kuhusishwa na kwamba? 607 00:31:33,830 --> 00:31:38,750 Hivyo katika kesi hii, kama mimi kuwasilishwa na jina la Ally na umri wa miaka 21, 608 00:31:38,750 --> 00:31:40,890 hii ni nini $ _POST inaonekana kama. 609 00:31:40,890 --> 00:31:41,570 OK? 610 00:31:41,570 --> 00:31:45,150 Na hii ni nini hii PHP faili wanapata. 611 00:31:45,150 --> 00:31:46,680 Wote haki? 612 00:31:46,680 --> 00:31:51,730 >> Hivyo katika kesi hii, hii ni kama kupata kitu nyingine yoyote kutoka safu yetu. 613 00:31:51,730 --> 00:31:55,370 Badala ya ripoti katika yetu safu, tuna baadhi ya muhimu. 614 00:31:55,370 --> 00:32:00,790 Hivyo hii ni kwenda kutoa mimi thamani katika jina muhimu. 615 00:32:00,790 --> 00:32:05,400 Hivyo hii ni kwenda kuwa na Ally, na haki hii hapa ni kwenda kunipa 616 00:32:05,400 --> 00:32:08,840 thamani ya $ _POST ambapo muhimu ni umri, ambayo itakuwa 21. 617 00:32:08,840 --> 00:32:12,541 618 00:32:12,541 --> 00:32:14,290 Wewe ni kwenda kuwa na kufanya hili kidogo kabisa. 619 00:32:14,290 --> 00:32:18,920 620 00:32:18,920 --> 00:32:21,590 Yeah, ambayo ni sehemu? 621 00:32:21,590 --> 00:32:24,235 >> Watazamaji: Wakati walikuwa akionyesha sehemu ya chini. 622 00:32:24,235 --> 00:32:25,860 ALLISON BUCHHOLTZ-AU: Hii ni sehemu ya chini? 623 00:32:25,860 --> 00:32:26,359 OK. 624 00:32:26,359 --> 00:32:31,897 Hivyo, wewe kuelewa hili ni HTML yetu kuunda, na sisi kuwa na baadhi ya mbinu $ _POST, 625 00:32:31,897 --> 00:32:32,480 ambayo mambo. 626 00:32:32,480 --> 00:32:35,410 Hii pia inaweza kuwa $ _GET, lakini kwa kusudi hili, 627 00:32:35,410 --> 00:32:36,910 sisi ni kwenda tu kusema ni $ _POST. 628 00:32:36,910 --> 00:32:42,700 Wakati sisi kuwasilisha fomu hii, hii ni sehemu ya faili PHP kwamba kuitwa. 629 00:32:42,700 --> 00:32:48,530 Hivyo faili hili PHP sasa ni kwenda kutekeleza kupewa taarifa kutoka HTML yetu 630 00:32:48,530 --> 00:32:49,840 fomu. 631 00:32:49,840 --> 00:32:52,670 >> Hivyo kile ni kufanya ni, wakati sisi kugonga Kuwasilisha juu ya HTML fomu yetu, 632 00:32:52,670 --> 00:32:59,220 ni kupita kwenu superglobal hii, ambayo ni tu safu associative. 633 00:32:59,220 --> 00:33:00,306 Ni hii. 634 00:33:00,306 --> 00:33:02,840 Ni kama tu kupita kwamba kwa faili. 635 00:33:02,840 --> 00:33:04,540 Na nini anasema ni, OK, hapa $ _POST. 636 00:33:04,540 --> 00:33:05,706 Ni associative yako safu. 637 00:33:05,706 --> 00:33:07,000 Kufanya na ni nini unataka. 638 00:33:07,000 --> 00:33:08,980 Na sisi ni kusema, OK. 639 00:33:08,980 --> 00:33:13,620 Nipe thamani katika jina, na kunipa thamani katika umri. 640 00:33:13,620 --> 00:33:18,150 >> Basi hizi ni funguo tu, na hii ni safu yetu. 641 00:33:18,150 --> 00:33:19,190 Je kwamba inafanya hisia? 642 00:33:19,190 --> 00:33:19,815 >> Watazamaji: Mhmm. 643 00:33:19,815 --> 00:33:21,266 ALLISON BUCHHOLTZ-AU: Ajabu. 644 00:33:21,266 --> 00:33:24,432 Watazamaji: Kama una resubmit aina gani kuandika tu juu ya data? 645 00:33:24,432 --> 00:33:25,557 ALLISON BUCHHOLTZ-AU: Yeah. 646 00:33:25,557 --> 00:33:26,160 Mhmm? 647 00:33:26,160 --> 00:33:30,300 >> Watazamaji: Kwa nini una kutaja kwamba ni int? 648 00:33:30,300 --> 00:33:34,950 >> ALLISON BUCHHOLTZ-AU: Katika kesi hiyo, user ni kulazimisha tu kuwa ni int. 649 00:33:34,950 --> 00:33:35,749 >> Watazamaji: OK. 650 00:33:35,749 --> 00:33:38,540 ALLISON BUCHHOLTZ-AU: Sijui kama ingekuwa kweli haja ya kuwa, 651 00:33:38,540 --> 00:33:43,850 lakini kwa madhumuni yao, waliamua kwamba wao alitaka kuwa int. 652 00:33:43,850 --> 00:33:45,590 Wao ni tu typecasting yake. 653 00:33:45,590 --> 00:33:47,760 Labda wao ni kutumia kama kitu kingine baadaye. 654 00:33:47,760 --> 00:33:49,872 Hii ni snippet moja tu. 655 00:33:49,872 --> 00:33:50,372 Ndiyo? 656 00:33:50,372 --> 00:33:57,246 >> Watazamaji: Nini kama typed 12, T-W-E-L-V-E, kwa umri? 657 00:33:57,246 --> 00:33:59,704 ALLISON BUCHHOLTZ-AU: Kama wao alijaribu aina hiyo kama int? 658 00:33:59,704 --> 00:34:00,160 Watazamaji: Yeah. 659 00:34:00,160 --> 00:34:02,076 ALLISON BUCHHOLTZ-AU: Mimi kusahau kile kwamba anafanya. 660 00:34:02,076 --> 00:34:05,540 Nadhani anaweza kujaribu kubadili tabia ya kwanza kwa int, 661 00:34:05,540 --> 00:34:11,360 au kuchukua thamani na kubadilisha , lakini mimi kusahau hasa nini. 662 00:34:11,360 --> 00:34:14,570 Kuwa jambo furaha kuandika mpango na kujaribu. 663 00:34:14,570 --> 00:34:16,389 Kufanya mistari michache. 664 00:34:16,389 --> 00:34:21,310 OK, hivyo hii ni moja ya kuu mambo ambayo wewe ni kwenda kufanya. 665 00:34:21,310 --> 00:34:23,969 Mimi nina kwenda hopefully kutembea kupitia michache ya files 666 00:34:23,969 --> 00:34:25,260 kutoka pset na wewe guys. 667 00:34:25,260 --> 00:34:28,850 Inaonekana kama sisi ni kwenda na wakati, ili tuweze kufanya hivyo. 668 00:34:28,850 --> 00:34:31,190 >> Lakini wewe ni kwenda kuwa na kufanya mambo mengi 669 00:34:31,190 --> 00:34:36,130 kama hii, ambapo wewe ni kupita mambo kutoka fomu HTML 670 00:34:36,130 --> 00:34:42,130 katika fomu hii PHP kwamba mapenzi kisha nitafanya baadhi ya seti ya maelekezo 671 00:34:42,130 --> 00:34:44,460 juu ya data kwamba ilikuwa zinazotolewa. 672 00:34:44,460 --> 00:34:46,864 Hiyo ni literally kiini cha pset yako. 673 00:34:46,864 --> 00:34:48,130 Yeah. 674 00:34:48,130 --> 00:34:52,040 >> Watazamaji: aina = "kuwasilisha", kwamba hufanya kifungo juu ya aina HTML. 675 00:34:52,040 --> 00:34:54,280 Je, kuna njia kuwaita kwamba kifungo kitu? 676 00:34:54,280 --> 00:34:56,040 Hivyo ungeweza kuwa kama jina = "kuwasilisha"? 677 00:34:56,040 --> 00:34:59,170 Au ni kwamba kifungo tu kwenda kuwa tupu sasa hivi, kwa sababu wewe tu 678 00:34:59,170 --> 00:35:00,970 akampa aina, si jina. 679 00:35:00,970 --> 00:35:03,803 >> ALLISON BUCHHOLTZ-AU: Nadhani ni tu kwenda kuwa tupu hivi sasa. 680 00:35:03,803 --> 00:35:07,320 Tunaweza dhahiri kuangalia katika pset, kwa sababu sisi dhahiri 681 00:35:07,320 --> 00:35:10,265 kuwa na kuangalia kusajili aina ya kitu. 682 00:35:10,265 --> 00:35:14,610 Lakini yeah, unaweza dhahiri bayana Nakala kwamba unataka kifungo yako. 683 00:35:14,610 --> 00:35:17,560 OK, hivyo SQL. 684 00:35:17,560 --> 00:35:21,880 >> Wakati wewe ni kununua na kuuza hisa, unahitaji kuweka wimbo wa wale. 685 00:35:21,880 --> 00:35:25,760 Hivyo njia tunakwenda kufanya hivyo ni na SQL, ambayo ni tu database. 686 00:35:25,760 --> 00:35:29,200 Fikiria kama meza ambapo wewe ni kutunza habari hii yote 687 00:35:29,200 --> 00:35:30,649 kuhusu watumiaji yako tofauti. 688 00:35:30,649 --> 00:35:32,940 Na nyie ni kweli kwenda kujenga moja ya haya. 689 00:35:32,940 --> 00:35:34,290 Ni pretty baridi. 690 00:35:34,290 --> 00:35:38,470 >> Na kuna mambo manne tu kuu kwamba unahitaji kujua kwa pset hii, 691 00:35:38,470 --> 00:35:43,120 na wao ni update, hivyo kimsingi mahitaji data. 692 00:35:43,120 --> 00:35:45,190 Kwamba akubali kwamba ni tayari. 693 00:35:45,190 --> 00:35:48,320 Kama siyo huko, ni kwenda kukupiga kwa kosa, 694 00:35:48,320 --> 00:35:51,300 hivyo labda unataka kuangalia. 695 00:35:51,300 --> 00:35:55,882 Na wewe update on-- mimi lazima actually- mimi na wakati, 696 00:35:55,882 --> 00:35:57,090 Mimi itabidi kuandika michache ya haya. 697 00:35:57,090 --> 00:36:03,370 Mimi kwa kweli kukupa guys a michache ya sampuli, amri kamili SQL, 698 00:36:03,370 --> 00:36:06,530 kwa sababu hizi ni tu kuu ndio, lakini unaweza kujiunga nao pamoja. 699 00:36:06,530 --> 00:36:09,780 Hivyo mimi itabidi kufanya hivyo na mimi itabidi kutuma kuwa nje na wewe kwa maelezo haya. 700 00:36:09,780 --> 00:36:14,580 >> Hivyo kama unataka update kitu, haja ya kuwaambia ni nini wewe uppdatering 701 00:36:14,580 --> 00:36:16,390 na ambapo wewe ni uppdatering yake. 702 00:36:16,390 --> 00:36:27,770 Hivyo kawaida SQL amri itakuwa update ID ambapo kitu ni sawa na kitu. 703 00:36:27,770 --> 00:36:31,490 Au kama update anwani ambapo ID sawa 3, 704 00:36:31,490 --> 00:36:37,040 na hii itakuwa update uwanja anwani ya mtumiaji yako ambaye ana ID ya tatu. 705 00:36:37,040 --> 00:36:37,630 OK? 706 00:36:37,630 --> 00:36:44,300 >> Hivyo kama wewe kwenda SQL na W3Schools, wana mifano ya kutisha. 707 00:36:44,300 --> 00:36:46,880 Kwa kweli, mimi ili kuvuta baadhi up katika kidogo. 708 00:36:46,880 --> 00:36:49,810 Na kisha kuingiza katika, wewe tu kuingiza maadili fulani huko. 709 00:36:49,810 --> 00:36:56,810 Hivyo kama wewe ni kujaribu kujenga baadhi ya mwezi kuingia, hivyo wewe ni kujenga mtumiaji mpya, 710 00:36:56,810 --> 00:37:00,970 unaweza kufanya kuingiza katika chochote Mbegu yako inaitwa, 711 00:37:00,970 --> 00:37:03,540 na ingekuwa maadili haya yote. 712 00:37:03,540 --> 00:37:06,250 >> Basi una kuchagua, kuchagua maadili kwa mtazamo. 713 00:37:06,250 --> 00:37:09,640 Hivyo kama wewe ni kujaribu kuangalia kwa kuona kama user lipo au uko 714 00:37:09,640 --> 00:37:12,030 kujaribu kunyakua maalum habari kuhusu user 715 00:37:12,030 --> 00:37:13,790 wewe ni kwenda kuwa na kutumia kuchagua. 716 00:37:13,790 --> 00:37:17,564 Na kisha kufuta, nadhani, ni pretty rahisi huko. 717 00:37:17,564 --> 00:37:19,480 Wewe ni kufuta tu kitu kutoka meza. 718 00:37:19,480 --> 00:37:25,960 Na kwa kweli, basi mimi kweli kuvuta up baadhi ya mifano kwa nyie. 719 00:37:25,960 --> 00:37:29,350 Oh kuangalia, ni yangu 61 ukurasa. 720 00:37:29,350 --> 00:37:32,940 >> Hivyo kama sisi kwenda W3Schools, hopefully ni juu tena. 721 00:37:32,940 --> 00:37:35,640 Ndiyo, Upendo. 722 00:37:35,640 --> 00:37:37,680 Sisi kwenda kwa SQL. 723 00:37:37,680 --> 00:37:39,160 Hivyo, hii ni kitu hapa. 724 00:37:39,160 --> 00:37:42,548 Hivyo, hii ni SELECT rahisi sana. 725 00:37:42,548 --> 00:37:45,620 Mtu, mimi upendo kazi hii. 726 00:37:45,620 --> 00:37:50,030 Hivyo, unaweza kuwa SELECT baadhi shamba kutoka kwa wateja. 727 00:37:50,030 --> 00:37:55,340 Katika kesi hiyo, wateja inahusu online database kwamba wewe ni kutumia, 728 00:37:55,340 --> 00:38:00,480 hivyo chochote meza yako inaitwa, na nyota tu ina maana kuchagua kila kitu. 729 00:38:00,480 --> 00:38:01,710 Nipe kila mmoja. 730 00:38:01,710 --> 00:38:05,810 731 00:38:05,810 --> 00:38:10,720 >> Kwa hiyo, mimi nataka tu kukupa guys a mifano michache ya ambapo hii ni. 732 00:38:10,720 --> 00:38:15,570 733 00:38:15,570 --> 00:38:17,960 Hivyo tuna SELECT, UPDATE. 734 00:38:17,960 --> 00:38:21,460 735 00:38:21,460 --> 00:38:25,420 Hivyo hapa ni aina ya syntax kwa ujumla. 736 00:38:25,420 --> 00:38:31,080 Hivyo Mwisho, chochote yako jina meza ni, na kisha kuweka 737 00:38:31,080 --> 00:38:35,060 ni ambapo wewe ni kweli kwenda kuwa kile data wewe ni kubadilisha. 738 00:38:35,060 --> 00:38:38,340 Hivyo hii inaweza be-- Hebu mimi kufanya mfano hapa. 739 00:38:38,340 --> 00:38:44,146 740 00:38:44,146 --> 00:38:45,145 Hivyo hii ni kwenda be-- 741 00:38:45,145 --> 00:39:10,250 742 00:39:10,250 --> 00:39:10,750 >> OK. 743 00:39:10,750 --> 00:39:13,585 Hivyo mimi umba database kidogo kwa ajili yetu. 744 00:39:13,585 --> 00:39:16,260 Tunakwenda kuwa na baadhi ya ID, baadhi mwaka, na baadhi ya jina lake. 745 00:39:16,260 --> 00:39:23,022 Hivyo ID moja kwenda kuwa mwaka '15, na sisi ni kwenda tu kufanya hivyo kwangu. 746 00:39:23,022 --> 00:39:24,980 Ambaye anataka kuwa wa pili mtu katika meza yetu? 747 00:39:24,980 --> 00:39:25,480 Mtu yeyote. 748 00:39:25,480 --> 00:39:28,192 749 00:39:28,192 --> 00:39:30,525 Mimi tu kwenda kuchagua Emma kwa sababu ya jina lako haraka. 750 00:39:30,525 --> 00:39:32,220 Emma, ​​mwaka gani ni wewe? 751 00:39:32,220 --> 00:39:33,180 >> Watazamaji: mwaka gani? 752 00:39:33,180 --> 00:39:33,600 >> ALLISON BUCHHOLTZ-AU: Yeah. 753 00:39:33,600 --> 00:39:34,183 >> Watazamaji: '16. 754 00:39:34,183 --> 00:39:35,780 ALLISON BUCHHOLTZ-AU: '16. 755 00:39:35,780 --> 00:39:37,920 Wewe ni kwenda tu kuwa guinea nguruwe wangu kwa leo. 756 00:39:37,920 --> 00:39:40,490 OK, hivyo tuna watu hawa wawili. 757 00:39:40,490 --> 00:39:42,194 Kweli, basi mimi kufanya hivyo. 758 00:39:42,194 --> 00:39:45,110 Hebu kusema nikasikia yake vibaya, na mimi kweli alisema yeye ni mwaka mdogo. 759 00:39:45,110 --> 00:39:46,980 Yeye ni '17. 760 00:39:46,980 --> 00:39:50,790 Nini tunataka kufanya hapa, kama sisi alitaka update mwaka Emma ya 761 00:39:50,790 --> 00:39:57,480 kuwa sahihi kwa kutumia kwamba, ni nini tunatarajia kufanya ni tunatarajia kusema UPDATE data zaidi ya hapa. 762 00:39:57,480 --> 00:40:05,140 763 00:40:05,140 --> 00:40:09,130 >> Na hii inaweza kuwa wote kwenye mstari mmoja, lakini tangu mimi nina USITUMIE kwa nafasi hapa, 764 00:40:09,130 --> 00:40:11,450 Mimi nina kwenda kuandika hapa. 765 00:40:11,450 --> 00:40:12,740 Na tunataka kuweka. 766 00:40:12,740 --> 00:40:16,770 Hivyo hii ni meza sisi ni uppdatering. 767 00:40:16,770 --> 00:40:21,600 SET ni kwenda kuwa na safu nini au nini data ni sisi kweli kubadilisha. 768 00:40:21,600 --> 00:40:30,670 Nini sisi ni kubadilisha ni mwaka, hivyo tunakwenda kusema SET mwaka = 16, 769 00:40:30,670 --> 00:40:39,470 na kisha WAPI anatueleza ambayo mtumiaji au nini mstari ni sisi kweli uppdatering hii. 770 00:40:39,470 --> 00:40:40,980 >> Hivyo wapi? 771 00:40:40,980 --> 00:40:42,600 Tuna chaguzi mbili hapa. 772 00:40:42,600 --> 00:40:43,450 Ni nini mbili? 773 00:40:43,450 --> 00:40:44,580 Hizi ni ya kipekee, haki? 774 00:40:44,580 --> 00:40:47,150 Hivyo majina yetu ni ya kipekee na ID zetu ni ya kipekee, 775 00:40:47,150 --> 00:40:50,880 hivyo ni nini chaguzi mbili kwa ambapo tunaweza kufanya hili? 776 00:40:50,880 --> 00:40:51,970 Mimi nitakupa moja. 777 00:40:51,970 --> 00:40:57,450 Tunaweza kufanya WAPI ID = 2, au tunaweza kufanya nini 778 00:40:57,450 --> 00:41:00,920 kama sisi ni kwenda mbali dhana hii hapa. 779 00:41:00,920 --> 00:41:02,180 >> Watazamaji: [inaudible]. 780 00:41:02,180 --> 00:41:03,430 ALLISON BUCHHOLTZ-AU: Hasa. 781 00:41:03,430 --> 00:41:07,300 Hivyo tunaweza pia kufanya jina = Emma. 782 00:41:07,300 --> 00:41:10,189 783 00:41:10,189 --> 00:41:11,480 Na kati ya hizi ingekuwa kazi. 784 00:41:11,480 --> 00:41:14,040 Na sisi mbio hii, ni d kuwa kama, sawa. 785 00:41:14,040 --> 00:41:15,300 Tutaweza mabadiliko hayo. 786 00:41:15,300 --> 00:41:17,680 Wewe ni kweli 16, hivyo sasa wewe ni haki tena. 787 00:41:17,680 --> 00:41:21,410 OK, hivyo hii itakuwa super muhimu katika pset yako 788 00:41:21,410 --> 00:41:25,157 ambapo labda mtu aliamua kununua 100 hisa ya Apple, 789 00:41:25,157 --> 00:41:26,740 na kisha wao walikuwa kama, just kidding. 790 00:41:26,740 --> 00:41:28,320 Nataka tu 90 ya hisa. 791 00:41:28,320 --> 00:41:33,630 Na hivyo kuuza 10 kati yao, hivyo haja ya kuboresha kiasi cha hifadhi 792 00:41:33,630 --> 00:41:34,330 kwamba wana. 793 00:41:34,330 --> 00:41:39,050 Hivyo, uppdatering hifadhi, uppdatering meza. 794 00:41:39,050 --> 00:41:39,950 >> OK. 795 00:41:39,950 --> 00:41:42,710 Hivyo hiyo ni moja mfano huko. 796 00:41:42,710 --> 00:41:45,131 Hiyo update syntax. 797 00:41:45,131 --> 00:41:45,630 Kufuta. 798 00:41:45,630 --> 00:41:50,391 799 00:41:50,391 --> 00:41:50,890 Oh. 800 00:41:50,890 --> 00:41:53,580 Kuingiza ndani ni yetu moja nyingine. 801 00:41:53,580 --> 00:41:57,950 Hivyo, hii moja hapa ni sawa sana. 802 00:41:57,950 --> 00:42:00,430 Tunaweza kusema tu, katika hii kesi hebu kuongeza mtu. 803 00:42:00,430 --> 00:42:02,310 Tunaweza kuongeza Ben wakati huu. 804 00:42:02,310 --> 00:42:13,300 Hatuna kuingiza ndani, na sisi wanataka jina la meza yetu. 805 00:42:13,300 --> 00:42:16,580 Katika kesi hiyo ni data. 806 00:42:16,580 --> 00:42:25,790 >> Na kisha sisi tu unataka, wewe kwenda kusema MAADILI, na nini ni kwenda kufanya 807 00:42:25,790 --> 00:42:29,147 ni, wewe kweli haja ya kuhakikisha kwamba una kitu kwa kila mstari 808 00:42:29,147 --> 00:42:29,730 kwamba unataka. 809 00:42:29,730 --> 00:42:31,090 Wewe tu kuweka yao katika utaratibu. 810 00:42:31,090 --> 00:42:33,920 Hivyo katika kesi hii, sisi kusema 3. 811 00:42:33,920 --> 00:42:35,280 Wewe ni 18, haki Ben? 812 00:42:35,280 --> 00:42:36,439 >> Watazamaji: 19. 813 00:42:36,439 --> 00:42:37,480 ALLISON BUCHHOLTZ-AU: 19? 814 00:42:37,480 --> 00:42:38,360 Watazamaji: 19. 815 00:42:38,360 --> 00:42:39,943 ALLISON BUCHHOLTZ-AU: '19 mwaka wako? 816 00:42:39,943 --> 00:42:41,459 Kuhitimu katika '18, haki? 817 00:42:41,459 --> 00:42:42,000 Watazamaji: Oh. 818 00:42:42,000 --> 00:42:42,870 ALLISON BUCHHOLTZ-AU: kuhitimu mwaka. 819 00:42:42,870 --> 00:42:43,842 Watazamaji: OK. 820 00:42:43,842 --> 00:42:46,070 ALLISON BUCHHOLTZ-AU: Mimi nilikuwa kama, ni wewe 821 00:42:46,070 --> 00:42:48,550 tayari mipango ya kuchukua mwaka mbali hapa? 822 00:42:48,550 --> 00:42:52,590 Hivyo, '18, tuna Ben. 823 00:42:52,590 --> 00:43:01,950 Hivyo katika kesi hii, itakuwa kwenda kupitia, ingekuwa kujenga kuingia mpya hapa. 824 00:43:01,950 --> 00:43:04,520 825 00:43:04,520 --> 00:43:05,750 Baridi. 826 00:43:05,750 --> 00:43:07,570 Si mbaya sana, haki? 827 00:43:07,570 --> 00:43:09,850 mengi ya hii ni kwenda kuwa syntax kwa nyie. 828 00:43:09,850 --> 00:43:13,280 Dhana anayekuja, hopefully, kiasi urahisi. 829 00:43:13,280 --> 00:43:17,270 syntax ni jambo tu ambayo inaweza kuwa ni kidogo suala gumu. 830 00:43:17,270 --> 00:43:20,590 >> Na kisha moja yetu ya mwisho ni Kufuta, na kama ilani, 831 00:43:20,590 --> 00:43:22,260 Mimi sana kupendekeza tovuti hii. 832 00:43:22,260 --> 00:43:24,110 Ni kubwa. 833 00:43:24,110 --> 00:43:25,620 Kuna tani ya mambo ya ajabu. 834 00:43:25,620 --> 00:43:30,550 Hivyo, katika njia sawa kwamba tulikuwa baadhi update, kufuta ni sawa sana. 835 00:43:30,550 --> 00:43:33,800 Badala tuna Futa kutoka Takwimu. 836 00:43:33,800 --> 00:43:37,506 Hivyo katika kesi hii, ya mwisho wetu moja mimi itabidi kuandika hapa. 837 00:43:37,506 --> 00:43:38,880 Hebu kusema tulitaka kufuta yangu. 838 00:43:38,880 --> 00:43:44,670 839 00:43:44,670 --> 00:43:48,750 Siwezi kuandika leo. 840 00:43:48,750 --> 00:43:51,720 Kufuta kutoka chochote meza tuko katika, data. 841 00:43:51,720 --> 00:43:56,160 842 00:43:56,160 --> 00:44:02,128 Na kuna kweli njia tatu tunaweza kuchagua kufuta yangu. 843 00:44:02,128 --> 00:44:06,040 844 00:44:06,040 --> 00:44:09,780 >> Unaweza guys kuniambia nini tatu njia ni, jinsi gani unaweza kufuta mimi? 845 00:44:09,780 --> 00:44:12,880 846 00:44:12,880 --> 00:44:15,400 ID sawa 1, ambapo ID sawa 1. 847 00:44:15,400 --> 00:44:19,470 Tunaweza kufanya ambapo mwaka sawa na 15, au ambapo jina sawa na Allison. 848 00:44:19,470 --> 00:44:21,540 Bila shaka, kuna tu njia tatu tofauti, 849 00:44:21,540 --> 00:44:24,570 kwa sababu haya yote ni ya kipekee. 850 00:44:24,570 --> 00:44:28,000 Kawaida katika meza yako, na hasa katika pset yako, 851 00:44:28,000 --> 00:44:32,105 wewe ni kwenda kuweka moja ya nguzo hizi kuwa ya kipekee. 852 00:44:32,105 --> 00:44:36,252 >> Ni pengine kwenda kuwa baadhi ya ID kipekee idadi, kwa sababu kama wewe have-- kweli, 853 00:44:36,252 --> 00:44:37,710 inaweza kweli basi una mbili. 854 00:44:37,710 --> 00:44:40,520 Siwezi kukumbuka kama itabidi basi una mbili ya jambo hilo. 855 00:44:40,520 --> 00:44:42,000 >> Watazamaji: Kisha ingekuwa kubadili tabia zao. 856 00:44:42,000 --> 00:44:43,291 >> ALLISON BUCHHOLTZ-AU: Ni ingekuwa. 857 00:44:43,291 --> 00:44:46,280 Utakuwa kusababisha tabia ni zisizotarajiwa, kwamba unaweza si kweli kutabiri. 858 00:44:46,280 --> 00:44:53,040 Hivyo utakuwa dhahiri kuwa na safu moja katika Mbegu yako ambayo itakuwa ya kipekee, 859 00:44:53,040 --> 00:44:55,760 na ni kawaida unaweza kuweka hivyo kwamba kama ID kipekee, 860 00:44:55,760 --> 00:44:59,884 na itakuwa tu update kila wakati kuingiza katika meza. 861 00:44:59,884 --> 00:45:02,050 Wakati wowote kuunda mpya mstari, itakuwa moja kwa moja 862 00:45:02,050 --> 00:45:04,190 nyongeza na kuwapa baadhi ID kipekee. 863 00:45:04,190 --> 00:45:05,960 Hivyo ladha kwa pset yako. 864 00:45:05,960 --> 00:45:08,560 865 00:45:08,560 --> 00:45:09,160 OK. 866 00:45:09,160 --> 00:45:11,575 Hivyo kwamba ni SQL. 867 00:45:11,575 --> 00:45:18,170 868 00:45:18,170 --> 00:45:22,140 >> Hivyo sasa sisi ni kwenda kuzungumza kuhusu Jambo la mwisho sana, ambayo mahusiano katika 869 00:45:22,140 --> 00:45:24,770 kweli pretty vizuri na yako pset, kama ingekuwa kwenda mbele. 870 00:45:24,770 --> 00:45:28,210 Hivyo MVC, mfano mtazamo mtawala. 871 00:45:28,210 --> 00:45:32,480 Hii ni kweli tu njia kuweka mambo kupangwa. 872 00:45:32,480 --> 00:45:36,910 Katika njia sawa na C tunakuomba guys kujenga kazi na mambo tofauti 873 00:45:36,910 --> 00:45:42,350 nje, hii ni njia tu ya kutenganisha nje kanuni wakati wewe kufanya maendeleo ya mtandao. 874 00:45:42,350 --> 00:45:46,850 >> Hivyo inafanya mambo mengi zaidi kifahari na rahisi, 875 00:45:46,850 --> 00:45:49,310 na hii ni kweli njia kwamba pset yako ni kweli 876 00:45:49,310 --> 00:45:52,460 kuanzisha, hivyo kama wewe kama hayo au si, wewe kwenda kujifunza, 877 00:45:52,460 --> 00:45:54,251 hata kama wewe sidhani wewe ni kujifunza yake. 878 00:45:54,251 --> 00:45:56,580 879 00:45:56,580 --> 00:46:01,950 Na jambo moja ni, pia utapata kufanya mengi zaidi kama user kushirikiana. 880 00:46:01,950 --> 00:46:05,770 >> Hivyo wakati mimi alichukua CS50, mimi tovuti kwa ajili ya mradi wangu wa mwisho, 881 00:46:05,770 --> 00:46:09,190 na mimi nilikuwa kama, mimi itabidi kushughulikia mambo database. 882 00:46:09,190 --> 00:46:12,450 Mimi itabidi kufanya nyuma mwisho stuff, na yangu roommate ambao nilikuwa kuchukua na ni 883 00:46:12,450 --> 00:46:14,270 ilikuwa artsy sana. 884 00:46:14,270 --> 00:46:17,370 Yeye hana hatua ya kubuni, na yeye alitaka kufanya yote pretty. 885 00:46:17,370 --> 00:46:18,435 Hivyo mimi nina kama, sawa. 886 00:46:18,435 --> 00:46:20,310 Unaweza kuchukua huduma ya wote mwisho mbele mambo ya ajabu. 887 00:46:20,310 --> 00:46:22,660 >> Na jambo ni, kama tutaweza kuona hivi karibuni, 888 00:46:22,660 --> 00:46:26,130 kuwa mfano mtazamo mtawala inakuwezesha kabisa tofauti kwamba kanuni hivyo 889 00:46:26,130 --> 00:46:29,260 kwamba mimi naweza kufanya kazi katika kutekeleza kurasa zetu, 890 00:46:29,260 --> 00:46:31,266 na kufanyia habari katika database yetu, 891 00:46:31,266 --> 00:46:34,140 na aliweza tu kufanya mambo pretty, na sisi wote walikuwa kweli furaha, 892 00:46:34,140 --> 00:46:36,750 sababu sisi got kufanya nini sisi wote alitaka na sisi 893 00:46:36,750 --> 00:46:38,400 hawakuwa na kukabiliana na nyingine moja. 894 00:46:38,400 --> 00:46:40,377 >> Hivyo sisi Hung nje pamoja. 895 00:46:40,377 --> 00:46:41,210 Sisi kama hutegemea nje. 896 00:46:41,210 --> 00:46:45,649 Mimi tu hakutaka kukabiliana na wote CSS na HTML mambo ya ajabu. 897 00:46:45,649 --> 00:46:46,940 Mimi nilikuwa kama, unaweza kufanya hivyo pretty. 898 00:46:46,940 --> 00:46:49,420 Mimi itabidi kukabiliana na database. 899 00:46:49,420 --> 00:46:52,620 Hivyo tuna kweli hii baridi, kubwa kidogo meza. 900 00:46:52,620 --> 00:46:55,440 Nampenda meza. 901 00:46:55,440 --> 00:46:59,680 Na kimsingi, mfano unaweza kufikiria ni tu orodha yako. 902 00:46:59,680 --> 00:47:03,630 >> Nilikuwa mfano mtu kwa ajili ya mradi wangu. 903 00:47:03,630 --> 00:47:06,800 Ni wote kuhusu uhifadhi wa habari na kuandaa data hiyo. 904 00:47:06,800 --> 00:47:09,790 Hivyo ni nini sisi kama kuwaita nyuma mwisho. 905 00:47:09,790 --> 00:47:13,260 Hivyo guys itakuwa kushughulika na Mbegu SQL na mafaili ya data. 906 00:47:13,260 --> 00:47:14,650 Hiyo ni mfano wako. 907 00:47:14,650 --> 00:47:17,800 >> Maoni yako, kama unaweza kufikiri, aina ya mantiki, 908 00:47:17,800 --> 00:47:20,610 ni nini user yako kweli anaona. 909 00:47:20,610 --> 00:47:22,110 Ni interface user. 910 00:47:22,110 --> 00:47:24,359 Ni kwamba mbele inakabiliwa sehemu. 911 00:47:24,359 --> 00:47:26,650 Hivyo kwamba ni nini rafiki yangu got kufanya kazi kwa wakati wote. 912 00:47:26,650 --> 00:47:27,660 Alikuwa super furaha. 913 00:47:27,660 --> 00:47:31,580 Hivyo hiyo ni yote ya HTML, na kuna PHP kidogo sana. 914 00:47:31,580 --> 00:47:34,420 >> Kama wewe ni tu kuzungumza juu ya nini kuwa kuonyeshwa kwa mtumiaji, 915 00:47:34,420 --> 00:47:36,576 tunazungumzia HyperText. 916 00:47:36,576 --> 00:47:37,950 Tunazungumzia jinsi inaonekana. 917 00:47:37,950 --> 00:47:41,400 Hatuzungumzii kuhusu mantiki, au hali au whatnot. 918 00:47:41,400 --> 00:47:45,620 Yote ya kwamba anapata kubebwa na mtawala, sawa? 919 00:47:45,620 --> 00:47:49,470 Hivyo kwamba Hushughulikia maombi user na anapata habari. 920 00:47:49,470 --> 00:47:54,750 >> Hivyo jambo moja unapaswa kujua kuhusu pset yako ni kwamba, katika maoni yako, 921 00:47:54,750 --> 00:47:57,650 chochote ambacho ni kweli Inaonekana habari 922 00:47:57,650 --> 00:48:00,530 kamwe kuwa maamuzi wito kwa mfano wako. 923 00:48:00,530 --> 00:48:02,570 Yote ya kwamba ni kubebwa katika mtawala wako. 924 00:48:02,570 --> 00:48:06,950 Mtawala wako ni moja upatanishi kati ya hizi mbili. 925 00:48:06,950 --> 00:48:10,280 Ni kuuliza mfano kwa habari fulani. 926 00:48:10,280 --> 00:48:12,610 Inaweza iterate juu ya kwamba habari, takwimu nje 927 00:48:12,610 --> 00:48:15,110 kweli nini unahitaji kutoka hivyo, nini cha kufanya na hayo, 928 00:48:15,110 --> 00:48:17,860 na kisha itakuwa kupita juu ya tu habari 929 00:48:17,860 --> 00:48:24,670 haja ya maoni kwa ajili yenu na magazeti hayo nje au kuonyesha ni kwa mtumiaji, sawa? 930 00:48:24,670 --> 00:48:28,690 >> Kwa sababu tunaona mtazamo kama chochote inakabiliwa user, 931 00:48:28,690 --> 00:48:31,340 hivyo itakuwa rahisi kwa wao kufikiri, 932 00:48:31,340 --> 00:48:34,980 oh, kama wewe ni kufanya baadhi ya wito kwa mfano wako 933 00:48:34,980 --> 00:48:39,152 na wewe ni kuuliza kwa watumiaji wote ambao kuanza na barua ya A, 934 00:48:39,152 --> 00:48:41,985 na wewe kufanya kwamba kwa maoni yako, mtu yeyote ambaye anaweza kuona mtandao ukurasa wako 935 00:48:41,985 --> 00:48:43,350 inaweza uwezekano wa kupata hiyo. 936 00:48:43,350 --> 00:48:44,740 >> Wewe si lazima wanataka. 937 00:48:44,740 --> 00:48:48,560 Wewe hawataki watu kuona zaidi katika orodha kuliko yale 938 00:48:48,560 --> 00:48:49,800 wanapaswa kuona. 939 00:48:49,800 --> 00:48:51,560 Tu wao upendeleo maalum. 940 00:48:51,560 --> 00:48:53,840 Hivyo mtawala Hushughulikia yote. 941 00:48:53,840 --> 00:48:59,800 Basi wote wa mafaili yako .php kwamba tutaweza kuona unaweza kufikiria mafaili yako mtawala. 942 00:48:59,800 --> 00:49:02,710 Na kwamba ni ambapo wewe ni kweli kwenda kuwa 943 00:49:02,710 --> 00:49:06,500 kuuliza kwa ajili ya mambo kutoka orodha yako, na iterating au kufanyia 944 00:49:06,500 --> 00:49:10,670 kama muhimu kabla ya kupita kwenye kutazamwa. 945 00:49:10,670 --> 00:49:12,830 >> Ni pset kweli baridi, kwa maoni yangu. 946 00:49:12,830 --> 00:49:15,580 Nadhani ni kidogo zaidi kama furaha ya papo, 947 00:49:15,580 --> 00:49:17,990 kwa sababu wewe kutekeleza mambo mengi kidogo kidogo, 948 00:49:17,990 --> 00:49:20,250 na kila jambo wanapaswa kufanya kazi juu yake mwenyewe. 949 00:49:20,250 --> 00:49:24,180 Si kama, kufanya kila kitu na kisha kuona kama ni kazi. 950 00:49:24,180 --> 00:49:26,570 Kama na programu ambapo wewe ni kama, mimi nina 951 00:49:26,570 --> 00:49:28,910 kweli matumaini hii ni haki, kwa sababu kama si, 952 00:49:28,910 --> 00:49:30,743 kuna mengi ya sehemu yake inaweza kuwa mbaya. 953 00:49:30,743 --> 00:49:34,220 954 00:49:34,220 --> 00:49:35,110 >> Wote haki. 955 00:49:35,110 --> 00:49:39,744 Tu kuhakikisha kwamba mimi alisema kila kitu mimi zinahitajika kusema kuhusu MVC. 956 00:49:39,744 --> 00:49:40,680 Yeah. 957 00:49:40,680 --> 00:49:41,347 Baridi. 958 00:49:41,347 --> 00:49:47,340 >> Hivyo katika CS50 Fedha, tuna mtindo wetu, kama mimi tu alisema hapa. 959 00:49:47,340 --> 00:49:51,810 Ni kwenda kuwa MySQL na phpMyAdmin. 960 00:49:51,810 --> 00:49:55,130 Siwezi dhahiri kuvuta wale up hivyo nyie kupata nafasi ya kuangalia ni. 961 00:49:55,130 --> 00:49:59,250 Kama nilivyosema kabla, SQL yako Mbegu vitendo kama mfano wako, 962 00:49:59,250 --> 00:50:03,600 na unaweza kutuma nini sisi kuwaita maswali, ambayo ni tu aina ya mambo haya. 963 00:50:03,600 --> 00:50:04,914 Hizi zinaitwa swala. 964 00:50:04,914 --> 00:50:07,830 Hii ni swala, ambapo wewe tu kuuliza Mbegu yako kwa kitu, 965 00:50:07,830 --> 00:50:09,810 au wewe ni kubadilisha yako Mbegu katika baadhi ya njia. 966 00:50:09,810 --> 00:50:11,470 Hayo ni yote ni. 967 00:50:11,470 --> 00:50:16,040 Na wewe kufanya hivyo kwa kazi tumekuwa aliyopewa hapa. 968 00:50:16,040 --> 00:50:20,500 >> Unaweza pia kuendesha yao kwa mkono kupitia phpMyAdmin, 969 00:50:20,500 --> 00:50:22,170 ambayo tunaweza dhahiri kuangalia. 970 00:50:22,170 --> 00:50:25,160 Mimi itabidi kujenga sampuli Mbegu kwa nyie. 971 00:50:25,160 --> 00:50:25,660 OK. 972 00:50:25,660 --> 00:50:26,680 Hivyo, mtawala. 973 00:50:26,680 --> 00:50:30,730 Hivyo katika kesi hii, kama wewe ilani, hii yote ni PHP. 974 00:50:30,730 --> 00:50:33,430 Taarifa hiyo ni aina ya yako Jambo kuu ya mtawala wako 975 00:50:33,430 --> 00:50:35,410 ni kwamba ni lazima kuwa zaidi PHP. 976 00:50:35,410 --> 00:50:39,590 Kama una HTML katika mtawala wako, si kweli na uhakika nini kinaendelea huko. 977 00:50:39,590 --> 00:50:42,495 njia sawa kama nilivyosema, kama wewe kusimamia na [inaudible] na HTML, 978 00:50:42,495 --> 00:50:43,810 Mimi nina kweli nia. 979 00:50:43,810 --> 00:50:49,150 >> Hivyo nini sisi hapa ni wewe na baadhi ya swala. 980 00:50:49,150 --> 00:50:53,700 Swala ni kazi ambayo sisi kujengwa kwa nyie. 981 00:50:53,700 --> 00:50:56,935 Ni kama wrapper kufanya maswali kwa Mbegu yako rahisi kidogo. 982 00:50:56,935 --> 00:51:01,441 Kama hawakuwa na kwamba, syntax kwa kweli kuzungumza na SQL database yako 983 00:51:01,441 --> 00:51:03,690 itakuwa tofauti, hivyo sisi tu ugavi ni kwa ajili yenu guys. 984 00:51:03,690 --> 00:51:05,490 Sisi kama kufanya maisha rahisi. 985 00:51:05,490 --> 00:51:09,050 >> Hivyo katika kesi hii, unaweza guys kuniambia nini mstari huu ni kufanya? 986 00:51:09,050 --> 00:51:11,860 987 00:51:11,860 --> 00:51:13,487 SELECT * kutoka kwa baadhi meza. 988 00:51:13,487 --> 00:51:15,320 Watazamaji: Chagua kila kitu kutoka meza hii. 989 00:51:15,320 --> 00:51:16,570 ALLISON BUCHHOLTZ-AU: Hasa. 990 00:51:16,570 --> 00:51:18,750 Hivyo ni kusema, nipe kila kitu kutoka meza hii. 991 00:51:18,750 --> 00:51:22,430 Na ni katika hifadhi hiyo baadhi ya matokeo ya kutofautiana. 992 00:51:22,430 --> 00:51:27,720 Na hii anasema, kama matokeo si sawa kwa uongo, basi sisi kufanya kila mmoja wa hili. 993 00:51:27,720 --> 00:51:32,390 Hivyo kama kuna kitu hapa, kama yako meza ya tupu au ni tu haipo, 994 00:51:32,390 --> 00:51:33,640 ni kwenda na kurudi uongo. 995 00:51:33,640 --> 00:51:36,431 Hivyo katika kesi hii, sisi ni maamuzi tu kuhakikisha kwamba kitu ilikuwa kweli 996 00:51:36,431 --> 00:51:37,520 kurudi kwetu. 997 00:51:37,520 --> 00:51:40,070 >> Na kisha hapa, tuna foreach yetu kubwa kitanzi 998 00:51:40,070 --> 00:51:44,380 kwamba sisi ni iterating juu ya yetu Matokeo yake, na sisi ni wito ni mstari, 999 00:51:44,380 --> 00:51:51,080 na sisi kusema atatoa template hii ambapo data yako ni matokeo haya. 1000 00:51:51,080 --> 00:51:52,170 OK? 1001 00:51:52,170 --> 00:51:54,440 Hivyo ni usindikaji tu mstari wa matokeo. 1002 00:51:54,440 --> 00:51:56,790 Vinginevyo, yells. 1003 00:51:56,790 --> 00:51:59,770 Hivyo, huu ni mfano ya mtawala. 1004 00:51:59,770 --> 00:52:02,842 Kama unaweza kuona, hii ni tu place-- Yeah, pole? 1005 00:52:02,842 --> 00:52:04,960 >> Watazamaji: Kwa nini kuna ampersand kabla mstari? 1006 00:52:04,960 --> 00:52:07,000 >> ALLISON BUCHHOLTZ-AU: ampersand kabla mfululizo. 1007 00:52:07,000 --> 00:52:11,000 Sisi ni iterating tu. 1008 00:52:11,000 --> 00:52:13,490 Hiyo pia anwani of-- 1009 00:52:13,490 --> 00:52:16,400 >> Watazamaji: Hivyo ni kama C referencing. 1010 00:52:16,400 --> 00:52:22,080 >> ALLISON BUCHHOLTZ-AU: Ni kuhakikisha kuwa wewe ni kweli 1011 00:52:22,080 --> 00:52:24,730 kubadilisha awali na si nakala. 1012 00:52:24,730 --> 00:52:28,580 Ni kwa njia sawa na C ambapo sisi ni kupita kwa kumbukumbu hapa, tu 1013 00:52:28,580 --> 00:52:30,449 kuhakikisha. 1014 00:52:30,449 --> 00:52:33,530 >> Watazamaji: Je, ni si == badala ya si katika PHP =? 1015 00:52:33,530 --> 00:52:35,400 >> ALLISON BUCHHOLTZ-AU: Ni si ==. 1016 00:52:35,400 --> 00:52:37,240 >> Watazamaji: Kwa sababu ni sawa na katika C ni just-- 1017 00:52:37,240 --> 00:52:37,970 >> ALLISON BUCHHOLTZ-AU: Ni tu si =. 1018 00:52:37,970 --> 00:52:38,470 Yeah, hakuna. 1019 00:52:38,470 --> 00:52:39,656 Ni si ==. 1020 00:52:39,656 --> 00:52:45,610 Kwa sababu == katika PHP hundi kwa usawa na toggling, nafasi, 1021 00:52:45,610 --> 00:52:47,650 lakini ubora wa ziada. 1022 00:52:47,650 --> 00:52:51,050 Hivyo, siyo == katika PHP. 1023 00:52:51,050 --> 00:52:53,025 Ni moja ya kidogo syntax tofauti. 1024 00:52:53,025 --> 00:52:55,330 1025 00:52:55,330 --> 00:52:55,830 Yeah. 1026 00:52:55,830 --> 00:52:57,538 Hivyo sisi ni iterating tu njia ya kila mstari, 1027 00:52:57,538 --> 00:53:00,850 na atatoa, kama wewe guys kusoma kwa njia ya spec yako, 1028 00:53:00,850 --> 00:53:05,360 ni baadhi tu ya kazi nyingine ambazo ni kweli kwenda mchakato HTML wote 1029 00:53:05,360 --> 00:53:09,760 na kuonyesha ni katika yako kivinjari kwa ajili yenu. 1030 00:53:09,760 --> 00:53:10,610 >> OK. 1031 00:53:10,610 --> 00:53:15,360 Hivyo, sisi kama kufikiria controllers yako kama kile kinafanya mantiki ya biashara. 1032 00:53:15,360 --> 00:53:18,550 Kama unaweza kuona hapa, hii ni mahali ambapo sisi ni kuchukua takwimu zetu kutoka meza, 1033 00:53:18,550 --> 00:53:23,530 sisi ni usindikaji katika baadhi ya njia, na kisha sisi ni kupita mbali. 1034 00:53:23,530 --> 00:53:27,930 Wakati sisi kufanya kutoa baadhi template, baadhi template ni maoni yetu, 1035 00:53:27,930 --> 00:53:31,810 na sisi ni kupita tu data kwamba ni lazima kupata. 1036 00:53:31,810 --> 00:53:33,340 Si wote data. 1037 00:53:33,340 --> 00:53:35,340 Tu data kwamba tunataka ni kupata. 1038 00:53:35,340 --> 00:53:37,520 OK? 1039 00:53:37,520 --> 00:53:40,270 Kimsingi data baada ya usindikaji. 1040 00:53:40,270 --> 00:53:44,780 >> Hivyo hii ni maoni, hii ni Jumla template kwamba tuna, 1041 00:53:44,780 --> 00:53:49,810 na yote hii ni kufanya husika, yaani, unaweza kuwa PHP kidogo kwa maoni yako. 1042 00:53:49,810 --> 00:53:52,620 Si kama hakuna PHP katika mtazamo. 1043 00:53:52,620 --> 00:53:55,650 Unapaswa tu sana PHP ndogo katika mtazamo, 1044 00:53:55,650 --> 00:53:58,860 na wewe kamwe kuwa querying katika maoni yako. 1045 00:53:58,860 --> 00:54:01,580 Wewe kamwe kuwa kuzungumza kwa Mbegu yako katika maoni yako. 1046 00:54:01,580 --> 00:54:02,760 Hiyo ni tofauti kubwa. 1047 00:54:02,760 --> 00:54:07,886 >> Hivyo nini kinaendelea hapa ni, tuna PHP hiyo iterating kupitia mfululizo. 1048 00:54:07,886 --> 00:54:10,260 Hivyo katika kesi hii, tangu tulipokuwa iterating kwa njia ya kila mstari 1049 00:54:10,260 --> 00:54:14,370 na utoaji kitu, hii ilikuwa pengine kama pande mbili safu 1050 00:54:14,370 --> 00:54:18,240 ambapo tuna baadhi ya safu ya kwamba yaani, katika yenyewe, safu, 1051 00:54:18,240 --> 00:54:20,520 sababu sisi ni iterating kupitia tena. 1052 00:54:20,520 --> 00:54:26,730 Na sisi ni uchapishaji tu nje jina mstari, basi mwisho ni. 1053 00:54:26,730 --> 00:54:28,470 >> Unapaswa haja hii katika foreach. 1054 00:54:28,470 --> 00:54:30,560 Sijawahi kuona kwamba kabla ya kweli. 1055 00:54:30,560 --> 00:54:33,160 Mimi tu kufanya foreach. 1056 00:54:33,160 --> 00:54:35,140 OK, hivyo hiyo ni maoni. 1057 00:54:35,140 --> 00:54:40,170 Hebu angalia kama tunaweza kutembea kwa njia ya kidogo ya pset yako. 1058 00:54:40,170 --> 00:54:45,380 Tuna dakika 15, hivyo mimi nina uhakika guys ungependa kuwa zaidi kuliko tu 1059 00:54:45,380 --> 00:54:45,935 kuishia mapema. 1060 00:54:45,935 --> 00:54:48,980 1061 00:54:48,980 --> 00:54:52,680 Napenda kuona kama naweza kuleta hii up. 1062 00:54:52,680 --> 00:54:57,130 >> Hivyo mimi sijui jinsi wengi wenu guys kuwa kupakuliwa na whatnot bado, 1063 00:54:57,130 --> 00:55:00,660 lakini tuna jina la mtumiaji hapa, na tuna baadhi ya password. 1064 00:55:00,660 --> 00:55:05,310 Na kwa bahati mbaya, haki sasa database ni tupu, 1065 00:55:05,310 --> 00:55:10,390 hivyo sisi kweli wanahitaji kujenga database. 1066 00:55:10,390 --> 00:55:13,470 Naam, hiyo ni weird. 1067 00:55:13,470 --> 00:55:14,450 Hawakuwa wanatarajia kwamba. 1068 00:55:14,450 --> 00:55:15,375 Ufundi makosa. 1069 00:55:15,375 --> 00:55:17,139 Ufundi matatizo. 1070 00:55:17,139 --> 00:55:17,930 Tuna baadhi pset7. 1071 00:55:17,930 --> 00:55:22,470 1072 00:55:22,470 --> 00:55:23,180 Baridi. 1073 00:55:23,180 --> 00:55:29,660 >> Hivyo, jambo moja unaweza kufanya ni, na query-- mimi itabidi kujenga meza. 1074 00:55:29,660 --> 00:55:38,570 Hivyo hii ni kwenda kuwa na users-- nini unaweza kufanya hapa ni, kama tuna some-- 1075 00:55:38,570 --> 00:55:39,830 Kweli sasa? 1076 00:55:39,830 --> 00:55:40,330 OK. 1077 00:55:40,330 --> 00:55:44,510 Ni wazi mimi si kufanya hivyo moto. 1078 00:55:44,510 --> 00:55:45,010 Oh. 1079 00:55:45,010 --> 00:55:45,740 Najua nini. 1080 00:55:45,740 --> 00:55:49,070 Kwa sababu mimi kamwe kuundwa halisi meza yangu. 1081 00:55:49,070 --> 00:55:52,400 Hivyo wakati wewe kwanza kuanza na Mbegu, wewe ni wazi 1082 00:55:52,400 --> 00:55:56,550 na kuamua ni nini mambo mimi haja ya kuwa katika hapa? 1083 00:55:56,550 --> 00:56:00,850 >> Hivyo kama sisi tu kwenda mbali data meza yetu hapa, 1084 00:56:00,850 --> 00:56:06,410 tulikuwa na baadhi ya ID, ambayo unaweza tu kukaa int. 1085 00:56:06,410 --> 00:56:12,460 Na kama sisi kuangalia zaidi ya hapa, kuna jambo zuri that-- Hivyo index. 1086 00:56:12,460 --> 00:56:18,060 Kama wewe kufanya msingi, itakuwa kufanya hivyo Jambo kwamba meza yako ni kupangwa kwa, 1087 00:56:18,060 --> 00:56:19,410 na itakuwa pia kufanya hivyo kipekee. 1088 00:56:19,410 --> 00:56:25,790 Hivyo katika kesi hii, tutaweza kufanya hivyo msingi, na mimi nina kwenda kufanya jina hili, 1089 00:56:25,790 --> 00:56:34,500 kisha tutaweza tu kufanya hivyo varchar barua ya kama 26, kwa sababu kwa nini? 1090 00:56:34,500 --> 00:56:39,060 >> Na kisha unaweza kwenda Hifadhi, na kisha kama unaweza kuona, tuna baadhi ya watumiaji hapa. 1091 00:56:39,060 --> 00:56:42,950 Hivyo kama sisi alitaka kufanya kuingiza, tunaweza kufanya hivyo 1092 00:56:42,950 --> 00:56:51,807 njia hii, au kama alitaka mazoezi na yako queries-- Oh mvulana. 1093 00:56:51,807 --> 00:56:53,140 Mimi si hii kutumika katika milele. 1094 00:56:53,140 --> 00:56:53,980 Mimi kuchukua nyuma hii. 1095 00:56:53,980 --> 00:56:57,620 1096 00:56:57,620 --> 00:57:04,030 >> Unaweza hariri hii juu yako mwenyewe ama tu kwa manually kuingiza habari 1097 00:57:04,030 --> 00:57:08,270 na kitu kama, wewe Unaweza kubadilisha yoyote ya hizi 1098 00:57:08,270 --> 00:57:13,730 kama alitaka make-- Kama unataka ghafla kujikwamua jina, unaweza kuacha, 1099 00:57:13,730 --> 00:57:15,220 unaweza kufanya mambo hayo yote. 1100 00:57:15,220 --> 00:57:17,560 Kama unahitaji milele manually mabadiliko meza yako, 1101 00:57:17,560 --> 00:57:20,200 Mimi zinaonyesha kufanya hivyo katika phpMyAdmin dhidi kujaribu 1102 00:57:20,200 --> 00:57:24,475 kufikiri SQL maswali kwa ujumla. 1103 00:57:24,475 --> 00:57:27,350 Wakati kwanza kuanza pset yako, wewe ni kwenda kuwa na kazi katika hapa, 1104 00:57:27,350 --> 00:57:29,650 hivyo kupata kutumika kwa kuwa. 1105 00:57:29,650 --> 00:57:35,650 Na kisha wakati wewe kweli unataka kuingiza mambo katika table-- yako 1106 00:57:35,650 --> 00:57:38,310 Mimi kwa kweli ajabu ambapo yaani, kwa sababu there's-- Hapa ni. 1107 00:57:38,310 --> 00:57:39,310 Hiyo ni nini nilitaka. 1108 00:57:39,310 --> 00:57:44,320 Hivyo kama wewe kwenda SQL, unaweza kweli kuona, kama sisi kuona hapa, 1109 00:57:44,320 --> 00:57:45,870 tuna maswali SQL. 1110 00:57:45,870 --> 00:57:54,100 >> Hivyo kama sisi alitaka kuchagua kitu au kama sisi alitaka kuingiza kitu, 1111 00:57:54,100 --> 00:58:00,320 tunaweza kufanya kuingiza katika watumiaji, haki? 1112 00:58:00,320 --> 00:58:04,460 1113 00:58:04,460 --> 00:58:07,230 Nadhani unahitaji backslash. 1114 00:58:07,230 --> 00:58:10,210 Jambo moja kujua ni, kama wewe ni milele kutumia hii, 1115 00:58:10,210 --> 00:58:14,800 una kutumia hizi nyuma apostrophes, ambayo ni kawaida, 1116 00:58:14,800 --> 00:58:16,790 kama wewe ni juu ya Mac, haki juu ya tab. 1117 00:58:16,790 --> 00:58:17,840 Hivyo jambo zuri kujua. 1118 00:58:17,840 --> 00:58:23,330 >> Unaweza kuingiza ndani ya watumiaji, na tuna maadili yetu, haki? 1119 00:58:23,330 --> 00:58:29,700 Hivyo tuna maadili, na maadili yetu katika kesi hii ingekuwa tu kuwa, 1120 00:58:29,700 --> 00:58:33,910 sisi tu ID hivyo sisi inaweza kufanya moja kama sisi alitaka. 1121 00:58:33,910 --> 00:58:35,320 Hiyo ni weird. 1122 00:58:35,320 --> 00:58:36,730 OK. 1123 00:58:36,730 --> 00:58:41,800 Hivyo kwamba kama tu mafupi kitu kidogo na SQL, 1124 00:58:41,800 --> 00:58:48,300 lakini inaweza kuwa na manufaa zaidi kwa kweli kuangalia baadhi ya mafaili katika hapa. 1125 00:58:48,300 --> 00:58:50,985 >> Hivyo kwenda Mkono. 1126 00:58:50,985 --> 00:58:51,950 Oh, si Mkono. 1127 00:58:51,950 --> 00:58:55,260 1128 00:58:55,260 --> 00:58:58,690 Hivyo, tu walkthrough ya haraka ya nini katika kila folders haya. 1129 00:58:58,690 --> 00:59:03,090 Ni pamoja, sisi tu mambo kwamba configure browser yako, 1130 00:59:03,090 --> 00:59:05,370 tuna constants haya, na tuna kazi hizi. 1131 00:59:05,370 --> 00:59:10,470 Kama wewe ni nia yao yoyote, Mimi kupendekeza kuangalia kazi. 1132 00:59:10,470 --> 00:59:17,400 Mmoja wao kwamba ni super muhimu, kweli ni hii moja hapa, dampo. 1133 00:59:17,400 --> 00:59:20,020 >> Hivyo kama wewe kutumia hii, itakuwa kweli tu 1134 00:59:20,020 --> 00:59:23,120 magazeti nje chochote kutofautiana kwamba wewe kama hayo kwa. 1135 00:59:23,120 --> 00:59:29,000 Hivyo kama wewe ni kuwa na matatizo ya kuhesabia nini safu hii inaonekana kama, 1136 00:59:29,000 --> 00:59:31,920 au kile data hii kwa kweli, jinsi ya mpangilio 1137 00:59:31,920 --> 00:59:33,280 hili ni jambo kubwa kutumia. 1138 00:59:33,280 --> 00:59:39,889 Hasa wakati una user na nyingi ya hisa, 1139 00:59:39,889 --> 00:59:41,680 hii ni kwenda kuwa jambo kubwa kutumia. 1140 00:59:41,680 --> 00:59:42,890 Sababu inaweza kuwa formatted-- 1141 00:59:42,890 --> 00:59:45,806 >> Najua angalau kwa ajili yangu wakati mimi pset hii, ilikuwa formatted katika njia 1142 00:59:45,806 --> 00:59:47,210 kwamba sikuwa kabisa kutarajia. 1143 00:59:47,210 --> 00:59:49,960 Hivyo mimi alikuwa anajaribu iterate juu ya na kujaribu kuendesha yake, 1144 00:59:49,960 --> 00:59:52,350 lakini mimi si kweli kuelewa nini nilikuwa kufanya. 1145 00:59:52,350 --> 00:59:56,830 Hivyo kama wewe tu dampo hilo, ni mapenzi magazeti ya nje kwa browser, 1146 00:59:56,830 --> 00:59:59,220 na unaweza kuona hasa jinsi gani formatted. 1147 00:59:59,220 --> 01:00:03,530 Utakuwa kawaida magazeti ya nje kama safu na funguo yake na maadili yake. 1148 01:00:03,530 --> 01:00:04,637 Hivyo inaweza kusaidia pale. 1149 01:00:04,637 --> 01:00:06,720 Inaweza pia kusaidia kufanya kuhakikisha kwamba wewe ni kweli 1150 01:00:06,720 --> 01:00:09,070 grabbing data kwamba wewe walidhani walikuwa. 1151 01:00:09,070 --> 01:00:12,950 Hivyo kama wewe walikuwa kama, meza yangu dhahiri anasema kuna user kwa ID hii, 1152 01:00:12,950 --> 01:00:15,260 lakini wakati wa kwenda dampo kutofautiana, si huko, 1153 01:00:15,260 --> 01:00:17,551 wewe ni wazi kujua kwamba ambapo kosa kwenda kuwa. 1154 01:00:17,551 --> 01:00:22,180 Hii ni moja ya zana bora kwa debugging, kwa maoni yangu. 1155 01:00:22,180 --> 01:00:24,480 Na kisha kuna wanandoa mambo mengine hapa, 1156 01:00:24,480 --> 01:00:27,660 lakini kwa sehemu kubwa, kwamba ni moja nataka kuteka mawazo yako kwa, 1157 01:00:27,660 --> 01:00:31,060 sababu ni msaada sana. 1158 01:00:31,060 --> 01:00:35,800 >> Umma, nini sisi hapa ni, hii yote ni ya CSS mambo yetu. 1159 01:00:35,800 --> 01:00:40,520 Hivyo CSS, fonts, picha wetu, whatnot. 1160 01:00:40,520 --> 01:00:43,255 Hii ni mambo yote huna kurekebisha. 1161 01:00:43,255 --> 01:00:46,070 1162 01:00:46,070 --> 01:00:50,080 Unaweza guys kufikiri kuhusu kama hii ina mambo kama CSS katika fonts, 1163 01:00:50,080 --> 01:00:54,039 ingekuwa hii kuwa mfano wa kuigwa, au maoni, au mtawala? 1164 01:00:54,039 --> 01:00:54,914 Watazamaji: [inaudible] 1165 01:00:54,914 --> 01:00:57,080 ALLISON BUCHHOLTZ-AU: Ni d kuwa zaidi ya maoni, haki? 1166 01:00:57,080 --> 01:01:00,510 Hii ni utunzaji kila mambo, jinsi mambo kuangalia. 1167 01:01:00,510 --> 01:01:03,500 Hivyo kama sisi kufungua hii hapa, tunaona kwamba yote yanayotokea hapa 1168 01:01:03,500 --> 01:01:05,060 ni sisi ni utoaji kitu. 1169 01:01:05,060 --> 01:01:05,820 OK? 1170 01:01:05,820 --> 01:01:09,710 Hivyo hii ingekuwa sana kuhitimu kama maoni kwa hili. 1171 01:01:09,710 --> 01:01:14,810 Hivyo hii ni kuchukua baadhi tu, ni wito baadhi portfolio.php 1172 01:01:14,810 --> 01:01:19,430 kwamba tuna, na ni kupita katika cheo na kwingineko. 1173 01:01:19,430 --> 01:01:20,696 Na ni utoaji tu. 1174 01:01:20,696 --> 01:01:21,820 Kweli, mimi kuchukua nyuma. 1175 01:01:21,820 --> 01:01:27,890 Hii ni mtawala, kwa sababu atatoa, kumbuka, mithili ya maoni. 1176 01:01:27,890 --> 01:01:30,832 Hivyo portfolio.php katika hii kesi itakuwa maoni yako. 1177 01:01:30,832 --> 01:01:32,480 Pole, guys. 1178 01:01:32,480 --> 01:01:36,160 Portfolio.php ni kwenda kuwa na maoni yako, na hii ingekuwa tu 1179 01:01:36,160 --> 01:01:38,730 kuwa mtawala wako kwa ajili hiyo. 1180 01:01:38,730 --> 01:01:43,120 Na kama sisi kuchukua kuangalia hii mwisho moja hapa, templates, 1181 01:01:43,120 --> 01:01:47,330 templates ni wote wa maoni yako hapa. 1182 01:01:47,330 --> 01:01:52,420 Hivyo kama sisi kuangalia, ni wazi sisi kuona mengi ya HTML hapa. 1183 01:01:52,420 --> 01:01:58,920 >> Hivyo hii moja ni kuonyesha wewe tu kile ukurasa wa kuingia inapaswa kuangalia kama. 1184 01:01:58,920 --> 01:02:04,810 Taarifa tuna baadhi ya makundi fomu, na kuwasilisha. 1185 01:02:04,810 --> 01:02:08,510 Hapa ni jinsi ya kuamua nini ni kuonyeshwa kwenye huko. 1186 01:02:08,510 --> 01:02:14,320 Una baadhi ya aina ya kifungo = "kuwasilisha", na kisha una nini unataka 1187 01:02:14,320 --> 01:02:16,670 kuonyesha katika kifungo. 1188 01:02:16,670 --> 01:02:19,860 Hivyo hiyo ni jinsi gani kufanya hivyo show up kama chochote Ningependa. 1189 01:02:19,860 --> 01:02:24,520 >> Na tunaona hapa tuna baadhi ya jina la mtumiaji, baadhi password, 1190 01:02:24,520 --> 01:02:30,590 na wakati sisi kweli kugonga Kuwasilisha, ni kwenda kuwa baadhi ya posta, 1191 01:02:30,590 --> 01:02:33,346 na ni kwenda baada ya kwa nini? 1192 01:02:33,346 --> 01:02:35,430 Nini mtawala kwa mtazamo huu? 1193 01:02:35,430 --> 01:02:38,040 1194 01:02:38,040 --> 01:02:40,940 Wakati sisi kugonga Kuwasilisha, nini kinaendelea kuitwa? 1195 01:02:40,940 --> 01:02:42,990 Je, sisi kujua? 1196 01:02:42,990 --> 01:02:45,560 Ni haki hapa, hivyo login.php. 1197 01:02:45,560 --> 01:02:47,600 Kitu nyie ni kwenda kutekeleza. 1198 01:02:47,600 --> 01:02:50,580 >> Hivyo unaweza daima kuwaambia nini kinaendelea kuwa 1199 01:02:50,580 --> 01:02:53,740 aitwaye baada ya kugonga Kuwasilisha na line hii ya kwanza hapa. 1200 01:02:53,740 --> 01:02:55,440 Nini aina ya hatua ni. 1201 01:02:55,440 --> 01:02:58,350 Wakati aina hii ni kuwasilishwa, hatua gani sisi kuchukua? 1202 01:02:58,350 --> 01:03:01,440 Tunatoa wito login.php, na sisi kuiita kwa njia hii 1203 01:03:01,440 --> 01:03:05,500 ya mwisho, ambayo ina habari ya siri. 1204 01:03:05,500 --> 01:03:06,210 OK? 1205 01:03:06,210 --> 01:03:14,485 Hivyo hii ni maoni yako, na basi ni wazi kama sisi akaenda login.php-- Je sisi kuwa nayo 1206 01:03:14,485 --> 01:03:16,025 bado? 1207 01:03:16,025 --> 01:03:17,970 Yeah. 1208 01:03:17,970 --> 01:03:21,950 >> Hivyo kama sisi kuona hapa, hii ina mantiki mengi zaidi. 1209 01:03:21,950 --> 01:03:23,570 Ni PHP yetu yote hapa. 1210 01:03:23,570 --> 01:03:28,870 Sisi ni kujaribu kuona kama ilikuwa $ _GET, kama ilikuwa $ _POST, validering mambo, 1211 01:03:28,870 --> 01:03:31,370 querying, mambo haya yote. 1212 01:03:31,370 --> 01:03:34,950 1213 01:03:34,950 --> 01:03:40,200 Hivyo wale ni tu tatu mambo mbalimbali hapa. 1214 01:03:40,200 --> 01:03:43,750 huna kubadili mambo. 1215 01:03:43,750 --> 01:03:46,540 Wewe utakuwa kujenga mambo katika template, pengine, 1216 01:03:46,540 --> 01:03:51,350 lakini mbali kama HTML au styling ya yoyote ya hii inakwenda, 1217 01:03:51,350 --> 01:03:54,550 unaweza kuondoka kama wazi au kama intricate kama Ningependa. 1218 01:03:54,550 --> 01:03:59,800 >> Baadhi ya watu kupata kweli ndani yake na kufanya baadhi ya Nje pretty kutisha. 1219 01:03:59,800 --> 01:04:00,940 Huna kufanya hivyo. 1220 01:04:00,940 --> 01:04:03,750 Kama una muda, ni Jambo kweli baridi. 1221 01:04:03,750 --> 01:04:08,260 Unaweza fujo karibu na CSS na HTML na kupata kujisikia bora zaidi kwa ajili yake, 1222 01:04:08,260 --> 01:04:10,810 lakini si kujisikia kusukumwa. 1223 01:04:10,810 --> 01:04:14,760 Kuna mengi kwa ajili ya kufanya juu ya nyuma mwisho na kutekeleza kuingia kwenye, 1224 01:04:14,760 --> 01:04:17,170 na kusajili, na mambo yote haya. 1225 01:04:17,170 --> 01:04:20,490 >> Hivyo hopefully ambayo husaidia kidogo. 1226 01:04:20,490 --> 01:04:23,430 guys una maswali yoyote kuhusu chochote tumeenda juu, 1227 01:04:23,430 --> 01:04:25,690 rasilimali nyingine yoyote? 1228 01:04:25,690 --> 01:04:31,160 Mimi dhahiri kutuma yote ya mfano wangu PHP kificho kwa nyie, 1229 01:04:31,160 --> 01:04:35,020 na kisha kujisikia huru kuchukua picha au whatnot ya hii. 1230 01:04:35,020 --> 01:04:36,180 Pia ni online. 1231 01:04:36,180 --> 01:04:39,010 Unaweza daima kuangalia tu tena. 1232 01:04:39,010 --> 01:04:42,190 Hivyo kama hiyo ni, kila mtu mwema? 1233 01:04:42,190 --> 01:04:42,690 Ndiyo. 1234 01:04:42,690 --> 01:04:44,523 >> Watazamaji: Mimi nataka tu kuthibitisha, wakati sisi ni 1235 01:04:44,523 --> 01:04:47,447 kufanya kuchagua katika SQL, nyota ina maana kila kitu, haki? 1236 01:04:47,447 --> 01:04:48,530 ALLISON BUCHHOLTZ-AU: Ndiyo. 1237 01:04:48,530 --> 01:04:50,446 Watazamaji: Na kisha kama huna nyota, 1238 01:04:50,446 --> 01:04:53,732 kama unataka kuchukua kutoka maalum mstari, basi tu ya kuweka jina of-- 1239 01:04:53,732 --> 01:04:55,440 ALLISON BUCHHOLTZ-AU: jina la mstari 1240 01:04:55,440 --> 01:04:56,240 na nini unataka unataka thamani ya. 1241 01:04:56,240 --> 01:04:57,577 >> Watazamaji: Na kisha tarehe. 1242 01:04:57,577 --> 01:04:59,910 ALLISON BUCHHOLTZ-AU: Kheri wewe ni kuangalia kwa, yeah. 1243 01:04:59,910 --> 01:05:05,100 Katika njia sawa, kama wewe kufanya Delete * kutoka baadhi ya meza, utakuwa kufuta kila kitu. 1244 01:05:05,100 --> 01:05:08,896 Hivyo, * ni pori kadi kwa kila kitu. 1245 01:05:08,896 --> 01:05:09,788 >> Watazamaji: OK. 1246 01:05:09,788 --> 01:05:10,930 >> ALLISON BUCHHOLTZ-AU: Baridi. 1247 01:05:10,930 --> 01:05:11,430 Kutisha. 1248 01:05:11,430 --> 01:05:12,800 Naam, kuwa kubwa Jumatatu, guys. 1249 01:05:12,800 --> 01:05:13,760 Mimi nitawaoneni wiki ijayo. 1250 01:05:13,760 --> 01:05:15,530 Bahati nzuri juu ya pset yako. 1251 01:05:15,530 --> 01:05:16,992