第一次接案就上手 PHP or RoR?

Slide 1

Slide 1 text

ୈҰ࣍઀Ҋब্ख PHP or RoR?

Slide 2

Slide 2 text

ࡏഝ೭લ

Slide 3

Slide 3 text

ࡏഝ೭લ

Slide 4

Slide 4 text

• David Kuo a.k.a. Davy Who am I ?

Slide 5

Slide 5 text

• David Kuo a.k.a. Davy • [email protected] Who am I ?

Slide 6

Slide 6 text

• David Kuo a.k.a. Davy • [email protected] • Love Ruby Who am I ?

Slide 7

Slide 7 text

• David Kuo a.k.a. Davy • [email protected] • Love Ruby • தԝେላࢿ؅ܥҰ೥ڃ Who am I ?

Slide 8

Slide 8 text

• David Kuo a.k.a. Davy • [email protected] • Love Ruby • தԝେላࢿ؅ܥҰ೥ڃ • ؆ᄸိ㘸बੋࢮላੜҰຕ Who am I ?

Slide 9

Slide 9 text

ຊ࣍Ҋྫհ঺ urschool.org

Slide 10

Slide 10 text

• ࣌ݶɿ3 ݸ݄ Ҋྫհ঺

Slide 11

Slide 11 text

• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL Ҋྫհ঺

Slide 12

Slide 12 text

Ҋྫհ঺

Slide 13

Slide 13 text

Ҋྫհ঺ ࡏഝཪ https://www.youtube.com/watch?v=1M_U_rOY5PM

Slide 14

Slide 14 text

• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • ૊һɿPM * 1ɼRD * 1ɼސ໰ * 1 Ҋྫհ঺

Slide 15

Slide 15 text

• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • ૊һɿPM * 1ɼRD * 1ɼސ໰ * 1 Ҋྫհ঺

Slide 16

Slide 16 text

• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • ૊һɿPM * 1ɼRD * 1ɼސ໰ * 1 • धٻɿ༴༗ Tagging system త࿦ஃɼ  like Stack Overﬂow Ҋྫհ঺

Slide 17

Slide 17 text

Ҋྫհ঺

Slide 18

Slide 18 text

㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ

Slide 19

Slide 19 text

ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ

Slide 20

Slide 20 text

ސ໰ɿզ೺ܥ౷Ս޷ྃ 㘸ނࣄ࣌ؒ ސ໰ɿࡏ BitBucket ։ྃҰݸ Project

Slide 21

Slide 21 text

Davyɿ؃ىိ޷૾ؐෆࡨɼഝੋॄኄ Framework ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ

Slide 22

Slide 22 text

ސ໰ɿഝੋ CodeIgniter Davyɿ؃ىိ޷૾ؐෆࡨɼഝੋॄኄ Framework ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ

Slide 23

Slide 23 text

ސ໰ɿഝੋ CodeIgniter Davyɿ؃ىိ޷૾ؐෆࡨɼഝੋॄኄ Framework ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ

Slide 24

Slide 24 text

ԙੋ

Slide 25

Slide 25 text

ԙੋ ቮ஌༻Ր

Slide 26

Slide 26 text

ԙੋ

Slide 27

Slide 27 text

ԙੋ SITE_Controller ?

Slide 28

Slide 28 text

Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 29

Slide 29 text

ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 30

Slide 30 text

Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 31

Slide 31 text

ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 32

Slide 32 text

DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 33

Slide 33 text

ސ໰ɿᔒࡨଞՄҎ٣ CRUD తૢ࡞ DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 34

Slide 34 text

ސ໰ɿՄੋଞ၇ෆೳҰى༻ ސ໰ɿᔒࡨଞՄҎ٣ CRUD తૢ࡞ DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝

Slide 35

Slide 35 text

10 ݄։࢝

Slide 36

Slide 36 text

10 ݄։࢝ Σ(oдolll)

Slide 37

Slide 37 text

ഝཫཁ์ඪ୊

Slide 38

Slide 38 text

߶߶࠽ෆੋ哏

Slide 39

Slide 39 text

ncucc.davy.tw/guestbook

Slide 40

Slide 40 text

ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝

Slide 41

Slide 41 text

Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝

Slide 42

Slide 42 text

่௵త։࢝

Slide 43

Slide 43 text

Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝

Slide 44

Slide 44 text

ސ໰ɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝

Slide 45

Slide 45 text

ސ໰ɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝

Slide 46

Slide 46 text

ސ໰ɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝

Slide 47

Slide 47 text

SQL

Slide 48

Slide 48 text

SQL SELECT table.* FROM (SELECT table.* …) AS A WHERE `table`.`counts` = …

Slide 49

Slide 49 text

SQL SELECT table.* FROM (SELECT table.* …) AS A WHERE `table`.`counts` = … ?