1 00:00:00,000 --> 00:00:10,393 >> [MUSIC PLAYING] 2 00:00:10,393 --> 00:00:11,037 3 00:00:11,037 --> 00:00:12,120 DAVID J. MALAN: B眉t眉n sa臒. 4 00:00:12,120 --> 00:00:12,830 Geri g蓹lmisiniz. 5 00:00:12,830 --> 00:00:13,890 Bu CS50 edir. 6 00:00:13,890 --> 00:00:15,570 Bu h蓹ft蓹 8 sonu. 7 00:00:15,570 --> 00:00:18,360 Bildiyiniz kimi, biz olduqca var bir ne莽蓹 m眉nt蓹z蓹m ofis saat 8 00:00:18,360 --> 00:00:21,090 yem蓹k m蓹艧臒ul, Annenberg o c眉ml蓹d蓹n. 9 00:00:21,090 --> 00:00:23,860 V蓹 komandan谋n b蓹zi xahi艧 son vaxtlar b蓹zi photos etdi. 10 00:00:23,860 --> 00:00:26,230 V蓹 艧蓹r蓹fin蓹 Halloween, biz ist蓹diyiniz d眉艧眉nd眉m 11 00:00:26,230 --> 00:00:30,160 daha biz蓹 tutdu ki, bir pay s眉rpriz burada Annenberg Salonunda yaln谋z 12 00:00:30,160 --> 00:00:31,490 dig蓹r gec蓹. 13 00:00:31,490 --> 00:00:36,300 Sizin sinif yolda艧谋 Yaqub 莽蓹kdirdi Bu 艧蓹kil, lakin daha 蓹yl蓹nc蓹li idi 14 00:00:36,300 --> 00:00:39,760 Facebook idi, g蓹l蓹n sonra n蓹 ba艧 verdi ki, s枚hb蓹t. 15 00:00:39,760 --> 00:00:43,020 >> Cavab Onun ilk post Onun foto bu idi. 16 00:00:43,020 --> 00:00:46,740 Bir ne莽蓹 d蓹qiq蓹 sonra, o q蓹rar Bu 枚z眉 q蓹d蓹r bir. 17 00:00:46,740 --> 00:00:53,800 Bu, bu getm蓹k sonra getdi v蓹 sonra, daha g眉lm蓹li 18 00:00:53,800 --> 00:00:55,320 Onun anas谋 chimed zaman. 19 00:00:55,320 --> 00:00:59,240 20 00:00:59,240 --> 00:01:01,800 V蓹 sonra n蓹hay蓹t, bu yaln谋z idi g枚r眉n眉r 21 00:01:01,800 --> 00:01:04,860 bir g枚z蓹l hiyl蓹 olur ki oynay谋r. 22 00:01:04,860 --> 00:01:07,080 >> Bel蓹 ki, siz ist蓹yirsinizs蓹 Yaqub v蓹 ba艧qalar谋 g枚rm蓹k, 23 00:01:07,080 --> 00:01:10,880 Onlar谋n aras谋nda Cynthia Meng, kim CS50 zona hey蓹ti p蓹rd蓹 arxas谋nda, 24 00:01:10,880 --> 00:01:13,970 bu URL burada bu oyun giderim. 25 00:01:13,970 --> 00:01:18,810 Bel蓹 ki, daha ADO olmadan, biz bu g眉n , web proqramla艧d谋rma bu g枚z davam 26 00:01:18,810 --> 00:01:21,810 v蓹 proqramlar谋 faktiki yarad谋lmas谋 ki, command line 莽al谋艧谋r deyil 27 00:01:21,810 --> 00:01:24,080 lakin 蓹v蓹zin蓹 bir browser daxilind蓹 ax谋r. 28 00:01:24,080 --> 00:01:26,320 >> Ehtimal indi v蓹 ya 莽ox q谋sa, siz olacaq 29 00:01:26,320 --> 00:01:30,200 h蓹yata ortas谋nda olmaq 脰z web server olan 30 00:01:30,200 --> 00:01:31,700 web proqramla艧d谋rma f蓹rqlidir. 31 00:01:31,700 --> 00:01:36,210 Pset6 web server b眉t眉n haqq谋nda bilir ki, proqram yaz谋l谋 etm蓹k 32 00:01:36,210 --> 00:01:39,300 Bir brauzer HTTP istekleri, v蓹 ya h蓹tta siz, bir insan, 33 00:01:39,300 --> 00:01:42,340 bir proqram il蓹 Telnet adlan谋r v蓹 sonra da h蓹min m眉raci蓹tl蓹r蓹 cavab 34 00:01:42,340 --> 00:01:48,600 HTML fayl谋 h蓹yata spitting, v蓹 ya bir jpeg, v蓹 ya gif, v蓹 ya h蓹tta bir Php fayl. 35 00:01:48,600 --> 00:01:52,490 >> Lakin bir web server il蓹, bu deyil Yaln谋z bir PHP fayl a莽maq 眉莽眉n ehtimal, 36 00:01:52,490 --> 00:01:55,260 php bit蓹n bir 艧ey, v蓹 sonra m蓹zmunu t眉p眉rm蓹k. 37 00:01:55,260 --> 00:01:58,440 Bunu ehtimal n蓹 ilk fayl? 38 00:01:58,440 --> 00:01:59,390 Bel蓹 dan谋艧maq. 39 00:01:59,390 --> 00:02:04,060 T蓹rtib deyil, biz bazar ert蓹si bildirib lakin rather-- Bel蓹 ki, 艧蓹rh. 40 00:02:04,060 --> 00:02:08,070 >> PHP bir 艧蓹rh dil var, v蓹 Sizin web 蓹sas x眉susiyy蓹tl蓹rind蓹n biridir 41 00:02:08,070 --> 00:02:11,550 server, h蓹yata ke莽irdiyimiz olsa, web server 眉莽眉n bu qabiliyy蓹ti 42 00:02:11,550 --> 00:02:12,490 oh, qeyd etm蓹k. 43 00:02:12,490 --> 00:02:14,580 Bu php bit蓹n bir fayl. 44 00:02:14,580 --> 00:02:17,970 M蓹n蓹 yaln谋z g枚nd蓹rm蓹k ed蓹k bu kimi istifad蓹莽i, statik content var 45 00:02:17,970 --> 00:02:20,970 蓹ksin蓹 m蓹n蓹 onu line oxumaq line, sa臒, v蓹 艧蓹rh. 46 00:02:20,970 --> 00:02:23,030 >> V蓹 bunu, siz ki, u艧aqlar mahiyy蓹tc蓹 ed蓹c蓹k 47 00:02:23,030 --> 00:02:26,520 cihaz bir proqram ayaqla z蓹rb蓹, v蓹 komp眉ter sisteml蓹ri bir 莽ox, 48 00:02:26,520 --> 00:02:27,500 yaln谋z PHP 莽a臒谋r谋b. 49 00:02:27,500 --> 00:02:30,579 PHP n谋n ad谋 dil 枚z t蓹rc眉m蓹莽i. 50 00:02:30,579 --> 00:02:33,120 Bel蓹 ki, par莽a biz h蓹yata Siz v蓹 n蓹 眉莽眉n t蓹rk edir 51 00:02:33,120 --> 00:02:35,240 n蓹tic蓹d蓹, bir s谋ra 蓹d蓹d, aras谋nda 52 00:02:35,240 --> 00:02:37,960 d蓹st蓹k h蓹yata ke莽irir statik m蓹zmun 眉莽眉n. 53 00:02:37,960 --> 00:02:40,180 >> Amma indi, v蓹 problem ist蓹yirik, yeddi m眉蓹yy蓹n 54 00:02:40,180 --> 00:02:43,660 ke莽id ba艧lamaq niyy蓹tind蓹dir h蓹qiq蓹t蓹n PHP kodu yazmaq 55 00:02:43,660 --> 00:02:45,970 ki, 艧蓹rh olur geri sonuna s枚hb蓹t 56 00:02:45,970 --> 00:02:47,960 m蓹lumat saklar veril蓹nl蓹r bazas谋. 57 00:02:47,960 --> 00:02:51,020 Bel蓹 ki, ilk daha yax艧谋 anlamaq ed蓹k Bu superglobals bir ne莽蓹 58 00:02:51,020 --> 00:02:53,720 v蓹 yaln谋z n蓹 q蓹d蓹r g眉c Pulsuz 眉莽眉n qutusu 莽谋xmaq 59 00:02:53,720 --> 00:02:55,250 PHP kimi bir dil il蓹. 60 00:02:55,250 --> 00:02:57,350 Siz yoxdur Things 枚z眉n眉z眉 h蓹yata ke莽irilm蓹si. 61 00:02:57,350 --> 00:03:01,700 >> Bel蓹 ki, biz, Bazar ert蓹si $ _GET g枚rd眉m bir superglobal, 62 00:03:01,700 --> 00:03:05,496 PHP qlobal hans谋 dan谋艧maq yaln谋z edir ist蓹diyiniz yerd蓹 daxil ola bil蓹rsiniz d蓹yi艧蓹n. 63 00:03:05,496 --> 00:03:06,620 V蓹 _GET dollar daxilind蓹 n蓹 var? 64 00:03:06,620 --> 00:03:09,930 65 00:03:09,930 --> 00:03:12,110 Bu daxilind蓹 nedir g枚r眉r眉k ki superglobal? 66 00:03:12,110 --> 00:03:15,900 67 00:03:15,900 --> 00:03:19,020 艦眉bh蓹siz ki, statistik at 蓹n az谋 bir 艧蓹xs bilir. 68 00:03:19,020 --> 00:03:21,590 N蓹 _GET dollar daxilind蓹 var? 69 00:03:21,590 --> 00:03:22,426 B蓹li? 70 00:03:22,426 --> 00:03:24,130 >> Auditoriya: Bu d蓹yi艧蓹nl蓹r var Siz sor臒u simli qoydu. 71 00:03:24,130 --> 00:03:24,530 >> DAVID J. MALAN: Perfect. 72 00:03:24,530 --> 00:03:26,488 Bu d蓹yi艧蓹nl蓹rin var sor臒u simli qoydu. 73 00:03:26,488 --> 00:03:29,910 Bel蓹 ki, bizim ya艧l谋 n眉mun蓹 biz zaman Google reimplementing 74 00:03:29,910 --> 00:03:34,130 bir URL, sonra sual i艧ar蓹si, olan HTTP start ay谋r谋r 75 00:03:34,130 --> 00:03:37,950 parametrl蓹ri, sonra biz b蓹rab蓹r q idi bir 艧ey, q pi艧ik b蓹rab蓹rdir kimi, 76 00:03:37,950 --> 00:03:41,500 avtomatik daxilind蓹 n蓹 getm蓹k olard谋 Sizin 眉莽眉n super qlobal ki, $ _GET ki, 77 00:03:41,500 --> 00:03:47,430 PHP, 莽眉nki Q bir 蓹sas v蓹 pi艧ik onlar谋n d蓹y蓹rinin. 78 00:03:47,430 --> 00:03:51,250 >> Ba艧qa s枚zl蓹, $ _GET v蓹 b眉t眉n bunlar assosiativ seriallarda, 79 00:03:51,250 --> 00:03:54,530 n枚v hash masalar ki, ma臒aza d眉ym蓹l蓹ri v蓹 d蓹y蓹rl蓹r. 80 00:03:54,530 --> 00:03:57,980 陌ndi geri pset5, bu hash masa h蓹yata ola bil蓹r, 81 00:03:57,980 --> 00:04:00,220 v蓹 ya siz ola bil蓹r c蓹hd H蓹qiq蓹t蓹n, h蓹yata 82 00:04:00,220 --> 00:04:04,010 s蓹m蓹r蓹li assosiativ idi array data qurulu艧u 83 00:04:04,010 --> 00:04:07,220 qovu艧durma臒谋m谋z 艧蓹rik bil蓹r d蓹y蓹rl蓹ri il蓹 d眉ym蓹l蓹ri. 84 00:04:07,220 --> 00:04:09,690 >> Amma pset5, d蓹y蓹rl蓹rimizin m蓹nas谋z idi. 85 00:04:09,690 --> 00:04:12,430 D蓹y蓹ri mahiyy蓹tc蓹 do臒ru v蓹 ya yalan idi. 86 00:04:12,430 --> 00:04:13,900 L眉臒蓹t蓹 s枚z? 87 00:04:13,900 --> 00:04:18,279 Bel蓹 ki, zaman alma kimi bir s枚z hashed alma l眉臒蓹t g枚rmek 眉莽眉n, 88 00:04:18,279 --> 00:04:21,820 Sizin 莽ek funksiyas谋 ehtimalla do臒ru v蓹 ya yalan d枚nd眉. 89 00:04:21,820 --> 00:04:24,120 Bel蓹 ki, s蓹m蓹r蓹li deyil d蓹y蓹ri biz geri al谋r谋q. 90 00:04:24,120 --> 00:04:26,456 >> Amma biz bazar ert蓹si g枚rd眉m q谋sa, 蓹lb蓹tt蓹 bil蓹rsiniz 91 00:04:26,456 --> 00:04:28,830 daha maraql谋 艧蓹rik yaln谋z do臒ru v蓹 ya yalan 莽ox d蓹y蓹rl蓹ri 92 00:04:28,830 --> 00:04:30,790 alma kimi d眉ym蓹l蓹ri il蓹. 93 00:04:30,790 --> 00:04:33,909 Siz, h蓹qiq蓹t蓹n, bir qay谋tmaq bil蓹r ixtiyari simli, h蓹qiq蓹t蓹n, 94 00:04:33,909 --> 00:04:36,200 n蓹 $ _GET v蓹 bu var dig蓹r d蓹yi艧蓹nl蓹rin n蓹 bildirin. 95 00:04:36,200 --> 00:04:40,595 >> Bel蓹 ki $ _POST, ruhu ox艧ar ancaq po莽t vasit蓹sil蓹 formada t蓹qdim 蓹g蓹r, 96 00:04:40,595 --> 00:04:44,490 ki, f蓹rqli bir HTTP metodu kredit kartlar谋 kimi 艧eyl蓹r 眉莽眉n istifad蓹, 97 00:04:44,490 --> 00:04:48,410 v蓹 枚z蓹l informasiya, v蓹 h蓹tta photos kimi binar informasiya, 98 00:04:48,410 --> 00:04:51,840 o 艧eyi $ _POST daxilind蓹 son. 99 00:04:51,840 --> 00:04:53,770 V蓹 h蓹qiq蓹t蓹n fayllar 眉莽眉n jpegs v蓹 etajer kimi, 100 00:04:53,770 --> 00:04:58,290 bel蓹 ki, ba艧qa var burada h蓹m莽inin $ _FILES 莽a臒谋r谋b. 101 00:04:58,290 --> 00:05:01,280 >> Bel蓹 ki, server biz d蓹 dayanmaq deyil 莽ox, lakin bu imkan谋 verir 102 00:05:01,280 --> 00:05:04,860 haqq谋nda a艧a臒谋 s蓹viyy蓹li m蓹lumat v蓹 d眉zm蓹k 眉莽眉n istifad蓹 etdiyiniz server 枚z眉. 103 00:05:04,860 --> 00:05:07,430 Cookie v蓹 sessiya olsa da, biz s蓹m蓹r蓹li indi g枚r眉rs眉n眉z. 104 00:05:07,430 --> 00:05:10,940 Son biz h蓹yata ke莽irm蓹k 眉莽眉n istifad蓹 n蓹 bir al谋艧-veri艧 sepeti anlay谋艧谋. 105 00:05:10,940 --> 00:05:14,480 A super sad蓹 bir, lakin geri ki, burada bu n眉mun蓹 idi 106 00:05:14,480 --> 00:05:17,640 Ne莽蓹 d蓹f蓹 hesablanmas谋 蓹vv蓹l bu s蓹hif蓹ni ziyar蓹t etmi艧di. 107 00:05:17,640 --> 00:05:20,850 >> Amma bu g眉n deyil, yaln谋z baxmaq 莽ox Bu t蓹siri q蓹d蓹r a莽maq 108 00:05:20,850 --> 00:05:22,640 Chrome inspektor, siz ad蓹t蓹n bil蓹rsiniz 109 00:05:22,640 --> 00:05:25,740 sa臒 t谋klayarak v蓹 ya n蓹zar蓹t ed蓹 h蓹r hans谋 bir web page t谋klayarak, 110 00:05:25,740 --> 00:05:27,250 v蓹 sonra element yoxlamaq download. 111 00:05:27,250 --> 00:05:31,600 Yoxsa menyular il蓹 getm蓹k olar biz pset6 nin Spec t蓹svir edir. 112 00:05:31,600 --> 00:05:35,020 M蓹n Network ni艧an谋 gedir蓹m burada, v蓹 bir an izl蓹m蓹k imkan 113 00:05:35,020 --> 00:05:37,590 ki, HTTP trafik geri v蓹 ir蓹li gedir. 114 00:05:37,590 --> 00:05:40,929 >> M蓹n蓹 ilk davam ed蓹k v蓹 ayd谋n Chrome cache. 115 00:05:40,929 --> 00:05:43,470 Bel蓹 ki, b蓹zi tan谋艧 ola bil蓹r art谋q bu texnika il蓹, 116 00:05:43,470 --> 00:05:45,790 v蓹 biz bunu istifad蓹 etm蓹k olacaq burada ay谋klama m蓹qs蓹dl蓹ri 眉莽眉n. 117 00:05:45,790 --> 00:05:48,890 118 00:05:48,890 --> 00:05:50,890 陌ndi biz komp眉ter elm ba艧lamaq 眉莽眉n gedir 119 00:05:50,890 --> 00:05:53,920 ay谋klama 眉莽眉n bunu m蓹qs蓹dl蓹ri, vasit蓹si 120 00:05:53,920 --> 00:05:55,910 biz cache ayd谋n olacaq, ad蓹t蓹n, bel蓹 ki, biz 121 00:05:55,910 --> 00:05:57,670 cookies adlanan 艧eyi xilas ed蓹 bil蓹rsiniz. 122 00:05:57,670 --> 00:06:01,700 Bel蓹likl蓹, siz y蓹qin ki, 眉mumiyy蓹tl蓹 tan谋艧 edirik n蓹 il蓹 cookies 蓹n az谋, v蓹 ya 123 00:06:01,700 --> 00:06:04,370 ki, onlar var, lakin n蓹 Onlar谋n sizin anla艧ma, 124 00:06:04,370 --> 00:06:06,920 yaln谋z bir istifad蓹莽i kimi komp眉ter, bir cookie n蓹dir? 125 00:06:06,920 --> 00:06:09,490 126 00:06:09,490 --> 00:06:09,990 B蓹li. 127 00:06:09,990 --> 00:06:14,391 >> Auditoriya: Bu, kontormerinin T蓹f蓹rr眉atlar d蓹 bir az deyil komp眉ter m眉dd蓹tin蓹 bit. 128 00:06:14,391 --> 00:06:18,303 Bu data par莽a var ki, bir veb 眉莽眉n siz蓹 g枚nd蓹rir 129 00:06:18,303 --> 00:06:20,209 siz蓹 statistika yazmaq etm蓹k. 130 00:06:20,209 --> 00:06:21,250 DAVID J. MALAN: OK, yax艧谋. 131 00:06:21,250 --> 00:06:24,980 Bel蓹 ki, m蓹lumatlar谋n bir par莽a var ki, bir server, komp眉ter 眉z蓹rind蓹 qoyur 132 00:06:24,980 --> 00:06:28,840 v蓹 bunu h蓹tta 眉mumil蓹艧dirm蓹k ed蓹k daha 莽ox, 蓹sas d蓹y蓹r yax艧谋 var, 133 00:06:28,840 --> 00:06:30,064 daha d蓹qiq 蓹ld蓹 edir. 134 00:06:30,064 --> 00:06:31,980 Bu bir par莽a m蓹lumat m蓹lumatlar谋n bir par莽a, 135 00:06:31,980 --> 00:06:34,430 bir server ed蓹 bil蓹r ki, Bilgisayar谋n谋zda qoymaq 眉莽眉n 136 00:06:34,430 --> 00:06:38,592 v蓹 莽ox tez-tez server yoxdur bu kim yadda kimi. 137 00:06:38,592 --> 00:06:40,300 M蓹s蓹l蓹n, bahis Bel蓹 ki, Siz y蓹qin edirik var 138 00:06:40,300 --> 00:06:42,982 Facebook kimi saytlar daxil, v蓹 ya Gmail, v蓹 ya dig蓹r 蓹vv蓹l 139 00:06:42,982 --> 00:06:44,940 v蓹 il蓹 daxil olun istifad蓹莽i ad谋 v蓹 parol, 140 00:06:44,940 --> 00:06:49,000 v蓹 sonra, bir s谋ra 眉莽眉n d蓹qiq蓹 v蓹 ya saat v蓹 ya h蓹tta g眉n, 141 00:06:49,000 --> 00:06:52,970 server ki, xat谋rlay谋r Siz, 蓹slind蓹, daxil. 142 00:06:52,970 --> 00:06:54,600 陌ndi, nec蓹 h蓹qiq蓹t蓹n ba艧 ki? 143 00:06:54,600 --> 00:06:58,630 Siz 蓹lb蓹tt蓹 ki, retyping deyilik, 莽眉nki istifad蓹莽i ad谋 v蓹 parol h蓹r zaman 144 00:06:58,630 --> 00:07:00,760 Bir gedin Facebook m眉xt蓹lif s蓹hif蓹. 145 00:07:00,760 --> 00:07:02,570 Bel蓹 莽谋x谋r cookies cavab verir. 146 00:07:02,570 --> 00:07:05,360 >> Kimi hesab ed蓹 bil蓹r bir cookie, sort, bir digital 蓹l ist蓹yir蓹m 147 00:07:05,360 --> 00:07:09,200 Bir 蓹yl蓹nc蓹 almaq bil蓹r ki, m枚h眉r眉 park v蓹 ya bir klub oldu臒unu mahiyy蓹tc蓹 148 00:07:09,200 --> 00:07:11,740 Burada olmu艧dur g枚st蓹rir 蓹vv蓹l, v蓹 siz art谋q var 149 00:07:11,740 --> 00:07:16,070 眉莽眉n, martaval 眉莽眉n ID g枚st蓹rilir instansiya ki, klub v蓹 ya park 150 00:07:16,070 --> 00:07:19,050 陌ndi ki, siz g枚t眉rm蓹lidir art谋q t蓹sdiq edilmi艧dir. 151 00:07:19,050 --> 00:07:21,270 Siz art谋q t蓹r蓹find蓹n m眉蓹yy蓹n edilmi艧dir. 152 00:07:21,270 --> 00:07:24,740 >> N蓹z蓹r蓹 Bel蓹 ki, burada counter a莽maq bildirin. 153 00:07:24,740 --> 00:07:27,220 M蓹n yaln谋z, m蓹n蓹 ir蓹li ged蓹k, v蓹 cookies b眉t眉n sil. 154 00:07:27,220 --> 00:07:29,970 陌ndi m蓹n n蓹 gedir蓹m yaln谋z yax艧谋 t蓹dbir 眉莽眉n, Shift ke莽irilm蓹si, 155 00:07:29,970 --> 00:07:31,740 v蓹 zorla s蓹hif蓹 yeniden. 156 00:07:31,740 --> 00:07:34,170 Yaln谋z 蓹min Shift he莽 bir 艧ey cached olur. 157 00:07:34,170 --> 00:07:36,850 V蓹 burada t蓹l蓹bi var geri v蓹 ir蓹li getdi. 158 00:07:36,850 --> 00:07:41,560 Bel蓹 ki, burada biz bir sor臒u var, qoy M蓹n蓹 burada a艧a臒谋 zoom, v蓹 bu bir 莽ox 159 00:07:41,560 --> 00:07:44,710 眉莽眉n sort maraqs谋z 蓹trafl谋 edir brauzer avtomatik indi ki, 160 00:07:44,710 --> 00:07:47,800 g枚nd蓹rdik, amma View bas谋n ed蓹k M蓹nb蓹 xammal ba艧l谋qlar谋n谋 g枚r眉r眉k. 161 00:07:47,800 --> 00:07:51,700 >> V蓹 art谋q pset6 dald谋q olsan谋z, Siz 蓹lb蓹tt蓹 ki, h蓹r 艧eyi tan谋maq laz谋md谋r 162 00:07:51,700 --> 00:07:54,990 bu kimi v蓹 b蓹lk蓹 b蓹zi Burada dig蓹r x蓹tl蓹rin, 163 00:07:54,990 --> 00:07:59,040 lakin n蓹 bu g眉n 眉莽眉n daha maraql谋d谋r M蓹n deyil, t蓹l蓹bi a艧a臒谋 diyirl蓹yin 蓹g蓹r 164 00:07:59,040 --> 00:08:02,870 lakin s枚zd蓹 cavab, Bu x蓹tt y蓹qin ki, tan谋艧 g枚r眉n眉r. 165 00:08:02,870 --> 00:08:04,977 Yax艧谋 bir 艧ey var Siz 200 OK g枚r蓹nd蓹. 166 00:08:04,977 --> 00:08:07,060 Y蓹qin bu deyil server tarixi v蓹 vaxt谋 167 00:08:07,060 --> 00:08:08,268 v蓹 stuff bir d蓹st蓹 var. 168 00:08:08,268 --> 00:08:09,290 Oh, bu maraql谋 deyil. 169 00:08:09,290 --> 00:08:13,430 >> Siz istifad蓹 zaman 莽谋x谋r 茝n az谋 bu server PHP, 170 00:08:13,430 --> 00:08:16,360 server spits n蓹 PHP versiyas谋 istifad蓹 edirik. 171 00:08:16,360 --> 00:08:18,962 T蓹hl眉k蓹sizlik h蓹qiq蓹t蓹n olan, m蓹qs蓹dl蓹ri, yax艧谋 bir 艧ey deyil. 172 00:08:18,962 --> 00:08:21,170 Amma, biz geri g蓹lm蓹k laz谋md谋r b蓹lk蓹 ba艧qa vaxt. 173 00:08:21,170 --> 00:08:25,740 Amma indi bu, 艧ir蓹li line g眉n v蓹 biz q谋sa bu b蓹zi g枚rd眉m 174 00:08:25,740 --> 00:08:29,240 Biz poked zaman Facebook il蓹 d眉艧眉nm蓹k o zaman inspektor 蓹traf谋nda, 175 00:08:29,240 --> 00:08:33,380 set cookie 蓹kin n蓹 m蓹lumat ki, ki莽ik bir par莽a 176 00:08:33,380 --> 00:08:34,890 bilgisayar谋n谋za. 177 00:08:34,890 --> 00:08:37,490 >> Bu HTTP header edir ki, s蓹m蓹r蓹li deyil 178 00:08:37,490 --> 00:08:39,970 Brauzerinizin izah, Chrome, IE, n蓹 olursa olsun, 179 00:08:39,970 --> 00:08:44,480 istifad蓹莽i haqq谋nda hey browser ma臒azas谋 sabit, v蓹 ya istifad蓹莽i RAM, 180 00:08:44,480 --> 00:08:49,680 bir olan PHPSESSID adl谋 蓹sas, sessiya ID stenoqrafiya notation, 181 00:08:49,680 --> 00:08:53,670 v蓹 bu d蓹y蓹r verm蓹k 0vlk8t, n枚qt蓹, n枚qt蓹, n枚qt蓹. 182 00:08:53,670 --> 00:08:56,480 A h蓹qiq蓹t蓹n uzun yalan莽谋 t蓹sad眉fi alfasay谋sal string. 183 00:08:56,480 --> 00:08:59,480 Bu, yaln谋z bir h蓹qiq蓹t蓹n b枚y眉k say谋, lakin Bu m蓹ktublar v蓹 n枚mr蓹l蓹r il蓹 kodlanm谋艧 edir 184 00:08:59,480 --> 00:09:03,550 bel蓹 ki, 枚l莽眉s眉 ola bil蓹r ki, t蓹k ba艧谋na daha b枚y眉k. 185 00:09:03,550 --> 00:09:06,947 V蓹 sonra, yolu il蓹, Path = / ki, bu cookie olmal谋d谋r o dem蓹kdir ki, 186 00:09:06,947 --> 00:09:08,780 il蓹 ba臒l谋 sayt谋n b眉t枚vl眉kd蓹, 187 00:09:08,780 --> 00:09:11,150 yaln谋z x眉susi deyil s蓹hif蓹 b眉t眉n 艧ey. 188 00:09:11,150 --> 00:09:12,930 Bel蓹 ki, bu virtual 蓹l m枚h眉r眉 edir. 189 00:09:12,930 --> 00:09:16,330 Bu, server, Facebook sanki var v蓹 ya bizim halda cihaz da, 190 00:09:16,330 --> 00:09:21,140 s枚z眉n yaz谋l谋 0vlk8t var v蓹 s, sizin t蓹r蓹fd蓹n. 191 00:09:21,140 --> 00:09:24,360 N蓹 serverin ed蓹k bunu deyil deyil deyil 192 00:09:24,360 --> 00:09:27,730 蓹lb蓹tt蓹, m蓹nim istifad蓹莽i ad谋 saxlan谋lmas谋 艦ifr蓹ni saxlan谋lmas谋 deyil. 193 00:09:27,730 --> 00:09:31,710 >> Bunun 蓹v蓹zin蓹, o g枚r眉n眉r yalan莽谋 t蓹sad眉fi saxlan谋lmas谋 m蓹lumat 194 00:09:31,710 --> 00:09:35,010 he莽 bir tahmin ed蓹 bil蓹r ki, M蓹nim 蓹l m枚h眉r眉 n蓹. 195 00:09:35,010 --> 00:09:37,590 Server t蓹r蓹find蓹, eyni zamanda, server 196 00:09:37,590 --> 00:09:40,370 y蓹qin ki, unutmay谋n gedir bir veril蓹nl蓹r bazas谋 v蓹 ya bir 艧ey, 197 00:09:40,370 --> 00:09:46,490 istifad蓹莽i, g蓹l蓹c蓹kd蓹 ed蓹n 0vlk8t bir 蓹l m枚h眉r眉 t蓹qdim, dot 198 00:09:46,490 --> 00:09:51,440 dot, bu il蓹 ba臒l谋 olmal谋d谋r dot X眉susil蓹 al谋艧-veri艧 araba, bel蓹 dan谋艧maq. 199 00:09:51,440 --> 00:09:55,060 Ba艧qa s枚zl蓹, m蓹n indi getm蓹k 蓹g蓹r burada geri v蓹 bu s蓹hif蓹ni yenid蓹n, 200 00:09:55,060 --> 00:09:58,020 server bilir nec蓹 M蓹n bir d蓹f蓹 ziyar蓹t? 201 00:09:58,020 --> 00:10:01,730 >> M蓹n bir daha bunu 蓹g蓹r v蓹 ya, nec蓹 server yoxdur M蓹n iki d蓹f蓹 ziyar蓹t etdik ki, bilirik? 202 00:10:01,730 --> 00:10:04,680 Yax艧谋 m蓹n bu a艧a臒谋 getm蓹k 蓹g蓹r 茝n son ist蓹yi olan 203 00:10:04,680 --> 00:10:09,150 M蓹n g枚nd蓹rdik ki, indi 眉莽眉nc眉 c蓹mi, indi m蓹nim t蓹l蓹bi bil蓹rsiniz. 204 00:10:09,150 --> 00:10:11,300 H蓹l蓹 bu var Burada, eyni up t蓹l蓹b 205 00:10:11,300 --> 00:10:15,040 蓹vv蓹l, h蓹l蓹 bir d蓹st蓹 var biz 蓹vv蓹lki kimi r蓹dd etdik ki, m蓹hsullar谋, 206 00:10:15,040 --> 00:10:19,350 lakin son header, bu vaxt, M蓹n 蓹vv蓹l burada oldu臒unuz 莽眉nki, 207 00:10:19,350 --> 00:10:21,980 bir t蓹qdimat Bu virtual 蓹l m枚h眉r眉. 208 00:10:21,980 --> 00:10:28,957 >> Vasit蓹si bu x蓹tt burada, m眉蓹yy蓹n cookie lakin cookie colon PHPSESSI = 0vlk8t, 209 00:10:28,957 --> 00:10:32,040 ki, yaln谋z m蓹nim browser avtomatik var bel蓹 ki, bu 蓹l m枚h眉r眉 t蓹qdimat谋 210 00:10:32,040 --> 00:10:37,910 陌ndi server, bu, h蓹yata kimi tezlikl蓹, ooh bu istifad蓹莽i 0vlk8t n枚qt蓹, n枚qt蓹, n枚qt蓹, 211 00:10:37,910 --> 00:10:42,010 陌ndi o olan xat谋rlay谋ram bil蓹r ki, istifad蓹莽i il蓹 reassociate n蓹 212 00:10:42,010 --> 00:10:46,450 m蓹lumat ist蓹yir蓹m, v蓹 b眉t眉n informasiya, siz saxlan谋la bil蓹r 213 00:10:46,450 --> 00:10:50,130 $ _SESSION proqram莽谋. 214 00:10:50,130 --> 00:10:57,170 >> M蓹n real tez a莽maq 蓹g蓹r Bel蓹 ki, ayd谋n olmaq gedit ki, faktiki fayl, counter.php, 215 00:10:57,170 --> 00:11:02,340 Yerli host ictimai kataloq 蓹vv蓹lki kimi, h蓹qiq蓹t蓹n, fark, 216 00:11:02,340 --> 00:11:06,860 M蓹n sonda saxlan谋lmas谋 al谋ram $ _SESSION Quote d谋rna臒谋 ba臒lamaq "蓹ks" 217 00:11:06,860 --> 00:11:10,110 蓹vv蓹lki counter d蓹y蓹ri olan M蓹n burada ki, biz bu x蓹tl蓹ri almaq 218 00:11:10,110 --> 00:11:13,010 son d蓹f蓹 plus bir baxd谋. 219 00:11:13,010 --> 00:11:14,980 Ba艧l谋q alt谋nda, bel蓹 ki, b眉t眉n cookies var. 220 00:11:14,980 --> 00:11:17,563 Bu digital yaln谋z sort var 蓹l m枚h眉r眉 geri v蓹 ir蓹li ged蓹n 221 00:11:17,563 --> 00:11:20,450 v蓹 s蓹mimi Chrome Agentliyi a莽maq 蓹g蓹r H蓹r hans谋 bir web Inspector 222 00:11:20,450 --> 00:11:22,580 Siz, bu g眉n ziyar蓹t super ehtimal谋 y眉ks蓹k, 223 00:11:22,580 --> 00:11:25,450 Siz b蓹lk蓹 bir g枚rm蓹k olacaq b蓹lk蓹 yar谋m bir 莽ox cookies 224 00:11:25,450 --> 00:11:26,650 sizin xat谋rlan谋r. 225 00:11:26,650 --> 00:11:29,500 >> V蓹 pis h蓹l蓹, 蓹g蓹r o veb etdiyiniz 226 00:11:29,500 --> 00:11:32,640 b眉t眉n reklam, olan , 蓹lb蓹tt蓹, bu g眉n olduqca 眉mumi 227 00:11:32,640 --> 00:11:36,100 v蓹 h蓹min reklam g蓹lir 蓹g蓹r b蓹zi m蓹rk蓹zi partiya, kims蓹 228 00:11:36,100 --> 00:11:39,000 Google v蓹 ya AdWords kimi onlar onlar谋n m蓹hsullar谋n谋n bir z蓹ng 229 00:11:39,000 --> 00:11:42,880 v蓹 ya dig蓹r sat谋c谋lar ki, reklam satmaq, maraql谋 n蓹, 230 00:11:42,880 --> 00:11:46,510 v蓹 bir az n蓹 s蓹mimi worrisome, HTTP i艧l蓹ri nec蓹 haqq谋nda, 231 00:11:46,510 --> 00:11:50,855 Siz 蓹g蓹r bir reklam 蓹laq蓹dar ki, Facebook.com, v蓹 Google.com in, 232 00:11:50,855 --> 00:11:54,240 v蓹 Harvard.edu, h蓹r hans谋 bir say谋 web, bel蓹 ki, var 233 00:11:54,240 --> 00:11:58,130 xidm蓹t ed蓹n bir orta insan var ki, bu web b眉t眉n 眉莽 reklam up, 234 00:11:58,130 --> 00:12:02,110 ki 莽谋x谋r cookies alan谋 ba艧谋na var. 235 00:12:02,110 --> 00:12:05,910 >> Siz 蓹g蓹r bel蓹 bir reklam g蓹l蓹n m眉xt蓹lif saytlarda eyni 艧irk蓹t, 236 00:12:05,910 --> 00:12:11,140 ki, 艧irk蓹t s蓹m蓹r蓹li kim takip ed蓹 bil蓹rsiniz bu web b眉t眉n aras谋nda var. 237 00:12:11,140 --> 00:12:13,140 Harvard bilmir蓹m bil蓹r Facebook ziyar蓹t edirik. 238 00:12:13,140 --> 00:12:15,306 Facebook bilmir蓹m bil蓹r v蓹 Siz Harvard ziyar蓹t edirik. 239 00:12:15,306 --> 00:12:18,160 Amma n蓹 olursa olsun ad xidm蓹t ki, domen, 蓹g蓹r onlar istifad蓹 etdiyiniz 240 00:12:18,160 --> 00:12:21,710 h蓹m Harvard.edu web m枚vcuddur pages v蓹 Facebook.com web pages, 241 00:12:21,710 --> 00:12:26,850 Bu orta insan 艧眉bh蓹siz ki, kim bilir Bu cookies payla艧谋lan alaraq 242 00:12:26,850 --> 00:12:30,910 aras谋nda, daha do臒rusu, 眉莽眉n ki komisyoncu s枚zd蓹. 243 00:12:30,910 --> 00:12:33,820 >> Bel蓹likl蓹, biz bu qay谋da bil蓹rsiniz onlar谋n t蓹hl眉k蓹sizlik n蓹tic蓹l蓹ri, 244 00:12:33,820 --> 00:12:37,170 lakin m蓹lumat bir 莽ox var he莽 bir zaman haqq谋nda saxlan谋l谋r siz 245 00:12:37,170 --> 00:12:40,120 蓹n h蓹r hans谋 bir web s蓹hif蓹sini ziyar蓹t internet v蓹 h蓹qiq蓹t蓹n 246 00:12:40,120 --> 00:12:42,877 Bu 莽ox sad蓹 mexanizm azald谋r. 247 00:12:42,877 --> 00:12:44,710 N蓹 蓹g蓹r, sonra, olur Siz super paranoid etdiyiniz 248 00:12:44,710 --> 00:12:48,190 v蓹 Chrome v蓹 ya IE daxil q蓹rar v蓹 ya h蓹r hans谋 v蓹 cookies s枚nd眉rm蓹k? 249 00:12:48,190 --> 00:12:49,365 N蓹 olur? 250 00:12:49,365 --> 00:12:50,790 B蓹li? 251 00:12:50,790 --> 00:12:53,170 Siz bu h眉ququ etdik, h蓹qiq蓹t蓹n? 252 00:12:53,170 --> 00:12:54,350 OK. 253 00:12:54,350 --> 00:12:55,994 Xeyr, ir蓹li getm蓹k. 254 00:12:55,994 --> 00:12:59,645 >> Auditoriya: B蓹zi saytlarda yoxdur bu bir funksiyas谋 Facebook kimi. 255 00:12:59,645 --> 00:13:00,520 DAVID J. MALAN: B蓹li! 256 00:13:00,520 --> 00:13:02,311 Bel蓹 ki, m眉蓹yy蓹n saytlar谋 yaln谋z i艧 dayanacaq. 257 00:13:02,311 --> 00:13:05,520 V蓹 蓹n web bu g眉n 蓹sasl谋, cookies etibar 258 00:13:05,520 --> 00:13:08,360 onlar daxil var, x眉susil蓹 d蓹 蓹g蓹r , onlar yaln谋z q谋rmaq olacaq. 259 00:13:08,360 --> 00:13:10,360 N蓹z蓹rd蓹n 脟眉nki alternativ, 蓹g蓹r veb 260 00:13:10,360 --> 00:13:14,480 , kim xat谋rlayaraq he莽 bir yol var v蓹 buna g枚r蓹 d蓹 sizin web browser deyil 261 00:13:14,480 --> 00:13:16,949 h蓹r HTTP il蓹 t蓹msil Bu 蓹l Markan谋n t蓹l蓹bi, 262 00:13:16,949 --> 00:13:18,740 s蓹m蓹r蓹li web Facebook ged蓹n kimi 263 00:13:18,740 --> 00:13:22,050 t蓹klif etm蓹k h蓹r darn d蓹f蓹 daxil 264 00:13:22,050 --> 00:13:26,200 Siz pages d蓹yi艧dirm蓹k, v蓹 ya bir link bas谋n olan x眉susil蓹 yax艧谋 user m眉tl蓹q deyil 265 00:13:26,200 --> 00:13:26,920 t蓹cr眉b蓹. 266 00:13:26,920 --> 00:13:30,020 >> Orada da bel蓹 ticar蓹t off aras谋nda. 267 00:13:30,020 --> 00:13:34,140 Daha ADO olmadan Bel蓹 ki, g枚t眉r蓹k web proqramla艧d谋rma il蓹 veril蓹n, 268 00:13:34,140 --> 00:13:37,630 PHP kimi dill蓹rd蓹, siz yadda bil蓹r problem kimi m蓹lumat set 269 00:13:37,630 --> 00:13:41,550 脰z h蓹yata zaman yeddi Almaq 眉莽眉n olan E * Trade kimi website 270 00:13:41,550 --> 00:13:45,710 v蓹 s蓹hml蓹rinin satmaq, siz d蓹qiq xat谋rlamaq laz谋md谋r Hans谋 istifad蓹莽i al谋n谋b sat谋lan 271 00:13:45,710 --> 00:13:49,110 v蓹 o olan Bu sessiya yolu il蓹. 272 00:13:49,110 --> 00:13:51,110 Amma biz laz谋m olacaq e-po莽t daha merakl谋s谋 yol 273 00:13:51,110 --> 00:13:52,640 蓹traf谋nda informasiya saxlan谋lmas谋 ba艧lamaq 眉莽眉n. 274 00:13:52,640 --> 00:13:53,140 Right? 275 00:13:53,140 --> 00:13:56,780 >> Bazar ert蓹si, biz Frosh Ani dan谋艧d谋q v蓹 nec蓹 web versiyas谋n谋 bir, 276 00:13:56,780 --> 00:14:00,250 il 蓹vv蓹l, biz b眉t眉n idi olan var Proctor e-po莽t 277 00:14:00,250 --> 00:14:04,250 Bu intramural idman m蓹sul proqram谋 ad谋 v蓹 gender, 278 00:14:04,250 --> 00:14:07,330 v蓹 onlar kapitan olsan谋z v蓹 ya, v蓹 kims蓹 yurt kim 279 00:14:07,330 --> 00:14:10,136 bir intramural idman 眉莽眉n qeydiyyatdan. 280 00:14:10,136 --> 00:14:13,010 Bel蓹 ki, pis deyil, lakin o, sonra o e-po莽t vasit蓹sil蓹 c眉ce idi, 281 00:14:13,010 --> 00:14:16,010 Bir elektron tablo v蓹 ya bir 艧ey kimi etm蓹k ki, h蓹r 艧eyi t蓹艧kil saxlamaq 眉莽眉n. 282 00:14:16,010 --> 00:14:19,750 Bel蓹 ki, 艧眉bh蓹siz ki, biz proqram莽谋lar kimi ki, Proctor 眉莽眉n bunu ed蓹 bil蓹rsiniz. 283 00:14:19,750 --> 00:14:22,970 V蓹 SQL daxil, Yap谋land谋r谋lm谋艧 Query Language, 284 00:14:22,970 --> 00:14:26,050 olduqca baxmaq niyy蓹tind蓹 olan C v蓹 PHP h蓹m d蓹 m眉xt蓹lif, 285 00:14:26,050 --> 00:14:30,990 v蓹 daha 莽ox 蓹ll蓹ri dal谋艧 laz谋md谋r PHP v蓹 problem d蓹 yeddi lakin SQL m眉蓹yy蓹n 286 00:14:30,990 --> 00:14:35,310 v蓹 ya SQL, bu dil ki, bir veril蓹nl蓹r bazas谋 dan谋艧maq 眉莽眉n istifad蓹 edin. 287 00:14:35,310 --> 00:14:36,480 >> Amma bir veril蓹nl蓹r bazas谋 var? 288 00:14:36,480 --> 00:14:38,440 Yax艧谋 bir hesab veril蓹nl蓹r bazas谋, 蓹n az谋 indi 眉莽眉n, 289 00:14:38,440 --> 00:14:41,750 yaln谋z bir Excel fayl kimi olan, v蓹 ya Mac istifad蓹莽i bir 蓹d蓹d fayl 蓹g蓹r, 290 00:14:41,750 --> 00:14:44,400 v蓹 ya Google Apps 蓹g蓹r istifad蓹莽i Google tablo, 291 00:14:44,400 --> 00:14:49,120 s蓹m蓹r蓹li bir veril蓹nl蓹r bazas谋 var, v蓹 ya, h蓹qiq蓹t蓹n, x眉susi bir relational veril蓹nl蓹r bazas谋. 292 00:14:49,120 --> 00:14:53,070 A relational veril蓹nl蓹r bazas谋 yaln谋z sat谋r v蓹 s眉tun var ki, bir 艧ey, 293 00:14:53,070 --> 00:14:56,440 v蓹 siz h蓹r c眉r saxlaya bil蓹rsiniz Bu sat谋r v蓹 ya s眉tun m蓹lumat. 294 00:14:56,440 --> 00:15:00,480 >> Lakin, SQL haqq谋nda g枚z蓹l n蓹 var v蓹 faktiki bazalar谋, yaln谋z 295 00:15:00,480 --> 00:15:04,910 tablolar v蓹 ya Google tablolar, Bir dil istifad蓹 ed蓹 bil蓹rsiniz ki, 296 00:15:04,910 --> 00:15:09,000 h蓹qiq蓹t蓹n sor臒u icra data, data aradan qald谋r谋lmas谋 眉莽眉n daxil, 297 00:15:09,000 --> 00:15:11,620 h蓹tta data axtarmaq 眉莽眉n 蓹n 蓹sas谋, v蓹 298 00:15:11,620 --> 00:15:16,110 kifay蓹t q蓹d蓹r 枚z眉n眉z istifad蓹 etm蓹k yoxdur, Siz ad蓹t蓹n Google g眉c kimi 299 00:15:16,110 --> 00:15:17,690 bu kimi elektron tablo. 300 00:15:17,690 --> 00:15:22,217 >> SQL Bel蓹 ki, bir d蓹st蓹 var fundamental hesabatlar谋 v蓹 ya 蓹d蓹d 301 00:15:22,217 --> 00:15:23,300 funksionall谋q in艧a. 302 00:15:23,300 --> 00:15:26,450 Bu daha 莽ox var, ancaq bir b枚y眉k m蓹saf蓹 getm蓹k bil蓹r 303 00:15:26,450 --> 00:15:28,620 yaln谋z bilerek adlanan bu dil 304 00:15:28,620 --> 00:15:30,840 SQL az谋 d枚rd var Siz leverage bil蓹r hesabatlar谋. 305 00:15:30,840 --> 00:15:34,420 >> Data aradan qald谋r谋lmas谋 眉莽眉n, Sil, Sat谋r 蓹lav蓹 etm蓹k 眉莽眉n, daxil edin, 306 00:15:34,420 --> 00:15:37,340 Update, d蓹yi艧dirilm蓹si 眉莽眉n sat谋r, v蓹 se莽ilm蓹si, 307 00:15:37,340 --> 00:15:39,860 sat谋r geri almaq 眉莽眉n v蓹 h蓹qiq蓹t蓹n SQL n蓹 var. 308 00:15:39,860 --> 00:15:43,810 Bu bel蓹 sat谋rlar tamamil蓹 f蓹aliyy蓹t Siz daxil, v蓹 ya aradan qald谋r谋lmas谋 zaman, 309 00:15:43,810 --> 00:15:47,470 v蓹 ya yenil蓹m蓹, v蓹 ya etdiyiniz n蓹 se莽in qondarma n蓹tic蓹 d蓹sti geri almaq, 310 00:15:47,470 --> 00:15:49,690 sat谋r bir s谋ra kimi. 311 00:15:49,690 --> 00:15:51,700 Bir masa sat谋r bir d蓹st蓹. 312 00:15:51,700 --> 00:15:54,050 >> Bel蓹 ki, g眉n geri, v蓹 h蓹tta bu g眉n, 313 00:15:54,050 --> 00:15:56,560 Siz il蓹 qar艧谋l谋ql谋 bil蓹r bir command line istifad蓹 ed蓹r蓹k veril蓹nl蓹r bazas谋, 314 00:15:56,560 --> 00:15:59,691 lakin istifad蓹 etm蓹k x眉susil蓹 蓹yl蓹nc蓹 deyil bu qara v蓹 a臒 stil p蓹nc蓹r蓹 315 00:15:59,691 --> 00:16:02,190 v蓹 h蓹qiq蓹t蓹n 蓹mrl蓹ri yerin蓹 v蓹 veril蓹nl蓹r bazas谋 蓹traf谋nda soxmaq. 316 00:16:02,190 --> 00:16:06,054 A qrafik istifad蓹莽i interfeys, v蓹 ya GUI, , arguably daha 莽ox 眉st眉nl眉k 317 00:16:06,054 --> 00:16:08,970 v蓹 biz g蓹lir al蓹t v蓹 cihaz sizin 眉莽眉n 蓹vv蓹lc蓹d蓹n qurulan 318 00:16:08,970 --> 00:16:10,580 phpMyAdmin adlan谋r. 319 00:16:10,580 --> 00:16:14,060 Bu ki, bir 眉mumi t蓹sad眉f deyil Bu 艧ey ad谋, bu PHP var 320 00:16:14,060 --> 00:16:17,430 yaln谋z insanlar o dem蓹kdir ki, 枚zl蓹rini bu proqram yaz谋b 321 00:16:17,430 --> 00:16:18,670 PHP bunu yazd谋. 322 00:16:18,670 --> 00:16:23,740 >> Amma bu idar蓹 haqq谋nda n蓹tic蓹d蓹 var bir MySQL server kimi bir veril蓹nl蓹r bazas谋 server, 323 00:16:23,740 --> 00:16:26,589 Siz ola bil蓹r ki, siz kimi CS50 cihaz, yoxdur. 324 00:16:26,589 --> 00:16:29,130 Bel蓹 ki, daha 蓹trafl谋 莽ox var burada Biz bu g眉n qay臒谋 laz谋md谋r 325 00:16:29,130 --> 00:16:33,280 lakin n蓹 蓹sas var sol ki, t蓹r蓹fd蓹n bazalar谋 siyah谋s谋 326 00:16:33,280 --> 00:16:36,040 sizin komp眉ter var ki, Sizin CS50 cihaz, 327 00:16:36,040 --> 00:16:40,090 v蓹 ya final layih蓹l蓹r g蓹lib ki, g眉c 眉莽眉nc眉, bir 艧irk蓹tin var 328 00:16:40,090 --> 00:16:43,415 haqqinda v蓹 ya web server ki, Siz yer 眉莽眉n 枚d蓹nilm蓹si bil蓹r. 329 00:16:43,415 --> 00:16:45,290 Bel蓹 ki, sol deyil veril蓹nl蓹r bazas谋, biri 330 00:16:45,290 --> 00:16:48,750 M蓹n n枚vb蓹ti borc olan pset7 edir 眉st, sonra h蓹ft蓹 pset, v蓹 331 00:16:48,750 --> 00:16:51,570 bir var orada qeyd Ni艧anlar d蓹st蓹 olan bir 332 00:16:51,570 --> 00:16:55,150 veril蓹nl蓹r bazas谋, SQL, status edir s istifad蓹莽il蓹r ixrac v蓹. 333 00:16:55,150 --> 00:16:56,900 Bel蓹 ki, uzun bil蓹rsiniz yolu yaln谋z h蓹yata ke莽irilm蓹si 334 00:16:56,900 --> 00:16:59,770 ki, istifad蓹莽i interfeysi 蓹n Sol 眉st s眉tun 335 00:16:59,770 --> 00:17:02,650 v蓹 sa臒 orada 眉st眉nde. 336 00:17:02,650 --> 00:17:04,980 Bel蓹 ki, biz, h蓹qiq蓹t蓹n, bu il蓹 n蓹 ed蓹 bil蓹r? 337 00:17:04,980 --> 00:17:08,609 Yax艧谋, bir yaratmaq ba艧lamaq ed蓹k m蓹lumat bit a艧a臒谋dak谋. 338 00:17:08,609 --> 00:17:11,760 >> A艧a臒谋dak谋 bel蓹dir d眉艧眉n蓹k, Yaln谋z bir ne莽蓹 g眉n olacaq, 339 00:17:11,760 --> 00:17:14,440 Bir h蓹yata ist蓹yir蓹m CS50 Maliyy蓹 deyil蓹n haqqinda, 340 00:17:14,440 --> 00:17:17,328 v蓹 bu veb siz almaq imkan verir d谋rna臒谋 ba臒lamaq sitat v蓹 s蓹hml蓹rinin satmaq. 341 00:17:17,328 --> 00:17:19,619 V蓹 anlamaq 眉莽眉n olacaq h蓹min s蓹hml蓹r qiym蓹ti, 342 00:17:19,619 --> 00:17:22,380 n蓹tic蓹d蓹 g枚r蓹c蓹ksiniz kimi, Yahoo Maliyy蓹 s枚hb蓹t. 343 00:17:22,380 --> 00:17:26,250 Hans谋, g枚z蓹l, bir pulsuz xidm蓹t var Bir fond ticker ke莽蓹 bil蓹r qovu艧durma臒谋m谋z 344 00:17:26,250 --> 00:17:29,830 Google GOOG, v蓹 bu kimi olacaq Google cari fond geri verm蓹k 345 00:17:29,830 --> 00:17:32,250 Ke莽mi艧d蓹 蓹rzind蓹 qiym蓹t ne莽蓹 d蓹qiq蓹 蓹n az谋. 346 00:17:32,250 --> 00:17:35,080 >> Bel蓹 ki, son n蓹tic蓹d蓹 ki, istifad蓹 ed蓹c蓹yik, istifad蓹莽i 眉莽眉n iddia 347 00:17:35,080 --> 00:17:37,750 almaq v蓹 faktiki satmaq virtual pul istifad蓹 ehtiyatlar谋, 348 00:17:37,750 --> 00:17:39,750 lakin 莽ox ilk 艧ey istifad蓹莽i g枚rm蓹k olacaq 349 00:17:39,750 --> 00:17:43,850 onlara soru艧ur bu giri艧 ekran 枚z istifad蓹莽i ad谋 v蓹 艧ifr蓹 眉莽眉n. 350 00:17:43,850 --> 00:17:46,540 V蓹 bel蓹 ki, bir ilk pset7 sizin 眉莽眉n probleml蓹r 351 00:17:46,540 --> 00:17:50,460 geri sonuna h蓹yata olacaq veril蓹nl蓹r bazas谋, tablo siz 蓹g蓹r, 352 00:17:50,460 --> 00:17:53,369 ki, saxlamaq olacaq istifad蓹莽il蓹r adlar谋 v蓹 parol 353 00:17:53,369 --> 00:17:56,660 v蓹 n蓹tic蓹d蓹 onlar 枚z n蓹 s蓹hml蓹r, v蓹 ne莽蓹, v蓹 n蓹 q蓹d蓹r pul onlar var, 354 00:17:56,660 --> 00:18:00,110 dig蓹r 艧eyi bir d蓹st蓹 dig蓹r masalar, v蓹 ya elektron tablolar. 355 00:18:00,110 --> 00:18:05,020 >> Bel蓹 ki, nec蓹 bu n蓹z蓹r ed蓹k ilk bax谋艧da g枚r眉n眉r bil蓹r. 356 00:18:05,020 --> 00:18:06,980 M蓹n geri getm蓹k 眉莽眉n gedir蓹m M蓹n v蓹 cihaz 357 00:18:06,980 --> 00:18:14,102 burada bu URL getm蓹k niyy蓹tind蓹 phpMyAdmin localhost / phpmyadmin 358 00:18:14,102 --> 00:18:16,060 v蓹 bunu ki, g枚r眉rs眉n眉z bir interface m蓹n蓹 edir 359 00:18:16,060 --> 00:18:18,520 tam biz g枚rd眉m kimi ekran shot, v蓹 burada m蓹n 360 00:18:18,520 --> 00:18:21,560 蓹lav蓹 bazas谋 var Bu g眉n 莽a臒谋r谋艧谋 m眉hazir蓹 361 00:18:21,560 --> 00:18:24,280 v蓹 m蓹n蓹 ir蓹li ged蓹k ilk v蓹 pset7 bas谋n. 362 00:18:24,280 --> 00:18:27,940 >> M蓹n variantlar谋 bir ne莽蓹 var g枚r眉n眉r, yeni bir yeni masa yaratmaq 眉莽眉n, 363 00:18:27,940 --> 00:18:30,770 istifad蓹莽il蓹r v蓹 bir link olan M蓹n art谋q yarad谋lm谋艧 bir masa. 364 00:18:30,770 --> 00:18:31,790 Bel蓹 ki, bir masa var? 365 00:18:31,790 --> 00:18:33,740 Excel istifad蓹 蓹g蓹r Bel蓹 ki, 蓹vv蓹l v蓹 siz var 蓹g蓹r 366 00:18:33,740 --> 00:18:37,110 istifad蓹 n枚mr蓹l蓹ri v蓹 ya Google Spreadsheets, bir p蓹nc蓹r蓹 a莽maq 367 00:18:37,110 --> 00:18:39,350 v蓹 b眉t眉n d蓹st蓹 almaq sat谋r v蓹 s眉tun, 368 00:18:39,350 --> 00:18:43,120 lakin sonra ad蓹t蓹n i艧 var alt, ya ayr谋-ayr谋 Ni艧anlar boyunca. 369 00:18:43,120 --> 00:18:46,140 Siz h蓹r hesab ed蓹 bil蓹r bir masa kimi i艧 370 00:18:46,140 --> 00:18:51,150 bel蓹 ki, veril蓹nl蓹r bazas谋, n蓹tic蓹d蓹, bir bir v蓹 ya daha 莽ox masalar birl蓹艧m蓹si, bir 371 00:18:51,150 --> 00:18:54,064 v蓹 ya daha 莽ox worksheets da bir normal tablo d眉nya. 372 00:18:54,064 --> 00:18:55,980 M蓹n蓹 ir蓹li getm蓹k v蓹 Bu i艧 bas谋n 373 00:18:55,980 --> 00:18:59,420 M蓹n premade ki, deyil蓹n istifad蓹莽il蓹r, a.k.a. 374 00:18:59,420 --> 00:19:00,700 Database masa. 375 00:19:00,700 --> 00:19:04,130 M蓹n burada a艧a臒谋 diyirl蓹yin 蓹g蓹r, M蓹n蓹 bir az zoom imkan, 376 00:19:04,130 --> 00:19:08,479 Bu phpMyAdmin izah n蓹 Biz蓹 indi bu masa daxilind蓹. 377 00:19:08,479 --> 00:19:11,020 Bu ilk bir az confusing var n蓹z蓹r UI deyil 378 00:19:11,020 --> 00:19:15,140 D眉nyan谋n 蓹n prettiest 艧ey, lakin n蓹 maraql谋 burada bu hiss蓹sidir. 379 00:19:15,140 --> 00:19:17,970 ID, istifad蓹莽i ad谋 v蓹 hash. 380 00:19:17,970 --> 00:19:20,510 >> 茝vv蓹lc蓹d蓹n, v蓹 siz 蓹lli olacaq Bu problem, yeddi m眉蓹yy蓹n 381 00:19:20,510 --> 00:19:25,050 biz bir super olan bir fayl verm蓹k ki莽ik bir veril蓹nl蓹r bazas谋 masa, h蓹qiq蓹t蓹n borc 382 00:19:25,050 --> 00:19:27,070 hacker n蓹艧r problemi iki set 383 00:19:27,070 --> 00:19:29,480 olan daxili alt谋 sat谋r var. 384 00:19:29,480 --> 00:19:32,720 B眉t眉n Belinda 眉莽眉n One yol a艧a臒谋 Zamyla 眉莽眉n bir, 385 00:19:32,720 --> 00:19:35,980 v蓹 o sol bildiri艧 istifad蓹莽i ad谋, bir kimi unikal kimlikleri var 386 00:19:35,980 --> 00:19:39,410 iki, 眉莽, d枚rd, be艧, alt谋, integers, v蓹 sonra sa臒 hashes var. 387 00:19:39,410 --> 00:19:42,780 >> V蓹 odds, 蓹g蓹r, siz etm蓹di hacker n蓹艧r problem, iki set 388 00:19:42,780 --> 00:19:46,560 lakin hash 艧ifreli kimi yaln谋z bir ne莽蓹 caveats il蓹 parol. 389 00:19:46,560 --> 00:19:49,470 Bel蓹 ki, siz burada n蓹 g枚rm蓹k b眉t眉n alt谋 艧ifreli versiyas谋 390 00:19:49,470 --> 00:19:52,950 problem bizim parol iki nin hacker n蓹艧r se莽in. 391 00:19:52,950 --> 00:19:56,500 陌ndi sol yaln谋z bir GUI stuff deyil, Bu s谋ra redakt蓹 bu s谋raya 莽谋xarmaq, 392 00:19:56,500 --> 00:19:57,630 Bu s谋ra silm蓹. 393 00:19:57,630 --> 00:19:59,840 >> Amma n蓹 maraql谋 陌ndi bel蓹dir. 394 00:19:59,840 --> 00:20:03,810 M蓹n, h蓹qiq蓹t蓹n, ba艧laya bil蓹rsiniz Bu c蓹dv蓹l蓹 il蓹 eksperiment. 395 00:20:03,810 --> 00:20:07,330 M蓹n getm蓹k v蓹 SQL bas谋n 蓹g蓹r ni艧an谋, m蓹n bu b枚y眉k m蓹tn qutusuna almaq. 396 00:20:07,330 --> 00:20:10,190 Bu biz olacaq nec蓹 deyil h蓹qiq蓹t蓹n kodu yaz谋l谋 zaman bunu. 397 00:20:10,190 --> 00:20:12,700 Ayd谋n olmaq 眉莽眉n, phpMyAdmin ki, bir vasit蓹dir 398 00:20:12,700 --> 00:20:16,450 Biz蓹 bazas谋 蓹traf谋nda soxmaq imkan gedir v蓹 biz蓹 sor臒u il蓹 s谋na臒a imkan verir. 399 00:20:16,450 --> 00:20:19,430 >> Bel蓹 ki, m蓹s蓹l蓹n, g眉man M蓹n m蓹hz bu icra. 400 00:20:19,430 --> 00:20:22,820 O biri olan se莽in, a莽ar s枚zl蓹r, m蓹n 蓹vv蓹ll蓹r, ulduz qeyd 401 00:20:22,820 --> 00:20:25,900 b眉t眉n t蓹msil bir masa s眉tunlar谋. 402 00:20:25,900 --> 00:20:26,820 N蓹 masa From? 403 00:20:26,820 --> 00:20:27,990 Yax艧谋, users. 404 00:20:27,990 --> 00:20:29,950 V蓹 bildiri艧 bu var SQL q蓹rib蓹 konqres 405 00:20:29,950 --> 00:20:32,140 burada h蓹qiq蓹t蓹n istifad蓹 geri, ad蓹t蓹n, ticks 406 00:20:32,140 --> 00:20:35,940 t蓹k quotes v蓹 ikiqat quotes Siz masalar adlar谋 haqq谋nda dan谋艧maq zaman, 407 00:20:35,940 --> 00:20:38,990 bel蓹 ki, geri quote haqq谋nda 艧ey klaviatura 眉st sol 蓹n 408 00:20:38,990 --> 00:20:39,720 ehtimal. 409 00:20:39,720 --> 00:20:41,850 >> Bel蓹 ki, m蓹n蓹 indi davam ed蓹k v蓹 yaln谋z t蓹k t蓹rk 410 00:20:41,850 --> 00:20:46,020 v蓹 ya a艧a臒谋 diyirl蓹yin v蓹 bas谋n Go, v蓹 biz 蓹slind蓹 eyni 艧ey g枚rm蓹k olacaq. 411 00:20:46,020 --> 00:20:52,410 Biz yaln谋z bir SQL sor臒u icra se莽in h蓹r 艧ey ulduz dey蓹r蓹k 412 00:20:52,410 --> 00:20:55,610 olan masa istifad蓹莽il蓹r adlan谋r v蓹 n蓹 geri almaq bu. 413 00:20:55,610 --> 00:20:58,400 N蓹tic蓹d蓹, biz ed蓹 bil蓹rsiniz kod ki, eyni 艧ey, 414 00:20:58,400 --> 00:21:02,109 lakin indi b眉t眉n I ist蓹di m蓹nim brauzerinizin g枚rm蓹k idi yoxdur. 415 00:21:02,109 --> 00:21:03,900 Yax艧谋 bir 艧ey ed蓹k bir az f蓹rqli. 416 00:21:03,900 --> 00:21:08,330 , M蓹n蓹 SQL ni艧an谋 geri ged蓹k v蓹 yaln谋z n蓹 dey蓹k? 417 00:21:08,330 --> 00:21:11,520 Zamyla onun b眉t眉n itirdi pul, v蓹 buna g枚r蓹 d蓹 bu 418 00:21:11,520 --> 00:21:13,190 bizim 眉莽眉n vaxt bir istifad蓹莽i kimi silm蓹k 眉莽眉n. 419 00:21:13,190 --> 00:21:14,630 O, art谋q giri艧 var. 420 00:21:14,630 --> 00:21:18,870 >> M蓹n from-- silm蓹k dem蓹k gedir蓹m yax艧谋, kapitalla艧ma saxlamaq 421 00:21:18,870 --> 00:21:23,080 ard谋c谋ll谋q 眉莽眉n, silin harada istifad蓹莽il蓹r. 422 00:21:23,080 --> 00:21:25,430 V蓹 bel蓹 ki, biz bu ola bil蓹r predicates, v蓹 ya bu 423 00:21:25,430 --> 00:21:31,180 M蓹nim 艧蓹rhd蓹 sonunda se莽m蓹l蓹ri, harada v蓹 nec蓹 Zamyla silm蓹k bil蓹r? 424 00:21:31,180 --> 00:21:34,190 Onun ad谋 Zamyla t蓹r蓹find蓹n, bel蓹 s眉tun, s眉tun biri 425 00:21:34,190 --> 00:21:37,950 adl谋, bel蓹 ki, burada name = "Zamyla" idi. 426 00:21:37,950 --> 00:21:40,000 V蓹 burada m蓹n ikiqat istifad蓹 quotes v蓹 ya bir quotes, 427 00:21:40,000 --> 00:21:42,958 yaln谋z zaman geri g蓹n蓹 istifad蓹 M蓹s蓹l蓹n, adlar谋 haqq谋nda s枚hb蓹t, 428 00:21:42,958 --> 00:21:45,130 masalar v蓹 ya sah蓹l蓹rind蓹. 429 00:21:45,130 --> 00:21:47,440 V蓹 m蓹n蓹 burada getm蓹k bas谋n bildirin. 430 00:21:47,440 --> 00:21:50,400 V蓹 indi, web s蓹hif蓹 bir az sinirli olan. 431 00:21:50,400 --> 00:21:53,620 >> V蓹 ya, h蓹qiq蓹t蓹n, silm蓹k icra etm蓹k ist蓹yir蓹m name Zamyla b蓹rab蓹rdir istifad蓹莽il蓹r? 432 00:21:53,620 --> 00:21:54,680 B蓹li. 433 00:21:54,680 --> 00:22:01,900 Bel蓹 ki, indi m蓹nim masa geri getm蓹k 蓹g蓹r t谋klayarak istifad蓹莽il蓹r t蓹r蓹find蓹n, HM ki, g枚r眉rs眉n眉z. 434 00:22:01,900 --> 00:22:02,530 M蓹n goofed. 435 00:22:02,530 --> 00:22:04,070 V蓹 蓹slind蓹, m蓹n n枚v bel蓹 s眉r蓹tli 眉z t谋klayan 436 00:22:04,070 --> 00:22:06,195 Siz h蓹tta g枚rm蓹dim b蓹lk蓹 q谋rm谋z谋 s蓹hv mesaj谋. 437 00:22:06,195 --> 00:22:07,649 M蓹n yanl谋艧 n蓹 idi? 438 00:22:07,649 --> 00:22:09,690 Auditoriya: Siz laz谋m deyil onun ad谋 kapitalla艧d谋rmaq. 439 00:22:09,690 --> 00:22:11,260 DAVID J. MALAN: B蓹li m蓹n , onun ad谋 kapitalla艧d谋r谋lm谋艧 440 00:22:11,260 --> 00:22:13,770 lakin onun M蓹n, h蓹qiq蓹t蓹n, username-- sa臒, bir ne莽蓹 s蓹hvl蓹r etdi? 441 00:22:13,770 --> 00:22:16,720 One, onun istifad蓹莽i ad谋 ZAMYLA, ki莽ik Z, 442 00:22:16,720 --> 00:22:20,140 v蓹 s眉tun ad谋 ad谋n谋z, deyil ad谋, bel蓹 ki, yen蓹 bunu bildirin. 443 00:22:20,140 --> 00:22:25,750 M蓹n蓹 davam ed蓹k v蓹 istifad蓹莽il蓹r yerd蓹n silm蓹k 444 00:22:25,750 --> 00:22:28,990 istifad蓹莽i ad谋 quote d谋rna臒谋 ba臒lamaq "Zamyla" b蓹rab蓹rdir. 445 00:22:28,990 --> 00:22:29,490 B眉t眉n h眉quqlar? 446 00:22:29,490 --> 00:22:32,600 Bel蓹 ki, bu bir az daha yax艧谋 g枚r眉n眉r, qoy M蓹n蓹 a艧a臒谋 diyirl蓹yin getm蓹k v蓹 Go bas谋n. 447 00:22:32,600 --> 00:22:34,730 Bu h蓹l蓹 olacaq 蓹min olmaq 眉莽眉n m蓹n蓹 f蓹臒an. 448 00:22:34,730 --> 00:22:37,500 M蓹n B蓹li bas谋n v蓹 indi biz g枚r眉r眉k s蓹mimi bu, h蓹qiq蓹t蓹n, ba艧 449 00:22:37,500 --> 00:22:39,870 s眉r蓹tli, az bir 陌kinci 蓹lb蓹tt蓹 ki, bu 450 00:22:39,870 --> 00:22:41,720 tam icra oldu ki, sor臒u edir. 451 00:22:41,720 --> 00:22:45,617 T蓹sdiq etm蓹k 眉莽眉n, m蓹n蓹 istifad蓹莽il蓹r bas谋n izl蓹 v蓹 h蓹qiq蓹t蓹n indi Zamyla getdi. 452 00:22:45,617 --> 00:22:46,700 陌ndi qar艧谋 n蓹 ed蓹k. 453 00:22:46,700 --> 00:22:49,320 Gabe ist蓹yir ki, d眉艧眉n蓹k haqqinda 眉莽眉n qeydiyyatdan ke莽in. 454 00:22:49,320 --> 00:22:52,825 SQL sor臒u n蓹, n蓹 var M蓹n Gabe 蓹lav蓹 etm蓹k yaz谋n bil蓹r command? 455 00:22:52,825 --> 00:22:54,200 Yax艧谋 olduqca sad蓹 var. 456 00:22:54,200 --> 00:22:58,260 Istifad蓹莽il蓹r daxil, v蓹 indi bir az sirli olur. 457 00:22:58,260 --> 00:23:03,190 M蓹n server, m眉蓹yy蓹n etm蓹k laz谋md谋r n蓹 m蓹n t蓹yin etm蓹k ist蓹yir蓹m sah蓹l蓹ri. 458 00:23:03,190 --> 00:23:06,630 M蓹n, h蓹qiq蓹t蓹n, qay臒谋 yoxdur n蓹 Gabe ID say谋, bel蓹 ki, ke莽m蓹k gedir蓹m. 459 00:23:06,630 --> 00:23:11,360 M蓹n 蓹v蓹zin蓹 dem蓹k gedir蓹m istifad蓹莽i ad谋, hash, v蓹 sonra 460 00:23:11,360 --> 00:23:14,960 d蓹y蓹rl蓹ri I qoymaq ist蓹yir蓹m Gabe var gedir. 461 00:23:14,960 --> 00:23:16,800 V蓹 sonra onun hash, m蓹n bilmir蓹m. 462 00:23:16,800 --> 00:23:19,900 Bel蓹likl蓹, m蓹n gedir蓹m etm蓹k 眉莽眉n bir b枚y眉k kimi t蓹rk. 463 00:23:19,900 --> 00:23:21,650 Biz geri g蓹lm蓹k laz谋md谋r Problem set ki, 464 00:23:21,650 --> 00:23:23,390 Siz, h蓹qiq蓹t蓹n, bunu nec蓹 spec. 465 00:23:23,390 --> 00:23:24,630 >> Bel蓹 ki, yen蓹 sintaksis, g枚r眉rs眉n眉z. 466 00:23:24,630 --> 00:23:28,430 Masa ad谋 daxil, sonra daxil edin sah蓹l蓹rind蓹 parenthesized siyah谋s谋 467 00:23:28,430 --> 00:23:30,980 s眉tun 蓹lav蓹 etm蓹k ist蓹diyiniz d蓹y蓹rl蓹ri, v蓹 sonra yaln谋z 468 00:23:30,980 --> 00:23:34,495 eyni d蓹qiq sifari艧 眉莽眉n sol 茝lav蓹 etm蓹k ist蓹diyiniz d蓹y蓹rl蓹rin sa臒, 469 00:23:34,495 --> 00:23:36,870 v蓹 yaln谋z 莽眉nki wrapping edir M蓹tn bir az uzun. 470 00:23:36,870 --> 00:23:38,520 Bel蓹 ki, indi m蓹n蓹 Go bas谋n bildirin. 471 00:23:38,520 --> 00:23:39,830 Bir s谋ra daxil. 472 00:23:39,830 --> 00:23:43,020 V蓹 indi geri getm蓹k 蓹g蓹r istifad蓹莽il蓹r n蓹 maraql谋 473 00:23:43,020 --> 00:23:48,960 yaln谋z Gabe d蓹 art谋q deyil ki, veril蓹nl蓹r bazas谋, onun ID y蓹qin n蓹dir? 474 00:23:48,960 --> 00:23:49,820 >> Yax艧谋 yeddi var. 475 00:23:49,820 --> 00:23:51,479 Niy蓹 m蓹n bunu 蓹lav蓹 etm蓹yib yeddi zaman? 476 00:23:51,479 --> 00:23:54,020 Bu bel蓹 d蓹 biridir x眉susiyy蓹tl蓹ri bazas谋 almaq. 477 00:23:54,020 --> 00:23:55,750 Bir 莽ox funksionall谋臒谋 in艧a. 478 00:23:55,750 --> 00:23:57,950 Bu zaman 莽谋x谋r ki, Bu masa yarad谋b, 479 00:23:57,950 --> 00:24:01,390 M蓹n avtomatik olaraq var 枚nceden bel蓹 bir 艧蓹kild蓹 ID t蓹yin 480 00:24:01,390 --> 00:24:02,480 Bu 蓹lav蓹l蓹r. 481 00:24:02,480 --> 00:24:05,470 Bel蓹likl蓹, siz he莽 蓹traf谋nda poked olsan谋z v蓹 n蓹 Facebook ID baxd谋 482 00:24:05,470 --> 00:24:09,292 say谋, h蓹qiq蓹t蓹n deyil bu g眉n bir 艧ey, bir API, lakin Facebook etm蓹k 483 00:24:09,292 --> 00:24:11,750 Application Programming Interface, qovu艧durma臒谋m谋z geri ala bil蓹rsiniz 484 00:24:11,750 --> 00:24:14,430 m蓹lumatlar谋n b眉t眉n d蓹st蓹 haqq谋nda 脰z眉n眉z, dostlar谋n谋z haqq谋nda, 485 00:24:14,430 --> 00:24:15,347 v蓹 蓹laq蓹l蓹ri. 486 00:24:15,347 --> 00:24:17,430 V蓹 n蓹 istifad蓹 c眉r s蓹rin, geri g眉n, 487 00:24:17,430 --> 00:24:19,510 axtarmaq 眉莽眉n n蓹 sizin Facebook ID say谋. 488 00:24:19,510 --> 00:24:22,390 Mark Zuckerberg-in, M蓹s蓹l蓹n, 眉莽 489 00:24:22,390 --> 00:24:23,890 O sayt谋n m眉蓹llifi idi. 490 00:24:23,890 --> 00:24:27,610 Hekay蓹 gedir kimi, onun yaratd谋臒谋 iki test hesablar谋, istifad蓹莽il蓹r bir v蓹 iki, 491 00:24:27,610 --> 00:24:28,690 o sonra silindi. 492 00:24:28,690 --> 00:24:32,780 V蓹 bel蓹 ki, Zuck, onun istifad蓹莽i ad谋 Facebook, ID say谋 眉莽d眉r 493 00:24:32,780 --> 00:24:36,110 v蓹 ham谋m谋z 莽ox n枚mr蓹l蓹ri var daha b枚y眉k 眉莽 bu g眉n. 494 00:24:36,110 --> 00:24:37,980 茝slind蓹, bir n枚qt蓹d蓹 Facebook 眉z k枚莽眉r眉l眉b 495 00:24:37,980 --> 00:24:42,410 h蓹tta bir int istifad蓹 hans谋 32-bit d蓹y蓹r istifad蓹 edir 496 00:24:42,410 --> 00:24:44,480 N枚vb蓹ti add谋m, mahiyy蓹tc蓹 uzun uzun bel蓹 497 00:24:44,480 --> 00:24:47,150 Onlar yerl蓹艧dirm蓹k bil蓹r ki, Qeydiyyatdan daha users. 498 00:24:47,150 --> 00:24:49,420 Bel蓹 ki, bir fun az tarixi fakt. 499 00:24:49,420 --> 00:24:51,660 >> Bel蓹 ki, yaln谋z 蓹sas sintaksis olan 500 00:24:51,660 --> 00:24:54,470 biz bir ne莽蓹 icra bil蓹r queries, lakin biz h蓹qiq蓹t蓹n bil蓹rsiniz 501 00:24:54,470 --> 00:24:56,744 SQL il蓹 bir d蓹st蓹 daha 莽ox 艧ey蓹. 502 00:24:56,744 --> 00:24:58,910 V蓹 n蓹hay蓹t, g枚r蓹c蓹ksiniz problemi yeddi m眉蓹yy蓹n 503 00:24:58,910 --> 00:25:01,034 Bir etm蓹k laz谋md谋r ki, dizayn q蓹rarlar谋 say谋, 504 00:25:01,034 --> 00:25:03,290 Onlar谋n aras谋nda olacaq n蓹 m蓹lumat n枚vl蓹ri istifad蓹 etm蓹k. 505 00:25:03,290 --> 00:25:08,240 Bel蓹 ki, yaln谋z C kimi, data var bir veril蓹nl蓹r bazas谋 n枚vl蓹ri, MySQL kimi, 506 00:25:08,240 --> 00:25:12,640 v蓹 m蓹lumat n枚vl蓹ri se莽m蓹k laz谋md谋r burada bu sah蓹l蓹ri daxildir. 507 00:25:12,640 --> 00:25:17,287 Char, VARCHAR, Int, big int, decimal v蓹 tarixi zaman, v蓹 bir 莽ox ba艧qalar谋. 508 00:25:17,287 --> 00:25:18,370 Bel蓹 nin 蓹slind蓹 bunu ed蓹k. 509 00:25:18,370 --> 00:25:21,060 Biz deyil ki, iddia ed蓹k 蓹l bu istifad蓹莽i masa 510 00:25:21,060 --> 00:25:25,080 v蓹 m蓹nim 眉莽眉n, ir蓹li getm蓹k v蓹 yaratmaq imkan 枚z眉m m眉hazir蓹l蓹r bazas谋nda 511 00:25:25,080 --> 00:25:31,000 h蓹qiq蓹t蓹n m蓹n蓹 ir蓹li getm蓹k v蓹 silm蓹k imkan M蓹n art谋q burada var masa 512 00:25:31,000 --> 00:25:32,940 bel蓹 ki, biz, h蓹qiq蓹t蓹n, bu yarada bil蓹rsiniz. 513 00:25:32,940 --> 00:25:33,550 Whoops. 514 00:25:33,550 --> 00:25:35,970 M蓹n bu d眉艧m蓹k gedir蓹m masa, v蓹 indi m蓹n 515 00:25:35,970 --> 00:25:38,337 Bu yenid蓹n getm蓹k olacaq burada bazas谋 m眉hazir蓹, 516 00:25:38,337 --> 00:25:40,420 M蓹n bir masa yaratmaq 眉莽眉n gedir蓹m adl谋 istifad蓹莽il蓹ri v蓹 ed蓹k 517 00:25:40,420 --> 00:25:43,010 Yaln谋z 眉莽 s眉tun etm蓹k ilkin v蓹 Go bas谋n. 518 00:25:43,010 --> 00:25:44,990 >> 陌ndi, 莽ox hiss蓹si 眉莽眉n, yenid蓹n, bu yaln谋z 519 00:25:44,990 --> 00:25:48,570 adlanan bu qrafik arac谋 istifad蓹 ed蓹r蓹k phpMyAdmin v蓹 biz indi n蓹 edirik 520 00:25:48,570 --> 00:25:49,600 bir masa yarad谋r. 521 00:25:49,600 --> 00:25:53,170 Bel蓹 ki, bu Fayl ged蓹n kimi, New, v蓹 yeni Excel fayl yaratmaq. 522 00:25:53,170 --> 00:25:55,440 Bel蓹 ki, m蓹n蓹 bir ne莽蓹 xahi艧 suallar, olan, sol sa臒 523 00:25:55,440 --> 00:25:58,620 ilk s眉tun ad谋 n蓹 var, v蓹 sonra ikinci s眉tun ad谋, 524 00:25:58,620 --> 00:25:59,560 v蓹 眉莽眉nc眉 ad谋. 525 00:25:59,560 --> 00:26:00,518 Bel蓹 ki, bu yeniden bildirin. 526 00:26:00,518 --> 00:26:05,460 ID, sonra istifad蓹莽i ad谋, biri idi v蓹 sonra hash ba艧qa idi. 527 00:26:05,460 --> 00:26:08,970 Bel蓹 ki, n蓹 data n枚v眉 olmal谋d谋r ID kimi bir sah蓹d蓹 art谋q ola bil蓹rmi? 528 00:26:08,970 --> 00:26:14,470 >> Burada data n枚vl蓹ri b眉t眉n siyah谋s谋 Bir veril蓹nl蓹r bazas谋 sizin 眉莽眉n, 529 00:26:14,470 --> 00:26:16,070 v蓹 indi yaln谋z int il蓹 ged蓹k. 530 00:26:16,070 --> 00:26:18,160 32-bit d蓹y蓹ri, m蓹n deyil M蓹n real d眉艧眉nm蓹k 531 00:26:18,160 --> 00:26:21,484 daha 4 milyard gedir M蓹nim hesab谋na istifad蓹莽il蓹r, m蓹nim xidm蓹t, 532 00:26:21,484 --> 00:26:23,650 M蓹n h蓹r蓹k蓹t saxlamaq 眉莽眉n gedir蓹m n枚vb蓹ti sual 眉莽眉n. 533 00:26:23,650 --> 00:26:25,490 M蓹n m眉蓹yy蓹n etm蓹k fikrind蓹 deyil蓹m bir uzunlu臒u v蓹 ya d蓹y蓹rl蓹r, 534 00:26:25,490 --> 00:26:28,540 Bu t蓹tbiq deyil burada int, 枚zl眉y眉nd蓹. 535 00:26:28,540 --> 00:26:30,740 V蓹 indi, belirtebilirsiniz y蓹qin, bir-u m蓹nim 536 00:26:30,740 --> 00:26:33,970 M蓹n m眉蓹yy蓹n etm蓹k fikrind蓹 deyil蓹m olan d蓹y蓹r. 537 00:26:33,970 --> 00:26:36,050 A 眉zl蓹艧dirilm蓹si, m蓹n n蓹 bilmir蓹m. 538 00:26:36,050 --> 00:26:37,290 Bir atributu. 539 00:26:37,290 --> 00:26:39,455 陌ndi biz, h蓹qiq蓹t蓹n, bir dizayn q蓹rar var. 540 00:26:39,455 --> 00:26:42,580 Bel蓹 ki, b眉t眉n burada bir ne莽蓹 sah蓹l蓹ri var olan t蓹tbiq, lakin imzas谋z var 541 00:26:42,580 --> 00:26:43,380 yaln谋z n蓹 dem蓹kdir? 542 00:26:43,380 --> 00:26:45,400 Bu int olmal谋d谋r? 543 00:26:45,400 --> 00:26:46,210 Yaln谋z qeyri-m蓹nfi. 544 00:26:46,210 --> 00:26:48,090 Bel蓹 ki, up 0 olmal谋d谋r. 545 00:26:48,090 --> 00:26:51,120 Xeyr, 莽眉nki yoxlamaq fikrind蓹 deyil蓹m M蓹n h蓹r bir istifad蓹莽i ID etm蓹k ist蓹yirsinizs蓹, 546 00:26:51,120 --> 00:26:52,470 Bu null ola bilm蓹z. 547 00:26:52,470 --> 00:26:55,949 V蓹 sonra, biz bir daha almaq bu kimi maraql谋 dizayn q蓹rarlar谋. 548 00:26:55,949 --> 00:26:58,990 Biz, bir anda bu qay谋da bil蓹rsiniz veril蓹nl蓹r bazas谋, lakin n蓹 bir x眉susiyy蓹t 549 00:26:58,990 --> 00:27:04,200 , siz dey蓹 bil蓹rsiniz ki, veril蓹nl蓹r bazas谋 server davam 550 00:27:04,200 --> 00:27:07,100 v蓹 枚z眉n眉z眉 optimize, sizin RAM v蓹 sabit disk space, 551 00:27:07,100 --> 00:27:11,770 ki se莽ir, v蓹 ed蓹r v蓹 bel蓹 silir v蓹 yenilikl蓹ri h蓹qiq蓹t蓹n s眉r蓹tli. 552 00:27:11,770 --> 00:27:13,250 Pset5 bu f蓹rqli. 553 00:27:13,250 --> 00:27:16,259 >> 茝g蓹r bir 艧ey axtarmaq ist蓹yirdi 蓹g蓹r Sizin hash masa, olan 554 00:27:16,259 --> 00:27:18,300 Bir bazas谋 kimi hesab b眉t眉n etm蓹k olan 555 00:27:18,300 --> 00:27:21,500 Sizin hash table s眉r蓹tli edilm蓹si 眉莽眉n 莽al谋艧谋r谋q. 556 00:27:21,500 --> 00:27:22,840 Bu, a莽谋q-ayd谋n, kimi var. 557 00:27:22,840 --> 00:27:23,060 Right? 558 00:27:23,060 --> 00:27:26,080 Siz b眉t眉n vaxt c蓹rim蓹 qoymaq idi bir hash funksiyas谋 蓹ld蓹 艧eyi tuning 559 00:27:26,080 --> 00:27:27,820 sa臒, h蓹yata nec蓹 figuring 莽ox buketler var. 560 00:27:27,820 --> 00:27:29,611 >> Amma, yen蓹 d蓹, g枚z蓹l n蓹 var haqq谋nda m蓹lumat bazas谋d谋r 561 00:27:29,611 --> 00:27:31,762 Yaln谋z b眉t眉n ayaqla z蓹rb蓹 dig蓹r insanlar谋n bu 562 00:27:31,762 --> 00:27:33,720 bu fikir n蓹 眉莽眉n vasit蓹sil蓹 v蓹 563 00:27:33,720 --> 00:27:37,170 M蓹n bura dem蓹k gedir蓹m index m蓹nim ID sah蓹d蓹 ki 564 00:27:37,170 --> 00:27:41,149 蓹sas yol olacaq Bu bazas谋nda istifad蓹莽il蓹r m眉蓹yy蓹n. 565 00:27:41,149 --> 00:27:42,940 M蓹n hesab edir蓹m fikrind蓹 deyil蓹m Zamyla kimi Zamyla ki, 566 00:27:42,940 --> 00:27:45,800 M蓹n hesab edir蓹m gedir蓹m onun say谋 6. 567 00:27:45,800 --> 00:27:49,814 >> Niy蓹, b蓹lk蓹 d蓹, daha yax艧谋 edir daxil蓹n v蓹 model hesab 568 00:27:49,814 --> 00:27:52,480 istifad蓹 ed蓹r蓹k, f蓹rdi sat谋r 蓹v蓹zin蓹 bir 艧ey bir s谋ra 569 00:27:52,480 --> 00:27:56,480 Bu Zamyla kimi bir string kimi Gabe v蓹 ya h蓹l蓹 uzun string v蓹 ya? 570 00:27:56,480 --> 00:27:57,444 B蓹li? 571 00:27:57,444 --> 00:28:00,117 >> Auditoriya: bir ID nadir? 572 00:28:00,117 --> 00:28:01,200 DAVID J. MALAN: yen蓹 De? 573 00:28:01,200 --> 00:28:02,283 Auditoriya: bir ID nadir? 574 00:28:02,283 --> 00:28:04,400 DAVID J. MALAN: An ID unikal, lakin suppose-- 575 00:28:04,400 --> 00:28:06,320 脺mumi halda istifad蓹莽i ad谋 il蓹, g眉man 576 00:28:06,320 --> 00:28:10,110 M蓹n d蓹 yaln谋z ola bil蓹r bir D眉nyada Zamyla, v蓹 yaln谋z bir Gabe. 577 00:28:10,110 --> 00:28:13,730 M蓹n unikall谋臒谋 t蓹tbiq ed蓹 bil蓹r M蓹n ist蓹yirdim, 莽ox strings s谋x谋nt谋. 578 00:28:13,730 --> 00:28:15,550 Bel蓹 ki, bir pis fikir. 579 00:28:15,550 --> 00:28:16,500 >> Auditoriya: Daha t蓹hl眉k蓹siz. 580 00:28:16,500 --> 00:28:17,874 >> DAVID J. MALAN: Daha t蓹hl眉k蓹siz, niy蓹? 581 00:28:17,874 --> 00:28:20,705 Auditoriya: Siz dey蓹 bilm蓹z istifad蓹莽i kimi olan. 582 00:28:20,705 --> 00:28:22,580 DAVID J. MALAN: OK, siz istifad蓹莽i dey蓹 bilm蓹z 583 00:28:22,580 --> 00:28:24,380 bel蓹 bir var olan bu gizlilik aspekt, 584 00:28:24,380 --> 00:28:27,810 x眉susil蓹 d蓹 蓹g蓹r kimlikleri b蓹lk蓹 URL g枚r眉nen. 585 00:28:27,810 --> 00:28:29,960 Bel蓹 ki, 蓹min ki, i艧 c眉r ola bil蓹r 莽ox. 586 00:28:29,960 --> 00:28:30,640 Dig蓹r fikir? 587 00:28:30,640 --> 00:28:31,383 B蓹li? 588 00:28:31,383 --> 00:28:34,316 >> Auditoriya: Bu asan bir int 蓹m蓹liyyatlar谋 yerin蓹 yetirm蓹k. 589 00:28:34,316 --> 00:28:35,940 DAVID J. MALAN: Bu real soncuqlayan var. 590 00:28:35,940 --> 00:28:38,850 Bu, yaln谋z daha s蓹m蓹r蓹li v蓹 ya komp眉ter 眉莽眉n asan, 591 00:28:38,850 --> 00:28:40,431 tam 蓹m蓹liyyatlar谋 yerin蓹 yetirm蓹k 眉莽眉n. 592 00:28:40,431 --> 00:28:40,930 Right? 593 00:28:40,930 --> 00:28:43,905 Bir int t蓹min olunur 32-bit ola Zamyla is蓹 594 00:28:43,905 --> 00:28:47,660 , Gabriel bir ne莽蓹 simvol uzun , bir ne莽蓹 simvol uzun 595 00:28:47,660 --> 00:28:51,930 Davenport h蓹qiq蓹t蓹n uzun, v蓹 bel蓹 ki, istifad蓹 etm蓹k, x眉susil蓹 s蓹m蓹r蓹li deyil 596 00:28:51,930 --> 00:28:55,860 strings d蓹y蓹rl蓹ri m眉qayis蓹 v蓹 baxmaq sah蓹l蓹ri, v蓹 yenil蓹m蓹 sah蓹l蓹ri 眉莽眉n, 597 00:28:55,860 --> 00:28:57,790 茝g蓹r 眉z 蓹ld蓹 ed蓹 bil蓹rsiniz yaln谋z bir tam olan. 598 00:28:57,790 --> 00:28:59,090 Just 32 bit. 599 00:28:59,090 --> 00:29:02,570 Istifad蓹莽i Bel蓹 ki, 莽ox, bu yolla, unikal yoxdur, 600 00:29:02,570 --> 00:29:05,040 Onlar y蓹qin ki, olmal谋d谋r, baxmayaraq ki, v蓹 h蓹tta bu 艧蓹kild蓹 莽ox 601 00:29:05,040 --> 00:29:07,520 istifad蓹莽i icaz蓹 bil蓹r onun ad谋 d蓹yi艧ir. 602 00:29:07,520 --> 00:29:10,810 >> Bel蓹 ki, indi kimi bu t蓹rk ed蓹k istifad蓹莽i m眉蓹yy蓹n 蓹sas vasit蓹dir. 603 00:29:10,810 --> 00:29:13,510 Bu veril蓹nl蓹r bazas谋 dan谋艧anlardan ir蓹li getm蓹k v蓹 枚z眉n眉z眉 optimize 604 00:29:13,510 --> 00:29:17,065 bel蓹 ID ki look up super s眉r蓹tli. 605 00:29:17,065 --> 00:29:19,620 AI, horribly yaln谋z ad谋na Auto art谋m dem蓹kdir, 606 00:29:19,620 --> 00:29:21,500 v蓹 bu 莽ek edir biz yoxlamaq laz谋md谋r qutusu 607 00:29:21,500 --> 00:29:24,614 眉莽眉n ID sah蓹sind蓹 ki, m眉蓹yy蓹n etm蓹k avtomatik m蓹nim 眉莽眉n sat谋c谋 t蓹r蓹find蓹n ayd谋nl谋q olmal谋d谋r, 608 00:29:24,614 --> 00:29:26,530 v蓹 sonra m蓹n gedir蓹m burada sa臒a diyirl蓹yin 609 00:29:26,530 --> 00:29:29,279 v蓹 s蓹mimi M蓹n, h蓹qiq蓹t蓹n maraql谋 deyil蓹m Bu sah蓹l蓹rd蓹 h蓹r hans谋 bir daha. 610 00:29:29,279 --> 00:29:30,630 茝lb蓹tt蓹 bu g眉n. 611 00:29:30,630 --> 00:29:33,770 >> M蓹n burada geri getm蓹k 眉莽眉n gedir蓹m, ilk s眉tun, harada 612 00:29:33,770 --> 00:29:35,830 M蓹n istifad蓹莽i ad谋 daxil laz谋md谋r v蓹 hash, v蓹 ed蓹k 613 00:29:35,830 --> 00:29:38,080 眉zr蓹 蓹n m蓹rk蓹zind蓹 陌ndi ikinci. 614 00:29:38,080 --> 00:29:41,498 Int y蓹qin ki, do臒ru z蓹ng deyil, bel蓹 ki, n蓹, b蓹lk蓹 daha 莽ox 蓹h蓹miyy蓹t k蓹sb edir? 615 00:29:41,498 --> 00:29:42,741 >> Auditoriya: Text. 616 00:29:42,741 --> 00:29:43,824 DAVID J. MALAN: yen蓹 De? 617 00:29:43,824 --> 00:29:44,710 Auditoriya: Text. 618 00:29:44,710 --> 00:29:44,980 DAVID J. MALAN: Text? 619 00:29:44,980 --> 00:29:45,590 OK, M蓹n m蓹tn e艧itdim. 620 00:29:45,590 --> 00:29:46,090 N蓹? 621 00:29:46,090 --> 00:29:50,520 622 00:29:50,520 --> 00:29:53,860 Biz n枚v se莽im bir d蓹st蓹 var t蓹bi蓹t m蓹tn var. 623 00:29:53,860 --> 00:29:55,990 Bel蓹 ki, v蓹 n蓹, n蓹 Bu b蓹zi istifad蓹? 624 00:29:55,990 --> 00:29:59,560 Char Yax艧谋, 蓹ksin蓹 n蓹 bil蓹r hesab edir蓹m ki, bir xarakter deyil. 625 00:29:59,560 --> 00:30:01,550 Bu simvol bir x眉susi say谋 var. 626 00:30:01,550 --> 00:30:04,600 Biz bilirik ki, b眉t眉n istifad蓹莽i ad谋 ki s蓹kkiz simvol kimi olmal谋d谋r, 627 00:30:04,600 --> 00:30:08,490 older 眉mumi olmaq 眉莽眉n istifad蓹 kimi komp眉ter sisteml蓹ri, m蓹n char dem蓹k bil蓹r 628 00:30:08,490 --> 00:30:09,830 v蓹 sonra m蓹n burada 8 dey蓹 bil蓹r. 629 00:30:09,830 --> 00:30:12,930 脺莽眉nc眉 s眉tun olur zaman var t蓹tbiq bir masa yaratmaq zaman. 630 00:30:12,930 --> 00:30:15,450 >> Amma ki, annoying c眉r b蓹zi insanlar ola bil蓹r, 莽眉nki 631 00:30:15,450 --> 00:30:17,660 uzun ad谋 var ist蓹yir蓹m s蓹kkiz simvol 莽ox, 632 00:30:17,660 --> 00:30:19,743 b蓹zi insanlar ist蓹yir蓹m bil蓹r q谋sa ad谋 var, 633 00:30:19,743 --> 00:30:22,210 niy蓹 枚z眉m眉 t枚r蓹tm蓹k m眉蓹yy蓹n bir s谋ra? 634 00:30:22,210 --> 00:30:24,710 Niy蓹 bir d蓹yi艧蓹n var chars say谋 v蓹 yaln谋z 635 00:30:24,710 --> 00:30:28,580 dem蓹k ki, bir ad谋 maksimum uzunlu臒u , m蓹n 64 simvol kimi, bilmir蓹m. 636 00:30:28,580 --> 00:30:31,780 M蓹n he莽 bir dostlar谋 hesab ed蓹 bilm蓹y蓹n 64 simvol 莽ox adlar谋 art谋q var, 637 00:30:31,780 --> 00:30:34,810 莽ox q谋sa bel蓹 v蓹 siz 蓹lb蓹tt蓹 枚zba艧谋na onu qabar. 638 00:30:34,810 --> 00:30:37,330 >> Bel蓹 ki, VARCHAR d蓹yi艧蓹n deyil chars say谋. 639 00:30:37,330 --> 00:30:41,010 M蓹tn pis instinkt deyil, v蓹 s蓹mimi ki, sort deyir n蓹, 640 00:30:41,010 --> 00:30:45,460 lakin m蓹tn sah蓹sind蓹 ola bil蓹r 蓹n az谋 65,000 bytes kimi. 641 00:30:45,460 --> 00:30:50,790 Ki, bir y蓹qin overkill sah蓹sind蓹 v蓹 蓹slind蓹, yup, 65.535. 642 00:30:50,790 --> 00:30:53,740 Ki, bir y蓹qin overkill ad谋, bel蓹 ki, biz ad蓹t蓹n, qalmaq laz谋md谋r, 643 00:30:53,740 --> 00:30:56,910 M蓹tn varchars il蓹 莽ox sah蓹 v蓹 hash. 644 00:30:56,910 --> 00:30:59,990 Hash, bu 莽谋x谋r, biz n蓹 ed蓹 bil蓹r VARCHAR h蓹m莽inin ya kimi bir 艧ey, 645 00:30:59,990 --> 00:31:03,080 lakin biz bu g眉n diqq蓹t deyil orada kriptoqrafiya v蓹 n枚mr蓹l蓹r 646 00:31:03,080 --> 00:31:05,210 biz, h蓹qiq蓹t蓹n bil蓹r ki, uzunlu臒u 眉莽眉n istifad蓹 etm蓹k ist蓹yirik. 647 00:31:05,210 --> 00:31:07,430 >> Amma m蓹n蓹 sa臒 眉莽眉n a艧a臒谋 diyirl蓹yin bildirin. 648 00:31:07,430 --> 00:31:11,280 Siz yaln谋z bir ola bil蓹r bir masa 眉莽眉n 蓹sas indeksi, 649 00:31:11,280 --> 00:31:16,380 amma bu h蓹r hans谋 m眉raci蓹t etm蓹k ist蓹yir蓹m, 陌ndi, istifad蓹莽i ad谋, siz dey蓹c蓹ksiniz? 650 00:31:16,380 --> 00:31:21,980 N蓹 istifad蓹莽i ad谋 laz谋md谋r anla艧谋lmaz 蓹sas谋nda Bu d枚rd variantlar谋 verir? 651 00:31:21,980 --> 00:31:23,340 M蓹hz onlar谋n adlar谋? 652 00:31:23,340 --> 00:31:24,140 >> Auditoriya: Unique. 653 00:31:24,140 --> 00:31:25,100 >> DAVID J. MALAN: Bel蓹 unikal, sa臒? 654 00:31:25,100 --> 00:31:28,190 Bel蓹 ki, yaln谋z bil蓹r 莽谋x谋r ki, Siz 蓹vv蓹lc蓹d蓹n, bir veril蓹nl蓹r bazas谋 dem蓹k 655 00:31:28,190 --> 00:31:30,380 Bu 蓹sas yoldur sah蓹l蓹ri m眉蓹yy蓹n. 656 00:31:30,380 --> 00:31:32,990 Siz h蓹m莽inin bu dem蓹k olar unikal sah蓹 olacaq. 657 00:31:32,990 --> 00:31:34,700 Bu olmaq niyy蓹tind蓹 deyil M蓹n etibar 艧ey, 658 00:31:34,700 --> 00:31:38,490 amma bazas谋 ist蓹yir蓹m mahiyy蓹tc蓹 ki, 蓹g蓹r v蓹ziyy蓹t bel蓹 var 659 00:31:38,490 --> 00:31:42,340 M蓹n he莽 qeydiyyatdan c蓹hd 蓹g蓹r Eyni ad谋 il蓹 iki users, 660 00:31:42,340 --> 00:31:44,360 Veril蓹nl蓹r bazas谋 d眉z M蓹n蓹 imkan niyy蓹tind蓹 deyil. 661 00:31:44,360 --> 00:31:47,490 M蓹n b蓹zi 蓹lav蓹 kodu ola bil蓹r q蓹d蓹r qar艧谋s谋n谋 PHP, 662 00:31:47,490 --> 00:31:50,640 lakin veril蓹nl蓹r bazas谋, 莽ox, t蓹min ed蓹 bil蓹r he莽 vaxt ba艧 ver蓹c蓹k ki. 663 00:31:50,640 --> 00:31:53,370 >> 陌ndi bir k蓹nara, x眉susil蓹 kimi Siz final layih蓹l蓹r haqq谋nda d眉艧眉nm蓹k, 664 00:31:53,370 --> 00:31:57,030 mind indeksi v蓹 tam saxlamaq m蓹tn 蓹slind蓹 olduqca faydal谋d谋r. 665 00:31:57,030 --> 00:32:01,080 Bir b枚y眉k veril蓹nl蓹r bazas谋, deyil varsa, onlarla, lakin y眉zl蓹rl蓹 v蓹 ya minl蓹rl蓹 666 00:32:01,080 --> 00:32:05,270 sah蓹l蓹rind蓹 v蓹 ya h蓹tta milyonlarla Siz d蓹 蓹vv蓹lc蓹d蓹n m蓹lumat bazas谋 dem蓹k 667 00:32:05,270 --> 00:32:07,980 m蓹n gedir蓹m bir sah蓹dir bir 莽ox axtar谋艧 眉莽眉n. 668 00:32:07,980 --> 00:32:10,520 B蓹lk蓹 onun ad谋, de臒ilseniz b蓹lk蓹 bio var 669 00:32:10,520 --> 00:32:13,750 Facebook kimi veb edilm蓹si istifad蓹莽i icaz蓹 b蓹ndl蓹r蓹 var 670 00:32:13,750 --> 00:32:16,799 茝g蓹r ist蓹yirsinizs蓹 saxlamaq, v蓹 蓹vv蓹lc蓹d蓹n m蓹lumat bazas谋 dem蓹k 671 00:32:16,799 --> 00:32:20,090 M蓹n bu sah蓹d蓹 axtar谋艧 gedir蓹m bir 莽ox, lakin bu, m眉tl蓹q unikal deyil 672 00:32:20,090 --> 00:32:22,800 M蓹n蓹 bir index yaratmaq belirtebilirsiniz. 673 00:32:22,800 --> 00:32:27,990 V蓹 ya, siz d蓹 dem蓹k m蓹n蓹 imkan bil蓹r Komandirliyi kimi ixtiyari axtar谋艧 sort 674 00:32:27,990 --> 00:32:30,420 v蓹 ya Control F, sizin kimi bir Word Processor bil蓹r, 675 00:32:30,420 --> 00:32:34,184 bel蓹 ki, ixtiyari strings baxmaq bil蓹r Bu sah蓹d蓹 v蓹 ya substrings. 676 00:32:34,184 --> 00:32:36,600 Ba艧qa s枚zl蓹, biz 蓹ld蓹 edirik d枚vr bax谋m谋ndan 677 00:32:36,600 --> 00:32:40,720 siz narahat yoxdur nec蓹 s蓹m蓹r蓹li 艧eyi h蓹yata ke莽irm蓹k. 678 00:32:40,720 --> 00:32:44,540 Siz yaln谋z haqq谋nda bilm蓹k laz谋md谋r n蓹 dizayn q蓹rarlar谋 bel蓹 edirik ki etm蓹k 679 00:32:44,540 --> 00:32:48,470 Bu 眉莽眉n do臒ru ara莽lar谋 istifad蓹 x眉susiyy蓹tl蓹ri leverage 眉莽眉n ticar蓹t 680 00:32:48,470 --> 00:32:50,380 dig蓹r insanlar 眉莽眉n tikilib. 681 00:32:50,380 --> 00:32:54,240 Bel蓹 ki recap, 蓹sas yaln谋z olmal谋d谋r bir var, yaln谋z, bir ola bil蓹r 682 00:32:54,240 --> 00:32:59,630 v蓹 bu t枚r蓹tm蓹kd蓹 etdiyiniz 艧ey benzersiz sah蓹l蓹ri m眉蓹yy蓹n etm蓹k 眉莽眉n istifad蓹. 683 00:32:59,630 --> 00:33:02,710 Unikal, ruhu yaln谋z ox艧ar, lakin Siz yaln谋z b蓹z蓹n istifad蓹 ed蓹 bil蓹r, 684 00:33:02,710 --> 00:33:04,530 ancaq bazas谋 onu t蓹tbiq etm蓹k ist蓹yir蓹m. 685 00:33:04,530 --> 00:33:08,050 Index yaln谋z preemptively dem蓹kdir G蓹l蓹c蓹kd蓹 艧eyi s眉r蓹tl蓹ndirm蓹k 686 00:33:08,050 --> 00:33:10,230 M蓹n 眉莽眉n axtar谋艧 ed蓹 bil蓹rsiniz, bel蓹 ki, Bu sah蓹d蓹 艧eyl蓹r. 687 00:33:10,230 --> 00:33:13,700 V蓹 sonra tam m蓹tn 眉莽眉n ad蓹t蓹n ci madd蓹l蓹rd蓹 v蓹 ya o莽erkl蓹r, v蓹 ya b枚y眉k orqanlar谋 688 00:33:13,700 --> 00:33:16,270 harada m蓹tn h蓹m莽inin isteyebilirsiniz 689 00:33:16,270 --> 00:33:19,420 ulduz ekvivalent kimi v蓹h艧i kartlar谋. 690 00:33:19,420 --> 00:33:19,920 Right. 691 00:33:19,920 --> 00:33:22,580 >> Bel蓹 ki c眉r idi bir d蓹f蓹 b眉t眉n bir 莽ox. 692 00:33:22,580 --> 00:33:25,220 Biz 莽蓹km蓹k m眉mk眉n olmad谋qda nin g枚r蓹k Bu x眉susiyy蓹tl蓹ri bir ne莽蓹 693 00:33:25,220 --> 00:33:29,540 v蓹 sonra bir 艧ey qurmaq kifay蓹t q蓹d蓹r sad蓹, lakin g眉cl眉. 694 00:33:29,540 --> 00:33:31,380 Dig蓹r aras谋nda bel蓹 dizayn q蓹rarlar谋 sen 695 00:33:31,380 --> 00:33:34,005 n蓹tic蓹d蓹 boyunca var gedir storage motorlar谋 x蓹tl蓹ri. 696 00:33:34,005 --> 00:33:37,370 V蓹 m蓹n蓹 yaln谋z bu qeyd ed蓹k son layih蓹l蓹r 蓹r蓹f蓹sind蓹, 697 00:33:37,370 --> 00:33:42,020 v蓹 g枚zl蓹yi艧 ed蓹k dem蓹k he莽 bunu ed蓹k. 698 00:33:42,020 --> 00:33:43,820 Bu ki莽ik in艧a ed蓹k ilk proqram. 699 00:33:43,820 --> 00:33:48,070 M蓹n terminal getm蓹k 眉莽眉n gedir蓹m p蓹nc蓹r蓹 v蓹 burada deyil 700 00:33:48,070 --> 00:33:52,500 yaln谋z counter.php, indi biz olacaq olan kimi art谋q ilgili qurtarmaq 眉莽眉n, 701 00:33:52,500 --> 00:33:54,570 lakin biz b眉t眉n d蓹st蓹 var rehberler v蓹 bu 702 00:33:54,570 --> 00:33:58,080 ruhunda 莽ox ox艧ard谋r olacaq 茝g蓹r problem g枚rm蓹k laz谋md谋r n蓹 眉莽眉n yeddi se莽in. 703 00:33:58,080 --> 00:34:00,980 >> Bel蓹likl蓹, biz 眉莽 rehberler var ictimai v蓹 艧ablonlar谋 daxildir 704 00:34:00,980 --> 00:34:05,040 d蓹qiq biz off sol Bizim b眉t眉n MVC paradiqma il蓹 Bazar ert蓹si. 705 00:34:05,040 --> 00:34:09,290 V蓹 recap, ictimai getm蓹k gedir M蓹n istifad蓹莽il蓹r ist蓹yir蓹m ki, h蓹r hans谋 bir fayl, h蓹qiq蓹t蓹n 706 00:34:09,290 --> 00:34:12,969 v ziyar蓹t ed蓹 bil蓹c蓹kl蓹r URL vasit蓹sil蓹 browser. 707 00:34:12,969 --> 00:34:13,502 艦ablon. 708 00:34:13,502 --> 00:34:14,710 Biz 艧ablonlar谋 n蓹 qoymaq idi? 709 00:34:14,710 --> 00:34:17,070 Stuff hans谋? 710 00:34:17,070 --> 00:34:21,659 Yox idi 莽ox, lakin bir ne莽蓹 bazar ert蓹si az谋 fayllar谋. 711 00:34:21,659 --> 00:34:22,619 B蓹li. 712 00:34:22,619 --> 00:34:23,100 >> Auditoriya: Header v蓹 Footer? 713 00:34:23,100 --> 00:34:24,516 >> DAVID J. MALAN: Header v蓹 Footer. 714 00:34:24,516 --> 00:34:26,679 Bel蓹likl蓹, biz bu g眉n d蓹 ox艧ar bir 艧ey var. 715 00:34:26,679 --> 00:34:30,330 Biz bir ne莽蓹 fayllar谋 var, lakin Footer M蓹n g枚r眉r蓹m M枚vzu g枚rm蓹k 716 00:34:30,330 --> 00:34:31,909 v蓹 sonra dig蓹r fayllar谋 bir d蓹st蓹. 717 00:34:31,909 --> 00:34:35,482 Bel蓹 ki, bu b蓹rab蓹rdir olan V MVC bax谋m谋ndan, bu, 718 00:34:35,482 --> 00:34:37,690 yen蓹 olacaq bir az daha problem ayd谋n, yeddi m眉蓹yy蓹n 719 00:34:37,690 --> 00:34:40,380 lakin bu m蓹n yaln谋z bir qovluq M蓹nim estetik bir 莽ox qoyaraq. 720 00:34:40,380 --> 00:34:42,840 M蓹nim HTML, m蓹nim formalar谋 bir 莽ox var. 721 00:34:42,840 --> 00:34:46,899 Eyni zamanda, daxildir, ba艧qa Bu 眉莽 fayllar谋 var ki, kataloq 722 00:34:46,899 --> 00:34:48,440 v蓹-nin bu bir s眉r蓹tli n蓹z蓹r salaq. 723 00:34:48,440 --> 00:34:51,699 >> M蓹n ir蓹li getm蓹k 眉莽眉n gedir蓹m v蓹 config.php a莽maq. 724 00:34:51,699 --> 00:34:54,610 Bu, 莽ox 莽谋x谋r kimi m眉dd蓹ti 蓹vv蓹lki kimi, 725 00:34:54,610 --> 00:34:57,850 Siz k蓹skin daxil Pset7 il蓹 CS50 dot h. 726 00:34:57,850 --> 00:35:00,780 Bug眉nk眉 M蓹s蓹l蓹n, siz olacaq ki, b蓹rab蓹r etm蓹k 727 00:35:00,780 --> 00:35:03,600 bir t蓹l蓹b b蓹yanat ki, s蓹m蓹r蓹li 728 00:35:03,600 --> 00:35:05,340 Bu bir ne莽蓹 x蓹tl蓹ri daxildir. 729 00:35:05,340 --> 00:35:08,225 Bel蓹 ki, ayd谋n olmaq, bu bir fayl config.php 莽a臒谋r谋b. 730 00:35:08,225 --> 00:35:09,350 V蓹 bunu n蓹 g枚r眉rs眉n眉z. 731 00:35:09,350 --> 00:35:11,970 Bu y蓹qin bir 艧ey edir sirli, d枚n眉艧 s蓹hv messages 732 00:35:11,970 --> 00:35:13,680 Siz browser onlara g枚r蓹 bil蓹rsiniz ki. 733 00:35:13,680 --> 00:35:15,860 Bu y蓹qin, sonra var dig蓹r iki fayllar谋 t蓹l蓹b 734 00:35:15,860 --> 00:35:19,530 bu, C # daxil kimi v蓹 sonra biz g枚rd眉n眉z bu, 735 00:35:19,530 --> 00:35:22,720 v蓹 biz istinad etdiyiniz bu 莽evrilir funksionall谋臒谋 kimi ki, al谋艧-veri艧 sepeti. 736 00:35:22,720 --> 00:35:25,610 >> Bu cookie dem蓹kdir geri v蓹 ir蓹li g枚nd蓹rilir. 737 00:35:25,610 --> 00:35:27,290 Bel蓹 ki, niy蓹 bu maraql谋 deyil? 738 00:35:27,290 --> 00:35:32,460 B蓹li, biz bu geri getm蓹k 蓹g蓹r kataloq v蓹 m蓹s蓹l蓹n, a莽maq, 739 00:35:32,460 --> 00:35:33,741 constance.php. 740 00:35:33,741 --> 00:35:38,840 Qeyd ed蓹k PHP d蓹st蓹k sabitl蓹ri ki, kifay蓹t q蓹d蓹r C. # m眉蓹yy蓹n kimi deyil 741 00:35:38,840 --> 00:35:41,290 茝ksin蓹, siz s枚z眉n m眉蓹yy蓹n deyir蓹m, v蓹 bildiri艧 742 00:35:41,290 --> 00:35:44,110 M蓹n 蓹vv蓹lc蓹d蓹n saxlan谋l谋r etdik ki, Bu fayl d枚rd sabitl蓹ri. 743 00:35:44,110 --> 00:35:47,020 Bug眉nk眉 veril蓹nl蓹r bazas谋 眉莽眉n bir 眉莽眉n M蓹nim parol, m蓹nim istifad蓹莽i ad谋 眉莽眉n, 744 00:35:47,020 --> 00:35:48,690 v蓹 server ad谋. 745 00:35:48,690 --> 00:35:51,644 Bel蓹 ki, bu 蓹slind蓹 olacaq problem olduqca ox艧ar yeddi se莽in. 746 00:35:51,644 --> 00:35:54,560 V蓹 n蓹hay蓹t, bu m蓹n harada b蓹zi g枚z蓹l funksionall谋臒谋 almaq 眉莽眉n gedir 747 00:35:54,560 --> 00:35:59,000 hey蓹ti, functions.php biz yazd谋q kodu bir d蓹st蓹 edir 748 00:35:59,000 --> 00:36:01,040 M蓹n bu b蓹zi 莽ald谋 problem yeddi m眉蓹yy蓹n olan 749 00:36:01,040 --> 00:36:05,920 Bu g眉n 眉莽眉n, ki, h蓹r 艧eyi bir d蓹st蓹 edir v蓹 yaln谋z onlardan biri baxaq 750 00:36:05,920 --> 00:36:07,270 x眉susil蓹. 751 00:36:07,270 --> 00:36:09,720 Burada bu funksiya, sor臒u, olacaq 752 00:36:09,720 --> 00:36:13,600 biz deyirik PHP funksiyas谋 SQL icra etm蓹k 眉莽眉n. 753 00:36:13,600 --> 00:36:16,070 Bir an 蓹vv蓹l istifad蓹 edirdil蓹r phpMyAdmin, lakin ki, yaln谋z var 754 00:36:16,070 --> 00:36:18,720 t蓹dris m蓹qs蓹dl蓹ri n枚v 眉莽眉n v蓹 diaqnostik m蓹qs蓹dl蓹r 755 00:36:18,720 --> 00:36:20,494 v蓹 veril蓹nl蓹r bazas谋 set unutma. 756 00:36:20,494 --> 00:36:22,660 Zaman h蓹qiq蓹t蓹n istifad蓹 edin veril蓹nl蓹r bazas谋, siz insan, 757 00:36:22,660 --> 00:36:24,100 a莽谋q-ayd谋n niyy蓹tind蓹 deyil Bir web 莽蓹k蓹r蓹k olunacaq 758 00:36:24,100 --> 00:36:25,740 s蓹hif蓹 h蓹r d蓹f蓹 kims蓹 qeyd蓹. 759 00:36:25,740 --> 00:36:29,870 Siz kod yazmaq olacaq ki, ed蓹r v蓹 t蓹l蓹b istifad蓹莽il蓹r silir, 760 00:36:29,870 --> 00:36:32,490 v蓹 biz bunu olacaq sor臒u funksiyas谋 yolu il蓹. 761 00:36:32,490 --> 00:36:35,360 陌ndi a艧a臒谋 diyirl蓹yin 蓹g蓹r var bir ne莽蓹 x眉susiyy蓹tl蓹ri olacaq. 762 00:36:35,360 --> 00:36:37,170 Y枚nl蓹ndirm蓹 gedir biz yazd谋臒谋 bir funksiyas谋 olacaq 763 00:36:37,170 --> 00:36:40,160 sizin 眉莽眉n imkan verir Ba艧qa URL istifad蓹莽i g枚nd蓹rm蓹k, 764 00:36:40,160 --> 00:36:43,780 v蓹 g枚st蓹rm蓹k olduqca kimi, bir funksiyas谋 biz, h蓹qiq蓹t蓹n g枚st蓹rir ki, bazar ert蓹si g枚rd眉m 765 00:36:43,780 --> 00:36:48,000 艧ablon, lakin daha bu bar蓹d蓹 vasit蓹sil蓹 pset7 枚z g蓹zm蓹k formas谋. 766 00:36:48,000 --> 00:36:50,500 Indi 眉莽眉n, ir蓹li getm蓹k v蓹 bunu bildirin. 767 00:36:50,500 --> 00:36:54,860 >> M蓹nim m眉hazir蓹l蓹r masa daxil ed蓹k v蓹 Hal-haz谋rda he莽 bir 艧ey yoxdur ki, g枚r蓹c蓹ksiniz 768 00:36:54,860 --> 00:36:59,640 burada yaln谋z h蓹l蓹, v蓹 m蓹n蓹 d蓹 ged蓹k M蓹nim ictimai kataloq, harada 769 00:36:59,640 --> 00:37:02,780 Yaln谋z bir fayl index.php var. 770 00:37:02,780 --> 00:37:06,920 Bu fayl super sad蓹 g枚r眉n眉r haz谋rda, yaln谋z bu kimi g枚r眉n眉r. 771 00:37:06,920 --> 00:37:09,110 脟ox nec蓹 kimi biz bazar ert蓹si off sol. 772 00:37:09,110 --> 00:37:11,945 M蓹n bu fayl t蓹l蓹b edir蓹m olan config.php, 773 00:37:11,945 --> 00:37:15,160 bir kataloq daxildir dot dot, m蓹nim valideynl蓹r, 774 00:37:15,160 --> 00:37:17,650 v蓹 sonra yaln谋z bu fayl g枚st蓹rilm蓹si oldu. 775 00:37:17,650 --> 00:37:18,960 Bel蓹 ki, bu fayl n蓹dir? 776 00:37:18,960 --> 00:37:24,700 >> M蓹nim 艧ablonlar谋 a莽maq ed蓹k form.php, v蓹 biz bu g枚r蓹c蓹ksiniz. 777 00:37:24,700 --> 00:37:28,500 Super sad蓹, y蓹qin bu formas谋 Bir $ _GET v蓹 ya $ _POST t蓹r蓹find蓹n t蓹qdim gedir. 778 00:37:28,500 --> 00:37:29,320 Tez a臒l谋 ba艧谋nda olma 莽ek. 779 00:37:29,320 --> 00:37:33,760 780 00:37:33,760 --> 00:37:35,690 Sanki vizual fayl axtar谋艧. 781 00:37:35,690 --> 00:37:36,610 Metod post b蓹rab蓹rdir. 782 00:37:36,610 --> 00:37:39,280 Bel蓹 ki, kimi, URL istifad蓹 etm蓹k niyy蓹tind蓹 deyil Google saxla sort olacaq, yoxdur 783 00:37:39,280 --> 00:37:41,030 arxas谋nda m蓹lumat p蓹rd蓹 v蓹 bu 784 00:37:41,030 --> 00:37:43,580 bir t蓹qdim etm蓹k niyy蓹tind蓹dir register.php adl谋 fayl, 785 00:37:43,580 --> 00:37:45,660 ki, fayl biz h蓹l蓹 yaz谋l谋 deyil 786 00:37:45,660 --> 00:37:47,610 lakin n蓹 bu gedir bu kimi baxmaq. 787 00:37:47,610 --> 00:37:52,670 >> M蓹n ayr谋ca s蓹hif蓹 getm蓹k 茝g蓹r bu n蓹 localhost / index.php kimi g枚r眉n眉r. 788 00:37:52,670 --> 00:37:56,930 V蓹 yen蓹, serverin yaln谋z index.php f蓹rz. 789 00:37:56,930 --> 00:37:57,910 Daxil edin. 790 00:37:57,910 --> 00:37:59,870 Biz oldu臒unuz Bel蓹 ki, at, v蓹 m蓹n n蓹 ist蓹yir蓹m 791 00:37:59,870 --> 00:38:02,450 艧eyi yaz谋n ed蓹 olunur Davud kimi, v蓹 sonra 792 00:38:02,450 --> 00:38:08,050 M蓹nim telefon n枚mr蓹si, buyuracaqd谋r 陌ndi 617-555-1212, qeydiyyatdan 793 00:38:08,050 --> 00:38:09,910 v蓹 indi register.php tap谋lmad谋. 794 00:38:09,910 --> 00:38:11,440 M蓹n bu h蓹yata laz谋md谋r. 795 00:38:11,440 --> 00:38:13,320 Bel蓹 ki, tez q谋z谋艧d谋rmaq bildirin Bu up kimi bir 艧ey. 796 00:38:13,320 --> 00:38:18,640 M蓹nim ictimai kataloq daxil ed蓹k v蓹 register.php v蓹 gedit etm蓹k, 797 00:38:18,640 --> 00:38:22,300 v蓹 indi ir蓹li getm蓹k 眉莽眉n gedir蓹m v蓹 Biz bazar ert蓹si oldu臒u kimi, PHP rejimi ba艧lamaq, 798 00:38:22,300 --> 00:38:25,430 v蓹 yax谋n PHP tag, v蓹 nin 艧eyi bir ne莽蓹 n蓹 ed蓹k. 799 00:38:25,430 --> 00:38:28,336 >> Bel蓹 ki, bir, m蓹n bilir蓹m, formada yaz谋l谋, 800 00:38:28,336 --> 00:38:29,960 M蓹n a艧a臒谋dak谋 kontrol etm蓹k ist蓹yir蓹m ki. 801 00:38:29,960 --> 00:38:35,670 Bu bo艧, n蓹 istifad蓹莽i sonra ad谋 sah蓹sind蓹 tipli 802 00:38:35,670 --> 00:38:39,860 M蓹n bir 艧ey dem蓹k gedir蓹m kimi ad itkin 眉zr. 803 00:38:39,860 --> 00:38:42,380 Eyni zamanda, bu, 眉zr deyil PHP 艧ey in艧a, 804 00:38:42,380 --> 00:38:45,970 biz yaz谋rd谋 bir funksiyas谋 var pset7 眉莽眉n functions.php 805 00:38:45,970 --> 00:38:47,940 ki, bunu etm蓹k imkan谋 var. 806 00:38:47,940 --> 00:38:53,830 Dig蓹r sah蓹 蓹g蓹r Else bo艧, say谋, sonra m蓹n 807 00:38:53,830 --> 00:38:58,370 Bu 眉zr gedir istifad蓹莽i v蓹 itkin say谋 deyirl蓹r. 808 00:38:58,370 --> 00:38:59,320 Bu fayl saxla. 809 00:38:59,320 --> 00:39:02,640 >> 陌ndi m蓹nim brauzerinizin geri ged蓹k, daha c蓹hd geri forum getm蓹k. 810 00:39:02,640 --> 00:39:04,070 Qeydiyyat. 811 00:39:04,070 --> 00:39:05,090 OK. 812 00:39:05,090 --> 00:39:06,730 He莽 yax艧谋 olan oldu. 813 00:39:06,730 --> 00:39:08,120 M蓹n bir s蓹hv mesaj谋 almaq etm蓹yib. 814 00:39:08,120 --> 00:39:11,651 Ancaq 蓹v蓹zin蓹, 蓹g蓹r bu yenid蓹n bildirin s蓹hif蓹 v蓹 bir 艧ey t蓹min. 815 00:39:11,651 --> 00:39:12,150 Bu Lanet olsun. 816 00:39:12,150 --> 00:39:15,350 817 00:39:15,350 --> 00:39:17,140 Bunu. 818 00:39:17,140 --> 00:39:18,810 Qeydiyyat. 819 00:39:18,810 --> 00:39:20,350 M蓹n yanl谋艧 n蓹 idi? 820 00:39:20,350 --> 00:39:24,860 Bo艧 varsa, $ _POST ad谋. 821 00:39:24,860 --> 00:39:26,350 Daha dem蓹k? 822 00:39:26,350 --> 00:39:27,670 >> Oh, 蓹lb蓹tt蓹. 823 00:39:27,670 --> 00:39:30,919 M蓹n 蓹n m眉h眉m hiss蓹si, unuttum olan ("../ / config.php daxildir.") t蓹l蓹b edir. 824 00:39:30,919 --> 00:39:34,210 825 00:39:34,210 --> 00:39:36,460 M蓹n daxil olmaq laz谋md谋r , funksiyas谋 眉zr dil蓹yir蓹m 826 00:39:36,460 --> 00:39:37,770 he莽 bir 艧ey ba艧 n蓹. 827 00:39:37,770 --> 00:39:39,460 Funksiyas谋 faktiki olaraq m枚vcud deyil. 828 00:39:39,460 --> 00:39:40,640 Bel蓹 ki, yen蓹 bu c蓹hd ed蓹k. 829 00:39:40,640 --> 00:39:42,350 Nin s蓹hif蓹ni ed蓹k, Qeydiyyat bas谋n. 830 00:39:42,350 --> 00:39:43,060 OK. 831 00:39:43,060 --> 00:39:43,770 Orada deyil. 832 00:39:43,770 --> 00:39:45,700 Bel蓹 ki, 莽谋x谋艧 deyilik burada g枚r蓹n n蓹tic蓹 833 00:39:45,700 --> 00:39:47,685 bir 眉zr bir z蓹ng funksiyas谋, super sad蓹, 834 00:39:47,685 --> 00:39:50,060 v蓹 yaln谋z 莽ap h蓹r hans谋 M蓹n bir arqument kimi verir. 835 00:39:50,060 --> 00:39:51,370 >> B眉t眉n h眉quqlar, bel蓹 ki, 蓹m蓹kda艧l谋q ed蓹k. 836 00:39:51,370 --> 00:39:54,240 M蓹nim ad t蓹min ed蓹k Davud kimi, qeydiyyatdan, 837 00:39:54,240 --> 00:39:56,890 say谋 OK ed蓹k itkin d蓹 ki, t蓹min edir. 838 00:39:56,890 --> 00:39:58,650 617-555-1212. 839 00:39:58,650 --> 00:39:59,250 Qeydiyyat. 840 00:39:59,250 --> 00:39:59,750 OK. 841 00:39:59,750 --> 00:40:02,760 Bel蓹 ki, b眉t眉n, indi d蓹 yaln谋z bir 艧ey deyil maraql谋 olur. 842 00:40:02,760 --> 00:40:06,000 Bel蓹 ki, indi daha 莽ox 艧ey ed蓹k maraql谋 bu kimi ba艧 verir. 843 00:40:06,000 --> 00:40:09,980 M蓹n蓹 phpMyAdmin daxil ed蓹k v蓹 ed蓹k h蓹qiq蓹t蓹n, istifad蓹莽il蓹r adl谋 bir masa yaratmaq 844 00:40:09,980 --> 00:40:12,330 M蓹n 眉莽 verm蓹k gedir蓹m s眉tun, v蓹 m蓹n tez laz谋md谋r 845 00:40:12,330 --> 00:40:16,250 sonra ID yaratmaq v蓹 ad谋, v蓹 sonra say谋, 846 00:40:16,250 --> 00:40:18,832 v蓹 艧蓹xsiyy蓹t sah蓹 Ben bir int kimi t蓹rk etm蓹k niyy蓹tind蓹dir. 847 00:40:18,832 --> 00:40:20,790 M蓹n gedir蓹m ad谋 sah蓹 bir varchar kimi t蓹rk etm蓹k, 848 00:40:20,790 --> 00:40:23,257 v蓹 biz bir q蓹d蓹r 枚zba艧谋na, 64 dem蓹k laz谋md谋r. 849 00:40:23,257 --> 00:40:25,090 M蓹n gedir蓹m say谋 etm蓹k 眉莽眉n, siz n蓹 bilirik? 850 00:40:25,090 --> 00:40:27,350 Biz daxil olacaq burada AB艦 n枚mr蓹l蓹ri d蓹st蓹k, 851 00:40:27,350 --> 00:40:31,510 m蓹n bir 艧ey gedir蓹m char kimi v蓹 sonra 10 simvol 852 00:40:31,510 --> 00:40:34,540 bir sah蓹 kodunu max sonra yeddi r蓹q蓹m. 853 00:40:34,540 --> 00:40:37,870 V蓹 sonra burada, m蓹n gedir蓹m avtomatik art谋m bu sah蓹d蓹 m眉蓹yy蓹n 854 00:40:37,870 --> 00:40:40,550 Bu ilkin 蓹sas, v蓹 M蓹n ir蓹li v蓹 getm蓹k 眉莽眉n gedir蓹m 855 00:40:40,550 --> 00:40:42,240 dig蓹r qutular谋 h蓹r hans谋 bir kontrol. 856 00:40:42,240 --> 00:40:48,030 >> M蓹n indi n蓹hay蓹t Saxla bas谋n zaman, v蓹 m蓹n istifad蓹莽il蓹r masa geri 857 00:40:48,030 --> 00:40:52,270 Bu 蓹g蓹r kimi g枚r眉n眉r n蓹 m蓹n 陌ndi Yeni Tab strukturu bas谋n. 858 00:40:52,270 --> 00:40:54,550 Bel蓹 ki, bu, ayd谋n olmaq yaln谋z phpMyAdmin yoludur 859 00:40:54,550 --> 00:40:58,570 veril蓹nl蓹r bazas谋 masa dey蓹r蓹k ID, ad谋, v蓹 bir s谋ra 860 00:40:58,570 --> 00:41:02,040 x眉susil蓹 konfiqurasiyalar谋 il蓹 v蓹 biz sah蓹l蓹rind蓹 qalan ignore bil蓹rsiniz 861 00:41:02,040 --> 00:41:03,140 orada indi. 862 00:41:03,140 --> 00:41:04,810 >> Bel蓹 ki, indi m蓹n n蓹 ist蓹yir蓹m? 863 00:41:04,810 --> 00:41:09,060 M蓹n daxil indi getm蓹k 蓹g蓹r Bel蓹 ki, m蓹nim m蓹nb蓹 kodu, b眉t眉n yax艧谋, 蓹g蓹r 864 00:41:09,060 --> 00:41:11,190 M蓹n a艧a臒谋dak谋 sor臒u icra etm蓹k ist蓹yirik. 865 00:41:11,190 --> 00:41:14,970 Daxil, v蓹 m蓹n yaln谋z bil蓹rsiniz Istifad蓹莽il蓹r ciddi deyil dem蓹k 866 00:41:14,970 --> 00:41:18,620 bu h蓹min geri ticks laz谋md谋r istifad蓹莽il蓹r kimi bir t蓹hl眉k蓹li s枚z. 867 00:41:18,620 --> 00:41:22,810 M蓹n ad谋n谋 dem蓹k gedir蓹m, say谋, v蓹 sonra burada Ben 868 00:41:22,810 --> 00:41:24,960 a臒谋r kodu niyy蓹tind蓹 deyil h蓹l蓹 d蓹y蓹rl蓹rin r蓹q蓹mli. 869 00:41:24,960 --> 00:41:26,760 M蓹n iki sual i艧ar蓹l蓹ri qoymaq 眉莽眉n gedir蓹m. 870 00:41:26,760 --> 00:41:29,320 V蓹 bu konvensiya 莽ox dill蓹rd蓹 871 00:41:29,320 --> 00:41:31,730 qovu艧durma臒谋m谋z etm蓹k ist蓹yirsinizs蓹 bir string 眉莽眉n tutucu 872 00:41:31,730 --> 00:41:34,105 Siz sual istifad蓹 etm蓹k olacaq ni艧anlar谋, s蓹b蓹bl蓹r蓹 g枚r蓹 biz will 873 00:41:34,105 --> 00:41:36,370 haqq谋nda s枚hb蓹t geri g蓹lm蓹k t蓹hl眉k蓹sizlik v蓹 burada 874 00:41:36,370 --> 00:41:39,420 M蓹n o ke莽m蓹k gedir蓹m iki sah蓹l蓹ri ad谋 g枚nd蓹rm蓹k, 875 00:41:39,420 --> 00:41:44,850 v蓹 sonra, s谋ra g枚nd蓹rm蓹k v蓹 indi fayl谋 qeyd edin. 876 00:41:44,850 --> 00:41:47,090 >> V蓹 indi m蓹n gedir蓹m super burada enm蓹k 877 00:41:47,090 --> 00:41:55,690 sad蓹c蓹 rendersuccess.php, dem蓹k olan ba艧qa bir 艧ablon olacaq. 878 00:41:55,690 --> 00:41:57,380 M蓹n, h蓹qiq蓹t蓹n, s眉r蓹tli yaratmaq 眉莽眉n gedir蓹m. 879 00:41:57,380 --> 00:42:06,270 Geditsuccess.php v蓹 m蓹n yaln谋z gedir蓹m ki, fayl H1 m眉v蓹ff蓹qiyy蓹ti dem蓹k. 880 00:42:06,270 --> 00:42:06,990 B眉t眉n h眉quqlar. 881 00:42:06,990 --> 00:42:11,312 Bel蓹 ki, indi d蓹 geri ged蓹k M蓹n 蓹vv蓹l ziyar蓹t etdi browser. 882 00:42:11,312 --> 00:42:14,270 Nin ir蓹li getm蓹k v蓹 m蓹n yaz谋b t蓹sdiq Davud, m蓹n, bir telefon n枚mr蓹si yazd谋 883 00:42:14,270 --> 00:42:15,390 qeydiyyatdan ke莽m蓹lisiniz. 884 00:42:15,390 --> 00:42:16,100 Bu Lanet olsun. 885 00:42:16,100 --> 00:42:17,420 M蓹n yanl谋艧 n蓹 idi? 886 00:42:17,420 --> 00:42:20,850 M蓹n, burada bir s蓹hv g枚r蓹n deyil蓹m Sizin SQL syntax bir s蓹hv var. 887 00:42:20,850 --> 00:42:24,900 M蓹n蓹 geri gedit jump ed蓹k, qoy M蓹n蓹 register.php geri 888 00:42:24,900 --> 00:42:28,830 v蓹 m蓹n ki, n蓹 buraxmaq idi m眉h眉m son d蓹f蓹 idi? 889 00:42:28,830 --> 00:42:29,722 M蓹n bu laz谋md谋r. 890 00:42:29,722 --> 00:42:32,930 Siz 莽ox dig蓹r bilm蓹k ist蓹yir蓹m olan 蓹vv蓹l qeyd, amma bu laz谋md谋r. 891 00:42:32,930 --> 00:42:35,596 >> Bel蓹 ki, indi geri ged蓹k, v蓹 bu brauzerinizin g枚rm蓹k 眉莽眉n faydal谋 oldu 892 00:42:35,596 --> 00:42:37,680 v蓹 niy蓹 config.php var biz s蓹hvl蓹r t眉p眉rm蓹k. 893 00:42:37,680 --> 00:42:41,770 Nin ir蓹li getm蓹k v蓹 yenid蓹n bildirin Davam u臒ur bas谋n. 894 00:42:41,770 --> 00:42:47,060 Bel蓹 ki, indi m蓹n蓹 眉z蓹rind蓹 ged蓹k m蓹nim burada bazas谋 v蓹 istifad蓹莽i bas谋n 895 00:42:47,060 --> 00:42:51,680 v蓹 g枚z v蓹 indi m蓹n qeyd burada m蓹nim bazas谋nda David var. 896 00:42:51,680 --> 00:42:55,810 陌ndi texniki bu haqqinda h蓹l蓹 ictimai internet, 897 00:42:55,810 --> 00:42:57,890 m蓹n ba艧qa ola bilm蓹z burada qoyaraq insanlar, 898 00:42:57,890 --> 00:43:01,120 amma indi 眉莽眉n, ist蓹yirdi instansiya, 枚z眉m眉 m蓹tn mesaj谋 g枚nd蓹r. 899 00:43:01,120 --> 00:43:03,920 Burada bir 蓹za 眉z蓹rind蓹 getm蓹k ed蓹k Bu h蓹qiq蓹t蓹n i艧l蓹yir g枚rmek. 900 00:43:03,920 --> 00:43:07,331 M蓹n ir蓹li getm蓹k 眉莽眉n gedir蓹m v蓹 bu s谋ra silm蓹k 901 00:43:07,331 --> 00:43:09,080 v蓹 biz bu blur laz谋md谋r video h蓹yata sonra 902 00:43:09,080 --> 00:43:11,900 bel蓹 ki, biz yoxdur B眉t眉n internet m蓹ni texting 903 00:43:11,900 --> 00:43:17,270 v蓹 indi q蓹d蓹r davam ed蓹c蓹k browser v蓹 biz m眉hazir蓹 art谋q getm蓹k laz谋md谋r 904 00:43:17,270 --> 00:43:22,040 v蓹 biz m眉xt蓹lif yaz谋n laz谋md谋r say谋, burada, u臒ur qeydiyyatdan ke莽in. 905 00:43:22,040 --> 00:43:25,550 >> Bel蓹 ki, indi, 枚z n枚mr蓹si ehtimalla var veril蓹nl蓹r bazas谋, v蓹 indi 蓹yl蓹nc蓹 hiss蓹si. 906 00:43:25,550 --> 00:43:28,774 Nin h蓹qiq蓹t蓹n n蓹 PHP istifad蓹 ed蓹k bir 艧ey program, 907 00:43:28,774 --> 00:43:30,940 ya komanda line v蓹 ya ba艧qa bir yerd蓹, 908 00:43:30,940 --> 00:43:32,773 v蓹 indi m蓹n yaln谋z deyil蓹m sad蓹 saxlamaq niyy蓹tind蓹dir 909 00:43:32,773 --> 00:43:36,230 v蓹 m蓹n getm蓹k 眉莽眉n gedir蓹m m蓹nim burada kataloq v蓹 a艧a臒谋dak谋. 910 00:43:36,230 --> 00:43:44,920 Gedit script biz will, dey蓹k , m蓹tn, #! / user / bin / env PHP z蓹ng 911 00:43:44,920 --> 00:43:46,700 kimi biz sonuncu d蓹f蓹 g枚rd眉m. 912 00:43:46,700 --> 00:43:47,950 PHP. 913 00:43:47,950 --> 00:43:55,055 >> 陌ndi t蓹l蓹b yoxdur gedir蓹m config.php daxildir, 914 00:43:55,055 --> 00:43:57,360 h蓹tta bu g眉c眉 olsa y眉ng眉l s蓹hv bi艧irm蓹k. 915 00:43:57,360 --> 00:44:03,960 V蓹 indi m蓹n ir蓹li getm蓹k v蓹 dem蓹k gedir蓹m istifad蓹莽il蓹r sat谋r, sor臒u, se莽in star, 916 00:44:03,960 --> 00:44:08,149 v蓹 indi burada bir texnika gedir蓹m s谋ra kimi h蓹r sat谋r 眉莽眉n son d蓹f蓹. 917 00:44:08,149 --> 00:44:09,690 M蓹n sad蓹 bir 艧ey 眉莽眉n gedir蓹m. 918 00:44:09,690 --> 00:44:19,090 Ad谋 bu dey蓹k printf, v蓹 say谋 bu backslash n. 919 00:44:19,090 --> 00:44:23,320 陌ndi ke莽m蓹k gedir蓹m s谋ra, d谋rna臒谋 ba臒lamaq ad谋 sitat 920 00:44:23,320 --> 00:44:28,140 v蓹 s谋ra quote d谋rna臒谋 ba臒lamaq say谋, v蓹 indi-nin ir蓹li ged蓹k 921 00:44:28,140 --> 00:44:31,430 v蓹 m蓹nim terminal p蓹nc蓹r蓹 chmod bu + x etm蓹k 922 00:44:31,430 --> 00:44:33,970 M蓹tn y眉r眉t眉lebilir adlanan bu script. 923 00:44:33,970 --> 00:44:36,080 陌ndi m蓹tn run bildirin. 924 00:44:36,080 --> 00:44:37,590 >> OK, bel蓹 ki, t蓹r蓹qqi. 925 00:44:37,590 --> 00:44:39,960 M蓹n indi yazd谋q command line script, 926 00:44:39,960 --> 00:44:43,300 ki, PHP adl谋 dilind蓹, ona g枚r蓹 ki, x蓹tti t蓹l蓹b 927 00:44:43,300 --> 00:44:46,380 b眉t眉n konfiqurasiya 莽谋x谋艧谋 var M蓹n ifad蓹 sabitl蓹ri. 928 00:44:46,380 --> 00:44:48,177 Veril蓹nl蓹r bazas谋 v蓹 s ad谋. 929 00:44:48,177 --> 00:44:50,260 茝slind蓹, yaln谋z ayd谋n olmaq bu bir fluke deyil ki, 930 00:44:50,260 --> 00:44:54,730 M蓹n蓹 davam v蓹 qeydiyyatdan imkan Rob kimi ba艧qa h蓹qiq蓹t蓹n s眉r蓹tli, kims蓹 931 00:44:54,730 --> 00:44:58,890 v蓹 ona 555-1212 say谋 ver蓹c蓹k. 932 00:44:58,890 --> 00:45:01,557 >> 陌ndi, m蓹n script run 蓹g蓹r yen蓹 g眉c hiss 933 00:45:01,557 --> 00:45:03,140 biz bazas谋 il蓹 i艧le. 934 00:45:03,140 --> 00:45:07,680 陌ndi d蓹rhal g枚rd眉m n蓹 Dig蓹r iki sat谋r m蓹nim bazas谋 var. 935 00:45:07,680 --> 00:45:10,699 Bel蓹 ki, indi bir 艧ey ed蓹k daxilind蓹 daha merakl谋s谋, 936 00:45:10,699 --> 00:45:12,740 bu biz hiss蓹sidir 蓹vv蓹lc蓹d蓹n test deyil, 937 00:45:12,740 --> 00:45:15,910 bel蓹 ki, son d蓹f蓹 bunu 艧eyl蓹r, horribly 蓹yri getdi 938 00:45:15,910 --> 00:45:17,120 ki, t蓹siri video var. 939 00:45:17,120 --> 00:45:18,286 >> 茝slind蓹, yeah, funny k蓹nara. 940 00:45:18,286 --> 00:45:20,480 Sonuncu d蓹f蓹 bel蓹 bir iki il 蓹vv蓹l kimi m眉hazir蓹, 941 00:45:20,480 --> 00:45:23,230 olmaq, m蓹n q蓹rar, q蓹rar b眉t眉n bu b枚y眉k bir fikir olard谋 942 00:45:23,230 --> 00:45:28,150 dinamik e-po莽t yaratmaq 眉莽眉n sinif, b眉t眉n veril蓹nl蓹r bazas谋 CS50 istifad蓹 943 00:45:28,150 --> 00:45:33,390 Biz蓹 onlar谋n verdiyi t蓹l蓹b蓹l蓹r, v蓹 onlar谋n telefon da艧谋y谋c谋lar谋 olan siz蓹 944 00:45:33,390 --> 00:45:36,290 pset0 xat谋rlay谋ram bil蓹r, bu 莽谋x谋r, s蓹b蓹b nec蓹 945 00:45:36,290 --> 00:45:40,650 M蓹n proqram ki莽ik bir s蓹hv var idi v蓹 2012-ci ild蓹 bir ne莽蓹 s蓹hvl蓹r etdi, m蓹n hesab edir蓹m. 946 00:45:40,650 --> 00:45:43,997 >> Vasit蓹si, m蓹n loop 眉莽眉n ki, 艧ey m蓹hz bu c眉r etdi 947 00:45:43,997 --> 00:45:46,580 veril蓹nl蓹r bazas谋 眉z蓹rind蓹 iterating, bazas谋nda bir ad almaq, 948 00:45:46,580 --> 00:45:49,940 h蓹r sonra veril蓹nl蓹r bazas谋 ad谋, v蓹 ki, loop iteration bir e-po莽t g枚nd蓹rdik. 949 00:45:49,940 --> 00:45:54,130 Amma 蓹v蓹zin蓹 bir e-po莽t g枚nd蓹rm蓹k, I bir e-po莽t ilk iteration g枚nd蓹rdi, 950 00:45:54,130 --> 00:45:58,200 iki e-po莽t ikinci iteration g枚nd蓹rdi 眉莽 e-po莽t ikinci iteration olan 951 00:45:58,200 --> 00:46:01,230 Siz geri bil蓹r bizim asimptotik notation m眉zakir蓹 952 00:46:01,230 --> 00:46:06,400 n kimi pis bu b枚y眉k O, kvadrat M蓹n g枚nd蓹rdi nec蓹 莽ox mesaj var 953 00:46:06,400 --> 00:46:08,560 lakin h蓹tta e-po莽t deyil Bu m蓹tn mesajlar谋 idi. 954 00:46:08,560 --> 00:46:12,070 >> Bildiyiniz kimi, olmay谋b deyil sonunda semestr do臒ru super y眉ks蓹k 955 00:46:12,070 --> 00:46:15,360 v蓹 m蓹n bu cute olaca臒谋n谋 d眉艧眉nd眉m zaman "Niy蓹 siz sinif deyil?" dem蓹k 956 00:46:15,360 --> 00:46:17,880 M蓹tn mesaj谋 I b眉t眉n sinif g枚nd蓹ril蓹n, 957 00:46:17,880 --> 00:46:22,140 v蓹 50% kimi g眉lm蓹li idi sinif, lakin dig蓹r 50%, onlardan b蓹zil蓹ri 958 00:46:22,140 --> 00:46:26,102 莽谋ld谋rd谋, i inan谋lmaz g枚nd蓹rdi 眉zr 艧irin notlar 959 00:46:26,102 --> 00:46:28,560 hey蓹ti 眉莽眉n 眉zr 眉莽眉n m眉hazir蓹 burax谋lm谋艧 ed蓹r蓹k yaln谋z 960 00:46:28,560 --> 00:46:29,530 bu d蓹f蓹, sa臒? 961 00:46:29,530 --> 00:46:32,790 962 00:46:32,790 --> 00:46:34,030 >> Bel蓹 ki, horribly 蓹yri edirik. 963 00:46:34,030 --> 00:46:37,030 Ki, ruhunda Bel蓹 ki, bu c蓹hd ed蓹k yen蓹 lakin yaln谋z m蓹nim s谋ra. 964 00:46:37,030 --> 00:46:41,940 脰nc蓹 functions.php, M蓹n burada bu funksiyan谋 yazd谋q. 965 00:46:41,940 --> 00:46:44,250 Bu m蓹tn adlan谋r v蓹 bu oldu 眉莽 d蓹lill蓹ri edir. 966 00:46:44,250 --> 00:46:46,360 Bir s谋ra da艧谋y谋c谋, v蓹 bir mesaj. 967 00:46:46,360 --> 00:46:50,390 >> M蓹n bir ke莽id 艧蓹rh kullan谋yorum hans谋 g枚z蓹l PHP, yaln谋z strings almaq 968 00:46:50,390 --> 00:46:53,350 integers, v蓹 m蓹n h蓹yata etm蓹yib h蓹l蓹 bu 眉莽眉n b眉t眉n d蓹st蓹yi, 969 00:46:53,350 --> 00:46:55,370 M蓹n yaln谋z AT & T v蓹 Verizon etdik. 970 00:46:55,370 --> 00:46:57,610 Bu 莽谋x谋r, 莽眉nki Bu da艧谋y谋c谋lar谋 il蓹 971 00:46:57,610 --> 00:47:00,570 onlar SMS 艧l眉zl蓹r e-po莽t qovu艧durma臒谋m谋z h蓹qiq蓹t蓹n bil蓹rsiniz 972 00:47:00,570 --> 00:47:05,529 bir 眉nvana e-po莽t g枚nd蓹rm蓹k vtext.com da telefon n枚mr蓹si kimi 973 00:47:05,529 --> 00:47:08,070 v蓹 istifad蓹莽i blok 蓹g蓹r mesajlar谋, onun vasit蓹sil蓹 getm蓹k laz谋md谋r 974 00:47:08,070 --> 00:47:09,340 m蓹tn mesaj谋. 975 00:47:09,340 --> 00:47:13,270 >> 陌ndi bunu, m蓹n 蓹lav蓹 etm蓹k 眉莽眉n gedir蓹m M蓹nim bazas谋nda h蓹qiq蓹t蓹n s眉r蓹tli bir sah蓹. 976 00:47:13,270 --> 00:47:15,470 M蓹n getm蓹k 眉莽眉n gedir蓹m M蓹nim strukturu v蓹 m蓹n 977 00:47:15,470 --> 00:47:21,880 ir蓹li getm蓹k v蓹 bir 蓹lav蓹 etm蓹k 眉莽眉n gedir C蓹dv蓹lin sonunda sah蓹sind蓹. 978 00:47:21,880 --> 00:47:25,227 Nin Go bas谋n ed蓹k v蓹 m蓹n bu da艧谋y谋c谋s谋 z蓹ng gedir 979 00:47:25,227 --> 00:47:27,310 v蓹 indi m蓹n gedir蓹m Bir bar m蓹tn kimi bu t蓹rk, 980 00:47:27,310 --> 00:47:29,320 lakin biz g蓹l蓹c蓹kd蓹 merakl谋s谋 ola bil蓹r. 981 00:47:29,320 --> 00:47:31,961 M蓹n tez getm蓹k 眉莽眉n gedir蓹m m蓹nim stol眉st眉, v蓹 m蓹n 982 00:47:31,961 --> 00:47:34,210 Rob qurtarmaq 眉莽眉n gedir, ki, bir saxta 莽眉nki, 983 00:47:34,210 --> 00:47:38,540 M蓹n burada redakt蓹 getm蓹k 眉莽眉n gedir蓹m v蓹 m蓹n 蓹l m蓹nim da艧谋y谋c谋s谋 d蓹yi艧dirm蓹k 眉莽眉n gedir 984 00:47:38,540 --> 00:47:43,410 Verizon, olmaq 眉莽眉n onu v蓹 indi burada bitdi. 985 00:47:43,410 --> 00:47:44,980 >> Tez a臒l谋 ba艧谋nda olma 莽ek ed蓹k. 986 00:47:44,980 --> 00:47:52,730 Bizim m蓹tn script, a莽maq imkan olan bu kimi g枚r眉n眉r, da艧谋y谋c谋% s. 987 00:47:52,730 --> 00:47:58,230 Biz daha 莽ox s蓹hv edirik M蓹n 2012-ci ild蓹 da艧谋y谋c谋s谋 daha yoxlan谋lmas谋. 988 00:47:58,230 --> 00:48:01,160 V蓹 indi m蓹n getm蓹k 眉莽眉n gedir蓹m ir蓹li v蓹 script yenid蓹n ax谋r. 989 00:48:01,160 --> 00:48:01,660 OK. 990 00:48:01,660 --> 00:48:06,100 Carrier dem蓹kdir Verizon edir 陌ndi 眉mid edir蓹m ki, yaln谋z bu ed蓹 bil蓹rsiniz. 991 00:48:06,100 --> 00:48:08,360 D眉zg眉n bu il, 眉mid edir蓹m ki, burada biz gedin. 992 00:48:08,360 --> 00:48:12,200 >> Bel蓹 ki, loop 眉莽眉n bu daxilind蓹, m蓹n bu printf 眉莽眉n yaln谋z gedir, 993 00:48:12,200 --> 00:48:15,990 M蓹n d蓹 m蓹tn z蓹ng etm蓹k 眉莽眉n gedir蓹m v蓹 bu funksiya geri istifad蓹 994 00:48:15,990 --> 00:48:19,670 idi bir, bir s谋ra edir da艧谋y谋c谋, v蓹 bir mesaj. 995 00:48:19,670 --> 00:48:23,310 Bel蓹 ki, g枚r蓹k, say谋 gedir s谋ra quote d谋rna臒谋 ba臒lamaq olacaq "say谋" 996 00:48:23,310 --> 00:48:31,660 s谋ra quote d谋rna臒谋 ba臒lamaq "g蓹misi" v蓹 son bir mesaj idi. 997 00:48:31,660 --> 00:48:36,250 Bu il n枚qt蓹li verg眉l q谋ymaq etm蓹yin. 998 00:48:36,250 --> 00:48:36,780 >> OK. 999 00:48:36,780 --> 00:48:38,280 Fingers ke莽di. 1000 00:48:38,280 --> 00:48:39,970 Bu i艧l蓹ri nin g枚r蓹k. 1001 00:48:39,970 --> 00:48:41,720 B眉t眉n h眉quqlar, bel蓹. 1002 00:48:41,720 --> 00:48:43,000 Burada biz gedin. 1003 00:48:43,000 --> 00:48:47,380 Nin Telefonun kilidini a莽maq ed蓹k, Sizin barmaqlar谋n谋 ke莽m蓹y蓹, Lanet olsun. 1004 00:48:47,380 --> 00:48:50,300 Undefined d蓹yi艧蓹n may-- oh real s眉r蓹tli, g枚zl蓹yin, g枚zl蓹yin. 1005 00:48:50,300 --> 00:48:51,340 Real s眉r蓹tli, real s眉r蓹tli. 1006 00:48:51,340 --> 00:48:53,380 Bu, tamamil蓹 bu d蓹y蓹r. 1007 00:48:53,380 --> 00:48:57,710 M蓹n蓹 uh-oh, i艧臒al莽谋 qoy, m蓹ni qapmaq ed蓹k. 1008 00:48:57,710 --> 00:48:59,965 M蓹tnl蓹r var, t蓹艧蓹kk眉r edir蓹m ba艧qas谋 ba艧lad谋. 1009 00:48:59,965 --> 00:49:04,770 1010 00:49:04,770 --> 00:49:11,650 M蓹n蓹 ir蓹li getm蓹k v蓹 real a莽maq ed蓹k Burada s眉r蓹tli, dropbox.php / mail. 1011 00:49:11,650 --> 00:49:12,660 Adi. 1012 00:49:12,660 --> 00:49:14,455 Tamamil蓹 bu d蓹y蓹r. 1013 00:49:14,455 --> 00:49:17,430 Downloads. 1014 00:49:17,430 --> 00:49:18,560 OK, m蓹nb蓹 src8m. 1015 00:49:18,560 --> 00:49:19,700 OK. 1016 00:49:19,700 --> 00:49:21,380 >> Burada daha bir x蓹tt laz谋md谋r. 1017 00:49:21,380 --> 00:49:24,530 Oh orada bu Frosh var ki, Ani, bu 眉莽 reyestrin蓹 var. 1018 00:49:24,530 --> 00:49:28,820 Salam Oh, Margo, 莽ox t蓹艧蓹kk眉r edir蓹m. 1019 00:49:28,820 --> 00:49:31,130 OK, m蓹n burada bu x蓹tt itkin edilmi艧dir. 1020 00:49:31,130 --> 00:49:33,010 M蓹n蓹 tez i艧臒al莽谋 izl蓹 kodu bu x蓹tt, 1021 00:49:33,010 --> 00:49:36,200 olan po莽t v蓹 ya kitabxana daxildir M蓹n, h蓹qiq蓹t蓹n, istifad蓹 etm蓹k ist蓹yir蓹m ki, 1022 00:49:36,200 --> 00:49:38,300 M蓹n tez gedir蓹m funksiyalar谋 geri getm蓹k, 1023 00:49:38,300 --> 00:49:42,337 Bu 眉st getm蓹k 眉莽眉n gedir蓹m fayl v蓹 h蓹m莽inin bu fayl谋 t蓹l蓹b, 1024 00:49:42,337 --> 00:49:45,420 v蓹 indi m蓹n, h蓹qiq蓹t蓹n ke莽m蓹y蓹 gedir蓹m m蓹nim M蓹n komanda geri getm蓹k zaman barmaqlar谋 1025 00:49:45,420 --> 00:49:49,530 daxilind蓹 olan line script, Bu g眉n yerli host directory. 1026 00:49:49,530 --> 00:49:50,610 Run m蓹tn. 1027 00:49:50,610 --> 00:49:52,720 Daxil edin. 1028 00:49:52,720 --> 00:49:53,220 Mail. 1029 00:49:53,220 --> 00:49:53,719 Adi. 1030 00:49:53,719 --> 00:49:58,850 1031 00:49:58,850 --> 00:49:59,600 Adi. 1032 00:49:59,600 --> 00:50:01,680 Mail. 1033 00:50:01,680 --> 00:50:02,290 OK, Oh. 1034 00:50:02,290 --> 00:50:03,870 Burada biz gedin. 1035 00:50:03,870 --> 00:50:06,880 >> Mail yeni PHP bir po莽t al谋r. 1036 00:50:06,880 --> 00:50:09,970 M蓹n bu h眉ququ mi? 1037 00:50:09,970 --> 00:50:11,067 Bu Lanet olsun. 1038 00:50:11,067 --> 00:50:12,150 G枚zl蓹yin, g枚zl蓹yin, g枚zl蓹yin, oh To--. 1039 00:50:12,150 --> 00:50:12,649 T蓹r蓹find蓹n se莽ilir. 1040 00:50:12,649 --> 00:50:15,820 1041 00:50:15,820 --> 00:50:18,630 M蓹n bu s枚z bel蓹 d蓹y蓹r olacaq. 1042 00:50:18,630 --> 00:50:20,340 脺nvan. 1043 00:50:20,340 --> 00:50:24,390 M蓹n etm蓹k niy蓹 bu Sa臒 sinif 蓹vv蓹l n眉mun蓹l蓹ri. 1044 00:50:24,390 --> 00:50:26,350 Uf. 1045 00:50:26,350 --> 00:50:27,910 A艧a臒谋dak谋 alanlar bilm蓹di. 1046 00:50:27,910 --> 00:50:31,500 1047 00:50:31,500 --> 00:50:33,040 Son bir 艧ey c蓹hd ed蓹k. 1048 00:50:33,040 --> 00:50:40,660 脺nvan谋 蓹lav蓹 set SMTP, 脺nvan h蓹qiq蓹t蓹n edir. 1049 00:50:40,660 --> 00:50:43,980 脺nvan谋 bu son hiss蓹sini c蓹hd ed蓹k. 1050 00:50:43,980 --> 00:50:47,210 Aw, m蓹n indi h蓹qiq蓹t蓹n k蓹d蓹rli deyil蓹m. 1051 00:50:47,210 --> 00:50:47,854 T蓹艧蓹kk眉r edir蓹m. 1052 00:50:47,854 --> 00:50:50,270 Amma h蓹qiq蓹t蓹n b眉t眉n t蓹艧蓹kk眉r m蓹tnl蓹r g枚nd蓹rilm蓹si etdik. 1053 00:50:50,270 --> 00:50:53,130 1054 00:50:53,130 --> 00:50:56,320 Bu David var. 1055 00:50:56,320 --> 00:50:59,310 Siz 蓹s蓹n edirik. 1056 00:50:59,310 --> 00:51:01,720 Orada onu t蓹rk ed蓹k v蓹 Biz bazar ert蓹si d眉zeltmek ed蓹c蓹k. 1057 00:51:01,720 --> 00:51:04,290 Sonra bax谋n. 1058 00:51:04,290 --> 00:51:08,090 >> Daven FARNHAM: 陌ndi Deep Daven Farnham t蓹r蓹find蓹n d眉艧眉nc蓹l蓹r. 1059 00:51:08,090 --> 00:51:11,340 1060 00:51:11,340 --> 00:51:17,590 Ikili a臒ac me艧蓹 d眉艧眉r varsa v蓹 he莽 bir C it-- [chuckling] 蓹traf谋nda. 1061 00:51:17,590 --> 00:51:18,998