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

Transcript

1. ୈҰ࣍઀Ҋब্ख PHP or RoR?
2. ࡏഝ೭લ
3. ࡏഝ೭લ
4. • David Kuo a.k.a. Davy Who am I ?
5. • David Kuo a.k.a. Davy • me@davy.tw Who am I ?
6. • David Kuo a.k.a. Davy • me@davy.tw • Love Ruby Who am I ?
7. • David Kuo a.k.a. Davy • me@davy.tw • Love Ruby • தԝେላࢿ؅ܥҰ೥ڃ Who am I ?
8. • David Kuo a.k.a. Davy • me@davy.tw • Love Ruby • தԝେላࢿ؅ܥҰ೥ڃ • ؆ᄸိ㘸बੋࢮላੜҰຕ Who am I ?
9. ຊ࣍Ҋྫհ঺ urschool.org
10. • ࣌ݶɿ3 ݸ݄ Ҋྫհ঺
11. • ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL Ҋྫհ঺
12. Ҋྫհ঺
13. Ҋྫհ঺ ࡏഝཪ https://www.youtube.com/watch?v=1M_U_rOY5PM
14. • ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • ૊һɿPM * 1ɼRD * 1ɼސ໰ * 1 Ҋྫհ঺
15. • ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • ૊һɿPM * 1ɼRD * 1ɼސ໰ * 1 Ҋྫհ঺
16. • ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • ૊һɿPM * 1ɼRD * 1ɼސ໰ * 1 • धٻɿ༴༗ Tagging system త࿦ஃɼ
 like Stack Overflow Ҋྫհ঺
17. Ҋྫհ঺
18. 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ
19. ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ
20. ސ໰ɿզ೺ܥ౷Ս޷ྃ 㘸ނࣄ࣌ؒ ސ໰ɿࡏ BitBucket ։ྃҰݸ Project
21. Davyɿ؃ىိ޷૾ؐෆࡨɼഝੋॄኄ Framework ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ
22. ސ໰ɿഝੋ CodeIgniter Davyɿ؃ىိ޷૾ؐෆࡨɼഝੋॄኄ Framework ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ
23. ސ໰ɿഝੋ CodeIgniter Davyɿ؃ىိ޷૾ؐෆࡨɼഝੋॄኄ Framework ސ໰ɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސ໰ɿզ೺ܥ౷Ս޷ྃ
24. ԙੋ
25. ԙੋ ቮ஌༻Ր
26. ԙੋ
27. ԙੋ SITE_Controller ?
28. Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
29. ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
30. Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
31. ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
32. DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
33. ސ໰ɿᔒࡨଞՄҎ٣ CRUD తૢ࡞ DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
34. ސ໰ɿՄੋଞ၇ෆೳҰى༻ ސ໰ɿᔒࡨଞՄҎ٣ CRUD తૢ࡞ DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސ໰ɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိ೗ࠑ...ಹഝݸ MEMBER_Controller 䏆 ސ໰ɿഝੋզᩋଞࣗಈ፛औ໨લ࢖༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
35. 10 ݄։࢝
36. 10 ݄։࢝ Σ(oдolll)
37. ഝཫཁ์ඪ୊
38. ߶߶࠽ෆੋ哏
39. ncucc.davy.tw/guestbook
40. ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝
41. Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝
42. ่௵త։࢝
43. Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝
44. ސ໰ɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝
45. ސ໰ɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝
46. ސ໰ɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ኷؆ᄸɼब༻ sub-query ׬੒㠧ʂ ސ໰ɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ໵ཁ ่௵త։࢝
47. SQL
48. SQL SELECT table.* FROM (SELECT table.* …) AS A WHERE `table`.`counts` = …
49. SQL SELECT table.* FROM (SELECT table.* …) AS A WHERE `table`.`counts` = … ?
50. ༻ sub-query ᰈવෆ။༻ alias త໊᜝ʁ ໡ᴍ
51. Davyɿڭ࿅ɼզՄෆՄҎ׵ Railsʁ 11 ݄ॳ
52. ސ໰ɿ Davyɿڭ࿅ɼզՄෆՄҎ׵ Railsʁ 11 ݄ॳ
53. ސ໰ɿ Davyɿڭ࿅ɼզՄෆՄҎ׵ Railsʁ 11 ݄ॳ
54. PM ɿഝᒬ။ိෆٴ㠧ʁ Davyɿڭ࿅ɼզՄෆՄҎ׵ Railsʁ 11 ݄ॳ
55. Davyɿզ޷ྃ 11 ݄ୈೋݸᜌ፨
56. urschool.org
57. PM ɿᄌᯪ໵ଠڧྃ㠧 Davyɿզ޷ྃ 11 ݄ୈೋݸᜌ፨
58. CodeIgniter Ruby on Rails
59. Routing
60. Routing
61. Controller & Model
62. Controller & Model
63. Davyɿᔒ໰୊ʂ PM ɿզ၇धཁ FaceBook ొೖ Ruby Gems
64. Ruby Gems
65. Ruby Gems
66. Q&A urschool.org