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
GPT-4oに遅刻理由を考えてもらうボタン #gpt_4o #iotlt #chatgpt
n0bisuke2
0
380
とある航空会社の飛行機の乗り方をお教えします。/20240913-lt
kwada
3
300
JAWS-UG山梨第0回 AWSのユーザーコミュニティ支援
awsjcpm
0
170
中指立てたか判定IoT #iotlt #p5js
n0bisuke2
0
290
JAWS-UGとAWS - JAWS-UG彩の国埼玉設立のお祝い
awsjcpm
2
490
LLMはTRPGのGMができる(確信)
kgmkm
0
1k
バーチャルバナナとリアルバナナ #iotlt #TouchDesigner
n0bisuke2
0
160
人を補助するAI ~AIとの壁打ちがきっかけになる~ #共創AIミートアップ
ishikiemo
0
360
未来の投げ銭箱
inoue2002
2
110
JAWS-UG Fukuoka - AWS re:Invent 2024 re:Cap AWS Community Perspective
awsjcpm
2
160
音に負けない!子どもが騒いでいる脇でも快適オンラインMTGの秘伝
kaitou
0
410
LT(Lightning Talk)のドキドキ感を共有する IoT ぼっとを作った話
scbc1167
1
210
Featured
See All Featured
The Language of Interfaces
destraynor
158
25k
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
17
950
How to Think Like a Performance Engineer
csswizardry
24
1.7k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
107
19k
Visualization
eitanlees
146
16k
We Have a Design System, Now What?
morganepeng
53
7.7k
Unsuck your backbone
ammeep
671
58k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
31
1.3k
Become a Pro
speakerdeck
PRO
28
5.4k
Mobile First: as difficult as doing things right
swwweet
223
9.7k
How GitHub (no longer) Works
holman
314
140k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
125
52k
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