My FAQ System is working well, but I want to include a search function with Select2.
What I got so far:
Select2 AJAX Script
<script>
$("#searchall").select2({
ajax: {
url: "/ajax/searchallSelect2",
dataType: 'json',
delay: 250,
data: function (params) {
return {
q: params.term, // search term
page: params.page
};
},
processResults: function (data, params) {
// parse the results into the format expected by Select2
// since we are using custom formatting functions we do not need to
// alter the remote JSON data, except to indicate that infinite
// scrolling can be used
params.page = params.page || 1;
return {
results: data.items,
pagination: {
more: (params.page * 30) < data.total_count
}
};
},
cache: true
},
escapeMarkup: function (markup) { return markup; }, // let our custom formatter work
minimumInputLength: 1,
});
AjaxController.php
/**
* @Route("/ajax/searchallSelect2", name="ajax_searchall_select2")
*/
public function searchallSelect2Action(Request $request)
{
dump($request);
exit;
return $this->render('', array('name' => $name));
}
Select2 Form in "index.html.twig"
<select id='searchall' style="width: 300px">
</select>
Firebug console output after typing in the select2 search field:
GET http://localhost:8000/ajax/searchallSelect2?q=test 200 OK 16ms
My question is, how do I implement the database searching? Simply with getRepository in the AjaxController?
$allfaqs = $this->getDoctrine()
->getRepository('AppBundle:Faq')
->findAll();
Or do I need to search the database in the Ajax script?
Any help is greatly appreciated, thank you for reading!