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;
}
//*******************************************************
?>
페이지 : $page / $totalpage
"; echo "\n"; } else { // 검색 조건 있을 때 echo "검색 조건 : $constraints \n"; echo "검색어 : $keyword
\n"; echo "검색된 신청서: $total
"; echo "$page / $totalpage"; echo "\n"; } //******************************************************* ?>
| 번호 | 신청인 | 신청 도서명 | 저 자 | 신청일 | 진행상태 |
|---|---|---|---|---|---|
| $col[APPLICANT_NAME]"; ?> | 신청한 도서가 없습니다. | \n"; //******************************************************* ?>