我正在开发一个Symfony2项目,我有一个用户实体,我需要一个ajax搜索栏来搜索我的用户.
问题是在我的 AJAX响应中,控制器由于某种原因返回数据库中的所有用户.

JS

$('#seArch').keyup(function() {

     searchText = $(this).val();

     $.ajax({
        tyPE: "GET",url: "/Apana/web/app_dev.PHP/search",dataType: "json",data: {searchText : searchText},success : function(response) 
          {
                console.LOG(response);
          }
    });
});

控制器

use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;

use Symfony\Component\Serializer\Serializer;
use Symfony\Component\Serializer\Encoder\XMlEncoder;
use Symfony\Component\Serializer\Encoder\JsonEncoder;
use Symfony\Component\Serializer\Normalizer\GetSetMethodNormalizer;

use Apana\Bundle\MainBundle\EntITy\User;

class SearchController extends Controller
{

    public function liveSearchAction(Request $request)
    {

        $string = $this->getRequest()->request->get('searchText');
        //$string = "alfa";
        $users = $this->getDoctrine()
                     ->getRepository('ApanaMainBundle:User')
                     ->findByLetters($string);

        //return users on JSON format

        $encoders = array(new XMLEncoder(),new JsonEncoder());
        $normalizers = array(new GetSetMethodNormalizer());
        $serializer = new Serializer($normalizers,$encoders);

        $jsonContent = $serializer->serialize($users,'json');

        $response = new Response($jsonContent);
        return $response;
    }
}

用户存储库

class UserRepository extends EntityRepository
{

    public function findByLetters($string){
        return $this->getEntityManager()->createQuery('SELECT u From ApanaMainBundle:User u  
                WHERE u.Firstname LIKE :string OR u.lastname LIKE :string')
                ->setParameter('string','%'.$string.'%')
                ->getResult();
    }
}

如果我为我的字符串参数提供静态文本并访问控制器的路由,它可以正常工作.

$.ajax({
        type: "GET",[...]

$.ajax({
        type: "POST",[...]

public function updateAction(Request $request)
{
    // $_GET parameters
    $request->query->get('name');

    // $_POST parameters
    $request->request->get('name');