twig ajax异常,twig - Ajax with Symfony3 - Stack Overflow

I want to display a list of users dynamically but it doesn't work. I tested the query by itself and it works just fine yet it still doesn't show anything. This is the script

function showUser() {

// code for IE7+, Firefox, Chrome, Opera, Safari

xmlhttp = new XMLHttpRequest();

xmlhttp.onreadystatechange = function() {

if (this.readyState == 4 && this.status == 200) {

document.getElementById("user-list-div").innerHTML = xmlhttp.responseText;

}

};

xmlhttp.open("GET","{{ path('ajax_update')}}",true);

xmlhttp.send();

}

This is the controller action:

public function searchUsersAction(Request $request)

{

/*$em = $this->getDoctrine()->getManager();

$request = $this->get('request');*/

$projectName = $request->get('projectName');

echo($projectName);

//$projectId=$this->getDoctrine()->getRepository('SocialProMeetingBundle:meetingUser')->findName($projectName);

//echo(count($projectId));

//foreach($projectId as $pId) {

//$projectId->getPId();

$pus = $this->getDoctrine()->getRepository('SocialProMeetingBundle:meetingUser')->findProjectUsers($projectName);

//}

$response = "";

foreach($pus as $user){

$response . "" . $user . "";

}

$response = $response." ";

return new Response($response);

//return($pus);

//call repository function

}

and this is the query

public function findProjectUsers($projectName){

$query=$this->getEntityManager()

->createQuery(

"SELECT u.firstName FROM SocialProDefaultBundle:User u, SocialProProjectBundle:Project p, SocialProProjectBundle:ProjectUser pu WHERE u.id = pu.user AND p.id=pu.project AND p.name='$projectName'");

return $query->getResult();

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值