How to get product informations by product name

[Gramzivi]

In my Prestashop controller I have name of product, if that product exist, I need information's of that product.

 

How to get information's about product if you only have product name ?

[hakeryk2]

As far as I know there is no this kind of method in prestashop but You can use this function 

 public function getProductIdByProductName($search, $id_shop = 1, $id_lang = 1)
    {
        return Db::getInstance()->getValue('
        SELECT id_product
        FROM '._DB_PREFIX_.'product_lang
        WHERE name LIKE "%'.(string)$search.'%"
        AND id_shop = '.$id_shop.' AND id_lang = '.$id_lang.'
        ');
    }

and after that in the same module or so use retrieved ID in example like this 

$product = new Product($this->getProductIdByProductName('Your product name'));

Function is returning plain int with id of product that You can use to create new Product object.

 

If You want to have strict match of name delete those % % in LIKE statement and If You using multilanguage and multishop You have to pass context values to get id of shop and language.

Edited April 19, 2017 by hakeryk2 (see edit history)

[ventura]

Better check your controller´s logic. It´s no the better way to take product´s information, especially in a multilang environment

[hakeryk2]

Agree with ventura: it is pretty much akward question from OP but there You go.

[changa]

how to retrieve the name of all product the sql query ?

good morning  

 

 

[rrataj]

Please try this one:

SELECT name FROM ps_product_lang WHERE id_shop = 1 AND id_lang = 1;