prepare("DELETE FROM learning_programs WHERE id = ?"); $stmt->execute([$_GET['id']]); $message = "ลบโปรแกรมการเรียนรู้เรียบร้อยแล้ว"; $action = 'list'; } if ($_SERVER['REQUEST_METHOD'] == 'POST') { $title = $_POST['title']; $content = $_POST['content']; $duration = $_POST['duration']; $document_url = $_POST['document_url']; $video_url = $_POST['video_url']; if (isset($_POST['id']) && !empty($_POST['id'])) { $stmt = $pdo->prepare("UPDATE learning_programs SET title=?, content=?, duration=?, document_url=?, video_url=? WHERE id=?"); $stmt->execute([$title, $content, $duration, $document_url, $video_url, $_POST['id']]); $message = "แก้ไขโปรแกรมการเรียนรู้เรียบร้อยแล้ว"; } else { $stmt = $pdo->prepare("INSERT INTO learning_programs (title, content, duration, document_url, video_url) VALUES (?, ?, ?, ?, ?)"); $stmt->execute([$title, $content, $duration, $document_url, $video_url]); $message = "เพิ่มโปรแกรมการเรียนรู้เรียบร้อยแล้ว"; } $action = 'list'; } $items = $pdo->query("SELECT * FROM learning_programs ORDER BY id DESC")->fetchAll(); $editData = null; if ($action == 'edit' && isset($_GET['id'])) { $stmt = $pdo->prepare("SELECT * FROM learning_programs WHERE id = ?"); $stmt->execute([$_GET['id']]); $editData = $stmt->fetch(); } ?>