query("SELECT * FROM categories ORDER BY name ASC");
// ฟังก์ชันสร้าง slug ไม่ซ้ำ
function generateSlug($title, $conn){
$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=?");
$stmt->bind_param("s", $slug);
$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'];
$author_id = $_SESSION['user_id'];
$slug = generateSlug($title, $conn);
$stmt = $conn->prepare("INSERT INTO articles (title, slug, content, category_id, author_id, status, created_at)
VALUES (?, ?, ?, ?, ?, ?, NOW())");
$stmt->bind_param("sssiss", $title, $slug, $content, $category_id, $author_id, $status);
if($stmt->execute()){
header("Location: manage_articles.php");
exit();
} else {
$error = "ไม่สามารถเพิ่มข่าวได้: ".$stmt->error;
}
$stmt->close();
}
?>
เพิ่มข่าวใหม่
"; ?>