묻고답하기
게시판 문의
2004.12.20 11:14
http://smrpc.com/zboard/zboard.php?id=apt안녕하세요...
제가 한 아파트 입주자 모임카페를 운영하고 있는데 입주자들이 온라인 상에서 간단한 신상명세를 기록하고 볼 수 있는
게시판을 만들려고 합니다.
아래 링크를 보시면 달력스킨으로 제가 해볼려고 하는데 잘 안되서 조언 부탁 드립니다.
제 의도는 첨에 블럭 형식의 게시판에서 동호수를 클릭하면 신상명세가 나오고 거기서 입력및 수정을 할 수 있게 할려고 합니다.
한블럭에 한개의 신상명세만 기록할 수 있으면 됩니다.
그리고 신상명세가 기록이 된 블럭은 색깔이 틀려서 입주가 되었다는것을 알수있게 할려고 합니다.
현재 입력을 누르면 입력은 되는데 동호수를 클릭해서 입련된 신상명세를 볼려고 하면 입력된 게시물이 없다고 나옵니다.
왜 그런지 아래 소스보시고 답변 좀 부탁 드립니다.
- view.php
<table border="0" cellpadding="0" cellspacing="0" width="60%">
<form method=post name=write action=write_ok.php onsubmit="return check_submit();" enctype=multipart/form-data>
<input type=hidden name=id value=<?=$id?>>
<input type=hidden name=no value=<?=$no?>>
<input type=hidden name=member_id value="<?=$data[user_id]?>">
<tr>
<td width="600" height="35" colspan="3" align="center" valign="middle" bgcolor="#F2F2F2">
♧ 간단한 신상명세를 기록해 주세요 ♧ </td>
</tr>
<tr>
<td width="600" height="9" colspan="3">
</td>
</tr>
<tr>
<td width="111" height="25">
성명
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
동호수
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=subject value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
주소
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
이메일
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=email value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="187">
본인소개
</td>
<td width="1" height="187" bgcolor="silver">
</td>
<td width="500" height="187">
<TEXTAREA class=textarea name="memo" style="WIDTH:97%" rows="10" cols="15">
</TEXTAREA>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="34" colspan="3">
</td>
</tr>
<tr>
<td width="600" height="36" align="center" valign="middle" colspan="3" bgcolor="#F2F2F2">
<input type=image border=0 src="images/writeok.gif" align=absmiddle border=0 accesskey="s"onclick="selectall('ex_field');" tabindex=44>
<img src="images/writecancel.gif" align=absmiddle border=0 style=cursor:hand onclick=history.back()>
</td>
</tr></form>
</table>
<?=$hide_download1_start?>
<table border="0" cellpadding="0" cellspacing="0" width=<?=$width?>>
<tr height=23>
<td align=right width=70 background=<?=$dir?>/img/background.gif><img src=<?=$dir?>/img/file_1.gif border=0> </td>
<td ><img src=images/t.gif height=3><br> <font class=thm8><?=$a_file_link1?><?=$file_name1?> (<?=$file_size1?>)</a> <font style=font-family:matchworks,tahoma;font-size:7pt>Download : <b><?=$file_download1?></b></font></font></td>
</tr>
<tr><td bgcolor=#FFEBCA height=1 colspan=2><img src=images/t.gif height=1></td></tr>
</table>
<?=$hide_download1_end?>
<?=$hide_download2_start?>
<table border="0" cellpadding="0" cellspacing="0" width=<?=$width?>>
<tr height=23>
<td align=right width=70 background=<?=$dir?>/img/background.gif><img src=<?=$dir?>/img/file_2.gif border=0> </td>
<td ><img src=images/t.gif height=3><br> <font class=thm8><?=$a_file_link2?><?=$file_name2?> (<?=$file_size2?>)</a> <font style=font-family:matchworks,tahoma;font-size:7pt>Download : <b><?=$file_download2?></b></font></font></td>
</tr>
<tr><td bgcolor=#FFEBCA height=1 colspan=2><img src=images/t.gif height=1></td></tr>
</table>
<?=$hide_download2_end?>
<?=$hide_sitelink2_start?>
<table border="0" cellpadding="0" cellspacing="0" width=<?=$width?>>
<tr height=23>
<td align=right width=70 background=<?=$dir?>/img/background.gif><img src=<?=$dir?>/img/link_1.gif border=0> </td>
<td ><img src=images/t.gif height=3><br> <font class=thm8><?=$sitelink2?></font></td>
</tr>
<tr><td bgcolor=#FFEBCA height=1 colspan=2><img src=images/t.gif height=1></td></tr>
</table>
<?=$hide_sitelink2_end?>
<table border=0 cellspacing=0 cellpadding=0 width=<?=$width?>>
<tr>
<td style='word-break:break-all;padding:10px;' bgcolor=#FFFFFF height=120 valign=top>
<span style=line-height:150%>
<?=$memo?>
</span>
</td>
</tr>
<tr>
<td height="30" valign="middle"><div align=right style=font-family:Tahoma;font-size:7pt;><?=$ip?></div></td>
</tr>
</table>
<table width='<?=$width?>' border=0 cellspacing=0 cellpadding=0 bordercolorlight=#FF3F9F bordercolordark=#FFFFFF>
<tr>
<td bgcolor="#FFEBCA" HEIGHT="2" ></td>
</tr>
</table>
아래부터는 write.php입니다.
<?
// 라이브러리 함수 파일 인크루드
// DB 연결
if(!$connect) $connect=dbConn();
$data2=mysql_fetch_array(mysql_query("select * from $member_table where user_id='$id' || no='$member_no'"));
// MySQL 닫기
if($connect) mysql_close($connect);
?>
<html>
<head>
<title>간단한 신상명세 기록</title>
<meta name="generator" content="Namo WebEditor v4.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<table border="0" cellpadding="0" cellspacing="0" width="60%">
<form method=post name=write action=write_ok.php onsubmit="return check_submit();" enctype=multipart/form-data>
<input type=hidden name=id value=<?=$id?>>
<input type=hidden name=no value=<?=$no?>>
<input type=hidden name=member_id value="<?=$data[user_id]?>">
<tr>
<td width="600" height="35" colspan="3" align="center" valign="middle" bgcolor="#F2F2F2">
♧ 간단한 신상명세를 기록해 주세요 ♧ </td>
</tr>
<tr>
<td width="600" height="9" colspan="3">
</td>
</tr>
<tr>
<td width="111" height="25">
성명
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
동호수
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=subject value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
주소
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
이메일
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=email value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="187">
본인소개
</td>
<td width="1" height="187" bgcolor="silver">
</td>
<td width="500" height="187">
<TEXTAREA class=textarea name="memo" style="WIDTH:97%" rows="10" cols="15">
</TEXTAREA>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="34" colspan="3">
</td>
</tr>
<tr>
<td width="600" height="36" align="center" valign="middle" colspan="3" bgcolor="#F2F2F2">
<input type=image border=0 src="images/writeok.gif" align=absmiddle border=0 accesskey="s"onclick="selectall('ex_field');" tabindex=44>
<img src="images/writecancel.gif" align=absmiddle border=0 style=cursor:hand onclick=history.back()>
</td>
</tr></form>
</table>
<p> </p>
</body>
</html>
아래는 list_head.php입니다.
<br>
<table cellspacing=0 cellpadding=1 bordercolorlight='<?=$bordercolorlight?>' bordercolordark='<?=$bordercolordark?>' border=1 align='center'>
<tr>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3004호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3003호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3002호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3001호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
</tr>
<tr>
제가 한 아파트 입주자 모임카페를 운영하고 있는데 입주자들이 온라인 상에서 간단한 신상명세를 기록하고 볼 수 있는
게시판을 만들려고 합니다.
아래 링크를 보시면 달력스킨으로 제가 해볼려고 하는데 잘 안되서 조언 부탁 드립니다.
제 의도는 첨에 블럭 형식의 게시판에서 동호수를 클릭하면 신상명세가 나오고 거기서 입력및 수정을 할 수 있게 할려고 합니다.
한블럭에 한개의 신상명세만 기록할 수 있으면 됩니다.
그리고 신상명세가 기록이 된 블럭은 색깔이 틀려서 입주가 되었다는것을 알수있게 할려고 합니다.
현재 입력을 누르면 입력은 되는데 동호수를 클릭해서 입련된 신상명세를 볼려고 하면 입력된 게시물이 없다고 나옵니다.
왜 그런지 아래 소스보시고 답변 좀 부탁 드립니다.
- view.php
<table border="0" cellpadding="0" cellspacing="0" width="60%">
<form method=post name=write action=write_ok.php onsubmit="return check_submit();" enctype=multipart/form-data>
<input type=hidden name=id value=<?=$id?>>
<input type=hidden name=no value=<?=$no?>>
<input type=hidden name=member_id value="<?=$data[user_id]?>">
<tr>
<td width="600" height="35" colspan="3" align="center" valign="middle" bgcolor="#F2F2F2">
♧ 간단한 신상명세를 기록해 주세요 ♧ </td>
</tr>
<tr>
<td width="600" height="9" colspan="3">
</td>
</tr>
<tr>
<td width="111" height="25">
성명
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
동호수
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=subject value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
주소
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
이메일
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=email value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="187">
본인소개
</td>
<td width="1" height="187" bgcolor="silver">
</td>
<td width="500" height="187">
<TEXTAREA class=textarea name="memo" style="WIDTH:97%" rows="10" cols="15">
</TEXTAREA>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="34" colspan="3">
</td>
</tr>
<tr>
<td width="600" height="36" align="center" valign="middle" colspan="3" bgcolor="#F2F2F2">
<input type=image border=0 src="images/writeok.gif" align=absmiddle border=0 accesskey="s"onclick="selectall('ex_field');" tabindex=44>
<img src="images/writecancel.gif" align=absmiddle border=0 style=cursor:hand onclick=history.back()>
</td>
</tr></form>
</table>
<?=$hide_download1_start?>
<table border="0" cellpadding="0" cellspacing="0" width=<?=$width?>>
<tr height=23>
<td align=right width=70 background=<?=$dir?>/img/background.gif><img src=<?=$dir?>/img/file_1.gif border=0> </td>
<td ><img src=images/t.gif height=3><br> <font class=thm8><?=$a_file_link1?><?=$file_name1?> (<?=$file_size1?>)</a> <font style=font-family:matchworks,tahoma;font-size:7pt>Download : <b><?=$file_download1?></b></font></font></td>
</tr>
<tr><td bgcolor=#FFEBCA height=1 colspan=2><img src=images/t.gif height=1></td></tr>
</table>
<?=$hide_download1_end?>
<?=$hide_download2_start?>
<table border="0" cellpadding="0" cellspacing="0" width=<?=$width?>>
<tr height=23>
<td align=right width=70 background=<?=$dir?>/img/background.gif><img src=<?=$dir?>/img/file_2.gif border=0> </td>
<td ><img src=images/t.gif height=3><br> <font class=thm8><?=$a_file_link2?><?=$file_name2?> (<?=$file_size2?>)</a> <font style=font-family:matchworks,tahoma;font-size:7pt>Download : <b><?=$file_download2?></b></font></font></td>
</tr>
<tr><td bgcolor=#FFEBCA height=1 colspan=2><img src=images/t.gif height=1></td></tr>
</table>
<?=$hide_download2_end?>
<?=$hide_sitelink2_start?>
<table border="0" cellpadding="0" cellspacing="0" width=<?=$width?>>
<tr height=23>
<td align=right width=70 background=<?=$dir?>/img/background.gif><img src=<?=$dir?>/img/link_1.gif border=0> </td>
<td ><img src=images/t.gif height=3><br> <font class=thm8><?=$sitelink2?></font></td>
</tr>
<tr><td bgcolor=#FFEBCA height=1 colspan=2><img src=images/t.gif height=1></td></tr>
</table>
<?=$hide_sitelink2_end?>
<table border=0 cellspacing=0 cellpadding=0 width=<?=$width?>>
<tr>
<td style='word-break:break-all;padding:10px;' bgcolor=#FFFFFF height=120 valign=top>
<span style=line-height:150%>
<?=$memo?>
</span>
</td>
</tr>
<tr>
<td height="30" valign="middle"><div align=right style=font-family:Tahoma;font-size:7pt;><?=$ip?></div></td>
</tr>
</table>
<table width='<?=$width?>' border=0 cellspacing=0 cellpadding=0 bordercolorlight=#FF3F9F bordercolordark=#FFFFFF>
<tr>
<td bgcolor="#FFEBCA" HEIGHT="2" ></td>
</tr>
</table>
아래부터는 write.php입니다.
<?
// 라이브러리 함수 파일 인크루드
// DB 연결
if(!$connect) $connect=dbConn();
$data2=mysql_fetch_array(mysql_query("select * from $member_table where user_id='$id' || no='$member_no'"));
// MySQL 닫기
if($connect) mysql_close($connect);
?>
<html>
<head>
<title>간단한 신상명세 기록</title>
<meta name="generator" content="Namo WebEditor v4.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<table border="0" cellpadding="0" cellspacing="0" width="60%">
<form method=post name=write action=write_ok.php onsubmit="return check_submit();" enctype=multipart/form-data>
<input type=hidden name=id value=<?=$id?>>
<input type=hidden name=no value=<?=$no?>>
<input type=hidden name=member_id value="<?=$data[user_id]?>">
<tr>
<td width="600" height="35" colspan="3" align="center" valign="middle" bgcolor="#F2F2F2">
♧ 간단한 신상명세를 기록해 주세요 ♧ </td>
</tr>
<tr>
<td width="600" height="9" colspan="3">
</td>
</tr>
<tr>
<td width="111" height="25">
성명
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
동호수
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=subject value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
주소
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=name value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="25">
이메일
</td>
<td width="1" height="25" bgcolor="silver">
</td>
<td width="500" height="25">
<input type=text name=email value="" size="34" maxlength=200 class=input style=width:97%>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="111" height="187">
본인소개
</td>
<td width="1" height="187" bgcolor="silver">
</td>
<td width="500" height="187">
<TEXTAREA class=textarea name="memo" style="WIDTH:97%" rows="10" cols="15">
</TEXTAREA>
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="1" colspan="3" bgcolor="silver">
</td>
</tr>
<tr>
<td width="600" height="34" colspan="3">
</td>
</tr>
<tr>
<td width="600" height="36" align="center" valign="middle" colspan="3" bgcolor="#F2F2F2">
<input type=image border=0 src="images/writeok.gif" align=absmiddle border=0 accesskey="s"onclick="selectall('ex_field');" tabindex=44>
<img src="images/writecancel.gif" align=absmiddle border=0 style=cursor:hand onclick=history.back()>
</td>
</tr></form>
</table>
<p> </p>
</body>
</html>
아래는 list_head.php입니다.
<br>
<table cellspacing=0 cellpadding=1 bordercolorlight='<?=$bordercolorlight?>' bordercolordark='<?=$bordercolordark?>' border=1 align='center'>
<tr>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3004호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3003호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3002호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
<td align=center height="100" width="100" font class=ver9><?
echo ("<A HREF='view.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>3001호</b></font></a></span> <br>" );
echo ;
?>
<?
echo ("<A HREF='write.php?$href&no=$data[no]' onfocus=blur() ><font color='$day_color'>$category_name$comment <b>입력</b></font></a></span> <br>" );
echo "</td>";
?>
</tr>
<tr>