Laravel＆Typeahead.js：检索类别名称，但将其ID提交给数据库？

我设法将Typeahead.js与laravel应用程序集成。但不幸的是，我需要提交ID而不是name。我需要使用Typeahead检索类别的名称，但将其ID插入数据库中，因为这就是我引用它的方式。

到目前为止，我收到一个sql错误，因为它期望一个整数，但是却得到一个字符串（类别名称）。

我尝试做一个foreach并分配给它$result->id，$data[]但是那根本不起作用。

我该如何解决？

getSubreddits 方法中 PostsController

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

JS

<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
            });
        });
</script>

路线

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

整个store()方法PostsController.php

public function store(PostRequest $request)
    {
        if (Input::has('link')) {
            $input['link'] = Input::get('link');
            $info = Embed::create($input['link']);

            if ($info->image == null) {
                $embed_data = ['text' => $info->description];
            } else if ($info->description == null) {
                $embed_data = ['text' => ''];
            } else {
                $extension = pathinfo($info->image, PATHINFO_EXTENSION);

                $newName = public_path() . '/images/' . str_random(8) . ".{$extension}";

                if (File::exists($newName)) {
                    $imageToken = substr(sha1(mt_rand()), 0, 5);
                    $newName = public_path() . '/images/' . str_random(8) . '-' . $imageToken . ".{$extension}";
                }

                $image = Image::make($info->image)->fit(70, 70)->save($newName);
                $embed_data = ['text' => $info->description, 'image' => basename($newName)];
            }

            Auth::user()->posts()->create(array_merge($request->all(), $embed_data));

            return redirect('/articles');
        }
        Auth::user()->posts()->create($request->all());

        return redirect('/');
}

和形式

{!! Form::open(['url' => 'posts', 'method' => 'POST']) !!}
      <p>
         {!! Form::label('title', 'Title:') !!}
         {!! Form::text('title', null, ['class' => 'form-control', 'id' => 'title']) !!}
      </p>

      <p>
         {!! Form::label('link', 'Link:') !!}
         {!! Form::text('link', null, ['class' => 'form-control', 'id' => 'link']) !!}
      </p>

       <p>
          <div id="remote">
           <input class="form-control typeahead" type="text" placeholder="Choose a Subreddit" name="subreddit_id">
          </div>
       </p>

        <p>
           {!! Form::submit('Submit Post', ['id' => 'submit', 'class' => 'btn btn-primary']) !!}
         </p>

{!! Form::close() !!}