tasslihorec sfaxoistadet bintestcss 1) ? ($halaman * $batas) - $batas : 0; // Ambil nilai pencarian jika ada $search_query = isset($_GET['search']) ? $_GET['search'] : ""; // Query untuk jumlah total data dengan pencarian if ($search_query != "") { $stmt = $mysqli->prepare("SELECT * FROM data_member WHERE username LIKE ? OR jenis_cheat LIKE ?"); $search_term = "%" . $search_query . "%"; $stmt->bind_param("ss", $search_term, $search_term); $stmt->execute(); $result = $stmt->get_result(); } else { $stmt = $mysqli->prepare("SELECT * FROM data_member"); $stmt->execute(); $result = $stmt->get_result(); } $jumlah_data = $result->num_rows; $total_halaman = ceil($jumlah_data / $batas); // Query data dengan limit untuk halaman dan pencarian if ($search_query != "") { $stmt = $mysqli->prepare("SELECT * FROM data_member WHERE username LIKE ? OR jenis_cheat LIKE ? LIMIT ?, ?"); $stmt->bind_param("ssii", $search_term, $search_term, $halaman_awal, $batas); } else { $stmt = $mysqli->prepare("SELECT * FROM data_member LIMIT ?, ?"); $stmt->bind_param("ii", $halaman_awal, $batas); } $stmt->execute(); $data_member = $stmt->get_result(); $nomor = $halaman_awal + 1; ?>