APPLICATION
|
|
¡° »ê¾÷´ë¹èµå¹ÎÅÏŬ·´ ¸® ¡±
Ãֱ٠Ȱ¿ëÆÁ °øÀ¯ RANK
-- update:30Min -- |
|
¾ÆÀ̺¸µå¿¡ ÆäÀÌÁö ¹øÈ£ Àû¿ëÇϱâ
application
Ȱ¿ëÆÁ °øÀ¯
|
Å×Å©³ëÆ® »ç¿ë¿¡ °ü·ÃµÈ ³ëÇϿ츦 °øÀ¯ÇÏ´Â °Ô½ÃÆÇÀÔ´Ï´Ù.
ȨÆäÀÌÁö ÀÛ¾÷/¿î¿ëÁß¿¡ ¾Ë°Ô µÈ ¿©·¯°¡Áö Ȱ¿ëÆÁÀ» ¿Ã·Á ÁÖ¼¼¿ä.
³ª¿¡°Õ ±×Àú ½À°üÀÏ »ÓÀÌ´ø °ÍÀÌ ´©±º°¡¿¡°Õ ¾öû Å« Èû°ú µµ±¸°¡ µÇ´Â °æ¿ì°¡ ¸¹´ä´Ï´Ù.
ÀÚ·áµî·Ï½Ã Àû¸³µÇ´Â Æ÷ÀÎÆ®´Â 200P ÀÔ´Ï´Ù.
|
|
|
|
|
¤ýÁ¶È¸: 1441 ¤ýÃßõ: 20
|
|
| ¤ýÀÛ¼ºÀÏ: 2010³â 11¿ù 4ÀÏ ¸ñ¿äÀÏ |
|
|
¡° ¾ÆÀ̺¸µå¿¡ ÆäÀÌÁö ¹øÈ£ Àû¿ëÇϱ⠡±
¾ÆÀ̺¸µå¿¡¼ ÆäÀÌÁö ¹øÈ£¸¦ Ãâ·Â ÇÒ ¼ö ÀÖµµ·Ï ÇØ ÁÖ´Â ¼Ò½º ÀÔ´Ï´Ù. Áú´ä°Ô½ÃÆÇ¿¡ Áú¹®ÀÌ Àֱ⵵ Çϰí, ³ª¸§ Àû¿ëÇØ ³õÀº ¼Ò½º°¡ ÀÖ¾î¼ Á¤¸®Çؼ ¿Ã¸³´Ï´Ù. http://technote.co.kr/php/technote1/board.php?board=memberqna&command=body&no=23392 Àú´Â '»ðÁú' »çÀÌÆ® ÅëÇÕ°Ë»ö¿¡ Àû¿ëÇß±¸¿ä.. Á¦°¡ Àû¿ëÇÑ ¼Ò½º´Â util_iboard_lib ÆÄÀÏ¿¡¼ ÇßÀ¸³ª,, »çÀÌÆ®¿¡ ¸Âµµ·Ï ¸¸µé´Ù º¸´Ï Á» º¹ÀâÇÑ°Í °°¾Æ¼ ±×º¸´Ù´Â ¾à°£ ½¬¿î kºô´õÀÇ insert_iboard1_home.php ¿¡¼ Àû¿ëÇÏ´Â ¹æ¹ýÀ» ¼Ò°³ ÇÕ´Ï´Ù. util_iboard_lib ÆÄÀÏ¿¡ Àû¿ëÇÏ´Â ¹æ¹ýµµ, ¾Æ·¡¸¦ Çѹø ÀÐ¾î º¸½Ã¸é, ±Ý¹æ ¾Ë ¼ö ÀÖÀ»°Å¶ó »ý°¢ µì´Ï´Ù..) 1. ¸ÕÀú Å×½ºÆ®¸¦ À§ÇØ insert_iboard1_home ÆÄÀÏÀ» º¹»çÇØ¼ insert_iboard1_home2.php ·Î ÇÏ°í »ó´Ü¿¡ <? global $db_ident,$page; // ====== ¼³Á¤ ============ $iboard_URI="board.php?board=$GLOBALS[board]&command=skin_insert&exe=insert_iboard1_home2"; //Ãâ·ÂµÉ ¾ÆÀ̺¸µå±âº» url $bbsnames="freeboard/community1/community2/community3"; //¾î´À º¸µå¿¡¼ Ãâ·Â ÇÒ°ÍÀΰ¡? $index_many=10; //ÆäÀÌÁö´ç ±ÛÀ» ¸î°³ Ãâ·Â ÇÒ°ÍÀΰ¡? 10°³ $print_pg=5; //ÆäÀÌÁö ¹øÈ£¸¦ ¸î°³ Ãâ·Â ÇÒ°ÍÀΰ¡? 5°³ // ======================== foreach(explode('/',$bbsnames) as $value) { $bbs_ad_table=$db_ident."2_".$value."_ad"; $sql=SQL_select_Fetch(" no='1' "," $bbs_ad_table "); //a_tn2_º¸µå_ad Å×À̺í, no=1, tx6_8 Ä÷³¿¡ $bbs_total=$bbs_total+$sql[tx6_8]; //150; //Ãѱ۰¹¼ö } if(!$page) $page=1; //ÆäÀÌÁö°¡ ¾øÀ»¶§ 1 $skip=$index_many*($page-1); //°Ç³Ê¶Û °¹¼ö $total_page=ceil($bbs_total/$index_many); //¸¶Áö¸· ÆäÀÌÁö ¹øÈ£ $cell_NO=ceil($page/$print_pg); //Çѹø¿¡ Ãâ·ÂµÉ ÆäÀÌÁöµéÀÇ ¹À½ ¹øÈ£ if($cell_NO>1) $lastpage=$cell_NO*$print_pg; //ÇöÀç Ãâ·ÂµÈ ÆäÀÌÁö¹À½ÀÇ ¸¶Áö¸·ÆäÀÌÁö ±¸ÇÔ else $lastpage=$print_pg; ?> ¿Í °°ÀÌ ¼Ò½º¸¦ ºÙ¿© ³Ö½À´Ï´Ù.
2. À§ ¼Ò½º¿¡¼ == ¼³Á¤== ¶õ¿¡ ÀÖ´Â 4°÷À» ¼öÁ¤ÇØ ÁÝ´Ï´Ù.
3. ¾à°£ ¾Æ·¡ÂÊ¿¡... ¾Æ·¡¿Í °°ÀÌ Ãâ·Â ¼³Á¤¼ÂÀ» ¸¸µì´Ï´Ù.
// ÀÏ¹Ý ´Ü¼øÇüÅ Ãâ·Â¼³Á¤ ¼ÂÆ® $PAGE_style_set=array( TABLE_head_function => "none", // Å×ÀÌºí »ó´Ü function TD_function_set => "TD_subject3/TD_date", # Á¦¸ñ/³¯Â¥ table_width => "288", subject_width => "250", subject_length => "31", subject_icon => "$this_skin/b_img_add/point_disk2.gif", new_icon_time => "12", mysql_orderby => "wdate", // select Äõ¸®ÀÇ order by Àý ¿É¼Ç (¿¹, Á¶È¸¼ö¿¡ ÀÇÇÑ Ãâ·Â¼ø¼·Î Ãâ·ÂÇ϶ó : " hit " ) //¾Æ·¡ºÎÅÍ´Â ÆäÀÌÁö Àû¿ë¶§ »ç¿ë == mysql_skip => "$skip", // select Äõ¸®ÀÇ limit skip ¿É¼Ç (¿¹, 3À» ÁöÁ¤ÇÏ¸é ¸ñ·ÏóÀ½¿¡¼ 3°³¸¦ ¶Ù°í select ÇÑ´Ù.) index_many => "$index_many", page_cnt => "1", //¿©·¯°³ º¸µå¸¦ Á¶ÀÎÇϸç, ÆäÀÌÁö ¹øÈ£ Ãâ·ÂÇÒ¶§´Â ¹Ýµå½Ã 1 ·Î ÁöÁ¤ );
4. ÆäÀÌÁö ¹øÈ£Ãâ·ÂÀ» À§ÇØ ¾Æ·¡¿Í °°ÀÌ iBoard_Print_Here(~~) ÀÂÊÀ̳ª ¾Æ·¡ÂÊ, µî.. ¿øÇÏ´Â À§Ä¡¿¡ ¾Æ·¡ÀÇ ÆäÀÌÁö ¼Ò½º¸¦ ³Ö¾î ÁÝ´Ï´Ù. <? iBoard_Print_Here($bbsnames,$PAGE_style_set); // ÆäÀÌÁö¹øÈ£ Ãâ·Â ========= if($cell_NO>1) echo "<a href='$iboard_URI&page=".(($cell_NO-1)*$print_pg)."'>ÀÌÀü</a> "; //ÀÌÀü for($n=($lastpage-$print_pg+1); $n<=$lastpage; $n++){ //ÆäÀÌÁö¹øÈ£ if($n<=$total_page){ echo "<a href='$iboard_URI&page=$n'>"; if($page==$n) echo "<span style='color:red'>"; else echo "<span>"; echo "[$n]</span></a> "; } } if(($total_page/$print_pg)>$cell_NO) echo "<a href='$iboard_URI&page=".($cell_NO*$print_pg+1)."'>´ÙÀ½</a> "; //´ÙÀ½ // Ãâ·Â ³¡ ======== ?>
5. ¿©±â¼ ¾à°£? Áß¿äÇÔ¤»¤» ÇÑÂü ¾Æ·¡ÂÊ¿¡ ÀÖ´Â ¸ñ·ÏÃâ·Â ÇÔ¼ö¿¡¼ if($tablecnt<2) $is_query.="select * from $list_table $whereStr $sub_query"; ¼Ò½º¸¦ ã¾Æ ¹Ù·Î ¾Æ·¡ÁÙ¿¡ else if($Print_option[page_cnt]=='1') $is_query.="(select * from $list_table $whereStr)"; //Ãß°¡ ¼Ò½º¸¦ Ãß°¡ ÇØ ÁÝ´Ï´Ù.
------------------- 5¹øÀ» ÇÏ´Â ÀÌÀ¯´Â ... ´ÜÀϺ¸µå¿¡¼ mysql_skip À» ÇØ ÁÖ¸é ¹®Á¦°¡ µÇÁö ¾ÊÁö¸¸ ¿©·¯ Å×À̺íÀ» Á¶ÀÎÇÏ°Ô µÇ¸é ¹Ýº¹Çؼ °Ç³Ê¶Ù´Â ¹®Á¦Á¡ÀÌ ÀÖ¾î¼... Ãß°¡ÇØ Áá½À´Ï´Ù. ¹Ù·Î ¾Æ·¡ else $is_query.="(select * from $list_table $whereStr $sub_query)"; ¿¡¼ $sub_query ¸¦ »èÁ¦Çصµ µÉ°Í °°Àºµ¥.. Ȥ½Ã ¸ô¶ó¼^^ ÇÑ ÁÙ ´õ Ãß°¡¸¦ ¼±Åà Çß½À´Ï´Ù..
¹Ì¸®º¸±â : http://sabjil.wo.tc/preview/?q=apple:1060
|
19
|
 |
|