Example #1
0
        print "<br><br>**************  Input wrong product code **************<br><br><br>";
    } else {
        if (isOwner($productCode, $username, $password) == 0) {
            print "<br><br>**************  This isn't your product code **************<br><br><br>";
        } else {
            //database connection
            $conn = mysql_connect("localhost", "root", "root") or die("****** can't connect to sever ******");
            mysql_select_db("easystock", $conn) or die("****** can't select database ******");
            //load product form database
            $rs = $easystockDB->fncSelectRecord("product", "code LIKE '{$productCode}%'");
            //Set value to class then use function sell() to calculate
            $productSell = new Product();
            $productSell->setAmount($rs[amount]);
            $productSell->setCost($rs[cost]);
            $productSell->setPrice($rs[price]);
            $productSell->setSale($rs[sale]);
            $productSell->sell($amount);
            $amountSell = $productSell->getAmount();
            $saleSell = $productSell->getSale();
            //update detail to database
            $easystockDB->fncUpdateRecord("product", "amount='{$amountSell}'", "code='{$productCode}'");
            $easystockDB->fncUpdateRecord("product", "sale='{$saleSell}'", "code='{$productCode}'");
            mysql_close($conn);
        }
    }
}
/*** Home ***/
//database connection
$conn = mysql_connect("localhost", "root", "root");
mysql_select_db("easystock", $conn);
//scan user by username and password