mercredi 2 janvier 2019

How do I print Data from table

1) This is my order table :

Schema::create('orders', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('user_id')->unsigned();
        $table->integer('category_id')->unsigned();
        $table->integer('product_id')->unsigned();
        $table->integer('variant_id')->unsigned();
        $table->integer('quantity');
        $table->integer('total');
        $table->timestamps();
        $table->foreign('user_id')->references('id')->on('users');
        $table->foreign('category_id')->references('id')->on('categories');
        $table->foreign('product_id')->references('id')->on('products');
        $table->foreign('variant_id')->references('id')->on('variants');
    });

2) This is my Order Blade :

<tbody>

        @foreach($orders as $order)
        <tr>
        <td></td>
        <td></td>
        <td>/-</td>
        </tr>
        @endforeach 
    </tbody>

3) This is my OrderController :

public function index()
{
    $orders = Order::where('user_id', auth()->user()->id)->get();
    return view('orders', compact('orders', 'variants'));
}

Now I want to print the variant name in my blade file but only thing I can print is id's. I've tried many things but still can't get the precise answer. I know it can be done with foreign keys but how do I use these foreign keys to print variant_name or anything from variant table.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire