php - Possible to break statement in foreach loop? -
i have 2 tables (user
,user_group
). user table contains
------------+-------------+------------------+ | user_id | user_name | user_group(id) | ------------+-------------+------------------+
and user_group
table contains
+-----------------+-------------------+ | user_group_id | user_group_name | +-----------------+-------------------+
now try join them without using join
query. solve problem have used double foreach()
loop, no result returns. can't use break
statement. how can desired result using loop? desired result be:
+-----------+-------------+-------------------+ | user_id | user_name | user_group_name | +-----------+-------------+-------------------+
what have far:
public function user_get_item() { $this->db->select('*'); $this->db->from('users'); $results=$this->db->get()->result_array(); $this->db->select('*'); $this->db->from('user_group'); $group_data=$this->db->get()->result_array(); foreach($results $v_results) { foreach($group_data $v_group_data) { if($v_results['user_group']==$v_group_data['user_group_id']) { $v_results['user_group']=$v_group_data['user_group_name']; } } } return $results; }
i think trying changing group id identifier group name in current row if match. so, replace:
$results['user_group']=$v_group_data['user_group_name'];
by:
$v_results['user_group']=$v_group_data['user_group_name'];
anyway, what's wrong joins? making sql queries faster polynomic loop.
Comments
Post a Comment