PHP calculatePopularities Examples

Example #1

File: cart.php Project: rohitvineet/PHP-Online-Shop

for ($i = 0; $i < count($expc); $i++) {
    $subid = $expc[$i];
    $res = mysql_query("select ItemID,SubItemName,Type,Price,Quantity from subitems where SubItemID='{$subid}'");
    $row = mysql_fetch_array($res);
    $itemId = $row['ItemID'];
    $res1 = mysql_query("select count(*) as ItemCount from subitems where ItemID = {$itemId}");
    $row1 = mysql_fetch_array($res1);
    $itemCount = $row1['ItemCount'];
    $subItemName = $row['SubItemName'];
    $type = $row['Type'];
    $price = $row['Price'];
    $quantity = $row['Quantity'];
    $res = mysql_query("select ItemName from items where ItemID='{$itemId}'");
    $row = mysql_fetch_array($res);
    $itemName = $row['ItemName'];
    if ($type == "P") {
        $cartString = "i->" . $subid . "->1->" . $subItemName . "->" . $type . "->" . $quantity . "->" . $price . "->" . $itemName;
    } else {
        $cartString = "i->" . $subid . "->0->" . $subItemName . "->" . $type . "->" . $quantity . "->" . $price . "->" . $itemName;
    }
    if (isset($_SESSION['gs_cart'])) {
        $_SESSION['gs_cart'] = $_SESSION['gs_cart'] . ";" . $cartString;
    } else {
        $_SESSION['gs_cart'] = $cartString;
    }
    $popFactor = 1 + 0.01 * $itemCount;
    $res = mysql_query("update subitems set Popularity = Popularity*{$popFactor} where SubItemID='{$subid}'");
    calculatePopularities($subid);
}
//closeDB($con);
echo $_SESSION['gs_cart'];

Example #2

File: orderComplete.php Project: rohitvineet/PHP-Online-Shop

            for ($i = 0; $i < count($cartItem); $i++) {
                $temp = explode("->", $cartItem[$i]);
                $subItemID = $temp[1];
                $res1 = mysql_query("select ItemID from items where SubItemID = {$subItemID}");
                $row1 = mysql_fetch_array($res1);
                $itemID = $row1['ItemID'];
                $res1 = mysql_query("select count(*) as ItemCount from subitems where ItemID = {$itemID}");
                $row1 = mysql_fetch_array($res1);
                $itemCount = $row1['ItemCount'];
                $itemQuantity = $temp[2];
                $query = "insert into orderlist (OrderID,SubItemID,Quantity) values ('{$insertID}','{$subItemID}','{$itemQuantity}')";
                mysql_query($query);
                $popFactor = 1 + 0.1 * $itemCount;
                $query = "update subitems set Popularity = Popularity*{$popFactor} where SubItemID = {$subItemID}";
                mysql_query($query);
                calculatePopularities($subItemID);
            }
            $_SESSION['gs_cart'] = null;
            $_SESSION['placed_order_id'] = $insertID;
            header("location: myorders.php");
        } else {
            $regs = "An error has been encountered while processing your order.<br/>Sorry for your Inconvenience...";
        }
        // closeDB($con);
    } else {
        $regs = "No Items in your CART";
    }
    showMessage($regs);
} else {
    header("location: index.php");
}