这是HTML代码
<form action="" method="post" id="personal-index" class="personal-index">
<table border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="2" align="center"><a href="" id="header"><img src="http://img1.2345.com/duoteimg/qqTxImg/11/2012091910313510745.jpg" width="60" height="60" id="avatar"><span id="username">头像</span></a></td>
</tr>
<tr>
<td align="center"><a href="{{ path('user_personal_points') }}">积分:245</a></td>
<td align="center"><a href="{{ path('user_personal_coupon') }}">优惠券:3</a></td>
</tr>
<tr>
<td align="center"><a href="{{ path('user_personal_recharge') }}">充值</a></td>
<td align="center"><a href="">消费记录</a></td>
</tr>
<tr>
<td align="center"><a href="{{ path('user_personal_points') }}">我的积分</a></td>
<td align="center"><a href="{{ path('user_personal_coupon') }}">我的优惠券</a></td>
</tr>
<tr>
<td align="center"><a href="javascript:;">适用门店</a></td>
<td align="center"><a href="">二维码</a></td>
</tr>
<tr>
<td align="center"><a href="{{ path('user_personal_info') }}">个人信息</a></td>
<td align="center"><a href="{{ path('user_personal_coupon') }}">使用帮助</a></td>
</tr>
</tbody>
</table>
</form>
这是 路由
user_personal:
path: /personal
defaults: { _controller: UserBundle:Personal:index }
这是控制器
public function indexAction()
{
// $user_id =$this->getSession('user_id');
$user_id =1;
if (empty($user_id)) {
return $this->redirect($this->generateUrl('user_index'));
} else {
$conn = $this->get('database_connection');
$user = $conn->fetchAssoc("SELECT id, avatar, avatar_update, name, points FROM user WHERE id =?", array($user_id));
$coupon = $conn->fetchColumn("SELECT COUNT(id) FROM user_coupon WHERE user_id =? AND is_used = 0 AND end_date >= NOW()", array($user_id));
}
return $this->render('UserBundle:Personal:index.html.twig', array('user' => $user, 'coupon' => $coupon));
}
我要怎么写代码,才能把数据库的avatar,points,在页面加载时显示在头像和积分上,而不是我在HTML代码里自己填的,听说用AJAX,但是不会写,求告知代码