How to Create a table dynamically in the controller??

@Shawdow Don’t. Your database schema should be version-controlled. Properly model your data instead.

how are you storing these extra attributes?

@Snapey I am Starting to do the Properties for a Particular Product so thought that it is better to add the Properties for a Particular Product.this can be done in the laravel ??

well, you cannot have a products table that has different columns for different types of product

@Snapey

below is my Product table i need to add the Properties/attributes for every Product because in the ecommerce site Properties may be different

for example if the Product is Book it can have author name,date of publish etc.. but if the Product is mobile it can have color,memory etc.. so i came up with the solution that in the controller if we create a table it could easy to implement. I hope it understands!!

+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| product_id       | int(100)     | NO   | PRI | NULL    | auto_increment |
| product_cat      | int(100)     | NO   |     | NULL    |                |
| product_brand    | int(100)     | NO   |     | NULL    |                |
| product_title    | varchar(255) | NO   |     | NULL    |                |
| product_price    | int(100)     | NO   |     | NULL    |                |
| product_desc     | text         | NO   |     | NULL    |                |
| product_image    | text         | NO   |     | NULL    |                |
| product_keywords | text         | NO   |     | NULL    |                |
+------------------+--------------+------+-----+---------+----------------+

This is typically done with an EAV store where any number of attributes may be stored against a single master record

have a look at this package https://github.com/rinvex/attributes

@Snapey

I have reffered your link but i don't understand table name given !!!

Schema::create(config('rinvex.attributes.tables.attributes'), function (Blueprint $table) {
            // Columns
            $table->increments('id');
            $table->string('slug');
            $table->{$this->jsonable()}('name');
            $table->{$this->jsonable()}('description')->nullable();
            $table->mediumInteger('sort_order')->unsigned()->default(0);
            $table->string('group')->nullable();
            $table->string('type');
            $table->boolean('is_required')->default(false);
            $table->boolean('is_collection')->default(false);
            $table->text('default')->nullable();
            $table->timestamps();
        });

its saying that the table name comes from a config value

@Snapey yeah I got it but this is not what i want can Laravel creates table/column in Controller Suppose if the admin adds the Properties like color for Mobile laravel should automatically create a column color in the table is there any options to achieve it??

no, use a package like suggested

@Snapey thank you :)

Dear @shawdow ,

You can use the below sample code

<?php

namespace App\Http\Controllers;

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

class TableController extends Controller
{
    public function createTable()
    {
        Schema::create('customers', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email');
            $table->string('phone');
            $table->timestamps();
        });
    }
}

Thanks

Anes P A