+994 50 299 11 09 info@smartdrip.net +994502991109

All Products

Stainless Steel Submersible Pumps Featured
Vansan

Stainless Steel Submersible Pumps

A product of superior Vansan engineering, Vansan Stainless Steel Submersible Pumps are designed to d...

DREAM2 Featured
Talgil

DREAM2

DREAM2 is a professional controller for drip irrigation systems. It automates irrigation, fertigatio...

Manuel Self-Cleaning Media Filter with Plastic Disc Filter System Featured
SANDWALL™ – Gravel (Sand Media) Filter

Manuel Self-Cleaning Media Filter with Plastic Disc Filter System

Manual Gravel Filter System with Plastic Disc Filters

SMART FILTER™ – Hydraulic Automatic Screen Filter
SMART FILTER™ – Hydraulic Automatic Screen Filter

SMART FILTER™ – Hydraulic Automatic Screen Filter

SMART FILTER™ is a hydraulic automatic self-cleaning screen filter designed for drip and sprinkler i...

Weather station
Talgil

Weather station

DAVIS Weather Station & DREAM2 Integration

VSP / VRP – Cast Iron Submersible Pumps Vansan (6”-7”-8”-10”)
Vansan

VSP / VRP – Cast Iron Submersible Pumps Vansan (6”-7”-8”-10”)

Vansan cast iron submersible pumps deliver high performance with the support of the Vansan engineeri...

Filtron 1-10
Talgil

Filtron 1-10

FILTRON 1–10 is a reliable controller for automatic backflushing of gravel, disc, or screen filters.

Sapir 2
Talgil

Sapir 2

SAPIR 2 is a compact controller for drip irrigation systems. It supports up to 32 outputs for valves...

RTU G5
Talgil

RTU G5

RTU G5 is a remote field control unit for professional irrigation systems. It allows connection of ...

$name_column = "name_$current_lang"; $description_column = "short_description_$current_lang"; // Default sütunları təyin et (əgər cari dil sütunu boşdursa) $fallback_columns = [ 'name' => ['name_az', 'name_en', 'name_ru'], 'description' => ['short_description_az', 'short_description_en', 'short_description_ru'] ]; // Ümumi məhsul sayı $total_products = 0; try { $stmt = $pdo->prepare("SELECT COUNT(*) as count FROM products WHERE is_active = 1"); $stmt->execute(); $result = $stmt->fetch(); $total_products = $result['count']; } catch(PDOException $e) { error_log("Count products error: " . $e->getMessage()); } // Ümumi səhifə sayı $total_pages = ceil($total_products / $per_page); // Məhsulları dilə görə çək $products = []; try { // COALESCE ilə dilə görə və fallback logic $query = " SELECT p.*, c.name_$current_lang as category_name, c.slug as category_slug, -- Title üçün: cari dil -> az -> en -> ru COALESCE( NULLIF(p.name_$current_lang, ''), NULLIF(p.name_az, ''), NULLIF(p.name_en, ''), NULLIF(p.name_ru, ''), 'No title' ) as display_name, -- Description üçün: cari dil -> az -> en -> ru COALESCE( NULLIF(p.short_description_$current_lang, ''), NULLIF(p.short_description_az, ''), NULLIF(p.short_description_en, ''), NULLIF(p.short_description_ru, ''), '' ) as display_description, p.featured_image, p.price, p.slug, p.is_featured FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.is_active = 1 ORDER BY p.is_featured DESC, -- Əvvəlcə is_featured = 1 olanlar p.created_at DESC LIMIT ? OFFSET ? "; $stmt = $pdo->prepare($query); $stmt->bindValue(1, $per_page, PDO::PARAM_INT); $stmt->bindValue(2, $offset, PDO::PARAM_INT); $stmt->execute(); $products = $stmt->fetchAll(); // Debug üçün (əgər lazımdırsa) if (empty($products)) { error_log("No products found for language: $current_lang"); } } catch(PDOException $e) { error_log("Products pagination error: " . $e->getMessage()); // Error log-a daha çox məlumat error_log("SQL Error: " . $e->getMessage() . " | Query: " . $query); } // SEO məlumatlarını təyin et $site_title = htmlspecialchars(getConfig('site_name') . ' - ' . ($t['all_products'] ?? 'Bütün Məhsullar')); $site_description = htmlspecialchars($t['all_products_desc'] ?? 'Smartdrip-in bütün məhsulları: suvarma sistemləri, nasoslar, filtrasiya avadanlıqları və daha çox.'); ?> SmartDrip - All Products