拉拉维尔:我怎么能在路上通过一个身份证呢

Question

我正在构建一个系统，这样用户就可以请求多件事，我希望能够可视化系统中(单独(提出的每个请求的详细信息。目前的方法让我一次得到所有东西，而不是分开。

这是代码的一部分

控制器

public function verDetalhesKeys($id)
{  
$detalhes = DB::table('keysRequest')  
->where('keysRequest.id','=', $id)
->select('keysRequest.*')
->get();
return view('Admin.keysRequestDetails',compact('detalhes'));
}

路线

Route::get('/detalhesK/{id}', 'AdminController@verDetalhesKeys') -> name('detalhesK');

显示详细信息的按钮

<table class="table table-striped">
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>Department</th>
<th>Site</th>
<th>Pourpose</th>
<th>From</th>
<th>To</th>
</tr>
</thead>
<tbody>
@foreach($keys as $s)
<tr>
<td>{{$s->name}}</td>
<td>{{$s->email}}</td>
<td>{{$s->department}}</td>
<td>{{$s->site}}</td>
<td>{{$s->purpose}}</td>
<td>{{$s->till}}</td>
<td>{{$s->until}}</td>
<td style="display:none;">{{$s->id}}</td>
<td><a class="btn btn-info btn-md" href="{{ route('detalhesK',['id' => $s->id])}}" style="background-color:#00a3b3;"><i class="fa fa-eye" aria-hidden="true"></i></a></td>
</tr>
@endforeach
</tbody>
</table>

详情页面

<div class="container">
<div class="row justify-content-center">
<div class="col-16 col-md-12 col-lg-12 pb-7">
<!--Form with header-->
<form  method="post">
@foreach($detalhes as $d)
<div class="card border-primary rounded-0">
<div class="card-header p-0">
<div class="bg-info text-white text-center py-2">
<h3>Requisição de Chaves Detalhes || Keys Request Details</h3>
</div>
</div>
<div class="card-body p-3">
<!--Body-->
<div class="form-group">
<label>Nome || Name</label>
<input type="text" class="form-control" placeholder="{{$d->name}}" readonly>
</div>
<div class="form-group">
<label>Email</label>
<input type="email" class="form-control"  placeholder="{{$d->email}}" readonly>
</div>
<div class="form-group">
<label>Departamento || Department</label>
<textarea class="form-control" placeholder="{{$d->department}}" readonly></textarea>
</div>
<div class="form-group">
<div class="input-group mb-2">
<label>Local || Site</label>
<textarea class="form-control" placeholder="{{$d->site}}" readonly></textarea>
</div>
<br>
<div class="form-group">
<label>Finalidade || Purpose</label>
<input type="Quantidade" class="form-control"  placeholder="{{$d->purpose}}" readonly>
</div>

<div class="form-group">                                   
<label>Período de uso das chaves || Period of use of the keys</label>
<textarea class="form-control" placeholder="{{$d->till}} - {{$d->until}}" readonly></textarea>
</div>
<div class="text-center">
<a class="btn btn-danger" href=""><font color="white"> Rejeitar || Refuse </font></a>
<a class="btn btn-success" href=""><font color="white"> Validar || Validate </font></a>
</div>
</div>
@endforeach
</div>
</form>
<!--Form with header-->
</div>

Answer 1

首先是数据库表中主键的列"id"，您需要确保它是，这样您就不会有duplicate产品。将查询编辑为$detalhes = DB::table('keysRequest')->find(id);。完成后，不需要使用循环来输出结果，因为它只有1个项目。只需使用{{$detalhes->something}}