connect_error) { die("Connection error: " . $conn->connect_error); } // Set charset $conn->set_charset('utf8'); // ============================================= // PAGINATION AND SEARCH CONFIGURATION // ============================================= $records_per_page = 15; $current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $offset = ($current_page - 1) * $records_per_page; // Get search parameter $search = isset($_GET['search']) ? trim($_GET['search']) : ''; // Build search query $where = ''; if (!empty($search)) { $clean_search = $conn->real_escape_string($search); $where = "WHERE c.full_name LIKE '%$clean_search%' OR c.symbol LIKE '%$clean_search%'"; } // Get total records (with filter if applicable) $total_query = "SELECT COUNT(*) as total FROM dbt_cryptocoin c $where"; $total_result = $conn->query($total_query); $total_records = $total_result->fetch_assoc()['total']; $total_pages = ceil($total_records / $records_per_page); // Main query with pagination and filter $query = "SELECT c.id, c.symbol, c.full_name, c.image, (SELECT b.bid_price FROM dbt_biding b WHERE b.currency_symbol = c.symbol ORDER BY b.id DESC LIMIT 1) as bid_price FROM dbt_cryptocoin c $where ORDER BY c.symbol ASC LIMIT $offset, $records_per_page"; $result = $conn->query($query); // ============================================= // IMAGE CONFIGURATION // ============================================= $base_image_url = 'https://iraic.trade/public/upload/coinlist/'; $allowed_extensions = ['jpg', 'jpeg', 'png', 'gif', 'webp', 'svg']; // Function to verify and build image URL function getImageUrl($image_field, $base_url) { if (empty($image_field)) return null; // If it's already a complete URL if (filter_var($image_field, FILTER_VALIDATE_URL)) { return $image_field; } // If it's a relative path or filename return $base_url . ltrim($image_field, '/'); } ?> close(); ?>