web/topics-upd.php at main · otake1006/web · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
session_start();
echo "こんにちは、" .$_SESSION['session_name']. "さん<br>";

// Initialize variables
$post = $_SERVER["REQUEST_METHOD"];
$msg = "";
$number = $title = $kinds = $subject = "";

// Request handling
if ($post == "POST") {
    $number = $_POST['number'] ?? '';
    $title = $_POST['title'] ?? '';
    $kinds = $_POST['kinds'] ?? '';
    $subject = $_POST['subject'] ?? '';
} else {
    $number = $_GET['number'] ?? '';
    $title = $_GET['title'] ?? '';
    $kinds = $_GET['kinds'] ?? '';
    $subject = $_GET['subject'] ?? '';
}

// Validation
if (isset($_POST["ent_btn"])) {
    if (!$title) {
        $msg = "<font color='red'>タイトルが入力されていませgyん</font>";
    } elseif (!$kinds) {
        $msg = "<font color='red'>種類が選択されていません</font>";
    } elseif (!$subject) {
        $msg = "<font color='red'>対象が選択されていません</font>";
    }
}
?>
<!DOCTYPE html>
<html lang="ja">
<head>
    <meta charset="utf-8" />
    <title>トピックス更新</title>
</head>
<body>
えいとびっと
<form action="topics-upd.php" method="post">
    <label>登録番号:</label>
    <input type="text" name="number" value="<?php echo $number; ?>" readonly><br>

    <label>タイトル:</label>
    <input type="text" name="title" value="<?php echo $title; ?>"><br>

    <label>種類:</label>
    <input type="radio" name="kinds" value="お知らせ" <?php echo $kinds === "お知らせ" ? "checked" : ""; ?>> お知らせ
    <input type="radio" name="kinds" value="ニュース" <?php echo $kinds === "ニュース" ? "checked" : ""; ?>> ニュース<br>

    <label>対象:</label>
    <input type="radio" name="subject" value="学生" <?php echo $subject === "学生" ? "checked" : ""; ?>> 学生
    <input type="radio" name="subject" value="教員" <?php echo $subject === "教員" ? "checked" : ""; ?>> 教員<br><br>

    <input type="submit" value="更新" name="ent_btn">
    <?php
    if ($msg) {
        echo $msg;
    }
    ?>
</form>
<br>
<a href="top.php" style="display: inline-block; padding: 10px 20px; background-color: #007BFF; color: white; text-decoration: none; border-radius: 5px;">TOPに戻る</a>

<?php
// If validation error exists, skip the update process
if ($msg) {
    exit;
}

// If POST method and form submitted
if ($post == "POST" && isset($_POST["ent_btn"])) {
    // SQL Query
    $sql = 'UPDATE topics SET title = :title, kinds = :kinds, subject = :subject WHERE number = :number';

    // Database connection
    $dsn = 'mysql:host=localhost;dbname=system2024;charset=utf8';
    $user = "user01";
    $pass = "user01";

    try {
        $pdo = new PDO($dsn, $user, $pass);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        // Execute SQL
        $stmt = $pdo->prepare($sql);
        $stmt->bindValue(':title', $title, PDO::PARAM_STR);
        $stmt->bindValue(':kinds', $kinds, PDO::PARAM_STR);
        $stmt->bindValue(':subject', $subject, PDO::PARAM_STR);
        $stmt->bindValue(':number', $number, PDO::PARAM_STR);
        $stmt->execute();

        echo "更新しました";
    } catch (PDOException $e) {
        echo "接続失敗: " . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8');
    } finally {
        // Close the connection
        $pdo = null;
    }
}
?>
<div style="display: flex; justify-content: space-between; align-items: center;">
	<div>

	<script>
	function confirm_test() {
		var select = confirm("ログアウトしますか？\n「OK」でログアウト\n");
		return select;
	}
	</script>
		<form action="logout.php" method="post" onsubmit="return confirm_test()">
			<input type="submit" value="ログアウト">
		</form>
	</div>
</div>
</body>
</html>