묻고답하기

member_memo.php 라는 회원간 쪽지 리스트 입니다.

그런데 9페이지까지만 나오고.... 그 뒤의 페이지를 볼 수가 없습니다.

왜냐하면 [next] [prev] 가 없기 때문입니다.

혼자 어케 해보려고 했지만.... 게시판과 설정값이 다른지 잘 안 되더군요.

프로그램 아시는 분.... 조금만 도움 주시면 저에게는 큰 것이 될 수 있습니다.

좋은 하루 보내세요^^



아래는 제가 쓰고 있는 코드입니다.

----------------------------------------------------------------------------------


<script language=JavaScript>
function bluring(){
if(event.srcElement.tagName=="A"||event.srcElement.tagName=="IMG") document.body.focus();
}
document.onfocusin=bluring;
</script>







<?
// 라이브러리 함수 파일 인크루드
        include "lib.php";

// DB 연결
        if(!$connect) $connect=dbConn();

// 멤버정보 구하기
        $member=member_info();

        if(!$member[no]) Error("로그인된 회원만이 사용할수 있습니다","window.close");

// 그룹데이타 읽어오기;;
        $group_data=mysql_fetch_array(mysql_query("select * from $group_table where no='$member[group_no]'"));

// 새쪽지 왔습니다;; 알람 없애기
        mysql_query("update $member_table set new_memo='0' where no='$member[no]'");

// 일주일 넘은 글 삭제;;
        mysql_query("delete from $get_memo_table where (".time()." - reg_date) >= ".$_zbDefaultSetup[memo_limit_time]) or error(mysql_error());

// 선택된 메모 삭제;;;
        if($exec=="del_all") {
                for($i=0;$i<count($del);$i++) {
                        mysql_query("delete from $get_memo_table where no='$del[$i]'");
                }
                mysql_close($connect);
                movepage("$PHP_SELF?page=$page");
        }

// 메모삭제
        if($exec=="del") {
                mysql_query("delete from $get_memo_table where no='$no' and member_no='$member[no]'");
                mysql_close($connect);
                movepage("$PHP_SELF?page=$page");
        }

// 선택된 메모가 있을시 데이타 뽑아오기;;
        if($no) {
                $now_data=mysql_fetch_array(mysql_query("select a.subject as subject, a.reg_date as reg_date, a.readed as readed, b.name as name, a.member_from as member_from, a.memo as memo from
                $get_memo_table a, $member_table b where a.member_from=b.no and a.no='$no' and a.member_no='$member[no]'"));
                if($now_data[readed]==1) {
                        mysql_query("update $get_memo_table set readed='0' where no='$no' and member_no='$member[no]'");
                        $check=mysql_fetch_array(mysql_query("select count(*) from $get_memo_table where readed='1' and member_no='$member[no]'"));
                        mysql_query("update $send_memo_table set readed='0' where reg_date='$now_data[reg_date]' and member_to='$member[no]'");
                        if(!$check[0]) mysql_query("update $member_table set new_memo='0' where no='$member[no]'");
                }
        }

// 읽지 않은 쪽지의 갯수 구하기
        $temp1=mysql_fetch_array(mysql_query("select count(*) from $get_memo_table where readed='1' and member_no='$member[no]'"));

        $new_total=$temp1[0];

// 전체 쪽지의 갯수
        $temp2=mysql_fetch_array(mysql_query("select count(*) from $get_memo_table  where member_no='$member[no]'"));

        $total=$temp2[0];

// 페이지 계산
        if(!$page) $page=1;
        $page_num=13;
        $start_num=($page-1)*$page_num; // 페이지 수에 따른 출력시 첫번째가 될 글의 번호 구함

        $total_page=(int)(($total-1)/$page_num)+1; // 전체 페이지 구함

        if($page>$total_page) $page=$total_page; // 페이지가 전체 페이지보다 크면 페이지 번호 바꿈

// 데이타 뽑아오는 부분...
        $que="select a.no as no, a.subject as subject, a.reg_date as reg_date, a.readed as readed, b.name as name, a.member_from as member_from from $get_memo_table a ,$member_table b where a.member_no='$member[no]' and a.member_from=b.no  order by a.no desc limit $start_num,$page_num";
        $result=mysql_query($que) or Error(mysql_error());

// MySQL 닫기
        if($connect) mysql_close($connect);
        $query_time=getmicrotime();

// 페이지 계산  $print_page 라는 변수에 저장
        $print_page="";
        $show_page_num=10;
                $i=1;

        if($page>$show_page_num) {
                $prev_page=$start_page;
                $print_page="<a href=$PHP_SELF?id=$id&page=$prev_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[Prev]</a> ";
                $print_page.="<a href=$PHP_SELF?id=$id&page=1&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[1]</a>..";
        }

        while($i+$start_page<=$total_page&&$i<=$show_page_num) {
                $move_page=$i+$start_page;
                if($page==$move_page) $print_page.=" <b>$move_page</b> ";
                else $print_page.="<a href=$PHP_SELF?id=$id&page=$move_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[$move_page]</a>";
                $i++;
        }

        if($total_page>$move_page) {
                $next_page=$move_page+1;
                $print_page.="..<a href=$PHP_SELF?id=$id&page=$total_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[$total_page]</a>";
                $print_page.=" <a href=$PHP_SELF?id=$id&page=$next_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[Next]</a>";
        }
  
        head("bgcolor=white");
?>



<script>
  function reverse() {
   var i, chked=0;
   for(i=0;i<document.list.length;i++)
   {
    if(document.list[i].type=='checkbox')
    {
     if(document.list[i].checked) { document.list[i].checked=false; }
     else { document.list[i].checked=true; }
    }
   }
  }
</script>

<style type='text/css'>
body
{scrollbar-face-color: #f6f6f6;
scrollbar-highlight-color: #FFFFFF;
scrollbar-3dlight-color: #FFFFFF;
scrollbar-shadow-color: #d6d6d6;
scrollbar-darkshadow-color: #ffffff;
scrollbar-track-color: #ffffff;
scrollbar-arrow-color: #d6d6d6}

body {color:#666666}

A:link    {color:666666;text-decoration:none;}
A:visited {color:666666;text-decoration:none;}
A:active  {color:666666;text-decoration:none;}
A:hover  {color:333333;text-decoration:none;}

</style>




<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
    <td align=center align="100%"  height="10" >      
            </td>
  </tr>
  <tr>
    <td align=center align="100%">      
            <p><img src="memo_images/memo_topright.gif" width="400" height="50" border="0"></td>
  </tr>
</table>


<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td>   <a href=member_memo.php><img src=memo_images/vi_B_inbox.gif border=0></a> <a href=member_memo2.php><img src=memo_images/vi_B_sent.gif border=0></a> <a href=member_memo3.php><img src=memo_images/vi_B_write.gif border=0></a></td>
    <td align=right><img src="images/t.gif" width="10" height="10"><font style=font-family:Tahoma;font-size:7pt;color:#666666>All :
      <b><?=$total?></b> , New Memo : <b><?=$new_total?></b></font>    </td>
  </tr>
</table>


<!-- 선택된 메모가 있을때;; --><?
        if($now_data[name]) {

                $temp_name = get_private_icon($now_data[member_from], "2");
                if($temp_name) $now_data[name]="<img src='$temp_name' border=0 align=absmiddle>";
                $temp_name = get_private_icon($now_data[member_from], "1");
                if($temp_name) $now_data[name]="<img src='$temp_name' border=0 align=absmiddle> ".$now_data[name];
?>
        

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td width="17">
            <img src="images/t.gif" width="17" height="10"></td>
    <td><br>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
                        <td colspan=2 height=1 bgcolor=#eeeeee></td>
                </tr>
                <tr>
          <td width="70" align="right" height="23">
                        <p align="left"> <b><font style=font-family:Tahoma;font-size:7pt;color:#666666>FROM</font><b></td>
          <td height="23">
                        <p><img src="images/t.gif" width="10" height="3"><br>
            <a href=.javascriptvoid(window.open('view_info.php?member_no=<?=$now_data[member_from]?>','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))><?=stripslashes($now_data[name])?></a></td>
        </tr>
                <tr>
                        <td colspan=2 height=1 bgcolor=#eeeeee></td>
                </tr>  
        <tr>
          <td width="70" align="right" height=23>
                        <p align="left"> <b><font style=font-family:Tahoma;font-size:7pt;color:#666666>SUBJECT</font></b></td>
          <td>
                        <p><img src="images/t.gif" width="10" height="3"><br>
            <?=stripslashes($now_data[subject])?></td>
        </tr>
                <tr>
                        <td colspan=2 height=1 bgcolor=#eeeeee></td>
                </tr>  
        <tr>
          <td width="70" align="right" height=23>
                        <p align="left"> <b><font style=font-family:Tahoma;font-size:7pt;color:#666666>DATE</font><b></td>
          <td><font style=font-family:Tahoma;font-size:7pt;color:#666666>            <?=date("Y.m.d H:i",$now_data[reg_date])?></font></td>
        </tr>
                <tr>
                        <td colspan=2 height=1 bgcolor=#eeeeee></td>
                </tr>        
        <tr>
          <td align="right" valign="top">
                        <p align="left" style="margin-top:7;"> <b><font style=font-family:Tahoma;font-size:7pt;color:#666666>MEMO</font><b></td>
          <td valign=top>
                        <p style="margin-top:5;"><img src="images/t.gif" width="10" height="3"><br>
            <?
//관리자의 받은쪽지함에 html 적용
if($member[no]=="1") {
    echo autolink(nl2br(stripslashes($now_data[memo])))."<br>";
} else {
    echo autolink(nl2br(stripslashes(del_html($now_data[memo]))))."<br>";
}
?>
            <br>
          </td>
        </tr>
                <tr>
                        <td colspan=2 height=1 bgcolor=#eeeeee></td>
                </tr>  
                <tr>
                        <td colspan=2 height=5></td>
                </tr>  
        <tr>
          <td align="right" valign="top">
                        <p align="left"> </td>
          <td>
                        <p style="margin-right:11;" align="right"><a href=.javascriptvoid(window.open('view_info.php?member_no=<?=$now_data[member_from]?>','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>* REPLY</font><b></a> <a href=<?=$PHP_SELF?>?exec=del&no=<?=$no?>&page=<?=$page?> onclick="return confirm('삭제하시겠습니까?'+ '+ ')"><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>* DELETE</font><b></a> <a href=<?=$PHP_SELF?>><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>* LIST</font><b></a> </td>
        </tr>
      </table>
    </td>
    <td width="17">
            <p><img src="images/t.gif" width="17" height="10"></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td width="15">
            <p> </td>
    <td>
            <p><img src="images/t.gif" width="10" height="5"></td>
    <td width="15">
            <p> </td>
  </tr>
</table>

<p style="line-height:100%; margin-top:0; margin-bottom:0;"> <?
}
?></p>

<table border=0 width="100%" cellpadding=0 cellspacing=0 align="center">
<tr>
<form method=post name=list action=<?=$PHP_SELF?> onsubmit="return confirm('삭제하시겠습니까?')">
<input type=hidden name=exec value=del_all>
<input type=hidden name=page value=<?=$page?>>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="17">
                            <p><img src="images/t.gif" width="17" height="10"></td>
    <td>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
                        <td colspan=5 height=1 bgcolor=#eeeeee></td>
                </tr>
                <tr>
          <td width="20" align="center" style="border-width:1px; border-color:#f4f4f4; border-bottom-style:solid;" height="27">
                                        <p><a href=.javascriptreverse()><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>C</font><b></a></td>
          <td width="20" align="center" style="border-width:1px; border-color:#f4f4f4; border-bottom-style:solid;" height="27">
                                        <p> </td>
          <td style="border-width:1px; border-color:#f4f4f4; border-bottom-style:solid;" height="27">
                                        <p><b><center><font style=font-family:Tahoma;font-size:7pt;color:#666666>SUBJECT</font></center><b></td>
          <td width="80" align="center" style="border-width:1px; border-color:#f4f4f4; border-bottom-style:solid;" height="27">
                                        <p><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>FROM</font><b></td>
          <td width="60" align="center" style="border-width:1px; border-color:#f4f4f4; border-bottom-style:solid;" height="27">
                                        <p><b><font style=font-family:Tahoma;font-size:7pt;color:#666666>DATE</font><b></td>
        </tr>
<?
        // 출력
        $loop_number=$total-($page-1)*$page_num;
        while($data=mysql_fetch_array($result)) {
                $data[name]=stripslashes($data[name]);

                $temp_name = get_private_icon($data[member_from], "2");
                if($temp_name) $data[name]="<img src='$temp_name'+ ' border=0 align=absmiddle>";
                $temp_name = get_private_icon($data[member_from], "1");
                if($temp_name) $data[name]="<img src='$temp_name' border=0 align=absmiddle> ".$data[name];
                
                $data[subject]=stripslashes($data[subject]);
                $reg_date=date("Y/m/d H:i",$data[reg_date]);
                if($data[readed]==0) $readed="<img src=images/memo_readed.gif>"; else $readed="<img src=images/memo_unread.gif>"
?>
       <tr onMouseOver=this.style.backgroundColor="#FAFAFA" onMouseOut=this.style.backgroundColor="">
          <td width="20" align="center" height="23">
            
                                        <p><input type=checkbox name=del[] value=<?=$data[no]?>>
          </td>
          <td width="20" align="center">
                                        <p><?=$readed?></td>
          <td onclick=location.href="<?="$PHP_SELF?exec=view&no=$data[no]&page=$page"?>">
                                        <p><img src="images/t.gif" width="10" height="3"><br>
            <a href=<?="$PHP_SELF?exec=view&no=$data[no]&page=$page"?>><?=$data[subject]?></a></td>
          <td width="80" align="center">
                                        <p><img src="images/t.gif" width="10" height="3"><br>
            <a href=.javascriptvoid(window.open('view_info.php?member_no=<?=$data[member_from]?>','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))><?=$data[name]?></a></td>
          <td width="60" align="center">
                                        <p><font style=font-family:Tahoma;font-size:7pt;><span title='<?=$reg_date?>'><? echo"".date("m/d",$data[reg_date])."" ?></span></font></td>
        </tr>
                 <tr>
                        <td colspan=5 height=1 bgcolor=#eeeeee></td>
                </tr>
<?
                $loop_number--;
        }
?>
      </table>
    </td>
    <td width="17">
                            <p><img src="images/t.gif" width="17" height="10"></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="15">
                            <p> </td>
    <td>
                            <p><img src="images/t.gif" width="10" height="5"></td>
    <td width="15">
                            <p> </td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td>
                            <p>     <font style=font-family:Tahoma;font-size:7pt;color:#666666>
            <?=$print_page?>
            </font></td>
    <td align="right">
                            <p style="margin-right:20;" align="right"><input type=image src="memo_images/memo_delete.gif" width="50" height="30" border="0">
      <a href=.javascriptwindow.close()><img src="memo_images/memo_close_m.gif" width="50" height="30" border="0"></a></td>
  </tr>
</table></td>
</form>
</tr>
</table>

<p><?
        foot();
?>
글쓴이 제목 최종 글
XE 공지 글 쓰기,삭제 운영방식 변경 공지 [16] 2019.03.05 by 남기남
경문규 도메인 검색 가능한가요???  
은선 꼭입니다.  
정대환 왜 안될까여? [1] 2007.08.10
시로이로 노프레임에 사용권한없게 하는거 말입니다.  
장우성 Action관련 질문요! [1] 2007.08.10
ㄴrㄹr 홈페이지 안에 비공개홈피 만들기 [1] 2007.08.10
김경미 셀 내용이 늘어나면서 바탕 배경 이미지가 늘어나는현상은??  
심화섭 [질문]테이블 안의 테이블 구조에서 [1] 2007.08.10
YK 테이블 셀에 게시판 삽입 방법 [1] 2007.08.10
클린아이 앞뒤로 넘어가는 버튼 좀 알려주세요.  
펠렌 CSS 로 배경 여러개 고정.. [1] 2007.08.10
김기현 플래쉬에서 액션스크립트 수정할수 있는 창 어떻게 띄우죠? [5] 2007.08.10
박용규 포토샵에서요. [1] 2007.08.10
lw9698 이런 공식은 어떻게 하나요(완전 초보라서...) [1] 2007.08.10
pahiyas 드림위버 에런데여 무슨말인지..모르겠습니다..ㅠ.ㅠ;;  
김기현 FLasH에서 작업한 파일을 홈페이지에~ [3] 2007.08.10
송승한 도움 부탁 드립니다  
눈썹 폰트자료실 사용범위문의  
백승렬 쿠키사용 질문!! 급해요. [1] 2007.08.10
김다혜 홈페이지를 만들고 올리려면.. [5] 2007.08.10
정용신 질문드립니다^^ [5] 2007.08.10
박준하 제로보드 상단//하단에 불러올 파일을 했는데..  
남궁현우 다운로드후 윈도우 미디어로 재생이 되는데요 바로 인터넷주소로 윈도우미디어로 재생되게 [3] 2007.08.10
한이쁨 지금들어오신분들봐주세요 ㅜ.ㅜ [8] 2007.08.10
제이 throttle를 이용하여 일정트래픽이 되면 페이지를 다른페이지로 이동하는 소스...  
느닷없이질문 폼(form) 문의 [1] 2007.08.10
김성국 이페이지를 친구에게 보내기를 첨부하려면....  
레드뱀프 아말감처리란  
아이리 mms를 웹상에서 재생하는 방법좀...  
백철 파일 업로드 버튼 css적용하는 방법이 궁금합니다. [1] 2007.08.10