Forum Adding DB-column "on the fly"

me4tshield

posted 8 years ago

Requests Database

Last updated 2 years ago.

ndy40

replied 8 years ago

I think you can start with -

Passing in all the parameters you need to create a column. (table name, new column name, data type etc).
Pick up the parameters, generate your sql queries (You can choose to use DB::raw to run ur queries but watch out for possible SQL Injection. You can also play with the methods in https://laravel.com/api/5.2/Illuminate/Database/Schema/Blueprint.html)

me4tshield

replied 8 years ago

Solution

hah, okay - I found another easy way ^^

You can use this code in your controller:

        Schema::table('user_option_values', function ($table) {
            $optionName = Input::get('myInput');
            $table->string($optionName);
        });

Input::get is globally available instead of my solution ^^ But thanks for your help, @ndy40 :)