Magento 1: Find All bundles that contain a simple

findAllBundlesWithSimple.php

<?php

/*
 * http://magento.stackexchange.com/questions/1354/how-to-find-all-bundle-products-that-contain-a-simple
 * 
 */

require_once '../shell/abstract.php';

class Mage_Shell_findProducts extends Mage_Shell_Abstract {

    public function run() {
        $simple_product_id = '5';
        $products = $this->findBundledProductsWithThisChildProduct($simple_product_id);
        foreach ($products as $product) {
            $product = mage::getModel('catalog/product')->load($product->getEntityId());
            echo $product->getName() . "\n";
        }
    }

    public function findBundledProductsWithThisChildProduct($id_to_find) {
        //grab all bundled products
        $bundles = array();
        $products = Mage::getModel('catalog/product')
                ->getCollection()
                ->addFieldToFilter('type_id', 'bundle');

        //loop over bundled products
        foreach ($products as $product) {

            //get child product IDs
            $children_ids_by_option = $product
                    ->getTypeInstance($product)
                    ->getChildrenIds($product->getId(), false); //second boolean "true" will return only
            //required child products instead of all          
            //flatten arrays (which are grouped by option)  
            $ids = array();
            foreach ($children_ids_by_option as $array) {
                $ids = array_merge($ids, $array);
            }

            //perform test and add to return value
            if (in_array($id_to_find, $ids)) {
                $bundles[] = $product;
            }
        }

        return $bundles;
    }

}

$shell = new Mage_Shell_findProducts();
$shell->run();
?>