mysql blade.html中的id值与其在数据库中的值不同

hmmo2u0o  于 12个月前  发布在  Mysql
关注(0)|答案(1)|浏览(54)

我在Laravel项目中发现我的条目的id值与它在数据库中的真实的值不同。
示例:

数据库

条目1

  • 联系我们
  • 姓名:John
  • 职位:司机
入口2
  • 联系我们
  • Name:zhang cheng
  • 工作:护士

在blade文件中,它会给予我这个:

条目1

  • 联系我们
  • 姓名:John
  • 职位:司机
入口2
  • 联系我们
  • Name:zhang cheng
  • 工作:护士

这是我的控制器:

public function sponsorship_transfer(Request $request)
{
    $data['q'] = $request->query('q');
    $data['profession_id'] = $request->query('profession_id');
    $data['nationality_id'] = $request->query('nationality_id');
    $data['professions'] = WorkerProfession::all();
    $data['nationalities'] = WorkerNationality::all();

    $query = InWorker::select('in_workers.*', 'worker_statuses.*', 'worker_nationalities.*', 'worker_professions.*')
        ->join('worker_statuses', 'worker_statuses.id', '=', 'in_workers.status_id')
        ->join('worker_nationalities', 'worker_nationalities.id', '=', 'in_workers.nationality_id')
        ->join('worker_professions', 'worker_professions.id', '=', 'in_workers.profession_id')
        ->with(['languages', 'education', 'experience', 'birthday_place', 'media'])
        ->where('status_id', 3)->where(function ($query) use ($data) {
            $query->orWhere('name', 'like', '%' . $data['q'] . '%');
        });

    if ($data['profession_id'])
        $query->where('worker_professions.id', $data['profession_id']);

    if ($data['nationality_id'])
        $query->where('worker_nationalities.id', $data['nationality_id']);

    $data['in_workers'] = $query->get();

    return view('frontend.sponsorship_transfer', $data);
}

这是我的密码

@foreach ($in_workers as $inWorker)
    <div class="invest-title-tow">
        <h3>{{ $inWorker->id }}</h3>
    </div>
@endforeach

我试着把刀片换成这样,但什么也没发生:

@foreach ($in_workers as $inWorker)
    <div class="invest-title-tow">
        <h3>{{ $inWorker->ID }}</h3>
    </div>
@endforeach

你能帮我修一下吗?
谢谢你

7rtdyuoh

7rtdyuoh1#

我用这个修好它

public function sponsorship_transfer(Request $request)

{



    $data['q'] = $request->query('q');
    $data['profession_id'] = $request->query('profession_id');
    $data['nationality_id'] = $request->query('nationality_id');
    $data['professions'] = WorkerProfession::all();
    $data['nationalities'] = WorkerNationality::all();



    $query = InWorker::with(['status', 'nationality', 'profession', 'languages', 'education', 'experience', 'birthday_place', 'media'])
        ->where('status_id', 3)->where(function ($query) use ($data) {
            $query->orWhere('name', 'like', '%' . $data['q'] . '%');
        });

    if ($data['profession_id'])
        $query->where('profession_id', $data['profession_id']);

    if ($data['nationality_id'])
        $query->where('nationality_id', $data['nationality_id']);

    $data['in_workers'] = $query->paginate(9);
    return view('frontend.sponsorship_transfer', $data );
}

相关问题