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; }
function deleteArticle($artID) { require_once ROOT . "DBInterface/articleTranslationDB.php"; require_once ROOT . "DBInterface/categoryArticleDB.php"; require_once ROOT . "DBInterface/variantDB.php"; require_once ROOT . "DBInterface/variantTranslationDB.php"; $articleDB = new ArticleDB(); $articleTranslationDB = new ArticleTranslationDB(); $categoryArticleDB = new CategoryArticleDB(); $variantDB = new VariantDB(); $variantTranslationDB = new VariantTranslationDB(); $articleDB->deleteArticle($artID); $articleTranslationDB->deleteAllTranslationsByArticle($artID); $categoryArticleDB->deleteAllCategorysByArticle($artID); $sqlVariantRes = $variantDB->getAllVariantIDsByArticle($artID); while ($variant = $sqlVariantRes->fetch_object()) { $variantTranslationDB->deleteAllVariantsByArticle($variant->Variation_ID); } $variantDB->deleteAllVariantsByArticle($artID); }