Delete unwanted files from magento folder

Question

I’ve installed magento edition version 1.9.2.0 and added a custom attribute pdf(text field) and adding pdf names for each product using this attribute and manually adding pdf file in the media/PDF folder.Now i want to delete the unwanted pdf files(not in database) .please suggest any option for this.

Answer 1

We assume that your attribute (PDF) default value is 0 or 'null'.Now you have to get those products which have values in the database. You need to get them from product collection on the basis of attribute filter after you can delete files other than the resultset values.

 $collection = Mage::getModel('catalog/product')->getCollection();

//filter product by attribute value 
$collection->addAttributeToFilter(
  array(
   array('attribute'=> 'pdf','neq' => '0'),
   array('attribute'=> 'pdf','neq' => '')
);