Free Public Downloads via function getProductDownloads?

Code: Select all

	public function getProductDownloads($product_id) {
		$product_download_data = array();
		
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_to_download WHERE product_id = '" . (int)$product_id . "'");
		
		foreach ($query->rows as $result) {
			$product_download_data[] = $result['download_id'];
		}
		
		return $product_download_data;
	}

Code: Select all

<?php
mysql_connect("hostname", "user", "pass") or die(mysql_error());
mysql_select_db("opencartdb") or die(mysql_error());
      
$result = mysql_query("SELECT * FROM " . DB_PREFIX . "product_to_download WHERE product_id = '" . (int)$product_id . "'");
      
$row = mysql_fetch_array( $result );

$result2 = mysql_query("SELECT * FROM " . DB_PREFIX . "download WHERE download_id = '" . (int)$row['download_id'] . "'");

$row2 = mysql_fetch_array( $result2 );

$result3 = mysql_query("SELECT * FROM " . DB_PREFIX . "download_description WHERE download_id = '" . (int)$row['download_id'] . "'");

$row3 = mysql_fetch_array( $result3 );

echo "<a href='http://www.domain.com/products/download/";
echo "".$row2['filename']."' target='_blank'>".$row3['name']."</a>";

?>