전략의 중심에서 고객과 함께 하십쇼
페이지 정보
작성자 vsun 작성일02-01-02 22:35 조회1,453회 댓글0건본문
<?php
// ===================================================
// DB 접속에 필요한 사항을 설정합니다.
// host,user_id, user_passwd, user_db 부분을 고치세요
// ===================================================
$connect = mysql_connect("host","user_id_","user_passwd") or die("SQL server에 연결할 수 없습니다.");
mysql_select_db("user_db",$connect);
// ================
// 게시판 환경설정
// ================
$scale = 5; // 한 페이지당 자료 수
$admin_ip = '127.0.0.1'; // 삭제시 필요한 관리자 IP
$html_allow = 0; // HTML 허용 여부(1 -> yes, 0 -> no)
// ==========
// 글 지우기
// ==========
if ($mode == 'del') {
if ($REMOTE_ADDR != $admin_ip) {
echo("
<script>
window.alert('관리자만 지울 수 있습니다.')
</script>");
echo("<meta http-equiv='Refresh' content='0; URL=$PHP_SELF'>");
exit;
}
else {
$que1 = "delete from guestbook where id=$id";
$result = mysql_query($que1,$connect);
}
}
// =============
// 새 글 올리기
// =============
if ($mode == 'up') {
if (!$name || !$comment) {
echo("
<script>
window.alert('이름과 남기실 말씀을 적어 주세요');
history.go(-1);
</script>");
exit;
}
if (!$allow_html) {
$name = htmlspecialchars($name);
$comment = htmlspecialchars($comment);
}
$name = addslashes($name);
$home = addslashes($home);
$email = addslashes($email);
$comment = addslashes($comment);
$que1 = "insert into guestbook values('','$name','$home','$email','$comment','$REMOTE_ADDR',now())";
$result = mysql_query($que1,$connect);
if ($result) {
echo("<META http-equiv='Refresh' content='0; URL=$PHP_SELF'>");
exit;
}
else {
echo("
<script>
window.alert('DB 오류가 발생하였습니다.');
history.go(-1);
</script>");
exit;
}
}
// ==============
// 새 글 쓰기 폼
// ==============
if ($mode == 'new') {
include('header.inc');
echo("
<FORM name='form' method='post' action='$PHP_SELF'>
<TABLE border='0' cellspacing='1'>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>이름</FONT></TD>
<TD width='541'><P> <INPUT type='text' name='name' SIZE=6 MAXLENGTHTH='20'></TD>
</TR>
<TR>
<TD bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>HOMEPAGE</FONT></TD>
<TD><P> http://<INPUT type='text' name='home' maxlength='40'></TD>
</TR>
<TR>
<TD bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Email 주소</FONT></TD>
<TD><P> <INPUT type='text' name='email' size=20 maxlength='40'></TD>
</TR>
<TR>
<TD bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>남기실 말씀</FONT></TD>
<TD><P><TEXTAREA name='comment' rows='4' cols='35'></TEXTAREA></TD>
</TR>
<TR>
<TD><P> </TD>
<TD><P> <INPUT type='submit' name='submit' value='글올리기'></TD>
</TR>
</TABLE>
<input type=hidden name=mode value='up'>
</FORM>");
}
// =============
// 내용보여주기
// =============
if (!$mode || $result) {
if (!$start) { $start = 0; }
$que1 = "select DATE_FORMAT(reg_date,'Y.m.d'),id,comment,name,home,email,ip from guestbook order by id DESC";
$result = mysql_query($que1,$connect);
$total = mysql_affected_rows();
if ($start) { $n = $total - $start; }
else { $n = $total; }
include('header.inc');
for($i=$start ; $i<$start+$scale ; $i++) { // start 에서 scale 까지 만
if ($i < $total) { // 전체 자료 개수까지만 출력
mysql_data_seek($result,$i);
$row = mysql_fetch_array($result);
$row[comment] = stripslashes($row[comment]) ;
echo("
<TABLE border='0' cellspacing='1'>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'><a href=$PHP_SELF?mode=del&id=$row[id]><IMG src='./img/del.gif' width='22' height='13' border='0' alt='지우기'></a></FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#FAF1C7'>$row[0] from $row[ip]</FONT></TD>
</TR>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Name</FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#E7EEF5'>$row[name]</FONT></TD>
</TR>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Home / Email</FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#E7EEF5'> </FONT>");
if ($row[email]) echo("<A href='mailto:$row[email]'><IMG SRC=./img/mail.gif BORDER=0 ALT='편지쓰기' align=center><FONT face='굴림' size='2' color='#E7EEF5'>$row[email]</FONT></A> ");
if ($row[home]) echo("<a href=http://$row[home]><IMG SRC=./img/home.gif BORDER=0 ALT='홈페이지' align=center><FONT face='굴림' size='2' color='#E7EEF5'>http://$row[home]</FONT></a>");
echo("
</TD>
</TR>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Comment </FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#E7EEF5'>$row[comment]</FONT></TD>
</TR>
<TR>
<TD width='109'><P><HR size='1' noshade></TD>
<TD width='541'><P><HR size='1' noshade></TD>
</TR></TABLE>");
}
}
}
// ===================== 내용 보여주기 끝 ===========
if (!$mode || $result) { // ==================== 하단 버튼 ==============
echo("
<center>
<a href=$PHP_SELF?mode=new><IMG HEIGHT=30 WIDTH=30 SRC='./img/write.gif' VSPACE=0 HSPACE=0 ALIGN='TOP' BORDER=0 alt='방명록에 글쓰기'></a> ");
$p_p = $start - $scale ;
$n_p = $start + $scale ;
if ($p_p >= 0 && $mode != 'new') {
echo("<a href='$PHP_SELF?start=$p_p'><IMG HEIGHT=30 WIDTH=30 SRC='./img/p-doc.gif' VSPACE=0 HSPACE=0 ALIGN='TOP' BORDER=0 alt='이전 페이지'></a> ");
}
if ($n_p < $total && $mode != 'new') {
echo("<a href='$PHP_SELF?start=$n_p'><IMG HEIGHT=30 WIDTH=30 SRC='./img/n-doc.gif' VSPACE=0 HSPACE=0 ALIGN='TOP' BORDER=0 alt='다음 페이지'></a></center>");
}
}
echo("
<p>
</BODY>
</HTML>");
?>
// ===================================================
// DB 접속에 필요한 사항을 설정합니다.
// host,user_id, user_passwd, user_db 부분을 고치세요
// ===================================================
$connect = mysql_connect("host","user_id_","user_passwd") or die("SQL server에 연결할 수 없습니다.");
mysql_select_db("user_db",$connect);
// ================
// 게시판 환경설정
// ================
$scale = 5; // 한 페이지당 자료 수
$admin_ip = '127.0.0.1'; // 삭제시 필요한 관리자 IP
$html_allow = 0; // HTML 허용 여부(1 -> yes, 0 -> no)
// ==========
// 글 지우기
// ==========
if ($mode == 'del') {
if ($REMOTE_ADDR != $admin_ip) {
echo("
<script>
window.alert('관리자만 지울 수 있습니다.')
</script>");
echo("<meta http-equiv='Refresh' content='0; URL=$PHP_SELF'>");
exit;
}
else {
$que1 = "delete from guestbook where id=$id";
$result = mysql_query($que1,$connect);
}
}
// =============
// 새 글 올리기
// =============
if ($mode == 'up') {
if (!$name || !$comment) {
echo("
<script>
window.alert('이름과 남기실 말씀을 적어 주세요');
history.go(-1);
</script>");
exit;
}
if (!$allow_html) {
$name = htmlspecialchars($name);
$comment = htmlspecialchars($comment);
}
$name = addslashes($name);
$home = addslashes($home);
$email = addslashes($email);
$comment = addslashes($comment);
$que1 = "insert into guestbook values('','$name','$home','$email','$comment','$REMOTE_ADDR',now())";
$result = mysql_query($que1,$connect);
if ($result) {
echo("<META http-equiv='Refresh' content='0; URL=$PHP_SELF'>");
exit;
}
else {
echo("
<script>
window.alert('DB 오류가 발생하였습니다.');
history.go(-1);
</script>");
exit;
}
}
// ==============
// 새 글 쓰기 폼
// ==============
if ($mode == 'new') {
include('header.inc');
echo("
<FORM name='form' method='post' action='$PHP_SELF'>
<TABLE border='0' cellspacing='1'>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>이름</FONT></TD>
<TD width='541'><P> <INPUT type='text' name='name' SIZE=6 MAXLENGTHTH='20'></TD>
</TR>
<TR>
<TD bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>HOMEPAGE</FONT></TD>
<TD><P> http://<INPUT type='text' name='home' maxlength='40'></TD>
</TR>
<TR>
<TD bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Email 주소</FONT></TD>
<TD><P> <INPUT type='text' name='email' size=20 maxlength='40'></TD>
</TR>
<TR>
<TD bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>남기실 말씀</FONT></TD>
<TD><P><TEXTAREA name='comment' rows='4' cols='35'></TEXTAREA></TD>
</TR>
<TR>
<TD><P> </TD>
<TD><P> <INPUT type='submit' name='submit' value='글올리기'></TD>
</TR>
</TABLE>
<input type=hidden name=mode value='up'>
</FORM>");
}
// =============
// 내용보여주기
// =============
if (!$mode || $result) {
if (!$start) { $start = 0; }
$que1 = "select DATE_FORMAT(reg_date,'Y.m.d'),id,comment,name,home,email,ip from guestbook order by id DESC";
$result = mysql_query($que1,$connect);
$total = mysql_affected_rows();
if ($start) { $n = $total - $start; }
else { $n = $total; }
include('header.inc');
for($i=$start ; $i<$start+$scale ; $i++) { // start 에서 scale 까지 만
if ($i < $total) { // 전체 자료 개수까지만 출력
mysql_data_seek($result,$i);
$row = mysql_fetch_array($result);
$row[comment] = stripslashes($row[comment]) ;
echo("
<TABLE border='0' cellspacing='1'>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'><a href=$PHP_SELF?mode=del&id=$row[id]><IMG src='./img/del.gif' width='22' height='13' border='0' alt='지우기'></a></FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#FAF1C7'>$row[0] from $row[ip]</FONT></TD>
</TR>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Name</FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#E7EEF5'>$row[name]</FONT></TD>
</TR>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Home / Email</FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#E7EEF5'> </FONT>");
if ($row[email]) echo("<A href='mailto:$row[email]'><IMG SRC=./img/mail.gif BORDER=0 ALT='편지쓰기' align=center><FONT face='굴림' size='2' color='#E7EEF5'>$row[email]</FONT></A> ");
if ($row[home]) echo("<a href=http://$row[home]><IMG SRC=./img/home.gif BORDER=0 ALT='홈페이지' align=center><FONT face='굴림' size='2' color='#E7EEF5'>http://$row[home]</FONT></a>");
echo("
</TD>
</TR>
<TR>
<TD width='109' bgcolor='#5485B6'><P align='center'><FONT face='굴림' size='2' color='#CDDAE4'>Comment </FONT></TD>
<TD width='541'><P><FONT face='굴림' size='2' color='#E7EEF5'>$row[comment]</FONT></TD>
</TR>
<TR>
<TD width='109'><P><HR size='1' noshade></TD>
<TD width='541'><P><HR size='1' noshade></TD>
</TR></TABLE>");
}
}
}
// ===================== 내용 보여주기 끝 ===========
if (!$mode || $result) { // ==================== 하단 버튼 ==============
echo("
<center>
<a href=$PHP_SELF?mode=new><IMG HEIGHT=30 WIDTH=30 SRC='./img/write.gif' VSPACE=0 HSPACE=0 ALIGN='TOP' BORDER=0 alt='방명록에 글쓰기'></a> ");
$p_p = $start - $scale ;
$n_p = $start + $scale ;
if ($p_p >= 0 && $mode != 'new') {
echo("<a href='$PHP_SELF?start=$p_p'><IMG HEIGHT=30 WIDTH=30 SRC='./img/p-doc.gif' VSPACE=0 HSPACE=0 ALIGN='TOP' BORDER=0 alt='이전 페이지'></a> ");
}
if ($n_p < $total && $mode != 'new') {
echo("<a href='$PHP_SELF?start=$n_p'><IMG HEIGHT=30 WIDTH=30 SRC='./img/n-doc.gif' VSPACE=0 HSPACE=0 ALIGN='TOP' BORDER=0 alt='다음 페이지'></a></center>");
}
}
echo("
<p>
</BODY>
</HTML>");
?>