Q&A
  • PHPÇÔ¼ö Q&A
Á¦¹ß À̰ÍÁ¡ÇذáÇØÁÖ¼¼¿ä.
±Û¾´ÀÌ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Èì¹Ù¹Ù ³¯ Â¥ 12-05-17 14:48 Á¶ ȸ 353
°£ÆíURL http://phpschool.com/link/qna_function/356280 º¹»ç

SyntaxHighlight·Î º¸±â

´äº¯Ã¤ÅÃÀ² 48 %
// ȸ¿ø°ü¸®
function pagenavigate($present_page, $total_page, $url) { // °Ô½ÃÆÇ¿¡¼­ ³Ñ¾î¿Â °ªÀÌ´Ù.
$from_page = (( (int)(($present_page - 1 ) / 10 )) * 10) + 1; // ÇöÀçÆäÀÌÁö¸¦ int·Î Á¤¼ö¸¦ ¸¸µç´Ù. ½ÃÀÛÆäÀÌÁö´Ù.
$to_page = $from_page + 9; // 10ÆäÀÌÁö¾¿ º¸¿©ÁÖ±â À§ÇÔÀÌ´Ù.

if($present_page > 10){ // ùÆäÀÌÁö¿¡¼­´Â ÀÌÀü 10ÆäÀÌÁö°¡ Á¸ÀçÇÏÁö ¾ÊÀ¸¹Ç·Î
$next_from_num_link = ($from_page * 10) - 100; // ÀÌÀüÆäÀÌÁöÀ̹ǷΠfromnumÀ» -100À» ÇØ ÁØ´Ù.
$nextpresentpage = $from_page-1; // 1ÆäÀÌÁö ÀÌÀüÀ» º¸¿©ÁØ´Ù.
$resultval .= " <a href='$url?fromnum=$next_from_num_link&page=$nextpresentpage'>[ÀÌÀü10ÆäÀÌÁö]</a> ";
}

for ($k=$from_page;$k<=$to_page;$k++){ // ½ÃÀÛÆäÀÌÁöºÎÅÍ 10ÆäÀÌÁö¸¦ º¸¿©ÁØ´Ù.
$from_num_link = ($k-1) *10; // ´ÙÀ½ 50°³ÀÇ µî·Ï¹°À» º¸¿©ÁÖ±â À§ÇÔÀÌ´Ù.
$presentpage = $k; // ÆäÀÌÁö¸¦ º¸¿©ÁØ´Ù.

if($total_page >= $k){ // ÅäÅ»ÆäÀÌÁö¼ö°¡ $kº¸´Ù Å« °ÍÀ» º¸¿©Áà¾ß 1°³¸¦ µî·ÏÇßÀ» °æ¿ì 1ÆäÀÌÁö¸¸ ³ªÅ¸³­´Ù.
if($present_page != $k){ // ÇöÀç º¸°í ÀÖ´Â ÆäÀÌÁö°¡ ¾Æ´Ï¶ó¸é ¹øÈ£¸¸ º¸¿©ÁØ´Ù.
$resultval .= " <a href='$url?fromnum=$from_num_link&page=$presentpage'> $k </a> ";
}else{
$resultval .= " <b>$k</b> "; // ÇöÀç º¸´Â ÆäÀÌÁö À̹ǷΠ±½Àº ±Û¾¾·Î º¸¿©ÁØ´Ù.
}
}

}
if($total_page > 11 && $total_page > ($from_page+10)){ // 11Àº Ãѵî·Ï¹°ÀÇ °³¼ö°¡ 11ÆäÀÌÁö¸¦ ³ÑÁö ¾ÊÀ¸¸é ´ÙÀ½10ÆäÀÌÁö¸¦ º¸¿©ÁÙ Çʿ䰡 ¾ø±â ¶§¹®¿¡ Á¸ÀçÇÑ´Ù. µÚÀÇ °ÍÀº ÃÖÁ¾ ÆäÀÌÁö¸¦ ÄÁÆ®·ÑÇϱâ À§ÇÔÀÌ´Ù.
if($total_page > ($present_page)){ // ÅäÅ» ÆäÀÌÁö¼ö°¡ ÇöÀç ÆäÀÌÁö¼öº¸´Ù Å©¸é ³ªÅ¸³» ÁØ´Ù.
$next_from_num_link = $from_num_link + 50;
$nextpresentpage = $presentpage + 1;
$resultval .= " <a href='$url?fromnum=$next_from_num_link&page=$nextpresentpage'>[´ÙÀ½10ÆäÀÌÁö]</a> ";
}
}

  return $resultval;
}



<?php
include '../include/header2.php';
include '../include/function.php';

require_once '../include/dblogin.php';
//·Î±×¾Æ¿ô »óÅÂÀ϶§. ¼öÁ¤ÇؾßÇÔ.
if(empty($_SESSION['userid'])){
echo "<script>
document.location.href='../index.php';
</script>";
}
?>

<div id="backpageimg" class="content">
   
<div id="pageimg" >   
    <img src="/img/pageimg/servicepageimg.png" alt="main" />
</div>
    </div>

<!-- ³»¿ëºÎºÐ ½ÃÀÛ-->
    <div id="backpage" class="content"> 
   
    <div id="page" >

  <div id="side">
     
   

<a href="admin.php"><img src="./img/web_icon15.png" alt="ÁÖ¹®°ü¸®" style="position:absolute" /></a>
<a href="admin_products.php"><img src="./img/web_icon16.png" alt="»óǰ¸ñ·Ï" style="position:absolute;top:30px" /></a>
<a href="admin_members.php"><img src="./img/web_icon13.png"  alt="ȸ¿ø°ü¸®"  style="position:absolute;top:60px;left:-5px"/></a>



      </div><!-- side -->
   
<div id="cont" >
 

  <?
   
$page=$_GET['page'];
$fromnum=$_GET['fromnum'];

echo $find=$_POST['find'];
      echo $search=$_POST['search'];
        if('homepage'==$_SESSION['userid']){
$numsql="select * from members where userid!='{$_SESSION['userid']}' and $find like '%$search%'";
$numresult=mysql_query($numsql);
$numrows=mysql_num_rows($numresult);
$totalpage=ceil($numrows/10);
if($numrows <1)
echo "ȸ¿øÀÌ ¾ø½À´Ï´Ù.";

?>
       
       
<table width="100%" border="0">
<tr>
<td width="120"><font  size="5" >ȸ¿ø°ü¸®</font></td><td>(ÃÑȸ¿ø¼ö :<? echo number_format($numrows); ?>)</td>
</tr>
<tr height="2">
<td bgcolor="#00CCFF" colspan="2"></td>
</tr>

</table>


<FORM NAME="Form1" METHOD="Post" ACTION="admin_members_search.php" onSubmit="return Form1_check(this);">
<select name="find" >
<option value="name">À̸§</option>
<option value="userid"> ¾ÆÀ̵ð</option>
</select>
<input type=text name="search" size=12  value="<? echo $search; ?>">
<input type="image" src="./img/se.png"  align="absmiddle">
</FORM>

<table width="100%"  border="0" cellpadding="0" cellspacing="0">
<tr height="30">
<td align="center" bgcolor="#E9FEFB">¾ÆÀ̵ð</td>
                <td align="center" bgcolor="#E9FEFB">À̸§</td>
                <td align="center" bgcolor="#E9FEFB">¼ºº°</td>
                <td align="center" bgcolor="#E9FEFB">À̸ÞÀÏ</td>
                <td align="center" bgcolor="#E9FEFB">ÁÖ¼Ò</td>
                <td align="center" bgcolor="#E9FEFB">ÈÞ´ëÆù</td>
                <td align="center" bgcolor="#E9FEFB">¼öÁ¤»èÁ¦</td>
</tr>

     
        <?

   
if(!$page) $page=1;
if($page==1) {$fromnum=0;}else{$fromnum=$page*10-10;}

$sql="select * from members where userid!='{$_SESSION['userid']}' and $find like '%$search%' order by userid desc limit $fromnum,10";
$result=mysql_query($sql);



while($row=mysql_fetch_row($result)){


?>
        <tr>
       
       

        <td align="center" height="25"><? echo $row[0] ?></td>
        <td align="center" ><? echo $row[2] ?></td>
        <td align="center"><? if($row[3]==1){ echo '³²ÀÚ';}else{ echo '¿©ÀÚ';}  ?></td>
        <td align="center"><? echo $row[4]; ?></td>
        <td align="center"><? echo $row[5].'-'.$row[6].$row[7].$row[8] ?></td>
        <td align="center"><? echo $row[9]; ?></td>
        <td align="center"><a href="admin_delcheck.php?id=<? echo $row[0] ?>">»èÁ¦</a><a href="admin_modify.php?id=<? echo $row[0] ?>">¼öÁ¤</a></td>
        </tr>
        <tr><td colspan="7" height="1" bgcolor="#cccccc"></td></tr>
        <?


}
?>
       
       
        </table>
        <table width="100%">
        <tr><td colspan="7" height="10"></td></tr>     
            <tr><td colspan="7" height="1" bgcolor="#6699ff"></td></tr>
            <tr><td colspan="7"></tr>
        </table>
     
        <p>
          <center><? echo pagenavigate($page, $totalpage, "$PHP_SELF",$find,$search)?></center>
</p>
     
<? }else{echo 'À̰÷Àº °ü¸®ÀÚ ÆäÀÌÁöÀÔ´Ï´Ù.' ;}  ?>
   
 
    </div><!-- cont -->


   
    </div><!-- page -->
 
      <?
  include '../include/end.php';
  ?>
   
 
 
    </div><!-- backpage -->
    <!-- ³»¿ëºÎºÐ ³¡-->

 
 

<?php
include '../include/footer.php';
?>


°Ë»ö±â´ÉÀÔ´Ï´Ù °Ë»ö±â´ÉÇÏ¸é °Ë»öµÈ³»¿ëÀÌÃâ·ÂµË´Ï´Ù ÇÏÁö¸¸ ÆäÀÌ¡À¸·Î ´ÙÀ½ÆäÀÌÁö°¡¸é $find °ú $seach¿¡ °ª¿¡ null°ªÀ̵Ǵµ¥ ÇØ°á¹æ¹ýÁ¡...
getÀ¸·Î ÀÚ·á³Ñ°ÜÁÖ°í ¤²¸Ó±×·±»ý°¢Çß´Àµ¥ Àß¾ÈµÈ¿ä ¤Ì¤Ì Á¤È®ÇÑ ´äÁ¡ ¤Ì¤Ì

Àüü´ñ±Û¼ö 2

  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°õÅ丮 12-05-17 14:56

    ¼Ò½ºº¸±â

  • ÆäÀÌÁö ½ÃÀÛÁ¡¿¡ $find = $_REQUEST[find]; $seach = $_REQUEST[seach];
    ¸¦ Ãß°¡Çغ¸°í print_r() ·Î °ªÀÌ Á¤»óÀûÀ¸·Î µé¾î¿À´ÂÁö È®ÀÎ ÇØº¸¼¼¿ä.
    get À¸·Î ³Ñ±ä´Ù°í ÇØµµ º¯¼ö ¼±¾ð ¾ÈÇÏ¸é ¾Èµé¾î°¥ ¼ö ÀÖÀ¸´Ï °ËÁõÀÌ Áß¿äÇÕ´Ï´Ù.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Èì¹Ù¹Ù 12-05-17 15:24

    ¼Ò½ºº¸±â

  • ¿À ¿ª½Ã ´ÔÀÌ ´ä±ÛÀ» ´Þ¾ÆÁּ̱º¿ä^^
  • °Ô½Ã¹° 130,436°Ç RSS
¹øÈ£´äº¯Á¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
°øÁö - [Çʵ¶»çÇ×]Q&A °Ô½ÃÆÇ ±ÔÄ¢ [51] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Ä¿ÇÇÇÑÀÜ 08-10-01 144180
130,116 ´äº¯¿Ï·á ÇØÅ· Àΰ¡¿ä? ¿ÜºÎ ip´Â form submitÀÌ µÇÁö ¾Ê½À´Ï´Ù. [3] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§SoundChaser 13-04-26 140
130,115 ´äº¯ÁøÇà ¹®ÀÚ Ä¡È¯ ¹®ÀÇÇÕ´Ï´Ù. [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÆÄ¶õ»êŸ 13-04-26 94
130,114 ´äº¯ÁøÇà extract() ÇÔ¼ö °ü·ÃÀÔ´Ï´Ù. [4] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§È­¶ûÃÊ 13-04-26 134
130,113 ´äº¯¿Ï·á ƯÁ¤ ÆÐÅÏÀ¸·Î ¹®ÀÚ¿­¸¸ »Ì¾Æ¿À°í ½Í¾î¿ä [1] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ÅÀç 13-04-26 123
130,112 ´äº¯ÁøÇà nusoap ´Â ¼­¹öµµ nusoap¸¦ »ç¿ëÇÏ¿©¾ß Çϴ°ǰ¡¿ä?? [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Áö³×µòÁö´Ü 13-04-26 91
130,111 ¹Ì´äº¯ °Ô½ÃÆÇ ÆäÀÌ¡À» ±×·ìÈ­(?)ÇØ¼­ ÇϽô ºÐ °è½Å°¡¿ä... Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Å©¸®½ºÅ踰 13-04-26 188
130,110 ¹Ì´äº¯ IE °ü¸®ÀÚ ¸ðµå¿Í ¼¼¼Ç°øÀ¯Çϱâ Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¸á·Ð³óÀå 13-04-26 113
130,109 - °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [3] ¸Ó¸®¾ÆÆÛ 13-04-26 93
130,108 ´äº¯¿Ï·á īī¿ÀÅå ¸µÅ©¸Þ¼¼Áö ÁٹٲÞÀÌ .. [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ºÄðµ¥¹ÌÁö 13-04-26 145
130,107 ´äº¯¿Ï·á ´Ù½ÃÇѹø Áú¹® mailÇÔ¼öÁ¦¸ñ±úÁü [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°í¸±¶óphp 13-04-26 100
130,106 ´äº¯ÁøÇà C <-> PHP ¼ÒÄÏÅë½Å Áú¹®µå¸³´Ï´Ù. [1] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§php¿ÕÃʺ¸! 13-04-26 130
130,105 - °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [1] Âî¶õÀÌ 13-04-26 90
130,104 ´äº¯ÁøÇà ÁÖ¼Ò·Î ÁÂÇ¥µû±â.. [1] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§À̳ª¶óÇлý 13-04-26 115
130,103 ´äº¯ÁøÇà pdf´Ù¿î·Îµå [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Âü¿ÀÀÏ 13-04-26 93
130,102 ¹Ì´äº¯ ¹®ÀÚ¿­ ġȯ... ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§°ø¼ö´Ï 13-04-26 98
130,101 ´äº¯¿Ï·á ÀÌ ÄÚµåÀÇ ¹®Á¦ Á» ºÁÁÖ¼¼¿ä(¿©·¯°³ÀÇ Ä÷³ »ý¼º °ü·Ã) [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§µµÅçÀÌ 13-04-26 84
130,100 ¹Ì´äº¯ ¿À¶óŬ ÇÑ±Û null Çö»ó ¹®ÀÇ µå¸³´Ï´Ù. ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¾ç¹Î 13-04-25 95
130,099 ´äº¯ÁøÇà php¸¦ exe ÆÄÀÏ·Î ¸¸µå´Â »ó¿ëÇÁ·Î±×·¥ÀÌ¶óµµ ºÎŹ¿ä [1] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ºÇÇÄ¿ 13-04-25 132
130,098 ¹Ì´äº¯ httpsÁÖ¼Ò È£Ãâ ÇØÁÖ·Á°íÇϴµ¥¿ä curl_exec¿¡¼­ ¸ÔÅëÀÌ¿¡¿ä Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¸Ó¸®¾ÆÆÛ 13-04-25 115
130,097 ¹Ì´äº¯ ³×À̹ö Áöµµ¿¡¼­ Áöµµ°¡ º¸ÀÌÁú ¾Ê½À´Ï´Ù. Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¶ó¿ÂÁ¦³ª 13-04-25 100
 
11121314151617181920