I am trying to get products name(value) and when i see my db table catalog_product_entity_varchar but in which in the column of value all base images are given so please tell accurate table or any method to get products name or value
Magento uses an EAV table structure for products. Names are stored in catalog_product_entity_varchar. If you have the product ID X, you can query this table directly:
SELECT entity_id, value, store_id FROM catalog_product_entity_varchar WHERE entity_id = X AND attribute_id = ( SELECT attribute_id FROM eav_attribute WHERE entity_type_id=4 AND attribute_code='name' )
The subquery determines the attribute id for "name", entity_type_id 4 is always the type ID for products.