mysqlÊý¾Ý¿âÖ÷Íâ¼ü¹ØÏµ - PHP / »ù´¡±à³Ì
ÇëÎÊ£¬ÈçºÎÔÚ¿ÉÊÓ»¯×´Ì¬ÏÂÉèÖÃmysqlÊý¾Ý¿âµÄÖ÷Íâ¼ü¹ØÏµ°¡£¿ ×¢£ºÊÇÔÚ¿ÉÊÓ»¯Ï£¬¶ø²»ÊÇдsqlÓï¾äÈö£¡£¡£¡
ÄãÓõÄÊÇʲ÷Ṥ¾ßÄØ? ÁíÍâÄãҪעÒâÄãµÄmysql±í類ÐÍ.Èç¹û類ÐÍÊÇmyisam ÊDz»Ö§³ÖÖ÷Íâ鍵µÄ. ¿ÉÒÔʹÓÃORMÀà doctirne ¹¦¹ú²ú queryphp http://code.google.com/p/queryphp/downloads/list ²»¹ýËÙ¶ÈÂýµã ѧϰ¡£¡£¡£¡£ Õâ¸ö²»Çå³þ£¬Ò»Ö±ÔÚ³ÌÐòÀï¿ØÖÆµÄ Ò»Ö±ÓÃPHPMYADMINûÓпÉÊÓ²Ù×÷£¬Ö±½Ó°Ñ1:nÄ£Ð͵Ä1ÉèÖóÉÖ÷Ë÷Òý£¬nÉèÖÃ³ÉÆÕͨË÷Òý ÄÇÈç¹ûÓÃsqlÓï¾äÓÖÔõôÀ´ÉèÖÃÄØ£¿ÊÇÕâÑùÂ𣿠alter table tablename constraint PK_name primary key(ÁÐÃû)£» дµÄ¶ÔÂ𣬻¹ÓÐÍâ¼üÄØ£¿ ÒòΪÎÒÊdzõѧÈö£¬ËùÒԺöණÎ÷¶¼²»Ì«»á£¬ÄãÃÇ˵µÄһЩÃû´ÊÊõÓïÎÒҲû½Ó´¥¹ýµÄ£¡ÒýÓà ¿ÉÊÓ:ʹÓÃnavicat SQLÓï¾ä:ALTER TABLE `ÕâÀïÊäÈëÏëÔÚÄĸö±íÔö¼ÓÍâ¼ü` ADD CONSTRAINT `ÕâÀïÊäÈëÍâ¼üÃû` FOREIGN KEY (`ÕâÀïÊäÈëÍâ¼ü×Ö¶Î`) REFERENCES `ÕâÀïÊäÈëÊÇÄĸö±íµÄÍâ¼ü` (`ÕâÀïÊäÈë¶ÔÓ¦ÄǸö±íµÄÄĸö×Ö¶Î`) ON DELETE CASCADE ON UPDATE CASCADE; ×îºóµÄON DELETE CASCAD¡¡ Äãտţ²æ.... ÄÇÓÐʲô°ì·¨£¬ÄãÒ²²»ÊÇÒ»¿ªÊ¼¾Í»á°É£¡ colerclub,лл°¡£¬ÄãÔõô֪µÀÎÒ»áÎÊ£ºON DELETE CASCADE ON UPDATE CASCADEÕâÃû»°°¡£¬ÎÒ¾ÍÊDz»¶®Õâ¾äµÄÒâ˼Èö£¬²»¹ýÄãÒѾ½âÊÍÁË£¬Ð»À²£¡ÒýÓà ÄÇÓÐʲô°ì·¨£¬ÄãÒ²²»ÊÇÒ»¿ªÊ¼¾Í»á°É£¡ Æäʵ¿ÉÒÔ²»ÓÃ×Ô¼ºÐ´sqlÓï¾ä½¨Á¢
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url) ²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È« Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£ »òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£ ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1 ÎÞ½â ÒýÓà Î޽⠲»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ...... ¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´ cookie Æ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......