include '../include/config.php';
?>
$table = "journal_$org";
if(!$page){
$page=1;
}
if(!$search){
$search="title";
}
//if(strlen($searchkey)>4){
$searchkey=trim($searchkey);
//}
$andKeyword=strstr($searchkey, "&");
$searchKeyAnd="";
if($andKeyword===false){
$andKeyword=strstr($searchkey, " and ");
$searchKeyAnd="";
if($andKeyword===false){
//do nothing
}else{
$searchKeyAnd = str_replace(" and ", " & ", $searchkey);
}
}else{
$searchKeyAnd = str_replace("&", "and", $searchkey);
}
//echo $searchkey;
$query = "SELECT COUNT(idx) AS COUNT FROM $table";
$query.= " WHERE \n";
if(!$find){
if($andKeyword===false){
$query.= " $search LIKE '%$searchkey%' \n";
}else{
$query.= " ($search LIKE '%$searchkey%' OR $search LIKE '%$searchKeyAnd%' ) \n";
}
}else{
///////초성으로 검색하기/////////
if($find == 'ㄱ'){
$query.= "(title RLIKE '^(ㄱ|ㄲ)' OR ( title >= '가' AND title < '나' )) ";
}else if($find == 'ㄴ'){
$query.= "(title RLIKE '^ㄴ' OR ( title >= '나' AND title < '다' )) ";
}else if($find == 'ㄷ'){
$query.= "(title RLIKE '^(ㄷ|ㄸ)' OR ( title >= '다' AND title < '라' )) ";
}else if($find == 'ㄹ'){
$query.= "(title RLIKE '^ㄹ' OR ( title >= '라' AND title < '마' )) ";
}else if($find == 'ㅁ'){
$query.= "(title RLIKE '^ㅁ' OR ( title >= '마' AND title < '바' )) ";
}else if($find == 'ㅂ'){
$query.= "(title RLIKE '^ㅂ' OR ( title >= '바' AND title < '사' )) ";
}else if($find == 'ㅅ'){
$query.= "(title RLIKE '^(ㅅ|ㅆ)' OR ( title >= '사' AND title < '아' )) ";
}else if($find == 'ㅇ'){
$query.= "(title RLIKE '^ㅇ' OR ( title >= '아' AND title < '자' )) ";
}else if($find == 'ㅈ'){
$query.= "(title RLIKE '^(ㅈ|ㅉ)' OR ( title >= '자' AND title < '차' )) ";
}else if($find == 'ㅊ'){
$query.= "(title RLIKE '^ㅊ' OR ( title >= '차' AND title < '카' )) ";
}else if($find == 'ㅋ'){
$query.= "(title RLIKE '^ㅋ' OR ( title >= '카' AND title < '타' )) ";
}else if($find == 'ㅌ'){
$query.= "(title RLIKE '^ㅌ' OR ( title >= '타' AND title < '파' )) ";
}else if($find == 'ㅍ'){
$query.= "(title RLIKE '^ㅍ' OR ( title >= '파' AND title < '하' )) ";
}else if($find == 'ㅎ'){
$query.= "(title RLIKE '^ㅎ' OR ( title >= '하')) ";
}else{
//영문 초성일경우
$query.= "title LIKE '$find%'";
}
}
if($db){
$query.= " AND db='$db'";
}
//echo $query."
";
$result = mysql_query($query, $connect);
$res = mysql_fetch_array($result);
$t_count=$res[COUNT];
$start=($page-1)*$listPerPage;
if($t_count%$listPerPage==0){
$lastpage=intval($t_count/$listPerPage);
}else{
$lastpage=intval($t_count/$listPerPage)+1;
}
$query = "SELECT * \n";
$query.= "FROM $table \n";
$query.= "WHERE \n";
if(!$find){
if($andKeyword===false){
$query.= " $search LIKE '%$searchkey%' \n";
}else{
$query.= " ($search LIKE '%$searchkey%' OR $search LIKE '%$searchKeyAnd%' ) \n";
}
}else{
///////초성으로 검색하기/////////
if($find == 'ㄱ'){
$query.= "(title RLIKE '^(ㄱ|ㄲ)' OR ( title >= '가' AND title < '나' ))";
}else if($find == 'ㄴ'){
$query.= "(title RLIKE '^ㄴ' OR ( title >= '나' AND title < '다' ))";
}else if($find == 'ㄷ'){
$query.= "(title RLIKE '^(ㄷ|ㄸ)' OR ( title >= '다' AND title < '라' ))";
}else if($find == 'ㄹ'){
$query.= "(title RLIKE '^ㄹ' OR ( title >= '라' AND title < '마' ))";
}else if($find == 'ㅁ'){
$query.= "(title RLIKE '^ㅁ' OR ( title >= '마' AND title < '바' ))";
}else if($find == 'ㅂ'){
$query.= "(title RLIKE '^ㅂ' OR ( title >= '바' AND title < '사' ))";
}else if($find == 'ㅅ'){
$query.= "(title RLIKE '^(ㅅ|ㅆ)' OR ( title >= '사' AND title < '아' ))";
}else if($find == 'ㅇ'){
$query.= "(title RLIKE '^ㅇ' OR ( title >= '아' AND title < '자' ))";
}else if($find == 'ㅈ'){
$query.= "(title RLIKE '^(ㅈ|ㅉ)' OR ( title >= '자' AND title < '차' ))";
}else if($find == 'ㅊ'){
$query.= "(title RLIKE '^ㅊ' OR ( title >= '차' AND title < '카' ))";
}else if($find == 'ㅋ'){
$query.= "(title RLIKE '^ㅋ' OR ( title >= '카' AND title < '타' ))";
}else if($find == 'ㅌ'){
$query.= "(title RLIKE '^ㅌ' OR ( title >= '타' AND title < '파' ))";
}else if($find == 'ㅍ'){
$query.= "(title RLIKE '^ㅍ' OR ( title >= '파' AND title < '하' ))";
}else if($find == 'ㅎ'){
$query.= "(title RLIKE '^ㅎ' OR ( title >= '하'))";
}else{
//영문 초성일경우
$query.= "title LIKE '$find%'";
}
}
if($db){
$query.= " AND db='$db'";
}
$query.= " ORDER BY title ASC LIMIT $start,$listPerPage";
//echo $query."
";
$result = mysql_query($query, $connect);
$start_no=($listPerPage*($page-1))+1;
?>
Untitled Document
$path="../admin/logo/";
$logo="";
$query = "SELECT * FROM org where id='$org'";
//echo $query." ";
$result_logo = mysql_query($query, $connect);
$res_logo = mysql_fetch_array($result_logo);
$logo=$res_logo[logo];
?>
|
|
|
|
|
 |
for($i=65;$i<91;$i++) {
echo "".chr($i)." ";
}
echo " ";
if(!$find){
//초성검색이 없을 경우
for($i=65;$i<91;$i++) {
echo "A".chr($i)." ";
}
echo " ";
}else{
if($find=="ㄱ" || $find=="ㄴ" || $find=="ㄷ" || $find=="ㄹ" || $find=="ㅁ" || $find=="ㅂ" || $find=="ㅅ" ||
$find=="ㅇ" || $find=="ㅈ" || $find=="ㅊ" || $find=="ㅋ" || $find=="ㅌ" || $find=="ㅍ" || $find=="ㅎ" ||
$find=="기타"){
//있는데 한글일 경우
echo " ";
}else{
//있으면서 영문일경우
if(strlen($find)==1){
//한글자 초성 선택했을때
for($i=65;$i<91;$i++) {
echo "$find".chr($i)." ";
}
}else{
//두글자 초성 선택했을때
$first=substr($find,0,1);
for($i=65;$i<91;$i++) {
echo "$first".chr($i)." ";
}
}
echo " ";
}
}
?>
가
나
다
라
마
바
사
아
자
차
카
타
파
하
기타
|
|
|
|
|
|
|
총 =$t_count?>종의 저널이 검색되었습니다. |
 |
|
|
|
순번 |
 |
MEDIA |
 |
DB |
 |
저널명 |
 |
원문제공기간 |
 |
출판사 |
 |
ISSN |
 |
URL |
|
if($t_count==0){
?>
조건과 일치하는 저널정보를 찾을 수 없습니다. |
|
}else{
while($list = mysql_fetch_array($result)){
$media_str="";
if($list[media]=="1"){
$media_str="프린트";
}else if($list[media]=="2"){
$media_str="온라인";
}else if($list[media]=="3"){
$media_str="프린트+온라인";
}else if($list[media]=="4"){
$media_str="휴간";
}
$url=$list[url];
if($url){
if(strpos($url, "http://")===false){
$url="http://".$url;
}
}
$etc=trim($list[etc]);
$etc=htmlspecialchars($etc);
?>
|
=$start_no++?> |
 |
=$media_str?> |
 |
=$list[db]?> |
 |
href="#" onclick="jnlView('=$list[idx]?>','=$url?>');" title="클릭하시면 저널을 보실 수 있습니다."
}
?>
>
=$list[title]?>
/**
if($list[coverage]){
echo " [".trim($list[coverage])."]";
}
//해양대학 요청으로 layout변경
**/
?>
|
 |
echo "[".trim($list[coverage])."]";
?>
|
 |
=$list[publisher]?> |
 |
=$list[issn]?> |
 |
if($url){
?>
LINK
}
?>
|
|
|
}
}
?>
if($page!=1){
?>
 |
}else{
?>
 |
}
?>
if($page!=1){
?>
 |
}else{
?>
 |
}
?>
$pagingStart=floor(($page-1)/$pageRange)*$pageRange+1;
for($i=$pagingStart;$i<$pagingStart+$pageRange;$i++){
if($i>$lastpage) break;
if($i==$page){
?>
=$i?> |
}else{
?>
=$i?> |
}
}
?>
if($page!=$lastpage){
?>
 |
}else{
?>
 |
}
?>
if($page!=$lastpage){
?>
 |
}else{
?>
 |
}
?>
|
|
|
|
include 'bottom.html';
?>