douzuan2814 2016-09-25 16:30
浏览 39
已采纳

Symfony2使用Select2和Ajax搜索数据库

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!

  • 写回答

2条回答 默认 最新

  • duanjuduo4573 2016-09-26 11:28
    关注

    Its up to you to write the queryBuilder in controller or in repository (Recommended) and call that in the controller. You shouldn't call ->findAll() in your repository as it will get you all data which you don't need. You need to filter data as per your request query parameter coming from ajax i.e. ?q=test. Below is a code snippet for your Controller.

    In your controller :

    /**
     * @Route("/ajax/searchallSelect2", name="ajax_searchall_select2")
     */
    public function searchallSelect2Action(Request $request)
    {
        $key = $request->query->get('q'); 
    
        // Find rows matching with keyword $key..
    
        $allfaqs = $this->getDoctrine()
        ->getRepository('AppBundle:Faq')->filterByKey($key);
    
        // customize your output as per Select2 requirement..
        return new JsonResponse($allfaqs);
    }
    

    In your Repository : (Considering you search against a 'name' property in FAQ.)

    /**
     * @param string $key
     *
     * @return type
     */
    public function filterByKey($key)
    {
        $qb = $this->createQueryBuilder('faq')
            ->andWhere('faq.name LIKE :key')
            ->setParameter('key', '%' . $key . '%')
            ->getQuery();
    
        return $qb->getQuery()->execute();
    }
    

    Hope it helps! Let me know your concerns otherwise.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 ansys fluent计算闪退
  • ¥15 有关wireshark抓包的问题
  • ¥15 需要写计算过程,不要写代码,求解答,数据都在图上
  • ¥15 向数据表用newid方式插入GUID问题
  • ¥15 multisim电路设计
  • ¥20 用keil,写代码解决两个问题,用库函数
  • ¥50 ID中开关量采样信号通道、以及程序流程的设计
  • ¥15 U-Mamba/nnunetv2固定随机数种子
  • ¥15 vba使用jmail发送邮件正文里面怎么加图片
  • ¥15 vb6.0如何向数据库中添加自动生成的字段数据。