I'm setting up a system to check if the user has sent a message to another user.
MessagesController.php
use App\Message;
use App\User;
class MessagesController extends Controller
{
public function index()
{
return view('admin.messages')->with('messages', Message::all())
->with('users', User::all());
}
The message migration has following data:
Schema::create('messages', function (Blueprint $table) {
$table->increments('id');
$table->integer('from');
$table->integer('to');
$table->mediumText('text');
$table->integer('status');
$table->timestamps();
});
And the web.php
Route::get('/admin/messages', [
'uses' => 'MessagesController@index',
'as' => 'messages'
]);
So the idea is to present a panel with the data of messages, showing:
<tbody>
<tr>
@foreach ($messages as $message)
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
@endforeach
</tr>
</tbody>
This loads correctly all the information on the Message table. However, it will display the 'from' and 'to' as and ID, as it should.
I expect to have the table populated with not the ID of the user, but the Name of the user, via a relationship between the Message table and the Users table.
What am I missing?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire