1 00:00:00,000 --> 00:00:02,405 >> [MUSIC PLAYING] 2 00:00:02,405 --> 00:00:10,439 3 00:00:10,439 --> 00:00:11,980 DAVID Malan: B眉t眉n sa臒, bu CS50 edir. 4 00:00:11,980 --> 00:00:13,740 Bu h蓹ft蓹 s蓹kkiz sonu. 5 00:00:13,740 --> 00:00:15,887 Bu g眉n biz ba艧lamaq bir 蓹d蓹d doldurmaq 眉莽眉n 6 00:00:15,887 --> 00:00:17,720 Bu binan谋n g蓹ldikd蓹 web 艧eyl蓹r. 7 00:00:17,720 --> 00:00:20,020 Bel蓹 ki, bazar ert蓹si Xat谋rladaq ki biz daha 莽ox vaxt s蓹rf 8 00:00:20,020 --> 00:00:22,530 PHP, hans谋 bu dinamik proqramla艧d谋rma dili ki 9 00:00:22,530 --> 00:00:26,872 dig蓹r aras谋nda, biz蓹 莽谋x谋艧 imkan谋 verir 艧eyi, HTML v蓹 dig蓹r bu kimi content 10 00:00:26,872 --> 00:00:27,830 g枚rm蓹k laz谋md谋r ki. 11 00:00:27,830 --> 00:00:30,871 Amma biz, h蓹qiq蓹t蓹n, nec蓹 baxd谋 yoxdur biz h蓹r hans谋 bir m蓹lumat saxlamaq 眉莽眉n olacaq. 12 00:00:30,871 --> 00:00:34,477 H蓹qiq蓹t蓹n, h蓹r hans谋 bir ki, super Bu g眉n ziyar蓹t maraql谋 saytlar谋 13 00:00:34,477 --> 00:00:36,560 veril蓹nl蓹r bazas谋 bir n枚v geri sonunda, sa臒? 14 00:00:36,560 --> 00:00:39,540 Facebook 蓹lb蓹tt蓹 m蓹lumatlar谋n 莽ox ma臒azalar b眉t眉n biz蓹 v蓹 Gmail ma臒azalar b眉t眉n 15 00:00:39,540 --> 00:00:40,210 Sizin e-po莽t. 16 00:00:40,210 --> 00:00:44,150 >> Bel蓹 ki, bir 莽ox dig蓹r saytlar yaln谋z var informasiya var statik content. 17 00:00:44,150 --> 00:00:45,640 Bu bir 艧蓹kild蓹 h蓹qiq蓹t蓹n dinamik var. 18 00:00:45,640 --> 00:00:48,480 Siz daxil, bu yenilikl蓹ri t蓹min dig蓹r insanlar 眉莽眉n pages. 19 00:00:48,480 --> 00:00:50,620 Siz g枚nd蓹rm蓹k, mesaj almaq s mesajlar, v蓹. 20 00:00:50,620 --> 00:00:54,250 Bel蓹 ki, bu g眉n biz yax谋n baxmaq layih蓹nin underpinnings 21 00:00:54,250 --> 00:00:57,330 n枚vb蓹ti dal谋艧 laz谋md谋r ki, h蓹ft蓹, CS50 Maliyy蓹, hans谋 22 00:00:57,330 --> 00:01:00,509 h蓹qiq蓹t蓹n qurmaq 眉莽眉n gedir Biz C, amma PHP bir 艧ey. 23 00:01:00,509 --> 00:01:02,550 Bir g枚r眉n眉r ki, bir haqqinda bu kimi ki莽ik bir 艧ey 24 00:01:02,550 --> 00:01:05,810 ki, almaq v蓹 satmaq 眉莽眉n imkan verir h蓹qiq蓹t蓹n ehtiyatlar谋 25 00:01:05,810 --> 00:01:09,044 real zamanlar c蓹lb Yahoo Maliyy蓹 fond m蓹lumat. 26 00:01:09,044 --> 00:01:11,960 V蓹 bel蓹 n蓹tic蓹d蓹, siz laz谋md谋r 脰z眉n眉z 眉莽眉n v蓹 istifad蓹莽il蓹r 眉莽眉n ill眉ziya 27 00:01:11,960 --> 00:01:14,550 Siz, h蓹qiq蓹t蓹n, al谋nmas谋 v蓹 sat谋艧 edirik ki, ehtiyatlar谋 t蓹xmin蓹n real vaxt 蓹ld蓹 28 00:01:14,550 --> 00:01:16,800 yenilikl蓹ri, idar蓹 portfel, olan b眉t眉n 29 00:01:16,800 --> 00:01:20,310 olan t蓹l蓹b edir, n蓹tic蓹d蓹, istifad蓹莽il蓹r bir veril蓹nl蓹r bazas谋. 30 00:01:20,310 --> 00:01:23,330 >> Bel蓹 ki, 枚z s枚zl蓹ri il蓹, Siz etdiyiniz x眉susil蓹 31 00:01:23,330 --> 00:01:25,670 komp眉ter il蓹 super tan谋艧 elm v蓹 ya veril蓹nl蓹r bazas谋, n蓹 32 00:01:25,670 --> 00:01:30,790 bir veril蓹nl蓹r bazas谋 bilirik olmaq 陌ndi, nontechnical bax谋m谋ndan? 33 00:01:30,790 --> 00:01:32,300 Bu n蓹dir? 34 00:01:32,300 --> 00:01:36,882 Siz onu t蓹svir nec蓹 Bir roommate v蓹 ya bir dost? 35 00:01:36,882 --> 00:01:40,100 >> Auditoriya: [i艧itilemez] m蓹lumat [i艧itilemez] 36 00:01:40,100 --> 00:01:44,430 >> DAVID Malan: Bel蓹 ki, informasiya siyah谋s谋 v蓹 ya m蓹lumat siyah谋s谋n谋 store-- 37 00:01:44,430 --> 00:01:47,160 Siz saxlamaq ist蓹yir蓹m bil蓹r ki, bir istifad蓹莽i kimi bir 艧ey haqq谋nda. 38 00:01:47,160 --> 00:01:50,190 V蓹 istifad蓹莽il蓹r var n蓹 onlarla ba臒l谋? 39 00:01:50,190 --> 00:01:53,160 Facebook v蓹 ya bir istifad蓹莽i de臒ilseniz Gmail, x眉susiyy蓹tl蓹ri hans谋lard谋r 40 00:01:53,160 --> 00:01:54,940 ki, bizim b眉t眉n istifad蓹莽il蓹r var? 41 00:01:54,940 --> 00:01:58,530 Kimi, n蓹 b蓹zi ola bil蓹r tablo s眉tun olan biz 42 00:01:58,530 --> 00:01:59,390 son d蓹f蓹 alluded? 43 00:01:59,390 --> 00:02:01,140 Daha, bil蓹rsiniz, 莽眉nki bir veril蓹nl蓹r bazas谋 hesab 44 00:02:01,140 --> 00:02:05,810 h蓹qiq蓹t蓹n bir x眉lya Excel fayl谋 v蓹 ya Google kimi Tablo v蓹 ya Apple N枚mr蓹l蓹r fayl. 45 00:02:05,810 --> 00:02:08,280 >> Bel蓹 ki, siz n蓹 d眉艧眉n眉rs眉n眉z Bir istifad蓹莽i hesab zaman? 46 00:02:08,280 --> 00:02:11,290 Onlar n蓹 var? 47 00:02:11,290 --> 00:02:11,790 Bu n蓹dir? 48 00:02:11,790 --> 00:02:12,470 >> Auditoriya: A ad谋. 49 00:02:12,470 --> 00:02:13,303 >> DAVID Malan: A ad谋. 50 00:02:13,303 --> 00:02:16,840 Bel蓹 ki, 蓹g蓹r ad谋 kimi, David Malan B蓹zi istifad蓹莽i ad谋 olacaq. 51 00:02:16,840 --> 00:02:17,980 Bir istifad蓹莽i ba艧qa n蓹 var? 52 00:02:17,980 --> 00:02:18,770 >> Auditoriya: An ID. 53 00:02:18,770 --> 00:02:19,561 >> DAVID Malan: An ID. 54 00:02:19,561 --> 00:02:23,320 Bel蓹 ki, Harvard kimi bir 艧蓹xsiyy蓹t n枚mr蓹si kimi ID ya Yale Net ID v蓹 ya kimi. 55 00:02:23,320 --> 00:02:24,923 Bir istifad蓹莽i ba艧qa n蓹 ola bil蓹r? 56 00:02:24,923 --> 00:02:25,890 >> Auditoriya: Parol. 57 00:02:25,890 --> 00:02:29,240 >> DAVID Malan: b蓹lk蓹 bir A parol, 眉nvan, b蓹lk蓹 bir telefon n枚mr蓹si, b蓹lk蓹 58 00:02:29,240 --> 00:02:30,050 bir e-mail. 59 00:02:30,050 --> 00:02:32,640 Bel蓹 ki, sah蓹l蓹ri v蓹 bu d蓹st蓹l蓹ri var sort n蓹zar蓹t spiral h蓹yata bil蓹r 60 00:02:32,640 --> 00:02:34,760 tez tezlikl蓹 ba艧lamaq kimi oh, bu saxlamaq ed蓹k, h蓹yata 61 00:02:34,760 --> 00:02:36,190 v蓹 bu v蓹 saxlamaq ed蓹k. 62 00:02:36,190 --> 00:02:37,657 >> Amma biz h蓹qiq蓹t蓹n ki etm蓹liy蓹m? 63 00:02:37,657 --> 00:02:39,740 Bel蓹 ki, yen蓹, ruhi model Bu g眉n 眉莽眉n kimi biz 64 00:02:39,740 --> 00:02:42,320 faktiki SQL daxil dal谋艧, Yap谋land谋r谋lm谋艧 Query Language, 65 00:02:42,320 --> 00:02:44,186 bu kimi g枚r眉n眉r ki, bir veril蓹nl蓹r bazas谋 var. 66 00:02:44,186 --> 00:02:45,310 Bu, sad蓹c蓹 sat谋r ve s眉tun var. 67 00:02:45,310 --> 00:02:48,309 V蓹 Google Spreadsheets t蓹s蓹vv眉r ed蓹 bil蓹rsiniz v蓹 ya dig蓹r proqramlar h蓹r hans谋 bir say谋. 68 00:02:48,309 --> 00:02:52,130 Amma MySQL haqq谋nda 蓹sas n蓹 veril蓹nl蓹r bazas谋 proqram istifad蓹 etm蓹k olacaq, 69 00:02:52,130 --> 00:02:54,920 s蓹rb蓹st a莽谋q Facebook istifad蓹 available-- 70 00:02:54,920 --> 00:02:59,200 Bu v蓹 dig蓹r websites-- h蓹r hans谋 bir say谋 Veril蓹nl蓹r bazas谋 relationally 艧eyi saklar. 71 00:02:59,200 --> 00:03:01,770 V蓹 relational veril蓹nl蓹r bazas谋 ki, yaln谋z s枚z眉n bir dem蓹kdir 72 00:03:01,770 --> 00:03:03,672 sat谋r ve s眉tun 枚z data saklar. 73 00:03:03,672 --> 00:03:04,630 Bu kimi sad蓹 deyil. 74 00:03:04,630 --> 00:03:07,230 >> Bel蓹 ki, Oracle kimi bel蓹 bir 艧ey ki, Siz, 眉mumiyy蓹tl蓹, e艧itmi艧蓹m bil蓹r 75 00:03:07,230 --> 00:03:08,271 bir relational veril蓹nl蓹r bazas谋 var. 76 00:03:08,271 --> 00:03:10,929 V蓹 ba艧l谋q alt谋nda, onu sat谋r ve s眉tun ma臒azalar data. 77 00:03:10,929 --> 00:03:12,970 V蓹 Oracle siz蓹 bir al谋r pul 莽ox bunu, 78 00:03:12,970 --> 00:03:15,550 MySQL ittihamlar is蓹 Eyni 眉莽眉n he莽 bir 艧ey. 79 00:03:15,550 --> 00:03:18,790 Bel蓹 ki, SQL biz蓹 verm蓹k niyy蓹tind蓹dir 蓹n az谋 d枚rd 蓹m蓹liyyatlar谋. 80 00:03:18,790 --> 00:03:23,190 oxumaq kimi, data se莽m蓹k imkan谋 data, insert, silm蓹k, v蓹 yenil蓹m蓹 data. 81 00:03:23,190 --> 00:03:25,525 Ba艧qa s枚zl蓹, h蓹min H蓹qiq蓹t蓹n d枚rd 蓹sas 蓹m蓹liyyatlar 82 00:03:25,525 --> 00:03:28,950 biz蓹 d蓹yi艧dirm蓹k imkan gedir o sat谋r ve s眉tun stuff. 83 00:03:28,950 --> 00:03:33,250 >> x眉susil蓹 bu g眉n istifad蓹 ed蓹c蓹yik al蓹t SQL 枚yr蓹nm蓹k v蓹 onunla oynamaq 眉莽眉n 84 00:03:33,250 --> 00:03:34,627 yenid蓹n PHP MyAdmin adlan谋r. 85 00:03:34,627 --> 00:03:35,460 Bu web-based arac谋d谋r. 86 00:03:35,460 --> 00:03:38,200 脺mumi t蓹sad眉f ki, Bu PHP yaz谋l谋. 87 00:03:38,200 --> 00:03:42,400 Amma bu, biz蓹 bir qrafik verm蓹k olacaq istifad蓹莽i interfeysi biz, h蓹qiq蓹t蓹n bil蓹r ki, 88 00:03:42,400 --> 00:03:46,054 bu sat谋r ve s眉tun yaratmaq v蓹 sonra kod vasit蓹sil蓹 onlara dan谋艧maq. 89 00:03:46,054 --> 00:03:47,970 Bel蓹 ki, indi ba艧lamaq ed蓹k n蓹 m蓹n hesab edir蓹m ki, s蓹mimi deyil 90 00:03:47,970 --> 00:03:51,000 蓹yl蓹nc蓹 prosesinin c眉r web geri sonuna bina, 91 00:03:51,000 --> 00:03:54,580 istifad蓹莽i yoxdur hiss蓹l蓹ri g枚rm蓹k, lakin, 艧眉bh蓹siz ki, haqq谋nda qay臒谋, 92 00:03:54,580 --> 00:03:56,170 ki, 莽眉nki data ged蓹c蓹k daha. 93 00:03:56,170 --> 00:03:59,570 C v蓹 A, bel蓹 ki, ox艧ar az PHP kimi ki莽ik, 94 00:03:59,570 --> 00:04:04,954 SQL, v蓹 ya d蓹st蓹kl蓹y蓹n bazas谋 SQL, 蓹n az谋 bu m蓹lumatlar n枚vl蓹ri var 95 00:04:04,954 --> 00:04:05,870 v蓹 ba艧qalar谋 d蓹st蓹l蓹ri. 96 00:04:05,870 --> 00:04:08,107 CHAR, VARCHAR, INT, Bigint, Decimal v蓹 Datetime. 97 00:04:08,107 --> 00:04:09,940 V蓹 b眉t眉n var dig蓹r x眉susiyy蓹tl蓹ri d蓹st蓹, 98 00:04:09,940 --> 00:04:11,940 lakin bunu bildirin faktiki M蓹s蓹l蓹n yolu. 99 00:04:11,940 --> 00:04:16,450 >> M蓹n CS50 IDE getm蓹k 眉莽眉n gedir蓹m harada 蓹vv蓹lc蓹d蓹n, m蓹n daxil etdik 100 00:04:16,450 --> 00:04:19,372 v蓹 m蓹n d蓹 bir URL ziyar蓹t etdik PHP MyAdmin adlanan bu arac谋. 101 00:04:19,372 --> 00:04:22,580 V蓹 problem yeddi m眉蓹yy蓹n, biz dem蓹k laz谋md谋r Siz d蓹qiq nec蓹 bu interface almaq 眉莽眉n 102 00:04:22,580 --> 00:04:23,200 h蓹m莽inin. 103 00:04:23,200 --> 00:04:25,640 Sol 眉st k眉nc眉nd蓹, qeyd Bu m眉hazir蓹 deyir. 104 00:04:25,640 --> 00:04:27,610 V蓹 yaln谋z o dem蓹kdir ki, 蓹vv蓹lc蓹d蓹n, m蓹n yarad谋lm谋艧 105 00:04:27,610 --> 00:04:31,360 bo艧 bazas谋 adl谋 m眉hazir蓹 ki, h蓹l蓹 he莽 bir tablolar var. 106 00:04:31,360 --> 00:04:32,600 He莽 bir sat谋r ve s眉tun var. 107 00:04:32,600 --> 00:04:34,308 Ilk 脟眉nki odur ki, biz n蓹 olacaq 108 00:04:34,308 --> 00:04:37,100 bir masa yaratmaq 眉莽眉n ba艧lay谋n ki, bizim istifad蓹莽il蓹r saxlamaq olacaq. 109 00:04:37,100 --> 00:04:39,100 >> Bel蓹 ki, s枚z眉n 眉z蓹rind蓹 Burada sa臒, m蓹n 110 00:04:39,100 --> 00:04:42,070 veril蓹nl蓹r bazas谋 dem蓹k gedir M蓹n bir masa 陌stifad蓹莽il蓹r adl谋 ist蓹yir蓹m. 111 00:04:42,070 --> 00:04:44,845 Bel蓹 ki, bu fayl kimi ki, m蓹n m蓹nim m蓹lumatlar谋n b眉t眉n saxlamaq 眉莽眉n ist蓹yir蓹m. 112 00:04:44,845 --> 00:04:45,720 V蓹 ne莽蓹 s眉tun? 113 00:04:45,720 --> 00:04:47,740 Yax艧谋, indi 眉莽眉n sad蓹 saxlamaq imkan verir. 114 00:04:47,740 --> 00:04:51,855 M蓹n yaln谋z bir kimi saxlamaq ist蓹yir蓹m istifad蓹莽i ad谋 v蓹 istifad蓹莽i 眉莽眉n bir ad. 115 00:04:51,855 --> 00:04:53,020 Biz ki莽ik ba艧lamaq laz谋md谋r. 116 00:04:53,020 --> 00:04:55,370 Bel蓹 ki, m蓹n iki s眉tun c蓹mi ist蓹yir蓹m. 117 00:04:55,370 --> 00:04:57,360 M蓹n ir蓹li getm蓹k v蓹 Go bas谋n gedir蓹m. 118 00:04:57,360 --> 00:04:59,210 V蓹 sonra, bu s眉tunlar, m蓹n n蓹 gedir蓹m 119 00:04:59,210 --> 00:05:04,576 Bu internet 蓹g蓹r n蓹 etm蓹k b眉t眉n sa臒 cooperates-- 120 00:05:04,576 --> 00:05:05,950 bel蓹 ki, biz daha c蓹hd olacaq. 121 00:05:05,950 --> 00:05:09,180 M蓹n adl谋 bir masa yaratmaq 眉莽眉n gedir蓹m Iki s眉tun, il蓹 indi OK, Go bas谋n. 122 00:05:09,180 --> 00:05:10,520 陌ndi biz, h蓹qiq蓹t蓹n, s眉r蓹tli var. 123 00:05:10,520 --> 00:05:12,065 脟ox yax艧谋, t蓹艧蓹kk眉r edir蓹m. 124 00:05:12,065 --> 00:05:14,440 B眉t眉n h眉quqlar, bel蓹 ki, biz ist蓹yirik n蓹 Bu s眉tun adland谋rmaq 眉莽眉n nec蓹? 125 00:05:14,440 --> 00:05:16,080 >> Bel蓹 ki, bir ad谋 adland谋rmaq olacaq. 126 00:05:16,080 --> 00:05:19,480 Burada v蓹 interface ki, b眉t眉n g枚r眉r蓹m s蓹mimi, n蓹hay蓹t bir az 莽irkin olur 127 00:05:19,480 --> 00:05:21,270 Siz bir d蓹f蓹 b眉t眉n bu m蓹lumatlar谋 yazma臒a ba艧lay谋n. 128 00:05:21,270 --> 00:05:27,450 Amma n蓹 g枚z蓹l ki, sort deyil Paradoksal, m蓹n s眉tun yarad谋lmas谋 al谋ram, 129 00:05:27,450 --> 00:05:29,977 lakin al蓹t gic-gic var sat谋r onlar谋 qoydu 130 00:05:29,977 --> 00:05:31,560 ki, m蓹n bu s眉tunlar konfiqurasiya ed蓹 bil蓹rsiniz. 131 00:05:31,560 --> 00:05:33,550 Bel蓹 ki, ad谋 alt谋nda iki blanklara var var. 132 00:05:33,550 --> 00:05:36,180 Bu sah蓹l蓹rd蓹n biri I 陌stifad蓹莽i ad谋 deyil蓹n ist蓹yir蓹m, 133 00:05:36,180 --> 00:05:38,000 v蓹 dig蓹r sah蓹 I ad谋 s蓹sl蓹nm蓹k ist蓹yir蓹m. 134 00:05:38,000 --> 00:05:40,340 >> 陌ndi se莽m蓹k laz谋md谋r bu 艧eyl蓹r 眉莽眉n data n枚vl蓹ri. 135 00:05:40,340 --> 00:05:42,330 Bel蓹 ki, Excel is蓹 v蓹 Google Spreadsheets, 136 00:05:42,330 --> 00:05:45,531 Bir s眉tun ist蓹yirsinizs蓹, siz s枚z眉n yaln谋z Ad v蓹 ya istifad蓹莽i ad谋 yaz谋n, Enter d眉ym蓹sini bas谋n. 137 00:05:45,531 --> 00:05:48,030 B蓹lk蓹 qal谋n 眉z etm蓹k yaln谋z ayd谋nl谋q 眉莽眉n, lakin bu. 138 00:05:48,030 --> 00:05:50,140 Siz daxil deyil s眉tun n枚vl蓹ri. 139 00:05:50,140 --> 00:05:53,790 陌ndi Google Spreadsheets v蓹 ya Excel siz蓹, m蓹lumat g枚st蓹rilir nec蓹 m眉蓹yy蓹n ed蓹 bil蓹r. 140 00:05:53,790 --> 00:05:58,120 Siz Format menyusu, v蓹 bil蓹r ox艧ar dollar i艧ar蓹si g枚st蓹rir belirtebilirsiniz, 141 00:05:58,120 --> 00:05:59,900 眉z蓹n point d蓹y蓹r kimi bu g枚st蓹rir. 142 00:05:59,900 --> 00:06:01,990 >> Bel蓹 ki, ruhu ox艧ar Biz n蓹 ist蓹yirik n蓹, 143 00:06:01,990 --> 00:06:04,740 lakin bu, h蓹qiq蓹t蓹n m蓹cbur gedir data m眉蓹yy蓹n bir n枚v眉 olmal谋d谋r. 144 00:06:04,740 --> 00:06:07,750 陌ndi, h蓹tta bir an 蓹vv蓹l olsa yaln谋z bir ne莽蓹 data n枚vl蓹ri var bildirib 145 00:06:07,750 --> 00:06:11,120 h蓹qiq蓹t蓹n var bir b眉t眉n 莽ox, v蓹 onlar 146 00:06:11,120 --> 00:06:12,910 spesifikliyi d蓹r蓹c蓹 m眉xt蓹lif il蓹. 147 00:06:12,910 --> 00:06:14,970 V蓹 bir k蓹nara kimi, h蓹tta x眉lya 艧eyi ed蓹 bil蓹rsiniz 148 00:06:14,970 --> 00:06:17,520 storage geometrileri kimi bir veril蓹nl蓹r bazas谋 daxilind蓹. 149 00:06:17,520 --> 00:06:19,250 Siz h蓹r 艧eyi saxlaya bil蓹rsiniz GPS koordinatlar谋 kimi 150 00:06:19,250 --> 00:06:22,420 v蓹 h蓹qiq蓹t蓹n, riyazi tapmaq dig蓹r yax谋n xal. 151 00:06:22,420 --> 00:06:24,128 Amma biz olacaq Bu super sad蓹 saxlamaq 152 00:06:24,128 --> 00:06:26,800 v蓹 burada b眉t眉n q蓹d蓹r getm蓹k S枚zd蓹 simli n枚vl蓹ri. 153 00:06:26,800 --> 00:06:29,240 >> Bel蓹 ki, burada bir bir siyah谋s谋 variantlar谋 b眉t眉n d蓹st蓹. 154 00:06:29,240 --> 00:06:32,740 CHAR, VARCHAR, TINYTEXT, MEDIUMTEXT, LONGTEXT. 155 00:06:32,740 --> 00:06:34,110 V蓹 bu b枚y眉k n枚v眉 var. 156 00:06:34,110 --> 00:06:37,610 V蓹 t蓹蓹ss眉f ki, bir q蓹d蓹r Paradoksal C, 157 00:06:37,610 --> 00:06:40,120 bir CHAR h蓹qiq蓹t蓹n CHAR deyil. 158 00:06:40,120 --> 00:06:44,170 Bir bazas谋nda qeyd edin Sizin data type CHAR ki, 159 00:06:44,170 --> 00:06:47,390 ki, b蓹li, bu, o dem蓹kdir ki CHAR, lakin bir v蓹 ya daha 莽ox chars var. 160 00:06:47,390 --> 00:06:49,630 V蓹 m眉蓹yy蓹n etm蓹k ne莽蓹 chars ist蓹diyiniz. 161 00:06:49,630 --> 00:06:51,636 Bel蓹 ki, n蓹 tipik var bir istifad蓹莽i ad谋 眉莽眉n uzunlu臒u? 162 00:06:51,636 --> 00:06:52,760 Bir limit ad蓹t蓹n var? 163 00:06:52,760 --> 00:06:53,920 >> Auditoriya: [i艧itilemez] 164 00:06:53,920 --> 00:06:55,050 >> DAVID Malan: 16 b蓹lk蓹? 165 00:06:55,050 --> 00:06:55,990 Kimi bir 艧ey. 166 00:06:55,990 --> 00:06:57,948 Siz geri, bilir蓹m g眉n, bu s蓹kkiz olmaq 眉莽眉n istifad蓹. 167 00:06:57,948 --> 00:07:00,289 B蓹z蓹n 16, b蓹z蓹n var ki, daha 莽ox var. 168 00:07:00,289 --> 00:07:02,080 Bel蓹 ki, bu deyil M蓹n蓹 bir char verm蓹k dem蓹kdir. 169 00:07:02,080 --> 00:07:04,730 Bu m眉蓹yy蓹n etm蓹k dem蓹kdir sah蓹sind蓹 uzunlu臒u, 170 00:07:04,730 --> 00:07:07,402 v蓹 indi 16 kimi bir 艧ey dey蓹 bil蓹r. 171 00:07:07,402 --> 00:07:08,610 V蓹 burada off ticar蓹t var. 172 00:07:08,610 --> 00:07:11,360 Bel蓹 ki, biz bir anda g枚r眉rs眉n眉z bu bir o dem蓹kdir ki, 173 00:07:11,360 --> 00:07:14,620 h蓹r istifad蓹莽i ad谋 16 simvol olmal谋d谋r. 174 00:07:14,620 --> 00:07:18,720 Amma bir d蓹qiq蓹, M-A-L-A-N g枚zl蓹yin. Ki, varsa M蓹nim istifad蓹莽i ad谋 v蓹 m蓹n yaln谋z be艧 istifad蓹 edir蓹m, 175 00:07:18,720 --> 00:07:23,070 Veril蓹nl蓹r bazas谋 ki, n蓹 t蓹klif edir蓹m 11 simvol 眉莽眉n n蓹 etm蓹k ki, 176 00:07:23,070 --> 00:07:24,471 M蓹n yer qorunur etdik? 177 00:07:24,471 --> 00:07:25,220 Siz n蓹 ed蓹rdiniz? 178 00:07:25,220 --> 00:07:26,480 >> Auditoriya: [i艧itilemez] 179 00:07:26,480 --> 00:07:27,160 >> DAVID Malan: B蓹li, yaln谋z Onlara b眉t眉n null edir. 180 00:07:27,160 --> 00:07:28,290 Onlara bo艧luq olun. 181 00:07:28,290 --> 00:07:30,816 Amma y蓹qin ki, null, bel蓹 bir backslash adet s谋f谋r 莽ox. 182 00:07:30,816 --> 00:07:33,190 Bel蓹 ki, bir t蓹r蓹fd蓹n, biz 陌ndi m蓹nim istifad蓹莽i ad谋 蓹min etdi 183 00:07:33,190 --> 00:07:34,780 16 simvol art谋q ola bil蓹r. 184 00:07:34,780 --> 00:07:37,590 V蓹 flip t蓹r蓹find蓹 M蓹n h蓹qiq蓹t蓹n uzun ad olsayd谋 185 00:07:37,590 --> 00:07:39,940 v蓹 ya h蓹qiq蓹t蓹n uzun ist蓹di b蓹zi kimi istifad蓹莽i ad谋 186 00:07:39,940 --> 00:07:44,840 u艧aqlar ki, kollec ola bil蓹r v蓹 ya Yale.edu at, bir ola bilm蓹z. 187 00:07:44,840 --> 00:07:47,177 V蓹 bel蓹 蓹slind蓹, var 蓹g蓹r He莽 bir haqqinda 眉莽眉n qeydiyyatdan 188 00:07:47,177 --> 00:07:49,385 v蓹 dey蓹r蓹k yelled almaq 艦ifr蓹ni 莽ox uzun 189 00:07:49,385 --> 00:07:52,710 v蓹 ya istifad蓹莽i ad谋 bu, 莽ox uzun sad蓹c蓹 bir proqram莽谋, 莽眉nki 190 00:07:52,710 --> 00:07:55,500 onun bazas谋 konfiqurasiya, q蓹rar bu sah蓹d蓹 olacaq ki, 191 00:07:55,500 --> 00:07:57,150 art谋q bu uzunlu臒u 莽ox ola. 192 00:07:57,150 --> 00:08:00,580 >> B眉t眉n h眉quqlar, bel蓹 n蓹 varsa biz ad davam? 193 00:08:00,580 --> 00:08:05,240 Nec蓹 uzun laz谋md谋r tipik insan ad谋? 194 00:08:05,240 --> 00:08:07,492 Ne莽蓹 simvol, 16? 195 00:08:07,492 --> 00:08:09,450 M蓹n biz bil蓹r t蓹xmin edir蓹m Bu otaqda kims蓹 tapmaq 196 00:08:09,450 --> 00:08:13,210 ke莽蓹n onun ilk plus ad谋 16 simvol art谋q var. 197 00:08:13,210 --> 00:08:14,850 Bel蓹 ki, 17 daha yax艧谋 n蓹 var? 198 00:08:14,850 --> 00:08:17,040 18? 199 00:08:17,040 --> 00:08:18,830 25? 200 00:08:18,830 --> 00:08:20,350 B枚y眉k? 201 00:08:20,350 --> 00:08:20,980 30? 202 00:08:20,980 --> 00:08:21,855 >> Auditoriya: [i艧itilemez] 203 00:08:21,855 --> 00:08:23,700 DAVID Malan: 5000, Allah谋m oh. 204 00:08:23,700 --> 00:08:26,309 Bel蓹 ki, y蓹qin ki, bir layiqli var yuxar谋 bound edilir s枚yl蓹yirik. 205 00:08:26,309 --> 00:08:28,350 V蓹 burada biz n枚v var bir q蓹rar z蓹ng etm蓹k 眉莽眉n. 206 00:08:28,350 --> 00:08:30,400 Kimi, burada he莽 bir d眉zg眉n cavab yoxdur. 207 00:08:30,400 --> 00:08:32,740 Infinite olduqca m眉mk眉n deyil biz n蓹hay蓹t ist蓹yirik, 莽眉nki 208 00:08:32,740 --> 00:08:34,781 biz ist蓹yirik yax艧谋d谋r gedir yadda艧 t枚k眉lm蓹k gedir. 209 00:08:34,781 --> 00:08:36,909 Bel蓹 ki, biz bir etm蓹k laz谋md谋r bir n枚qt蓹d蓹 q蓹rar z蓹ng. 210 00:08:36,909 --> 00:08:41,010 >> Olacaq 脟ox 眉mumi, m蓹s蓹l蓹n, use-- v蓹 m蓹n蓹 burada K枚m眉rl蓹艧dirm蓹k m眉蓹yy蓹n imkan 211 00:08:41,010 --> 00:08:46,050 kimi, 蓹vv蓹l 255 sanki Bu veril蓹nl蓹r bazas谋 proqram yuxar谋 h蓹ddi 212 00:08:46,050 --> 00:08:46,700 ill蓹r 枚nc蓹. 213 00:08:46,700 --> 00:08:48,575 V蓹 insanlar bel蓹, bir 莽ox yaln谋z g枚z蓹l, dem蓹k olard谋. 214 00:08:48,575 --> 00:08:49,420 255 limit var. 215 00:08:49,420 --> 00:08:50,620 Yaln谋z maksimum istifad蓹 ed蓹k. 216 00:08:50,620 --> 00:08:51,870 Bu olduqca g眉lm蓹li deyil. 217 00:08:51,870 --> 00:08:55,060 Kimi, kims蓹 yazaraq edirsinizs蓹 200 plus simvol 眉莽眉n ad, 218 00:08:55,060 --> 00:08:56,140 bir az g眉lm蓹li ki. 219 00:08:56,140 --> 00:08:59,624 >> Amma ASCII deyil ki, unutmay谋n Sand谋q谋 眉莽眉n yaln谋z sistem. 220 00:08:59,624 --> 00:09:01,540 Bel蓹 ki, x眉susil蓹 bir Asiya qrupu 莽ox 221 00:09:01,540 --> 00:09:04,248 simvol var biz bilm蓹z M蓹nim AB艦 kimi klaviatura ifad蓹 222 00:09:04,248 --> 00:09:08,209 klaviatura, faktiki olaraq, b蓹zi simvollar 16 bit yerin蓹 s蓹kkiz bit almaq. 223 00:09:08,209 --> 00:09:10,250 Bel蓹 ki, bu, h蓹qiq蓹t蓹n, b眉t眉n 蓹sass谋z deyil 224 00:09:10,250 --> 00:09:12,250 daha 莽ox laz谋md谋r ki, space biz uy臒un ist蓹yirsinizs蓹 225 00:09:12,250 --> 00:09:16,252 莽ox AB艦 daha b枚y眉k simvol merkezli olanlar谋 m眉zakir蓹 meyl etdik. 226 00:09:16,252 --> 00:09:17,460 Bel蓹 ki, biz b蓹zi yuxar谋 bound laz谋md谋r. 227 00:09:17,460 --> 00:09:21,470 M蓹n 蓹n yax艧谋 n蓹 bilmir蓹m lakin 255 眉mumiyy蓹tl蓹 眉mumi biridir. 228 00:09:21,470 --> 00:09:22,700 25 a艧a臒谋 hiss edir. 229 00:09:22,700 --> 00:09:23,857 16, 32 a艧a臒谋 hiss edir蓹m. 230 00:09:23,857 --> 00:09:25,690 M蓹n t蓹r蓹find蓹 s蓹hv d眉艧m蓹k olard谋 y眉ks蓹k bir 艧ey. 231 00:09:25,690 --> 00:09:27,330 Amma ticar蓹t h蓹mi艧蓹 oldu臒u kimi, off var. 232 00:09:27,330 --> 00:09:31,902 , B蓹lk蓹 d蓹, ayd谋nd谋r n蓹 255 chars sifari艧 off ticar蓹t 233 00:09:31,902 --> 00:09:33,360 M蓹nim bazas谋nda h蓹r k蓹sin ad谋? 234 00:09:33,360 --> 00:09:34,230 >> Auditoriya: [i艧itilemez] 235 00:09:34,230 --> 00:09:34,510 >> DAVID MALAN: N蓹 olub? 236 00:09:34,510 --> 00:09:35,430 >> Auditoriya: [i艧itilemez] 237 00:09:35,430 --> 00:09:37,138 >> DAVID Malan: Bu var yadda艧 莽ox sa臒? 238 00:09:37,138 --> 00:09:42,280 M-A-L-A-N. M蓹n yaln谋z 250 s蓹rf simvol yaln谋z m蓹nim ad saxlamaq 眉莽眉n 239 00:09:42,280 --> 00:09:46,000 m眉dafi蓹, yaln谋z halda kims蓹 sinif bir h蓹qiq蓹t蓹n uzun ad谋 var. 240 00:09:46,000 --> 00:09:47,940 Ki, bir h蓹dsiz tradeoff kimi g枚r眉n眉r. 241 00:09:47,940 --> 00:09:52,040 >> Bel蓹 ki, ki, SQL 莽谋x谋r Bu veril蓹nl蓹r bazas谋 dili, 242 00:09:52,040 --> 00:09:55,480 h蓹qiq蓹t蓹n, bir 艧ey d蓹st蓹kl蓹yir VARCHAR, v蓹 ya nisbi CHAR 莽a臒谋r谋b. 243 00:09:55,480 --> 00:09:59,390 V蓹 bu ki, bu c眉r g枚z蓹l Bir sabit deyil m眉蓹yy蓹n etm蓹k 眉莽眉n imkan verir 244 00:09:59,390 --> 00:10:01,900 eni, 蓹ksin蓹, d蓹yi艧蓹n eni. 245 00:10:01,900 --> 00:10:05,060 V蓹 daha 莽ox x眉susi bir sah蓹sind蓹 maksimum eni. 246 00:10:05,060 --> 00:10:08,901 Bel蓹 ki, bu bir ad bil蓹r o dem蓹kdir ki, art谋q 250 simvol ola, 247 00:10:08,901 --> 00:10:10,150 lakin 蓹lb蓹tt蓹 ki, daha az ola bil蓹r. 248 00:10:10,150 --> 00:10:11,733 V蓹 veril蓹nl蓹r bazas谋 smart olacaq. 249 00:10:11,733 --> 00:10:14,860 M-A-L-A-N qoymaq deyils蓹, Bu, yaln谋z be艧 istifad蓹 olacaq 250 00:10:14,860 --> 00:10:18,120 b蓹lk蓹 alt谋 bytes kimi bir arxada null xarakteri, 251 00:10:18,120 --> 00:10:23,330 v蓹 蓹lav蓹 s蓹rf deyil Laz谋ms谋z 249 v蓹 ya 250 bytes. 252 00:10:23,330 --> 00:10:27,380 >> Bel蓹 ki, bu m蓹n olmal谋d谋r kimi g枚r眉n眉r bu hekay蓹 il蓹 ba艧lam谋艧d谋r. 253 00:10:27,380 --> 00:10:29,140 Amma h蓹mi艧蓹 bir tradeoff var. 254 00:10:29,140 --> 00:10:33,024 Bel蓹 ki, bir t蓹r蓹fd蓹n, bir istifad蓹莽i ad谋 m蓹n var a臒谋r 16 kodlu etm蓹k 眉莽眉n m眉蓹yy蓹n, 255 00:10:33,024 --> 00:10:34,940 v蓹 b蓹lk蓹 deyil sa臒 z蓹ng, b蓹lk蓹 256 00:10:34,940 --> 00:10:40,040 var, amma niy蓹 istifad蓹 H蓹r 艧ey 眉莽眉n VARCHARs? 257 00:10:40,040 --> 00:10:42,020 >> Bu s蓹b蓹bd蓹n m枚vcuddur. 258 00:10:42,020 --> 00:10:46,200 Niy蓹 h蓹r sah蓹 眉莽眉n VARCHARs istifad蓹 Onun uzunlu臒u 蓹vv蓹lc蓹d蓹n bilmir蓹m 259 00:10:46,200 --> 00:10:48,180 Sa臒, b枚y眉k bir 艧ey g枚r眉n眉r 蓹g蓹r? 260 00:10:48,180 --> 00:10:50,482 Kimi yaln谋z 莽ox yer istifad蓹 edin bu limit q蓹d蓹r laz谋md谋r? 261 00:10:50,482 --> 00:10:51,271 >> Auditoriya: yava艧. 262 00:10:51,271 --> 00:10:52,146 DAVID Malan: Speller? 263 00:10:52,146 --> 00:10:53,120 Auditoriya: yava艧 edir? 264 00:10:53,120 --> 00:10:53,970 DAVID Malan: Oh, yava艧 var. 265 00:10:53,970 --> 00:10:55,720 Yax艧谋, dem蓹k olar ki, h蓹mi艧蓹 var cavab s蓹mimi. 266 00:10:55,720 --> 00:10:56,520 Kimi, tradeoff var? 267 00:10:56,520 --> 00:10:58,570 Bu da daha 莽ox yer x蓹rcl蓹ri v蓹 ya daha 莽ox vaxt x蓹rcl蓹ri. 268 00:10:58,570 --> 00:11:00,111 Bel蓹 ki, bu halda, bu yava艧 ola bil蓹r. 269 00:11:00,111 --> 00:11:00,920 Niy蓹? 270 00:11:00,920 --> 00:11:05,830 >> Auditoriya: [i艧itilemez] [I艧itilemez] m眉蓹yy蓹n. 271 00:11:05,830 --> 00:11:06,640 >> DAVID Malan: Yax艧谋. 272 00:11:06,640 --> 00:11:09,670 Bel蓹 ki, h蓹tta geri bil蓹r PSED5, sizin yana艧ma il蓹 oynayan 273 00:11:09,670 --> 00:11:12,750 l眉臒蓹t, siz varsa dinamik yadda艧 ayr谋lmas谋 v蓹 ya saxlamaq 274 00:11:12,750 --> 00:11:14,630 ki, bir bufer art谋r h蓹qiq蓹t蓹n yava艧 ola bil蓹r. 275 00:11:14,630 --> 00:11:16,963 Siz malloc z蓹ng etm蓹k varsa, ba艧l谋q alt谋nda v蓹 b蓹lk蓹 276 00:11:16,963 --> 00:11:19,610 ki MySQL, bel蓹 ki, n蓹 var H蓹qiq蓹t蓹n, bu halda ola bil蓹r. 277 00:11:19,610 --> 00:11:22,430 V蓹 yol hesab edir蓹m, 蓹g蓹r geri h蓹tta PSet-- v蓹 ya 278 00:11:22,430 --> 00:11:26,340 kimi h蓹ft蓹 iki etdik 艧eyi ikili axtar谋艧 v蓹 ya h蓹tta x蓹tti axtar谋艧, 279 00:11:26,340 --> 00:11:30,690 h蓹r s枚z眉 haqq谋nda g枚z蓹l 艧eyl蓹r biri bir s眉tun bir veril蓹nl蓹r bazas谋 v蓹 ya h蓹r s枚z眉 280 00:11:30,690 --> 00:11:33,690 h蓹tta eyni uzunlu臒u olan h蓹min simvol b眉t眉n d蓹st蓹 281 00:11:33,690 --> 00:11:37,390 bo艧, siz istifad蓹 ed蓹 bil蓹rsiniz ki, Sizin data t蓹sad眉fi giri艧, sa臒? 282 00:11:37,390 --> 00:11:40,310 >> H蓹r bilirsinizs蓹 s枚z, 16 simvol 眉z 283 00:11:40,310 --> 00:11:46,460 Siz ki, pointer hesab istifad蓹 ed蓹 bil蓹rsiniz dan谋艧maq, biz蓹 getm蓹k 16, 32, 48, 64, 284 00:11:46,460 --> 00:11:49,589 v蓹 yaln谋z atlayabilir d蓹rhal hesab istifad蓹 ed蓹r蓹k, 285 00:11:49,589 --> 00:11:51,130 veril蓹nl蓹r bazas谋 s枚zl蓹ri h蓹r hans谋 bir. 286 00:11:51,130 --> 00:11:54,280 Bu bir VARCHAR 蓹g蓹r halbuki, n蓹 蓹v蓹zin蓹 n蓹 etm蓹k laz谋md谋r? 287 00:11:54,280 --> 00:11:55,960 >> [Telefon z蓹ng] 288 00:11:55,960 --> 00:11:58,680 >> Bu bir VARCHAR varsa, siz t蓹sad眉fi giri艧 istifad蓹 ed蓹 bilm蓹z. 289 00:11:58,680 --> 00:12:01,341 N蓹 眉莽眉n baxmaq v蓹 ya n蓹 etm蓹k laz谋md谋r? 290 00:12:01,341 --> 00:12:01,840 Evet? 291 00:12:01,840 --> 00:12:03,240 >> Auditoriya: [i艧itilemez] 292 00:12:03,240 --> 00:12:04,310 >> DAVID Malan: bax谋n whole-- iz vasit蓹sil蓹 293 00:12:04,310 --> 00:12:06,518 b眉t眉n siyah谋s谋 莽ox g眉man ki, n蓹 axtar谋r? 294 00:12:06,518 --> 00:12:08,356 X眉susi d蓹y蓹r n蓹 c眉r? 295 00:12:08,356 --> 00:12:09,230 Auditoriya: [i艧itilemez] 296 00:12:09,230 --> 00:12:11,105 DAVID Malan: Axtar谋ram null Terminators 眉莽眉n 297 00:12:11,105 --> 00:12:13,637 ki, s枚zl蓹ri ayr谋lmas谋 ay谋rmaq. 298 00:12:13,637 --> 00:12:15,720 Bel蓹 ki, yen蓹, bir tradeoff v蓹 he莽 bir d眉zg眉n cavab yoxdur. 299 00:12:15,720 --> 00:12:18,380 Amma bu, x眉susil蓹, harada Sizin istifad蓹莽il蓹r bir 莽ox ola almaq zaman 300 00:12:18,380 --> 00:12:21,700 Sizin server v蓹 y眉k, insanlar谋n say谋, y眉ks蓹k olur istifad蓹 301 00:12:21,700 --> 00:12:23,650 Bu, h蓹qiq蓹t蓹n, nontrivial q蓹rarlard谋r. 302 00:12:23,650 --> 00:12:26,640 Bel蓹 ki, biz bu bu t蓹rk, lakin bil蓹r h眉ququ 眉z蓹rind蓹 a艧a臒谋 diyirl蓹yin bildirin 303 00:12:26,640 --> 00:12:27,332 burada. 304 00:12:27,332 --> 00:12:30,290 陌ndi s眉tun bir ne莽蓹 var biz bir q蓹rar z蓹ng etm蓹k 眉莽眉n var. 305 00:12:30,290 --> 00:12:35,170 Bir istifad蓹莽i imkan m蓹nada edirmi bir istifad蓹莽i istifad蓹莽i ad谋 v蓹 ya istifad蓹莽i ad谋, 306 00:12:35,170 --> 00:12:36,370 , null ola ad谋? 307 00:12:36,370 --> 00:12:37,610 Bu, yaln谋z bo艧. 308 00:12:37,610 --> 00:12:40,360 Bir az c蓹f蓹ng hiss, m蓹n deyil蓹m bu qutular谋 yoxlamaq niyy蓹tind蓹 deyil. 309 00:12:40,360 --> 00:12:42,670 Amma bir 莽谋x谋r veril蓹nl蓹r bazas谋, siz dey蓹 bil蓹rsiniz 310 00:12:42,670 --> 00:12:44,620 Kims蓹 iste臒e bu d蓹y蓹r ola bil蓹r. 311 00:12:44,620 --> 00:12:47,180 Bu s眉tun yoxdur h蓹qiq蓹t蓹n orada olmaq. 312 00:12:47,180 --> 00:12:48,570 >> 陌ndi menyu a艧a臒谋 a莽谋lan bu var. 313 00:12:48,570 --> 00:12:50,810 V蓹 m蓹n h蓹l蓹 d蓹 hiss orada ilk s谋rada, 314 00:12:50,810 --> 00:12:52,520 m蓹n indi istifad蓹莽i ad谋 b蓹hs edir蓹m. 315 00:12:52,520 --> 00:12:56,290 V蓹 bu, bir veril蓹nl蓹r bazas谋 莽谋x谋r ki sad蓹 sad蓹c蓹 elektron tablo f蓹rqli olaraq, 316 00:12:56,290 --> 00:12:58,520 g枚st蓹ricil蓹ri adl谋 g眉cl眉 x眉susiyy蓹tl蓹ri vard谋r. 317 00:12:58,520 --> 00:13:02,600 V蓹 bir index izah bir yoldur 茝vv蓹lc蓹d蓹n bazas谋 insan ki, 318 00:13:02,600 --> 00:13:03,900 asan siz art谋q deyil蓹m. 319 00:13:03,900 --> 00:13:10,430 >> M蓹n sor臒u n蓹 c眉r se莽in bilirik v蓹 ya daxil etm蓹zd蓹n v蓹 ya silm蓹k v蓹 ya yenil蓹m蓹 320 00:13:10,430 --> 00:13:13,182 M蓹nim code ba艧a gedir ki, Bu bazas谋nda bunu. 321 00:13:13,182 --> 00:13:14,390 M蓹n bir 莽ox veri oxumaq ist蓹yir蓹m. 322 00:13:14,390 --> 00:13:15,681 M蓹n bir 莽ox veri daxil etm蓹k ist蓹yir蓹m. 323 00:13:15,681 --> 00:13:17,530 M蓹n daim ist蓹yir蓹m bir 莽ox veri silin. 324 00:13:17,530 --> 00:13:21,520 M蓹n olmaq gedir蓹m bilirik ki, 蓹g蓹r bir 莽ox 陌stifad蓹莽i ad谋 kimi bir sah蓹 daxil, 325 00:13:21,520 --> 00:13:24,770 M蓹n preemptively dey蓹 bil蓹rsiniz veril蓹nl蓹r bazas谋, M蓹n siz蓹 daha 莽ox bilm蓹k 326 00:13:24,770 --> 00:13:29,220 v蓹 m蓹n s蓹r蓹ncam谋 ist蓹yir蓹m ki, Siz index bu sah蓹 olmal谋d谋r. 327 00:13:29,220 --> 00:13:33,200 Bir sah蓹 v蓹 ya bir s眉tun indeksasiyas谋 harada o dem蓹kdir ki, 蓹vv蓹lc蓹d蓹n bazas谋 328 00:13:33,200 --> 00:13:37,040 kimi, b蓹zi ideyalar谋 borc olmal谋d谋r, h蓹ft蓹 d枚rd v蓹 be艧 v蓹 alt谋 CS50 329 00:13:37,040 --> 00:13:39,240 v蓹 h蓹qiq蓹t蓹n qurmaq bir ikili axtar谋艧 kimi bir 艧ey 330 00:13:39,240 --> 00:13:41,560 a臒ac v蓹 ya bir 艧ey 眉mumiyy蓹tl蓹 B a臒ac 莽a臒谋r谋b 331 00:13:41,560 --> 00:13:43,410 茝g蓹r 枚yr蓹nm蓹k ki, bir sinif kimi CS124 da 332 00:13:43,410 --> 00:13:46,710 Harvard, bir alqoritml蓹r sinif, v蓹 ya dig蓹r yerl蓹rd蓹 h蓹r hans谋 bir say谋. 333 00:13:46,710 --> 00:13:49,570 >> veril蓹nl蓹r bazas谋 v蓹 a臒谋ll谋 onu h蓹yata insanlar 334 00:13:49,570 --> 00:13:53,880 saxlamaq 眉莽眉n nec蓹 anlamaq ed蓹c蓹k m蓹lumatlar谋n masa 335 00:13:53,880 --> 00:13:57,061 yadda艧 ki, axtar谋艧lar v蓹 dig蓹r 蓹m蓹liyyatlar super s眉r蓹tli. 336 00:13:57,061 --> 00:13:58,060 Siz bunu yoxdur. 337 00:13:58,060 --> 00:14:00,640 Siz h蓹yata yoxdur x蓹tti axtar谋艧 v蓹 ya ikili axtar谋艧 338 00:14:00,640 --> 00:14:03,300 v蓹 ya sort v蓹 ya se莽im daxil sort ki, h蓹r hans谋 bir. 339 00:14:03,300 --> 00:14:06,590 Siz dem蓹k 蓹g蓹r bazas谋 sizin 眉莽眉n bunu edir Bu preemptively index bu sah蓹d蓹. 340 00:14:06,590 --> 00:14:09,100 >> V蓹 var, 莽ox g枚r蓹 bil蓹rsiniz B蓹zi dig蓹r x眉susiyy蓹tl蓹ri 341 00:14:09,100 --> 00:14:11,010 biz bazas谋 t蓹tbiqi 眉莽眉n dey蓹 bil蓹rsiniz. 342 00:14:11,010 --> 00:14:16,431 M蓹n unikal se莽erseniz Bu n蓹 dem蓹k bil蓹r Bu menyu, yaln谋z daxil蓹n? 343 00:14:16,431 --> 00:14:16,930 Evet? 344 00:14:16,930 --> 00:14:17,889 >> Auditoriya: [i艧itilemez] 345 00:14:17,889 --> 00:14:19,930 DAVID Malan: B蓹li, istifad蓹莽i ad谋 unikal olmal谋d谋r. 346 00:14:19,930 --> 00:14:23,330 Bu yax艧谋 bir 艧ey v蓹 ya pis bir 艧ey 眉莽眉n istifad蓹莽il蓹r il蓹 bir haqqinda 眉莽眉n bir veril蓹nl蓹r bazas谋? 347 00:14:23,330 --> 00:14:24,965 Istifad蓹莽i ad谋 unikal olmal谋d谋r? 348 00:14:24,965 --> 00:14:25,880 B蓹li, y蓹qin. 349 00:14:25,880 --> 00:14:27,800 Ki, varsa n蓹 sah蓹sind蓹 biz daxil olmaq 眉莽眉n istifad蓹 350 00:14:27,800 --> 00:14:31,867 Siz, h蓹qiq蓹t蓹n, insanlar olan ist蓹mir蓹m eyni hiss v蓹 ya eyni istifad蓹莽i ad谋. 351 00:14:31,867 --> 00:14:33,700 Bel蓹 ki, biz ola bil蓹r veril蓹nl蓹r bazas谋 ki, h蓹yata 352 00:14:33,700 --> 00:14:37,880 ki, indi m蓹nim PHP kodu v蓹 ya h蓹r hans谋 bir dild蓹, M蓹n, m蓹s蓹l蓹n, yoxlamaq yoxdur 353 00:14:37,880 --> 00:14:41,490 m眉tl蓹q bu istifad蓹莽i ad谋 yoxdur M蓹n kims蓹 qeydiyyatdan imkan 蓹vv蓹l var? 354 00:14:41,490 --> 00:14:46,690 Veril蓹nl蓹r bazas谋 adl谋 iki adam imkan ver蓹c蓹k David v蓹 ya Malans bu halda qeydiyyatdan ke莽m蓹lisiniz. 355 00:14:46,690 --> 00:14:50,030 >> V蓹 bir k蓹nara kimi, h蓹tta bu olsa menyu yaln谋z birini se莽in imkan verir, 356 00:14:50,030 --> 00:14:54,550 unikal index var biridir super s眉r蓹tli performans 眉莽眉n dizine, 357 00:14:54,550 --> 00:14:56,100 lakin bu da unikall谋臒谋 t蓹tbiq. 358 00:14:56,100 --> 00:14:58,850 V蓹 biz geri g蓹lm蓹k laz谋md谋r n蓹 yaln谋z bir anda dem蓹k iki. 359 00:14:58,850 --> 00:15:00,930 Eyni zamanda, m蓹n getm蓹k 蓹g蓹r m蓹nim ikinci s谋ra olan 360 00:15:00,930 --> 00:15:06,230 istifad蓹莽i ad谋, m蓹n m眉蓹yy蓹n etm蓹lidir Ad benzersiz olmal谋d谋r ki? 361 00:15:06,230 --> 00:15:09,550 Xeyr, 蓹lb蓹tt蓹 ki, ola bil蓹r, 莽眉nki yax艧谋d谋r iki David var 362 00:15:09,550 --> 00:15:11,050 Bu otaqda Malans, 莽ox g眉man ki,. 363 00:15:11,050 --> 00:15:14,290 Amma biz ba艧qa bir ad se莽蓹 蓹g蓹r, biz, 艧眉bh蓹siz ki toqqu艧ma ola bil蓹r. 364 00:15:14,290 --> 00:15:16,130 >> Masalar v蓹 kimi hash geri d眉艧眉n眉n. 365 00:15:16,130 --> 00:15:18,604 Bel蓹 ki, biz, 艧眉bh蓹siz ki, ist蓹mirik ad谋 sah蓹sind蓹 unikal etm蓹k. 366 00:15:18,604 --> 00:15:21,270 Bel蓹 ki, biz yaln谋z t蓹rk etm蓹k olacaq ki tire, tire, tire, he莽 bir 艧ey kimi. 367 00:15:21,270 --> 00:15:22,660 M蓹n t蓹rk gedir蓹m t蓹k ba艧qa h蓹r 艧ey. 368 00:15:22,660 --> 00:15:25,035 H蓹qiq蓹t蓹n, bu sah蓹l蓹rd蓹 蓹n biz qay臒谋 yoxdur. 369 00:15:25,035 --> 00:15:27,830 V蓹 m蓹n bu saxlamaq 眉莽眉n haz谋r oldu臒umu, , internet 蓹m蓹kda艧l谋q 蓹g蓹r 370 00:15:27,830 --> 00:15:35,032 M蓹n 莽ox, 莽ox, 莽ox Saxla bas谋n v蓹 yava艧-yava艧 bazas谋 xilas etmir. 371 00:15:35,032 --> 00:15:37,240 V蓹 indi bu geri Ben interface olan etiraf, 372 00:15:37,240 --> 00:15:38,680 ilk bax谋艧da b枚y眉k deyil. 373 00:15:38,680 --> 00:15:42,450 Amma gedir蓹m b眉t眉n bas谋n sol 眉st s枚z istifad蓹莽i. 374 00:15:42,450 --> 00:15:47,630 M蓹n burada getm蓹k 眉莽眉n gedir蓹m bas谋n 陌stifad蓹莽il蓹r v蓹 default, onu 375 00:15:47,630 --> 00:15:50,180 b蓹zi SQL icra, lakin bir an ki, daha 莽ox. 376 00:15:50,180 --> 00:15:52,654 Burada n蓹 bir x眉las蓹. 377 00:15:52,654 --> 00:15:55,320 V蓹 g枚rm蓹k ki, narahat deyil burada Lat谋n v蓹 陌sve莽 qeyd. 378 00:15:55,320 --> 00:16:00,490 Bu yaln谋z default var parametrl蓹ri, ilk MySQL, 莽眉nki, 379 00:16:00,490 --> 00:16:04,000 v蓹 ya PHP MyAdmin, iki bir ba艧 B蓹zi 陌sve莽 insanlar t蓹r蓹find蓹n yazd谋rd谋. 380 00:16:04,000 --> 00:16:06,100 Lakin burada bizim halda yersiz var. 381 00:16:06,100 --> 00:16:08,280 >> B眉t眉n h眉quqlar, bel蓹 ki, niy蓹 var Bu b眉t眉n maraql谋? 382 00:16:08,280 --> 00:16:13,050 Bu 莽谋x谋r, m蓹n data 蓹lav蓹 ed蓹 bil蓹rsiniz kodu yaz谋l谋 bir bazas谋nda. 383 00:16:13,050 --> 00:16:15,940 M蓹n ir蓹li getm蓹k v蓹 al谋ram burada m蓹nim fayl, m蓹n 384 00:16:15,940 --> 00:16:19,000 ir蓹li getm蓹k v蓹 kimi iddia gedir Bu veril蓹nl蓹r bazas谋, simli olan 385 00:16:19,000 --> 00:16:23,040 bu anda deyil, lakin o, biz problem almaq yeddi m眉蓹yy蓹n zaman ola bil蓹r. 386 00:16:23,040 --> 00:16:25,640 M蓹n ir蓹li getm蓹k 眉莽眉n gedir蓹m v蓹 , sor臒u adl谋 funksiyas谋 yerin蓹 387 00:16:25,640 --> 00:16:28,730 Hans谋 problem ver蓹c蓹k ki, yeddi paylama kodu m眉蓹yy蓹n 388 00:16:28,730 --> 00:16:31,490 蓹n az谋 bir m眉bahis蓹 edir, olan yaln谋z bir simli edir. 389 00:16:31,490 --> 00:16:33,460 SQL kodu A string. 390 00:16:33,460 --> 00:16:36,700 Bel蓹 ki, nec蓹 枚yr蓹nm蓹k 眉zeresiniz Yap谋land谋r谋lm谋艧 Sor臒u Dil yaz谋n. 391 00:16:36,700 --> 00:16:41,270 >> M蓹n yeni bir s谋ra daxil etm蓹k ist蓹yirsinizs蓹 m蓹nim Veril蓹nl蓹r bazas谋 kims蓹 t蓹qdim edib, 莽眉nki 392 00:16:41,270 --> 00:16:47,600 m蓹nim kodu bir formas谋, M蓹n s枚z眉n ki istifad蓹莽il蓹r daxil a艧a臒谋dak谋 yazmaq 393 00:16:47,600 --> 00:16:52,800 sah蓹l蓹ri: istifad蓹莽i ad谋, verg眉l, ad谋, d蓹y蓹rl蓹r, 394 00:16:52,800 --> 00:16:57,480 v蓹 indi daxil etm蓹k laz谋md谋r Malan, v蓹 quote kimi bir 艧ey, 395 00:16:57,480 --> 00:17:01,490 d谋rna臒谋 ba臒lamaq "David Malan. V蓹 indi h蓹tta SQL il蓹 tan谋艧 olanlar 眉莽眉n, 396 00:17:01,490 --> 00:17:07,830 niy蓹 vahid quotes istifad蓹 edir蓹m bu ya艧谋l simli daxilind蓹? 397 00:17:07,830 --> 00:17:10,790 398 00:17:10,790 --> 00:17:13,040 N蓹 s蓹b蓹b burada ola bil蓹r? 399 00:17:13,040 --> 00:17:14,609 >> M蓹n AT茝T-qar谋艧araq iki dild蓹 deyil蓹m ed蓹k. 400 00:17:14,609 --> 00:17:18,099 Query bir PHP funksiyas谋 lakin bir m眉bahis蓹 edir. 401 00:17:18,099 --> 00:17:21,740 V蓹 d蓹lil 枚z眉 眉莽眉n var ola adl谋 bir dild蓹 yaz谋lm谋艧d谋r 402 00:17:21,740 --> 00:17:23,500 SQL, Yap谋land谋r谋lm谋艧 Query Language. 403 00:17:23,500 --> 00:17:27,940 Bel蓹 ki, h蓹r 艧ey ki, m蓹n yaln谋z burada qeyd edib 404 00:17:27,940 --> 00:17:30,380 SQL adlanan bu dilidir. 405 00:17:30,380 --> 00:17:36,290 Bel蓹 ki, bir quotes il蓹 n蓹, yaln谋z bir s眉r蓹tli a臒l谋 ba艧谋nda olma 莽ek kimi? 406 00:17:36,290 --> 00:17:37,324 Davam et. 407 00:17:37,324 --> 00:17:37,990 Onlar strings ist蓹yirik. 408 00:17:37,990 --> 00:17:41,590 Bel蓹 ki, quote, d谋rna臒谋 ba臒lamaq Malan v蓹 quote, d谋rna臒谋 ba臒lamaq David Malan strings var. 409 00:17:41,590 --> 00:17:45,210 V蓹 yaln谋z indi daxil蓹n d眉艧眉n眉r C v蓹 PHP haqq谋nda n蓹 bilm蓹d蓹n, 410 00:17:45,210 --> 00:17:50,220 niy蓹 bunu, M蓹n ad蓹t蓹n etm蓹yib strings 眉莽眉n istifad蓹 ikiqat quotes? 411 00:17:50,220 --> 00:17:52,310 Niy蓹 bunu ist蓹mir? 412 00:17:52,310 --> 00:17:52,810 Evet? 413 00:17:52,810 --> 00:17:53,685 >> Auditoriya: [i艧itilemez] 414 00:17:53,685 --> 00:17:56,695 415 00:17:56,695 --> 00:17:57,570 DAVID Malan: M蓹hz. 416 00:17:57,570 --> 00:17:59,653 M蓹n art谋q istifad蓹 edir蓹m, 莽眉nki yolda ikiqat quotes 417 00:17:59,653 --> 00:18:01,929 d蓹lil k蓹narda PHP funksiyas谋, 418 00:18:01,929 --> 00:18:03,470 M蓹n yaln谋z t蓹rc眉m蓹莽i 莽a艧d谋rmaq bil蓹r. 419 00:18:03,470 --> 00:18:04,860 Bu bilmir蓹m, bu birlikd蓹 getm蓹k yoxdur? 420 00:18:04,860 --> 00:18:05,735 Bu birlikd蓹 getm蓹k edirsiniz? 421 00:18:05,735 --> 00:18:06,810 Bu birlikd蓹 getm蓹k edirsiniz? 422 00:18:06,810 --> 00:18:08,070 Bel蓹 ki, m蓹n 蓹v蓹zin蓹 alternativ. 423 00:18:08,070 --> 00:18:11,784 >> V蓹 ya bu kimi bir 艧ey ola bil蓹r backslash quote v蓹 ya backslash quote. 424 00:18:11,784 --> 00:18:14,200 A莽谋臒谋, yaln谋z ba艧lay谋r 莽ox okunmaz v蓹 莽irkin almaq. 425 00:18:14,200 --> 00:18:16,790 Amma ki, nail olmaq olard谋 h蓹m莽inin eyni n蓹tic蓹. 426 00:18:16,790 --> 00:18:19,760 >> M蓹n 蓹g蓹r Bel蓹 ki, bu icra sor臒u 陌ndi n蓹 g枚rm蓹k ed蓹k. 427 00:18:19,760 --> 00:18:22,740 陌ndi v蓹 daha ir蓹li getm蓹k 眉莽眉n gedir蓹m PHP kodu, icra 莽ox olan 428 00:18:22,740 --> 00:18:24,610 siz oynamaq laz谋md谋r harada problemi, yeddi m眉蓹yy蓹n 429 00:18:24,610 --> 00:18:27,200 M蓹n 蓹v蓹zin蓹 PHP MyAdmin getm蓹k 眉莽眉n gedir蓹m. 430 00:18:27,200 --> 00:18:29,770 M蓹n 蓹l gedir蓹m SQL ni艧an谋 getm蓹k 眉莽眉n, 431 00:18:29,770 --> 00:18:31,580 v蓹 m蓹n蓹 interface zoom imkan. 432 00:18:31,580 --> 00:18:34,007 M蓹n yap谋艧d谋r谋b gedir蓹m M蓹n yaln谋z tipli 艧ey. 433 00:18:34,007 --> 00:18:36,090 V蓹 r蓹ng kodla艧d谋rma var 陌ndi bir az d蓹yi艧ib 434 00:18:36,090 --> 00:18:38,750 yaln谋z proqram format 莽眉nki h蓹r 艧eyi f蓹rqli bir az. 435 00:18:38,750 --> 00:18:41,960 Amma m蓹n etdik ki, g枚r眉rs眉n眉z M蓹n indi daxil, bildirib etdik. 436 00:18:41,960 --> 00:18:45,790 M蓹n verg眉l, sonra, belirledi臒iniz ayr谋lm谋艧 parenthesized siyah谋s谋 iki 437 00:18:45,790 --> 00:18:48,850 M蓹n daxil etm蓹k ist蓹yir蓹m sah蓹l蓹ri v蓹 sonra m蓹n s枚z眉n bildirib etdik d蓹y蓹rl蓹r 438 00:18:48,850 --> 00:18:51,510 ba艧qa paren izl蓹di v蓹 sonra iki d蓹y蓹rl蓹r 439 00:18:51,510 --> 00:18:53,520 M蓹n plug-in ist蓹yir蓹m, v蓹 陌ndi yax艧谋 t蓹dbir 眉莽眉n, 440 00:18:53,520 --> 00:18:55,010 M蓹n sonunda n枚qt蓹li verg眉l qoymaq laz谋md谋r. 441 00:18:55,010 --> 00:18:56,570 Bel蓹 ki, bu PHP deyil C. deyil. 442 00:18:56,570 --> 00:18:59,970 Bu art谋q SQL, v蓹 m蓹n onu sovu艧durmaq al谋ram ki, bu web-based interface daxil 443 00:18:59,970 --> 00:19:02,710 yaln谋z m蓹n蓹 imkan gedir, tezlikl蓹 m蓹n Go bas谋n kimi, 444 00:19:02,710 --> 00:19:08,060 bazas谋nda bu sor臒u icra CS50 IDE daxilind蓹 莽al谋艧谋r. 445 00:19:08,060 --> 00:19:09,470 >> Bel蓹 ki, bu yax艧谋d谋r. 446 00:19:09,470 --> 00:19:12,520 Dedi Notice bir s谋ra daxil, super s眉r蓹tli getdi 447 00:19:12,520 --> 00:19:15,190 0,0054 saniy蓹 m蓹lumatlar daxil etm蓹k 眉莽眉n. 448 00:19:15,190 --> 00:19:16,610 Bel蓹 ki, olduqca sa臒lam s蓹sl蓹nir. 449 00:19:16,610 --> 00:19:19,350 Bu, m蓹nim sor臒u bi莽imlendirildikten yaln谋z g枚rm蓹k 眉莽眉n m蓹nim 眉莽眉n 450 00:19:19,350 --> 00:19:21,730 r蓹ng kodlu versiyas谋 n枚v. 451 00:19:21,730 --> 00:19:24,540 Amma indi bas谋n 陌nsanlar, h蓹tta, ki, qeyd 452 00:19:24,540 --> 00:19:29,070 clutter bir 莽ox var, baxmayaraq ekran, m蓹nim masa iki sat谋r var. 453 00:19:29,070 --> 00:19:30,700 >> Bel蓹 ki, m蓹n蓹 ir蓹li getm蓹k v蓹 bir n蓹 ed蓹k. 454 00:19:30,700 --> 00:19:33,760 Bunun 蓹v蓹zind蓹, m蓹n蓹 imkan yenid蓹n SQL ni艧an谋 getm蓹k. 455 00:19:33,760 --> 00:19:40,723 V蓹 bu zaman m蓹n kimi bir 艧ey daxil olacaq Rob v蓹 onun ad谋 Rob Bowden olacaq. 456 00:19:40,723 --> 00:19:42,330 Bowden. 457 00:19:42,330 --> 00:19:44,040 Nin Saxla bas谋n ed蓹k. 458 00:19:44,040 --> 00:19:46,140 Ba臒谋艧lay谋n, daha gedin. 459 00:19:46,140 --> 00:19:48,890 >> Daha Browse bas谋n v蓹 indi iki sat谋r var g枚r眉rs眉n眉z. 460 00:19:48,890 --> 00:19:52,390 Bel蓹 ki, bu, yaln谋z bir yol daha m眉r蓹kk蓹bdir a莽谋lmas谋 Google Spreadsheets yolu 461 00:19:52,390 --> 00:19:54,010 v蓹 yaln谋z bir s眉tun bir s谋ra yazaraq. 462 00:19:54,010 --> 00:19:57,070 Lakin 蓹sas ki, n蓹 var biz indi sintaksis var 463 00:19:57,070 --> 00:20:00,220 olan kod yazmaq 眉莽眉n ki, n蓹tic蓹d蓹, biz, h蓹qiq蓹t蓹n bil蓹r 464 00:20:00,220 --> 00:20:01,790 bir v蓹 bunu. 465 00:20:01,790 --> 00:20:05,380 Ki, PHP d蓹st蓹kl蓹yir Xat谋rladaq super qlobal d蓹yi艧蓹nl蓹r. 466 00:20:05,380 --> 00:20:08,415 >> Dollar daxilind蓹 n蓹dir PHP GET underscore imzalamaq? 467 00:20:08,415 --> 00:20:10,290 Biz bir n蓹z蓹r etdi v蓹 ya iki sad蓹 n眉mun蓹l蓹ri. 468 00:20:10,290 --> 00:20:15,640 V蓹 PSet6, siz salam var geri Bu d蓹yi艧蓹n istifad蓹 dot PHP. 469 00:20:15,640 --> 00:20:17,870 N蓹 var gedir? 470 00:20:17,870 --> 00:20:21,015 Yoxsa bu n蓹dir? 471 00:20:21,015 --> 00:20:22,522 Bir az louder. 472 00:20:22,522 --> 00:20:23,790 >> Auditoriya: [i艧itilemez] 473 00:20:23,790 --> 00:20:25,030 >> DAVID Malan: Bu bir qar var serial谋n toxum olan 474 00:20:25,030 --> 00:20:27,714 Bir dey蓹r蓹k bir x眉lya yoldur 蓹sas d蓹y蓹r c眉t var array. 475 00:20:27,714 --> 00:20:28,880 V蓹 d眉ym蓹l蓹ri r蓹q蓹mli deyil. 476 00:20:28,880 --> 00:20:30,420 Onlar s枚z v蓹 ya strings ist蓹yirik. 477 00:20:30,420 --> 00:20:32,750 V蓹 x眉susi, n蓹 o 蓹sas d蓹y蓹r c眉t var? 478 00:20:32,750 --> 00:20:35,110 Onlar haradan g蓹lirs蓹n? 479 00:20:35,110 --> 00:20:35,620 Ba臒谋艧lay谋n? 480 00:20:35,620 --> 00:20:36,994 >> Auditoriya: [i艧itilemez] 481 00:20:36,994 --> 00:20:37,660 DAVID Malan: No? 482 00:20:37,660 --> 00:20:40,700 Harada o 蓹sas yoxdur d蓹y蓹r c眉t g蓹lir? 483 00:20:40,700 --> 00:20:42,490 Daha dem蓹k? 484 00:20:42,490 --> 00:20:44,610 Yen蓹? 485 00:20:44,610 --> 00:20:46,472 M蓹n yaln谋z bir e艧itm蓹 bir 艧ey Am? 486 00:20:46,472 --> 00:20:47,810 >> [G眉l眉艧] 487 00:20:47,810 --> 00:20:49,042 >> B蓹li, do臒ru? 488 00:20:49,042 --> 00:20:50,435 >> Auditoriya: [i艧itilemez] 489 00:20:50,435 --> 00:20:52,560 DAVID Malan: B蓹li, onlar sor臒u simli g蓹lir. 490 00:20:52,560 --> 00:20:55,380 Bel蓹 ki, zaman geri 蓹g蓹r Google il蓹 ifa etdiyiniz zaman 491 00:20:55,380 --> 00:20:59,600 v蓹 biz Google.com 莽izgi getdi etdik Axtar谋艧 sual i艧ar蓹si q, pi艧ik b蓹rab蓹rdir 492 00:20:59,600 --> 00:21:03,550 M蓹n hit 蓹g蓹r daxil edin v蓹 蓹g蓹r Google, PHP h蓹yata ke莽irilmi艧dir 493 00:21:03,550 --> 00:21:07,017 Google yaz谋rd谋 ki, PHP kodu dollar i艧ar蓹si etm蓹k imkan谋 var ki, 494 00:21:07,017 --> 00:21:11,600 olan daxilind蓹 almaq vur臒ulamaq 蓹sas adl谋 Q v蓹 d蓹y蓹ri 495 00:21:11,600 --> 00:21:17,680 sonra istifad蓹 ed蓹 bil蓹rsiniz ki adlanan cats il蓹 faktiki axtar谋艧 etm蓹k 眉莽眉n istifad蓹 olunur. 496 00:21:17,680 --> 00:21:20,860 >> Bel蓹 ki, 蓹slind蓹, m蓹n n蓹 gedir蓹m 陌ndi m蓹nim PHP kodu geri yoxdur 497 00:21:20,860 --> 00:21:23,140 Siz yen蓹 PSet7 da daha 莽ox laz谋md谋r ki,. 498 00:21:23,140 --> 00:21:25,440 V蓹 蓹v蓹zin蓹 sayede a臒谋r kodlu d蓹y蓹rl蓹r olan 499 00:21:25,440 --> 00:21:27,630 kimi g枚r眉nm眉r 莽ox dinamik haqqinda, 500 00:21:27,630 --> 00:21:30,680 M蓹n siz蓹 bir iltifat verm蓹k gedir蓹m faktiki code n蓹 ed蓹c蓹yini. 501 00:21:30,680 --> 00:21:32,854 Siz iki qoymaq olard谋 sual bu kimi olur. 502 00:21:32,854 --> 00:21:34,270 M蓹n istifad蓹莽i ad谋 n蓹 bilmir蓹m. 503 00:21:34,270 --> 00:21:37,390 M蓹n n蓹 bilmir蓹m ad谋, olacaq 504 00:21:37,390 --> 00:21:39,470 amma m蓹n bilmir蓹m dinamik onlar谋 almaq. 505 00:21:39,470 --> 00:21:43,420 >> Bel蓹 ki, biz indi yaz谋l谋 etdiyiniz code 蓹g蓹r Google servers 莽al谋艧an indeksi, 506 00:21:43,420 --> 00:21:46,940 v蓹 ya bu salam dot 蓹g蓹r PSet6 il蓹 g蓹lir PHP, 507 00:21:46,940 --> 00:21:48,650 M蓹n ke莽ir gedir蓹m sor臒u funksiyas谋 508 00:21:48,650 --> 00:21:51,450 yaln谋z printf kimi, iki d蓹lill蓹ri. 509 00:21:51,450 --> 00:21:57,120 Quote, GET, d谋rna臒谋 ba臒lamaq istifad蓹莽i ad谋, v蓹 quote, d谋rna臒谋 ba臒lamaq ad谋 almaq. 510 00:21:57,120 --> 00:22:00,720 陌ndi n蓹 hiss 眉mumi qurulu艧u burada. 511 00:22:00,720 --> 00:22:03,320 M蓹n sol var z蓹ng t蓹r蓹fd蓹n, 512 00:22:03,320 --> 00:22:05,480 bu funksiya PHP sor臒u 莽a臒谋r谋b. 513 00:22:05,480 --> 00:22:08,160 M蓹n h蓹l蓹 bir ilk var d蓹lil, m蓹tn yaln谋z bir string. 514 00:22:08,160 --> 00:22:11,000 >> Lakin m蓹tnin ki, simli edir SQL adl谋 dilind蓹 yaz谋lm谋艧. 515 00:22:11,000 --> 00:22:12,616 V蓹 s蓹mimi, bu b枚y眉k bir dil deyil. 516 00:22:12,616 --> 00:22:14,990 Biz yaln谋z dan谋艧maq olacaq Bu r蓹smi bu g眉n h蓹qiq蓹t蓹n. 517 00:22:14,990 --> 00:22:17,031 V蓹 sonra problem m眉蓹yy蓹n yeddi nisb蓹t蓹n var 518 00:22:17,031 --> 00:22:18,800 biz ist蓹yirik ne莽蓹 x眉susiyy蓹tl蓹ri leverage gedir. 519 00:22:18,800 --> 00:22:22,530 sual i艧ar蓹l蓹ri, baxmayaraq ki, plug dem蓹k ba艧qa d蓹y蓹rind蓹 burada d蓹y蓹ri v蓹 plug 520 00:22:22,530 --> 00:22:23,130 burada. 521 00:22:23,130 --> 00:22:26,010 V蓹 bildiri艧, m蓹n 莽谋xar谋lm谋艧d谋r n蓹 quote-- l蓹n蓹tl蓹m蓹k 蓹traf谋nda 522 00:22:26,010 --> 00:22:30,470 Kotirovka 蓹traf谋nda pseudocode Bu d蓹f蓹 olur. 523 00:22:30,470 --> 00:22:34,930 M蓹n kotirovka 莽谋xar谋lm谋艧d谋r sonra sual i艧ar蓹si 蓹traf谋nda i艧ar蓹l蓹ri 524 00:22:34,930 --> 00:22:36,410 Ba臒谋艧lay谋n, bu d蓹f蓹 蓹traf谋nda. 525 00:22:36,410 --> 00:22:38,870 >> Bel蓹 ki, n蓹 bu bar蓹d蓹 g枚z蓹l sual i艧ar蓹si x眉susiyy蓹t 526 00:22:38,870 --> 00:22:42,830 PHP, Ruby d蓹st蓹k 莽al谋艧谋r v蓹 Python v蓹 dig蓹r dill蓹rd蓹, 527 00:22:42,830 --> 00:22:45,730 bu yaln谋z b蓹zi plug dem蓹kdir burada qiym蓹tl蓹ndiririk v蓹 n蓹 bilirik? 528 00:22:45,730 --> 00:22:48,300 Siz istifad蓹 edilm蓹si anlamaq bir quotes v蓹 ya c眉t quotes. 529 00:22:48,300 --> 00:22:50,966 O m蓹ni narahat etm蓹yin intellektual maraqs谋z 蓹trafl谋. 530 00:22:50,966 --> 00:22:53,780 Lakin, 蓹min do臒ru etm蓹k M蓹nim code n蓹tic蓹d蓹 ki, 531 00:22:53,780 --> 00:22:57,010 蓹m蓹liyyat v蓹 t蓹hl眉k蓹siz olan uzun 蓹vv蓹l bir m蓹nas谋 var. 532 00:22:57,010 --> 00:23:00,460 >> 陌ndi ne莽蓹 arqumentl蓹r yaln谋z, c蓹mi ayd谋n, sor臒u funksiyas谋 alaraq edir? 533 00:23:00,460 --> 00:23:05,240 534 00:23:05,240 --> 00:23:07,581 H蓹r k蓹s daha iki s蓹s ist蓹yirsiniz? 535 00:23:07,581 --> 00:23:08,080 Three? 536 00:23:08,080 --> 00:23:10,001 茝lb蓹tt蓹, niy蓹? 537 00:23:10,001 --> 00:23:10,920 Niy蓹 眉莽? 538 00:23:10,920 --> 00:23:12,305 >> Auditoriya: [i艧itilemez] 539 00:23:12,305 --> 00:23:13,180 DAVID Malan: M蓹hz. 540 00:23:13,180 --> 00:23:14,610 birinci hiss蓹si simli edir. 541 00:23:14,610 --> 00:23:18,640 陌kinci arqument dollar 蓹lam蓹tidir GET istifad蓹莽i ad谋 bracket vur臒ulay谋r. 542 00:23:18,640 --> 00:23:21,950 V蓹 眉莽眉nc眉 arqument Eyni 艧ey, ancaq ad谋. 543 00:23:21,950 --> 00:23:24,590 陌ndi, ba艧qa s枚zl蓹, bel蓹 ki, M蓹n bir web formu olsa 544 00:23:24,590 --> 00:23:27,149 ki, m蓹tn sah蓹l蓹ri idi istifad蓹莽i ad谋 眉莽眉n bir, 545 00:23:27,149 --> 00:23:29,690 onun 眉莽眉n bir v蓹 ya onun ad谋, yaln谋z kimi bir veb g枚rm蓹k olard谋 546 00:23:29,690 --> 00:23:32,120 Siz qeydiyyatdan zaman bir bax, bu q眉dr蓹ti 547 00:23:32,120 --> 00:23:35,450 geri sonunda kodunu olmaq h蓹qiq蓹t蓹n durub indi yoxdur 548 00:23:35,450 --> 00:23:37,220 bazas谋nda. 549 00:23:37,220 --> 00:23:40,870 >> 陌ndi 蓹ksin蓹, s眉r蓹tli ir蓹li ed蓹k. 550 00:23:40,870 --> 00:23:43,840 Bir istifad蓹莽i indi d眉艧眉n蓹k giri艧 v蓹 ist蓹diyiniz 551 00:23:43,840 --> 00:23:48,860 olub-olmad谋臒谋n谋 yoxlay谋r PHP kodu yazmaq yaln谋z daxil olan 艧蓹xs 552 00:23:48,860 --> 00:23:52,250 bir istifad蓹莽i h蓹qiq蓹t蓹n, siz bil蓹r olduqca sad蓹 sintaksis istifad蓹 edin. 553 00:23:52,250 --> 00:23:55,832 Siz dey蓹k se莽in dem蓹k olar star h蓹r 艧ey dem蓹kdir harada, ulduz. 554 00:23:55,832 --> 00:23:57,540 M蓹n n蓹 bilmir蓹m m蓹n ist蓹yir蓹m, bel蓹 ki, yaln谋z m蓹n蓹 verm蓹k 555 00:23:57,540 --> 00:24:01,585 masa b眉t眉n s眉tunlar users harada adlan谋r v蓹 bu g枚z蓹l. 556 00:24:01,585 --> 00:24:03,710 Select n蓹 d蓹st蓹kl蓹yir olan bir x蓹b蓹r adl谋 557 00:24:03,710 --> 00:24:06,630 ist蓹diyiniz se莽m蓹 yolu kimi. 558 00:24:06,630 --> 00:24:10,590 Harada istifad蓹莽i ad谋 b蓹rab蓹rdir quote, d谋rna臒谋 ba臒lamaq Malan. 559 00:24:10,590 --> 00:24:13,680 Bel蓹 ki, burada da m蓹n 蓹laq蓹dar sonra d蓹lil daxili 560 00:24:13,680 --> 00:24:16,110 bir PHP funksiyas谋, SQL kodu bir line. 561 00:24:16,110 --> 00:24:18,680 V蓹 SQL kodu bu vaxt sanki gedir 562 00:24:18,680 --> 00:24:21,790 quote 眉莽眉n axtar谋艧, Malan d谋rna臒谋 ba臒lamaq. 563 00:24:21,790 --> 00:24:24,420 >> 陌ndi ki, b眉t眉n faydal谋 deyil m蓹n ki ke莽m蓹k gedir蓹m 564 00:24:24,420 --> 00:24:28,650 v蓹 m蓹n 眉z qoymaq gedir蓹m Brady bu tip, v蓹 getm蓹k 565 00:24:28,650 --> 00:24:30,990 v蓹 plug-in yerin蓹 Burada bir sual i艧ar蓹si. 566 00:24:30,990 --> 00:24:33,290 Bel蓹 ki, yaln谋z ayd谋n olmaq 眉莽眉n n蓹 m蓹nim ikinci d蓹lil olmal谋d谋r 567 00:24:33,290 --> 00:24:37,480 kims蓹 yaln谋z v蓹 I daxil edir 蓹g蓹r o, h蓹qiq蓹t蓹n, 蓹g蓹r check ist蓹diyiniz 568 00:24:37,480 --> 00:24:39,265 Bir istifad蓹莽i? 569 00:24:39,265 --> 00:24:40,140 Auditoriya: [i艧itilemez] 570 00:24:40,140 --> 00:24:40,890 DAVID Malan: B蓹li. 571 00:24:40,890 --> 00:24:44,120 M蓹n dollar i艧ar蓹si vur臒ulamaq e艧itm蓹k Quote, d谋rna臒谋 ba臒lamaq istifad蓹莽i ad谋 al谋n. 572 00:24:44,120 --> 00:24:50,040 V蓹 m蓹n蓹 qay谋tmal谋d谋rlar M蓹nim bazas谋nda sat谋r h蓹r hans谋 573 00:24:50,040 --> 00:24:51,986 ki Malan bir istifad蓹莽i ad谋 var. 574 00:24:51,986 --> 00:24:54,860 陌ndi 眉mid edir蓹m ki, m蓹n geri almaq 眉莽眉n gedir蓹m s谋f谋r Malan burada he莽 蓹g蓹r, 575 00:24:54,860 --> 00:24:56,290 v蓹 ya bir O varsa. 576 00:24:56,290 --> 00:24:59,026 M蓹n geri almaq laz谋md谋r iki v蓹 ya 眉莽 v蓹 ya d枚rd. 577 00:24:59,026 --> 00:24:59,526 Niy蓹? 578 00:24:59,526 --> 00:25:00,220 >> Auditoriya: [i艧itilemez] 579 00:25:00,220 --> 00:25:01,120 >> DAVID MALAN: M蓹n, unikal dedi? 580 00:25:01,120 --> 00:25:01,750 Simple s蓹b蓹b. 581 00:25:01,750 --> 00:25:04,030 M蓹n dedim, 莽眉nki bu var yaln谋z m蓹ntiqi, unikal, 582 00:25:04,030 --> 00:25:07,940 Yaln谋z s谋f谋r v蓹 ya bir Malans ola bil蓹r bu veril蓹nl蓹r bazas谋 masa. 583 00:25:07,940 --> 00:25:10,965 陌ndi g枚rd眉m k蓹nara, yaln谋z bel蓹 kimi Bu, m蓹n istifad蓹 saxlamaq, baxmayaraq ki GET 584 00:25:10,965 --> 00:25:14,350 v蓹 PSet6 yaln谋z istifad蓹 olsa da , 茝lb蓹tt蓹 ki, POST ola bil蓹r GET. 585 00:25:14,350 --> 00:25:17,212 V蓹 Post ba艧qa Xat谋rladaq ki, m蓹lumat t蓹qdim texnika 586 00:25:17,212 --> 00:25:19,170 bir formada, lakin URL g枚rs蓹nmir. 587 00:25:19,170 --> 00:25:22,690 Bu, 蓹lb蓹tt蓹 ki, bir az daha t蓹hl眉k蓹siz istifad蓹莽i ad谋 v蓹 parol kimi 艧eyl蓹r, 588 00:25:22,690 --> 00:25:25,210 olan PSet7, 蓹slind蓹, i艧tirak ed蓹c蓹k. 589 00:25:25,210 --> 00:25:28,130 >> Bel蓹 ki, PHP bunu ed蓹k MyAdmin v蓹 n蓹 g枚rm蓹k. 590 00:25:28,130 --> 00:25:30,020 M蓹n MySQL ni艧an谋 getm蓹k 眉莽眉n gedir蓹m. 591 00:25:30,020 --> 00:25:34,450 V蓹 ki, default d蓹y蓹ri, qeyd PHP MyAdmin, yaln谋z faydal谋 olmaq 眉莽眉n c蓹hd 592 00:25:34,450 --> 00:25:37,050 harada istifad蓹莽il蓹r etibar蓹n ulduz se莽m蓹kdir. 593 00:25:37,050 --> 00:25:39,430 Yax艧谋, bir, bel蓹 ki, h蓹mi艧蓹 do臒ru bu effektiv silly var 594 00:25:39,430 --> 00:25:40,400 yaln谋z h蓹r 艧eyi se莽in. 595 00:25:40,400 --> 00:25:42,691 Amma bir az gedir蓹m daha x谋rda莽谋 v蓹 蓹l 596 00:25:42,691 --> 00:25:45,920 istifad蓹莽il蓹r SELECT ulduz yaz谋n. 597 00:25:45,920 --> 00:25:48,294 >> 陌ndi texniki, siz masa ad谋n谋 sitat. 598 00:25:48,294 --> 00:25:50,460 Bu laz谋md谋r ki, nadir, lakin bu deyil qeyd 599 00:25:50,460 --> 00:25:52,240 AB艦 klaviatura sizin normal quotes. 600 00:25:52,240 --> 00:25:54,760 Bu qondarma backtick, olan sol 眉st t蓹r蓹fd蓹n 眉mumiyy蓹tl蓹 601 00:25:54,760 --> 00:25:56,000 klaviatura k眉nc. 602 00:25:56,000 --> 00:25:58,500 Ancaq laz谋md谋r ki, nadir var h蓹qiq蓹t蓹n ki, narahat etm蓹k laz谋md谋r, 603 00:25:58,500 --> 00:25:59,950 m蓹n yaln谋z h蓹r halda onlar谋 buraxmaq laz谋md谋r. 604 00:25:59,950 --> 00:26:02,280 Bel蓹 ki, indi m蓹n蓹 ir蓹li getm蓹k v蓹 getm蓹k hit imkan. 605 00:26:02,280 --> 00:26:06,616 Ne莽蓹-ne莽蓹 sat谋r I almaq laz谋md谋r geri M蓹n istifad蓹莽il蓹r ulduz se莽in? 606 00:26:06,616 --> 00:26:08,407 >> Auditoriya: [i艧itilemez] 607 00:26:08,407 --> 00:26:09,990 DAVID Malan: 蓹min sat谋r say谋. 608 00:26:09,990 --> 00:26:12,390 Amma bu ne莽蓹 陌ndi konkret hekay蓹? 609 00:26:12,390 --> 00:26:14,640 Iki, var idi, 莽眉nki M蓹n蓹 v蓹 Rob var idi. 610 00:26:14,640 --> 00:26:19,370 M蓹n Go bas谋n Bel蓹 ki, m蓹n vizual ki, g枚r蓹c蓹ksiniz M蓹n, h蓹qiq蓹t蓹n, geri iki sat谋r kazan谋lm谋艧 etdik. 611 00:26:19,370 --> 00:26:22,060 Clutter bir 莽ox var ekran, amma yaln谋z iki sat谋r oldu. 612 00:26:22,060 --> 00:26:28,580 M蓹n bir daha bunu 蓹g蓹r 蓹ksin蓹, n蓹 Istifad蓹莽il蓹r, harada istifad蓹莽i ad谋 FROM SELECT star 613 00:26:28,580 --> 00:26:31,840 quote, d谋rna臒谋 ba臒lamaq b蓹rab蓹rdir Malan, indi, Go bas谋n 蓹g蓹r 614 00:26:31,840 --> 00:26:33,970 M蓹n yaln谋z geri bir s谋ra almaq 眉莽眉n gedir蓹m. 615 00:26:33,970 --> 00:26:36,499 V蓹 n蓹hay蓹t, m蓹n 蓹g蓹r bu kimi bir 艧ey, g眉man 616 00:26:36,499 --> 00:26:38,290 M蓹n qay臒谋 yoxdur ki, h蓹r 艧ey 蓹ld蓹, 617 00:26:38,290 --> 00:26:41,020 indi c眉r m蓹nas谋z, yaln谋z iki s眉tun var, 莽眉nki. 618 00:26:41,020 --> 00:26:43,103 M蓹n se莽ilm蓹si al谋ram kimi deyil m蓹lumatlar谋n b枚y眉k m蓹bl蓹臒i. 619 00:26:43,103 --> 00:26:46,720 M蓹n ir蓹li getm蓹k v蓹 g眉man FROM ad谋 se莽in yoxdur 620 00:26:46,720 --> 00:26:51,990 istifad蓹莽i ad谋 Malan b蓹rab蓹rdir istifad蓹莽il蓹r, n蓹 vicdanla SQL haqq谋nda g枚z蓹l, 621 00:26:51,990 --> 00:26:54,290 Bu, h蓹qiq蓹t蓹n, yaln谋z deyil ki, Siz n蓹 dem蓹k. 622 00:26:54,290 --> 00:26:57,550 Bu olduqca q谋sa, lakin siz s枚z眉n yaln谋z ist蓹diyiniz n蓹 dem蓹k. 623 00:26:57,550 --> 00:27:01,130 Istifad蓹莽il蓹r harada se莽in ad谋 istifad蓹莽i ad谋 Malan b蓹rab蓹rdir. 624 00:27:01,130 --> 00:27:03,440 V蓹 bu, h蓹qiq蓹t蓹n ki a莽谋q deyil. 625 00:27:03,440 --> 00:27:08,410 Bel蓹 ki, indi m蓹n Go ne莽蓹 hit 蓹g蓹r sat谋r M蓹n geri almaq 眉莽眉n gedir蓹m? 626 00:27:08,410 --> 00:27:10,770 One, yaln谋z 莽眉nki Malan, in艧allah. 627 00:27:10,770 --> 00:27:13,100 V蓹 ya s谋f谋r o deyil, 蓹g蓹r var, lakin maksimum biridir. 628 00:27:13,100 --> 00:27:17,610 >> M蓹n geri ne莽蓹 s眉tun olacaq? 629 00:27:17,610 --> 00:27:18,450 Ne莽蓹 s眉tun? 630 00:27:18,450 --> 00:27:20,658 Bu d蓹f蓹 m蓹n yaln谋z gedir蓹m M蓹n 莽眉nki bir almaq 631 00:27:20,658 --> 00:27:22,380 h蓹r 艧ey olan ulduz se莽in. 632 00:27:22,380 --> 00:27:27,900 陌ndi yaln谋z ad谋n谋 se莽ilm蓹si, m蓹n al谋ram yaln谋z bir s眉tun v蓹 bir s谋ra geri almaq. 633 00:27:27,900 --> 00:27:31,730 V蓹 bu, m眉vafiq sort g枚r眉n眉r g眉l眉nc, yaln谋z axtar谋r super 634 00:27:31,730 --> 00:27:33,060 bu kimi ki莽ik. 635 00:27:33,060 --> 00:27:34,290 Bel蓹 ki, h蓹qiq蓹t蓹n n蓹l蓹r olur? 636 00:27:34,290 --> 00:27:36,890 Bir SQL icra zaman sor臒u se莽in istifad蓹 637 00:27:36,890 --> 00:27:38,700 n蓹 al谋r谋q geri bazas谋 638 00:27:38,700 --> 00:27:42,970 M眉v蓹qq蓹ti masa kimi sat谋r v蓹 s眉tunlar il蓹, b蓹lk蓹, 639 00:27:42,970 --> 00:27:46,260 lakin bir 艧ey buraxmaq ki, h蓹qiq蓹t蓹n, sizin t蓹r蓹find蓹n se莽ilmi艧 deyil. 640 00:27:46,260 --> 00:27:49,010 Bel蓹 ki, kims蓹 b枚y眉k bir olsayd谋 kimi b眉t眉n t蓹l蓹b蓹l蓹r tablo 641 00:27:49,010 --> 00:27:51,610 bir 眉莽眉n qeydiyyatdan t蓹l蓹b蓹 qrupu, dem蓹k, 642 00:27:51,610 --> 00:27:55,097 M蓹n蓹 var birinci b眉t眉n verm蓹k Bizim t蓹l蓹b蓹 qrupu 眉莽眉n qeydiyyatdan n蓹 643 00:27:55,097 --> 00:27:56,930 sizin h蓹mkar谋 t蓹l蓹b蓹 qrupu ed蓹 bil蓹r 644 00:27:56,930 --> 00:27:58,430 onlar yaln谋z 蓹l ed蓹 bil蓹r ki, b眉t眉n tablo. 645 00:27:58,430 --> 00:27:59,742 Bu se莽in ulduz dey蓹n kimi. 646 00:27:59,742 --> 00:28:02,200 V蓹 蓹g蓹r bir az annoying var Yaln谋z birinci ist蓹di. 647 00:28:02,200 --> 00:28:05,640 V蓹 bel蓹 ki, 蓹v蓹zin蓹, ifad蓹 ed蓹r蓹k, veril蓹nl蓹r bazas谋 masa se莽in star 648 00:28:05,640 --> 00:28:08,470 burada il b蓹rab蓹rdir quote, d谋rna臒谋 ba臒lamaq birinci, 649 00:28:08,470 --> 00:28:10,810 Bu sizin dost sanki var t蓹l蓹b蓹 qrup 650 00:28:10,810 --> 00:28:13,770 s枚z眉n qeyd v蓹 kopyalanamaz yaln谋z birinci sat谋r, 651 00:28:13,770 --> 00:28:16,780 yeni Google onlar谋 yap谋艧d谋r谋l谋r Tablo v蓹 ya Excel fayl谋 652 00:28:16,780 --> 00:28:18,860 v蓹 geri t蓹hvil yaln谋z n蓹tic蓹l蓹n蓹n fayl. 653 00:28:18,860 --> 00:28:21,710 Ki, gedir ki, b眉t眉n var konseptual burada. 654 00:28:21,710 --> 00:28:23,920 >> Bel蓹 ki, sonunda, biz n蓹 ed蓹 bil蓹r b蓹zi olduqca fancy 艧eyi 655 00:28:23,920 --> 00:28:26,560 istifad蓹莽i kimi 艧eyl蓹r saxlan谋lmas谋 il蓹 v蓹 parol v蓹 s. 656 00:28:26,560 --> 00:28:30,310 Lakin, bu 莽谋x谋r, biz bunu etm蓹liyik f蓹rqli bu bir az. 657 00:28:30,310 --> 00:28:34,750 Bu, yaln谋z ki, smart deyil bir istifad蓹莽i ad谋 v蓹 parol saxlamay谋n. 658 00:28:34,750 --> 00:28:37,790 茝vv蓹ll蓹r kims蓹, m蓹n hesab edir蓹m burada, bir ID ir蓹li s眉rd眉. 659 00:28:37,790 --> 00:28:40,787 陌ndi ID kimi ola bil蓹r Harvard ID v蓹 ya Yale nin Net ID, 660 00:28:40,787 --> 00:28:42,870 lakin h蓹tta sad蓹 ola bil蓹r Bizim veril蓹nl蓹r bazas谋 halda. 661 00:28:42,870 --> 00:28:45,120 艦眉bh蓹siz ki, 眉mumi halda ba艧qa s眉tun var. 662 00:28:45,120 --> 00:28:46,953 M蓹n getm蓹k 眉莽眉n gedir蓹m ir蓹li v蓹 masa redakt蓹. 663 00:28:46,953 --> 00:28:49,521 V蓹 il蓹 蓹traf谋nda oynamaq 蓹g蓹r PSet7 bu interface, 664 00:28:49,521 --> 00:28:51,770 Siz kontrol ed蓹 bil蓹rsiniz ki, g枚r眉rs眉n眉z Burada bu d眉ym蓹sini bas谋n v蓹 蓹lav蓹 665 00:28:51,770 --> 00:28:53,750 masa ba艧谋nda sah蓹sind蓹. 666 00:28:53,750 --> 00:28:56,720 M蓹n Go bas谋n indi 蓹g蓹r, gedir M蓹n蓹 o formalar谋ndan biri verm蓹k 667 00:28:56,720 --> 00:28:57,600 茝vv蓹ll蓹r. 668 00:28:57,600 --> 00:29:00,170 M蓹n ID adl谋 sah蓹sind蓹 蓹lav蓹 etm蓹k 眉莽眉n gedir蓹m. 669 00:29:00,170 --> 00:29:03,070 V蓹 m蓹n say谋sal type etm蓹k 眉莽眉n gedir蓹m. 670 00:29:03,070 --> 00:29:05,362 >> M蓹n b眉t眉n d蓹st蓹 var bir Numerics 眉莽眉n qiym蓹tl蓹ndirir. 671 00:29:05,362 --> 00:29:08,677 M蓹n yaln谋z bir int se莽m蓹k gedir蓹m v蓹 disparate 枚l莽眉l蓹ri bar蓹d蓹 narahat olmay谋n. 672 00:29:08,677 --> 00:29:10,510 M蓹n m眉蓹yy蓹n etm蓹k yoxdur bir uzunlu臒u v蓹 ya d蓹y蓹ri, 673 00:29:10,510 --> 00:29:13,710 bu olacaq, 莽眉nki 32 bit n蓹 olursa olsun. 674 00:29:13,710 --> 00:29:16,070 Features, biz 蓹vv蓹l g枚rm蓹dim. 675 00:29:16,070 --> 00:29:18,410 Bu h蓹r hans谋 bir h蓹r hans谋 bir maraq menyu variantlar谋 bu d蓹f蓹? 676 00:29:18,410 --> 00:29:21,890 677 00:29:21,890 --> 00:29:23,745 Bir INT 眉莽眉n? 678 00:29:23,745 --> 00:29:24,620 N蓹 t蓹klif etdi? 679 00:29:24,620 --> 00:29:27,350 680 00:29:27,350 --> 00:29:28,445 Yox? 681 00:29:28,445 --> 00:29:29,570 Bu h蓹r hans谋 bir m蓹nada ed蓹 bil蓹r蓹m? 682 00:29:29,570 --> 00:29:30,536 B蓹li. 683 00:29:30,536 --> 00:29:31,900 Sa臒, imzas谋z, evet? 684 00:29:31,900 --> 00:29:35,930 >> Gedirik, 蓹g蓹r 脺mumiyy蓹tl蓹 verm蓹k h蓹r k蓹s bir unikal n枚mr蓹sini olan 685 00:29:35,930 --> 00:29:38,200 Bu hekay蓹 harada gedir, M蓹n, h蓹qiq蓹t蓹n, yaln谋z ist蓹yir蓹m 686 00:29:38,200 --> 00:29:41,919 Bir 艧蓹xs s谋f谋r kimi say谋 眉莽眉n v蓹 bir v蓹 iki, 眉莽 v蓹 d枚rd. 687 00:29:41,919 --> 00:29:43,710 M蓹n m蓹艧臒ul ehtiyac yoxdur m蓹nfi n枚mr蓹l蓹ri il蓹. 688 00:29:43,710 --> 00:29:45,210 Bu, sad蓹c蓹 h蓹dsiz m眉r蓹kk蓹b kimi g枚r眉n眉r. 689 00:29:45,210 --> 00:29:48,470 M蓹n d枚rd milyard m眉mk眉n d蓹y蓹rl蓹r ist蓹yir蓹m, K枚rp眉 milyard m眉mk眉n d蓹y蓹rl蓹r, 690 00:29:48,470 --> 00:29:50,699 m蓹n yaln谋z iki d蓹f蓹 M蓹nim INT g眉c眉. 691 00:29:50,699 --> 00:29:53,490 Bir k蓹nara, siz aid ist蓹yirsinizs蓹 As Facebook kimi bu 艧ey, 692 00:29:53,490 --> 00:29:56,190 geri m蓹nim g眉n zaman n枚v Facebook ilk 莽谋xd谋 693 00:29:56,190 --> 00:29:59,510 M蓹n onlar n蓹 iman onlar谋n MySQL veril蓹nl蓹r bazas谋 istifad蓹 694 00:29:59,510 --> 00:30:02,856 bir istifad蓹莽i saxlamaq 眉莽眉n identifikator, yaln谋z bir INT idi. 695 00:30:02,856 --> 00:30:05,230 Amma 蓹lb蓹tt蓹, bir 莽ox var D眉nyada real insanlar谋n. 696 00:30:05,230 --> 00:30:07,438 Saxta Facebook bir 莽ox var d眉nyada d眉艧眉r. 697 00:30:07,438 --> 00:30:11,701 V蓹 bel蓹 n蓹hay蓹t, Facebook da艧d谋 bir INT 枚l莽眉s眉, d枚rd milyard 698 00:30:11,701 --> 00:30:12,200 d蓹y蓹ri. 699 00:30:12,200 --> 00:30:15,032 Siz niy蓹 baxsaq olan 蓹traf谋nda v蓹 web var 700 00:30:15,032 --> 00:30:16,740 ki, siz dey蓹 bil蓹r n蓹 Sizin unikal ID edir. 701 00:30:16,740 --> 00:30:19,781 V蓹 siz istifad蓹莽i ad谋 se莽di he莽 蓹g蓹r Facebook, sizin unikal ID g枚r蓹c蓹ksiniz. 702 00:30:19,781 --> 00:30:23,080 M蓹n profile dot PHP hesab sual i艧ar蓹si ID bir 艧ey b蓹rab蓹rdir. 703 00:30:23,080 --> 00:30:27,210 Ki, indi b枚y眉k bir kimi bir 艧eydir INT, v蓹 ya uzun uzun siz bir, 704 00:30:27,210 --> 00:30:29,700 64-bit d蓹y蓹ri olan v蓹 ya m眉qayis蓹 bir 艧ey. 705 00:30:29,700 --> 00:30:33,620 >> Bel蓹 ki, h蓹tta real d眉nyada bu n蓹 m蓹s蓹l蓹l蓹r n蓹tic蓹d蓹 b蓹z蓹n 蓹h蓹miyy蓹tli. 706 00:30:33,620 --> 00:30:37,600 M蓹n 蓹g蓹r o, burada 莽谋x谋r m蓹nim istifad蓹莽il蓹r unikal ID h蓹r verilm蓹si 707 00:30:37,600 --> 00:30:41,750 M蓹n super a莽谋q olmaq ist蓹yir蓹m v蓹 minimal bu sah蓹d蓹 unikal. 708 00:30:41,750 --> 00:30:44,750 Bir var h蓹yata Amma bu 莽谋x谋r nomenklaturas谋 g眉n par莽a 莽ox 709 00:30:44,750 --> 00:30:46,470 ki, ilkin 蓹sas var. 710 00:30:46,470 --> 00:30:49,800 Bir veril蓹nl蓹r bazas谋 dizayn edirsinizs蓹 masa v蓹 蓹vv蓹lc蓹d蓹n bilm蓹k 711 00:30:49,800 --> 00:30:55,580 ki, masa s眉tun biri ki, v蓹 unikal sat谋r m眉蓹yy蓹n ed蓹c蓹k laz谋md谋r 712 00:30:55,580 --> 00:30:58,500 c蓹dv蓹ld蓹, ist蓹diyiniz Onu m眉蓹yy蓹n v蓹 veril蓹nl蓹r bazas谋 dem蓹k, 713 00:30:58,500 --> 00:31:00,250 Bu m蓹nim 蓹sas a莽ard谋r. 714 00:31:00,250 --> 00:31:02,110 Dublikatlar谋 ola bil蓹r dig蓹r sah蓹l蓹rd蓹, 715 00:31:02,110 --> 00:31:06,330 amma bu ki, veril蓹nl蓹r bazas谋 deyir蓹m m蓹nim 蓹sas deyil, 蓹n m眉h眉m sah蓹, 716 00:31:06,330 --> 00:31:08,420 ki, unikal olmaq 眉莽眉n t蓹min edir. 717 00:31:08,420 --> 00:31:09,660 >> 陌ndi bu laz谋ms谋z g枚r眉n眉r. 718 00:31:09,660 --> 00:31:13,830 陌ndi ki, biz t蓹klif edir蓹m burada Saxla t谋klayarak 蓹lav蓹, 719 00:31:13,830 --> 00:31:17,210 sah蓹sind蓹 脟a臒谋r谋艧 v蓹 m蓹n gedir蓹m ir蓹li getm蓹k v蓹 AI bas谋n, 720 00:31:17,210 --> 00:31:19,720 biz geri g蓹lm蓹k laz谋md谋r bir anda edin ki. 721 00:31:19,720 --> 00:31:22,540 陌ndi ki, t蓹klif edir蓹m m蓹nim masa bu kimi g枚r眉n眉r. 722 00:31:22,540 --> 00:31:26,305 M蓹n ID adl谋 INT sah蓹sind蓹 var 陌stifad蓹莽i ad谋 adl谋 CHAR sah蓹sind蓹, 723 00:31:26,305 --> 00:31:31,100 bir VARCHAR ad谋n谋 sah蓹, lakin ID, Bu 蓹sas v蓹 buna g枚r蓹 d蓹 unikal varsa, 724 00:31:31,100 --> 00:31:33,760 niy蓹 yaln谋z s蓹rf etdi vaxt n蓹 t蓹qdim 725 00:31:33,760 --> 00:31:39,140 s蓹m蓹r蓹li unikal bir ikinci sah蓹sind蓹 bir INT ID adlan谋r? 726 00:31:39,140 --> 00:31:41,980 >> Istifad蓹莽i ad谋, geri idi art谋q unikal dedik. 727 00:31:41,980 --> 00:31:45,350 Bel蓹 ki, yaln谋z m蓹ntiqi, ehtiyac yoxdur s蓹b蓹bd蓹n h蓹r hans谋 bir m蓹lumat bazas谋 t蓹cr眉b蓹 728 00:31:45,350 --> 00:31:47,570 , niy蓹 bu yolu M蓹n t蓹qdim ola bil蓹r 729 00:31:47,570 --> 00:31:50,065 el蓹c蓹 d蓹 m蓹nim unikal identifikator kimi INT? 730 00:31:50,065 --> 00:31:52,740 731 00:31:52,740 --> 00:31:53,930 艦eyl蓹rdir daha n蓹 dem蓹k var? 732 00:31:53,930 --> 00:31:55,580 >> Auditoriya: [i艧itilemez] 733 00:31:55,580 --> 00:31:59,534 >> DAVID Malan: Random giri艧 asand谋r, niy蓹? 734 00:31:59,534 --> 00:32:00,410 >> Auditoriya: [i艧itilemez] 735 00:32:00,410 --> 00:32:02,367 DAVID Malan: B蓹li, bu yaln谋z n枚mr蓹l蓹ri daxil. 736 00:32:02,367 --> 00:32:04,750 Bel蓹 ki, 蓹g蓹r siz h蓹qiq蓹t蓹n bu hesab bir masa, bir s谋ra kimi, 737 00:32:04,750 --> 00:32:07,690 indi unikal tan谋mlay谋c谋lar谋 var M蓹n 蓹traf谋nda jump bil蓹r. 738 00:32:07,690 --> 00:32:11,520 V蓹 daha yax艧谋 h蓹l蓹 ki, n蓹 q蓹d蓹r b枚y眉k bir INT yenid蓹n olacaq? 739 00:32:11,520 --> 00:32:14,450 740 00:32:14,450 --> 00:32:15,800 32 bit v蓹 ya d枚rd bytes. 741 00:32:15,800 --> 00:32:17,750 >> Nec蓹 b枚y眉k m蓹nim istifad蓹莽i ad谋 olacaq? 742 00:32:17,750 --> 00:32:20,310 743 00:32:20,310 --> 00:32:21,990 Maksimum? 744 00:32:21,990 --> 00:32:22,880 16 bytes. 745 00:32:22,880 --> 00:32:26,080 >> Bel蓹 ki, h蓹qiq蓹t蓹n, haqq谋nda qay臒谋 蓹g蓹r Sizin kodu performans, 746 00:32:26,080 --> 00:32:31,390 Siz ist蓹rdiniz geri pset5 d眉艧眉nm蓹k d枚rd byte d蓹y蓹ri v蓹 ya 16 axtarmaq 眉莽眉n 747 00:32:31,390 --> 00:32:32,240 byte d蓹y蓹ri, sa臒? 748 00:32:32,240 --> 00:32:33,810 Bu, h蓹qiq蓹t蓹n kimi sad蓹 deyil. 749 00:32:33,810 --> 00:32:38,060 Siz 莽ox i艧 kimi d枚rd d蓹f蓹 etm蓹k laz谋md谋r o, 莽眉nki istifad蓹莽i 眉莽眉n axtar谋艧 750 00:32:38,060 --> 00:32:38,830 16 bytes var. 751 00:32:38,830 --> 00:32:41,320 Bel蓹 ki, s枚z眉n var olmaq 眉莽眉n b眉t眉n 16 bayt m眉qayis蓹 752 00:32:41,320 --> 00:32:43,140 b蓹li 蓹min, m蓹n ist蓹yir蓹m istifad蓹莽i ad谋 var. 753 00:32:43,140 --> 00:32:46,610 Bir INT 眉莽眉n, siz is蓹 yaln谋z d枚rd bayt il蓹 bunu. 754 00:32:46,610 --> 00:32:49,212 >> V蓹 bir k蓹nara ed蓹nl蓹r 眉莽眉n kimi komp眉ter hardware maraql谋, 755 00:32:49,212 --> 00:32:52,420 bu kimi bir 艧ey uy臒un 莽谋x谋r bir INT v蓹 ya bir 艧ey bir 32-bit d蓹y蓹ri 756 00:32:52,420 --> 00:32:55,330 bir komp眉ter bir register adl谋 Bu super dem蓹kdir CPU, 757 00:32:55,330 --> 00:32:58,400 h蓹tta a艧a臒谋, super s眉r蓹tli komp眉ter hardware s蓹viyy蓹si. 758 00:32:58,400 --> 00:33:00,530 Bel蓹 ki, b眉t眉n 蓹traf谋nda yaln谋z 眉st眉nl眉kl蓹ri var. 759 00:33:00,530 --> 00:33:01,530 Bel蓹 ki, bu n蓹 dem蓹kdir? 760 00:33:01,530 --> 00:33:04,850 茝slind蓹, zaman dizayn etdiyiniz bir zaman, dem蓹k olar ki, b眉t眉n veril蓹nl蓹r bazas谋 masa 761 00:33:04,850 --> 00:33:07,170 Siz gedir yaln谋z siz qay臒谋s谋na m蓹lumatlar 762 00:33:07,170 --> 00:33:09,280 kimi, h蓹m d蓹 bir 艧ey unikal identifikator 763 00:33:09,280 --> 00:33:11,280 Bu, 莽眉nki gedir Bizi dig蓹r 艧eyl蓹r ed蓹k. 764 00:33:11,280 --> 00:33:13,160 V蓹 burada bir problem 眉z蓹rind蓹 s蓹f蓹r ed蓹k. 765 00:33:13,160 --> 00:33:15,990 >> Istifad蓹莽il蓹r var ki, d眉艧眉n蓹k yaln谋z istifad蓹莽i ad谋 v蓹 adlar谋, 766 00:33:15,990 --> 00:33:19,540 lakin onlar da 艧蓹h蓹rl蓹ri kimi 艧eyl蓹r var v蓹 d枚vl蓹tl蓹r v蓹 po莽t kodlar谋, 蓹n az谋 767 00:33:19,540 --> 00:33:20,432 AB艦-da burada. 768 00:33:20,432 --> 00:33:22,390 Bel蓹 ki, m蓹n ir蓹li getm蓹k 眉莽眉n gedir蓹m v蓹 yaln谋z tez dem蓹k, 769 00:33:22,390 --> 00:33:26,180 M蓹n蓹 daha 眉莽 s眉tun verm蓹k C蓹dv蓹lin sonunda. 770 00:33:26,180 --> 00:33:28,900 Bu, City olacaq Bu, State olacaq 771 00:33:28,900 --> 00:33:30,400 bu Zip olacaq. 772 00:33:30,400 --> 00:33:32,710 >> 陌ndi City, n蓹 m蓹lumat n枚vl蓹ri Bu, b蓹lk蓹 d蓹, olmal谋d谋r? 773 00:33:32,710 --> 00:33:35,460 774 00:33:35,460 --> 00:33:35,989 VARCHAR? 775 00:33:35,989 --> 00:33:37,780 M蓹n n蓹 bilmir蓹m uzun ad谋 艧蓹h蓹rdir. 776 00:33:37,780 --> 00:33:40,571 Somewhere Amerikada var y蓹qin ki, bir ridiculously uzun s枚z, 777 00:33:40,571 --> 00:33:43,605 bel蓹 q蓹d蓹r, yaln谋z 255 il蓹 ged蓹k tarix蓹n v蓹 ya 枚zba艧谋na. 778 00:33:43,605 --> 00:33:44,730 D枚vl蓹t, n蓹 etm蓹k ist蓹yirsiniz? 779 00:33:44,730 --> 00:33:48,380 780 00:33:48,380 --> 00:33:50,367 Qiyam蓹t z蓹ng, sa臒? 781 00:33:50,367 --> 00:33:51,700 N蓹 蓹n s蓹m蓹r蓹li b蓹lk蓹 var? 782 00:33:51,700 --> 00:33:53,500 Ne莽蓹 simvol? 783 00:33:53,500 --> 00:33:55,950 B蓹lk蓹 yaln谋z iki, 蓹g蓹r biz yaln谋z bunu 眉z almaq, 784 00:33:55,950 --> 00:33:58,250 kimi, MA Massa莽usets 眉莽眉n v蓹 s. 785 00:33:58,250 --> 00:34:00,520 Bel蓹 ki, m蓹n iki CHAR d蓹y蓹ri getm蓹k 眉莽眉n gedir蓹m. 786 00:34:00,520 --> 00:34:03,080 >> Po莽t indeksi maraql谋 biri. 787 00:34:03,080 --> 00:34:06,679 Biz ki, 02138-da buraday谋q Biz n蓹 istifad蓹 etm蓹lidir t蓹klif? 788 00:34:06,679 --> 00:34:07,470 Bu do臒ru, bir int var? 789 00:34:07,470 --> 00:34:10,030 790 00:34:10,030 --> 00:34:12,800 INT, INT, q谋sa? 791 00:34:12,800 --> 00:34:14,521 Qisa i艧 olard谋. 792 00:34:14,521 --> 00:34:15,020 Yox? 793 00:34:15,020 --> 00:34:18,920 794 00:34:18,920 --> 00:34:20,870 CHAR v蓹 ya be艧, lakin m蓹n bir int ist蓹yir蓹m. 795 00:34:20,870 --> 00:34:23,710 N蓹 眉莽眉n INT geri it蓹l蓹m蓹k? 796 00:34:23,710 --> 00:34:26,820 Bu m蓹ni inand谋rmaq. 797 00:34:26,820 --> 00:34:29,210 Hans谋 bir INT, m蓹nim fikir haqq谋nda axmaq var? 798 00:34:29,210 --> 00:34:29,871 B蓹li. 799 00:34:29,871 --> 00:34:31,199 >> Auditoriya: Daha 莽ox yadda艧 tutur. 800 00:34:31,199 --> 00:34:32,909 >> DAVID Malan: daha 莽ox yadda艧 up edin. 801 00:34:32,909 --> 00:34:35,310 D枚rd bytes, ancaq ist蓹yirik Bir po莽t kodu t蓹klif 802 00:34:35,310 --> 00:34:39,000 v蓹 ya be艧 bayt kimi kims蓹, bir char kimi idi ki, h蓹qiq蓹t蓹n deyil, eh kimi hiss ed蓹n 803 00:34:39,000 --> 00:34:39,620 halda. 804 00:34:39,620 --> 00:34:40,489 >> Yax艧谋, fun hekay蓹. 805 00:34:40,489 --> 00:34:43,179 陌ll蓹r 蓹vv蓹l, istifad蓹 眉莽眉n istifad蓹 zaman M蓹nim e-po莽t 眉莽眉n Microsoft Outlook, 806 00:34:43,179 --> 00:34:45,150 M蓹n n蓹hay蓹t Gmail ke莽m蓹k ist蓹di. 807 00:34:45,150 --> 00:34:48,949 Bel蓹likl蓹, m蓹n b眉t眉n ixrac m蓹nim bir CSV fayl谋 olaraq Outlook 蓹laq蓹l蓹r. 808 00:34:48,949 --> 00:34:50,699 Virg眉lle ayr谋lm谋艧 d蓹y蓹rl蓹r, olan yaln谋z m蓹n dem蓹k 809 00:34:50,699 --> 00:34:54,060 b眉t眉n dostlar谋m adlar谋 var idi v蓹 son adlar谋 v蓹 telefon n枚mr蓹l蓹ri v蓹 po莽t kodlar谋 810 00:34:54,060 --> 00:34:54,747 v蓹 ki, b眉t眉n. 811 00:34:54,747 --> 00:34:56,580 V蓹 sonra m蓹n etdi onu a莽谋l谋艧 s蓹hv 812 00:34:56,580 --> 00:34:58,640 Excel olan bir var elektron tablo proqram谋 813 00:34:58,640 --> 00:35:00,289 biz g枚rd眉k kimi CSV fayllar谋 anlay谋r. 814 00:35:00,289 --> 00:35:03,080 Amma sonra, m蓹n kimi, hit olmal谋d谋r Bir n枚qt蓹d蓹 Command v蓹 ya Control S. 815 00:35:03,080 --> 00:35:06,250 V蓹 Excel y蓹qin zamanda H蓹r hans谋 bir zamanda qovu艧durma臒谋m谋z bir x眉susiyy蓹t idi ki, 816 00:35:06,250 --> 00:35:08,100 faydal谋 olma臒a 莽al谋艧d谋q, bir s谋ra g枚rd眉m. 817 00:35:08,100 --> 00:35:11,610 V蓹 say谋 il蓹 ba艧lad谋 蓹g蓹r adet s谋f谋r, yaln谋z onlar谋 qurtarmaq olard谋. 818 00:35:11,610 --> 00:35:13,420 Niy蓹 apar谋c谋 laz谋md谋r edirsiniz integers haqq谋nda adet s谋f谋r? 819 00:35:13,420 --> 00:35:15,140 Onlar riyazi, m蓹nas谋z ist蓹yirik. 820 00:35:15,140 --> 00:35:17,530 Onlar m蓹nas谋z deyilik AB艦 saxlay谋n sistemind蓹. 821 00:35:17,530 --> 00:35:19,954 Bel蓹 ki, m蓹n il ya艧ad谋m, bu g眉n, m蓹n h蓹l蓹 d蓹 822 00:35:19,954 --> 00:35:22,370 ki, dostlar谋 var zaman M蓹n kims蓹 laz谋md谋r nadir hal 823 00:35:22,370 --> 00:35:24,078 bu g眉n m眉raci蓹t, M蓹n h蓹l蓹 ki, m蓹n g枚r眉rs眉n眉z 824 00:35:24,078 --> 00:35:26,767 , Cambridge bir dost var Massachusetts, 2138. 825 00:35:26,767 --> 00:35:29,350 Siz de臒ilseniz bu annoying var program d眉zm蓹k 眉莽眉n 莽al谋艧谋r 826 00:35:29,350 --> 00:35:30,975 z蓹rfl蓹rin yaratmaq v蓹 ya yaln谋z a艧a臒谋 jot. 827 00:35:30,975 --> 00:35:33,599 V蓹, bu s蓹b蓹bd蓹n var M蓹n yanl谋艧 data type se莽di. 828 00:35:33,599 --> 00:35:34,490 Bel蓹 ki, m蓹n sizin fikir sevir蓹m. 829 00:35:34,490 --> 00:35:35,650 Bir CHAR sah蓹sind蓹 istifad蓹 ed蓹k. 830 00:35:35,650 --> 00:35:38,340 Be艧 simvol, istisna olmaqla, bir k眉nc halda var. 831 00:35:38,340 --> 00:35:42,220 Siz h蓹l蓹 mail g枚nd蓹rin varsa, b蓹z蓹n bu g眉n kodlar谋 zip, 832 00:35:42,220 --> 00:35:45,360 Onlar kimi, ist蓹yirik, 眉st蓹g蓹l d枚rd. 833 00:35:45,360 --> 00:35:48,200 Bel蓹 ki, biz sonra bir tire v蓹 laz谋md谋r biz daha d枚rd 蓹d蓹d laz谋md谋r. 834 00:35:48,200 --> 00:35:50,330 Bel蓹 ki, vicdanl谋 olmaq, bu ola bil蓹r bir 莽ox m眉xt蓹lif yollarla getm蓹k. 835 00:35:50,330 --> 00:35:52,371 >> 陌ndi, m蓹n saxlamaq 眉莽眉n gedir蓹m Bu sad蓹 v蓹 m蓹n yaln谋z deyil蓹m 836 00:35:52,371 --> 00:35:54,780 bir ki, dem蓹k olacaq Be艧 CHAR d蓹y蓹ri v蓹 biz ist蓹yirik 837 00:35:54,780 --> 00:35:56,739 b眉t眉n dash plus d枚rd ke莽m蓹k gedir. 838 00:35:56,739 --> 00:35:58,280 Lakin bu 蓹v蓹zetm蓹l蓹r n枚v var. 839 00:35:58,280 --> 00:36:00,196 V蓹 siz hesab ed蓹 bil蓹r yaranan eyni probleml蓹r 840 00:36:00,196 --> 00:36:01,860 telefon n枚mr蓹l蓹ri v蓹 ya dig蓹r sah蓹l蓹ri il蓹. 841 00:36:01,860 --> 00:36:04,350 >> V蓹 indi bu 蓹slind蓹 a臒谋ls谋z yol a艧a臒谋 getm蓹k 眉莽眉n. 842 00:36:04,350 --> 00:36:08,000 Rob v蓹 m蓹n v蓹 Hannah h蓹m d眉艧眉n蓹k v蓹 Maria v蓹 [? Davon?] V蓹 Andy 843 00:36:08,000 --> 00:36:12,820 v蓹 hey蓹ti ba艧qalar谋 ya艧ay谋r Kembric, Massa莽usets, 02138-ci ild蓹. 844 00:36:12,820 --> 00:36:17,970 Bu, h蓹qiq蓹t蓹n, M蓹n ki, axmaq hiss M蓹nim users masa 蓹lav蓹, 艧蓹h蓹r, d枚vl蓹t, 845 00:36:17,970 --> 00:36:18,630 v蓹 zip. 846 00:36:18,630 --> 00:36:20,980 Niy蓹? 847 00:36:20,980 --> 00:36:21,960 >> Auditoriya: [i艧itilemez] 848 00:36:21,960 --> 00:36:22,918 >> DAVID Malan: daha dem蓹k? 849 00:36:22,918 --> 00:36:24,310 Auditoriya: [i艧itilemez] 850 00:36:24,310 --> 00:36:25,850 >> DAVID Malan: Onlar h蓹mi艧蓹 ist蓹yirik sa臒, birlikd蓹 getm蓹k 眉莽眉n gedir? 851 00:36:25,850 --> 00:36:28,660 Bu 莽谋x谋r zaman, biz d眉艧眉nm蓹k 眉莽眉n istifad蓹 Bu exhaustively biz q蓹d蓹r oldu臒u 852 00:36:28,660 --> 00:36:30,570 b眉t眉n AB艦 axtar谋艧 v蓹 orada 莽谋x谋r 853 00:36:30,570 --> 00:36:32,653 b蓹zi uy臒unsuzluqlar var burada 莽ox 艧蓹h蓹rl蓹r var 854 00:36:32,653 --> 00:36:35,060 q蓹rib蓹 eyni zip,. 855 00:36:35,060 --> 00:36:40,580 Amma indi 02138 bunun 眉莽眉n m眉蓹yy蓹n 蓹g蓹r h蓹mi艧蓹 Cambridge, Massachusetts 856 00:36:40,580 --> 00:36:44,910 niy蓹 d眉nyada saxlamaq olard谋 veril蓹nl蓹r bazas谋 Cambridge v蓹 MA v蓹 02138 857 00:36:44,910 --> 00:36:49,357 m蓹nim 眉莽眉n v蓹 Hannah v蓹 Rob v蓹 [眉莽眉n? Davon?] V蓹 ya艧amaq ba艧qalar谋 眉莽眉n 858 00:36:49,357 --> 00:36:51,190 burada Cambridge, bu m眉k蓹mm蓹l laz谋ms谋z. 859 00:36:51,190 --> 00:36:54,480 >> Biz 眉z almaq laz谋md谋r yaln谋z n蓹 saxlan谋lmas谋 il蓹? 860 00:36:54,480 --> 00:36:55,610 Just saxlay谋n kodu. 861 00:36:55,610 --> 00:36:58,660 Amma sonra, biz yaln谋z saxlamaq 蓹g蓹r po莽t indeksi, m蓹n y蓹qin ki, ist蓹yir蓹m 862 00:36:58,660 --> 00:37:02,160 02138 harada m蓹nim haqqinda 眉莽眉n bilm蓹k. 863 00:37:02,160 --> 00:37:03,910 Bel蓹 ki, m蓹n bir masa laz谋md谋r. 864 00:37:03,910 --> 00:37:04,697 V蓹 OK. 865 00:37:04,697 --> 00:37:07,530 V蓹 蓹slind蓹, bu biri dizayn masa dizayn prosesl蓹ri 866 00:37:07,530 --> 00:37:11,472 Siz h蓹m莽inin vasit蓹si PSet7 ed蓹c蓹yik ki, Siz 眉mumi m蓹lumatlar谋n amil ist蓹yir蓹m. 867 00:37:11,472 --> 00:37:14,430 Just biz faktoring oldu臒unuz kimi 眉mumi code v蓹 faktorinq 眉mumi 868 00:37:14,430 --> 00:37:17,380 Burada CSS 眉slub 脟ox bazas谋nda, 869 00:37:17,380 --> 00:37:21,180 M蓹n yaln谋z benzersiz 眉莽眉n 02138 laz谋md谋r, 蓹g蓹r , kimins蓹 m蓹ml蓹k蓹ti m眉蓹yy蓹n 870 00:37:21,180 --> 00:37:25,020 Cambridge, k眉tl蓹vi saxlamay谋n Sizin c蓹dv蓹ld蓹 h蓹r bir darn istifad蓹莽i. 871 00:37:25,020 --> 00:37:29,770 >> 茝ksin蓹, adl谋 ayr谋-ayr谋 masa var Zips var ki, n蓹 s眉tunlar? 872 00:37:29,770 --> 00:37:33,490 Y蓹qin ki, bir ID sah蓹, yaln谋z, 莽眉nki prinsipl蓹ri biz indi s枚hb蓹t edirik. 873 00:37:33,490 --> 00:37:35,720 02138 眉莽眉n y蓹qin ki, bir zip sah蓹sind蓹. 874 00:37:35,720 --> 00:37:38,400 V蓹 sonra y蓹qin ki, n蓹 dig蓹r s眉tunlar? 875 00:37:38,400 --> 00:37:42,950 艦蓹h蓹r v蓹 d枚vl蓹t, lakin yaln谋z bir var s谋ra 02138 眉莽眉n 02139 眉莽眉n bir s谋ra, 876 00:37:42,950 --> 00:37:44,772 90210 眉莽眉n bir s谋ra. 877 00:37:44,772 --> 00:37:46,730 V蓹 s枚z眉n M蓹n bilir蓹m, b眉t眉n po莽t kodlar谋. 878 00:37:46,730 --> 00:37:49,012 >> Bel蓹 ki, indi siz n蓹 ed蓹 bil蓹r? 879 00:37:49,012 --> 00:37:51,220 Bu, 莽眉nki, problemli indi is蓹 iki masalar var. 880 00:37:51,220 --> 00:37:54,660 Bel蓹 ki, m蓹nim users 蓹sas蓹n burada var, lakin onlar谋n 艧蓹h蓹r d枚vl蓹t informasiya 881 00:37:54,660 --> 00:37:55,390 burada. 882 00:37:55,390 --> 00:37:58,635 Bel蓹 ki, var, SQL il蓹 莽谋x谋r 蓹slind蓹 bir yol, informasiya qo艧ulmaq 883 00:37:58,635 --> 00:38:00,470 v蓹 pset bu g枚r蓹c蓹ksiniz. 884 00:38:00,470 --> 00:38:03,000 >> Amma bu siz 莽谋x谋r bu kimi bir 艧ey. 885 00:38:03,000 --> 00:38:10,501 Istifad蓹莽il蓹r SELECT star, ON zips OL users po莽t zips zip n枚qt蓹 b蓹rab蓹rdir n枚qt蓹. 886 00:38:10,501 --> 00:38:13,360 Hans谋 bir az wordy edir, admittedly, lakin bu yaln谋z 887 00:38:13,360 --> 00:38:17,590 se莽in h蓹r 艧ey dem蓹kdir M蓹nim istifad蓹莽i masa alaraq prosesi 888 00:38:17,590 --> 00:38:19,580 v蓹 zips masa. 889 00:38:19,580 --> 00:38:22,120 Bir onlara qo艧ul sah蓹sind蓹 Onlar s眉tun var. 890 00:38:22,120 --> 00:38:24,780 Bel蓹 ki, sanki bir 艧ey bunu bu kimi v蓹 m蓹ni geri verm蓹k 891 00:38:24,780 --> 00:38:27,360 yeni m眉v蓹qq蓹ti masa ki, ki, b枚y眉k var, geni艧 var 892 00:38:27,360 --> 00:38:29,450 ki, b眉t眉n var Onlar谋n h蓹m d蓹 s眉tun. 893 00:38:29,450 --> 00:38:33,510 V蓹, sad蓹c蓹, ola bil蓹r bu kimi bir 艧ey etm蓹k 眉莽眉n syntax. 894 00:38:33,510 --> 00:38:35,540 >> Bel蓹 ki, ir蓹lid蓹 bu var lakin olacaq 895 00:38:35,540 --> 00:38:38,950 dig蓹r dizayn q蓹rarlar谋 olmaq 眉莽眉n laz谋md谋r yaln谋z g枚st蓹ricil蓹ri il蓹 etm蓹k laz谋md谋r 896 00:38:38,950 --> 00:38:40,550 h蓹m d蓹 probleml蓹r daxil 莽al谋艧an. 897 00:38:40,550 --> 00:38:43,360 茝slind蓹, bir problem var h蓹r hans谋 bir m蓹lumat bazas谋 dizayn 898 00:38:43,360 --> 00:38:47,930 qovu艧durma臒谋m谋z b蓹z蓹n iki n蓹f蓹r ist蓹yir蓹m veril蓹nl蓹r bazas谋 eyni sat谋r daxil olmaq 眉莽眉n 899 00:38:47,930 --> 00:38:48,530 masa. 900 00:38:48,530 --> 00:38:51,450 Bel蓹 ki, bu bir 艧ey ki, biz laz谋md谋r deyil h蓹m莽inin PSet7 qar艧谋la艧a. 901 00:38:51,450 --> 00:38:54,686 >> Amma m蓹n bir baxmaq ist蓹diyiniz fikir SQL m眉mk眉nd眉r h眉cum. 902 00:38:54,686 --> 00:38:56,560 Hans谋lard谋r yarana bil蓹r probleml蓹r? 903 00:38:56,560 --> 00:38:58,170 Bel蓹 ki, PSet7 bu qar艧谋la艧a bil蓹rsiniz. 904 00:38:58,170 --> 00:39:01,874 V蓹 biz a莽谋q n蓹 dem蓹k Bu problem 眉莽眉n kodla艧d谋rma h蓹ll edir. 905 00:39:01,874 --> 00:39:04,790 Amma y眉ks蓹k s蓹viyy蓹d蓹 sinif almaq 蓹g蓹r, x眉susil蓹 蓹m蓹liyyat sistemi, 906 00:39:04,790 --> 00:39:06,950 kar艧谋la艧aca臒谋n谋z olacaq atomicity bir m蓹s蓹l蓹, 907 00:39:06,950 --> 00:39:10,080 etm蓹y蓹 莽al谋艧谋r谋q problemi 脟ox 艧eyi b眉t眉n bir d蓹f蓹 908 00:39:10,080 --> 00:39:11,000 fasil蓹siz. 909 00:39:11,000 --> 00:39:14,560 >> V蓹 m蓹n bu t蓹qdim ist蓹diyiniz fikir bir m蓹caz il蓹 PSet7 眉莽眉n fikir 910 00:39:14,560 --> 00:39:18,160 M蓹n Margo 枚z眉m眉 oldu臒u 枚yr蓹nil蓹n Seltzer nin CS164 蓹m蓹liyyat sisteml蓹ri 911 00:39:18,160 --> 00:39:18,990 bundan sinif il. 912 00:39:18,990 --> 00:39:22,230 Bu yurt biri Tutaq ki, Sizin yurt otaq v蓹 ya ev soyuducu, 913 00:39:22,230 --> 00:39:24,474 v蓹 s眉d 眉莽眉n real meyil var. 914 00:39:24,474 --> 00:39:27,140 Bel蓹 ki, siz sinifl蓹r ev g蓹lm蓹k bir g眉n, siz soyuducu a莽maq. 915 00:39:27,140 --> 00:39:27,620 Oh, l蓹n蓹t olsun. 916 00:39:27,620 --> 00:39:28,870 Soyuducuda he莽 bir s眉d var. 917 00:39:28,870 --> 00:39:32,470 Bel蓹 ki, soyuducu yax谋n, , qap谋n谋 ba臒lamaq yurt kilidi, 918 00:39:32,470 --> 00:39:34,770 k枚艧edeki g蓹zm蓹k CVS 眉莽眉n, x蓹tti almaq, 919 00:39:34,770 --> 00:39:36,312 v蓹 b蓹zi s眉d 眉莽眉n h蓹yata yoxlan谋lmas谋 ba艧lay谋r. 920 00:39:36,312 --> 00:39:38,978 V蓹 bu, bir m眉dd蓹t olacaq o l蓹n蓹tl蓹m蓹k 枚z眉n眉 checkout 莽眉nki 921 00:39:38,978 --> 00:39:40,570 counters h蓹r halda istifad蓹 眉莽眉n 蓹b蓹di edir. 922 00:39:40,570 --> 00:39:41,950 Bel蓹 ki, eyni zamanda, sizin roommate ev g蓹lir. 923 00:39:41,950 --> 00:39:43,470 O, h蓹qiq蓹t蓹n, h蓹m莽inin s眉d b蓹y蓹nir. 924 00:39:43,470 --> 00:39:45,520 Onlar yurt ota臒a g蓹lib, soyuducu a莽maq, oh, bu darn. 925 00:39:45,520 --> 00:39:46,490 He莽 bir daha 莽ox s眉d var. 926 00:39:46,490 --> 00:39:49,040 >> Bel蓹 ki, o da k枚艧edeki gedir. 927 00:39:49,040 --> 00:39:51,670 Amma indi bu yana iki kimi var v蓹 ya 眉莽 v蓹 ya d枚rd CVSes yax谋n, 928 00:39:51,670 --> 00:39:53,800 Onlar biri getm蓹k 眉莽眉n n蓹 Meydanda f蓹rqli olanlar. 929 00:39:53,800 --> 00:39:55,830 V蓹 indi, bir ne莽蓹 d蓹qiq蓹 Siz sonra, h蓹m d蓹 930 00:39:55,830 --> 00:39:58,060 ev g蓹lm蓹k v蓹 he莽 uf, 蓹n pis problem. 931 00:39:58,060 --> 00:40:00,967 陌ndi siz d蓹 莽ox s眉d var Bu tur艧 getm蓹k olacaq, 莽眉nki. 932 00:40:00,967 --> 00:40:03,050 V蓹 s眉d ist蓹yir蓹m, amma siz h蓹qiq蓹t蓹n s眉d kimi deyil. 933 00:40:03,050 --> 00:40:06,730 >> Bel蓹 ki, indi bu bahal谋 idi s蓹hv Siz d蓹, 莽眉nki 934 00:40:06,730 --> 00:40:09,870 蓹sas谋nda q蓹rar q蓹bul edib b蓹zi d蓹yi艧蓹n d枚vl蓹t ki, 935 00:40:09,870 --> 00:40:12,660 prosesind蓹 idi sizin d蓹yi艧dirilir, 936 00:40:12,660 --> 00:40:14,560 s眉d almaq 眉莽眉n gedir t蓹艧蓹bb眉skar谋. 937 00:40:14,560 --> 00:40:17,785 Bel蓹 ki, n蓹 b蓹lk蓹 insan ki, problemin h蓹lli? 938 00:40:17,785 --> 00:40:18,660 Auditoriya: [i艧itilemez] 939 00:40:18,660 --> 00:40:19,430 DAVID Malan: sa臒, qeyd yaz? 940 00:40:19,430 --> 00:40:21,850 Siz 蓹g蓹r h蓹mi艧蓹 bir qeyd t蓹rk ki, 艧ou il蓹 tan谋艧. 941 00:40:21,850 --> 00:40:23,100 B蓹li, biz蓹 iki var. 942 00:40:23,100 --> 00:40:25,940 Bel蓹 ki, h蓹mi艧蓹 qeyd t蓹rk, v蓹 ya s枚z眉n soyuducu kilidi 943 00:40:25,940 --> 00:40:28,602 asma kilit bir n枚v v蓹 ya kimi 眉st眉nd蓹n bir 艧ey. 944 00:40:28,602 --> 00:40:31,310 Amma bu h蓹qiq蓹t蓹n olacaq veril蓹nl蓹r bazas谋 dizayn il蓹 蓹sas problem, 945 00:40:31,310 --> 00:40:34,710 Siz ola bil蓹r, x眉susil蓹 d蓹 zaman 脟ox brauzerl蓹rd蓹, 莽ox noutbuk, 946 00:40:34,710 --> 00:40:37,450 bird蓹n 莽ox istifad蓹莽i b眉t眉n 莽al谋艧谋r bir d蓹f蓹 m蓹lumat yenil蓹m蓹. 947 00:40:37,450 --> 00:40:40,590 X眉susil蓹 h蓹ssas m蓹lumat maliyy蓹 informasiya kimi, 948 00:40:40,590 --> 00:40:43,350 qovu艧durma臒谋m谋z bir fond ticar蓹t Sizin kimi web bina olacaq, 949 00:40:43,350 --> 00:40:47,270 Siz n蓹 q蓹d蓹r pul yoxlamaq ist蓹yirsinizs蓹 n蓹 siz v蓹 sonra kifay蓹t q蓹d蓹r varsa, 950 00:40:47,270 --> 00:40:48,490 bir fond almaq? 951 00:40:48,490 --> 00:40:50,899 >> Amma n蓹 ba艧qas谋 Sizinl蓹 birg蓹 hesab谋 var 952 00:40:50,899 --> 00:40:52,690 eyni zamanda 莽al谋艧谋r bir fond almaq 眉莽眉n nec蓹? 953 00:40:52,690 --> 00:40:55,190 Bel蓹 ki, o yoxlan谋lmas谋 deyil Siz d蓹 hesab balans谋, 954 00:40:55,190 --> 00:40:57,540 Eyni geri almaq cavab yoxdur s眉d var. 955 00:40:57,540 --> 00:41:00,580 V蓹 ya h蓹r iki cavab geri almaq Siz haqq-hesab $ 100 var. 956 00:41:00,580 --> 00:41:04,680 Siz d蓹 q蓹rar q蓹bul etm蓹k 眉莽眉n c蓹hd edin b蓹zi 艧irk蓹t fond bir pay almaq. 957 00:41:04,680 --> 00:41:06,130 >> 陌ndi n蓹 olar? 958 00:41:06,130 --> 00:41:07,140 Siz iki s蓹hml蓹rin var? 959 00:41:07,140 --> 00:41:08,420 Siz he莽 bir s蓹hml蓹rin var? 960 00:41:08,420 --> 00:41:10,320 Kimi probleml蓹r yarana bil蓹r. 961 00:41:10,320 --> 00:41:11,755 Bel蓹 ki, biz ki qar艧谋la艧a bil蓹rsiniz. 962 00:41:11,755 --> 00:41:14,630 SQL injection h眉cumlar谋n, t蓹艧蓹kk眉rl蓹, biz siz蓹 yard谋m ed蓹c蓹yik bir 艧ey var, 963 00:41:14,630 --> 00:41:17,430 lakin bu x眉susi amans谋zl谋qla var h蓹l蓹 d蓹 眉mumi bu g眉n. 964 00:41:17,430 --> 00:41:18,680 Bel蓹 ki, bu, yaln谋z bir n眉mun蓹sidir. 965 00:41:18,680 --> 00:41:21,290 M蓹n he莽 bir iddia etm蓹k ki, Harvard PIN sistemi 966 00:41:21,290 --> 00:41:23,130 bu h眉cum h蓹ssas. 967 00:41:23,130 --> 00:41:24,160 Biz c蓹hd etdik. 968 00:41:24,160 --> 00:41:26,120 Amma bilirsiniz ki, biz bu kimi bir sah蓹 var. 969 00:41:26,120 --> 00:41:29,620 V蓹 Yale nin Net ID b蓹nz蓹r var bu g眉n ekran axtar谋r. 970 00:41:29,620 --> 00:41:33,190 V蓹 bu, 莽谋x谋r ki, b蓹lk蓹 PIN sistemi PHP h蓹yata ke莽irilir. 971 00:41:33,190 --> 00:41:37,050 >> Bu were-- 蓹g蓹r onlar deyilik var bu kimi g枚r眉n眉r kod ola bil蓹r. 972 00:41:37,050 --> 00:41:38,210 Onlar iki d蓹yi艧蓹nl蓹r var. 973 00:41:38,210 --> 00:41:42,495 M蓹n蓹 ad谋n谋z谋 v蓹 艧ifr蓹nizi verin post super qlobal d蓹yi艧蓹n 974 00:41:42,495 --> 00:41:43,970 biz 蓹vv蓹ll蓹r haqq谋nda s枚hb蓹t edir. 975 00:41:43,970 --> 00:41:47,310 B蓹lk蓹 Harvard bir sor臒u var istifad蓹莽il蓹r SELECT ulduz kimi 976 00:41:47,310 --> 00:41:50,005 harada istifad蓹莽i ad谋 ki, b蓹rab蓹rdir v蓹 parol ki, b蓹rab蓹rdir. 977 00:41:50,005 --> 00:41:51,880 M蓹n yaln谋z deyil蓹m ki, qeyd istifad蓹 ed蓹r蓹k onu sayede 978 00:41:51,880 --> 00:41:55,050 dig蓹r buruq brace notation Yaln谋z bir d蓹y蓹r plug dem蓹kdir g眉n 979 00:41:55,050 --> 00:41:55,550 burada. 980 00:41:55,550 --> 00:41:57,449 M蓹n istifad蓹 edir蓹m sual i艧ar蓹si texnika. 981 00:41:57,449 --> 00:41:59,240 M蓹n he莽 bir ikinci yoxdur v蓹 ya 眉莽眉nc眉 d蓹lill蓹ri. 982 00:41:59,240 --> 00:42:02,350 M蓹n yaln谋z s枚z眉n deyil蓹m simli 枚z眉m眉 in艧a. 983 00:42:02,350 --> 00:42:04,930 >> problem olsa da, ki, Kims蓹 bir scroob kimi, 蓹g蓹r, 984 00:42:04,930 --> 00:42:09,020 olan film istinad edir, bu kimi bir 艧ey il蓹 logs, 985 00:42:09,020 --> 00:42:11,250 M蓹n n枚qt蓹l蓹r xaric etdik ad蓹t蓹n 蓹hat蓹 ki, 986 00:42:11,250 --> 00:42:14,370 O n蓹 varsa parol, x眉susil蓹 z蓹r蓹rli 987 00:42:14,370 --> 00:42:18,860 v蓹 onun parol b蓹lk蓹, 12345 edir adl谋 film ba艧谋na "Spaceballs" 988 00:42:18,860 --> 00:42:21,970 lakin o, t蓹nqidi n枚v be艧 sonra bir quote, 989 00:42:21,970 --> 00:42:24,790 sonra s枚z眉n s枚z v蓹 ya m蓹kan谋nda, sonra quote, 990 00:42:24,790 --> 00:42:29,160 d谋rna臒谋 ba臒lamaq bir quote bir b蓹rab蓹rdir lakin o, n蓹 莽谋xar谋lm谋艧d谋r bildiri艧? 991 00:42:29,160 --> 00:42:32,700 O, sa臒 quote 莽谋xar谋lm谋艧d谋r ki, O, sol quote 莽谋xar谋lm谋艧d谋r oldu. 992 00:42:32,700 --> 00:42:35,170 >> 脟眉nki 蓹g蓹r bu t蓹cav眉zkar scroob nin prezumpsiyas谋 993 00:42:35,170 --> 00:42:38,160 insanlar yazd谋 ki, Bu PHP kodu, bel蓹 parlaq deyil 994 00:42:38,160 --> 00:42:42,990 b蓹lk蓹 onlar yaln谋z bir t蓹k var interpolation 蓹traf谋nda quotes 995 00:42:42,990 --> 00:42:45,210 q谋vr谋m a艧谋rma d蓹yi艧蓹n? 996 00:42:45,210 --> 00:42:48,620 V蓹 bel蓹 ki, b蓹lk蓹, o c眉r ola bil蓹r onlar谋n fikir ba艧a 997 00:42:48,620 --> 00:42:53,290 onlar 眉莽眉n, lakin bir 艧蓹kild蓹 gedir Ona PIN sistemi h眉cumu imkan. 998 00:42:53,290 --> 00:42:55,310 Ba艧qa s枚zl蓹, g眉man Bu kodu edir ki, 999 00:42:55,310 --> 00:42:57,140 v蓹 biz tipli scroob n蓹 yerl蓹艧dirin. 1000 00:42:57,140 --> 00:42:58,770 Bu pis, 莽眉nki bu, q谋rm谋z谋. 1001 00:42:58,770 --> 00:43:01,310 >> V蓹 蓹sas m蓹tn , o tipli n蓹 1002 00:43:01,310 --> 00:43:05,510 scroob Harvard server bezemek bil蓹r bir SQL sor臒u tikintisi daxil 1003 00:43:05,510 --> 00:43:07,440 bu kimi g枚r眉n眉r string. 1004 00:43:07,440 --> 00:43:11,760 艦ifr蓹 12345 ya bir bir b蓹rab蓹rdir. 1005 00:43:11,760 --> 00:43:14,820 N蓹tic蓹d蓹 olan m蓹ntiqi, Bu scroob daxil olacaq ki, 1006 00:43:14,820 --> 00:43:18,360 onun parol 蓹g蓹r 12345 ya bir b蓹rab蓹r 1007 00:43:18,360 --> 00:43:22,660 h蓹mi艧蓹 蓹lb蓹tt蓹 do臒rudur biri, olan scroob h蓹mi艧蓹 olur dem蓹kdir. 1008 00:43:22,660 --> 00:43:26,060 >> Bel蓹 ki, yol d眉zeltmek 眉莽眉n Bu hallarda bir 莽ox kimi, 1009 00:43:26,060 --> 00:43:28,140 daha m眉dafi蓹 yazmaq olard谋. 1010 00:43:28,140 --> 00:43:30,390 Kimi bir 艧ey istifad蓹 etm蓹k 眉莽眉n bizim Faktiki sor臒u funksiyas谋 olan 1011 00:43:30,390 --> 00:43:33,980 biz plug PSet7, g枚r蓹c蓹ksiniz sual kimi bir 艧ey burada qeyd olunur. 1012 00:43:33,980 --> 00:43:35,980 V蓹 g枚z蓹llik sor臒u funksiyas谋 ki, biz 1013 00:43:35,980 --> 00:43:40,010 Siz bu qar艧谋 m眉dafi蓹 verm蓹k S枚zd蓹 SQL injection h眉cumlar谋n, 1014 00:43:40,010 --> 00:43:44,260 Kims蓹 sizin kodu tricking olunur 枚z SQL kodu inyeksiya. 1015 00:43:44,260 --> 00:43:47,380 N蓹 sor臒u funksiyas谋 脟眉nki Biz, h蓹qiq蓹t蓹n, ed蓹c蓹yik verm蓹k, 1016 00:43:47,380 --> 00:43:51,270 Siz sual i艧ar蓹si sintaksis istifad蓹 蓹g蓹r v蓹 ikinci v蓹 眉莽眉nc眉 d蓹lil, 1017 00:43:51,270 --> 00:43:54,590 Bu 蓹lav蓹 n蓹 var istifad蓹莽i t蓹min giri艧? 1018 00:43:54,590 --> 00:43:56,060 H蓹min backslash quotes. 1019 00:43:56,060 --> 00:43:58,590 >> Bel蓹 ki, h蓹r hans谋 bir potensial escape t蓹hl眉k蓹li simvol. 1020 00:43:58,590 --> 00:44:01,000 Bu, art谋q q蓹rib蓹 g枚r眉n眉r lakin bu h蓹ssas deyil 1021 00:44:01,000 --> 00:44:03,260 bu deyil, 莽眉nki Art谋q m蓹ntiq d蓹yi艧蓹 1022 00:44:03,260 --> 00:44:06,470 ki, b眉t眉n parol, 莽眉nki 陌ndi deyil bir quote, 1023 00:44:06,470 --> 00:44:07,596 蓹slind蓹, scroob parol. 1024 00:44:07,596 --> 00:44:09,845 Bel蓹 ki, b蓹zi zarafatlar olub il 蓹rzind蓹 bu bar蓹d蓹. 1025 00:44:09,845 --> 00:44:12,570 Bel蓹 ki, bu bir foto艧蓹kili 莽蓹kdirdi bir park b蓹zi turk 1026 00:44:12,570 --> 00:44:16,620 vasit蓹si Siz ki, b蓹zi 艧蓹h蓹rl蓹ri bil蓹r v蓹 d枚vl蓹tl蓹r lisenziya scan 眉莽眉n c蓹hd 1027 00:44:16,620 --> 00:44:19,460 n枚mr蓹li Siz v蓹 ya bilet qanun layih蓹si Siz Siz kimi, olmadan vasit蓹sil蓹 getm蓹k 蓹g蓹r, 1028 00:44:19,460 --> 00:44:20,660 E-Z Pass 艧ey. 1029 00:44:20,660 --> 00:44:24,490 Bel蓹 ki, bu 艧蓹xs b蓹lk蓹 ehtimal E-Z Pass sistemi yaz谋l谋 n蓹f蓹r 1030 00:44:24,490 --> 00:44:28,240 bel蓹 parlaq deyil, v蓹 b蓹lk蓹 onlar yaln谋z bir simli birlikd蓹 Z蓹ncirl蓹m蓹, 1031 00:44:28,240 --> 00:44:32,190 ki, o pis bilm蓹di yaln谋z onlar谋n fikir tam deyil, 1032 00:44:32,190 --> 00:44:35,150 ancaq bir pis 蓹mri yerin蓹, olan biz h蓹l蓹 qeyd etdik 1033 00:44:35,150 --> 00:44:36,380 lakin y蓹qin ki, tahmin ed蓹 bil蓹rsiniz. 1034 00:44:36,380 --> 00:44:39,820 Bundan 蓹lav蓹 ki, silm蓹k v蓹 daxil edin v蓹 yenil蓹m蓹 v蓹 se莽in, 1035 00:44:39,820 --> 00:44:43,370 drop adl谋 s枚z d蓹 var, olan s枚z眉n h蓹r 艧eyi silir 1036 00:44:43,370 --> 00:44:45,300 veril蓹nl蓹r bazas谋, olan x眉susil蓹 pis. 1037 00:44:45,300 --> 00:44:48,760 >> Biz bu 蓹g蓹r zoom ed蓹 bil蓹rsiniz g枚rm蓹k 眉莽眉n bir az 莽蓹tin deyil. 1038 00:44:48,760 --> 00:44:52,300 Bu, indi m蓹艧hur karikatura deyil ki, indi g枚z蓹l a臒谋ll谋 deyil 1039 00:44:52,300 --> 00:44:53,145 v蓹 ayd谋n. 1040 00:44:53,145 --> 00:45:00,880 1041 00:45:00,880 --> 00:45:04,750 >> [G眉l眉艧] 1042 00:45:04,750 --> 00:45:05,910 >> S蓹rin, B蓹li. 1043 00:45:05,910 --> 00:45:06,800 Kind h蓹yata geeking. 1044 00:45:06,800 --> 00:45:08,800 Bu, sonra, var SQL injection h眉cumlar. 1045 00:45:08,800 --> 00:45:13,050 Onlar istifad蓹 ed蓹r蓹k qar艧谋s谋n谋 almaq 眉莽眉n bel蓹 asan ist蓹yirik sa臒 code ya sa臒 kitabxana. 1046 00:45:13,050 --> 00:45:15,947 V蓹 siz ki PSet7 g枚r蓹c蓹ksiniz niy蓹 biz siz蓹 sor臒u funksiyas谋 verir. 1047 00:45:15,947 --> 00:45:17,780 Bel蓹 ki, oyunlar谋n谋z bir ne莽蓹 Biz ist蓹diyiniz d眉艧眉nd眉m ki, 1048 00:45:17,780 --> 00:45:19,930 burada verm蓹k bizim birlikd蓹 qalan d蓹qiq蓹l蓹rind蓹. 1049 00:45:19,930 --> 00:45:24,030 Bel蓹 ki, kimi h蓹ft蓹 s谋f谋r xat谋rlay谋ram, biz Bu iki y眉ng眉l amp眉ller t蓹qdim ed蓹n 1050 00:45:24,030 --> 00:45:26,610 olan g枚z蓹l deyil yaln谋z, 莽眉nki Onlar olduqca etdiyiniz v蓹 r蓹ngar蓹ng, 1051 00:45:26,610 --> 00:45:29,450 lakin onlar bir 艧ey d蓹st蓹k 莽眉nki 茝riz蓹, bir API adl谋 1052 00:45:29,450 --> 00:45:31,980 Proqram 陌nterfeysi V蓹 CS50 g眉n蓹 q蓹d蓹r, biz 1053 00:45:31,980 --> 00:45:34,440 蓹sas蓹n al谋n diqq蓹t v蓹 POST, lakin bu 莽谋x谋r 1054 00:45:34,440 --> 00:45:37,390 PUT kimi dig蓹r HTTP fe'll蓹r var. 1055 00:45:37,390 --> 00:45:39,430 >> V蓹 蓹slind蓹, bu idi H蓹ft蓹 s谋f谋r bir slayd 1056 00:45:39,430 --> 00:45:44,930 vasit蓹si 茝g蓹r siz kodu yazmaq 蓹g蓹r g枚nd蓹rir a la PSet6 bir HTTP request ki 1057 00:45:44,930 --> 00:45:49,647 Bu m蓹tn y谋臒谋n il蓹 bu kimi g枚r眉n眉r JSON adlan谋r alt谋ndak谋, 1058 00:45:49,647 --> 00:45:52,230 v蓹 ya JavaScript Obyekt Notation ki, biz g蓹l蓹n h蓹ft蓹 haqq谋nda dan谋艧maq laz谋md谋r, 1059 00:45:52,230 --> 00:45:57,030 Siz yand谋rmaq v蓹 ya s枚nd眉rm蓹k v蓹 ya d蓹yi艧dirm蓹k olar bu kimi i艧谋qlar r蓹ng. 1060 00:45:57,030 --> 00:46:00,480 CS50 b蓹zi 蓹lav蓹 var, bel蓹 ki, New Haven burada h蓹min y眉ng眉l amp眉ller 1061 00:46:00,480 --> 00:46:02,480 Siz borc ist蓹yirsinizs蓹 Onlara final layih蓹l蓹r 眉莽眉n, 1062 00:46:02,480 --> 00:46:04,370 b蓹zi Microsoft Kimi Bands, 1063 00:46:04,370 --> 00:46:07,619 Siz bil蓹k 蓹traf谋nda geyinm蓹k ki, Zin蓹t 蓹艧yalar谋 v蓹 saatlar eyni ki, bir API var ki, 1064 00:46:07,619 --> 00:46:10,040 onlar 眉莽眉n 枚z proqram yaza bil蓹rsiniz. 1065 00:46:10,040 --> 00:46:12,490 >> Biz bir haqq-hesab il蓹 var Apple iOS code bel蓹 1066 00:46:12,490 --> 00:46:15,510 ki, Apple Watch v蓹 ya varsa iPhone v蓹 ya iPad v蓹 ya iPod, 1067 00:46:15,510 --> 00:46:17,707 茝g蓹r siz kodu yazmaq olar ki, h蓹qiq蓹t蓹n o 莽al谋艧谋r. 1068 00:46:17,707 --> 00:46:19,540 Biz b眉t眉n d蓹st蓹 var vard谋r Arduinos, 1069 00:46:19,540 --> 00:46:22,010 ki莽ik ki莽ik komp眉ter hallarda olmadan, mahiyy蓹tc蓹, 1070 00:46:22,010 --> 00:46:25,240 Siz USB vasit蓹sil蓹 qo艧ula bil蓹r ki, ad蓹t蓹n 枚z Mac v蓹 ya PC, 1071 00:46:25,240 --> 00:46:28,810 bu fiziki 莽al谋艧谋r kodu yazmaq tez-tez onlara sensorlar var cihazlar 1072 00:46:28,810 --> 00:46:30,790 bel蓹 ki, real d眉nya il蓹 qar艧谋l谋ql谋 bil蓹r. 1073 00:46:30,790 --> 00:46:32,860 Biz b眉t眉n d蓹st蓹 var Leap Motion cihazlar, 1074 00:46:32,860 --> 00:46:36,500 Mac 眉莽眉n USB cihazlar谋 olan v蓹 Burada yen蓹 New Haven PC. 1075 00:46:36,500 --> 00:46:40,080 V蓹 sizin Mac qo艧ulmaq 蓹g蓹r, Siz, h蓹qiq蓹t蓹n, komp眉ter n蓹zar蓹t ed蓹 bil蓹rsiniz 1076 00:46:40,080 --> 00:46:42,550 proqram yazmaqla ki, infraq谋rm谋z谋 艧眉alar谋 vasit蓹sil蓹, 1077 00:46:42,550 --> 00:46:46,360 insan 蓹ll蓹ri oldu臒u tutulur, h蓹tta klaviatura toxunmadan. 1078 00:46:46,360 --> 00:46:49,135 Biz tez b枚l眉艧m蓹k ist蓹diyiniz fikir M蓹s蓹l蓹n, bu fikir. 1079 00:46:49,135 --> 00:46:51,428 >> [MUSIC PLAYING] 1080 00:46:51,428 --> 00:47:55,840 1081 00:47:55,840 --> 00:47:57,590 Bel蓹 ki, biz bir b眉t眉n var bunlar d蓹st蓹, 1082 00:47:57,590 --> 00:48:01,040 da Myo qol lentl蓹r adl谋 siz sizin 枚n kol 眉z蓹rind蓹 qoymaq 1083 00:48:01,040 --> 00:48:04,595 v蓹 sonra real n蓹zar蓹t ed蓹 bil蓹rsiniz d眉nya v蓹 ya bu kimi virtual d眉nya. 1084 00:48:04,595 --> 00:48:06,471 >> [MUSIC PLAYING] 1085 00:48:06,471 --> 00:49:17,580 1086 00:49:17,580 --> 00:49:20,920 Yoxsa, biz d蓹 b蓹zi Google var Kimi, s枚z眉n karton, 1087 00:49:20,920 --> 00:49:24,841 Siz qoymaq ki, bir karton qutu sizin onu telefonunuzda 眉z, lakin slide 1088 00:49:24,841 --> 00:49:27,590 ki, 艧眉艧蓹 qoymaq G枚zl蓹riniz蓹 h蓹qiq蓹t蓹n yax谋n telefon. 1089 00:49:27,590 --> 00:49:30,190 V蓹 Google Cardboard deyil $ 10 v蓹 ya $ 20 olduqca ucuz. 1090 00:49:30,190 --> 00:49:32,230 V蓹 bu ki莽ik linzalar var ki, bir az n枚vb蓹d蓹 off 1091 00:49:32,230 --> 00:49:35,900 Sizin insan 眉莽眉n ekranda image g枚zl蓹ri d蓹rinliyi hissi verm蓹k 1092 00:49:35,900 --> 00:49:39,550 bel蓹 ki, h蓹qiq蓹t蓹n bir 3D var ki, Siz qar艧谋s谋nda m眉hit. 1093 00:49:39,550 --> 00:49:42,927 Biz d蓹 b蓹zi Samsung Gear, olan Bu daha bahal谋 versiyas谋 1094 00:49:42,927 --> 00:49:46,010 lakin eyni bir slide bil蓹r Android telefon v蓹 ill眉ziya verm蓹k 1095 00:49:46,010 --> 00:49:48,309 of-- v蓹 ya t蓹cr眉b蓹 verm蓹k virtual reall谋q. 1096 00:49:48,309 --> 00:49:50,850 Bizim son iki d蓹qiq蓹, biz bu etm蓹k 眉莽眉n c蓹hd ist蓹diyiniz d眉艧眉nd眉m. 1097 00:49:50,850 --> 00:49:55,250 M蓹n Colton n蓹 layih蓹 ed蓹 bil蓹r, 蓹g蓹r Burada yaln谋z i艧taha itil蓹m蓹k 眉莽眉n, 1098 00:49:55,250 --> 00:49:58,442 M蓹n蓹 davam v蓹 atmaq imkan Burada b枚y眉k ekranda up. 1099 00:49:58,442 --> 00:49:59,400 M蓹n蓹 i艧谋qlar 枚ld眉rm蓹k ed蓹k. 1100 00:49:59,400 --> 00:50:02,290 Colton, siz ir蓹lid蓹 getm蓹k ist蓹yir蓹m v蓹 bir an 眉莽眉n h眉ceyr蓹 qoymaq 1101 00:50:02,290 --> 00:50:05,171 v蓹 眉z蓹rind蓹 g蓹lib m蓹rh蓹l蓹nin orta? 1102 00:50:05,171 --> 00:50:07,420 V蓹 project-- ist蓹yirsiniz bu Colton g枚r眉r n蓹. 1103 00:50:07,420 --> 00:50:10,560 >> 陌ndi burada Wi-Fi var Bu cihaz 眉莽眉n bel蓹 g眉cl眉 deyil 1104 00:50:10,560 --> 00:50:13,870 Bu super 莽ekici ki, lakin Colton s枚z眉n 1105 00:50:13,870 --> 00:50:15,710 bu sehirli Futuristik yerd蓹. 1106 00:50:15,710 --> 00:50:16,796 O, yaln谋z bir 艧蓹kil g枚r眉r. 1107 00:50:16,796 --> 00:50:19,920 Siz onun sol v蓹 sa臒 g枚z眉n眉 g枚r眉r眉k onun beyin birlikd蓹 stitching ki, 1108 00:50:19,920 --> 00:50:22,260 眉莽 枚l莽眉l眉 olan onun 眉z m眉hit. 1109 00:50:22,260 --> 00:50:24,319 O, yaln谋z burada menyu se莽imi var. 1110 00:50:24,319 --> 00:50:27,360 V蓹 yen蓹 d蓹, o, bu qulaql谋q qal谋c谋 bu bir Samsung telefonu il蓹 ki 1111 00:50:27,360 --> 00:50:29,080 kabelsiz bizim yer眉st眉 眉莽眉n layih蓹l蓹ndirilm蓹si. 1112 00:50:29,080 --> 00:50:30,349 陌ndi Mars, m蓹n hesab edir蓹m ki mi? 1113 00:50:30,349 --> 00:50:31,140 COLTON: M蓹n bel蓹 d眉艧眉n眉r蓹m. 1114 00:50:31,140 --> 00:50:32,181 I [i艧itilemez] 蓹min deyil蓹m. 1115 00:50:32,181 --> 00:50:34,250 [G眉l眉艧] 1116 00:50:34,250 --> 00:50:36,374 >> DAVID Malan: 莽谋x谋r Mars bu menyular var. 1117 00:50:36,374 --> 00:50:41,590 >> COLTON: [i艧itilemez] b蓹zi s蓹rin yerl蓹rd蓹 biz to-- getm蓹k ist蓹yirsinizs蓹 1118 00:50:41,590 --> 00:50:43,330 >> DAVID Malan: Harada biz getm蓹k ist蓹yirsiniz? 1119 00:50:43,330 --> 00:50:45,837 >> COLTON: [i艧itilemez] 1120 00:50:45,837 --> 00:50:48,170 DAVID Malan: V蓹 nin g枚r蓹k burada Colton indi biz蓹 alaraq. 1121 00:50:48,170 --> 00:50:48,961 COLTON: [i艧itilemez] 1122 00:50:48,961 --> 00:50:52,830 1123 00:50:52,830 --> 00:50:56,380 >> DAVID Malan: Bel蓹 ki, bir 莽ox var m眉xt蓹lif yerl蓹rd蓹 枚z眉n眉z ed蓹 bil蓹rsiniz. 1124 00:50:56,380 --> 00:51:00,590 FAPIs var hans谋 vasit蓹sil蓹 ed蓹 bil蓹rsiniz oyunlar v蓹 ya qar艧谋l谋ql谋 yazmaq 1125 00:51:00,590 --> 00:51:01,950 telefon, n蓹tic蓹d蓹, ax谋r. 1126 00:51:01,950 --> 00:51:03,908 Bel蓹 ki, h蓹qiq蓹t蓹n, yaln谋z mobil telefon app yaz谋l谋. 1127 00:51:03,908 --> 00:51:06,380 Lakin proqram say蓹sind蓹 v蓹 qrafik imkanlar谋, 1128 00:51:06,380 --> 00:51:08,765 陌ndi Colton bu deyil ki莽ik ki莽ik kottec. 1129 00:51:08,765 --> 00:51:10,515 V蓹 riski 枚z眉m眉z眉 b枚y眉k, 1130 00:51:10,515 --> 00:51:13,330 Colton v蓹 m蓹n 蓹traf谋nda qalmaq laz谋md谋r is蓹 burada sinif sonunda bu g眉n 1131 00:51:13,330 --> 00:51:14,300 Siz g蓹lib v蓹 oynamaq ist蓹yirsinizs蓹. 1132 00:51:14,300 --> 00:51:16,350 V蓹 biz onlar谋 g蓹tirm蓹k laz谋md谋r geri g蓹l蓹n h蓹ft蓹 h蓹m莽inin. 1133 00:51:16,350 --> 00:51:18,420 Daha olmadan, ado bu g眉n 眉莽眉n var. 1134 00:51:18,420 --> 00:51:21,990 Biz g蓹l蓹n h蓹ft蓹 g枚r蓹c蓹ksiniz. 1135 00:51:21,990 --> 00:51:24,140 >> [MUSIC - Ragga TWINS "BAD MAN"] 1136 00:51:24,140 --> 00:55:23,146