?> </td> </tr> <tr> <td>Category</td> <td>:</td> <td><?php echo $row["Name"]; ?> </td> </tr> <tr> <td>Price</td> <td>:</td> <td><?php echo 'Rp. ' . $row["Price"] . " or \$" . $rate->exchange_rate_convert("IDR", "USD", $row["Price"]); ?> </td> </tr> <tr> <?php $cat = $row['CategoryID']; if ($cat < 5) { ?> <td colspan="3"> <table> <?php $q = "SELECT * FROM units WHERE CategoryID=1"; $res = mysql_query($q); while ($r = mysql_fetch_array($res)) { $id = $r["Id"];
<?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>";
<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; for ($i = 0; $i < count($item); $i++) { $productID = $_SESSION['cartSystem']['item'][$i]; $unitID = $_SESSION['cartSystem']['unit'][$i]; $queryForProduct = "SELECT p.ProductName, c.Name, u.Unit, 3, pp.Price FROM products p JOIN design d ON p.DesignID = d.Id JOIN categories c ON p.CategoryID = c.Id JOIN stock s ON s.ProductID = p.Id JOIN units u ON s.UnitID = u.Id JOIN productsprice pp ON p.Id = pp.ProductID WHERE p.Id = {$productID} AND u.Id = {$unitID} AND pp.isCurrent = 1"; $res = mysql_query($queryForProduct) or die(mysql_error()); $row = mysql_fetch_array($res); $dollar = $cur->exchange_rate_convert("IDR", "USD", $row["Price"]); $total += $row["Price"] * $_SESSION['cartSystem']['qty'][$i]; ?> <tr> <td><?php echo $row["ProductName"]; ?> </td> <td><?php echo $row["Name"]; ?> </td> <td><?php echo $row["Unit"]; ?> </td>