如何从 Laravel 中的对象获取用户名

Question

我是 Laravel 的初学者，我有以下迁移。

Schema::create('users', function (Blueprint $table) {

    $table->bigIncrements('id');

    $table->bigInteger('company_id')->unsigned();

    $table->foreign('company_id')->references('id')->on('companies')->onDelete('cascade');

    $table->boolean('enable')->default(0);

    $table->string('name', 120)->nullable();

    $table->string('surname', 120)->nullable();

    $table->string('email', 120)->unique();

    $table->timestamp('email_verified_at')->nullable();

    $table->string('password');

    $table->boolean('enable_map')->default(0);

    $table->rememberToken();

    $table->timestamps();

    $table->engine = "InnoDB";

});

Schema::create('comments', function (Blueprint $table) {

    $table->bigIncrements('id');

    $table->bigInteger('user_id')->unsigned();

    $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');

    $table->Integer('rating');

    $table->text('content');

    $table->dateTime('date_time');

    $table->string('ip', 25);

    $table->engine = "InnoDB";

});

用户名

class User extends Authenticatable implements MustVerifyEmail

{

    use Notifiable;

    use psCMS\Presenters\UserPresenter;

    public static $roles = [];

    protected $fillable = ['company_id', 'enable', 'name', 'surname', 'email', 'email_verified_at', 'password', 'counter', 'url_address',  'isCompany', 'isMailing', 'content', 'nip1', 'business1', 'phone1', 'street1', 'number1', 'postal_code1', 'city1', 'country_id1', 'provincial_id1', 'nip2', 'business2', 'phone2', 'street2', 'number2', 'postal_code2', 'city2', 'country_id2', 'provincial_id2', 'nip3', 'business3', 'phone3', 'street3', 'number3', 'postal_code3', 'city3', 'country_id3', 'provincial_id3', 'cash', 'lng', 'lat', 'enable_map', 'remember_token', 'created_at', 'updated_at', 'last_login_at', 'last_login_ip' ];

    protected $hidden = [

        'password', 'remember_token',

    ];

 

Answer 1

Comments::with('user')->where('content','LIKE','%'.$query.'%')->orWhere('id','LIKE','%'.$query .'%')->orderBy($sortColumn, $sortMethod)->paginate(25);

Answer 2

我没有关于用户的信息。我只有来自评论的价值。为什么？因为您只在模型 Comments 上进行查询我如何获取有关添加此评论的用户的信息？将用户添加到查询中：$comments_with_user_info = Comments::with('user')->where('content','LIKE','%'.$query.'%')->orWhere('id','LIKE','%'.$query.'%')->orderBy($sortColumn, $sortMethod)->paginate(25);我想显示评论列表以及有关用户的信息。您可以通过这种方式获取名称（例如在刀片中）：@foreach($comments_with_user_info as $comment)    {{ $comment->user->name }}@endforeach