数据库未更新 [英] database not updated

问题描述

我有两个名为'Allrawmaterials'和'Formulation'的表，在'Allrawmaterial'表中有字段'rawmaterial'，如果我更新字段'rawmaterial'中的特定值，它必须更新表''中的'raw'字段'配方'。

  $ objdpoddt  =配方:: LoadAll（QQ :: OrderBy（QQN :: Formulation（） - > ProductObject-> Productnm））; 
  foreach （$ objdpoddt  as  $ objdpodd）{
 
 $ objdpodd->总计= number_format（$ objformhasallrowmat-> ProductionCost，2，' 。'，< span class =code-string>' '）; 
 $ objdpodd-> BasicAmount = number_format（（$ objdpodd-> Total * $ objdpodd-> Expence）/ 100）+ $ objdpodd-> Total，2，' 。'，' ' ）; 
 $ objdpodd->保存（）; 
} 

我刷新了数据库数据库，但是所有'rawmaterial'都看到了更改数据的影响但是我必须只更新在'Allrawmaterials'中更新的特定'rawmaterial'。

解决方案

objdpoddt = Formulation :: LoadAll（QQ :: OrderBy（ QQN ::制剂（） - > ProductObject-> Productnm））;
foreach （

objdpoddt as

objdpodd）{

I have two tables named 'Allrawmaterials' and 'Formulation',in 'Allrawmaterial' table there is field 'rawmaterial',if I update perticular value in field 'rawmaterial', it has to update filed 'raw' in table 'Formulation'.

  $objdpoddt = Formulation::LoadAll(QQ::OrderBy(QQN::Formulation()->ProductObject->Productnm));
foreach ($objdpoddt as $objdpodd){
                    
$objdpodd->Total= number_format($objformhasallrowmat->ProductionCost, 2, '.', '');
$objdpodd->BasicAmount= number_format((($objdpodd->Total*$objdpodd->Expence)/100)+$objdpodd->Total, 2, '.','');
$objdpodd->Save();
}

I had refreshed the database database,but the effect of changed data is seeing on all the 'rawmaterial' but iI have to update only perticular 'rawmaterial'which had updated in 'Allrawmaterials'.

解决方案

objdpoddt = Formulation::LoadAll(QQ::OrderBy(QQN::Formulation()->ProductObject->Productnm)); foreach (

objdpoddt as

objdpodd){

这篇关于数据库未更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！