mysqlÔËÓÃÎÊÌâ - PHP / »ù´¡±à³Ì
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from dbname1.time, dbname2.goods
timeÊÇdbname1Êý¾Ý¿âÖÐtime±íÖеÄ×Ö¶Î
goodidÊÇdbname2Êý¾Ý¿âÖÐgoods±íÖеÄ×Ö¶Î
Äã¶¼»á¿ç¿âÁË,»¹À´ÎÊÕâ¸öÎÊÌâ?»¹ÓÐ3¸öÊý¾Ý¿â,ÄãÊÇ·ñ¶¼ÓÐȨÏÞÁ´½ÓºÍ²Ù×÷.
Õâ¸ö ºÃÏñ²»¿ÉÒÔÓÐ ÓÐÄÇô¶à¿â ²»Âé·³Âð£¿
¼òµ¥µã¾Í¿ÉÒÔµ±³É¶à±í²Ù×÷¡£
Ö»ÊÇÒªÔÚ±íÃûǰ¼ÓÊý¾Ý¿âÃû¡£
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
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)ÖеÄÊý¾ ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......