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