php数组更新到mysql数据库表中某列？

Question

数组为$data

array(4) {
  [0] => array(1) {
    ["credits"] => int(11)
  }
  [1] => array(1) {
    ["credits"] => int(16)
  }
  [2] => array(1) {
    ["credits"] => int(14)
  }
  [3] => array(1) {
    ["credits"] => int(12)
  }

斜体文字

表中credits 表 目前值0

Id    credits
1       1
2       2
3       3
10      0
11      0
12      0
13      0

更新完成后的样子（更新指定列【credits】的区间字的值。

Id    credits
1        1
2        2
3        3
10       11
11       16
12       14
13       12

原生或thinkphp sql 写法都行

Answer 1

thinkphp5:

foreach ($data as $k => $v) {
    $info = db('credits')->where('credits = 0')->find();
    if (!empty($info)) {
        $info['credits'] = $v['credits'];
        db('credits')->update($info);
    }
}