我在做laravel 5.2项目,报告创建在"vehicleDetail.blade.php"我需要给一个下拉选项,因为我需要得到车辆名称是在数据库中。从该列表中,如果我选择一辆车,选择fromDate, toDate,然后单击生成报告,我应该能够从数据库(设备表)获取数据。对于这个过滤器引擎,我怎么能使下拉列表从数据库中获取数据?
vehicleDetail.blade.php
@extends('app')
@section('content')
<br><br><br><br><br>
<div class="templatemo-content-wrapper">
<div class="container">
<ol class="breadcrumb">
<li><a href="{{ url("/") }}"><font color="green">Home</font></a></li>
<li class="active">Vehicle Detail</li>
</ol>
<div class="row">
<div class="col-md-8 col-md-offset-2">
<div class="panel panel-success">
<div class="panel-heading">Vehicle Detail</div>
<div class="panel-body">
@if (count($errors) > 0)
<div class="alert alert-danger">
<strong>Whoops!</strong> There were some problems with your input.<br><br>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif
<form class="form-horizontal" role="form" method="POST" action="{{ url('group/update/') }}">
<input type="hidden" name="_token" value="{{ csrf_token() }}">
<div class="form-group">
<label class="col-md-4 control-label">Vehicle</label>
<div class="col-md-6">
<input type="text" class="form-control" name="groupID" value="{{ ('#')}}">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label">From Date</label>
<div class="col-md-6">
<input type="date" class="form-control" name="Fdate">
</div>
<label class="col-md-4 control-label">To Date</label>
<div class="col-md-6">
<input type="date" class="form-control" name="Tdate" >
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-md-offset-4">
<button type="submit" class="btn btn-warning">
Get Report
</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
请任何人帮助我做这件事,响应是值得赞赏的。
在控制器中从数据库中获取所有值,例如:
$list = DB::table('tablename')->get(array('id', 'name'));
并将其传递给视图,如
return view('viewname', array('list' => $list));
现在在视图中使用:
foreach($list as $key => $val)
{
//drop down html here
}