Build CodeIgniter query from the results of another query [duplicate]

Question

I have the following CI query builder query

$query_teams = $this->db->get_where('teams_in_cups', array('cup_id' => 2));
$team_ids = $query_teams->result_array();

I want $team_ids (which currently outputs two ids -> 22 and 25) to be compatible with the following query:

$this->db->where_in('id', $team_ids);    
$query_team_details = $this->db->get('teams');

In the second query, $team_ids should look like the following array(22,25);

I tried foreach(), implode(), explode(), but couldn't manage to get it to work.

Bikram Pahi · Accepted Answer · 2017-04-19 10:31:25Z

1

You can use MySQL join to get the desired result.

I am fixing your current situation only.

$query_teams = $this->db->get_where('teams_in_cups', array('cup_id' => 2));
$team_data=$query_teams->result();
team_ids='';
foreach($team_data as $td)
{
   $team_ids=$team_id.','.$td->team_id;
}
$team_ids=ltrim($team_ids,',');
$this->db->where_in('id', $team_ids);    
$query_team_details = $this->db->get('teams');

answered Apr 19, 2017 at 10:31

Bikram Pahi

1,1931 gold badge14 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Tibor Over a year ago

Thanks for fast answer,but '$td->team_id' returns undefined variable error. In MySQL the column name is team_id so I don't know why could it be?

Bikram Pahi Over a year ago

use your own database table column name in place of team_id. I have just given one example.

Tibor Over a year ago

inside the foreach, what does the variable $team_id do? Because it is not defined anywhere.

Bikram Pahi Over a year ago

This is an imaginary item, I added, as you have not given the table structure. update the code as per the table structure or update the question with table structure, I will update the solution.

mickmackusa Oct 24 at 2:36

There is no reason to perform 2 trips to the database. where_in() expects an array of values as the second parameter. This answer should not be used.

Collectives™ on Stack Overflow

Build CodeIgniter query from the results of another query [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related