时间戳

首页 > 解决方案 > 有没有办法只从中获取列名？

laravel - 有没有办法只从中获取列名？

问题描述

我只想在可能的情况下获取列名在此处输入图像描述

//项目表，列new_values数据

 {"item_name":"
  Chopstick",
  "item_quantity":"4",
  "item_brand":"d",
  "item_serialno":"3",
  "item_tag":"New",
   "item_categories":"Assets",
   "item_unitcost":"4",
   "item_depriciation":"5",
   "item_location":
   "Not Deployed",
   "user_assign":"None",
   "department":"Not Assigned","id":36}

//控制器

$audits=audits::select('new_values')->get();

//刀

   @foreach($audits as $colName => $value)
       {{ $colName }}
   @endforeach

标签： laravel

解决方案

据我了解，您正在使用审核模型包如果是，那么您可以使用它

@foreach($audits as $audit)
    @foreach($audit->new_values as $colName => $value)
        {{ $colName }}
        // use @dd($aud->new_values, $colName) for see what is value
        // other logic
    @endforeach
@endforeach

推荐阅读