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