페이지가 하단에 보여야 하는데 페이지가
본문
아래 소스는 마이페이지 입니다.
아래 소스에서 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";
?>
전체 소스가 아니구요 참고용으로 응용해서 적용을 해야 합니다
페이징 소스를 참고하세요
모두 설명을 할 수가 없어요
아침안개님, 답변 감사합니다.
적용해보겠습니다.