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!

score 67 · Accepted Answer · answered May 07 '15 at 09:02

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 07 '15 at 09:02

Shay

2,060
2
16
22

6

Yes! Two months later it helped someone. Thanks – Michael Obi Jul 05 '15 at 21:55
Thanks Shay! Still helpful in 2017! – Barn on a Hill Aug 04 '17 at 19:28
Thanks a lot Shy! it's helping me in 2019, thanks for sharing your solution to us! – Reza sh Jul 06 '19 at 11:04
Perfect!!! Thanks for informing back to us – Ritobroto Mukherjee Dec 21 '21 at 17:53

score 12 · Answer 2 · answered May 20 '16 at 08:22

12

This one is even better.

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

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

answered May 20 '16 at 08:22

YakuZa

516
7
12

It is exactly the same as Shay's answer. – Darkshifty Sep 18 '19 at 12:19

Laravel - Creating tables dynamically (without migration)

2 Answers2

Linked