Banner description integration

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "banner_image bi LEFT JOIN " . DB_PREFIX . "banner_image_description bid ON (bi.banner_image_id  = bid.banner_image_id) WHERE bi.banner_id = '" . (int)$banner_id . "' AND bid.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY bi.sort_order ASC");

Code: Select all

Array ( [0] => Array ( [banner_image_id] => 299 [banner_id] => 14 [link] => https://www.kidsspeelgoed.nl/specials [image] => catalog/image.png [sort_order] => 1 [language_id] => 4 [title] => banner-1 [description] => <h2>Title</h2> <p>text</P> ) )

Code: Select all

	foreach ($results as $result) {
		if (is_file(DIR_IMAGE . $result['image'])) {
			$data['banners'][] = array(
				'title' => $result['title'],
				'link'  => $result['link'],
				'image' => $this->model_tool_image->resize($result['image'], $setting['width'], $setting['height']),
				'description' => $result['description'],
			);
		}
		}

Code: Select all

<?php echo $banner['description']; ?>

Code: Select all

 Array ( [description] => [title] => hallo [link] => http://demo.nl/index.php?route=product/search&search [image] => https://www.demo.nl/image/cache/catalog/image/banner-900x300.jpg )