I'm trying to fetch following things from the database:
- user name
 - user avatar_name
 - user avatar_filetype
 - complete conversation_messages
 
with the following query:
    static public function getConversation($id)
{
    $conversation = DB::table('conversation_messages')
        ->where('belongsTo', $id)
        ->join('users', 'conversation_messages.sender', '=', 'users.id')
        ->join('user_avatars', 'conversation_messages.sender', '=', 'user_avatars.id')
        ->select('users.name', 'conversation_messages.*', 'user_avatars.name', 'user_avatars.filetype')
        ->get();
    return $conversation;
}
It works fine so far, but the avatar's column name is 'name' like the column name from the 'users' table. 
So if I'm using this query the to get the output via $conversation->name, the avatar.name overwrites the users.name
Is there a way to rename the query output like the mysql "as" feature at laravel 5.1?
For example:
$conversation->avatarName
$conversation->userName
Aucun commentaire:
Enregistrer un commentaire