在 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();