Laravel 5.3 Parse error: syntax error, unexpected '$table' (T_VARIABLE) when migrating

Question

Heres my migration codes:

class CreateOrdersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
          Schema::create('orders', function (Blueprint $table){
          $table->increments('order_id');
          $table->integer('order_no');
          $table->string('total_price');
          $table->date('date_received');
          $table->date('date_expected');
          $table->integer('product_id')->unsigned();
          $table->foreign('product_id')->references('product_id')->on('product');
          $table->string('product_snumber');
          $table->integer('customer_name')
          $table->string('order_status');
          $table->timestamps();
          });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
                Schema::dropIfExists('orders');
    }
}

But after I run 'php artisan migrate', the following error appears.

[Symfony\Component\Debug\Exception\FatalThrowableError]
Parse error: syntax error, unexpected '$table' (T_VARIABLE)

Please help! I am migrating to phpmyadmin database.

have you crosschecked your migrations? those **unexpected '$table'** might related to missing `;` or something else, just proof-read the syntax.. — Bagus Tesa, Jan 20 '17 at 02:57
@BagusTesa Yes I have crosschecked my migrations. Apparently the error line appears to be '$table->string('order_status');'. Any idea why? — Kimberly Inspirit, Jan 20 '17 at 03:01
Does this answer your question? [PHP parse/syntax errors; and how to solve them](https://stackoverflow.com/questions/18050071/php-parse-syntax-errors-and-how-to-solve-them) — Nico Haase, Jun 18 '21 at 09:32

score 4 · Answer 1 · answered Mar 15 '17 at 04:56

4

Yes @Bagus Tesa is right. (Just wanted to answer because I nearly missed the comment as it contains no answer) The missing semicolon ; could be the problem. Check all your modified migrations.

answered Mar 15 '17 at 04:56

bishnub

41
1
5

score 0 · Answer 2 · answered Jul 10 '19 at 16:20

0

Check if into another migration has some char or something was lost there, In my case, I forgot a character in an old migration :(, after removed that worked for me!

answered Jul 10 '19 at 16:20

José Bispo

161
1
3

score 0 · Answer 3 · answered Jul 15 '20 at 09:30

The error occurred for me when I cut and pasted a list of fields from another program, Freemind 1.0.1, into VS Code (the one before 1.47.1). Some pasted lines included leading spaces. VS Code continually showed the error until all the leading spaces were deleted and replaced with the usual tab key presses.

It was necessary to start deleting the leading spaces above the highlighted error line. The error highlight would then hop from line to line down the code till it disappeared.

Sometimes the error switched from unexpected '$table' to: unexpected ' '

Because the problem was in the leading spaces, it couldn't be seen, unlike the missing semicolon solution.

Mrunali Khandekar · Answer 4 · 2020-09-11T10:11:11.437

0

semicolon is missing on this line $table->integer('customer_name') add semicolon $table->integer('customer_name');

edited Sep 11 '20 at 10:11

answered Sep 05 '20 at 12:43

Mrunali Khandekar

55
1
10

There's no need to duplicate existing answers - the exact hint has already been given over three years before your answer – Nico Haase Jun 18 '21 at 09:33
Still I wanted to answer. You can ignore the post if you don't find it useful. – Mrunali Khandekar Jun 25 '21 at 06:36

score 0 · Answer 5 · answered Sep 05 '20 at 12:48

0

$table->integer('customer_name')

missing semicolon ';'

meanwhile for avoiding these errors when your coding , you should use as such EA inspect codes plugins , usually smell check code and background inspect tools

answered Sep 05 '20 at 12:48

dılo sürücü

3,821
1
26
28

There's no need to duplicate existing answers - the exact hint has already been given over three years before your answer – Nico Haase Jun 18 '21 at 09:33
ı don't was realize it – dılo sürücü Jun 18 '21 at 15:45

Laravel 5.3 Parse error: syntax error, unexpected '$table' (T_VARIABLE) when migrating

5 Answers5