query("SELECT * FROM articles WHERE id=$id")->fetch_assoc();
if(!$article){
die("ไม่พบข่าวนี้");
}
// ดึงหมวดข่าว
$categories = $conn->query("SELECT * FROM categories ORDER BY name ASC");
// ฟังก์ชันสร้าง slug ไม่ซ้ำ
function generateSlug($title, $conn, $id){
$slug = strtolower(preg_replace('/[^a-z0-9]+/i', '-', trim($title)));
$slug = trim($slug, '-');
$baseSlug = $slug;
$i = 1;
while(true){
$stmt = $conn->prepare("SELECT id FROM articles WHERE slug=? AND id<>?");
$stmt->bind_param("si", $slug, $id);
$stmt->execute();
$result = $stmt->get_result();
if($result->num_rows == 0) break;
$slug = $baseSlug . '-' . $i;
$i++;
}
return $slug;
}
// บันทึกข่าว
if($_SERVER['REQUEST_METHOD'] == 'POST'){
$title = $_POST['title'];
$content = $_POST['content'];
$category_id = intval($_POST['category_id']);
$status = $_POST['status'];
$slug = generateSlug($title, $conn, $id);
$stmt = $conn->prepare("UPDATE articles SET title=?, slug=?, content=?, category_id=?, status=? WHERE id=?");
$stmt->bind_param("sssisi", $title, $slug, $content, $category_id, $status, $id);
if($stmt->execute()){
header("Location: manage_articles.php?msg=updated");
exit();
} else {
$error = "บันทึกไม่สำเร็จ: ".$stmt->error;
}
$stmt->close();
}
?>
แก้ไขข่าว