include '../include/config.php';
?>
$table = "journal_$org";
if(!$page){
$page=1;
}
if(!$search){
$search="title";
}
$searchkey=trim($searchkey);
$query = "SELECT COUNT(idx) AS COUNT FROM $table";
$query.= " WHERE type=1 AND \n";
if(!$find){
$query.= " $search LIKE '%$searchkey%' \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%'";
}
}
//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 type=1 AND \n";
if(!$find){
$query.= " $search LIKE '%$searchkey%' \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%'";
}
}
$query.= " ORDER BY title ASC LIMIT $start,$listPerPage";
//echo $query."
";
$result = mysql_query($query, $connect);
$start_no=($listPerPage*($page-1))+1;
?>
//include 'top_nav.html';
?>
$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]; ?>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|