--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>
꼭좀 봐주세요