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
93
Crystal
david50407
0
280
Mail Server
david50407
0
87
Git 基礎講座
david50407
0
380
Other Decks in How-to & DIY
See All in How-to & DIY
未来大生の胃を支える函館グルメ
deflis
0
350
Dirbtinis intelektas dizainerio gyvenime
lekevicius
0
190
データエンジニアのためのテクニカルサポートとLLM
yutomatsunoo
0
1k
How to create better speaker proposals
logico_jp
2
370
球体型ロボットと複合現実を活用したマルチエージェントシステム - M5stack Japan Tour 2024 Spring Osaka
tichise
0
190
さらなるアウトプットに、Let's ライトニングトーク! ― LTのやり方
ma2shita
2
520
What I Talk About When I Talk About Social Media
idealhack
0
110
地域JAWSの現状とベストプラクティス
awsjcpm
0
360
M5Stickと超小型エッジAIカメラ「AITRIOS」
hoshinoresearch
0
300
Raspberry PiではじめるKiCad入門 / 20240226-rpi-jam
akkiesoft
1
3.3k
Terra Charge|普通充電器ご利用ガイドブック / Terra Charge Ordinary Charger Guidebook
contents
1
110
「おうちクラウド」が今も熱い!
hirosat
2
1k
Featured
See All Featured
It's Worth the Effort
3n
183
27k
Testing 201, or: Great Expectations
jmmastey
38
7.1k
Into the Great Unknown - MozCon
thekraken
32
1.5k
Rebuilding a faster, lazier Slack
samanthasiow
79
8.7k
Keith and Marios Guide to Fast Websites
keithpitt
409
22k
Gamification - CAS2011
davidbonilla
80
5k
Site-Speed That Sticks
csswizardry
0
31
A designer walks into a library…
pauljervisheath
204
24k
Six Lessons from altMBA
skipperchong
27
3.5k
Visualization
eitanlees
145
15k
Making the Leap to Tech Lead
cromwellryan
133
8.9k
A better future with KSS
kneath
238
17k
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