基于其他列表laravel 5显示来自数据库的数据

Question

I want to display data from spesific column users table, let say uiprv column. and uiprv same as id from provinsi table.

This is User table image:

and this is provinsi table:

and now, I've succesfully display data from database but just show "31". 31 is uiprv column from users table, it same thing with id from provinsi table. the question is, how to display data not just 31 , but it can be DKI JAKARTA . like in nama_provinsi at provinsi table .

How should I write code in my controller for this. Thanks in Advance.

Answer 1

Add this in your App/User.php

/**
 * Returns the province of the user
 *
 * @return 
 */
public function province()
{
    // Province is your model related to Provinsi table
    return $this->belongsTo('App\Province');
}

From what you've written,

Relationship between User to Province is Many to one.

Reference - https://laravel.com/docs/5.3/eloquent-relationships