query("SELECT * FROM news WHERE id = $id"); $news = $result->fetch_assoc(); } if(isset($_POST['update_news'])){ $id = $_POST['news_id']; $title = mysqli_real_escape_string($conn, $_POST['title']); $detail = mysqli_real_escape_string($conn, $_POST['detail']); // จัดการเรื่องรูปภาพ (ถ้ามีการเลือกรูปใหม่) if($_FILES['image']['name'] != ""){ $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION); $new_name = "news_" . time() . "." . $ext; move_uploaded_file($_FILES['image']['tmp_name'], "uploads/" . $new_name); $sql = "UPDATE news SET title='$title', detail='$detail', image='$new_name' WHERE id=$id"; } else { $sql = "UPDATE news SET title='$title', detail='$detail' WHERE id=$id"; } if($conn->query($sql)){ echo ""; } } ?>

✏️ แก้ไขข่าวสาร