mysql쿼리 결과를 페이지 처리하는방법 정보
mysql쿼리 결과를 페이지 처리하는방법본문
g4_write_a10 과 g4_write_a20 부분을 페이징처리하는방법이있나요?
현재는 a10게시판과 a20게시판이 같이나오고있는데요
<a href="/bbs/board.php?bo_table=w10&page=1">
<a href="/bbs/board.php?bo_table=w10&page=2">
이런식으로 링크클릭해서들왓을때 따로 페이지로보여줄수있는지 부탁드립니다.
g4_write_a10 쿼리는 page1
g4_write_a20 쿼리는 page2 로보여주는방법이요..
---------------------------------------w10.php------------------------------------
<?
include_once("_common.php");
$sql = "SELECT * FROM g4_write_a10 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
$sort_arr = array();//추가
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
$val['group_id'] = "a10_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]'";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;
}
$sql = "SELECT * FROM g4_write_a20 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
$val['group_id'] = "a20_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]'";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;
}
$temp_arr = array(); //추가
asort($sort_arr);
foreach ($sort_arr as $key => $val) {
$temp_arr[] = $arr[$key];
}
$arr = $temp_arr;
//추가 완료
echo json_encode($arr);
?>
현재는 a10게시판과 a20게시판이 같이나오고있는데요
<a href="/bbs/board.php?bo_table=w10&page=1">
<a href="/bbs/board.php?bo_table=w10&page=2">
이런식으로 링크클릭해서들왓을때 따로 페이지로보여줄수있는지 부탁드립니다.
g4_write_a10 쿼리는 page1
g4_write_a20 쿼리는 page2 로보여주는방법이요..
---------------------------------------w10.php------------------------------------
<?
include_once("_common.php");
$sql = "SELECT * FROM g4_write_a10 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
$sort_arr = array();//추가
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
$val['group_id'] = "a10_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]'";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;
}
$sql = "SELECT * FROM g4_write_a20 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
$val['group_id'] = "a20_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]'";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;
}
$temp_arr = array(); //추가
asort($sort_arr);
foreach ($sort_arr as $key => $val) {
$temp_arr[] = $arr[$key];
}
$arr = $temp_arr;
//추가 완료
echo json_encode($arr);
?>
댓글 전체
w10.php를 어떻게 불러오는지 모르겠지만 페이지 값을 넘겨준다면 아래처럼 if문으로
if($page==1){
g4_write_a10 부분
}
else{
g4_write_a20 부분
}
if($page==1){
g4_write_a10 부분
}
else{
g4_write_a20 부분
}