Searching Products By Tag

[Amiral D.]

Hello everyone,

 

I try to dev a solution for Prestashop, but i can't figure how to search by tag with the DbQuery object.

 

I wrote this but it's false, can anyone help me ?

 

 

 

 

 

$sql = new DbQuery();

$sql->select('*');

$sql->from('products', 'c');

$sql->innerJoin('product_tag', 'l', 'c.id_product = l.id_product');

$sql->innerJoin('tag', 'm', 'l.id_tag = m.id_tag');

$sql->where('m.name = apple');

$sql->orderBy('product_tag');

$res = Db::getInstance()->executeS($sql);

print_r($res);

 

 

 

-> Error 500

 

S.O.S.

 

M.

[Alex Simonchik BelVG]

Hi,

 

for debug sql-query use:

$sql = new DbQuery();
$sql->select('*');
$sql->from('products', 'c');
$sql->innerJoin('product_tag', 'l', 'c.id_product = l.id_product');
$sql->innerJoin('tag', 'm', 'l.id_tag = m.id_tag');
$sql->where('m.name = apple');
$sql->orderBy('product_tag');
print_r((string)$sql); die;
//or $sql->build()
$res = Db::getInstance()->executeS($sql);
print_r($res);

 

Regards

[Amiral D.]

Thanks for your response, i've solved a part of it, just check what i've done :

 

$sql = new DbQuery();
 $sql->select('*');
 $sql->from('product', 'p');
 $sql->innerJoin('product_tag', 'l', 'p.id_product = l.id_product');
 $sql->innerJoin('tag', 't', 'l.id_tag = t.id_tag');
 $sql->where('t.name = "apple"');
 $sql->orderBy('t.name');
 $res = Db::getInstance()->executeS($sql);