phpÈ¡³ö¼Ç¼ºó£¬ÈçºÎͳ¼ÆÏàͬµÄ¼Ç¼(ÔÚÏßµÈ)
ÎÒͨ¹ýÒ»Ìõ²éѯÓï¾ä(select fStaff,intParent from G_register as g,Users as u where g.intParent=u.IDUser order by fStaff)£¬µÃµ½Ò»¸ö½á¹û¼¯£¬½á¹ûÓÐ70¶àÍòÌõ¼Ç¼£¬ÎÒÏÖÔÚÏë°ÑintParentÊôÓÚͬһ¸ö×ֶΣ¨fStaff)µÄ¼Ç¼ÕÒ³öÀ´£¬×ö³öÒ»ÕÅͳ¼Æ±í£¬¸ÃÈçºÎ×öÄØ£¿
Èç:
fStaff(Êý×ÖÐÍ) intParent(Êý×ÖÐÍ)
1 258£¨Ìõ)
2 300(Ìõ)
...
Òâ˼¾ÍÊÇÊôÓÚ1ÏÂÃæµÄintParent¼Ç¼ÓÐ258Ìõ,ÊôÓÚ2ÏÂÃæµÄintParent¼Ç¼ÓÐ300Ìõ£¬
лл£¡²»Ê¤¸Ð¼¤,·ÖÊý²»¶à£¬ÒÔ±í¾´Òâ¡£
select fstaff count(*) as intParent from G_register as g,Users as u where g.intParent=u.IDUser group by fstaff
SQL code:
select fstaff,count(*) as intParent
from G_register
group by fstaff;
²»Ì«Ã÷°×lzµÄÒâ˼,°ÑintParentÊôÓÚͬһ¸ö×ֶΣ¨fStaff)µÄ¼Ç¼ÕÒ³öÀ´£¬
ʲôÒâ˼£¿
°ÑintParentÊôÓÚͬһ¸ö×ֶΣ¨fStaff)µÄ¼Ç¼ÕÒ³öÀ´£¬
Õâ¾ä»°ÎÒûÓн²Çå³þ£¬²»ºÃÒâ˼£¬
ÕâÌõÓï¾ä²é³öµÄ½á¹ûÀàËÆÏÂÃæ:
fStaff(Êý×ÖÐÍ) intParent(Êý×ÖÐÍ)
1 23213
1 3213
1 4324545
2 58115
2 &n
Ïà¹ØÎÊ´ð£º
<?php
if($_SERVER['HTTP_REFERER']!=''){
@header("Content-type:image/jpeg");
echo file_get_contents("xlight.jpg");
}
else{
@header("location:ht ......
ʹÓÃPHPµÄexecº¯Êýµ÷ÓÃlinuxµÄshellÃüÁÈçdateÈ¥ÐÞ¸Äʱ¼ä»òshutdownȥʵÏֹػú/ÖØÆô£¬µ«ÊÇ·µ»ØÖµ¶¼ÊÇʧ°ÜµÄ¡£¾¹ý¶à´ÎÊÔÑ飬È϶¨ÊÇûÓÐȨÏÞµÄÎÊÌâ¡£
ËùÒÔ£¬Ð¡µÜÔÚ´ËÇë½Ì¸÷룬ÈçºÎ²ÅÄÜÉèÖÃȨÏÞ£¬µ÷ÓÃlinux shellà ......
¹«Ë¾Ãû³Æ Ò½ÔªÍø
ְλÃû³Æ PHP¿ª·¢¸ß¼¶¹¤³Ìʦ
ÕÐÆ¸ÈËÊý 1
¹¤×÷µØµã ÉϺ£
нˮ´ýÓö ÃæÒé
µç×ÓÓÊÏä zik@yynet.cn
¹«Ë¾ÍøÖ· http://www.yynet.cn
¹«Ë¾½éÉÜ Ò½ÔªÍø-רעҽ»¼»¥¶¯£¬¼ÜÆðÒ½»¼ ......
ÎÒÔÚʹÓÃphpÒ»¶Î´úÂëÖÐ,Ô´´úÂëÊÇ
<input type="file" name="file_source" id="file_source" class="edt" value="<?=$file_source?>">
ÊÇÒ»¸öÉÏ´«Î ......
ÈçÌâ
ÐÂÍøµÄ~
²»ÖªµÀÄļҺá£ÎÒÓÃÏã¸ÛÖ÷»ú»¹ÐÐ
ÒýÓÃ
ÐÂÍøµÄ~
Õâ¸öºÃÂð£¿ÓÃÆðÀ´ºÜÂý£¬ÎÒÏÖÔÚÓõİÛÍøµÄ£¬http://www.hb666.net/
DreamHost
ÃÀ¹ú£¬ÊÀ½çµÚÒ»Á÷µÄÊշѿռä
¹úÍâ¿Õ¼äµÄ»° ......