SQL查询query

代码:

$user = new User();
$uid = 3;
// 准备SQL,查询uid大于3的
$sql = "SELECT * FROM test_user WHERE uid > :uid";

// query第一个参数是SQL语句,第二个参数是绑定参数的列表
$this->findall = $user->query($sql, array(
	":uid" => $uid, // 注意这种绑定参数的做法,可以防止SQL注入
));

结果:多维数组

<{foreach $findall as $k => $v}> <{/foreach}>
<{$k}> <{foreach $v as $vk => $vv}> <{/foreach}>
<{$vk}> <{$vv}>

返回到main/index