prepare("SELECT * FROM teledramas WHERE id = :id LIMIT 1");
$stmt->execute([':id' => $id]);
$teledrama = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$teledrama) {
die("Teledrama not found.");
}
} catch (Exception $e) {
die("Database error: " . htmlspecialchars($e->getMessage()));
}
// ---------------------------
// Handle Update
// ---------------------------
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$title = filter_input(INPUT_POST, 'title', FILTER_SANITIZE_STRING);
$description = filter_input(INPUT_POST, 'description', FILTER_SANITIZE_STRING);
$youtube_playlist = filter_input(INPUT_POST, 'youtube_playlist', FILTER_SANITIZE_STRING);
$cover_image = $teledrama['cover_image']; // Keep old image by default
$target_dir = $_SERVER['DOCUMENT_ROOT'] . '/uploads/teledramas/';
if (isset($_FILES['cover_image']) && $_FILES['cover_image']['error'] === UPLOAD_ERR_OK) {
$new_file = basename($_FILES['cover_image']['name']);
$target_file = $target_dir . $new_file;
$imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
$check = getimagesize($_FILES['cover_image']['tmp_name']);
if ($check === false || !in_array($imageFileType, ['jpg', 'jpeg', 'png', 'gif', 'svg'])) {
$edit_message = "Invalid image file. Please upload JPG, PNG, or GIF.";
} elseif (!move_uploaded_file($_FILES['cover_image']['tmp_name'], $target_file)) {
$edit_message = "Error uploading new image.";
} else {
// Delete old file
if ($cover_image && file_exists($target_dir . $cover_image)) {
unlink($target_dir . $cover_image);
}
$cover_image = $new_file;
}
}
if (!$edit_message) {
try {
$stmt = $conn->prepare("UPDATE teledramas
SET title = :title, description = :description, youtube_playlist = :youtube_playlist, cover_image = :cover_image
WHERE id = :id");
$stmt->execute([
':title' => $title,
':description' => $description,
':youtube_playlist' => $youtube_playlist,
':cover_image' => $cover_image,
':id' => $id
]);
$edit_message = "Teledrama updated successfully!";
// Refresh data
$teledrama['title'] = $title;
$teledrama['description'] = $description;
$teledrama['youtube_playlist'] = $youtube_playlist;
$teledrama['cover_image'] = $cover_image;
} catch (Exception $e) {
$edit_message = "Error updating teledrama: " . htmlspecialchars($e->getMessage());
}
}
}
?>
<?php echo $page_title; ?>
Edit Teledrama