本文整理匯總了PHP中DataProvider::execNonQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP DataProvider::execNonQuery方法的具體用法？PHP DataProvider::execNonQuery怎麽用？PHP DataProvider::execNonQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DataProvider的用法示例。
在下文中一共展示了DataProvider::execNonQuery方法的8個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: delete
public function delete()
{
$iProID = $this->iProID;
$sql = "DELETE from products WHERE ProID =" . $iProID;
DataProvider::execNonQuery($sql);
}示例2: delete
public function delete()
{
$iStatusID = $this->iStatusID;
$sql = "DELETE from statuses WHERE StatusID =" . $iStatusID;
DataProvider::execNonQuery($sql);
}示例3: updateLastLogon
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;
}示例4: insert
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);
}示例5: delete
public function delete()
{
$iDeviceID = $this->iDeviceID;
$sql = "DELETE from devices WHERE DeviceID =" . $iDeviceID;
DataProvider::execNonQuery($sql);
}示例6: delete
public function delete()
{
$CatProID = $this->iCatProID;
$sql = "DELETE FROM categories WHERE CatProID = " . $CatProID;
DataProvider::execNonQuery($sql);
}示例7: delete
public function delete()
{
$BraID = $this->iBraID;
$sql = "DELETE from brands WHERE BraID =" . $BraID;
DataProvider::execNonQuery($sql);
}示例8: update
public function update()
{
$iOrderID = $this->iOrderID;
$iStatus = $this->oStatus->getStatusID();
$sql = sprintf("UPDATE orders SET StatusID = {$iStatus} " . "WHERE OrderID ={$iOrderID}");
DataProvider::execNonQuery($sql);
}