··조회 13,286
게시판 코멘트에 대해 의문이있습니다.
parent 에 db안에 값이 안들어가는데요 이유가 뭐죠 ㅠㅠ 휴 모르겠어요
제가 이렇게 코딩했거든요 ㅠㅠ
<?php
//테이블지정 및 db연결
$board = "board_dap"; //게시판답글의 테이블이 아닌 게시판테이블이름입니다.
$conn = mysql_connect("localhost","nurimnet","rurusy1");
mysql_select_db("nurimnet", $conn);
mysql_query("UPDATE $board SET see=see+1 WHERE number='$number'", $conn); //조회수증가
$res1 = mysql_query("SELECT * FROM $board WHERE number='$number'", $conn); //글정보가지고오기
if(!$res1) dbError();
$row = mysql_fetch_array($res1);
/*-------------------------------------------------------------------------------------*/
//아래부분부터 코멘트를 위한 소스입니다.
$res2 = mysql_query("SELECT count(*) FROM $board WHERE $research", $conn);
//게시판의 id를 bbs_id로 적용하고 게시판답글을 number 역순으로 출력
$res_dap = mysql_query("SELECT number, parent, name, pass, comment FROM board_dap where parent='$row[number]' ORDER BY number DESC", $conn); //위줄과 한줄입니다 너무길어서 짤라습니다 ^^;;
$total = mysql_num_rows($res_dap);
if($total) {
$i=0;
while($i<$total) {
$dap_id = mysql_result($res_dap, $i, "number");
$name = mysql_result($res_dap, $i, "name");
$pass = mysql_result($res_dap, $i, "pass");
$comment = mysql_result($res_dap, $i, "comment");
$htmlStr .= "
<table width='580' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td width='90'><font color='#999999'>$name</font></td>
<td widtn='100'><font color='#999999'>$comment</font></td>
<td align='left' style='padding:0 10 0 0'><a href=predel_dap.php?dap_id=$dap_id&number=$number><img src='../images/button_img15.gif' border=0></a></td>
</tr>
</table>";
$i = $i + 1;
}
} else {
$htmlStr .= "
<table width='580' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td align=center>등록된 내용이 없습니다</td>
</tr>
</table>
";
}
?>
<script language=javascript>
function formCheck(Form)
{
if(!Form.name.value)
{
alert('이름을 입력해주세요.'); //코멘트미입력시 출력
Form.name.focus();
return false;
}
if(!Form.pass.value)
{
alert('비밀번호을 입력해주세요.'); //이름 미입력시 출력
Form.pass.focus();
return false;
}
if(!Form.comment.value)
{
alert('한줄 코멘트를 입력해주세요.'); //비밀번호 미입력시 출력
Form.comment.focus();
return false;
}
Form.action = 'board_dap.php?type=comment'
return true;
}
</script>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<form name=form2 method=post onSubmit='return formCheck(this)'>
<tr>
<td width=100 align="center"><font size="2" color="#999999">이름</font><?=$row[comm_su]?><input type=text name=name style="border:1 solid #999999; background:#ffffff; height:15px" size="7"></td>
<td width=100 align="center"><font size="2" color="#999999">비밀번호</font><input type=password name=pass style="border:1 solid #999999; background:#ffffff; height:15px" size="7"></td>
<td width=350 align="center"><font size="2" color="#999999">코멘트</font><input type=text name=comment style="border:1 solid #999999; background:#ffffff; height:15px" size="50"><input type=hidden name=id value='<?=$row[number]?>'></td>
<td width=100 align="center"><input type="image" src="../images/icon03.gif" width="50" height="17"></td>
</tr>
</form>
</table>
<?=$htmlStr?>
제가 이렇게 코딩했거든요 ㅠㅠ
<?php
//테이블지정 및 db연결
$board = "board_dap"; //게시판답글의 테이블이 아닌 게시판테이블이름입니다.
$conn = mysql_connect("localhost","nurimnet","rurusy1");
mysql_select_db("nurimnet", $conn);
mysql_query("UPDATE $board SET see=see+1 WHERE number='$number'", $conn); //조회수증가
$res1 = mysql_query("SELECT * FROM $board WHERE number='$number'", $conn); //글정보가지고오기
if(!$res1) dbError();
$row = mysql_fetch_array($res1);
/*-------------------------------------------------------------------------------------*/
//아래부분부터 코멘트를 위한 소스입니다.
$res2 = mysql_query("SELECT count(*) FROM $board WHERE $research", $conn);
//게시판의 id를 bbs_id로 적용하고 게시판답글을 number 역순으로 출력
$res_dap = mysql_query("SELECT number, parent, name, pass, comment FROM board_dap where parent='$row[number]' ORDER BY number DESC", $conn); //위줄과 한줄입니다 너무길어서 짤라습니다 ^^;;
$total = mysql_num_rows($res_dap);
if($total) {
$i=0;
while($i<$total) {
$dap_id = mysql_result($res_dap, $i, "number");
$name = mysql_result($res_dap, $i, "name");
$pass = mysql_result($res_dap, $i, "pass");
$comment = mysql_result($res_dap, $i, "comment");
$htmlStr .= "
<table width='580' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td width='90'><font color='#999999'>$name</font></td>
<td widtn='100'><font color='#999999'>$comment</font></td>
<td align='left' style='padding:0 10 0 0'><a href=predel_dap.php?dap_id=$dap_id&number=$number><img src='../images/button_img15.gif' border=0></a></td>
</tr>
</table>";
$i = $i + 1;
}
} else {
$htmlStr .= "
<table width='580' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td align=center>등록된 내용이 없습니다</td>
</tr>
</table>
";
}
?>
<script language=javascript>
function formCheck(Form)
{
if(!Form.name.value)
{
alert('이름을 입력해주세요.'); //코멘트미입력시 출력
Form.name.focus();
return false;
}
if(!Form.pass.value)
{
alert('비밀번호을 입력해주세요.'); //이름 미입력시 출력
Form.pass.focus();
return false;
}
if(!Form.comment.value)
{
alert('한줄 코멘트를 입력해주세요.'); //비밀번호 미입력시 출력
Form.comment.focus();
return false;
}
Form.action = 'board_dap.php?type=comment'
return true;
}
</script>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<form name=form2 method=post onSubmit='return formCheck(this)'>
<tr>
<td width=100 align="center"><font size="2" color="#999999">이름</font><?=$row[comm_su]?><input type=text name=name style="border:1 solid #999999; background:#ffffff; height:15px" size="7"></td>
<td width=100 align="center"><font size="2" color="#999999">비밀번호</font><input type=password name=pass style="border:1 solid #999999; background:#ffffff; height:15px" size="7"></td>
<td width=350 align="center"><font size="2" color="#999999">코멘트</font><input type=text name=comment style="border:1 solid #999999; background:#ffffff; height:15px" size="50"><input type=hidden name=id value='<?=$row[number]?>'></td>
<td width=100 align="center"><input type="image" src="../images/icon03.gif" width="50" height="17"></td>
</tr>
</form>
</table>
<?=$htmlStr?>