// ȸ¿ø°ü¸®
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À¸·Î ÀÚ·á³Ñ°ÜÁÖ°í ¤²¸Ó±×·±»ý°¢Çß´Àµ¥ Àß¾ÈµÈ¿ä ¤Ì¤Ì Á¤È®ÇÑ ´äÁ¡ ¤Ì¤Ì
// ȸ¿ø°ü¸®
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À¸·Î ÀÚ·á³Ñ°ÜÁÖ°í ¤²¸Ó±×·±»ý°¢Çß´Àµ¥ Àß¾ÈµÈ¿ä ¤Ì¤Ì Á¤È®ÇÑ ´äÁ¡ ¤Ì¤Ì