PHP Laravel：来自数组的条件更新查询

Question

I want to add multiple where clause and multiple field to update in a single query. The code below dosen't return error but dosen't do anything :( pls help

        $query = DB::table($table);
        foreach($where as $key => $value ){
            if($key != 0){
                $query -> where( $key , '=' , $value);
            }
        }
        foreach($field as $key => $value ){
            if($key != 0){
                $query -> update([$key => $value]);
            }
        }

        $result2 = $query->get();

Answer 1

you can not use where inside the loop. There will be only one where clause. you can use "orWhere" along with where clause. For more details please refer this

http://laravel.com/docs/5.1/queries#selects