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
120
2016 計中短期資訊推廣課程 —— 多人線上繪圖板
david50407
0
140
Open Source Software and Culture -- Crystal
david50407
1
200
簡潔優雅的語言 —— Crystal
david50407
0
170
各種工具介紹
david50407
1
100
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
AWS User Community - JAWS-UG/AWS ユーザーコミュニティのご紹介
awsjcpm
1
200
miiboとamiibo繋げてみた。 #miibo #amiibo #iotlt
n0bisuke2
1
350
ブロックテーマをゴリゴリに使い倒してサイトを作った話 / Kansai WordPress Meetup 2025 01 25
tbshiki
1
560
【技術カンファレンス運営の裏側】Iwaken Lab 技術好き学生の近況報告 & ことみんさんに技術カンファレンス運営の裏側を聞いちゃう会
kotomin_m
5
1.6k
在宅フルリモートワークを可能にするスキルと知識n連発! / how to more effective remoteworking
masaru_b_cl
3
1.1k
バッドプラクティスから学ぶハワイアン航空で行く re:Invent
kentosuzuki
0
270
How to create better speaker proposals
logico_jp
2
900
3ヶ月でできる! 探査機自作ゼミ教材自作入門
sksat
6
2.6k
人を補助するAI ~AIとの壁打ちがきっかけになる~ #共創AIミートアップ
ishikiemo
0
380
AWS re:Invent 2024 re:Cap – AWS Community Perspective / JAWS-UG新潟
awsjcpm
0
160
Raspberry Pi Connectを使って #Manus => Node-RED操作チャレンジ #iotlt vol121
n0bisuke2
0
130
未来大生の胃を支える函館グルメ
deflis
0
500
Featured
See All Featured
Code Reviewing Like a Champion
maltzj
524
40k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.6k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.8k
Documentation Writing (for coders)
carmenintech
72
4.9k
The Pragmatic Product Professional
lauravandoore
35
6.7k
Testing 201, or: Great Expectations
jmmastey
43
7.6k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
The Cult of Friendly URLs
andyhume
79
6.5k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
50
5.5k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
8
690
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
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