getConnection(); if ($conn && !$conn->connect_error) { // Get main product details $stmt = $conn->prepare("SELECT id, name, link, image FROM products WHERE id = ?"); $stmt->bind_param('i', $productId); $stmt->execute(); $stmt->bind_result($id, $name, $link, $image); if ($stmt->fetch()) { $mainProduct = [ 'id' => $id, 'name' => $name, 'link' => $link, 'image' => $image ]; } $stmt->close(); if (!$mainProduct) { die('Product not found'); } // Extract base number from product name (e.g., "celana 18B" -> "18") // Try to match patterns like "18B", "18", "856A", etc. preg_match('/(\d+)[A-Za-z]?$/i', $mainProduct['name'], $matches); $baseNumber = isset($matches[1]) ? $matches[1] : ''; if ($baseNumber) { // Find all products with same base number // Pattern: name ends with baseNumber followed by optional letter $searchPattern = "%{$baseNumber}%"; $stmt = $conn->prepare(" SELECT id, name, link, image FROM products WHERE name LIKE ? ORDER BY name ASC "); $stmt->bind_param('s', $searchPattern); $stmt->execute(); $stmt->bind_result($id, $name, $link, $image); while ($stmt->fetch()) { // Verify this is actually a variant (ends with baseNumber + optional letter) if (preg_match('/\b' . preg_quote($baseNumber, '/') . '[A-Za-z]?\b/i', $name)) { $relatedProducts[] = [ 'id' => $id, 'name' => $name, 'link' => $link, 'image' => $image ]; } } $stmt->close(); } } } catch (Exception $e) { error_log('Error loading product details: ' . $e->getMessage()); die('Error loading product'); } ?> <?php // Extract base number for title preg_match('/(\d+)[A-Za-z]?$/i', $mainProduct['name'], $titleMatches); $titleNumber = isset($titleMatches[1]) ? $titleMatches[1] : ucfirst($mainProduct['name']); echo htmlspecialchars('Produk No - ' . $titleNumber); ?> - Detail Produk
Kembali ke Beranda

"15") preg_match('/(\d+)[A-Za-z]?$/i', $mainProduct['name'], $numberMatches); $baseNumber = isset($numberMatches[1]) ? $numberMatches[1] : ''; if ($baseNumber) { echo 'Produk No - ' . htmlspecialchars($baseNumber); } else { // Fallback to original name if no number found $displayName = ucfirst(trim($mainProduct['name'])); $lastSpacePos = strrpos($displayName, ' '); if ($lastSpacePos !== false) { $displayName = substr_replace($displayName, ' - ', $lastSpacePos, 1); } echo htmlspecialchars($displayName); } ?>

<?php echo htmlspecialchars($mainProduct['name']); ?>
0): ?>

Link Varian Produk ( Varian)

"Celana - 18B" $displayName = ucfirst(trim($variant['name'])); $lastSpacePos = strrpos($displayName, ' '); if ($lastSpacePos !== false) { $displayName = substr_replace($displayName, ' - ', $lastSpacePos, 1); } ?>

Tidak Ada Varian Lain

Produk ini tidak memiliki varian lain yang tersedia