php) 게시판 만들기 (글수정 글삭제)

by 히드라✧ 2022. 3. 8. php

edit.php

<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/html">
<head>
    <meta charset="UTF-8">
    <title>BBS demo</title>
</head>
<body>
    <?php
    $id=$_GET['id'];
    // mysql 연결
    $host = 'localhost:3306';
    $user = 'root';
    $pw = '52273178';
    $dbName = 'study_db';
    $conn = new mysqli($host, $user, $pw, $dbName);
    $sql = "SELECT * FROM BBS WHERE id=$id";
    $result = mysqli_query($conn, $sql);
    while($row = mysqli_fetch_array($result)){
    ?>
    <form method="post" action="editing.php">
        <h1>editing</h1>
        <input type="hidden" name="id" value="<?php echo $row['id'] ?>">
        <h3>title<input type="text" name="title" value="<?php echo $row['title'] ?>"></h3>
        <h3>writer<input type="text" name="writer" value="<?php echo $row['writer'] ?>"></h3>
        <h3>content</h3><br>
        <textarea rows="7" cols="33" name="content"><?php echo $row['content'] ?></textarea></br>
        <button type="submit">submit</button>
        <button type="reset">reset</button>
    </form>
        <button onclick=location.href="./deleting.php?id=<?php echo $id ?>">delete</button>
        <?php
    }
    $conn->close();
    ?>
</body>
</html>

editing.php

<?php
$id=$_POST['id'];
$title=$_POST['title'];
$writer=$_POST['writer'];
$content=$_POST['content'];
// mysql 연결
$host = "localhost";
$user = "root";
$pw = "52273178";
$dbName = "study_db";
$conn = new mysqli($host, $user, $pw, $dbName);
$sql = "UPDATE BBS SET title='$title', content='$content', publish=NOW() WHERE id = '$id'";
if ($conn->query($sql) === TRUE) { ?>
    <script>
        alert("<?php echo "alert: 게시글이 수정되었습니다.";
            ?>");
        location.replace("<?php echo './list.php' ?>");
    </script>
    <?php
} else { ?>
    <script>
        alert("<?php echo "Error: " . $sql . "<br>" . $conn->error; ?>")
    </script>
    <?php
}
$conn->close();
?>

deleting.php

<script>
<?php
$id=$_GET['id'];
$host = "localhost";
$user = "root";
$pw = "52273178";
$dbName = "study_db";
$conn = new mysqli($host, $user, $pw, $dbName);
$sql = "DELETE FROM BBS WHERE id = '$id'";
if ($conn->query($sql) === TRUE) { ?>
    alert("<?php echo "alert: 게시글이 삭제되었습니다." ?>");
    location.replace("<?php echo './list.php' ?>");
<?php
} else { ?>
    alert("<?php echo "Error: " . $sql . "<br>" . $conn->error; ?>")
<?php
}
$conn->close();
?>
</script>
저작자표시 비영리 변경금지

'php' 카테고리의 다른 글

m1) php codeigniter (CI) 설치 (설정) (feat.homebrew) 수정중  (0) 2022.03.25
php) 로그인(세션_아이디저장) 글작성자(세션_아이디) 게시판 조회수  (0) 2022.03.10
php) 게시판 만들기 (글작성, 글목록, 글읽기)  (0) 2022.03.07
PHP) 페이지 클래스(Pagination)  (0) 2022.03.05
php) mysql 연동 insert, select, update, delete (CRUD)  (0) 2022.03.02
'php' Related Articles
Comment