Question

thinkphp筛选问题

function queryRoom(){
$n = M("Use");
$day = $_REQUEST['day'];
$shiduan = $_REQUEST['shiduan'];
$condition[$shiduan] = "";
$condition['day'] = $day;
$list = $n->where($condition)->select();
$ids = "";
for($i=0;$i<count($list);$i++){
$use = $list[$i];
if($i == (count($list)-1)){
$ids.=$use['id'];
}else{
$ids.=$use['id'].",";
}
}
$r = M("Room");
$sql = "select * from rm_room where id in ($ids)";
$result = $r->query($sql);
n能不能详细解释下代码，特别是从for循环那里开始的

Answer 1

function queryRoom(){
$n = M("Use");
$day = $_REQUEST['day'];
$shiduan = $_REQUEST['shiduan'];
$condition[$shiduan] = "";
$condition['day'] = $day;
$list = $n->where($condition)->select(); //查询Use表的结果，结果是二位数组（多条记录）
$ids = "";
for($i=0;$i<count($list);$i++){ //循环查询到的结果集
$use = $list[$i];
if($i == (count($list)-1)){ //如果最后一条记录时
$ids.=$use['id'];
}else{ //非最后一条记录
$ids.=$use['id'].",";
}
}
$r = M("Room");
$sql = "select * from rm_room where id in ($ids)";
$result = $r->query($sql); //执行查询

追问

判断语录内的代码（ids.和.","）是在做什么操作啊？

追答

$ids为后面的$sql = "select * from rm_room where id in ($ids)";做准备
后面的是用where id in ($ids)
类似与where id in (1,2,3,4,5)