php - 拉拉维尔 5 : jQuery Typeahead gives error status 500 on page load (Missing argument)

Question

其他一切正常，当我搜索 subreddit(类别)并将其提交到数据库时，没有问题。

但是当我第一次加载post/create时页面，我得到 STATUS 500在此路线上http://localhost/reddit/public/data/subreddits

考虑到它有效，我不确定我做错了什么。

路线

Route::get('data/subreddits', 'PostsController@getSubreddits');
Route::get('data/subreddits/{QUERY}', 'PostsController@getSubreddits');

PostsController.php

public function create()
{
    $subreddits = Subreddit::lists('name', 'id')->toArray();

    return view('post/create')->with('subreddits', $subreddits);
}

public function getSubreddits($query) {
        $results = Subreddit::select('id', 'name')->where('name', 'LIKE', '%' . $query . '%')->get();
        return Response::json($results);
}

create.blade.php中的Javascript

<script type="text/javascript">
        $(document).ready(function() {
            var subreddits = new Bloodhound({
                datumTokenizer: Bloodhound.tokenizers.obj.whitespace('name'),
                queryTokenizer: Bloodhound.tokenizers.whitespace,
                prefetch: 'http://localhost/reddit/public/data/subreddits',
                remote: {
                    url: 'http://localhost/reddit/public/data/subreddits/%QUERY',
                    wildcard: '%QUERY'
                }
            });

            $('#remote .typeahead').typeahead(null, {
                name: 'name',
                display: 'name',
                source: subreddits
            });

            $('#remote .typeahead').bind('typeahead:select', function(ev, suggestion) {
                $('.subreddit_id').val(suggestion.id);
            });
        });
    </script>

错误

Missing argument 1 for App\Http\Controller\PostsController::getSubreddits()

Answer 1

正如 @mimo 所回答的那样，您需要将您的查询作为可选参数。

Route::get('data/subreddits/{query?}', 'PostsController@getSubreddits');

您还需要将默认值传递给 getSubreddits 中的 query 参数

public function getSubreddits($query = '') {
    $results = Subreddit::select('id', 'name')->where('name', 'LIKE', '%' . $query . '%')->get();
    return Response::json($results);
}

此外，如果只有很少的结果，如果没有传递查询参数，您可以发送所有数据。

public function getSubreddits($query = '') {
    $q = Subreddit::select('id', 'name')
    if ($query) {
        $q->where('name', 'LIKE', '%' . $query . '%');
    }
    return Response::json($q->get());
}