SQL查找query

代码:

$user = new User();
// 先查一条,uid为2的
$this->findone = $user->find(array("uid"=>"2"));

// 查全部,用findAll
// findAll( $conditions=array(), $order=null, $field='*',  $limit=null )
// findAll参数:$conditions数组形式的条件(同find),$field指定字段(默认是*),
// $order是排序(如 “uid DESC”), $limit是限定条数(如“3,5”,第三条开始取五条)
$this->findall = $user->findAll();

结果(find):一位数组

<{if !empty($findone)}> <{foreach $findone as $k => $v}> <{/foreach}>
<{$k}> <{$v}>
<{else}>

没有结果!

<{/if}>

结果(findAll):多维数组

<{if !empty($findall)}> <{foreach $findall as $k => $v}> <{/foreach}>
<{$k}> <{foreach $v as $vk => $vv}> <{/foreach}>
<{$vk}> <{$vv}>
<{else}>

没有结果!

<{/if}>

返回到main/index