Laravel将数组格式化为Blade表格时出现报错与格式异常求助

错误原因 #

• 你重复嵌套了两层$checkins的遍历，导致数据重复输出
• HTML表格结构错误：<tr>是表格行标签，需要包裹该行所有<td>单元格，你现有代码把key直接放在<tr>标签内，单元格和行的层级完全混乱
• 分页场景下直接对分页器调用map方法会丢失分页结构，也可能导致后续遍历异常
• 单次遍历直接输出数组元素时，{{}}会尝试将数组转为字符串，就会抛出htmlspecialchars() expects parameter 1 to be string, array given错误

修复步骤 #

1. 控制器代码修复（适配分页场景） #

if($request->has('search')) {
    $checkins = Checkin::with(['user'])->where('name', 'like', '%'.$request->search.'%')->paginate(setting('record_per_page', 15));
} else {
    $checkins = Checkin::with(['user'])->get();
}

$title = "Manage Checkins";

// 分页实例用through方法保留分页结构，普通集合用map处理
$checkins = $checkins instanceof \Illuminate\Pagination\LengthAwarePaginator 
    ? $checkins->through(function ($checkin) {
        $location = $this->getAddress($checkin->lat,$checkin->long);
        return [
            'location' => $location,
            // 原代码你写了两次first_name，已修正为first_name+last_name，不需要可以改回
            'student' => $checkin->user->first_name. ' ' .$checkin->user->last_name, 
            'supervisor' => $checkin->supervisor === null ? '' : $checkin->supervisor->first_name. ' ' .$checkin->supervisor->last_name  ,
            'created_at' => $checkin->created_at?->format('Y-m-d H:i:s'), // 提前格式化时间，避免直接输出Carbon对象异常
        ];
    })
    : $checkins->map(function ($checkin) {
        $location = $this->getAddress($checkin->lat,$checkin->long);
        return [
            'location' => $location,
            'student' => $checkin->user->first_name. ' ' .$checkin->user->last_name,
            'supervisor' => $checkin->supervisor === null ? '' : $checkin->supervisor->first_name. ' ' .$checkin->supervisor->last_name  ,
            'created_at' => $checkin->created_at?->format('Y-m-d H:i:s'),
        ];
    });

return view('checkins.index', compact('checkins', 'title'));

2. Blade模板代码修复 #

<table border="1" cellpadding="8" cellspacing="0">
  <!-- 表头：取第一条数据的键作为表头字段 -->
  <thead>
    <tr>
      @if($checkins->isNotEmpty())
        @foreach(array_keys($checkins->first()) as $header)
          <th>{{ ucfirst($header) }}</th>
        @endforeach
      @endif
    </tr>
  </thead>
  <tbody>
    <!-- 遍历每一行数据 -->
    @foreach($checkins as $row)
      <tr>
        @foreach($row as $value)
          <td>{{ $value ?? '-' }}</td>
        @endforeach
      </tr>
    @endforeach
  </tbody>
</table>

<!-- 分页场景下输出分页链接 -->
@if($checkins instanceof \Illuminate\Pagination\LengthAwarePaginator)
  {{ $checkins->links() }}
@endif

补充说明 #

• 代码中先判断$checkins非空再读取表头，避免空数据场景下报错
• 用ucfirst()将表头首字母大写，显示更规范
• 输出值时加?? '-'处理空值，避免页面出现空白

内容的提问来源于stack exchange，提问作者tharnos_nos