[SOLVED] Get product id knowing its name?

[noosphere]

Hello everybody...
just facing a new challenge...I can't solve
I'd like to get the ID of a product (CG Products module) but I know only the name.

Do you know how to do it ?
Thank you in advance !

Have a nice day

[Dr.CSS]

Isn't it the first thing on the left next to the products name..?

[noosphere]

Isn't it the first thing on the left next to the products name..?

In the admin yes....it's that easy !

I meant in my template ?

[Dr.CSS]

{entry->id} ..?

[noosphere]

I'd like to get the ID of a product (CG Products module) knowing only the name.

Do you know how to do it ?
Thank you in advance !

Have a nice day

[Wishbone]

OK.. I'll bite.

Create a UDT called "get_product_id" containing:

Code: Select all

$name = $params['name'];
$assign = $params['assign'];
$product_id = '';

$db = cmsms()->GetDb();
$query = 'SELECT id FROM '.cms_db_prefix().'module_products WHERE product_name= ?';
$row = $db->GetRow($query,array($name));

if(!is_array($product)) {
  $product_id = $row['id'];
}

$smarty->assign($assign, $product_id);

Usage:

Code: Select all

{get_product_id name='Mr. Potato Head' assign='product_id'}

The ID is: {$product_id}

[noosphere]

Oh Wishbone !
That's it , thank you so much

And it's simple indeed...I really have to go deeper into UDT and db queries !!!

SOLVED

[Wishbone]

Small typo. Change to:

if(is_array($row)) {
$product_id = $row['id'];
}

Note that I removed the ! from isarray

[noosphere]

yes !
the procedure was correct...now the code is correct and working
thank you !!!