Jump to content

how to get only the value of an array PHP prestashop 1.7


xbKappa
 Share

Recommended Posts

I have this code for counting product attributes 

$getProductAttributes = Db::getInstance()->executeS('SELECT COUNT(id_product_attribute) FROM '._DB_PREFIX_.'product_attribute WHERE id_product = '.$id_product.'');

print_r($getProductAttributes);

 

and is printing this  Array ( [0] => Array ( [COUNT(id_product_attribute)] => 90 ) )

how can i get only the value 90?

 

Share this post


Link to post
Share on other sites

It should be like this,
 

$getProductAttributes = Db::getInstance()->executeS('SELECT COUNT(id_product_attribute) FROM `'._DB_PREFIX_.'product_attribute` WHERE id_product='.(int)$id_product);
print_r($getProductAttributes, true);

then get the value from array.

Edited by Rhobur
clarity (see edit history)
  • Like 1
  • Thanks 1

Share this post


Link to post
Share on other sites

Don't use executeS but getValue

 

$getProductAttributes = Db::getInstance()->getValue ('SELECT COUNT(id_product_attribute) FROM '._DB_PREFIX_.'product_attribute WHERE id_product = '.(int)$id_product);

and then $getProductAttributes  = 90

for security, don't forget (int) before $id_product

  • Like 1
  • Thanks 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More