osCommerce / oscommerce2

////

// Return all subcategory IDs

// TABLES: categories

  function tep_get_subcategories(&$subcategories_array, $parent_id = 0) {

    $OSCOM_Db = Registry::get('Db');

    $Qsub = $OSCOM_Db->prepare('select categories_id from :table_categories where parent_id = :parent_id');

    $Qsub->bindInt(':parent_id', $parent_id);

    $Qsub->execute();

    while ($Qsub->fetch()) {

      $subcategories_array[sizeof($subcategories_array)] = $Qsub->valueInt('categories_id');

      if ($Qsub->valueInt('categories_id') != $parent_id) {

        tep_get_subcategories($subcategories_array, $Qsub->valueInt('categories_id'));

      }

    }

  }

////

// Parse search string into indivual objects

////

// Recursively go through the categories and retreive all parent categories IDs

// TABLES: categories

  function tep_get_parent_categories(&$categories, $categories_id) {

    $OSCOM_Db = Registry::get('Db');

    $Qparent = $OSCOM_Db->prepare('select parent_id from :table_categories where categories_id = :categories_id');

    $Qparent->bindInt(':categories_id', $categories_id);

    $Qparent->execute();

    while ($Qparent->fetch()) {

      if ($Qparent->valueInt('parent_id') == 0) return true;

      $categories[sizeof($categories)] = $Qparent->valueInt('parent_id');

      if ($Qparent->valueInt('parent_id') != $categories_id) {

        tep_get_parent_categories($categories, $Qparent->valueInt('parent_id'));

      }

    }

  }

////

// Construct a category path to the product