페이징 처리에 대하여 질문 드려요 채택완료

<?</p>

<p>/* Load DB */

$conn = mysqli_connect('123.456.789.012', 'aaaaaa', 'bbbbbb', 'aaaaaa');

if ( !$conn ) die('DB Error');</p>

<p>/* Set to UTF-8 Encoding */

mysqli_query($conn, 'set session character_set_connection=utf8;');

mysqli_query($conn, 'set session character_set_results=utf8;');

mysqli_query($conn, 'set session character_set_client=utf8;');</p>

<p>

  if(!$start) $start = 1;</p>

<p>  // 전체 페이지 구하기

  $query = "select count(*) from g5_write_estimate where 1";

  if($Search_Text){

     $query .= " and wr_name like '%$Search_Text%' ";

  }

  $result = mysqli_query($conn, $query);

  $data = mysqli_fetch_array($result);

  $total = $data[0];</p>

<p>  echo "$total  ";</p>

<p>  // 한화면에 표시될 페이지수

  $pagenum = 10;</p>

<p>  // 총페이지수

  $pages = round($total / $pagenum);</p>

<p>  // 시작변수

  $s = $pagenum * ($start-1);</p>

<p>  $query = "select * from g5_write_estimate where 1 ";</p>

<p>  if($Search_Text){

     $query .= " and wr_name like '%$Search_Text%' ";

     $href = "&Search_Text=$Search_Text";</p>

<p>  }</p>

<p>  $query .= " limit $s, $pagenum ";

  echo $query;

  $result = mysqli_query($conn, $query);

  while($data = mysqli_fetch_array($result)){

?></p>

<p><li><?=$data[wr_subject]?> <?=$data[wr_name]?> <?=$data[wr_4]?> <?=$data[wr_datetime]?></li></p>

<p><? } ?>

 

<hr></p>

<p><?

    $a = $start - 5;

    $b = $start + 5;</p>

<p>    if($a<1) $a = 1;

    if($b>$pages) $b = $pages;</p>

<p>    $prev = $start - 10;

    $next = $start + 10;</p>

<p>    if($prev<=1) $prev = 1;

    if($next>=$pages) $next = $pages;

?>

 

<? if($prev!=1){ ?>

 <a href=<?=$PHP_SELF?>?start=1<?=$href?>>first</a>

<? } ?>

 

<a href=<?=$PHP_SELF?>?start=<?=$prev?><?=$href?>>[preview]</a></p>

<p><?

   for($i=$a; $i<=$b; $i++){

     if($start==$i) {?>

        <b><?=$i?></b>

     <? }else{  ?>

       <a href=<?=$PHP_SELF?>?start=<?=$i?><?=$href?>>[<?=$i?>]</a>

   <? } ?> 

<? } ?>

 

<? if($next!=$pages){ ?>

 <a href=<?=$PHP_SELF?>?start=<?=$next?><?=$href?>>[next]</a>

<? } ?>

 

<a href=<?=$PHP_SELF?>?start=<?=$pages?><?=$href?>>end</a></p>

<p><form action=<?=$PHP_SELF?> >

  <input type=text name=Search_Text>

  <input type=submit value='search' >

</form></p>

<p><?php mysqli_close($conn); ?>