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
410
GraphQL 簡介
david50407
0
110
2016 計中短期資訊推廣課程 —— 多人線上繪圖板
david50407
0
140
Open Source Software and Culture -- Crystal
david50407
1
200
簡潔優雅的語言 —— Crystal
david50407
0
170
各種工具介紹
david50407
1
99
Crystal
david50407
0
280
Mail Server
david50407
0
96
Git 基礎講座
david50407
0
400
Other Decks in How-to & DIY
See All in How-to & DIY
安全に失敗するための手遊び-未定義動作を引き出そう-
zilmina
0
610
新婚19年目から学ぶ夫婦円満の正しい歩き方 / Life is beautiful
soudai
PRO
12
4.6k
【技術カンファレンス運営の裏側】Iwaken Lab 技術好き学生の近況報告 & ことみんさんに技術カンファレンス運営の裏側を聞いちゃう会
kotomin_m
5
1.6k
球体型ロボットと複合現実を活用したマルチエージェントシステム - M5stack Japan Tour 2024 Spring Osaka
tichise
0
300
JAWS-UGについて JAWS-UG TOHOKU [青森] 弘前開催
awsjcpm
0
200
JAWS-UG会津 & JP Stripes会津 合同勉強会 JAWS-UGとAWSコミュニティプログラムアップデート
awsjcpm
0
100
エンジニアになって2年間で学んだこと
kaiphoenix
0
170
JAWS-UG/AWSコミュニティプログラムのご紹介 - JAWS-UG 佐賀
awsjcpm
2
130
JAWS-UGのご紹介 JAWS-UGとは?
awsjcpm
0
5.1k
Invitation to Okinawa.rb in 2024
yasslab
PRO
1
840
How to make the Groovebox
asonas
2
1.5k
EasyEDA機能紹介と今後の計画 (中国語) プロジェクトマネージャ罗德松
takasumasakazu
0
130
Featured
See All Featured
Optimising Largest Contentful Paint
csswizardry
37
3.3k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
657
60k
Stop Working from a Prison Cell
hatefulcrawdad
270
20k
Designing for Performance
lara
609
69k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Site-Speed That Sticks
csswizardry
10
660
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
30
2.1k
A designer walks into a library…
pauljervisheath
207
24k
Scaling GitHub
holman
459
140k
Build The Right Thing And Hit Your Dates
maggiecrowley
36
2.8k
The World Runs on Bad Software
bkeepers
PRO
69
11k
How to Think Like a Performance Engineer
csswizardry
24
1.7k
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