페이지가 하단에 보여야 하는데 페이지가

페이지가 하단에 보여야 하는데 페이지가

QA

페이지가 하단에 보여야 하는데 페이지가

본문

아래 소스는 마이페이지 입니다.

아래 소스에서 10개 이상의 글이 있으면 

페이지(12345...) 가 하단에 보여야 하는데 페이지가 

보이지 안습니다. 어디가 문제인지요.

감사합니다.

 

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

<?

if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가 

 

// 선택옵션으로 인해 셀합치기가 가변적으로 변함

$colspan = 5;

 

// 제목이 두줄로 표시되는 경우 이 코드를 사용해 보세요.

// <nobr style='display:block; overflow:hidden; width:000px;'>제목</nobr>

    if ($member['mb_id']) {

        $sql = " select count(*) as cnt from {$g4['memo_table']} where me_recv_mb_id = '{$member['mb_id']}' and me_read_datetime = '0000-00-00 00:00:00' ";

        $row = sql_fetch($sql);

        $memo_not_read = $row['cnt'];

 

        $is_auth = false;

        $sql = " select count(*) as cnt from $g4[auth_table] where mb_id = '$member[mb_id]' ";

        $row = sql_fetch($sql);

        if ($row['cnt']) 

            $is_auth = true;

    }

$icon = "<img src='$board_skin_path/img/point.png' align='absmiddle' border='0'> ";

$icon2 = "<img src='$board_skin_path/img/allows.png' align='absmiddle' border='0' width=15 height=15> ";

$icon3 = "<img src='$board_skin_path/img/dot.gif' align='absmiddle'>";

$icon4 = "$board_skin_path/img/dot.gif";

?>

 

<style>

.sub {

font-weight:bold; color:green;

}

#content {

margin:30px;

}

</style>

 

<!--

<img src="<?=$board_skin_path?>/img/mypage.gif" align="absmiddle" border='0'>

-->

 

 

<!--네비게이션---->

<div style="width:100%;">

<div class="hig xxlarge p7px pl5px" style="font-family:Arial,Helvetica,sans-serif; font-style:normal; font-variant:normal; font-weight:normal; font-size:1.3em; color:rgb(0,136,204); word-spacing:0px; letter-spacing:normal; text-transform:none; text-indent:0px; line-height:18px; background-color:white; padding-top:7px; padding-right:7px; padding-bottom:7px; padding-left:5px; border-top-width:2px; border-top-style:solid; transition: background-color 0.5s, color 0.5s, box-shadow 0.5s; -webkit-transition: background-color 0.5s, color 0.5s, box-shadow 0.5s; text-shadow: rgba(255, 255, 255, 0.74902) 1px 1px; orphans: auto; text-align: start; widows: auto; -webkit-text-stroke-width: 0px;">

    <h3 style="display: block; margin: 0px; padding: 0px; font-size: 1em;">  My page</h3></div>

<ul class="main-categories graydark" style="margin: 0px; padding: 0px; list-style: none; transition: background-color 0.5s, color 0.5s, box-shadow 0.5s; -webkit-transition: background-color 0.5s, color 0.5s, box-shadow 0.5s; color: rgb(51, 51, 51); font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);">

</div>

<!--네비게이션끝!-->

 

 

<div id=content>

<table border="1" width="100%" cellspacing=0 cellpadding=5>

<tr>

<td class=sub><?=$icon?>Name</th>

<td> <?=$member[mb_name]?></td>

<td class=sub><?=$icon?>Id</th>

<td> <?=$member[mb_id]?></td>

<td class=sub><?=$icon?>Nickname</th>

<td> <?=$member[mb_nick]?></td>

</tr>

<tr>

<td class=sub><?=$icon?>Birth</th>

<td> <?=$member[mb_birth]?></td>

<td class=sub><?=$icon?>Tel.</th>

<td> <?=$member[mb_tel]?></td>

<td class=sub><?=$icon?>Mobile phone</th>

<td> <?=$member[mb_hp]?></td>

</tr>

<tr>

<td class=sub><?=$icon?>E-mail</th>

<td colspan="5"> <?=$member[mb_email]?></td>

</tr>

<tr>

<td class=sub><?=$icon?>Address</th>

<td colspan="5"> <?=$member[mb_address]?></td>

</tr>

<tr>

<td class=sub><?=$icon?>Introduction</th>

<td colspan="5"> <?=$member[mb_introduction_company]?></td>

</tr>

 

<tr>

<td class=sub><?=$icon?>Point</th>

<td><?=$member[mb_point]?> point</td>

<td class=sub><?=$icon?>Scrap</th>

<td><a href="javascript:win_scrap();">scrap</a></td>

<td class=sub><?=$icon?>Modify</th>

<td><a href="<?=$g4['bbs_path']?>/member_confirm.php?url=register_form.php">Modify</a></td>

</tr>

<tr>

<td class=sub><?=$icon?>New memo</th>

<td><a href="javascript:win_memo();"><?=$memo_not_read?> </a></td>

<td class=sub><?=$icon?>Company</th>

<td><a><?=$member[mb_company_name]?> </a></td>

 

 

<!--<td class=sub><?=$icon?>회원탈퇴</th>

<td><a href="javascript:member_leave();">탈퇴하기</a></td>-->

 

<td class=sub><?=$icon?>Admin memo</th>

<td><a href="javascript:win_memo('../bbs/memo_form.php?me_recv_mb_id=admin');">Send to admin</a></td>

</tr>

</table>

 

 

 

<br>

 <?  

 

    $count = 10; 

    $cnt = 0; 

    $sql = " select bo_table, wr_parent from $g4[board_new_table] a 

              where mb_id = '$member[mb_id]'  

                -- and a.wr_id = a.wr_parent 

                group by bo_table, wr_parent 

                order by bn_id desc 

                limit $count "; 

    $results = sql_query($sql); 

 

    echo "<table width=100% cellpadding=0 cellspacing=0 align=center border=1 rules=none>"; 

echo "<tr align=center><td colspan=2 height=20><b>My Product</b></td><td><b>Posted date</b></td></tr>";

echo "<tr><td colspan='3' background='$icon4'>$icon3</td></tr>"; 

    for ($i=0; $row=sql_fetch_array($results), $i<$count; $i++)  

    {  

        if (!$row[bo_table])  

        { 

            continue; 

        } 

 

        $tmp_table = $g4[write_prefix].$row[bo_table]; 

        $sql2 = " select wr_subject,wr_datetime,wr_comment from $tmp_table where wr_id = '$row[wr_parent]' "; 

        $row2 = sql_fetch($sql2); 

        $subject = cut_str(get_text($row2[wr_subject]), 22); 

        $dates = cut_str(get_text($row2[wr_datetime]), 22); 

        if ($row2[wr_comment]) 

            $comment = "<span class=new>($row2[wr_comment])</span>"; 

        echo "<tr><td width='20' >$icon2</td>"; 

echo "<td height='25' style='letter-spacing: -1px;'>"; 

echo "<a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>$subject   $comment </a>"; 

echo "</td><td width=22% align=center> $dates</td></tr>"; 

echo "<tr><td colspan='3' background='$icon4'>$icon3</td></tr>"; 

$cnt++; } if (!$cnt) echo "<tr><td colspan='3' height='50' align='center'>게시글이 없습니다.</td></tr>"; 

echo "</table>\n"; 

?>

</div>

 

 

 

<script type="text/javascript">

 

// 탈퇴의 경우 아래 코드를 연동하시면 됩니다.

function member_leave() 

{

    if (confirm("정말 회원에서 탈퇴 하시겠습니까?")) 

            location.href = "<?=$g4['bbs_path']?>/member_confirm.php?url=member_leave.php";

}

 

</script>

 

<!-- 게시판 목록 끝 -->

 

 

 

이 질문에 댓글 쓰기 :

답변 4

상단과 하단에 페이징 코드가 없네요

위에는

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / $rows);
if ($page == "") { $page = 1; }

if ($page == "") { $page = 1; }

아래는 이런식으로 응용해서 코딩하셔야 되요

$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");
 

아침안개님, 답변 감사합니다

아래와 같이 적용해 보았는데 안되네요.

다시 한번 살펴봐 주세요.

감사합니다.

 

 

<?  

 

    $count = 10; 

    $cnt = 0; 

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

$rows = $config[cf_page_rows];

$total_page  = ceil($total_count / $rows);

if ($page == "") { $page = 1; }

if ($page == "") { $page = 1; }

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

    $sql = " select bo_table, wr_parent from $g4[board_new_table] a 

              where mb_id = '$member[mb_id]'  

                -- and a.wr_id = a.wr_parent 

                group by bo_table, wr_parent 

                order by bn_id desc 

                limit $count "; 

    $results = sql_query($sql); 

 

    echo "<table width=100% cellpadding=0 cellspacing=0 align=center border=1 rules=none>"; 

echo "<tr align=center><td colspan=2 height=20><b>My Product</b></td><td><b>Posted date</b></td></tr>";

echo "<tr><td colspan='3' background='$icon4'>$icon3</td></tr>"; 

    for ($i=0; $row=sql_fetch_array($results), $i<$count; $i++)  

    {  

        if (!$row[bo_table])  

        { 

            continue; 

        } 

 

        $tmp_table = $g4[write_prefix].$row[bo_table]; 

        $sql2 = " select wr_subject,wr_datetime,wr_comment from $tmp_table where wr_id = '$row[wr_parent]' "; 

        $row2 = sql_fetch($sql2); 

        $subject = cut_str(get_text($row2[wr_subject]), 22); 

        $dates = cut_str(get_text($row2[wr_datetime]), 22); 

        if ($row2[wr_comment]) 

            $comment = "<span class=new>($row2[wr_comment])</span>"; 

        echo "<tr><td width='20' >$icon2</td>"; 

echo "<td height='25' style='letter-spacing: -1px;'>"; 

echo "<a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>$subject   $comment </a>"; 

echo "</td><td width=22% align=center> $dates</td></tr>"; 

echo "<tr><td colspan='3' background='$icon4'>$icon3</td></tr>"; 

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

$cnt++; } if (!$cnt) echo "<tr><td colspan='3' height='50' align='center'>게시글이 없습니다.</td></tr>"; 

echo "</table>\n"; 

?>

 

 

 

 

 

답변을 작성하시기 전에 로그인 해주세요.
전체 10,628
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT