$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;