เช็ค pagination ให้หน่อยครับ กดหน้าอื่นๆ ไม่ไป เพิ่มข้อมูล ได้ปกติ ค้นหาได้ปกติครับ

function fetchData(page) {
  const searchTerm = $('#searchTerm').val();
  const fromDate = $('#fromDate').val() || (new Date(Date.now() - 7*24*60*60*1000)).toISOString().substr(0, 10);
  const toDate = $('#toDate').val() || (new Date()).toISOString().substr(0, 10);

  $.ajax({
    method: "POST",
    url: "fetch_data.php",
    data: {
      searchTerm: searchTerm,
      fromDate: fromDate,
      toDate: toDate,
      page: page // Pass the current page number to the server
    },
    success: function(response) {
      // Existing code for updating the table data

      // Pagination
      const pages = Math.ceil(total / 10);
      let paginationHTML = '';
      for (let i = 1; i <= pages; i++) {
        if (i === page) {
          paginationHTML += `<span>${i}</span> `;
        } else {
          paginationHTML += `<a href="#" onclick="changePage(${i})">${i}</a> `;
        }
      }
      $("#pagination").html(paginationHTML);
    }
  });
}

function changePage(newPage) {
  const totalPages = Math.ceil(total / 10);
  if (newPage >= 1 && newPage <= totalPages) {
    fetchData(newPage); // Pass the new page to fetchData function
  }
}

// Fetch initial data
$(document).ready(function() {
  const initialPage = 1; // Set the initial page to 1
  fetchData(initialPage); // Fetch data for the initial page
});