Laravel - Creating tables dynamically (without migration)

Question

I'm trying to create a table dynamically upon an admin request, and while it seems it should be straightforward like most of Laravel's documentation, I can't seem to create a table. Though I can drop tables, and add or drop columns as I wish.

This is my basic code model:

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

public static function createTable()
{
    Schema::create('randomName', function($table) {
        $table->increments('id');
        $table->string('name');
    });
}

What could possibly be the problem here? Unfortunately I don't receive any errors so not sure how to debug it.

Any advice? Thanks in advance!

Shay · Accepted Answer · 2015-05-07 09:02:13Z

67

Ugh, never mind... I worked on it for long enough, and the solution as always was... Very simple.

I just had to figure a connection for the database first, so instead of

Schema::create('tableName', function($table)
{           
    $table->increments('id');
});

It is

Schema::connection('mysql')->create('tableName', function($table)
{
    $table->increments('id');
});

Hope this helps someone someday in the future!

answered May 7, 2015 at 9:02

Shay

2,0962 gold badges18 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Player1 · Accepted Answer · 2023-09-26 23:50:09Z

12

This one is even better.

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

Schema::create('tableName', function (Blueprint $table) {
        $table->id();
        $table->timestamps();
    });

edited Sep 26, 2023 at 23:50

Player1

3,2253 gold badges30 silver badges40 bronze badges

answered May 20, 2016 at 8:22

YakuZa

5267 silver badges12 bronze badges

1 Comment

Darkshifty Over a year ago

It is exactly the same as Shay's answer.

Collectives™ on Stack Overflow

Laravel - Creating tables dynamically (without migration)

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related