¼ò½é£º
CakePHP ÊÇÒ»ÖÖÓà PHP ¹¹½¨ Web Õ¾µãµÄ¸¨Öú¹¤¾ß£¬ËüºÜÎȶ¨£¬¿ÉÖ±½ÓÓÃÓÚÉú²ú¼°¿ìËÙ¿ª·¢¡£¡°Ê¹ÓÃ
CakePHP ¿ìËÙ´òÔì Web Õ¾µã¡± ϵÁн̳ÌÏòÄúչʾÈçºÎʹÓà CakePHP ¹¹½¨ÔÚÏß²úƷĿ¼¡£µÚ
1 ²¿·ÖÖ÷Òª½éÉÜÈçºÎ°²×°²¢ÔËÐÐ CakePHP£¬ÒÔ¼°ÈçºÎ¹¹½¨Ò»¸ö¼òµ¥µÄÓ¦ÓóÌÐò£¬ÒÔÔÊÐíÓû§×¢²áÕÊ»§²¢µÇ¼µ½Ó¦ÓóÌÐò¡£
¿ªÊ¼Ö®Ç°
±àÕß×¢£º±¾ÏµÁÐ×î³õ·¢±íÓÚ 2006 Ä꣬Ôڴ˺óΪÁ˸úÉÏ CakePHP
µÄ·¢Õ¹½øÐÐÁ˶à´ÎÐÞ¶©¡£Õâ´ÎÊÇÕë¶Ô CakePHP V1.3.4 ¶øÐÞ¶©µÄ¡£
¡°Ê¹Óà CakePHP ¿ìËÙ´òÔì Web Õ¾µã¡± ϵÁн̳ÌÊʺÏÏ£Íû¿ªÊ¼Ê¹ÓÃ
CakePHP ÇáËɹ¹½¨Ó¦ÓóÌÐòµÄ PHP Ó¦ÓóÌÐò¿ª·¢ÈËԱѧϰ¡£Í¨¹ý±¾ÏµÁн̳̣¬Äú½«Á˽âÈçºÎ°²×°ºÍÅäÖÃ
CakePHP ÒÔ¼°ÓÐ¹Ø Model-View-Controller£¨MVC£©Éè¼Æ¡¢ÈçºÎÔÚ CakePHP
ÖмìÑéÓû§Êý¾Ý¡¢ÈçºÎʹÓà CakePHP helper¡¢ÈçºÎʹÓà CakePHP ¿ìËÙ½¨Á¢²¢ÔËÐÐÓ¦ÓóÌÐòµÄ»ù±¾ÖªÊ¶¡£ÌýÆðÀ´ºÃÏñÓкܶණÎ÷Ҫѧϰ£¬µ«²»±Øµ£ÐÄ
¡ª¡ª CakePHP »áÌæÄúÍê³ÉÆäÖеĴ󲿷ֹ¤×÷¡£
ÏȾöÌõ¼þ
±¾½Ì³Ì¼ÙÉèÄúÊìϤ PHP ±à³ÌÓïÑÔ£¬»ù±¾ÕÆÎÕÊý¾Ý¿âÉè¼ÆÇÒϲ»¶ÊµÕ½¡£Äú²»±ØÍêÈ«ÕÆÎÕ
MVC ģʽ£¬ÒòΪ±¾½Ì³Ì½«»á½éÉÜËüµÄ»ù±¾ÔÀí¡£×îÖØÒªµÄÊÇ£¬Äú±ØÐëÔ¸Òâѧϰ¡¢Ô¸ÒâͶÈëÆäÖв¢Ê®·Ö¿ÊÍûËõ¶Ì¿ª·¢Ê±¼ä¡£
ϵͳÐèÇó
¿ªÊ¼Ö®Ç°£¬ÐèÒª¾ß±¸Ò»¸ö¹¤×÷»·¾³¡£CakePHP µÄ×îµÍ·þÎñÆ÷ÐèÇóΪ£º
Ö§³Ö»á»°£¨²¢ÇÒ×îºÃÖ§³Ö mod_rewrite£©µÄ HTTP ·þÎñÆ÷¡£±¾½Ì³Ì²ÉÓõÄÊÇÖ§³Ö
mod_rewrite µÄ Apache V2.2.4¡£
PHP V4.3.2 »ò¸ü¸ß°æ±¾£¨°üÀ¨ PHP V5£©¡£±¾½Ì³Ì²ÉÓõÄÊÇ
PHP V5.2.3¡£
ÊÜÖ§³ÖµÄÊý¾Ý¿âÒýÇæ¡£±¾½Ì³Ì²ÉÓõÄÊÇ MySQL V5.0.4¡£
»¹ÐèҪ׼±¸ºÃÒ»¸öÊý¾Ý¿âÒÔ¹©Ó¦ÓóÌÐòʹÓᣱ¾½Ì³Ì½«ÌṩÓà MySQL ´´½¨ÈκαØÐèµÄ±íµÄÓï·¨¡£
°²×°
ÎÞÂÛÄúµÄ¾ÑéˮƽÈçºÎ£¬CakePHP ¶¼¿ÉÒÔʹӦÓóÌÐò¸üÒ×ÓÚ¿ìËÙ±àдºÍά»¤£¬´Ó¶ø¼ò»¯ÄúµÄ¹¤×÷¡£CakePHP
Óкܶà·Ç³£¿á¶øÇÒÊ®·ÖÓÐÓõÄÌØÐÔ¡£CakePHP ¿ÉÒÔΪÄú´¦Àí Ajax¡¢Êý¾Ý¼ìÑéºÍ»á»°¡£Èç¹û¿ÉÒÔ±àд²å¼þ¸æËß
CakePHP ÔõÑù×ö£¬ËüÉõÖÁÄÜÌṩ¸ü¶à°ïÖú¡£ÏÖÔÚÄú»¹²»ÄÜʹÓà CakePHP£¬ÐèÒªÏȰ²×°Ëü¡£
½âѹºÍ°²×°
ΪÁË´ïµ½±¾½Ì³ÌµÄÄ¿µÄ£¬Ó¦µ±ÔÚ Web ·þÎñÆ÷µÄ Web ¸ùĿ¼ÄÚ½âѹÕû¸ö
CakePHP °²×°Ä¿Â¼¡£ÔÚÇåµ¥ 1 ÖУ¬Web ¸ùĿ¼ÊÇ /webroot¡£
Çåµ¥ 1. ½âѹ CakePHP °²×°Ä¿Â¼
unzip cakephp-cakephp-1.3.4-0-g703344c.zip cd cakephp-cakephp-df6ffd4 mv * /webroot
|
ÊäÈë ls -la /webroot ÒÔÁгö Web ¸ùĿ¼µÄÄÚÈݲ¢¼ìÑéÎļþÊÇ·ñÒѱ»ÕýÈ·¸´ÖÆ¡£Êä³öÓ¦µ±ÀàËÆÓÚÇåµ¥
2¡£
Çåµ¥ 2. ls ÃüÁîµÄÊä³ö
-rw-r--r-- 1 YOURUSER YOURGROUP 139 2010-09-12 00:57 .htaccess -rw-r--r-- 1 YOURUSER YOURGROUP 1154 2010-09-12 00:57 README drwxr-xr-x 13 YOURUSER YOURGROUP 4096 2010-09-12 00:57 app drwxr-xr-x 6 YOURUSER YOURGROUP 4096 2010-09-12 00:57 cake -rw-r--r-- 1 YOURUSER YOURGROUP 1848 2010-09-12 00:57 index.php drwxr-xr-x 2 YOURUSER YOURGROUP 4096 2010-09-12 00:57 plugins drwxr-xr-x 3 YOURUSER YOURGROUP 4096 2010-09-12 00:57 vendors |
Ŀ¼ app/tmp ±ØÐëÊÇ Web ·þÎñÆ÷¿ÉдµÄ¡£Í¨¹ýÊäÈë ls -l app È·È϶ÔÕâ¸öÎļþ¼ÐµÄȨÏÞ¡£Êä³ö¿ÉÄÜÀàËÆÓÚÇåµ¥
3¡£
Çåµ¥ 3. È·ÈÏÎļþ¼ÐȨÏÞ
-rw-r--r-- 1 YOURUSER YOURGROUP 141 2010-09-12 00:57 .htaccess drwxr-xr-x 3 YOURUSER YOURGROUP 4096 2010-09-12 00:57 config drwxr-xr-x 3 YOURUSER YOURGROUP 4096 2010-09-12 00:57 controllers -rw-r--r-- 1 YOURUSER YOURGROUP 685 2010-09-12 00:57 index.php drwxr-xr-x 2 YOURUSER YOURGROUP 4096 2010-09-12 00:57 libs drwxr-xr-x 3 YOURUSER YOURGROUP 4096 2010-09-12 00:57 locale drwxr-xr-x 4 YOURUSER YOURGROUP 4096 2010-09-12 00:57 models drwxr-xr-x 2 YOURUSER YOURGROUP 4096 2010-09-12 00:57 plugins drwxr-xr-x 5 YOURUSER YOURGROUP 4096 2010-09-12 00:57 tests drwxr-xr-x 6 YOURUSER YOURGROUP 4096 2010-09-12 00:57 tmp drwxr-xr-x 3 YOURUSER YOURGROUP 4096 2010-09-12 00:57 vendors drwxr-xr-x 8 YOURUSER YOURGROUP 4096 2010-09-12 00:57 views drwxr-xr-x 6 YOURUSER YOURGROUP 4096 2010-09-12 00:57 webroot |
Íê³É´ËÈÎÎñµÄ×î¼òµ¥·½·¨¿ÉÄÜÊÇ×î³£¼ûÒ²ÊÇ×î²»°²È«µÄ£º½«Ð´È¨ÏÞÊÚÓèÿ¸öÈË£¨¼ûÇåµ¥ 4£©¡£
Çåµ¥ 4. ½«Ð´È¨ÏÞÊÚÓèÿ¸öÈË
chmod -R 777 app/tmp ls -l app |
tmp Îļþ¼ÐµÄȨÏÞÓ¦µ±ÒѾ±»¸üУ¬ÈçÇåµ¥ 5 Ëùʾ¡£
Çåµ¥ 5. ¸üРtmp Îļþ¼ÐµÄȨÏÞ
drwxrwxrwx 6 YOURUSER YOURGROUP 2010-09-12 00:57 tmp |
ͨ³£Çé¿öÏ£¬²»½¨Ò齫дȨÏÞÊÚÓèÿ¸öÈË¡£ÀíÏëÇé¿öÏ£¬Ó¦µ±½«Õâ¸öÎļþ¼ÐµÄËùÓÐȨÊÚÓè Web ·þÎñÆ÷ʹÓõÄÄǸöÓû§£¬»ò½«
Web ·þÎñÆ÷ʹÓõÄÄǸöÓû§Ìí¼Óµ½Õâ¸öĿ¼µÄÒ»¸ö×éÖв¢Ìí¼Ó×éµÄдȨÏÞ¡£±¾½Ì³ÌÖ¼ÔÚÑÝʾÈçºÎʹÓà CakePHP£¬²¢²»ÊÇÓйع¹½¨°²È«Ó¦ÓóÌÐòµÄÖ¸ÄÏ¡£ËäÈ»°²È«ÐÔÓ¦µ±ÊÇÈκÎÓ¦ÓóÌÐò¿ª·¢µÄÊ×Òª¿¼ÂÇÊÂÏµ«ÊÇÈ«ÃæÌÖÂÛ°²È«
PHP ʵ¼ù³¬³öÁ˱¾½Ì³ÌµÄ·¶Î§¡£
ΪÁËÖ´ÐвúÆ·°²×°£¬½« Web ·þÎñÆ÷µÄ Web ¸ùĿ¼¸ÄΪ app/webroot£¬ÕâÑù×ö½«°Ñ¿ÉÒÔͨ¹ý
Web ä¯ÀÀÆ÷·ÃÎʵĴúÂëÁ¿¼õÖÁ×îÉÙ£¬ÓÐÖúÓÚÔöǿϵͳµÄ°²È«ÐÔ¡£
¼ìÑé 1
ÔÚä¯ÀÀÆ÷ÖУ¬·ÃÎÊÓë Web ·þÎñÆ÷µÄ Web ¸ùĿ¼Ïà¶ÔÓ¦µÄ URL¡£ÀýÈ磬Èç¹ûÒѽ« CakePHP
°²×°µ½±¾µØÖ÷»úµÄ Web ¸ùĿ¼ÖУ¬Ôò·ÃÎÊ http://localhost£»ÄúÓ¦µ±»á¿´µ½ CakePHP
ĬÈÏÖ÷Ò³£¨¼ûͼ 1£©¡£

ͼ 1. Ó¦µ±¿´µ½µÄ CakePHP ĬÈÏÖ÷Ò³
×¢Ò⣺Èç¹ûĬÈÏÖ÷Ò³¿´ÉÏÈ¥¸üÏñͼ 2£¬Ôò˵Ã÷ mod_rewrite ²¢Ã»Óа´ÕÕ CakePHP ËùÐèµÄ·½Ê½ÔËÐС£µÚÒ»´ÎʹÓÃ
CakePHP µÄÓû§ÓÐʱ¿ÉÄÜ»áÓöµ½Õâ¸öÎÊÌâ¡£

ͼ 2. Íâ¹Û²»ÕýÈ·µÄÖ÷Ò³
ÒÔÏÂÊÇһЩÐèҪȷÈϵĶ«Î÷¡£
.htaccess ÎļþÊÇ·ñÕýÈ·£¿
.htaccess ÎļþÓ¦µ±ÒѳöÏÖÔÚ CakePHP °²×°Ä¿Â¼ÖС£ÔÚ´ó¶àÊý *nix ϵͳÖУ¬´ËÎļþ¶¼ÊÇĬÈÏÒþ²ØµÄ¡£Èç¹ûûÓиÃÎļþ£¬Çë¼ì²éÏÂÔØµÄÔ´Îļþ»ò´Ó
CakePHP.org »ñµÃ×îиüС£Í¨¹ý·ÃÎʰ²×°Ä¿Â¼²¢ÔËÐÐ cat .htaccess£¬È·ÈϸÃÎļþÊÇ·ñ´æÔÚÇÒÓÐЧ¡£Õ⽫ÏÔʾ¸ÃÎļþµÄÄÚÈÝ£¬ÆäÄÚÈÝÓ¦µ±ÀàËÆÓÚÇåµ¥
6¡£
Çåµ¥ 6. È·ÈÏ .htaccess ÎļþÊÇ·ñ´æÔÚ
<IfModule mod_rewrite.c> RewriteEngine on RewriteRule ^$ app/webroot/ [L] RewriteRule (.*) app/webroot/$1 [L] </IfModule> |
ÊÇ·ñΪ·þÎñÆ÷ÆôÓÃÁË mod_rewrite£¿
È·±£Îª Web ·þÎñÆ÷ÆôÓà mod_rewrite¡£¶ÔÓÚ Apache£¬httpd.conf ÎļþÖÐÓ¦µ±»á³öÏÖÁ½¸ö²»Í¬µÄÐС£ÔÚ
LoadModule ÁбíÖУ¬ÄúÓ¦µ±»á¿´µ½ÏÂÃæÒ»ÐУ¨»ò¼«ÎªÀàËÆ£©£ºLoadModule rewrite_module
libexec/mod_rewrite.so¡£ÔÚ AddModule ÁбíÖУ¬ÄúÓ¦µ±»á¿´µ½ÕâÒ»ÐУ¨»ò¼«ÎªÀàËÆ£©£ºAddModule
mod_rewrite.c¡£
Èç¹ûÄúÔÚ httpd.conf ÎļþÖÐÕÒ²»µ½ÕâÁ½ÐУ¬Ôò mod_rewrite δÆôÓá£Çë²éÔÄ·þÎñÆ÷ÎĵµÒÔ»ñµÃÈçºÎ½â¾ö´ËÎÊÌâµÄÏêϸÐÅÏ¢¡£
·þÎñÆ÷ÊÇ·ñÔÊÐí .htaccess ¸²¸Ç£¿
È·±£½« Web ·þÎñÆ÷ÅäÖÃΪÔÊÐí .htaccess ¸²¸Ç¡£¶ÔÓÚ Apache£¬Ã¿¸öĿ¼¶¼Ó¦ÔÚ httpd.conf
ÎļþÖж¨Òå¡£ÕâЩ¶¨Òå¿ÉÄÜÒòΪ°²×°µÄ²»Í¬¿´ÉÏÈ¥ÓÐËù²»Í¬£¬µ«Ó¦µ±ÈÔ»áÔÚ¶¨ÒåÖп´µ½ AllowOverride
All Ò»ÐС£¶¨Òå¿ÉÄÜÀàËÆÓÚÇåµ¥ 7¡£
Çåµ¥ 7. httpd.conf ÎļþÖе͍Òå
<Directory "/webroot"> Options Indexes MultiViews AllowOverride All Order allow,deny Allow from all </Directory> |
ÓÐ¹Ø .htaccess ¸²¸ÇµÄ¸ü¶àÐÅÏ¢£¬Çë²ÎÔÄ·þÎñÆ÷Îĵµ¡£
ÅäÖÃÊý¾Ý¿âÁ¬½Ó
¼ÈÈ»ÒѾ°²×°ÁË CakePHP£¬²¢ÒÑÓë Web ·þÎñÆ÷¹ØÁªÁËÆðÀ´£¬¾ÍÐèÒª°Ñ CakePHP ÒýÈëÊý¾Ý¿â¡£±¾½Ú½éÉÜÈçºÎÉèÖÃÊý¾Ý¿âÅäÖúͼìÑé
CakePHP ÊÇ·ñ½ÓÊÜÕâ¸öÊý¾Ý¿â¡£Tor ÐèÒªÒ»¸öλÖÃÀ´±£´æÆäÓû§ºÍ²úÆ·Êý¾Ý¡£È»ºóÒª´´½¨Ò»¸ö users
±í£¬¸Ã±íÓÃÓÚ¹¹½¨ Tor µÄµÇ¼ºÍ×¢²á²¿·Ö¡£
±à¼Êý¾Ý¿âÅäÖÃÎļþ
ÉèÖÃÊý¾Ý¿âÅäÖÃÊ®·Ö¼òµ¥£¬µ«ÔÚ¿ªÊ¼Ö®Ç°£¬ÒªÈ·±£Êý¾Ý¿â·þÎñÆ÷´¦ÓÚÔËÐÐ״̬£¬È·±£ÒѾΪӦÓóÌÐò´´½¨ÁËÊý¾Ý¿â£¬²¢È·±£ÓµÓÐÒ»¸öÓû§µÄÓû§ÃûºÍÃÜÂ루Õâ¸öÓû§¾ßÓжÔÊý¾Ý¿â½øÐвÙ×÷µÄȨÏÞ£©
Ê×ÏÈ£¬¸´ÖÆ app/config/database.php.default Îļþ²¢½«Æä±£´æÎª app/config/database.php¡£ÕâÑù×öÊÇΪÁ˱£ÁôÒ»¸öÔʼģ°åµÄ¿½±´¡£ÔÚÄúϲ»¶µÄÎı¾±à¼Æ÷Öдò¿ª¸ÃÎļþ²¢²éÕÒÒÔϲ¿·Ö£¨ËüÓ¦µ±·Ç³£½Ó½ü¸ÃÎļþµÄµ×²¿£©£¬ÈçÇåµ¥
8 Ëùʾ¡£
Çåµ¥ 8. app/config/database.php.default Îļþ
Çåµ¥ 8. app/config/database.php.default Îļþ var $default = array( 'driver' => 'mysql', 'persistent' => false, 'host' => 'localhost', 'login' => 'user', 'password' => 'password', 'database' => 'database_name', 'prefix' => '' ); |
¸ù¾Ý×Ô¼ºµÄÇé¿öÐÞ¸ÄÒÔÏÂÐÅÏ¢£º
driver
´Ë×ֶοÉÒÔÊÇ mysql¡¢mysqli¡¢postgres¡¢sqlite¡¢mssql¡¢db2, oracle¡¢adodb
»ò pear-drivername¡£±¾½Ì³Ì¼Ù¶¨ËüÊÇ mysql¡£
persistent
´Ë×ֶθæËß CakePHP ÊÇ·ñÓ¦µ±Ê¹Óó־õÄÊý¾Ý¿âÁ¬½Ó¡£ÓÐЧֵÊÇ true »ò false¡£±¾½Ì³Ì¼Ù¶¨ËüÊÇ
false¡£
host
ÕâÊÇÊý¾Ý¿â·þÎñÆ÷µÄÖ÷»úÃû£¬±ÈÈç localhost »ò mysql.yourdomain¡£
login
ÕâÊÇÓÃÓÚÊý¾Ý¿âµÇ¼µÄÓû§Ãû£¬±ÈÈç dbuser¡£
password
ÕâÊÇÓÃÓÚÊý¾Ý¿âµÇ¼µÄÃÜÂ룬±ÈÈç secretsecret¡£
database
ÕâÊÇÏ£ÍûʹÓõÄÊý¾Ý¿âµÄÃû³Æ£¬±ÈÈç cakedev¡£
prefix
ǰ׺ÊÇÒ»¸ö×Ö·û´®£¬±ÈÈç cp_£¬ËüÊÇ CakePHP Ö´ÐеÄÈκÎÊý¾Ý¿âµ÷ÓõıíÃûǰ׺¡£Èç¹ûÊý¾Ý¿âÓɶà¸öÓ¦ÓóÌÐò¹²Ïí£¬¶øÓÖÒª±£Ö¤ÔÚÁ½¸ö»ò¶à¸öÓ¦ÓóÌÐòÐèҪʹÓþßÓÐÏàͬÃû³ÆµÄ±íʱ£¨±ÈÈç
users£©±í²»»áÏ໥¸²¸Ç£¬ÄÇô¾ÍÓбØÒªÊ¹ÓÃǰ׺¡£
Çë²»ÒªÍü¼Ç±£´æÎļþ¡£
¿ÉÒÔÔÚ database.php ÖÐÖ¸¶¨ÈÎÒâÊýÄ¿µÄÊý¾Ý¿âÅäÖã¬Ö»ÒªÕâЩÊý¾Ý¿âÅäÖþßÓв»Í¬µÄÃû³Æ¡£¿ÉÒÔÖ¸¶¨Ó¦ÓóÌÐòÓ¦µ±ÔÚÄ£ÐÍÖÐʹÓÃÄĸöÊý¾Ý¿âÅäÖá£
¹ØÓÚÊý¾Ý¿âºÍ CakePHP µÄһЩעÒâÊÂÏ
±í±ØÐë¾ßÓÐÃûΪ id µÄÖ÷¼ü¡£
Èç¹û±íÖаüº¬ created »ò modified ÁУ¬CakePHP ¾Í»áÔÚÊʵ±µÄʱºò×Ô¶¯Ìî³ä×ֶΡ£
±íÃûÓ¦¸ÃΪ¸´Êý£¨users¡¢products¡¢eggs¡¢sodas¡¢winners¡¢losers£©¡£ÆäÏàÓ¦µÄÄ£Ðͽ«¾ßÓе¥ÊýµÄÃû³Æ£¨user¡¢product¡¢egg¡¢soda¡¢winner¡¢loser£©¡£
Èç¹ûÒª½«±í¹ØÁªÆðÀ´£¬Íâ¼üÓ¦µ±²ÉÓà table_id ¸ñʽ£¬ÇÒʹÓõ¥ÊýµÄ±íÃû¡£ÀýÈ磬user_id¡¢product_id¡¢egg_id¡¢soda_id¡¢winner_id
ºÍ loser_id ÊDZíµÄ user¡¢product¡¢egg¡¢soda¡¢winner ºÍ loser
µÄÍâ¼ü¡£
¼ìÑé 2
·µ»Øµ½ÓÃÓÚ¼ìÑé³õʼ°²×°µÄ URL¡£Ó¦µ±»á¿´µ½ CakePHP ĬÈÏÖ÷Ò³ÒѾ¸ÄΪÏÔʾÊý¾Ý¿âÅäÖõÄ״̬£¨¼ûͼ
3£©¡£

ͼ 3. CakePHP ĬÈÏÖ÷Ò³¸ÄΪÏÔʾÊý¾Ý¿âÅäÖõÄ״̬
CakePHP ĬÈÏÖ÷Ò³¸ÄΪÏÔʾÊý¾Ý¿âÅäÖõÄ״̬
Èç¹ûĬÈÏÖ÷Ò³Ö¸³öÊý¾Ý¿âÅäÖÃÎļþ²»´æÔÚ£¬ÔòÄú¿ÉÄܽ«Æä·ÅÔÚÁË´íÎóµÄλÖûòÕ߯äÃû³Æ²»ÕýÈ·¡£È·±£Êý¾Ý¿âÅäÖÃÎļþΪ
app/config/database.php¡£Èç¹ûĬÈÏÖ÷Ò³Ö¸³ö CakePHP ÎÞ·¨Á¬½ÓÊý¾Ý¿â£¬ÄÇôȷÈÏÊäÈëµÄÁ¬½ÓÐÅÏ¢ÊÇ·ñÓÐЧ£¬È»ºóÖØÊÔ¡£
´´½¨Ó¦ÓóÌÐò±í
ÏÖÔÚ£¬CakePHP¡¢Web ·þÎñÆ÷ºÍÊý¾Ý¿â¶¼¹ØÁªµ½Ò»ÆðÁË¡£¿ªÊ¼¶¯ÊÖʵ¼ù°É£¡Tor ÐèÒªÒ»¸ö users
񡭜
Õâ¸ö±í½«°üº¬Ê¶±ðÓû§ºÍÓëÓû§½»»¥ËùÐèµÄ»ù±¾ÐÅÏ¢¡£¼òµ¥µÄÓû§ÃûºÍÃÜÂë×ֶοÉÄܾ͹»ÁË£¬µ«ÆäËûÐÅÏ¢Ò²¿ÉÄÜÓÐÓã¬ÀýÈçµç×ÓÓʼþµØÖ·£¨ÓÃÓÚ·¢ËÍÃÜÂëÖØÖÃÇëÇ󣩡¢Ãû×ÖºÍÐÕÊÏ£¨ÓÃÓÚ¸öÐÔ»¯·þÎñ£©ÒÔ¼°×îºóÒ»´ÎµÇ¼µÄÈÕÆÚ£¨ÓÃÓÚ°ïÖú¸ú×Ù²»»î¶¯µÄÕÊ»§£©¡£Äú¿ÉÄÜÏ£ÍûÓû§ÃûºÍµç×ÓÓʼþ×Ö¶ÎÊÇΨһµÄ¡£ÁíÍ⣬²»ÒªÍü¼ÇÖ÷¼ü
ID ×ֶΡ£´´½¨±íµÄ SQL ¿ÉÄÜÀàËÆÓÚÇåµ¥ 9¡£
Çåµ¥ 9. ´´½¨±íµÄ SQL
CREATE TABLE 'users' ( 'id' INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , 'username' VARCHAR( 40 ) NOT NULL , 'password' VARCHAR( 40 ) NOT NULL , 'email' VARCHAR( 255 ) NOT NULL , 'first_name' VARCHAR( 40 ) NOT NULL , 'last_name' VARCHAR( 40 ) NOT NULL , UNIQUE ( 'username' ,, 'email' ) ) TYPE = MYISAM ; |
×¢Ò⣬username¡¢password¡¢first_name ºÍ last_name ×Ö¶Î×î¶à°üº¬
40 ¸ö×Ö·û¡£ÔÚ user Ä£ÐÍÖн«Ç¿ÖÆÒªÇó²»³¬¹ýÕâ¸ö×Ö·û³¤¶È¡£ÔÚ±¾ÀýÖУ¬40 ¸ö×Ö·ûµÄ×î´ó³¤¶ÈÍêÈ«ÊÇÈÎÒâÉ趨µÄ¡£
|