php 批量更新数据 单字段 和多字段更新 拼接

批量更新sql格式   单字段   

update exp2_profit_pool01 SET runoutNoSettleScore = CASE poolid when "28" then runoutNoSettleScore +694 when "12" then runoutNoSettleScore +200 when "13" then runoutNoSettleScore +100 when "8" then runoutNoSettleScore +6 end where poolid in (28,12,13,8)

 $ids  = "'".str_replace(",","','",implode(',',$channelTypeArr))."'";

            $sql = "UPDATE bp_paychannel_fee SET inUserStatus = CASE channel ";
            foreach ($channelTypeArr as $k => $v)
            {
                $sql .= sprintf("WHEN '%s' THEN '%s' ", $v, '10'); // 拼接SQL语句
            }

            $sql .= "END WHERE channel IN ($ids) and b01id=".$data['seller']['b01id'];

批量更新sql格式  多字段   

           foreach ($outdata  as $k => $v)
            {
                    $updB01idFlag = true;
                    $outdata[$k]['b01id'] = $poolbusiness01Arr[$k]['b01id'];
                    $outdata[$k]['bCode'] = $poolbusiness01Arr[$k]['bCode'];
                    $updB01idStr .= $k.',';
                    $updatebShortName .='when "'.$k.'" then "'.$v[3].'" ';
                    $updatebName .='when "'.$k.'" then "'.$v[2].'" ';
                    $updatebFrom .='when "'.$k.'" then "'.$v[4].'" ';
                    $updatebType .='when "'.$k.'" then "'.$v[5].'" ';
                    $updatecity .='when "'.$k.'" then "'.$v[11].'" ';
                    $updatebankCode .='when "'.$k.'" then "'.$v[12].'" ';
                    $updatebankName .='when "'.$k.'" then "'.$v[13].'" ';
                    $updatebankAccount .='when "'.$k.'" then "'. $tool->encryptToken(trim($v[14])).'" ';
            }


            //更新商户池数据
            if($updB01idFlag)
            {
                if(false === $mysql->execute('update bp_pool_business01 SET bShortName = CASE outB01id '.$updatebShortName.'END,bName = CASE outB01id '.$updatebName.'END,bFrom = CASE outB01id '.$updatebFrom.' END ,bType = CASE outB01id '.$updatebType.' END,city = CASE outB01id '.$updatecity.' END ,bankCode = CASE outB01id '.$updatebankCode.' END,bankName = CASE outB01id '.$updatebankName.' END ,bankAccount = CASE outB01id '.$updatebankAccount.' END where outB01id in ('.rtrim($updB01idStr,',').')')){
                    tryException('导入失败,错误代码：-2');
                }
            }