How to foreach items for database on 1.5

[Esnyper]

Hi, I'am going to update testimonials module for prestashop 1.5, but I can't understand how to use Prestashop functions. I even can't find any documentation about working with database.

 

I have function:

public function viewTestimonials ()
{
	//Sukuriame masyvą kuriame laikysime atsiliepimus
	$output = array();
	$db = Db::getInstance();
	$vnt = $db->Execute('SELECT COUNT(*) FROM `'._DB_PREFIX_.'testimonials`');
	$result = $db->Execute('SELECT * FROM `'._DB_PREFIX_.'testimonials` ORDER BY testimonial_id DESC');
	while ($row = mysqli_fetch_assoc($vnt))
	{
		$results[] = $row;
	}

	global $smarty;
		$smarty->assign(array('testimonials' => $results));
		return $this->display(__FILE__, 'rodyti_atsiliepimus.tpl');
}

 

With this code I have this error:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given

 

Can anyone help my with this? Thank you!

Edited November 2, 2012 by Esnyper (see edit history)

[Alex Simonchik BelVG]

Hi,

 

you need use ExecuteS instead of Execute in your example.

Great guide is there http://doc.prestashop.com/display/PS15/DB+class+best+practices and http://www.prestashop.com/blog/en/good_practices_on_class_db_for_prestashop_141/

 

Regards

[Esnyper]

Thanks!

Edited November 2, 2012 by Esnyper (see edit history)