首页 > 解决方案 > 在控制器中使用 foreach 时出现语法错误

问题描述

这是我的控制器,在控制器中使用 foreach 时出现语法错误

namespace App\Http\Controllers;

use DB;

class course_controller extends Controller {

    public function show_details() {
        $prospects = DB::table('prospect')->get();

        foreach ($prospects as $prospect) {
            DB::table('course_prospect')->insert(['prospect_id' => 
$prospect->id, 'course_id' => $prospect->course_intrested])
        };

    }

}

标签: laravellaravel-5

解决方案


您需要在插入方法后添加分号。

namespace App\Http\Controllers;

use DB;

class course_controller extends Controller {

    public function show_details() {
        $prospects = DB::table('prospect')->get();

        foreach ($prospects as $prospect) {
            DB::table('course_prospect')->insert(['prospect_id' => 
$prospect->id, 'course_id' => $prospect->course_intrested]);   // add semicolon here
        }   // don't need semi-colon here

    }

}

推荐阅读