진서기

게시판 전체 최근글 뽑기 및 페이징하기

· 2004-10-15 (금) 17:09:25 · 3830 · 3
드림위버로 껄떡여 봤습니다. ㅡ.ㅡ;;;
<?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);
?>
|

댓글 3개

하하하 참 좋은 팁과 잼있는 리플이십니다..^^
ㅋㅋ..드림위버로 보면...껄떡녀가 보이는...이야기로 잘못읽었다는.....@@
좋은정보를 이제야 보네요 ^^
댓글을 작성하시려면 로그인이 필요합니다.

그누3 팁자료실

1,026건
+
제목 글쓴이 날짜 조회
04-10-24 조회 3,166
04-10-22 조회 3,106
04-10-22 조회 2,919
04-10-20 조회 5,749
04-10-19 조회 2,990
04-10-18 조회 3,212
04-10-17 조회 4,309
04-10-15 조회 3,535
04-10-15 조회 2,836
04-10-15 조회 3,831
04-10-15 조회 3,725
04-10-15 조회 4,504
04-10-14 조회 2,860
04-10-13 조회 3,114
04-10-13 조회 3,862
04-10-12 조회 3,300
04-10-12 조회 3,340
04-10-12 조회 3,002
04-10-12 조회 3,442
04-10-09 조회 4,158