如何通过'?filter[DBfieldname]=value&[DBfieldname2]=value2'在 Laravel 8 的 url 中

Question

我需要根据获取请求来过滤数据，

当前路由

Route::get('datasearch', [Mycontroller::class, 'MyFunction'])->name('this.is.route.name');

当前 Forntend 表单

    <form method="get" enctype="multipart/form-data" action="{{ route('this.is.route.name') }}">
@csrf
        <select class="form-control" name="searchAdmin">
            <option class="hidden" selected disabled>Admin List </option>
            <option value="1">Value 1</option>
            <option value="2">Value 2</option>
        </select>
        <<select class="form-control" name="searchAgent">
            <option class="hidden" selected disabled>Agent List </option>
            <option value="1">Value 1</option>
            <option value="2">Value 2</option>
        </select>
        <input type="submit" value="Search Data" />
    </form>

我需要创建以下类型的 URL

http://127.0.0.1:8000/datasearch?filter[dbfieldname1]=searchAdmin&filter[dbfieldname2]=searchAgent

Answer 1

要发出符合您要求的请求，只需使用此内容设置表单，例如 resources\views\home.blade.php：

<form method="get" enctype="multipart/form-data" action="{{ route('search.data') }}">
  <select class="form-control" name="filter[dbfieldname1]">
      <option class="hidden" disabled selected>Admin List </option>
      <option value="1">Value 1</option>
      <option value="2">Value 2</option>
  </select>
  <select class="form-control" name="filter[dbfieldname2]">
      <option class="hidden" disabled selected>Agent List </option>
      <option value="1">Value 1</option>
      <option value="2">Value 2</option>
  </select>
  @csrf
  <input type="submit" value="Search Data" />
</form>

配置路由 routes\web.php：

Route::get('/search/data', [App\Http\Controllers\HomeController::class, 'search'])->name('search.data');

然后将搜索功能设置为app\Http\Controllers\HomeController.php：

// Get search data
public function search(Request $request)
{
    logger('Function search is working.');
    $filter = $request->filter;
    if($filter) {
        if(isset($filter['dbfieldname1'])){
            logger('Value of dbfieldname1:');
            logger($filter['dbfieldname1']);
        } else {
            logger('Admin list is not choosen.');
        }
        if(isset($filter['dbfieldname2'])){
            logger('Value of dbfieldname2:');
            logger($filter['dbfieldname2']);
        } else {
            logger('Agent list is not choosen.');
        }
    } else {
        logger('Not any lists choosen!');
    }
}

清除storage\logs\laravel.log，即可获得成功结果！

[2022-03-05 05:53:54] local.DEBUG: Function search is working.  
[2022-03-05 05:53:54] local.DEBUG: Admin list is not choosen.  
[2022-03-05 05:53:54] local.DEBUG: Value of dbfieldname2:  
[2022-03-05 05:53:54] local.DEBUG: 2  
[2022-03-05 05:54:24] local.DEBUG: Function search is working.  
[2022-03-05 05:54:24] local.DEBUG: Value of dbfieldname1:  
[2022-03-05 05:54:24] local.DEBUG: 1  
[2022-03-05 05:54:24] local.DEBUG: Agent list is not choosen.  

Answer 2

只需提供一个包含路由参数键值的数组即可。例如：

route('products.index', ['manufacturer' => 'Samsung','price' => '10000']);

Answer 3

如果您不上传任何文件，您可能需要在表单中使用 enctype="application/x-www-form-urlencoded"。 multipart/form-data 将与需要文件上传的（特殊）POST 请求一起使用（我不确定当您将它与GET，它可能会被忽略）。

然后，您必须记住，inputs/selects/textareas 上的每个 name="..." 属性将确定 URL 中数据的键，即

<input type="text" name="username" value="foobar" />
// example.com?username=foobar
// Laravel will interpret it as ['username' => 'foobar']

您也可以更改此名称到 username[] 自动将输入解析为数组（我相信这一切都可以在 PHP 中开箱即用，最终取决于您的服务器），即

<input type="text" name="username[]" value="foo" />
<input type="text" name="username[]" value="bar" />
// example.com?username[]=foo&username[]=bar
// Laravel will interpret it as ['username' => ['foo', 'bar']]

最后，当您放置内容时在括号内，它将被解释为其中的键像这样的值：

<input type="text" name="username[a]" value="foo" />
<input type="text" name="username[b]" value="bar" />
// example.com?username[a]=foo&username[b]=bar
// Laravel will interpret it as ['username' => ['a' => 'foo', 'b' => 'bar']]