function getItemByKeyword($keyword, $lang) { $articleDB = new ArticleDB(); $variantDB = new VariantDB(); $res = $articleDB->getArticleByKeyword($keyword, $lang); $items = array(); while ($itemRes = $res->fetch_object()) { $itemName = $itemRes->ArticleName; if ($itemRes->TranslatedName != null) { $itemName = $itemRes->TranslatedName; } $itemDescription = $itemRes->ArticleDescription; if ($itemRes->TranslatedName != null) { $itemDescription = $itemRes->TranslatedDescription; } $itemImage = "No_image_available.png"; if ($itemRes->ArticleImage != null) { $itemImage = $itemRes->ArticleImage; } $itemImage = "./img/" . $itemImage; $varRes = $variantDB->getAllVariantsFromArticle($itemRes->Article_ID, $lang); $variants = array(); while ($variant = $varRes->fetch_object()) { $variantName = $variant->VariationName; if ($variant->TranslatedName != null) { $variantName = $variant->TranslatedName; } $variantDescription = $variant->VariationDescription; if ($variant->TranslatedName != null) { $variantDescription = $variant->TranslatedDescription; } $variants[] = new articleVariant($variant->Variation_ID, $variantName, $variant->VariationPrice); } $items[] = new article($itemRes->Article_ID, $itemName, $itemRes->ArticlePrice, $itemDescription, $itemImage, $variants); } return $items; }