Passsing PHP variable values to template

Code: Select all

	 if ($rspurchchk->num_rows > 0) {
		 $this->data['Purchased'] = True;
	}
	else {
		$this->data['Purchased'] = False;
	}

Code: Select all

 if ($rspurchchk->num_rows > 0) {
		 $data['Purchased'] = True;
	}
	else {
		$data['Purchased'] = False;
	}

Code: Select all

              {% if not Purchased %}
              <button type="button" id="button-cart" data-loading-text="{{ text_loading }}" class="btn btn-primary btn-lg btn-block">{{ button_cart }}</button>
            {% endif %}

Code: Select all

//Recordset and variable setting for customer ID from session variable 

// Create connection
$mysqli = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($mysqli->connect_error) {
	die("Connection failed: " . $mysqli->connect_error);
}
//Set session variable 
$session_idParm = "0";
if (isset($_COOKIE['OCSESSID'])) {
	$session_idParm = $_COOKIE['OCSESSID'];
}

if ($rssessionchk = $mysqli->prepare("SELECT * FROM oc_session WHERE oc_session.session_id=?")) {
 
	// Bind variable to the parameter as a string. 
	$rssessionchk->bind_param("s", $session_idParm);
 
	// Execute the statement.
	$rssessionchk->execute();
	$rssessionchk->store_result();
	// Get the variables from the query.
	$rssessionchk->bind_result($session_idrslt,$datarslt,$expirerslt);
	// Fetch the data.
	$rssessionchk->fetch();
	 if ($rssessionchk->num_rows > 0) {
		//Set the data.
		$str1 = str_replace('"', "", $datarslt);
		$str2 = strstr($str1, 'customer_id:');
		$str3 = str_replace('customer_id:', "", $str2);
		$customerID = substr($str3,0,1);
		//echo "customerID=". $customerID. "<br>";
	}
	else {
		//echo "No customer ID";
	}
	// Close the prepared statement.
	$rssessionchk->close();
}
//Recordset and variable setting for purchase determination 
$product_idParm = "0";
if (isset($_GET['product_id'])) {
	 if ( is_numeric($product_idParm) == true){
		$product_idParm = $_GET['product_id'];
		//echo "productID Parm=". $product_idParm. "<br>";
	 }
}
// Create connection
$mysqli = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($mysqli->connect_error) {
	die("Connection failed: " . $mysqli->connect_error);
}
if ($rspurchchk = $mysqli->prepare("SELECT oc_order.order_id, oc_order_product.product_id FROM oc_order, oc_order_product WHERE oc_order.order_id = oc_order_product.order_id AND oc_order.customer_id = ? AND oc_order_product.product_id = ?")) {
 
	// Bind variable to the parameter as a string. 
	$rspurchchk->bind_param("ss", $customerID,$product_idParm);
 
	// Execute the statement.
	$rspurchchk->execute();
	$rspurchchk->store_result();
	// Get the variables from the query.
	$rspurchchk->bind_result($order_idrslt,$product_idrslt);
	// Fetch the data.
	$rspurchchk->fetch();
	 if ($rspurchchk->num_rows > 0) {
		 $data['Purchased'] = True;
		//echo $Purchased;
	}
	else {
		$data['Purchased'] = False;
	}
	// Close the prepared statement.
	$rspurchchk->close();
}

Code: Select all

public function hasProducts() {

Code: Select all

public function hasProduct($product_id) {
		$product_data = array();
		
		$products = $this->getProducts();

		foreach ($products as $product) {
			$product_data[] = (int)$product['product_id'];
		}
		
		return (in_array((int)$product_id, $product_data));
	}

Code: Select all

$this->model_catalog_product->updateViewed($this->request->get['product_id']);

Code: Select all

$data['product_in_cart'] = $this->cart->hasProduct($this->request->get['product_id']);

Code: Select all

{% if product_in_cart %}
    ...
{% else %}
    ...
{% endif %}

Code: Select all

$this->response->setOutput($this->load->view('product/product', $data));