php¿ç±í²éѯÎÊÌâ - PHP / »ù´¡±à³Ì
Á½ÕÅ±í ·Ö±ðÊÇ sale ºÍ basic ÆäÖÐÓÐÁ½¸ö×Ö¶Î Ò»¸öÊÇ ÏúÊÛÓû§ Ò»¸öÊÇÏúÊÛ²úÆ·ÐͺŠÏúÊÛÓû§´æÔÚÓÚ saleÖÐ ÏúÊÛ²úÆ·ÀàÐÍ´æÔÚÓÚ basic ²¢ÇÒΨһ
×îºóÓÐÒ»¸ö±¨±í¹¦ÄÜ ÏÖÓеŦÄÜÊÇÖ»Äܲéѯ ÏúÊÛÓû§ ´úÂëÈçÏ £¨²¿·Ö£©
case "month":
$query="select *
from #@__sale,#@__reportsale
where year(#@__reportsale.r_date)=year('$sday') and month(#@__reportsale.r_date)=month('$sday')
and #@__sale.rdh=#@__reportsale.r_dh
and #@__sale.member LIKE '%".$member."%' //²éѯijÌìµÄÏúÊÛÓû§
ÏÖÔÚÐèÒª¼ìË÷ijÌìÏúÊÛÓû§µÄij¸öÏúÊÛÐÍºÅ Ç£Éæµ½¿ç±í²éѯÎÊÌâ £¨ÒòΪ²»Ïë°ÑÏúÊÛ²úÆ·ÀàÐÍҲдÈëµ½sale±íÖУ©
´úÂëÓ¦¸ÃÈçºÎÐ´ÄØ
ÒòΪ²éʵ°ÉbasicÖÐµÄ ÏúÊÛ²úÆ·ÀàÐÍдÈë µ«·¢ÏÖʵÏÖ²»ÁË
±È½Ï²Ë Çë´óʦ¸ø³ö´ð°¸°É
±í sale ÖÐµÄ member ×Ö¶Î ±í basic ÖÐµÄ cp_name
±ÈÈç ɽ¶«Ð·¢£¨member£©Ä³ÌìKÕâÖÖÐͺţ¨cp_name£©µÄ²úÆ·µÄÏúÊÛÇé¿ö
È¥SQLÇøÎÊÎÊ£¬°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£
ÎÒÏȶ¥ÁËÔÙ¿´
SQL code:
SELECT * from sale s LEFT JOIN basic b ON s.prodectionid = b.prodectionid WHERE year(#@__reportsale.r_date)=year('$sday') and month(#@__reportsale.r_date)=month('$sday')
and #@__sale.rdh=#@__reportsale.r_dh
and #@__sale.member LIKE '%".$member."%'
ÊÔÊÔÕâ¸ö°É£¬ÎÒÕâÀïû·¨Ä£ÄâÄãµÄÇé¿ö
°Ñ±í½á¹¹Ìù³öÀ´£¬ÌûÉϲâÊÔÊý¾ÝºÍÆÚÍû½á¹ûÊý¾Ý¡
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
PHPÖÐ ÉùÃ÷±äÁ¿µÄʱºòÒ»¸ö$¸úÁ½¸ö$µÄÇø±ð
±ÈÈç˵
$var="333"; ±íʾ±äÁ¿ÃûΪ$varµÄ±äÁ¿µÄֵΪ333
$var="myvar";$$var="333";±íʾ±äÁ¿ÃûΪ$myvarµÄ±äÁ¿µÄֵΪ333
ÕâÑù˵Çå³þÁËÂð£¿
......
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
»òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿
PHP¸ÕÈëÃÅѧϰ,ÓÑÇé¶¥Ò»¸ö
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
//echo '<script>alert("ok");< ......