foreign key shows syntax error in laravel 5.4

Question

I have created migration file in that i have written :

public function up()
    {
        //
        Schema::create('ad_group', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('campaign_id')->unsigned();
            $table->char('name',32);
        });
        Schema::table('ad_group',function (Blueprint $table){
            $table->foreign('campaign_id')->references->('id')->on('campaigns');
        });
    }

which returns error like this :

[Symfony\Component\Debug\Exception\FatalThrowableError]
Parse error: syntax error, unexpected '(', expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$'

score 0 · Accepted Answer · answered May 10 '17 at 06:17

0

Your mistake is  "->references->('id')->" must be "->references('id')->"

public function up() {
    Schema::table('ad_group', function (Blueprint $table) {
          $table->foreign('campaign_id')->references('id')->on('campaigns');
    });
}

Hope it help :)

answered May 10 '17 at 06:17

Odin Thunder

3,284
2
28
47

Thank you for your answer. It was a syntax error ! I cannot believe i spent more than 2 hours on this. Thank you ! – Tricore Dev May 10 '17 at 06:25
sometimes it happens ;) – Odin Thunder May 10 '17 at 06:31
do not forget mark question as solve ) – Odin Thunder May 10 '17 at 06:59
Sure. I didn't know how to mark solved. I was trying to upvote your answer!! – Tricore Dev May 10 '17 at 09:55

foreign key shows syntax error in laravel 5.4

1 Answers1