Question

在将产品列入电子店时,我们常常需要将一些产品(与工厂有关的产品)与其他产品联系起来,而且连接必须同时进行,即如果我把产品1与产品2联系起来,那么产品2也必须与产品1挂钩。

采用额外的表格关系(prodid, 相关_prodid)或将相关产品清单列入产品表中每一产品行经限定的插图,是哪些最佳做法?

In either case, we would also need a recursive method to loop through a given array of products and insert/update the tables with the relations, could someone help me out with the algorithm? I will do the PHP coding but I cant think of a good way to do it.

Answer 1

You d better use an intermediate table related_to(id, product1, product2)

然后,你使用该守则:

function findRelatedProducts($product) {
  $relatedProducts = array();
  $data = mysql_query("SELECT * FROM related_to WHERE product1= $product  OR product2= $product ");
  while ($relation = mysql_fetch_array($data)) {
    $relatedProducts[] = $relation[ product1 ] == $product ? $relation[ product2 ] : $relation[ product1 ];
  }
  return $relatedProducts;
}

当然,你需要在本表格中填写,但由于我没有多少关于你的神话结构的信息,请你在<<。

Answer 2

Definitely use the extra table (the string solution is really a bad idea), preferably organizing it so that the product with the lowest primary key is put first in the relation (allows for a bit of optimization); there is no need to duplicate the relationships (i.e. having and at the same time). As for the recursive method thing, it s not clear where you get the relations value from.

友情链接