PHP 프로그래밍

Web Programming >> PHP Programming

제12장 게시판 프로그램(MySQL)

1. MySQL을 이용한 게시판 만들기

1. 게시판 테이블 만들기

create table board (
uid       int not null default '0' auto_increment,
num    int not null default '0',
writer   varchar(20),
email   varchar(60),
subject    varchar(50),
content    blob,
passwd    varchar(30),
r_step      varchar(250),
regtime    datetime,
visit         int,
primary key(uid));

2. 게시판의 기능들...

게시물 목록 출력(list.html)
새로운 게시물 등록하기(writeform.html, write.html)
게시물 내용보기(read.html)
게시물 답변글 쓰기(replyform.html, reply.html)
게시물 수정하기(modifyform.html, modify.html)
게시물 삭제하기(deleteform.html, delete.html)

<그림> 게시판 흐름도

3. 목록출력하기(list.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

if(!$db)

{

echo "<SCRIPT>alert('게시판 DB Name이 입력되지 않았습니다.');history.go(-1);</SCRIPT>";

exit;

}

$query = "SELECT count(*) FROM $db";

$result = mysql_query($query,$connect);

$row = mysql_fetch_row($result);

$total = $row[0];

if(!$page) $page=1;

$ppage = $page - 1;

$npage = $page + 1;

$pgsize = 10;

$totalpage = (int)($total/$pgsize);

if(($total%$pgsize) <> 0) $totalpage++;

$rcount=1;

echo "

<HEAD>

<TITLE>LeeLAB - 게시판</TITLE>

<!--

A:link{text-decoration:none;color:}

A:visited{text-decoration:none;color:}

A:hover {background-color:dddddd}

-->

</STYLE>

</HEAD>

<TR>

<TD ALIGN=LEFT><FONT SIZE=2>총 게시물 : $total</TD>

<TD ALIGN=RIGHT><FONT SIZE=2>현재 페이지 :

<SELECT NAME=PAGE onchange=\"location.replace('list.html?db=$db&page='+document.PAGE.PAGE.value);\">";

for($i=1;$i<=$totalpage;$i++)

{

if($i==$page) echo "<OPTION VALUE='$i' SELECTED>$i / $totalpage</OPTION>";

else echo "<OPTION VALUE='$i'>$i / $totalpage</OPTION>";

}

echo "</SELECT></TD>

</TR>

</FORM>

</TABLE>

<TR>

</TR>";

$query = "SELECT num,subject,writer,visit,regtime,r_step FROM $db ORDER BY num DESC,r_step ASC";

$result = mysql_query($query,$connect);

for($i=1;$i<=$pgsize*($page-1);$i++) $row=mysql_fetch_array($result);

while($row = mysql_fetch_array($result))

{

$writer = stripslashes($row[writer]);

$email = stripslashes($row[email]);

$subject = stripslashes($row[subject]);

$content = stripslashes($row[content]);

$passwd = stripslashes($row[passwd]);

$regtime = substr($row[regtime],0,10);

echo "

<TR>

<TD ALIGN=CENTER BGCOLOR='eeeeee'><FONT SIZE=2>";

if($row[r_step] == 0) echo $row[num];

else echo " ";

echo "</FONT></TD>

<TD BGCOLOR='eeeeee'><FONT SIZE=2>";

if($row[r_step] != 0) echo "    ☞ ";

echo " <A HREF='read.html?db=$db&num=$row[num]&page=$page&r_step=$row[r_step]'>$subject</A></FONT></TD>

<TD ALIGN=CENTER BGCOLOR='eeeeee'><FONT SIZE=2>$writer</FONT></TD>

<TD ALIGN=CENTER BGCOLOR='eeeeee'><FONT SIZE=2>$row[visit]</FONT></TD>

<TD ALIGN=CENTER BGCOLOR='eeeeee'><FONT SIZE=2>$regtime</FONT></TD>

</TR>";

if($rcount == $pgsize) break;

else $rcount++;

}

echo "

</TABLE><BR>

<TR>

[ ";

if($page > 1) echo "<A HREF='list.html?db=$db&page=$ppage'>이전페이지</A>";

else echo "이전페이지";

echo "]  

[ <A HREF='writeform.html?db=$db&page=$page'>글쓰기</A> ]  

[ ";

if($page < $totalpage) echo "<A HREF='list.html?db=$db&page=$npage'>다음페이지</A>";

else echo "다음페이지";

echo "]</TD>

</FORM>

</TR>

</TABLE>";

4. 새로운 게시물 등록하기(writeform.html, write.html)

등록 폼 만들기(writeform.html)

<HEAD>

<TITLE>LeeLAB - 게시판</TITLE>

<!--

A:link{text-decoration:none;color:}

A:visited{text-decoration:none;color:}

A:hover {background-color:dddddd}

-->

</STYLE>

function chk_form()

{

if(document.signform.writer.value == '') alert('이름을 입력하여 주세요.');

else if(document.signform.subject.value == '') alert('제목을 입력하여 주세요');

else if(document.signform.content.value.length < 10) alert('내용을 성심껏 입력해주세요');

else if(document.signform.passwd.value == '') alert('비밀번호는 추후 글을 수정,삭제하는데 필요하니 입력해주세요.');

else document.signform.submit();

}

</SCRIPT>

</HEAD>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

</TABLE>

<TR>

</TR>

</TABLE>

</FORM>

</BODY>

</HTML>

등록 처리 프로그램(write.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

$writer = addslashes($writer);

$email = addslashes($email);

$subject = addslashes($subject);

$content = addslashes($content);

$passwd = addslashes($passwd);

$query = "SELECT max(num) FROM $db";

$result = mysql_query($query,$connect);

$num = mysql_result($result,0,0)+1;

$query = "INSERT INTO $db (num,writer,email,subject,content,passwd,r_step,regtime,visit) VALUES ($num,'$writer','$email','$subject','$content','$passwd','0',NOW(),0)";

$result = mysql_query($query,$connect);

echo "<SCRIPT>location.replace('list.html?db=$db&page=$page');</SCRIPT>";

5. 게시물 내용 보기(read.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

$query = "UPDATE $db SET visit=visit+1 WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

$query = "SELECT * FROM $db WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

$row = mysql_fetch_array($result);

$writer = stripslashes($row[writer]);

$email = stripslashes($row[email]);

$subject = stripslashes($row[subject]);

$content = stripslashes($row[content]);

$passwd = stripslashes($row[passwd]);

$content = nl2br($content);

echo "

<HEAD>

<TITLE>LeeLAB - 게시판</TITLE>

<!--

A:link{text-decoration:none;color:}

A:visited{text-decoration:none;color:}

A:hover {background-color:dddddd}

-->

</STYLE>

</HEAD>

<TR>

<TD BGCOLOR='eeeeee' WIDTH=280><FONT SIZE=2> $writer</TD>

<TD BGCOLOR='bbbbbb'

ALIGN=CENTER WIDTH=80><FONT SIZE=2 COLOR=black>작성시간</FONT></TD>

<TD BGCOLOR='eeeeee' WIDTH=160 ALIGN=CENTER><FONT SIZE=2>$row[regtime]</TD>

</TR>

<TR>

<FONT SIZE=2><A HREF='mailto:$row[email]'>$row[email]</A></TD>

<TD BGCOLOR='eeeeee' WIDTH=160 ALIGN=CENTER><FONT SIZE=2>$row[visit]</TD>

</TR>

<TR>

<TD BGCOLOR='eeeeee' COLSPAN=3><FONT SIZE=2> $subject</TD>

</TR>

</TABLE>

<BR>

<TR>

<TD BGCOLOR='eeeeee' COLSPAN=2><BR><FONT SIZE=2>$content<BR><BR></TD>

</TR>

</TABLE>

<BR>

<TR>

[ <A HREF='list.html?db=$db&page=$page'>글목록</A> ]  

[ <A HREF='modifyform.html?db=$db&num=$num&r_step=$r_step&page=$page'>글수정</A> ]  

[ <A HREF='replyform.html?db=$db&num=$num&r_step=$r_step&page=$page'>답변글</A> ]  

[ <A HREF='deleteform.html?db=$db&num=$num&r_step=$r_step&page=$page'>삭제하기</A> ]</TD>

</TR>

</TABLE>";

6. 답변글 쓰기(replyform.html, reply.html)

답변글 쓰기 폼 만들기(replyform.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

$query = "SELECT content FROM $db WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

$row = mysql_fetch_array($result);

$writer = stripslashes($row[writer]);

$email = stripslashes($row[email]);

$subject = stripslashes($row[subject]);

$content = stripslashes($row[content]);

$passwd = stripslashes($row[passwd]);

<HEAD>

<TITLE>LeeLAB - 게시판</TITLE>

<!--

A:link{text-decoration:none;color:}

A:visited{text-decoration:none;color:}

A:hover {background-color:dddddd}

-->

</STYLE>

function chk_form()

{

if(document.replyform.writer.value == '') alert('이름을 입력하여 주세요.');

else if(document.replyform.subject.value == '') alert('제목을 입력하여 주세요');

else if(document.replyform.content.value.length < 10) alert('내용을 성심껏 입력해주세요');

else if(document.replyform.passwd.value == '') alert('비밀번호는 추후 글을 수정,삭제하는데 필요하니 입력해주세요.');

else document.replyform.submit();

}

</SCRIPT>

</HEAD>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

<TR>

<?echo "답변 : $row[content]

------------------------------------------------------------\n";?>

</TEXTAREA></TD>

</TR>

<TR>

</TR>

</TABLE>

<TR>

</TR>

</TABLE>

</FORM>

</BODY>

</HTML>

답변글 쓰기 처리 프로그램(reply.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

$writer = addslashes($writer);

$email = addslashes($email);

$subject = addslashes($subject);

$content = addslashes($content);

$passwd = addslashes($passwd);

$query = "SELECT r_step FROM $db WHERE num=$num ORDER BY r_step DESC";

$result = mysql_query($query,$connect);

$row = mysql_fetch_array($result);

$r_step = $row[r_step] + 1;

$query = "INSERT INTO $db (num,writer,email,subject,content,passwd,r_step,regtime,visit) VALUES ($num,'$writer', '$email','$subject','$content','$passwd','$r_step',NOW(),0)";

$result = mysql_query($query,$connect);

if(!$result) {

echo($query);

exit;

}

echo "<SCRIPT>location.replace('list.html?db=$db&page=$page');</SCRIPT>";

7. 게시물 수정하기(modifyform.html, modify.html)

게시물 수정 폼 만들기(modifyform.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

if(!$r_step) $r_step=0;

$query = "SELECT * FROM $db WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

$row = mysql_fetch_array($result);

$writer = stripslashes($row[writer]);

$email = stripslashes($row[email]);

$subject = stripslashes($row[subject]);

$content = stripslashes($row[content]);

$passwd = stripslashes($row[passwd]);

<HEAD>

<TITLE>LeeLAB - 게시판</TITLE>

<!--

A:link{text-decoration:none;color:}

A:visited{text-decoration:none;color:}

A:hover {background-color:dddddd}

-->

</STYLE>

function chk_form()

{

if(document.modifyform.writer.value == '') alert('이름을 입력하여 주세요.');

else if(document.modifyform.subject.value == '') alert('제목을 입력하여 주세요');

else if(document.modifyform.content.value.length < 10) alert('내용을 성심껏 입력해주세요');

else if(document.modifyform.passwd.value == '') alert('글을 수정하시려면 비밀번호가 필요합니다..');

else document.modifyform.submit();

}

</SCRIPT>

</HEAD>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

</TABLE>

<TR>

</TR>

</TABLE>

</FORM>

</BODY>

</HTML>

게시물 수정 처리 프로그램(modify.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

$writer = addslashes($writer);

$email = addslashes($email);

$subject = addslashes($subject);

$content = addslashes($content);

$passwd = addslashes($passwd);

$query = "SELECT passwd FROM $db WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

$row = mysql_fetch_array($result);

if($row[passwd] == $passwd) {

$query = "UPDATE $db SET writer='$writer',email='$email',subject='$subject',content='$content' WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

echo "<SCRIPT>location.replace('read.html?db=$db&num=$num&r_step=$r_step&page=$page');</SCRIPT>";

}

else {

echo "<SCRIPT>alert('비밀번호가 틀렸습니다.');history.go(-1);</SCRIPT>";

exit;

}

8. 게시물 삭제하기(deleteform.html, delete.html)

게시물 삭제 폼 만들기(deleteform.html)

<HEAD>

<TITLE>LeeLAB - 게시판</TITLE>

<!--

A:link{text-decoration:none;color:}

A:visited{text-decoration:none;color:}

A:hover {background-color:dddddd}

-->

</STYLE>

</HEAD>

<BODY>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

</TABLE>

</FORM>

</BODY>

</HTML>

게시물 삭제 처리 프로그램(delete.html)

$connect = mysql_connect("localhost","php","php99");

mysql_select_db("sample",$connect);

$writer = addslashes($writer);

$email = addslashes($email);

$subject = addslashes($subject);

$content = addslashes($content);

$passwd = addslashes($passwd);

$query = "SELECT passwd FROM $db WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

$row = mysql_fetch_array($result);

if($row[passwd] == $passwd) {

$query = "DELETE FROM $db WHERE num=$num AND r_step='$r_step'";

$result = mysql_query($query,$connect);

echo "<SCRIPT>location.replace('list.html?db=$db&page=$page');</SCRIPT>";

}

else {

echo "<SCRIPT>alert('비밀번호가 틀렸습니다.');history.go(-1);</SCRIPT>";

exit;

}

[목차]