Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
第一次接案就上手 PHP or RoR?
Search
David Kuo (Davy)
March 15, 2014
How-to & DIY
4
1.6k
第一次接案就上手 PHP or RoR?
David Kuo (Davy)
March 15, 2014
Tweet
Share
More Decks by David Kuo (Davy)
See All by David Kuo (Davy)
Operator SDK 帶你玩轉 Kubernetes
david50407
0
360
GraphQL 簡介
david50407
0
110
2016 計中短期資訊推廣課程 —— 多人線上繪圖板
david50407
0
130
Open Source Software and Culture -- Crystal
david50407
1
200
簡潔優雅的語言 —— Crystal
david50407
0
160
各種工具介紹
david50407
1
92
Crystal
david50407
0
280
Mail Server
david50407
0
86
Git 基礎講座
david50407
0
380
Other Decks in How-to & DIY
See All in How-to & DIY
M5Stickと超小型エッジAIカメラ「AITRIOS」
hoshinoresearch
0
300
GPT-4oに遅刻理由を考えてもらうボタン #gpt_4o #iotlt #chatgpt
n0bisuke2
0
240
[너구리랑! 회고 밋업 2023] GTD & PARA -머릿속이 복잡하던 일상에 적용한 정리법 // 토르 님
develop_neoguri
1
310
未来大生の胃を支える函館グルメ
deflis
0
350
お家で育てる制御実験環境
zilmina
0
860
とある航空会社の飛行機の乗り方をお教えします。/20240913-lt
kwada
3
230
GPTsとラズパイ5で監視カメラを作ってみた #iotlt #chatgpt #raspberrypi
n0bisuke2
0
480
一番やさしいDJ入門 2024
stefafafan
6
1.8k
Notionでの快適メモ術
ayumu11
0
980
Terra Charge|EVコンセントご利用ガイドブック / Terra Charge EV Charger Guidebook
contents
0
1k
JAWS-UGから学んだコミュニティの成功要因 (Success Factors)
awsjcpm
3
320
drumstick_jacket.pdf
lyh125
1
520
Featured
See All Featured
Building Applications with DynamoDB
mza
90
6.1k
Git: the NoSQL Database
bkeepers
PRO
427
64k
How to Ace a Technical Interview
jacobian
276
23k
Imperfection Machines: The Place of Print at Facebook
scottboms
265
13k
Keith and Marios Guide to Fast Websites
keithpitt
409
22k
Building a Scalable Design System with Sketch
lauravandoore
459
33k
Being A Developer After 40
akosma
86
590k
Intergalactic Javascript Robots from Outer Space
tanoku
269
27k
Visualization
eitanlees
145
15k
Ruby is Unlike a Banana
tanoku
97
11k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
280
13k
4 Signs Your Business is Dying
shpigford
180
21k
Transcript
ୈҰ࣍Ҋब্ख PHP or RoR?
ࡏഝ೭લ
ࡏഝ೭લ
• David Kuo a.k.a. Davy Who am I ?
• David Kuo a.k.a. Davy •
[email protected]
Who am I
?
• David Kuo a.k.a. Davy •
[email protected]
• Love Ruby
Who am I ?
• David Kuo a.k.a. Davy •
[email protected]
• Love Ruby
• தԝେላࢿܥҰڃ Who am I ?
• David Kuo a.k.a. Davy •
[email protected]
• Love Ruby
• தԝେላࢿܥҰڃ • ؆ᄸိ㘸बੋࢮላੜҰຕ Who am I ?
ຊ࣍Ҋྫհ urschool.org
• ࣌ݶɿ3 ݸ݄ Ҋྫհ
• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL Ҋྫհ
Ҋྫհ
Ҋྫհ ࡏഝཪ https://www.youtube.com/watch?v=1M_U_rOY5PM
• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • һɿPM *
1ɼRD * 1ɼސ * 1 Ҋྫհ
• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • һɿPM *
1ɼRD * 1ɼސ * 1 Ҋྫհ
• ࣌ݶɿ3 ݸ݄ • ٕज़ɿPHP + MySQL • һɿPM *
1ɼRD * 1ɼސ * 1 • धٻɿ༴༗ Tagging system తஃɼ like Stack Overflow Ҋྫհ
Ҋྫհ
㘸ނࣄ࣌ؒ ސɿզܥ౷Սྃ
ސɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސɿզܥ౷Սྃ
ސɿզܥ౷Սྃ 㘸ނࣄ࣌ؒ ސɿࡏ BitBucket ։ྃҰݸ Project
Davyɿىိ૾ؐෆࡨɼഝੋॄኄ Framework ސɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސɿզܥ౷Սྃ
ސɿഝੋ CodeIgniter Davyɿىိ૾ؐෆࡨɼഝੋॄኄ Framework ސɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސɿզܥ౷Սྃ
ސɿഝੋ CodeIgniter Davyɿىိ૾ؐෆࡨɼഝੋॄኄ Framework ސɿࡏ BitBucket ։ྃҰݸ Project 㘸ނࣄ࣌ؒ ސɿզܥ౷Սྃ
ԙੋ
ԙੋ ቮ༻Ր
ԙੋ
ԙੋ SITE_Controller ?
Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
ސɿഝੋզᩋଞࣗಈऔલ༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
Davyɿݪိࠑ...ಹഝݸ MEMBER_Controller 䏆 ސɿഝੋզᩋଞࣗಈऔલ༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
ސɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိࠑ...ಹഝݸ MEMBER_Controller 䏆 ސɿഝੋզᩋଞࣗಈऔલ༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိࠑ...ಹഝݸ MEMBER_Controller 䏆 ސɿഝੋզᩋଞࣗಈऔલ༻ऀతํ๏ Davyɿഝݸ
SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
ސɿᔒࡨଞՄҎ٣ CRUD తૢ࡞ DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိࠑ...ಹഝݸ MEMBER_Controller
䏆 ސɿഝੋզᩋଞࣗಈऔલ༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
ސɿՄੋଞ၇ෆೳҰى༻ ސɿᔒࡨଞՄҎ٣ CRUD తૢ࡞ DavyɿREST_Controller बੋࢧԉ RESTful ሣ㠧 ސɿबੋᔒొೖత။Ҡಈ౸ొೖท໘ Davyɿݪိࠑ...ಹഝݸ
MEMBER_Controller 䏆 ސɿഝੋզᩋଞࣗಈऔલ༻ऀతํ๏ Davyɿഝݸ SITE_Controller ੋॄኄ㠷ʁ 10 ݄։࢝
10 ݄։࢝
10 ݄։࢝ Σ(oдolll)
ഝཫཁ์ඪ
߶߶࠽ෆੋ哏
ncucc.davy.tw/guestbook
ސɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ཁ ่௵త։࢝
Davyɿᡒىိ؆ᄸɼब༻ sub-query 㠧ʂ ސɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ཁ ่௵త։࢝
่௵త։࢝
Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ؆ᄸɼब༻ sub-query 㠧ʂ ސɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ཁ ่௵త։࢝
ސɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ؆ᄸɼब༻ sub-query 㠧ʂ ސɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ཁ ่௵త։࢝
ސɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ؆ᄸɼब༻ sub-query 㠧ʂ ސɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ཁ ่௵త։࢝
ސɿ... Davyɿ䏊ʁෆ။ಈɼզݚڀݚڀ Davyɿᡒىိ؆ᄸɼब༻ sub-query 㠧ʂ ސɿզ၇తᚙจཁ༗൛ຊ߇੍ᄛʂ࿈ Tag ཁ ่௵త։࢝
SQL
SQL SELECT table.* FROM (SELECT table.* …) AS A WHERE
`table`.`counts` = …
SQL SELECT table.* FROM (SELECT table.* …) AS A WHERE
`table`.`counts` = … ?
༻ sub-query ᰈવෆ။༻ alias త໊ʁ ᴍ
Davyɿڭ࿅ɼզՄෆՄҎ Railsʁ 11 ݄ॳ
ސɿ Davyɿڭ࿅ɼզՄෆՄҎ Railsʁ 11 ݄ॳ
ސɿ Davyɿڭ࿅ɼզՄෆՄҎ Railsʁ 11 ݄ॳ
PM ɿഝᒬ။ိෆٴ㠧ʁ Davyɿڭ࿅ɼզՄෆՄҎ Railsʁ 11 ݄ॳ
Davyɿզྃ 11 ݄ୈೋݸᜌ፨
urschool.org
PM ɿᄌᯪଠڧྃ㠧 Davyɿզྃ 11 ݄ୈೋݸᜌ፨
CodeIgniter Ruby on Rails
Routing
Routing
Controller & Model
Controller & Model
Davyɿᔒʂ PM ɿզ၇धཁ FaceBook ొೖ Ruby Gems
Ruby Gems
Ruby Gems
Q&A urschool.org