테스트 사이트 - 개발 중인 베타 버전입니다
SIR
목록으로
이전글 다음글

그누보드 질문입니다. 채택완료

roka1956 8년 전 조회 2,503
답변 1
목록 

</p><p><?</p><p>if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가 </p><p>include_once(G5_LIB_PATH.'/thumbnail.lib.php');</p><p>include_once $board_skin_path."/board_head.skin.php";</p><p>?></p><p><link rel="stylesheet" href="<?php echo $board_skin_url ?>/css/style.css"></p><p><link rel="stylesheet" type="text/css" href="<?php echo $board_skin_url ?>/css/lightbox.css" media="screen" /></p><p>
</p><p>
</p><p>
</p><p><div class="sub_con"></p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">	</span><div class="history_div mt55"></p><p>    <form name="fboardlist"  id="fboardlist" action="./board_list_update.php" onsubmit="return fboardlist_submit(this);" method="post"></p><p>    <input type="hidden" name="bo_table" value="<?php echo $bo_table ?>"></p><p>    <input type="hidden" name="sfl" value="<?php echo $sfl ?>"></p><p>    <input type="hidden" name="stx" value="<?php echo $stx ?>"></p><p>    <input type="hidden" name="spt" value="<?php echo $spt ?>"></p><p>    <input type="hidden" name="page" value="<?php echo $page ?>"></p><p>    <input type="hidden" name="sw" value=""></p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">		</span><!-- 게시판 목록 시작 --></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><?</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$sql = "SELECT * FROM $write_table ORDER BY wr_subject $board[bo_4], wr_1, wr_2 ";</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$result=sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$num_rows = @mysql_num_rows($result);</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$count = 0;</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>while($data=sql_fetch_array($result)) {</p><p><span class="Apple-tab-span" style="white-space:pre">			</span></p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$count++;</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>$hList[]=$data;<span class="Apple-tab-span" style="white-space:pre">	</span></p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>if($preYear != $data[wr_subject]) {</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$preYear = $data[wr_subject];</p><p>
</p><p>
</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if($count > 1) {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$cicle_img = '<div class="year_body"><span>'.$data[wr_subject].'</span></div>';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}elseif($count == 1){</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$cicle_img = '<div class="year_body first"><span>'.$data[wr_subject].'</span></div>';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo '<span class="Apple-tab-span" style="white-space:pre">				</span><div class="p_box '.$margin_top.'">';</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo '<span class="Apple-tab-span" style="white-space:pre">					</span><div class="history_img">'.$cicle_img.'</div>';</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo '<span class="Apple-tab-span" style="white-space:pre">					</span><div class="history_txt">';</p><p>
</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$tmp_write_table = $g5['write_prefix'] . $board['bo_table']; // 게시판 테이블 전체이름</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$sql_detail = " select * from {$tmp_write_table} where wr_subject = {$data[wr_subject]} order by wr_subject, wr_1, wr_2 $board[bo_4]";</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$result_detail = sql_query($sql_detail);</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$history_icon = '';</p><p><span class="Apple-tab-span" style="white-space:pre">				</span></p><p><span class="Apple-tab-span" style="white-space:pre">				</span>for ($i=0; $hList = sql_fetch_array($result_detail); $i++) {</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if($i == 0) {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span> if($i > -1) $margin_top = "mt30";</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo '<div class="tit">';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo '<span class="Apple-tab-span" style="white-space:pre">	</span><h4>'.$hList[wr_subject].'</h4>';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo '<span class="Apple-tab-span" style="white-space:pre">	</span><div class="bar"></div>';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo '</div>';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if (substr($hList[wr_1],0,1) == 1) { $disp_month = $hList[wr_1]; } else { $disp_month = substr($hList[wr_1],1,2); }</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$disp_day = $hList[wr_2];</p><p><span class="Apple-tab-span" style="white-space:pre">					</span></p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if($board[bo_3]=="d") {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$display = $disp_month."월 ".$disp_day." ";</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}else{</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$display = $disp_month."월 ";</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>echo '<p class="mt5">';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if($is_admin || $is_checkbox) echo '<input type="checkbox" name="chk_wr_id[]" value="'.$hList[wr_id].'" title="'.$hList[wr_subject].'"> ';</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if($is_admin) {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo ' <a href="'.G5_BBS_URL.'/write.php?bo_table='.$bo_table.'&w=u&wr_id='.$hList[wr_id].'">';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>echo $display.nl2br($hList[wr_content]);</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if ($is_admin)</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>set_session("ss_delete_token", $token = uniqid(time()));</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$delete_href ='./delete_all.php?bo_table='.$bo_table.'&amp;wr_id='.$hList[wr_id];</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo ' </a> ';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>echo '<a href="javascript:del(\''.$delete_href.'\');"><img src="'.$board_skin_url.'/img/btn_close.gif" alt="Delete" width="15px" height="14px" /></a>';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}<span class="Apple-tab-span" style="white-space:pre">	</span></p><p><span class="Apple-tab-span" style="white-space:pre">					</span>echo '</p>';</p><p>
</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if($thumb['src']) {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$history_icon .= '<div class="history_icon">';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$history_icon .= '<strong>'.$hList[wr_subject].'</strong>';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$history_icon .= '<p class="tit">'.$thumb['alt'].'</p>';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$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>';</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$history_icon .= '</div>';</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo '<span class="Apple-tab-span" style="white-space:pre">					</span></div>';</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo $history_icon;</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo '<span class="Apple-tab-span" style="white-space:pre">				</span></div>';</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>}</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>?></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><div class="p_box"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><div class="history_img"><img src="<?=$board_skin_url?>/img/history_start.gif" style="position:absolute;bottom:0;left:83px;" alt="history_start"></div></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><div class="history_txt"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></div></p><p><span class="Apple-tab-span" style="white-space:pre">		</span></div></p><p>
</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">	</span></div></p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">	</span><div class="mt40"></div></p><p>
</p><p>
</p><p>    <?php if ($is_admin || $list_href || $is_checkbox || $write_href) { ?></p><p>    <div class="bo_fx"></p><p>        <?php if ($is_checkbox) { ?></p><p>        <ul class="btn_bo_adm"></p><p>            <li><input type="submit" name="btn_submit" value="선택삭제" onclick="document.pressed=this.value"></li></p><p>            <li><input type="submit" name="btn_submit" value="선택복사" onclick="document.pressed=this.value"></li></p><p>            <li><input type="submit" name="btn_submit" value="선택이동" onclick="document.pressed=this.value"></li></p><p>        </ul></p><p>        <?php } ?></p><p>
</p><p>        <?php if ($list_href || $rss_href || $write_href) { ?></p><p>        <ul class="btn_bo_user"></p><p>            <?php if ($rss_href) { ?><li><a href="<?php echo $rss_href ?>" class="btn_b01">RSS</a></li><?php } ?></p><p>            <?php if ($admin_href) { ?><li><a href="<?php echo $admin_href ?>" class="btn_admin">관리자</a></li><?php } ?></p><p>            <?php if ($list_href) { ?><li><a href="<?php echo $list_href ?>" class="btn_b01">목록</a></li><?php } ?></p><p>            <?php if ($write_href) { ?><li><a href="<?php echo $write_href ?>" class="btn_b02">글쓰기</a></li><?php } ?></p><p>        </ul></p><p>        <?php } ?></p><p>    </div></p><p>    <?php } ?></p><p><span class="Apple-tab-span" style="white-space:pre">	</span></form></p><p>
</p><p>
</p><p>
</p><p><!-- 페이지 --></p><p><?php //echo $write_pages;  ?></p><p>
</p><p><!-- 게시판 검색 시작 { </p><p><fieldset id="bo_sch"></p><p>    <legend>게시물 검색</legend></p><p>
</p><p>    <form name="fsearch" method="get"></p><p>    <input type="hidden" name="bo_table" value="<?php echo $bo_table ?>"></p><p>    <input type="hidden" name="sca" value="<?php echo $sca ?>"></p><p>    <input type="hidden" name="sop" value="and"></p><p>    <label for="sfl" class="sound_only">검색대상</label></p><p>    <select name="sfl" id="sfl"></p><p>        <option value="wr_subject"<?php echo get_selected($sfl, 'wr_subject', true); ?>>제목</option></p><p>        <option value="wr_content"<?php echo get_selected($sfl, 'wr_content'); ?>>내용</option></p><p>        <option value="wr_subject||wr_content"<?php echo get_selected($sfl, 'wr_subject||wr_content'); ?>>제목+내용</option></p><p>        <option value="mb_id,1"<?php echo get_selected($sfl, 'mb_id,1'); ?>>회원아이디</option></p><p>        <option value="mb_id,0"<?php echo get_selected($sfl, 'mb_id,0'); ?>>회원아이디(코)</option></p><p>        <option value="wr_name,1"<?php echo get_selected($sfl, 'wr_name,1'); ?>>글쓴이</option></p><p>        <option value="wr_name,0"<?php echo get_selected($sfl, 'wr_name,0'); ?>>글쓴이(코)</option></p><p>    </select></p><p>    <label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label></p><p>    <input type="text" name="stx" value="<?php echo stripslashes($stx) ?>" required  class="frm_input required" size="15" maxlength="15"></p><p>    <input type="submit" value="검색" class="btn_submit"></p><p>    </form></p><p></fieldset></p><p><!-- } 게시판 검색 끝 --></p><p>
</p><p>
</p><p></div></p><p>
</p><p>
</p><p>
</p><p>
</p><p><span class="Apple-tab-span" style="white-space:pre">	</span><script type="text/javascript"></p><p><span class="Apple-tab-span" style="white-space:pre">	</span>var num = 0;</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>jQuery(document).ready(function(){</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>jQuery(".history_img").animate({opacity:0, marginTop:"-200px"}, 0);</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>jQuery(".history_txt").animate({opacity:0, marginTop:"-50px"}, 0);</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$(".history_icon").animate({opacity:0, marginTop:"-50px"}, 0);</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>})</p><p><span class="Apple-tab-span" style="white-space:pre">		</span></p><p><span class="Apple-tab-span" style="white-space:pre">		</span>jQuery(window).load(function(){</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>jQuery(".history_img").each(function(index){</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>jQuery.easing.def = "easeOutQuart";</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>num++;</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>jQuery(".history_img").eq(index).delay((450 * num)).animate({opacity:1, marginTop:"0px"}, 900);</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>jQuery(".history_txt").eq(index).delay((650 * num)).animate({opacity:1, marginTop:"0px"}, 900);</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$(".history_icon").eq(index).delay((650 * num)).animate({opacity:1, marginTop:"0px"}, 600);</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>})</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>})</p><p><span class="Apple-tab-span" style="white-space:pre">	</span></script></p><p><script type="text/javascript"></p><p>if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';</p><p>if ('<?=$stx?>') {</p><p>    document.fsearch.sfl.value = '<?=$sfl?>';</p><p>
</p><p>    if ('<?=$sop?>' == 'and') </p><p>        document.fsearch.sop[0].checked = true;</p><p>
</p><p>    if ('<?=$sop?>' == 'or')</p><p>        document.fsearch.sop[1].checked = true;</p><p>} else {</p><p>    document.fsearch.sop[0].checked = true;</p><p>}</p><p></script></p><p>
</p><p><?php if ($is_checkbox) { ?></p><p><script></p><p>function all_checked(sw) {</p><p>    var f = document.fboardlist;</p><p>
</p><p>    for (var i=0; i<f.length; i++) {</p><p>        if (f.elements[i].name == "chk_wr_id[]")</p><p>            f.elements[i].checked = sw;</p><p>    }</p><p>}</p><p>
</p><p>function fboardlist_submit(f) {</p><p>    var chk_count = 0;</p><p>
</p><p>    for (var i=0; i<f.length; i++) {</p><p>        if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)</p><p>            chk_count++;</p><p>    }</p><p>
</p><p>    if (!chk_count) {</p><p>        alert(document.pressed + "할 게시물을 하나 이상 선택하세요.");</p><p>        return false;</p><p>    }</p><p>
</p><p>    if(document.pressed == "선택복사") {</p><p>        select_copy("copy");</p><p>        return;</p><p>    }</p><p>
</p><p>    if(document.pressed == "선택이동") {</p><p>        select_copy("move");</p><p>        return;</p><p>    }</p><p>
</p><p>    if(document.pressed == "선택삭제") {</p><p>        if (!confirm("선택한 게시물을 정말 삭제하시겠습니까?\n\n한번 삭제한 자료는 복구할 수 없습니다"))</p><p>            return false;</p><p>    }</p><p>
</p><p>    return true;</p><p>}</p><p>
</p><p>// 선택한 게시물 복사 및 이동</p><p>function select_copy(sw) {</p><p>    var f = document.fboardlist;</p><p>
</p><p>    if (sw == "copy")</p><p>        str = "복사";</p><p>    else</p><p>        str = "이동";</p><p>
</p><p>    var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");</p><p>
</p><p>    f.sw.value = sw;</p><p>    f.target = "move";</p><p>    f.action = "./move.php";</p><p>    f.submit();</p><p>}</p><p></script></p><p><?php } ?></p><p><!-- } 게시판 목록 끝 --></p><p><script type="text/javascript" src="<?php echo $board_skin_url ?>/js/lightbox-2.6.min.js"></script></p><p> </p><p>


여기서 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개

채택된 답변
+20 포인트
플래토
플래토
8년 전

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

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



@mysql_num_rows($result); 

를 

@mysqli_num_rows($result); 


로 말이죠


로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

�
해피정
8년 전
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

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인