Laravel - dynamic table creation (no migration)

Question

I am trying to create a table dynamically at the request of the administrator, and although it seems that everything is funny and dandy, as in most Laravel documentation, I cannot imagine creating a table. Although I can drop the tables and add or remove columns as I wish.

This is my main 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 be the problem here? Unfortunately, I am not getting any errors, so I do not know how to debug it. It just moves on to the next line, like everything that works fine. It just does not create any tables.

Any tips? Thank you very much in advance!

Answer 1

Wow, it doesn’t matter ... I worked on it for a long time, and the solution, as always, was ... Very simple.

I just needed to first define the connection for the database, so instead

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

it

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

Hope this someday helps someone in the future!

Answer 2

This is even better.

 use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; Schema::create('tableName', function (Blueprint $table) { $table->increments('id'); $table->timestamps(); });