"; // exit; //} // **************************************************** // Include ******************************************** require ("../lib/dbConn.inc"); require ("../lib/messages.inc"); // **************************************************** // DBConn Class Instance ****************************** $oci = new DBCONN(); // **************************************************** // **************************************************** $tblName = "bo_furnish_tbl"; // 테이블 명 if (empty($page)) $page = 1; // **************************************************** ?> 희망도서신청 0) $constraints .= " or "; $constraints .= "도서명"; if ( strlen($search) > 0) $search .= " or "; $search .= "(LOWER(title) like LOWER('%".$keyword."%'))"; } } //******************************************************* // 총개시물 갯수($total) ******************************** if (empty($keyword)) { $qry = "select count(*) from $tblName where rec_key>0"; // 검색 조건 없을 때 } else { $qry ="select count(*) from $tblName where ($search) and (rec_key>0)"; // 검색 조건 있을 때 } $oci->select($qry); if ($oci->fetch()) { $total = $oci->result(1); $oci ->parseFree(); } //******************************************************* // 게시판 검색 query ************************************ if (empty($keyword)) { $qry = "select * from "; $qry .= "(select rownum as rnum, rec_key, applicant_name, title, author, to_char(applicant_date, 'yyyy-mm-dd') as dtime, furnish_status from "; $qry .= "(select * from $tblName order by applicant_date)) "; $qry .= "where (rnum >= ($total - ($page) * $POSTNUM + 1)) and (rnum <= ($total - ($page - 1) * $POSTNUM)) "; } else { $qry = "select * from "; $qry .= "(select rownum as rnum, rec_key, applicant_name, title, author, to_char(applicant_date, 'yyyy-mm-dd') as dtime, furnish_status from "; $qry .= "(select * from $tblName where $search order by applicant_date)) "; $qry .= "where (rnum >= ($total - ($page) * $POSTNUM + 1)) and (rnum <= ($total - ($page - 1) * $POSTNUM)) "; } //******************************************************* $qry .= "order by rnum desc"; //******************************************************* // DB SELECT ******************************************** if (!$oci->select($qry)) { MessagePage("DB Connect Error !!"); exit; } //******************************************************* ?>

"; } else { // 검색 조건 있을 때 echo ""; } //******************************************************* ?>
총신청서: $total건페이지: $page / $totalpage
검색 조건 : $constraints  검색어 : $keyword  검색된 신청서: $total$page / $totalpage
fetchInto(&$col)) { ?> \n"; //******************************************************* ?>
번호 신청인 신청 도서명 저자 신청일 진행상태
$col[APPLICANT_NAME]"; ?>
신청한 도서가 없습니다.
> <<[4][5][6]>> <<[7][8] 아래코드는 이와 같이 작동함. ********************************************************/ $totalPage = ceil($total/$POSTNUM); //전체 페이지 갯수 $widthPage = floor(($page-1)/$PAGENUM)+1; // 아래 [1][2] 을 위한 페이지 구분 1부터 시작!!! $nStart = ($widthPage-1)*$PAGENUM+1; $nEnd = $widthPage*$PAGENUM; if($totalPage < $nEnd) $nEnd = $totalPage; //$encode_root=urlencode($root); // 이전 페이지 블록링크 출력(<<) ************************ if($widthPage>1) { $nPrev=$nStart-1; echo "이전 <<\n"; } //******************************************************* // 페이지 바로가기 링크 출력 **************************** for($nStart; $nStart<=$nEnd; $nStart++) { if($page==$nStart) echo "".$nStart." |"; else echo " ".$nStart." |\n"; } //******************************************************* // 다음 페이지 블록링크 출력(>>) ************************ if($totalPage > $nEnd) { $nNext=$nEnd+1; echo "다음 >>\n"; } //******************************************************* ?>
신청인     도서명        찾기