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; } 

enter image description here

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

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -