本文整理汇总了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);
}