CakePHP ‚̂�N‚��‚µ‚��H‚�~•û

‚o‚g‚oƒ†[ƒU[ƒYƒJƒ“ƒtƒ@ƒŒƒ“ƒX‚ªŠJÃ‚³‚ê‚Ü‚·B

PHPƒJƒ“ƒtƒ@ƒŒƒ“ƒX2007ƒvƒƒOƒ‰ƒ€ŠT—v
http://www.php.gr.jp/seminar/20070901/prog.php

PHP Framework Update‚Ƃ��‚¤ƒe[ƒ}‚Ì‚à‚ƂɁA‰º‹L‚Ì•ûX‚ªÅV‚̏󋵂ð˜b‚³‚ê‚é‚»‚¤‚Å‚·B

symfonyFŠ”Ž®‰ïŽÐƒfƒBƒm ŒŽ‹{‹I–ö
CakePHPFŠ”Ž®‰ïŽÐƒJƒTƒŒƒAƒ‹ ˆÀ“¡—S‰î
Piece FrameworkFŠ”Ž®‰ïŽÐƒAƒCƒeƒ}ƒ“ ‹v•Û“ÖŒ[
EthnaFƒOƒŠ[Š”Ž®‰ïŽÐ ˆêˆä ’
Zend Framework:(–��’è)

CakePHP‚ÉŠÖ‚µ‚ẮA‚�}‚ê‚܂Ő¸—Í“I‚ɃŒƒNƒ`ƒƒ[‚ðs‚Á‚Ä‚«‚½ˆÀ“¡—S‰î‚³‚ñ‚ª‚Ü‚Æ‚ß‚Ü‚·B

ˆÀ“¡‚³‚ñ‚̃TƒCƒgFCakePHP‚̉½‚©
http://puyo2.upper.jp/cake/

’P‚È‚éŠT—v‚É‚Æ‚Ç‚Ü‚ç‚Ȃ��u‰½‚©v‚ª‚ ‚é‚悤‚Å‚·‚̂ŁAoÈ‚³‚ê‚é•û‚ÍŠy‚µ‚݂ɁB

‚�}‚ꌩ‚Ü‚µ‚½H
"PHP‚ÆRails‚ð”ä‚�~‚Ä‚à‚µ‚傤‚ª‚Ȃ��‚Å‚µ‚å"‚Ƃ��‚¤º‚ɂ�}‚½‚¦‚āA"Rails vs CakePHP"ƒo[ƒWƒ‡ƒ“‚Å‚·B

‚Å‚àA‚æ‚­ƒtƒŒ[ƒ€ƒ[ƒN‚Ìó‹µ‚ð—‰ð‚µ‚Ä‚ï¿½ï¿½‚él‚ªì‚ê‚΁AAkelos‚©PHP on TRAX‚ª“ü‚Á‚Ä‚«‚½‚Í‚¸‚Å‚·‚ª‚Ë‚\BCakePHP‚́A‚æ‚­‚àˆ«‚­‚àARails‚ÌŠÛƒRƒs[‚Å‚Í‚ ‚è‚Ü‚¹‚ñB‚Ü‚ŸACakePHPg‚àh’–Ú‚³‚ê‚Ä‚«‚½A‚Ƃ��‚¤‚�}‚Æ‚Å‚µ‚傤‚©B

PHP‚̃ZƒLƒ…ƒŠƒeƒB‚ɏڂµ‚��‘åŠ_‚³‚ñ‚̃uƒƒO

SET NAMES‚Í‹ÖŽ~

iˆø—pj
============
ÆŽã«‚Ìà–¾‚Í–Ê“|‚Å‚·‚ª’ˆÓŽ–€‚ÍŠÈ’P‚Å‚·BuDBMS‚ðƒAƒvƒŠƒP[ƒVƒ‡ƒ“‚©‚ç—˜—p‚·‚éê‡A•ï¿½ï¿½ŽšƒGƒ“ƒR[ƒfƒBƒ“ƒOÝ’è‚Í•K‚¸API‚ð—˜—p‚·‚év‚‚܂èuSET NAMESiSET CLIENT_ENCODING“™‚à)‚Í‹ÖŽ~v‚Å‚·B
============

“ú–{ŒêˆÈŠO‚Ì‹LŽ–‚ł́AuSET NAMES‚ðŽg‚Á‚Ă͂��‚¯‚Ȃ��v‚Ƃ܂ŏ‘‚��‚��‚é‹LŽ–‚ªŒ©‚‚©‚ç‚È‚©‚Á‚½‚̂ŁA‚��‚Ü‚¾‚·‚ñ‚È‚è‚Æ”[“¾‚Å‚«‚��‚Ȃ��‚Ì‚Å‚·‚ªA¡ŒãAMySQL 4.1ˆÈã‚ð“ü‚ꂽ‹¤—LƒT[ƒo‚È‚ñ‚©‚Å‚Í‚Ç‚¤‚·‚ê‚΂��‚��‚ñ‚Å‚µ‚傤‚©cB

gSET NAMES sjsh‚É–â‘肪‚ ‚éA‚Ƃ��‚¤‹LŽ–‚͉º‹L‚É‚ ‚è‚Ü‚µ‚½B

t_komura‚Ì“ú‹L
addslashes() ‚É‚æ‚é SQL •ï¿½ï¿½Žš—ñ‚̃GƒXƒP[ƒv‰ñ”ð–â‘è

hoshikuzu | star_dust ‚̏‘Ö
¡PHP —˜—pŽž‚É Shift_JIS ‚Å addslashes() ‚É‚æ‚éƒGƒXƒP[ƒvˆ—‚Ɂ@SQL ƒCƒ“ƒWƒFƒNƒVƒ‡ƒ“‰Â”\‚ÈŒŠ

gmysql_real_escape_string()‚Å‚àSET NAMES sjis;“™‚ðŽÀs‚µ‚½Œã‚ÉŽg‚¤‚Æ2ƒoƒCƒg–Ú‚Ì0x5C•ï¿½ï¿½Žš‚ªƒGƒXƒP[ƒv‚³‚ê‚Ȃ��‚悤‚Å‚·Bh‚Æ‚ ‚Á‚½‚̂ŁA

"0x5C SQL injection"
‚È‚Ç‚Å’²‚�~‚é‚ƁA‰º‹L‚̃y[ƒW‚ªB

http://www.postgresql.org/docs/techdocs.50
‚Å‚àA‚�}‚̃y[ƒW‚ɂ́A

"this includes at least SJIS, BIG5, GBK, GB18030, and UHC."

‚Æ‚ ‚è‚Ü‚·B‘åŠ_‚³‚ñ‚́A

SET NAMES ujis
SET NAMES utf8
SET NAMES binary

‚à‚Ý‚ñ‚ÈŽg‚¤‚ȁA‚ÆŒ¾‚í‚ê‚��‚é‚Ì‚Å‚µ‚傤‚©cB
‚�}‚Ì‚ ‚½‚è‚ɏڂµ‚��•ûA‚Ç‚È‚½‚©‹³‚¦‚Ä‚­‚¾‚³‚��B

Œë‰ð‚ª‚Ȃ��‚悤‚ÉŒ¾‚Á‚�N‚­‚ƁAŽ„‚ÍCakePHPƒ†[ƒU‚ŁA‚�N‚»‚ç‚­¡Œã‚à“–•ª‚ÍCakePHP‚ðŽg‚��‘�}‚¯‚é‚̂ł͂Ȃ��‚©A‚ÆŽv‚��‚Ü‚·B

Akelos‚à‚È‚©‚È‚©‚��‚��‚ÆŽv‚Á‚ĈȑO‚æ‚è‹C‚É‚µ‚��‚Ü‚·‚ªAŒ»ó‚ł́A‚‚��Å‹ßŒöŠJ‚³‚ꂽ‚΂©‚è‚́Aƒo[ƒWƒ‡ƒ“0.8‚̂ЂƂèƒvƒƒWƒFƒNƒg‚Å‚·BƒtƒH[ƒ‰ƒ€‚ðŒ©‚é‚Æ•ª‚©‚è‚Ü‚·‚ªA‚Ü‚¾ƒoƒO‚‚Ԃµ‚ª•K—v‚¾‚ÆŽv‚��‚Ü‚·B‚»‚ê‚ɁARails‚ÌŠ®‘SƒRƒs[‚ð–ÚŽw‚·‚Ì‚Å‚ ‚ê‚΁APHP on TRAX ‚È‚Ç‚àŠù‚É’·‚��ŠÔ‘��Ý‚µ‚��‚Ü‚·‚µA‚»‚à‚»‚àRails‚Ì•~‹‚ª‰º‚ª‚Á‚Ä‚«‚��‚é‚킯‚Å‚·‚©‚çARails‚ł��‚��‚̂ł͂Ȃ��‚©A‚ƁB

‚Ü‚½A‚·‚Å‚ÉCakePHP‚Í‚©‚È‚è‚Ì‘å‚«‚ȃRƒ~ƒ…ƒjƒeƒB‚É”­“W‚µ‚��‚é‚̂ŁA‚»‚�}‚©‚çV‚µ‚��ƒCƒmƒx[ƒVƒ‡ƒ“‚ªï¿½ï¿½‚Ü‚ê‚é‰Â”\«‚à‚ ‚èACakePHP‚Ì”­“W«‚́AAkelos‚âPHP on TRAX‚æ‚è‘å‚«‚��‚ÆŽv‚��‚Ü‚·B

‚È‚É‚µ‚ëAƒRƒ~ƒ…ƒjƒeƒBi‰pŒêj‚Å‹c˜_‚ð[‚߂Ă䂯‚΁ARails‚É‚Í‚È‚©‚Á‚½‚悤‚È‹Zp‚ª“Ë‚«i‚ñ‚Å‚ä‚­‚©‚à‚µ‚ê‚Ȃ��‚킯‚Å‚·BWEB“‡ŠJ”­ŠÂ‹«‚ªŒ»‚ê‚é‚©‚à‚µ‚ê‚Ȃ��A‚ ‚Á‚Æ‹Á‚­ƒfƒoƒbƒK‚ªo‚Ä‚­‚é‚©‚à‚µ‚ê‚Ȃ��Aƒ‚ƒfƒ‹‚̏ˆ—‚à¡ŒãA‚Ç‚ñ‚ȉü—Ç‚ª‚͂��‚Ü‚é‚Ì‚©AŠy‚µ‚Ý‚Å‚·B

RailsƒRƒs[‚̏ꍇ‚́Au‚»‚êARails‚��‚á‚Ȃ��v‚ÆŒ¾‚í‚ꂽŽž“_‚Å•sÌ—p‚É‚È‚Á‚Ä‚µ‚܂��‚Ü‚·‚æ‚ˁcB

‚Æ‘O’u‚«‚͂�}‚�}‚Ü‚Å‚É‚µ‚āA‚â‚Í‚èCakePHPƒtƒŒ[ƒ€ƒ[ƒN‚Ì“Á«ãAg‹êŽè‚ȁhƒvƒƒWƒFƒNƒg‚à‚ ‚é‚ÆŽv‚��‚Ü‚·B

“Á‚ɁAgŠù‘��‚̃f[ƒ^ƒx[ƒX‚ª‚·‚Å‚É‚ ‚èA‚»‚ê‚ðˆµ‚¤‚o‚g‚oƒVƒXƒeƒ€‚ðì‚éê‡h‚ɂ́A³’¼AŒ»Ý‚̂Ƃ�}‚ë‚́A‘¼‚̃tƒŒ[ƒ€ƒ[ƒN‚ðŽg‚Á‚½‚Ù‚¤‚ª‚æ‚��ê‡‚³‚¦‚ ‚é‚©‚à‚µ‚ê‚Ü‚¹‚ñB‚�}‚Ì‚ ‚½‚è‚ð‚È‚ñ‚Æ‚©‰ü—Ç‚µ‚āAƒf[ƒ^ƒx[ƒX‚ƃ‚ƒfƒ‹‚ÌŠÔ‚É‚È‚É‚©ˆê–‡A‚©‚Ü‚¹‚é‚�}‚Æ‚ª‚Å‚«‚ê‚΂©‚È‚è•Ö—˜‚©‚àA‚ÆŽv‚Á‚½‚è‚à‚µ‚��‚Ü‚·Bi‚�N‚»‚ç‚­A‚¾‚ê‚©‚ªì‚é‚̂ł͂Ȃ��‚Å‚µ‚傤‚©Bj

‰º‹L‚́AActiveRecord(CakePHP) ‚©‚çASQLMap Data MapperiPRADOj‚Ɉړ®‚µ‚½‚©‚Á‚½A‚Ƃ��‚¤‚Ì‚ªŽå‚È——R‚ł͂Ȃ��‚©‚ÆŽv‚��‚Ü‚·B

geeQsQuad
PRADO Watch: Interview With Timani Tunduwani - Why I Moved From CakePHP to PRADO

šnD•iŒnPHPH‚̂܂Ƃ߁B
‚ ‚Ü‚è‚܂��‚߂ɍl‚¦‚¸B

CakePHPiƒP[ƒLj
http://cakephp.org/

Cheesecakeiƒ`[ƒYƒP[ƒLj
http://cheesecake-photoblog.org/

hotcakeiƒzƒbƒgƒP[ƒLj
http://cakeforge.org/projects/hotcakes/

Pockyiƒ|ƒbƒL[j
http://cakeforge.org/projects/pocky/

BiscuitiƒrƒXƒPƒbƒgj
http://bennolan.com/biscuit/

phpPeanutsiƒs[ƒiƒcj
http://www.phppeanuts.org/

Chocolateiƒ`ƒ‡ƒRƒŒ[ƒgj
http://www.phpchocolate.com/

Double Choco Latteiƒ_ƒuƒ‹ƒ`ƒ‡ƒRƒ‰ƒej
http://dcl.sourceforge.net/

ƒ`ƒ‡ƒRƒŒ[ƒg‚̑匤‹†
http://www.php.co.jp/bookstore/detail.php?isbn=978-4-569-68661-5
PHPŒ¤‹†Š‚Í‚â‚Í‚èƒTƒCƒg‚É.php‚ðŽg—p‚µ‚��‚éB
(There is a famous "PHP" company in Japan from 1946.)

CakePHP‚ðï¿½ï¿½‚ɏЉ‚½Favio(H3RALD)‚ªCakeƒRƒ~ƒ…ƒjƒeƒB‚ð‹Ž‚Á‚½ŒãA‚�}‚ñ‚È‹LŽ–‚ð‘‚ï¿½ï¿½‚��‚Ü‚·B

An Interview with the creator of the Akelos Framework
http://www.h3rald.com/blog/akelos-interview

‹»–¡[‚��‚̂́ACakePHP‚âCode Igniter‚ª‚Ü‚¾‚È‚©‚Á‚½iSymfony‚à‚Ü‚¾Mojavi‚¾‚Á‚½‚�}‚ë‚́jŽž‘ã‚ɁA‚·‚Å‚ÉAkelos‚̌�LŒ^‚ªo—ˆ‚��‚½A‚Ƃ��‚¤“_‚Å‚·B

Å‹ßAAkelosƒRƒ~ƒ…ƒjƒeƒB‚ªî•ñ”­M‚ðÏ‹É“I‚ɂ͂��‚ß‚Ü‚µ‚½B
ActiveRecord”h‚È‚çA‰º‹L‚̃XƒNƒŠ[ƒ“ƒLƒƒƒXƒg‚Í•KŒ©‚Å‚·B
http://www.akelos.org/screencasts

E‚·‚Å‚Émigrate‚ª“‡‚³‚ê‚��‚é
E‘½Œ¾Œê‘Ήž‚ª”ñí‚ÉŠÈ’Pi•¡”Œ¾Œê—p–|–óƒtƒ@ƒCƒ‹‚ÌŽ©“®ï¿½ï¿½ï¿½ï¿½j
EPHP‚Ì–îˆó‚ª­‚Ȃ��I
Eƒeƒ“ƒvƒŒ[ƒg‚ÉPHP\•ï¿½ï¿½‚ÍŽg—p‚µ‚Ȃ��iecho ‚ð‘‚©‚È‚­‚Ä‚æ‚��j
E‚Ù‚ÚRailsB

‰pŒêŒ—ˆÈŠO‚ł͂��‚Ü‚Á‚��‚é‚Ì‚ªƒ~ƒ\‚ŁA“ú–{ŒêŠÂ‹«‚Å‚à‚«‚Á‚ÆŽg‚��‚â‚·‚��‚Í‚¸‚Å‚·BPHPƒtƒŒ[ƒ€ƒ[ƒN‚̐��ŠE‚ł̓fƒtƒ@ƒNƒg‚ª‹N‚�}‚è‚É‚­‚��ŠÂ‹«‚É‚ ‚è‚Ü‚·‚̂ŁA¡‚©‚ç‚Å‚à\•ª‚ɒǂ��ã‚��‰Â”\‚©‚à‚µ‚ê‚Ü‚¹‚ñB

‚»‚¤‚µ‚½‚çAuCakePHP‚̂�N‚��‚µ‚��H‚�~•ûv‚Å‚Í‚È‚­‚āAuPHPƒtƒŒ[ƒ€ƒ[ƒN‚̂�N‚��‚µ‚��H‚�~•ûv‚É‚µ‚悤‚©‚È‚ŸcB‚܁A‚»‚ê‚Í‚³‚�N‚«A¡Œã‚Ì“WŠJ‚ª–Ê”’‚­‚È‚Á‚Ä‚«‚Ü‚µ‚½B

¡‚»‚�}‚ŃT[ƒrƒX‚ª‚Å‚«‚ ‚ª‚è‚Ü‚µ‚½A‚Ƃ��‚¤Žèì‚èŠï¿½L‚Ì‚ ‚éƒTƒCƒgB
Žx•\‚��—\’èE‹L˜^‚ðŠÇ—‚Å‚«‚éƒTƒCƒg‚¾‚»‚¤‚Å‚·B
Ã‘��ƒ[ƒ‹‚‚«B

http://www.billbugger.com/
ŠJ”­ƒuƒƒOF
http://billbugger.wordpress.com/

ŽÀ‚͉º‹L‚̃XƒŒƒbƒh‚É‚Í”ñí‚ɏd—v‚Ȃ�}‚Æ‚ª‘‚��‚Ä‚ ‚è‚Ü‚·B
1.1Œn‚Å‚àAƒRƒ“ƒgƒ[ƒ‰“à‚Å•¡ŽG‚ȃoƒŠƒf[ƒVƒ‡ƒ“‚ð‚©‚¯‚é‹@”\‚ª•W€‚Å‘g‚ݍž‚Ü‚ê‚��‚é‚Ƃ��‚¤˜b‚Å‚·B

Problems with simple invalidate test
http://groups.google.com/group/cake-php/browse_thread/thread/354a677b21779c0/

’ʏíAbake.php ‚â decorate.php ‚È‚Ç‚ðŽg‚Á‚ăf[ƒ^‚ðo—Í‚·‚é‚ƁA‰º‹L‚̂悤‚ȃR[ƒh‚ªï¿½ï¿½ï¿½ï¿½‚³‚ê‚Ü‚·B


function add() {
@@@@//‚à‚µƒf[ƒ^‚ªPOST‚³‚ê‚��‚Ȃ��ˆê‰ñ–Ú‚È‚ç
@@@@if (empty($this->data)) {
@@@@@@@@//“ü—͉æ–Ê‚ðo—Í
@@@@@@@@$this->render();
@@@@} else {
@@@@@@@@//ƒf[ƒ^‚ªPOST‚³‚ê‚��‚é‚È‚çA
@@@@@@@@//“ú•tƒf[ƒ^‚̘AŒ‹ˆ—‚ð‚·‚ég‚܂Ƃ߁hŠÖ”
@@@@@@@@$this->cleanUpFields();
@@@@@@@@//$this->data‚Ì“à—e‚ð•Û‘��
@@@@@@@@if ($this->Category->save($this->data)) {
@@@@@@@@@@@@$this->Session->setFlash('The Category has been saved');
@@@@@@@@@@@@$this->redirect('/categories/index');
@@@@@@@@} else {
@@@@@@@@@@@@//ƒoƒŠƒf[ƒVƒ‡ƒ“‚ÉŽ¸”s‚µ‚½‚̂ŃGƒ‰[‚ðo—́BC³‚ð‘��‚·
@@@@@@@@@@@@$this->Session->setFlash('Please correct errors below.');
@@@@@@@@}
@@@@}
}



‚µ‚©‚µ‚�}‚ê‚ðA

function add() {
@@@@//‚à‚µƒf[ƒ^‚ªPOST‚³‚ê‚��‚Ȃ��ˆê‰ñ–Ú‚È‚ç
@@@@if (empty($this->data)) {
@@@@@@@@//“ü—͉æ–Ê‚ðo—Í
@@@@@@@@$this->render();
@@@@} else {
@@@@@@@@//ƒf[ƒ^‚ªPOST‚³‚ê‚��‚é‚È‚çA
@@@@@@@@//“ú•tƒf[ƒ^‚̘AŒ‹ˆ—‚ð‚·‚ég‚܂Ƃ߁hŠÖ”
@@@@@@@@$this->cleanUpFields();
@@@@
@@@@@@@@//ƒf[ƒ^‚ðˆÚ“® *‚�}‚�}‚ªƒ|ƒCƒ“ƒg*
@@@@@@@@$this->Category->set($this->data);
@@@@@@@@//ƒf[ƒ^‚ðƒ`ƒFƒbƒN‚µ‚Ä•K—v‚Å‚ ‚ê‚΁AðŒ‚ʼnº‹L‚̂悤‚ȃGƒ‰[‚𔭐��‚³‚¹‚éB
@@@@@@@@$this->Category->invalidate("name");
@@@@@@@@$this->Category->invalidate("ƒrƒ…[‚ÌtagErrorMsg()‚ɐݒ肷‚é’l");

@@@@@@@@//$this->data‚Ì“à—e‚ð•Û‘��
@@@@@@@@if ($this->Category->save()) { //*’ˆÓ*
@@@@@@@@@@@@$this->Session->setFlash('The Category has been saved');
@@@@@@@@@@@@$this->redirect('/categories/index');
@@@@@@@@} else {
@@@@@@@@@@@@//ƒoƒŠƒf[ƒVƒ‡ƒ“‚ÉŽ¸”s‚µ‚½‚̂ŃGƒ‰[‚ðo—́BC³‚ð‘��‚·
@@@@@@@@@@@@$this->Session->setFlash('Please correct errors below.');
@@@@@@@@}
@@@@}
}



‚Ə‘‚«’¼‚·‚ƁA•¡”ƒtƒB[ƒ‹ƒh‚ð‚Ü‚½‚��‚¾ƒoƒŠƒf[ƒVƒ‡ƒ“ˆ—‚âA‚ЂƂ‚̃tƒB[ƒ‹ƒh‚É•¡”‚̃oƒŠƒf[ƒVƒ‡ƒ“ƒ‹[ƒ‹‚ð“K—p‚·‚é‚�}‚Æ‚ª‚Å‚«‚Ü‚·B

‚¿‚Ȃ݂ɁA‚�}‚ê‚Ü‚Å
$this->data['Category']['name']
‚È‚Ç‚Æ‚µ‚Ä‘€ì‚µ‚��‚½ƒf[ƒ^‚́A$this->Category->set($this->data)Œã‚́A
$this->Category->data['Category']['name']
‚Ƃ��‚¤Œ`‚ł̃AƒNƒZƒX‚É‚È‚è‚Ü‚·B