조회수 추가 방법 좀 알려주세요 정보
조회수 추가 방법 좀 알려주세요본문
까만 도둑님의 글등록현황 부분에서 조회수를 추가하고 싶은데 제가 아는게 없어서 어떻게 해야할지 모르겠습니다. 방법 좀 알려주세요.
초보라 잘 모르니 아주 자세히 좀요.. ㅜㅜ;;
까만도둑님 글등록현황 주소: http://sir.co.kr/bbs/board.php?bo_table=g4_tiptech&wr_id=9
위 주소에 있는 글등록현황을 사용하고 있는데 그곳에 글 조회수도 넣고 싶습니다.
* 이하 까만도둑님의 글등록현황 소스입니다.
* 초보라 잘 몰라요. 자세히 좀 알려주세요.
--------------------------------------------------------------------------------------
<?
$g4_path = "..";
include_once ("$g4_path/common.php");
include_once("$g4[path]/head.php");
$g4[title] = "$member[mb_name] 게시물등록 현황";
//$main_width = "98%";
?>
<title><?=$g4[title]?> 게시물등록 현황</title>
<br>
<table width=98% align=center cellpadding=0 cellspacing=0 border=0>
<tr>
<td>
<?
//echo $user_id;
//echo $user_num;
// 그룹정보읽기
$dbqry="select from $g4[group_table] order by gr_id";
$rs=mysql_query($dbqry);
while($row=sql_fetch_array($rs)) {
$group_list[$row[gr_id]]=$row;
}
$gr_name='';
// 게시판 목록을 읽어서 메뉴로 만들어 버린다.
$dbqry="
SELECT * FROM $g4[board_table]
where bo_table<>'gmnotice' and bo_table<>'qna' and bo_table<>'application' and bo_table<>'photo' and bo_table<>'taste' and bo_table<>'mypage' and bo_table<>'ggggbada' and bo_table<>'fdddfdbd' and bo_table<>'tretrgooin' and gr_id<>'etc' and gr_id<>'gr_11' and gr_id<>'gr_12' and gr_id<>'gr_03' and gr_id<>'gr_04' and gr_id<>'gr_05' and gr_id<>'gr_06' and gr_id<>'gr_07' and gr_id<>'gr_08' and gr_id<>'gr_09'
/*제외하고픈 게시판 테이블명 및 그룹명 설정 ORDER BY gr_id, bo_table, bo_subject */
ORDER BY gr_id, bo_table, bo_subject
";
$my_post_rs=sql_query($dbqry);
$total_board = mysql_num_rows($my_post_rs);
?>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td bgcolor="FFFFFF">
<!-- 전체게시물 목록보이기 -->
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr bgColor=000000>
<!--
<td colspan="2" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
<td colspan="2" align="right" style='padding:4 8 4 4;color:ffffff;'>
<a href="javascript:self.close()" style="font-family:Verdana;font-size:12px;color:FFFFFF;font-weight:bold;">닫기</a>
</td>-->
<td colspan="1" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
</tr>
<?
$all_my_post = 0;
$all_my_cmt = 0;
while($row=sql_fetch_array($my_post_rs)) {
$gul_su_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1'";
$my_post_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1' and mb_id = '$member[mb_id]'";
/*
$gul_su_qry="select * from $g4[write_table] where wr_comment = '0'";
$my_post_qry="select * from $g4[write_table] where wr_comment = '0' and mb_id = '$member[mb_id]'";
*/
$gul=sql_query($gul_su_qry);
$total_gul = mysql_num_rows($gul);
$my_all_gul = $my_all_gul+$total_gul;
$my_post=sql_query($my_post_qry);
$my_post = mysql_num_rows($my_post);
$all_my_post = $all_my_post+$my_post;
//$my_post_per = ( $my_post / $total_gul )*100;
if ($my_post) {$my_post_per = ( $my_post / $total_gul )*100; }
$my_post_per = intval($my_post_per);
//$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;
if ($all_my_post) {$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;}
$tot_my_post_per = intval($tot_my_post_per);
$cmt_su_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1'";
// $my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
$my_cmt_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1' and mb_id = '$member[mb_id]'";
$cmt=sql_query($cmt_su_qry);
// $total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
$total_cmt = mysql_num_rows($cmt); //게시판코멘트수
$my_all_cmt = $my_all_cmt+$total_cmt; //내가쓴게시판코멘트수
$my_cmt=sql_query($my_cmt_qry);
$my_cmt = mysql_num_rows($my_cmt); //전체게시판코멘트수
$all_my_cmt = $all_my_cmt+$my_cmt; //내가쓴전체게시판코멘트수
//echo $total_cmt." : ".$my_all_cmt." : ".$my_cmt." : ".$all_my_cmt." : ";
@$my_cmt_per = ( $my_cmt / $total_cmt )*100;
$my_cmt_per = intval($my_cmt_per);
@$tot_my_cmt_per = ( $all_my_cmt / $my_all_cmt )*100;
$tot_my_cmt_per = intval($tot_my_cmt_per);
?>
<!-- 전체게시물 목록보이기 -->
<tr>
<td align=left bgColor="" style='padding:2 0 0 4;font-family:;font-size:12px;'>
<a href='../<?=$g4[bbs]?>/board.php?bo_table=<?=$row[bo_table]?>' onfocus=this.blur();><B><?=$row[bo_subject]?></B></a>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_gul?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span><br>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="./img_my/piegraph/<?=$my_post_per?>.png" align="middle">
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="./img_my/piegraph/<?=$my_cmt_per?>.png" align="middle">
</td>
</tr>
<!-- 전체게시물 목록보이기 -->
<tr><td colspan="9" bgColor=E9E9E9 height=1></td></tr>
<?
}
?>
<tr><td colspan="9" height="1" bgcolor=666666></td></tr>
<tr>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<b>전체현황</b>
</td>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<B><?=$my_all_gul?></B>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="./img_my/piegraph/<?=$tot_my_post_per?>.png">
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:000000;font-weight:bold;'>
<?=$my_all_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="./img_my/piegraph/<?=$tot_my_cmt_per?>.png">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<?
include_once("$g4[path]/tail.php");
?>
초보라 잘 모르니 아주 자세히 좀요.. ㅜㅜ;;
까만도둑님 글등록현황 주소: http://sir.co.kr/bbs/board.php?bo_table=g4_tiptech&wr_id=9
위 주소에 있는 글등록현황을 사용하고 있는데 그곳에 글 조회수도 넣고 싶습니다.
* 이하 까만도둑님의 글등록현황 소스입니다.
* 초보라 잘 몰라요. 자세히 좀 알려주세요.
--------------------------------------------------------------------------------------
<?
$g4_path = "..";
include_once ("$g4_path/common.php");
include_once("$g4[path]/head.php");
$g4[title] = "$member[mb_name] 게시물등록 현황";
//$main_width = "98%";
?>
<title><?=$g4[title]?> 게시물등록 현황</title>
<br>
<table width=98% align=center cellpadding=0 cellspacing=0 border=0>
<tr>
<td>
<?
//echo $user_id;
//echo $user_num;
// 그룹정보읽기
$dbqry="select from $g4[group_table] order by gr_id";
$rs=mysql_query($dbqry);
while($row=sql_fetch_array($rs)) {
$group_list[$row[gr_id]]=$row;
}
$gr_name='';
// 게시판 목록을 읽어서 메뉴로 만들어 버린다.
$dbqry="
SELECT * FROM $g4[board_table]
where bo_table<>'gmnotice' and bo_table<>'qna' and bo_table<>'application' and bo_table<>'photo' and bo_table<>'taste' and bo_table<>'mypage' and bo_table<>'ggggbada' and bo_table<>'fdddfdbd' and bo_table<>'tretrgooin' and gr_id<>'etc' and gr_id<>'gr_11' and gr_id<>'gr_12' and gr_id<>'gr_03' and gr_id<>'gr_04' and gr_id<>'gr_05' and gr_id<>'gr_06' and gr_id<>'gr_07' and gr_id<>'gr_08' and gr_id<>'gr_09'
/*제외하고픈 게시판 테이블명 및 그룹명 설정 ORDER BY gr_id, bo_table, bo_subject */
ORDER BY gr_id, bo_table, bo_subject
";
$my_post_rs=sql_query($dbqry);
$total_board = mysql_num_rows($my_post_rs);
?>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td bgcolor="FFFFFF">
<!-- 전체게시물 목록보이기 -->
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr bgColor=000000>
<!--
<td colspan="2" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="3" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
<td colspan="2" align="right" style='padding:4 8 4 4;color:ffffff;'>
<a href="javascript:self.close()" style="font-family:Verdana;font-size:12px;color:FFFFFF;font-weight:bold;">닫기</a>
</td>-->
<td colspan="1" height=40 align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
My Status - <FONT COLOR="FFE311"><? if(!$member[mb_id]) { echo "비회원"; } ?><?=$member[mb_name]?></FONT>
</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
글등록 현황</td>
<td colspan="4" align="center" style='font-family:Verdana;font-size:12px;padding:4 0 4 10;color:ffffff;font-weight:bold;'>
코멘트 현황</td>
</tr>
<?
$all_my_post = 0;
$all_my_cmt = 0;
while($row=sql_fetch_array($my_post_rs)) {
$gul_su_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1'";
$my_post_qry="select * from g4_write_$row[bo_table] where wr_comment > '-1' and mb_id = '$member[mb_id]'";
/*
$gul_su_qry="select * from $g4[write_table] where wr_comment = '0'";
$my_post_qry="select * from $g4[write_table] where wr_comment = '0' and mb_id = '$member[mb_id]'";
*/
$gul=sql_query($gul_su_qry);
$total_gul = mysql_num_rows($gul);
$my_all_gul = $my_all_gul+$total_gul;
$my_post=sql_query($my_post_qry);
$my_post = mysql_num_rows($my_post);
$all_my_post = $all_my_post+$my_post;
//$my_post_per = ( $my_post / $total_gul )*100;
if ($my_post) {$my_post_per = ( $my_post / $total_gul )*100; }
$my_post_per = intval($my_post_per);
//$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;
if ($all_my_post) {$tot_my_post_per = ( $all_my_post / $my_all_gul )*100;}
$tot_my_post_per = intval($tot_my_post_per);
$cmt_su_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1'";
// $my_cmt_qry="select * from g4_write_$row[bo_table] where wr_comment < '0' and mb_id = '$member[mb_id]'";
$my_cmt_qry="select * from {$g4[write_prefix]}{$row[bo_table]} where wr_is_comment = '1' and mb_id = '$member[mb_id]'";
$cmt=sql_query($cmt_su_qry);
// $total_cmt = mysql_num_rows($cmt) - mysql_num_rows($gul); //게시판코멘트수
$total_cmt = mysql_num_rows($cmt); //게시판코멘트수
$my_all_cmt = $my_all_cmt+$total_cmt; //내가쓴게시판코멘트수
$my_cmt=sql_query($my_cmt_qry);
$my_cmt = mysql_num_rows($my_cmt); //전체게시판코멘트수
$all_my_cmt = $all_my_cmt+$my_cmt; //내가쓴전체게시판코멘트수
//echo $total_cmt." : ".$my_all_cmt." : ".$my_cmt." : ".$all_my_cmt." : ";
@$my_cmt_per = ( $my_cmt / $total_cmt )*100;
$my_cmt_per = intval($my_cmt_per);
@$tot_my_cmt_per = ( $all_my_cmt / $my_all_cmt )*100;
$tot_my_cmt_per = intval($tot_my_cmt_per);
?>
<!-- 전체게시물 목록보이기 -->
<tr>
<td align=left bgColor="" style='padding:2 0 0 4;font-family:;font-size:12px;'>
<a href='../<?=$g4[bbs]?>/board.php?bo_table=<?=$row[bo_table]?>' onfocus=this.blur();><B><?=$row[bo_subject]?></B></a>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_gul?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span><br>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="./img_my/piegraph/<?=$my_post_per?>.png" align="middle">
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$total_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:EF5900;font-size:10px;font-weight:bold;padding:0 4 0 0;'>
<?=$my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;color:000000;font-size:10px;font-weight:bold;'>
<?=$my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:;color:;padding:4;'>
<img src="./img_my/piegraph/<?=$my_cmt_per?>.png" align="middle">
</td>
</tr>
<!-- 전체게시물 목록보이기 -->
<tr><td colspan="9" bgColor=E9E9E9 height=1></td></tr>
<?
}
?>
<tr><td colspan="9" height="1" bgcolor=666666></td></tr>
<tr>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<b>전체현황</b>
</td>
<td align="left" style='font-family:Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:;'>
<B><?=$my_all_gul?></B>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_post?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>post</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_post_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="./img_my/piegraph/<?=$tot_my_post_per?>.png">
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:000000;font-weight:bold;'>
<?=$my_all_cmt?>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:0 4 0 0;color:EF5900;font-weight:bold;'>
<?=$all_my_cmt?> <span style='font-family:tahoma,Verdana;font-size:9px;color:999999;font-weight:bold;'>comment</span>
</td>
<td align="right" style='font-family:tahoma,Verdana;font-size:12px;padding:4 0 4 4;color:000000;font-weight:bold;'>
<?=$tot_my_cmt_per?>%
</td>
<td align="right" style='font-family:Verdana;font-size:10px;color:ffffff;font-weight:bold;padding:4;'>
<img src="./img_my/piegraph/<?=$tot_my_cmt_per?>.png">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<?
include_once("$g4[path]/tail.php");
?>
댓글 전체