Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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."%'
ÊÔÊÔÕâ¸ö°É£¬ÎÒÕâÀïû·¨Ä£ÄâÄãµÄÇé¿ö

°Ñ±í½á¹¹Ìù³öÀ´£¬ÌûÉϲâÊÔÊý¾ÝºÍÆÚÍû½á¹ûÊý¾Ý¡


Ïà¹ØÎÊ´ð£º

php »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

Ïëѧphp - PHP / »ù´¡±à³Ì

Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡

ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ

Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â

php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£

È¥ÂòÊ¥¾­°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......

ÐÂѧPHP Çë½ÌÎÊÌâ - PHP / »ù´¡±à³Ì

PHPÖÐ ÉùÃ÷±äÁ¿µÄʱºòÒ»¸ö$¸úÁ½¸ö$µÄÇø±ð
±ÈÈç˵
$var="333"; ±íʾ±äÁ¿ÃûΪ$varµÄ±äÁ¿µÄֵΪ333
$var="myvar";$$var="333";±íʾ±äÁ¿ÃûΪ$myvarµÄ±äÁ¿µÄֵΪ333
ÕâÑù˵Çå³þÁËÂ𣿠......

phpÎļþµ÷ÓÃjsÎļþÀïµÄ·½·¨£¿ - PHP / »ù´¡±à³Ì

¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
»òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿
PHP¸ÕÈëÃÅѧϰ,ÓÑÇé¶¥Ò»¸ö


¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
//echo '<script>alert("ok");< ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ