在下拉列表中选择“选项”之后,如何从数据库中获取一些输入的值



我正在构建一个html表单,其中包含有关客户端和其他信息的所有信息,因此,当我选择下拉列表中的客户端名称时(选择选项包含所有客户名称(其他输入字段(例如(地址,电话,电子邮件((应自动填充。

我不知道我必须使用Ajax或jQuery以及如何使用它。

这是我的观点:

@extends('layouts.master')
@section('content')
<div class="container">
    <div class="row">
        <div class="col-md-11">
            <div class="panel panel-default">
                <div class="panel-heading">Création de commandes</div>
                <div class="panel-body">
                    <form id="form2" class="form-horizontal" method="POST" action="{{url('gestion_commandes/create')}}">
                        {{ csrf_field() }}
                        <div class="form-group{{ $errors->has('nomp') ? ' has-error' : '' }}">
                            <label for="nomp" class="col-md-1 control-label">Client</label>
                            <div class="col-md-5">
                                     <select name="nomclient" id="nomclient"  class="form-control dynamic" data-dependent="organisme" required autofocus>
                                          <option>--Select--</option>
                                          @foreach ($clientscombos as $clientcombos)
                                          <option value="{{$clientcombos->nom}}">{{$clientcombos->nom}} </option>
                                          @endforeach
                                     </select>
                         </div>
                         {{ csrf_field() }}
                             <label for="organisme" class="col-md-1 control-label">Organisme</label>
                          <div class="col-md-5">
                                <input id="organisme" type="text" class="form-control" name="organisme" value="{{$clientcombos->organisme}}"  required  autofocus>
                                @if ($errors->has('organisme'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('organisme') }}</strong>
                                    </span>
                                @endif
                            </div>


                        </div>
                        <div class="form-group{{ $errors->has('adresse') ? ' has-error' : '' }}">
                            <label for="adresse" class="col-md-1 control-label">Adresse</label>
                            <div class="col-md-5">
                                <input id="adresse" type="text" class="form-control" name="adresse" value="{{$clientcombos->adresse}}"   autofocus>
                                @if ($errors->has('adresse'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('adresse') }}</strong>
                                    </span>
                                @endif
                            </div>
                            <label for="emailp" class="col-md-1 control-label">E-Mail Address</label>
                            <div class="col-md-5">
                                <input id="emailp" type="email" class="form-control" name="emailp" placeholder="Saisir l'adresse email" required autofocus>
                                @if ($errors->has('emailp'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('emailp') }}</strong>
                                    </span>
                                @endif
                            </div>


                      </div>
                      <div class="form-group{{ $errors->has('adressep') ? ' has-error' : '' }}">
                          <label for="tel" class="col-md-1 control-label">Tel</label>
                            <div class="col-md-3">
                                <input id="tel" type="Tel" class="form-control" name="tel"  value="{{$clientcombos->tel1}}" required autofocus>
                                @if ($errors->has('tel'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('tel') }}</strong>
                                    </span>
                                @endif
                            </div>
                            <label for="tel2p" class="col-md-1 control-label">Tel2</label>
                            <div class="col-md-3">
                                <input id="tel2p" type="Tel" class="form-control" name="tel2p"  value="+2126" required autofocus>
                                @if ($errors->has('tel2p'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('tel2p') }}</strong>
                                    </span>
                                @endif
                            </div>
                         <label for="faxp" class="col-md-1 control-label">Fax</label>
                            <div class="col-md-3">
                           <input id="faxp" type="Tel" class="form-control" name="faxp" value="{{$clientcombos->fax}}" required autofocus>
                               @if ($errors->has('faxp'))
                              <span class="help-block">
                              <strong>{{ $errors->first('faxp') }}</strong>
                                </span>
                               @endif
                            </div>

                      </div>









                            <div class=" panel panel-success">                             </div>
                            <div class=" panel panel-success">                             </div>

                        <div class="form-group{{ $errors->has('daterecep') ? ' has-error' : '' }}">
                                <label for="commercial" class="col-md-1 control-label">Commercial</label>
                            <div class="col-md-3">
                            <select name="commercial" id="commercial"  class="form-control" required autofocus>
                                          <option>--Select--</option>
                                          @foreach ($combocommerciaux as $combocommercial)
                                          <option value="{{$combocommercial->name}}">{{$combocommercial->name}} </option>
                                          @endforeach
                                     </select>
                            </div>
                            <label for="datereception" class="col-md-1 control-label">Date de réception</label>
                            <div class="col-md-3">
                                <input id="datereception" type="date" class="form-control" name="datereception" placeholder="Saisir le nom complet"  required autofocus>
                                @if ($errors->has('datereception'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('datereception') }}</strong>
                                    </span>
                                @endif
                            </div>
                            <label for="dateprelev" class="col-md-1 control-label">Date de prélevement</label>
                            <div class="col-md-3">
                                <input id="dateprelev" type="date" class="form-control" name="dateprelev" placeholder="Saisir le nom complet"  required autofocus>
                                @if ($errors->has('dateprelev'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('dateprelev') }}</strong>
                                    </span>
                                @endif
                            </div>

                     </div>

                      <div class="form-group{{ $errors->has('commercial') ? ' has-error' : '' }}">
                             <label for="savedby" class="col-md-9 control-label">Enregistrée par </label>
                            <div class="col-md-3">
                                <input id="savedby" type="text" class="form-control" name="savedby" value="{{Auth::user()->name}}" required autofocus>
                                @if ($errors->has('savedby'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('savedby') }}</strong>
                                    </span>
                                @endif
                            </div>
                        </div>
                        <div class="form-group{{ $errors->has('nbrrowsol') ? ' has-error' : '' }}">
                            <label for="nbrrowsow" class="col-md-1 control-label">Sol </label>
                            <div class="col-md-3">
                                <input id="nbrrowsol" type="number" class="form-control" name="nbrrowsol"  required autofocus>
                                @if ($errors->has('nbrrowsol'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrrowsol') }}</strong>
                                    </span>
                                @endif
                            </div>

                        </div>
                        <div class="form-group{{ $errors->has('nbrroweau') ? ' has-error' : '' }}">
                            <label for="nbrroweau" class="col-md-1 control-label">Eau </label>
                            <div class="col-md-3">
                                <input id="nbrroweau" type="number" class="form-control" name="nbrroweau"  required autofocus>
                                @if ($errors->has('nbrroweau'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrroweau') }}</strong>
                                    </span>
                                @endif
                            </div>

                        </div>
                        <div class="form-group{{ $errors->has('nbrrowveg') ? ' has-error' : '' }}">
                            <label for="nbrrowveg" class="col-md-1 control-label">VEG </label>
                            <div class="col-md-3">
                                <input id="nbrrowveg" type="number" class="form-control" name="nbrrowveg"  required autofocus>
                                @if ($errors->has('nbrrowveg'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrrowveg') }}</strong>
                                    </span>
                                @endif
                            </div>

                        </div>
                        <div class="form-group{{ $errors->has('nbrrowbiof') ? ' has-error' : '' }}">
                            <label for="nbrrowbiof" class="col-md-1 control-label">Fertilisant </label>
                            <div class="col-md-3">
                                <input id="nbrrowbiof" type="number" class="form-control" name="nbrrowbiof" placeholder="Saisir l'adresse email" required autofocus>
                                @if ($errors->has('nbrrowbiof'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrrowbiof') }}</strong>
                                    </span>
                                @endif
                            </div>
                            <div class="col-md-6 control-label">
                            <button type="submit" class="btn btn-primary" onclick="location.href='{{url('gestion_regions/create')}}'" >Executer</button>
                            </div>
                        </div>
                        <div class="form-group{{ $errors->has('nbrrowmicair') ? ' has-error' : '' }}">
                            <label for="nbrrowmicair" class="col-md-1 control-label">Mic Air </label>
                            <div class="col-md-3">
                                <input id="nbrrowmicair" type="number" class="form-control" name="nbrrowmicair"  required autofocus>
                                @if ($errors->has('nbrrowmicair'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrrowmicair') }}</strong>
                                    </span>
                                @endif
                            </div>

                        </div>
                        <div class="form-group{{ $errors->has('nbrrowmiceau') ? ' has-error' : '' }}">
                            <label for="nbrrowmiceau" class="col-md-1 control-label">Mic Eau</label>
                            <div class="col-md-3">
                                <input id="nbrrowmiceau" type="number" class="form-control" name="nbrrowmiceau"  required autofocus>
                                @if ($errors->has('nbrrowmiceau'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrrowmiceau') }}</strong>
                                    </span>
                                @endif
                            </div>

                        </div>
                        <div class="form-group{{ $errors->has('nbrrowmicsurface') ? ' has-error' : '' }}">
                            <label for="nbrrowmicsurface" class="col-md-1 control-label">Mic Surface </label>
                            <div class="col-md-3">
                                <input id="nbrrowmicsurface" type="number" class="form-control" name="nbrrowmicsurface" placeholder="Saisir l'adresse email" required autofocus>
                                @if ($errors->has('nbrrowmicsurface'))
                                    <span class="help-block">
                                        <strong>{{ $errors->first('nbrrowmicsurface') }}</strong>
                                    </span>
                                @endif
                            </div>

                      </div>

                        <div class="form-group">
                            <div class="col-md-6 col-md-offset-4">
                                <button type="submit" class="btn btn-success">
                                    Enregistrer
                                </button>
                            </div>
                        </div>
                    </form>
                </div>


            </div>
        </div>
    </div>
</div>
@endsection

这是控制器:

<?php
namespace AppHttpControllers;

use IlluminateHttpRequest;
use DB;
use AppClient;
class DynamicDependent extends Controller
{
    public function comboboxclients()
    {
        $clientscombos = DB::select('select * from clients');
        $combocommerciaux = DB::select('select * from commercials');

        return view('gestion_commandes.create',['clientscombos' => $clientscombos , 'combocommerciaux' => $combocommerciaux]);
    }
}

您必须:

1(服务器端:创建另一个动作,该操作将根据SELECT的值获取客户端数据(我建议您在模板中使用客户端ID作为SELECT值(。

2(客户端:在选择值更改上添加挂钩(js中的'更改'事件(,该挂钩将向步骤1创建的操作发送AJAX请求(包含选定值(,并填充带有接收数据的表单输入。

就是这样。自由询问特定的实施详细信息,但请记住,没有人会在这里为您编写代码,您必须自己做,但是您可以使用此方向。

最新更新