"); } F_Redirect("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 가없으면 실행 #################### ############## 테이블의 모든값을 가져오기 ################ if($key){ $qry = mysql_query("select count(*) from thanks where B_prc='$key'",$dbconn); }else{ $qry = mysql_query("select count(*) from thanks",$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 ); } #################### 테이블에 있는 자료 뽑아오기 ###################### if($key){ $qry1 = mysql_query("select B_no,B_title,B_prc,board from thanks where B_prc='$key' order by B_title asc limit $nono,$pagesize ",$dbconn); }else{ $qry1 = mysql_query("select B_no,B_title,B_prc,board from thanks order by B_title asc limit $nono,$pagesize ",$dbconn); } ################################################################### }else{ ####################### search 값이 있으면 실행 ###################### if($key){ $qry = mysql_query("select count(*) from thanks where B_prc='$key' and $search like '%$keyword%'",$dbconn); }else{ $qry = mysql_query("select count(*) from thanks 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 ); } #################### 테이블에 잇는 자료 뽑아오기 ###################### ####################### 자료 뽑아오기 ####################### if($key){ $qry1 = mysql_query("select B_no,B_title,B_prc,board from thanks where key='$B_prc' and $search like '%$keyword%' order by B_no desc limit $nono,$pagesize",$dbconn); }else{ $qry1 = mysql_query("select B_no,B_title,B_prc,board from thanks 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){ ?>  ▶ ...▶▶ []