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±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡 ÊÖ²áºÜÖØÒªµÄàÞ£¡~ ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£ È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
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)ÖеÄÊý¾ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã ´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´ ÎÒÓõĵÄÊÇiis smtp <?php $to = 'xueyuxia1988@sohu.com'; $subject = 'the subject'; $message = 'hello'; $ ......