Пример #1
0
 public static function getSKUsForProduct($id)
 {
     $sql = "SELECT s.child_id FROM `catalog_product_relation` as s\nWHERE s.parent_id = {$id}";
     $con = mysql_connect(StoreConfigManager::getDbHost(), StoreConfigManager::getDbUser(), StoreConfigManager::getDbPass()) or die("Could not connect: " . mysql_error());
     mysql_select_db(strtolower(StoreConfigManager::getDbName()));
     $result = mysql_query($sql);
     $skuList = array();
     while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
         $skuList[] = $row['child_id'];
     }
     mysql_free_result($result);
     return $skuList;
 }