java for循环返回值_CodeIgniter中foreach循环中的返回值

function returnStuff($search_for_area,$search_for_requirement) {

$arr_area = array();

$arr_filter = array();

if ( ! empty($search_for_area) and ! empty($search_for_requirement)) {

foreach($search_for_requirement as $search_value_1) {

foreach($search_for_area as $search_value_2) {

if($search_value_2 != null && $search_value_1 != null) {

$arr_area[] = $this->db->escape($search_value_2);

$arr_filter[] = $this->db->escape_like_str($search_value_1);

}

}

}

}

$str_area = 'NULL';

if ($arr_area)

$str_area = implode(', ', $arr_area);

$str_filter = "'^-$'";

if ($arr_filter)

$str_filter = "'(".implode('|', $arr_filter).")'";

$query = $this->db->query("

SELECT name, area, contactno

FROM tut_listing

WHERE area IN ({$str_area}) AND categoryfilter REGEXP {$str_filter} and partner > '' group by name

");

return $query->result();

}

说真的，请考虑这种方法 . 您只需要通过一次调用来打扰可怜的Mysql服务器，就可以同时获得所需的所有数据 .

除此之外，在代码中练习一致的样式 . 从长远来看，它将节省您的时间和头发 .