>> Edit article
이름
제목
패스워드
--guest_book.sql--start> create table guest_book( number int(4) not null default '0' auto_increment primary key, name char(10), passwd char(10), email char(30), homepage char(40), subject char(40), content text, wdate date); <--guest_book.sql--end> <--write.html--start> <html> <head> <title> 방명록 작성 </title> <script language=javascript> function field(arg , msg){ var result = true; if(!arg.value){ alert(msg); arg.focus(); result = false; } return result; } function checknsubmit(){ var data = document.mainform; if(!field(data.name , "이름을 적어 주세여")) return; if(!field(data.passwd , "비밀번호를 적어 주세여")) return; if(!field(data.subject , "제목을 적어 주세여")) return; if(!field(data.content , "내용을 적어 주세여")) return; data.submit(); } </script> </head> <body bgcolor=white> <center> 방문하신 님들의 방문 소감을 적어 주세여 <br> <form method=post action=write_ok.php name=mainform> <table border=0 cellspacing=2 cellpadding=0> <tr> <td bgcolor=#dddddd align=center> 이름 </td> <td bgcolor=#eeeeee> <input type=text name=name maxlength=5> </td> </tr> <tr> <td bgcolor=#dddddd align=center> 비밀번호 </td> <td bgcolor=#eeeeee> <input type=password name=passwd maxlength=10> <font size=-1> 글을 수정하거나 삭제 할때 필요합니다 </font> </td> </tr> <tr> <td bgcolor=#dddddd align=center> E-Mail </td> <td bgcolor=#eeeeee> <input type=text name=email maxlength=30 size=25> </td> </tr> <tr> <td bgcolor=#dddddd align=center> Homepage </td> <td bgcolor=#eeeeee> <input type=text name=homepage maxlength=40 size=30> </td> </tr> <tr> <td bgcolor=#dddddd align=center> 제목 </td> <td bgcolor=#eeeeee> <input type=text name=subject maxlength=40 size=30> </td> </tr> <tr> <td bgcolor=#dddddd align=center colspan=2> 내용 </td> </tr> <tr> <td bgcolor=#eeeeee align=center colspan=2> <textarea name=content cols=50 rows=10></textarea> </td> </tr> <tr> <td bgcolor=#dddddd align=center colspan=2> <input type=button value='확인' onClick=javascript:checknsubmit()> <input type=reset value='다시'> </td> </tr> </table> </form> </center> </body> </html> <--write.html--end> <--write_ok.php--start> <? $conn = mysql_connect('localhost' , 'phper' , 'pass'); mysql_select_db('php_study' , $conn); $wdate = date("Y-m-d"); if($homepage && !eregi("^http://" , $homepage)) $homepage = "http://".$homepage; $query = "insert into guest_book"; $query.= "(name,passwd,email,homepage,subject,content,wdate)"; $query.= "values('$name','$passwd','$email','$homepage','$subject','$content','$wdate')"; $result = mysql_query($query , $conn); $err_str = mysql_error(); mysql_close($conn); if(!$result) echo $err_str; else echo "글을 입력하는데 성공 했습니다"; echo "<a href=list.html> 방명록 목록으로 </a>"; ?> <--write_ok.php--end> <--list.php--start> <? $conn = mysql_connect('localhost','phper','pass'); mysql_select_db('php_study' , $conn); if(!$page) $page = 1; $cut = 8; $start = ($page * $cut) - $cut; $query = "select number,name,email,homepage,subject,content,wdate from guest_book"; $query.= " order by number desc LIMIT $start,$cut"; $total_number_query = "select count(number) as total from guest_book"; $result = mysql_query($query , $conn); $total_number_result = mysql_query($total_number_query , $conn); $total_number = mysql_result($total_number_result , 0 , "total"); mysql_close($conn); ?> <html> <head> <title> 방명록 목록 </title> </head> <body bgcolor=white link=blue alink=orange vlink=blue> <center> 방명록 목록입니다 <a href=write.html> 글 남기기 </a> <table border=0 cellspacing=2 cellpadding=0> <? while($data = mysql_fetch_array($result)){ if($data[email]) $writer = "<a href=mailto:$data[email]> $data[name] </a>"; else $writer = $data[name]; if($data[homepage]) $homepage = "<a href=$data[homepage]> <img src=home.gif border=0> </a>"; else $homepage = ""; $content = nl2br($data[content]); echo(" <tr bgcolor=#cccccc> <td> $writer 님이 $data[wdate] 에 남기신 글 입니다 Homepage : $homepage </td> </tr> <tr bgcolor=#dddddd> <td align=center> <b> $data[subject] <b> </td> </tr> <tr bgcolor=#eeeeee> <td> $content </td> </tr> <tr> <td align=right> <a href=mod.html?number=$data[number]> 수정 </a> <a href=del.html?number=$data[number]> 삭제 </a> </td> </tr> <tr> <td height=20> </td> </tr> "); } ?> </table> <? $total_page = ceil($total_number / $cut); $jmp = 10; $end_jmp = ceil($page / $jmp) * $jmp; $start_jmp = $end_jmp - $jmp; $prev_page = $page - 1; $next_page = $page + 1; if($end_jmp > $total_page) $end_jmp = $total_page; if($prev_page > 0) echo "[<a href=list.html?page=$prev_page>이전</a>]"; else echo "[이전]"; for($i = $start_jmp + 1 ; $i < $end_jmp + 1; $i++){ if($i == $page) echo "<b> $i </b>"; else echo "<a href=list.html?page=$i> $i </a>"; } if($next_page <= $total_page) echo "[<a href=list.html?page=$next_page>다음</a>]"; else echo "[다음]"; ?> <br> </center> </body> </html> <--list.php--end> 꼭좀 봐주세요
Copyleft
1999-2026 by
JSBoard Open Project
Theme Designed by
IDOO
All right reserved