在 Laravel 选择查询中获取额外数据

Question

当我在 laravel 中使用 select 查询时，我得到了额外的数据。我的查询MyModal::where('state', 1)        ->select('code as popupContent', 'latitude as lat','longitude as lng')        ->take(3)        ->get()        ->toArray();返回数据：[  [    "popupContent" => "260563"    "lat" => 35.765014    "lng" => 51.333209    "update_time" => null    "rooms_number" => null  ]  [    "popupContent" => "891962"    "lat" => 35.794741    "lng" => 51.391965    "update_time" => null    "rooms_number" => null  ]  [    "popupContent" => "477845"    "lat" => 35.723649    "lng" => 51.320682    "update_time" => null    "rooms_number" => null  ]]在上面的代码中，添加了字段update_time和rooms_number我想给这个数据：[  [    "popupContent" => "260563"    "lat" => 35.765014    "lng" => 51.333209  ]  [    "popupContent" => "891962"    "lat" => 35.794741    "lng" => 51.391965  [    "popupContent" => "477845"    "lat" => 35.723649    "lng" => 51.320682  ]]

Answer 1

您可能会覆盖$append属性

public $appends = ['update_time', 'rooms_number'];

对于隐藏的附加列使用这个

MyModal::where('state', 1)

    ->select('code as popupContent', 'latitude as lat','longitude as lng')

    ->take(3)

    ->get()

    ->makeHidden(['update_time', 'rooms_number'])

    ->toArray();

Answer 2

我认为它仍然在您的模型中。你可以试试：

$items =  DB::table('tableName')

->where('state', 1)

->select('code as popupContent', 'latitude as lat','longitude as lng')

->take(3)->get();

Answer 3

您可以使用以下代码：

    YourModel::select('code as popupContent', 'latitude as lat','longitude as lng')

    ->where('state', 1)

    ->take(3)

    ->get()

    ->toArray();