삭제 - delete.php

728x90

<html>
<?
$number = $_GET["number"];
$page = $_GET["page"];
?>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title>글 삭제</title>
<STYLE TYPE="text/css">
BODY,TD,SELECT,input,DIV,form,TEXTAREA,center,option,pre,blockquote {font-family:굴림;font-size:9pt;color:#555555;}
A:link {color:black;text-decoration:none;}
A:visited {color:black;text-decoration:none;}
A:active {color:black;text-decoration:none;}
A:hover {color:gray;text-decoration:none;}
</STYLE>
<script language="javascript">
function check_submit() {
if (document.myForm.password.value == "") {
alert('비밀번호를 입력해야 글을 삭제할 수 있습니다.');
document.myForm.password.focus();
return;
} else {
document.myForm.action = "delete_ok.php";
document.myForm.submit();
}
}
</script>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<form name="myForm" method="post">
<input type="hidden" name="page" value="<? echo $page; ?>">
<input type="hidden" name="number" value="<? echo $number; ?>">
<table align="center" border="1" cellspacing="0" width="200" bordercolordark="white" bordercolorlight="#CCCCCC">
<tr>
<td>
<p align="center">글 삭제 비밀번호</p>
</td>
</tr>
<tr>
<td align="center">
<input type="password" name="password" maxlength="12" size="12">
</td>
</tr>
</table>
<p align="center">[<a href="javascript:check_submit();">삭제</a>] [<a href="javascript:history.go(-1)">취소</a>]</p>
</form>
</body>
</html>

======================================================================

delete_ok.php

======================================================================

<?
//db 연결 부분입니다.
mysql_connect("localhost", "phpbbs", "phpbbs") or die (mysql_error()); //host,id,passwd
mysql_select_db("itmembers"); //db이름
//변수
$password = $_POST["password"];
$password = addslashes($password);
$tablename="bbs"; //테이블 이름
$number = $_POST["number"];
$page = $_POST["page"];
//비밀번호가 맞는지 확인합니다.
$sql = "select number from $tablename where number=$number and password=$password";
$result = mysql_query($sql) or die (mysql_error());
$msg = "비밀번호가 틀립니다.";
if(mysql_num_rows($result)) { //반환된 열이 있으면...
//삭제합니다.
$sql = "delete from $tablename where number=$number";
mysql_query($sql) or die (mysql_error());
$msg = "삭제하였습니다.";
}
//메시지를 출력하고 목록 페이지로 이동합니다.
echo " <html><head>
<script name=javascript>
if('$msg' != '') {
self.window.alert('$msg');
}
location.href='list.php?page=$page';
</script>
</head>
</html> ";
?>

728x90