$query = "SELECT p.Id, p.ProductName, p.ProductImage, c.Name, pp.Price, p.CategoryID FROM design d JOIN products p ON d.Id = p.DesignID JOIN categories c ON p.CategoryID = c.Id, productsprice pp WHERE pp.ProductID = p.Id AND pp.isCurrent = 1 AND p.isDeleted = 0 AND (p.ProductName LIKE '%{$cari}%' OR p.Description LIKE '%{$cari}%' OR d.ProductName LIKE '%{$cari}%')";
}
} else {
$query = "SELECT p.Id, p.ProductName, p.ProductImage, c.Name, pp.Price, p.CategoryID FROM design d JOIN products p ON d.Id = p.DesignID JOIN categories c ON p.CategoryID = c.Id, productsprice pp WHERE pp.ProductID = p.Id AND pp.isCurrent = 1 AND p.isDeleted = 0 AND (p.ProductName LIKE '%{$cari}%' OR p.Description LIKE '%{$cari}%' OR d.ProductName LIKE '%{$cari}%')";
}
} else {
if (isset($_GET['category'])) {
if ($c != 0) {
$query = "SELECT p.Id, p.ProductName, p.ProductImage, c.Name, pp.Price, p.CategoryID FROM design d JOIN products p ON d.Id = p.DesignID JOIN categories c ON p.CategoryID = c.Id, productsprice pp WHERE pp.ProductID = p.Id AND pp.isCurrent = 1 AND p.isDeleted = 0 AND c.Id={$c}";
}
} else {
$query = "SELECT p.Id, p.ProductName, p.ProductImage, c.Name, pp.Price, p.CategoryID FROM design d JOIN products p ON d.Id = p.DesignID JOIN categories c ON p.CategoryID = c.Id, productsprice pp WHERE pp.ProductID = p.Id AND pp.isCurrent = 1 AND p.isDeleted = 0";
}
}
$result = mysql_query($query) or die(mysql_error());
$rate = new exchange_rates();
?>
<form>
<input type="text" name="search" placeholder="Search Product"/>
<select name="category">
<?php
$queryCat = "SELECT * FROM categories";
$resCat = mysql_query($queryCat);
echo '<option value="0">All Category</option>';
while ($row = mysql_fetch_array($resCat)) {
$catName = $row["Name"];
$catId = $row["Id"];
echo "<option value='{$catId}'>{$catName}</option>";
}
?>
<?php
require '../lib/Functions.php';
echo "<hr>";
$rates = new exchange_rates();
//instantiate the class
//Some Test rates
echo "1 USD equals " . $rates->exchange_rate_convert("USD", "IDR", 1) . " IDR<br>";
echo "1 IDR equals " . $rates->exchange_rate_convert("IDR", "USD", 13370.214669052) . " USD<br>";
<?php
/**
* Created by PhpStorm.
* User: root
* Date: 2/16/16
* Time: 5:39 PM
*/
include 'controller/config.php';
require 'lib/Functions.php';
$cur = new exchange_rates();
session_start();
if (isset($_SESSION['cartSystem']['item'][0])) {
$item = $_SESSION['cartSystem']['item'];
$unit = $_SESSION['cartSystem']['unit'];
$qty = $_SESSION['cartSystem']['qty'];
?>
<table>
<tr>
<td>Product Name</td>
<td>Product Category</td>
<td>Size</td>
<td>Qty</td>
<td>Price in IDR</td>
<td>Price in USD</td>
<td>Subtotal in IDR</td>
<td>Subtotal in USD</td>
<td>Action</td>
</tr>
<?php
$total = 0;
