public function delete() { $iProID = $this->iProID; $sql = "DELETE from products WHERE ProID =" . $iProID; DataProvider::execNonQuery($sql); }
public function delete() { $iStatusID = $this->iStatusID; $sql = "DELETE from statuses WHERE StatusID =" . $iStatusID; DataProvider::execNonQuery($sql); }
public function updateLastLogon() { $id = $this->userID; $str_LastLogon = date_format($this->lastLogon, 'Y-m-d H:i:s'); $sql = "update users set LastLogon = '{$str_LastLogon}' " . "where UserID = " . $id; DataProvider::execNonQuery($sql); return true; }
public function insert() { $iOrderID = $this->oOrder->getOrderID(); $iProID = $this->oProduct->getProID(); $iQuantity = $this->iQuantity; $fPrice = $this->fPrice; $fAmount = $this->fAmount; $sql = "INSERT INTO orderdetails (OrderID, ProID,Quantity ,Price , Amount) VALUES " . "('{$iOrderID}' , {$iProID}, {$iQuantity}, {$fPrice} , {$fAmount} )"; DataProvider::execNonQuery($sql); }
public function delete() { $iDeviceID = $this->iDeviceID; $sql = "DELETE from devices WHERE DeviceID =" . $iDeviceID; DataProvider::execNonQuery($sql); }
public function delete() { $CatProID = $this->iCatProID; $sql = "DELETE FROM categories WHERE CatProID = " . $CatProID; DataProvider::execNonQuery($sql); }
public function delete() { $BraID = $this->iBraID; $sql = "DELETE from brands WHERE BraID =" . $BraID; DataProvider::execNonQuery($sql); }
public function update() { $iOrderID = $this->iOrderID; $iStatus = $this->oStatus->getStatusID(); $sql = sprintf("UPDATE orders SET StatusID = {$iStatus} " . "WHERE OrderID ={$iOrderID}"); DataProvider::execNonQuery($sql); }