Rakesh Jesadiya

You can get the category product table name dynamically using the Magento 2 Catalog module.

catalog_category_product table used for category-product relation.

The table contains entity_id, category_id, product_id, and position fields to manage relationships with products.

You can get the product category IDs from the product object using Magento 2.

You can retrieve all the category IDs assigned for products at any place, using the below code snippet.

Using a SQL quoteInto() method, Write a Query using Magento standard way with SQL Safe quoted value.

You can avoid SQL injection attacks, no matter which database you use, is to separating the data value from the SQL statement. You can use ? to pass data in SQL query with the quoteInto() method.

Return Type: Always returns a string with SQL-safe quoted value placed into the original text.

You can use a given method in the direct SQL query for a safe quote with SQL conditions.