그누보드 질문입니다.

그누보드 질문입니다.

QA

그누보드 질문입니다.

답변 1

본문


<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가 
include_once(G5_LIB_PATH.'/thumbnail.lib.php');
include_once $board_skin_path."/board_head.skin.php";
?>
<link rel="stylesheet" href="<?php echo $board_skin_url ?>/css/style.css">
<link rel="stylesheet" type="text/css" href="<?php echo $board_skin_url ?>/css/lightbox.css" media="screen" />



<div class="sub_con">

	<div class="history_div mt55">
    <form name="fboardlist"  id="fboardlist" action="./board_list_update.php" onsubmit="return fboardlist_submit(this);" method="post">
    <input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
    <input type="hidden" name="sfl" value="<?php echo $sfl ?>">
    <input type="hidden" name="stx" value="<?php echo $stx ?>">
    <input type="hidden" name="spt" value="<?php echo $spt ?>">
    <input type="hidden" name="page" value="<?php echo $page ?>">
    <input type="hidden" name="sw" value="">

		<!-- 게시판 목록 시작 -->
		<?
		$sql = "SELECT * FROM $write_table ORDER BY wr_subject $board[bo_4], wr_1, wr_2 ";

		$result=sql_query($sql);
		$num_rows = _num_rows($result);
		$count = 0;
		while($data=sql_fetch_array($result)) {
			
			$count++;
			$hList[]=$data;	

			if($preYear != $data[wr_subject]) {
				$preYear = $data[wr_subject];



					if($count > 1) {
						$cicle_img = '<div class="year_body"><span>'.$data[wr_subject].'</span></div>';
					}elseif($count == 1){
						$cicle_img = '<div class="year_body first"><span>'.$data[wr_subject].'</span></div>';
					}

				echo '				<div class="p_box '.$margin_top.'">';
				echo '					<div class="history_img">'.$cicle_img.'</div>';
				echo '					<div class="history_txt">';


				$tmp_write_table = $g5['write_prefix'] . $board['bo_table']; // 게시판 테이블 전체이름

				$sql_detail = " select * from {$tmp_write_table} where wr_subject = {$data[wr_subject]} order by wr_subject, wr_1, wr_2 $board[bo_4]";
				$result_detail = sql_query($sql_detail);
				$history_icon = '';
				
				for ($i=0; $hList = sql_fetch_array($result_detail); $i++) {
					if($i == 0) {
						 if($i > -1) $margin_top = "mt30";
						echo '<div class="tit">';
						echo '	<h4>'.$hList[wr_subject].'</h4>';
						echo '	<div class="bar"></div>';
						echo '</div>';
					}
					if (substr($hList[wr_1],0,1) == 1) { $disp_month = $hList[wr_1]; } else { $disp_month = substr($hList[wr_1],1,2); }
					$disp_day = $hList[wr_2];
					
					if($board[bo_3]=="d") {
						$display = $disp_month."월 ".$disp_day." ";
					}else{
						$display = $disp_month."월 ";
					}

					echo '<p class="mt5">';
					if($is_admin || $is_checkbox) echo '<input type="checkbox" name="chk_wr_id[]" value="'.$hList[wr_id].'" title="'.$hList[wr_subject].'"> ';

					if($is_admin) {
						echo ' <a href="'.G5_BBS_URL.'/write.php?bo_table='.$bo_table.'&w=u&wr_id='.$hList[wr_id].'">';
					}

					echo $display.nl2br($hList[wr_content]);
					if ($is_admin)
					{
						set_session("ss_delete_token", $token = uniqid(time()));
						$delete_href ='./delete_all.php?bo_table='.$bo_table.'&wr_id='.$hList[wr_id];
						echo ' </a> ';
						echo '<a href="javascript:del(\''.$delete_href.'\');"><img src="'.$board_skin_url.'/img/btn_close.gif" alt="Delete" width="15px" height="14px" /></a>';
					}	
					echo '</p>';


					if($thumb['src']) {
						$history_icon .= '<div class="history_icon">';
						$history_icon .= '<strong>'.$hList[wr_subject].'</strong>';
						$history_icon .= '<p class="tit">'.$thumb['alt'].'</p>';
						$history_icon .= '<p class="mt5"><a href="'.G5_DATA_URL.'/file/'.$bo_table.'/'.$row['bf_file'].'" data-lightbox="history-image-set" class="light-box-image"><img src="'.$thumb['src'].'" alt="'.$thumb['alt'].'" width="'.$board['bo_gallery_width'].'" height="'.$board['bo_gallery_height'].'"></a></p>';
						$history_icon .= '</div>';
					}

				}
				echo '					</div>';
				echo $history_icon;
				echo '				</div>';
			}
		}

		?>
		<div class="p_box">
			<div class="history_img"><img src="<?=$board_skin_url?>/img/history_start.gif" style="position:absolute;bottom:0;left:83px;" alt="history_start"></div>
			<div class="history_txt">
			</div>
		</div>


	</div>

	<div class="mt40"></div>


    <?php if ($is_admin || $list_href || $is_checkbox || $write_href) { ?>
    <div class="bo_fx">
        <?php if ($is_checkbox) { ?>
        <ul class="btn_bo_adm">
            <li><input type="submit" name="btn_submit" value="선택삭제" onclick="document.pressed=this.value"></li>
            <li><input type="submit" name="btn_submit" value="선택복사" onclick="document.pressed=this.value"></li>
            <li><input type="submit" name="btn_submit" value="선택이동" onclick="document.pressed=this.value"></li>
        </ul>
        <?php } ?>

        <?php if ($list_href || $rss_href || $write_href) { ?>
        <ul class="btn_bo_user">
            <?php if ($rss_href) { ?><li><a href="<?php echo $rss_href ?>" class="btn_b01">RSS</a></li><?php } ?>
            <?php if ($admin_href) { ?><li><a href="<?php echo $admin_href ?>" class="btn_admin">관리자</a></li><?php } ?>
            <?php if ($list_href) { ?><li><a href="<?php echo $list_href ?>" class="btn_b01">목록</a></li><?php } ?>
            <?php if ($write_href) { ?><li><a href="<?php echo $write_href ?>" class="btn_b02">글쓰기</a></li><?php } ?>
        </ul>
        <?php } ?>
    </div>
    <?php } ?>
	</form>



<!-- 페이지 -->
<?php //echo $write_pages;  ?>

<!-- 게시판 검색 시작 { 
<fieldset id="bo_sch">
    <legend>게시물 검색</legend>

    <form name="fsearch" method="get">
    <input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
    <input type="hidden" name="sca" value="<?php echo $sca ?>">
    <input type="hidden" name="sop" value="and">
    <label for="sfl" class="sound_only">검색대상</label>
    <select name="sfl" id="sfl">
        <option value="wr_subject"<?php echo get_selected($sfl, 'wr_subject', true); ?>>제목</option>
        <option value="wr_content"<?php echo get_selected($sfl, 'wr_content'); ?>>내용</option>
        <option value="wr_subject||wr_content"<?php echo get_selected($sfl, 'wr_subject||wr_content'); ?>>제목+내용</option>
        <option value="mb_id,1"<?php echo get_selected($sfl, 'mb_id,1'); ?>>회원아이디</option>
        <option value="mb_id,0"<?php echo get_selected($sfl, 'mb_id,0'); ?>>회원아이디(코)</option>
        <option value="wr_name,1"<?php echo get_selected($sfl, 'wr_name,1'); ?>>글쓴이</option>
        <option value="wr_name,0"<?php echo get_selected($sfl, 'wr_name,0'); ?>>글쓴이(코)</option>
    </select>
    <label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>
    <input type="text" name="stx" value="<?php echo stripslashes($stx) ?>" required  class="frm_input required" size="15" maxlength="15">
    <input type="submit" value="검색" class="btn_submit">
    </form>
</fieldset>
<!-- } 게시판 검색 끝 -->


</div>




	<script type="text/javascript">
	var num = 0;
		jQuery(document).ready(function(){
			jQuery(".history_img").animate({opacity:0, marginTop:"-200px"}, 0);
			jQuery(".history_txt").animate({opacity:0, marginTop:"-50px"}, 0);
				$(".history_icon").animate({opacity:0, marginTop:"-50px"}, 0);
		})
		
		jQuery(window).load(function(){
			jQuery(".history_img").each(function(index){
				jQuery.easing.def = "easeOutQuart";
				num++;
				jQuery(".history_img").eq(index).delay((450 * num)).animate({opacity:1, marginTop:"0px"}, 900);
				jQuery(".history_txt").eq(index).delay((650 * num)).animate({opacity:1, marginTop:"0px"}, 900);
					$(".history_icon").eq(index).delay((650 * num)).animate({opacity:1, marginTop:"0px"}, 600);
			})
		})
	</script>
<script type="text/javascript">
if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';
if ('<?=$stx?>') {
    document.fsearch.sfl.value = '<?=$sfl?>';

    if ('<?=$sop?>' == 'and') 
        document.fsearch.sop[0].checked = true;

    if ('<?=$sop?>' == 'or')
        document.fsearch.sop[1].checked = true;
} else {
    document.fsearch.sop[0].checked = true;
}
</script>

<?php if ($is_checkbox) { ?>
<script>
function all_checked(sw) {
    var f = document.fboardlist;

    for (var i=0; i<f.length; i++) {
        if (f.elements[i].name == "chk_wr_id[]")
            f.elements[i].checked = sw;
    }
}

function fboardlist_submit(f) {
    var chk_count = 0;

    for (var i=0; i<f.length; i++) {
        if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
            chk_count++;
    }

    if (!chk_count) {
        alert(document.pressed + "할 게시물을 하나 이상 선택하세요.");
        return false;
    }

    if(document.pressed == "선택복사") {
        select_copy("copy");
        return;
    }

    if(document.pressed == "선택이동") {
        select_copy("move");
        return;
    }

    if(document.pressed == "선택삭제") {
        if (!confirm("선택한 게시물을 정말 삭제하시겠습니까?\n\n한번 삭제한 자료는 복구할 수 없습니다"))
            return false;
    }

    return true;
}

// 선택한 게시물 복사 및 이동
function select_copy(sw) {
    var f = document.fboardlist;

    if (sw == "copy")
        str = "복사";
    else
        str = "이동";

    var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");

    f.sw.value = sw;
    f.target = "move";
    f.action = "./move.php";
    f.submit();
}
</script>
<?php } ?>
<!-- } 게시판 목록 끝 -->
<script type="text/javascript" src="<?php echo $board_skin_url ?>/js/lightbox-2.6.min.js"></script>
 


여기서 php5.2, mysql 5.1.41 실행하면 출력이 잘되는데

php7, mysql 5.7.18 로 실행하면 


Fatal error: Uncaught Error: Call to undefined function mysql_num_rows() in /home/html/skin/board/history_edit/list.skin.php:27 Stack trace: #0 /home/html/bbs/list.php(244): include_once() #1 /home/html/bbs/board.php(235): include_once('/home/htm...') #2 {main} thrown in /home/asamo/html/skin/board/history_edit/list.skin.php on line 27 

에러가 뜹니다. mysql 버전때문인거같은데 ㅠㅠㅠ...

#그누보드5

이 질문에 댓글 쓰기 :

답변 1

플래토 홈페이지 자기소개 회원게시물 회원 질문검색 회원 답변검색 회원 댓글검색 님의 답변

218.♡.♡.130

예전에 mysql 로 시작하는 함수들을

mysqli 로 시작하도록 변경하셔야 할겁니다.



_num_rows($result); 

를 

@mysqli_num_rows($result); 


로 말이죠


해피정님의 댓글
↳ 해피정 홈페이지 자기소개 회원게시물 회원 질문검색 회원 답변검색 회원 댓글검색
14.♡.♡.29

mysqli_num_rows  이런 PHP 함수는 없습니다.
http://php.net/manual-lookup.php?pattern=mysqli_num_rows&scope=quickref

mysql_connect 를 mysqli-connect 로 변경해보세요
http://php.net/manual/en/function.mysqli-connect.php

답변을 작성하시기 전에 로그인 해주세요.
전체 4
문의 PC 버전
© SIRSOFT
현재 페이지 제일 처음으로