"); } F_Redirect("brand_list.php"); }else{ ########################################## $wichi = "전국"; $encoded = urlencode($wichi); $live = urlencode($live); $blocksize = 10; $pagesize = 200; if(!$pageno){ $pageno = 1; } if(!$blockpage){ $blockpage = floor(($pageno-1)/$blocksize) * $blocksize +1; } if($search=="") { ############## search 가없으면 실행 #################### ############## 테이블의 모든값을 가져오기 ################ $qry = mysql_query("select count(*) from brand",$dbconn); if(!$qry){ error("QUERY_ERROR"); exit; } $col = mysql_fetch_row($qry); $qry2 = mysql_query("select count(*) from brand where board='1'",$dbconn); if(!$qry2){ error("QUERY_ERROR"); exit; } $col2 = mysql_fetch_row($qry2); ################### 페이지 나누기 ##################### $recordcount = $col[0]; $pagecount = ceil($recordcount/$pagesize); if($pageno==1){ $nono = 0; }else{ $nono = $pagesize*$pageno-$pagesize; } If($pageno == $pagecount) { $pagesize = $recordcount - ( ( $pageno - 1 ) * $pagesize ); } #################### 테이블에 있는 자료 뽑아오기 ###################### $qry1 = mysql_query("select B_no,B_title,board from brand order by B_title asc limit $nono,$pagesize ",$dbconn); ################################################################### }else{ ####################### search 값이 있으면 실행 ###################### $qry = mysql_query("select count(*) from brand where $search like '%$keyword%'",$dbconn); if(!$qry){ error("QUERY_ERROR"); exit; } $col = mysql_fetch_row($qry); ###################### 페이지 처리 ############################ $recordcount = $col[0]; $pagecount = ceil($recordcount/$pagesize); if($pageno==1){ $nono = 0; }else{ $nono = $pagesize*$pageno-$pagesize; } If($pageno == $pagecount) { $pagesize = $recordcount - ( ( $pageno - 1 ) * $pagesize ); } #################### 테이블에 잇는 자료 뽑아오기 ###################### ####################### 자료 뽑아오기 ####################### $qry1 = mysql_query("select B_no,B_title,board from brand where $search like '%$keyword%' order by B_no desc limit $nono,$pagesize",$dbconn); } if(!$qry1){ echo("데이터베이스 연결에 실패했습니다.
"); } ##################### 인코딩하기 ############################ ?>
alert('검색된 브랜드가 없습니다');history.go(-1);"; }elseif($recordcount==0 and $search==""){ echo "


등록된 브랜드가 없습니다"; echo "

브랜드등록하기"; echo "
"; }else{ ?>

브랜드 등록현황

등록하기

메인등록갯수 :    [ 현재  페이지 / 총  페이지 ]

no

브랜드

메인

 

'; }else{ echo $count; } ##################################################################### ?>

수정 삭제 해제 등록

[1] $blocksize){ if($blockpage!=1){ ?> ◀◀... ◀  $i  "; }else { ?> =$pagecount){break;} } ################### 여기까정 ##################### if($pageno!=$pagecount){ ?>  ▶ ...▶▶ []