|










|
|
|
 |
0 |
|
View Articles |
|
 |
 Name |
¿À¼®Áø |
(2004-04-27 13:00:14, Hit : 8537, Vote : 1809)
|
|
 |
Subject |
 ¿À·£¸¸¿¡ Áú¹®µå¸³´Ï´Ù. |
 |
 |
¾ß±¸±â·Ï½Ç °ü·ÃÇØ¼ ¿©·¯°¡Áö Áú¹®µå·È´ø »ç¶÷ÀÔ´Ï´Ù.
¼Õº´¸ñ´Ô°ú µÎ¸®¹¶½Ç´Ô ´öºÐ¿¡ ¼º°øÇß½À´Ï´Ù.^.^ Áö±Ý ĪÂùÀÌ ÀÚÀÚÇÕ´Ï´Ù.
À߸¸µé¾ú´Ù°í¿ä.. °¨»çµå¸³´Ï´Ù.
±â·ÏÁ¤·Ä°ú °ü·ÃµÇ¾î¼ Áú¹®ÀÌ ÀÖ¾î¼ ±ÛÀ» ³²±é´Ï´Ù.
http://www.yagootj.com/record_batter/list_batter.php
Áú¹®1. ´©ÀûŸÀ²°è»ê½Ã ¼Ò¼öÁ¡ 3ÀÚ¸®±îÁö Ç¥½ÃÇÏ·Á¸é...========================================
ab->Ÿ¼ö hit->¾ÈŸ
$query="select sum(ab) as s_ab,sum(hit) as s_hit,sum(hit)/sum(ab) as s_hra from $tablename ".$que_league." ".$and." ".$que_team1." GROUP BY name,team1,league order by $select_arrange_s $desc limit $offset, $list_num";
ÀÌ·¯ÄÉÇϴϱî s_hra°ªÀÌ ¼Ò¼öÁ¡ µÎÀÚ¸®°ªÀ¸·Î Á¤ÇØÁ® ¹ö¸®´õ¶ó±¸¿ä.
$s_hra = (number_format($array[s_hra],3));
À̺¯¼ö¸¦ Ãß°¡Çصµ ¼¼ÀÚ¸®¼Ò¼öÁ¡Àº 0À¸·ÎÇ¥½Ã°¡µË´Ï´Ù.
±×·¡¼ sum(hit)/sum(ab) as s_hraÀ» ¾ø¾Ö°í
$s_hra = (number_format($array[s_hit]/$array[s_ab],3)); ¸¦ ³ÖÀ¸¸é
¼Ò¼öÁ¡ 3ÀÚ¸®±îÁö Á¤»óÇ¥½ÃµÇ±äÇϴµ¥, s_hitÇϰí s_ab°ªÀÌ 0 ÀÎ ¼±¼ö´Â
Warning: Division by zero in /home/triple/yagootj/record_batter/list_batter.php on line 339
ÀÌ·±½ÄÀ¸·Î °è»ê¿À·ù¶ó°í ¶ß´õ±º¿ä.
°è»ê¿À·ùµµ ¾È¶ß°Ô ÇÏ°í ¼Ò¼öÁ¡ 3ÀÚ¸®±îÁö Ç¥½ÃµÇ°Ô Çϴ¹æ¹ýÀÌ ¾øÀ»±î¿ä?
Áú¹®2.-==================================================================================
±â·ÏÀ» s_hra ¿¡ ÀÇÇØ Á¤·Ä½ÃÄ״µ¥, s_ab °ª°ú s_hit°ªÀÌ 0ÀÎ ¼±¼ö°¡ ÃÖ»óÀ§·Î Á¤·ÄÀÌ µÇ´õ±º¿ä. ¾Æ¸¶ 0/0 ÀÌ¸é ¹«ÇÑ´ë°¡ Ç¥½ÃµÇ¼ ±×·±°Å °°Àºµ¥ ÇØ°á¹æ¹ýÀº ¾ø´ÂÁö¿ä.
Áú¹®3. Á¤·Ä¼ø¼ÀÇ º¹¼öÁöÁ¤..===============================================================
ÇöÀç ÃʱâÁ¤·Ä°ªÀÌ s_hraÀÔ´Ï´Ù. À̶§ s_hra °ªÀÌ °°Àº µÎ¼±¼ö°¡ ÀÖÀ»¶© s_hit°ªÀÌ ´õÅ« ¼±¼ö¸¦ »óÀ§ Á¤·Ä½Ã۰íÀÚ ÇÕ´Ï´Ù.
Áï.-----s_ab s_hit s_hra
°È£µ¿ 12 6 0.500
À¯Àç¼® 10 5 0.500
s_hra°ªÀÌ °°À¸¸é s_hit°ªÀÌ Å«¼±¼ö¸¦ »óÀ§Á¤·Ä½ÃŰ·Á°íÇÕ´Ï´Ù.
Áú¹®4. ±ÔÁ¤Å¸¼ö ¿ì¼±Á¤·Ä===================================================================
3¹øÁú¹®°ú ºñ½ÁÇÑ ³»¿ëÀÌ µÉ°Í °°Àºµ¥¿ä.
s_ab°ªÀÌ Á¤ÇØÁø ¼ýÀÚ(±ÔÁ¤Å¸¼ö-º¯¼öó¸®) ÀÌ»óÀÎ ¼±¼ö¸¦ ¿ì¼±ÀûÀ¸·Î Á¤·ÄÇÑ´ÙÀ½, Á¤ÇØÁø¼ýÀÚÀÌÇÏÀÎ ¼±¼ö¸¦ ±×ÀÌÇÏ·Î Á¤·ÄÇϴ¹æ¹ýÀº ¾ø´ÂÁö¿ä.
Áú¹®5. ¼øÀ§ ¸Å±â±â=========================================================================
ÀÌ°Ç Á¦°¡ ÇØºÁ¼ ¼øÀ§¸Å±â±â´Â °¡´ÉÇߴµ¥.. ¼ø¼´ë·Î ±×³É ÁÖ¿í---1,2,3,4,---ÀÌ·¯ÄÉ 됬½À´Ï´Ù.
ÀÌ·¯ÄÉ º¯¼öó¸® Ç߰ŵç¿ä
$no=0;
$no=$no+1;
http://www.yagootj.com/record_result/list_rank.php?league=4
½Â·ü¿¡ ÀÇÇØ Á¤·Ä½ÃŰ·Î ±×¿¡ µû¶ó ¼øÀ§¸¦ ºÎ¿©Çߴµ¥¿ä.
½Â·üÀÌ °°À¸¸é °°Àº¼øÀ§°¡ Ç¥½ÃµÇ°Ô ÇÏ·Á°í ÇÕ´Ï´Ù.
¼øÀ§ ÆÀ ½Â·ü ----
1 A 1.000
1 B 1.000
1 C 1.000
4 D 0.900
4 E 0.900
6 F 0.800
ÀÌ·±½ÄÀ¸·Î Ç¥ÇöµÇ°Ô ÇÏ·Á°í ÇÕ´Ï´Ù.
¾î¶»°Ô ÇØ¾ß ÇÒ·±Áö¿ä..
=========================================================================================
¿À´Ã ³Ê¹« ¸¹Àº Áú¹®À» µå·È³×¿ä.. ±×µ¿¾È È¥ÀÚ¼ ²þ²þ´ë´Ù°¡ ³Ê¹« ¾ÈÇ®·Á¼ µµ¿òÀ» ±¸ÇÕ´Ï´Ù. ^.^
Ç×»ó Ä£ÀýÇÑ ´äº¯ °¨»çµå¸³´Ï´Ù ²Ù¹÷
|
 ¼Õº´¸ñ |
¸ÕÀú, Áú¹® 1¹ø¿ä.
select sum(ab) as s_ab,sum(hit) as s_hit,sum(hit)/sum(ab) as s_hra..... ¿¡¼
sum(hit)/sum(ab) ºÎºÐÀ» round(sum(hit)/sum(ab),3)¿Í °°ÀÌ ¹Ù²ãº¸¼¼¿ä. ¾Æ¸¶ µÉ °Ì´Ï´Ù. |
|
|
 ¼Õº´¸ñ |
Áú¹® 2´Â, ÀÌÇØ°¡ Àß ¾ÈµË´Ï´Ù.
0Ÿ¼ö 0¾ÈŸÀÇ °ªÀº ¾ö°ÝÇÏ°Ô ¸»ÇÏ¸é ¿À·ùÀε¥, ½ÇÁ¦ s_hra°ª¿¡´Â NULL °ªÀÌ ÀԷµ˴ϴÙ. µû¶ó¼ NULLÀÇ °ªÀº 0º¸´Ù ÀÛ°Ô Ãë±ÞµÇ¾î, ³»¸²Â÷¼øÀ¸·Î Á¤·ÄÇÏ¸é °¡Àå ³·°Ô, ¿Ã¸²Â÷¼øÀ¸·Î Á¤·ÄÇÏ¸é °¡Àå ³ô°Ô Ç¥½ÃµË´Ï´Ù.
Á¦°¡ Å×½ºÆ®Çغ» °á°ú ±×·¸½À´Ï´Ù. |
|
|
 ¼Õº´¸ñ |
Áú¹® 3Àº °£´ÜÇÕ´Ï´Ù.
s_hra ±âÁØÀ¸·Î ³»¸²Â÷¼ø, s_hit ±âÁØÀ¸·Î ³»¸²Â÷¼øÀ» µ¿½Ã¿¡ Àû¿ëÇÏ¸é µË´Ï´Ù.
ORDER BY s_hra DESC, s_hit DESC ¶ó°í ÇÏ¸é µË´Ï´Ù. |
|
|
 ¼Õº´¸ñ |
Áú¹® 4´Â 3¹ø ´äº¯À» º¸°í ÀÀ¿ëÇØ º¸½Ã¸é µÉ °Í °°³×¿ä. |
|
|
 ½Ãµð¸Ç |
Áú¹® 1,3¹øÀº ÇØ°á됬½À´Ï´Ù. Á¤¸» ³Ê¹«³Ê¹« °¨»çÇÕ´Ï´Ù. ^.^
Áú¹® 2ÀÇ °æ¿ì
http://www.yagootj.com/record_batter/list_batter.php?league=2 ÀÇ °æ¿ìÀÔ´Ï´Ù. 0Ÿ¼ö 0¾ÈŸÀÇ ¼±¼ö°¡ °¡ÀåÀ§¿¡ Á¤·ÄÀÌ µË´Ï´Ù.
$query="select Áß·« name,sum(ab) as s_abi,sum(hit) as s_hit,round(sum(hit)/sum(ab),3) as s_hra Áß·« from $tablename ".$que_league." ".$and." ".$que_team1." GROUP BY name,team1,league order by $select_arrange_s desc, s_hit DESC limit $offset, $list_num"; // SQL Äõ¸®¹®
$select_arrange_s ÀÇ º¯¼ö󸮴 ´ÙÀ½°ú °°ÀÌ Çß½À´Ï´Ù.
if($select_arrange_s=="") {$select_arrange_s="s_hra";}
====================================================
5¹øÁú¹®¿¡ ´ëÇÑ ´äµµ ºÎʵ右´Ï´Ù.^.^
Ç×»ó °¨»çÇÕ´Ï´Ù. |
|
|
 ¼Õº´¸ñ |
Áú¹® 5¿¡ ´ëÇÑ ´äÀÌ Á» ´Ê¾ú³×¿ä. Á˼ÛÇÕ´Ï´Ù.
ÀÌ°Ç ¼³¸íÀÌ Á» º¹ÀâÇÕ´Ï´Ù. ¹è¿À» ÀÌ¿ëÇØ¾ßÇÒ °Í °°³×¿ä.
¸¸¾à ½Â·üÀÇ °ªÀÌ $ÇöÀç½Â·ü¿¡ ÀúÀåµÈ´Ù°í °¡Á¤ÇÕ´Ï´Ù. Áö³ ½Â·ü,Áï ¹Ù·Î ÀüÀÇ ½Â·üÀº $½Â·ü¿¡ ÀúÀåµÈ´Ù°í °¡Á¤Çϱ¸¿ä.
¼øÀ§´Â $grade ¹è¿º¯¼ö¸¦ »ç¿ëÇÕ´Ï´Ù(ÇöÀç´Â $no¸¦ »ç¿ëÇßÁÒ?). ´ë½Å $no´Â ÷ÀÚ·Î »ç¿ëÇÕ´Ï´Ù.
$no´Â ´Ü¼øÇÑ ¼ø¼¸¸À» ³ªÅ¸³À´Ï´Ù. µû¶ó¼ $grade[1]À̸é ù¹øÂ° °ªÀÇ ¼øÀ§¶ó´Â ¶æÀÌÁÒ. ÀÌ°Ç ´ç¿¬È÷ 1ÀÌ µÇ°ÚÁÒ.
$grade[2]´Â µÎ¹øÂ° ¼øÀ§¶ó´Â ¶æÀε¥, À̰ÍÀº 2°¡ µÉ ¼öµµ ÀÖ°í ù¹øÂ° °ª°ú µ¿ÀÏÇϸé 1ÀÌ µÉ ¼öµµ ÀÖ´Â °Ì´Ï´Ù.
¿¹¸¦ µé¾î, ¸¸¾à $no°¡ 1À̸é
$grade[$no] = $no ; // ¡æ $grade[1] = 1; °ú µ¿ÀÏÇÑ ¶æÀÔ´Ï´Ù.
½Â·üÀÌ ¸ðµÎ ´Ù¸£´Ù¸é,
$grade[2] = 2
$grade[3] = 3 °ú °°ÀÌ ÁøÇàµÇ°ÚÁö¸¸,
¸¸¾à ³×¹øÂ° ½Â·üÀÌ ¼¼¹øÂ° ½Â·ü°ú µ¿ÀÏÇÏ´Ù¸é
$grade[4] = 3 °ú °°ÀÌ, ³×¹øÂ° ¼øÀ§($grade[4])¿¡µµ Àü¼øÀ§(3)ÀÇ °ªÀÌ ÀúÀåµÇ¾î¾ß ÇÕ´Ï´Ù.
À̰ÍÀ» ÄÚµùÇÏ¸é ´ë·« ´ÙÀ½°ú °°½À´Ï´Ù.
$no = 1;
while(...) { // ¹Ýº¹¹® ½ÃÀÛ
$ÇöÀç½Â·ü = ÇöÀç½Â·ü;
if($ÇöÀç½Â·ü == $½Â·ü) {
$grade[$no] = $grade[$no-1];
} else {
$grade[$no] = $no;
}
$½Â·ü = $ÇöÀç½Â·ü;
$no = $no+1;
} // ¹Ýº¹¹® ³¡
¹¹°¡ Á» ºüÁø °Í °°Áö¸¸, ÇÏ¿©Æ° ¼øÀ§¸¦ ¹è¿¿¡ ÀúÀå½Ã۸é¼, ÀÌÀüÀÇ °ª°ú ºñ±³ÇØ¾ß ÇÏ´Â °ÍÀº ¸Â½À´Ï´Ù.
Çѹø ½ÃµµÇغ¸¼¼¿ä... |
|
|
 |
 |
|
|

|
|

|
|