/** * @param Product $product */ private function saveCategories($product) { if ($product->isCategoriesModified()) { $this->getDb()->query("DELETE FROM product_to_category WHERE product_id = :productId", [':productId' => $product->getId()]); foreach ($product->getCategories() as $category) { $this->getDb()->query("\n INSERT INTO product_to_category\n SET\n product_id = :productId,\n category_id = :categoryId,\n main_category = :isMainCategory\n\n ", [':productId' => $product->getId(), ':categoryId' => $category->getCategory()->getId(), ':isMainCategory' => $category->isMain()]); } } }