게시판 전체 최근글 뽑기 및 페이징하기 정보
그누호환 게시판 전체 최근글 뽑기 및 페이징하기
본문
드림위버로 껄떡여 봤습니다. ㅡ.ㅡ;;;
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_latest = 5; // 페이지당 나올 개시판 수
$pageNum_latest = 0;
if (isset($_GET['pageNum_latest'])) {
$pageNum_latest = $_GET['pageNum_latest'];
}
$startRow_latest = $pageNum_latest * $maxRows_latest;
$query_latest = "SELECT bo_table, gr_id, bo_subject FROM $cfg[table_board] ORDER BY bo_subject ASC"; // 전체 게시판의 최근글을 뽑기위한 쿼리
$query_limit_latest = sprintf("%s LIMIT %d, %d", $query_latest, $startRow_latest, $maxRows_latest);
$latest = mysql_query($query_limit_latest) or die(mysql_error());
$row_latest = mysql_fetch_assoc($latest);
if (isset($_GET['totalRows_latest'])) {
$totalRows_latest = $_GET['totalRows_latest'];
} else {
$all_latest = mysql_query($query_latest);
$totalRows_latest = mysql_num_rows($all_latest); // 전체 개시판 수
}
$totalPages_latest = ceil($totalRows_latest/$maxRows_latest)-1;
$queryString_latest = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_latest") == false &&
stristr($param, "totalRows_latest") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_latest = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_latest = sprintf("&totalRows_latest=%d%s", $totalRows_latest, $queryString_latest);
?>
<?php
do {
echo "<table width=100%><tr><td height=25 bgcolor=#666666 class='lh'> ■ <a href='./?doc=bbs/gnuboard.php&bo_table=$row_latest[bo_table]'><b>$row_latest[bo_subject]</b></a></td></tr></table>";
latest('gallery', $row_latest[bo_table], 5, 70); //스킨 지정
} while ($row_latest = mysql_fetch_assoc($latest));
?>
<table width="100%" border="0">
<tr bgcolor="#CCCCCC">
<td width="23%" align="center"><?php if ($pageNum_latest > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, 0, $queryString_latest); ?>">첫 번째</a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center"><?php if ($pageNum_latest > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, max(0, $pageNum_latest - 1), $queryString_latest); ?>">이전</a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_latest < $totalPages_latest) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, min($totalPages_latest, $pageNum_latest + 1), $queryString_latest); ?>">다음</a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_latest < $totalPages_latest) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, $totalPages_latest, $queryString_latest); ?>">마지막</a>
<?php } // Show if not last page ?>
</td>
</tr>
</table>
<?php
mysql_free_result($latest);
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_latest = 5; // 페이지당 나올 개시판 수
$pageNum_latest = 0;
if (isset($_GET['pageNum_latest'])) {
$pageNum_latest = $_GET['pageNum_latest'];
}
$startRow_latest = $pageNum_latest * $maxRows_latest;
$query_latest = "SELECT bo_table, gr_id, bo_subject FROM $cfg[table_board] ORDER BY bo_subject ASC"; // 전체 게시판의 최근글을 뽑기위한 쿼리
$query_limit_latest = sprintf("%s LIMIT %d, %d", $query_latest, $startRow_latest, $maxRows_latest);
$latest = mysql_query($query_limit_latest) or die(mysql_error());
$row_latest = mysql_fetch_assoc($latest);
if (isset($_GET['totalRows_latest'])) {
$totalRows_latest = $_GET['totalRows_latest'];
} else {
$all_latest = mysql_query($query_latest);
$totalRows_latest = mysql_num_rows($all_latest); // 전체 개시판 수
}
$totalPages_latest = ceil($totalRows_latest/$maxRows_latest)-1;
$queryString_latest = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_latest") == false &&
stristr($param, "totalRows_latest") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_latest = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_latest = sprintf("&totalRows_latest=%d%s", $totalRows_latest, $queryString_latest);
?>
<?php
do {
echo "<table width=100%><tr><td height=25 bgcolor=#666666 class='lh'> ■ <a href='./?doc=bbs/gnuboard.php&bo_table=$row_latest[bo_table]'><b>$row_latest[bo_subject]</b></a></td></tr></table>";
latest('gallery', $row_latest[bo_table], 5, 70); //스킨 지정
} while ($row_latest = mysql_fetch_assoc($latest));
?>
<table width="100%" border="0">
<tr bgcolor="#CCCCCC">
<td width="23%" align="center"><?php if ($pageNum_latest > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, 0, $queryString_latest); ?>">첫 번째</a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center"><?php if ($pageNum_latest > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, max(0, $pageNum_latest - 1), $queryString_latest); ?>">이전</a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_latest < $totalPages_latest) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, min($totalPages_latest, $pageNum_latest + 1), $queryString_latest); ?>">다음</a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_latest < $totalPages_latest) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_latest=%d%s", $currentPage, $totalPages_latest, $queryString_latest); ?>">마지막</a>
<?php } // Show if not last page ?>
</td>
</tr>
</table>
<?php
mysql_free_result($latest);
?>
추천
0
0
댓글 전체
하하하 참 좋은 팁과 잼있는 리플이십니다..^^
ㅋㅋ..드림위버로 보면...껄떡녀가 보이는...이야기로 잘못읽었다는.....@@

좋은정보를 이제야 보네요 ^^