how to get wishlist id according to the product id?

Question

I have a product id but i want to know the wishlist id according to that product id. Is there any way to find that wish list corresponding that productid?

Answer 1

Try this:

$productId =1;
$wishlistItem = Mage::getModel('wishlist/item')->getCollection()
    ->addFieldToFilter('product_id',$productId);
if(count($wishlistItem)) {
    $wishlistIds = $wishlistItem->getColumnValues('wishlist_id');
    print_r($wishlistIds);
}


//OR

if(count($wishlistItem)) {
    echo $wishlistId = $wishlistItem->getFirstItem()->getWishlistId();
}

Answer 2

Not sure to fully understand the question but there is no function to get all wishlist IDs linked to a product.
The way to do that is make a query in wishlist_item table.
For example : SELECT wishlist_id FROM wishlist_item WHERE product_id = {your_product_id}
Or if you want in a Magento way :
$adapter = $this->_getReadAdapter(); $select = $adapter->select()->from($this->getTable('wishlist/item'), array('product_id'))->where('product_id=:product_id'); $bind = array( 'product_id' => $productId ); $data = $adapter->fetchRow($select, $bind);
Edit with you example : $wishlistIds = Mage::getModel('wishlist/item')->getCollection()->addFieldToFilter('product_id',$collection1['entity_id'])->getAllIds();