本文整理汇总了PHP中DbUtils::updateQuery方法的典型用法代码示例。如果您正苦于以下问题：PHP DbUtils::updateQuery方法的具体用法？PHP DbUtils::updateQuery怎么用？PHP DbUtils::updateQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbUtils的用法示例。
在下文中一共展示了DbUtils::updateQuery方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: updateIssueQtyANDlocation
function updateIssueQtyANDlocation($item_code, $currentIssueQty, $issueLocation)
{
$sql = "Update raw_item set stock_issue_qty='{$currentIssueQty}' , issue_location='{$issueLocation}' WHERE stock_item_id='{$item_code}'";
return parent::updateQuery($sql);
}示例2: updateReqStatus
function updateReqStatus($rm_id)
{
$sql = 'UPDATE requisitions_master set status=3 WHERE rm_id=' . $rm_id;
return parent::updateQuery($sql);
}示例3: updateDepartment
function updateDepartment($depid, $depOfficeID, $department_name)
{
$sql = "UPDATE departments \n\t\t\t\tSET department_name = '{$department_name}',department_office_id='{$depOfficeID}' \n\t\t\t\tWHERE department_id='{$depid}'";
parent::updateQuery($sql);
}示例4: updateStockPartNo
function updateStockPartNo($stcItmId, $txtStkPart)
{
$sql = "UPDATE stock_part_details SET stock_part = '{$txtStkPart}' WHERE stock_part_m_id= '{$stcItmId}'";
return parent::updateQuery($sql);
}示例5: updateReqStatus
function updateReqStatus($user_level, $rm_id)
{
if ($user_level == 0) {
$sql = 'UPDATE requisitions_master set status=1 WHERE rm_id=' . $rm_id;
}
if ($user_level == 1) {
$sql = 'UPDATE requisitions_master set status=2 WHERE rm_id=' . $rm_id;
}
return parent::updateQuery($sql);
}示例6: Update
function Update()
{
$sql = "UPDATE companies SET\n\t\tcompany_name='{$this->name}',\n\t\tcompany_mailing_name='{$this->mailing_name}',\n\t\tcompany_address='{$this->address}',\n\t\tcompany_phone='{$this->phone}',\n\t\tcompany_email='{$this->email}',\n\t\tcompany_financial_year_start='{$this->financial_year_start}',\n\t\tcompany_financial_year_end ='{$this->financial_year_end}',\n\t\tupdated_at=NOW()\t\n\t\t";
parent::updateQuery($sql);
}示例7: updateSection
function updateSection($secid, $section_name, $department, $officeName)
{
$sql = "UPDATE user_section \n\t\t\t\tSET sec_name = '{$section_name}',dep_id='{$department}',office_id='{$officeName}'\n\t\t\t\tWHERE sec_id='{$secid}'";
parent::updateQuery($sql);
}示例8: updateReceivedQty
function updateReceivedQty($item_code, $current_recieved_qty)
{
$sql = "Update finish_item set \tstock_received_qty='{$current_recieved_qty}' WHERE stock_item_id='{$item_code}'";
return parent::updateQuery($sql);
}