How to get data from database by using an array of ids in codeigniter?

Question

I have an id array in my controller that has checkbox input in a form in views. $toppings = $this->input->get('topping');

Array
(
  [0] => 1
  [1] => 3
  [2] => 4
)

I'm trying to get the information relevant to each id in the array from the database.

    $toppings = $this->input->get('topping');
    foreach ($toppings as $topping ) {
        $id = $topping;
        $toppinglist = $this->toppingmodel->find_topping($id);
        echo'<pre>'; print_r($toppinglist); die();

    }

Model Class -

function find_topping($id)
{
    $query = $this->db->get_where('Topping', array('id' => $id));
    return $query->row_array(); }

}

The output array i'm getting is only the data for the first id

Array
(
  [id] => 1
  [slug] => mushroom
  [toppingName] => Mushrooms
  [price] => 50.00
)

How can i get all the data relevant to each id in an array. (nested array) Thank you.

$this->db->where_in('Topping', $toppings);

mighty_dev
– mighty_dev

2020-11-03 05:35:03 +00:00
Commented Nov 3, 2020 at 5:35 — mighty_dev
– mighty_dev, Commented Nov 3, 2020 at 5:35

KUMAR · Accepted Answer · 2020-11-03 09:29:20Z

1

Controller:-

$toppings = $this->input->post('topping');    //Array         
$toppinglist = $this->toppingmodel->find_topping($toppings);

model:-

function find_topping($idArr = array()){         //Array  
 $query = $this->db->where_in("Topping", $idArr)->get("tablename");
     return $query->result_array();
}

Note:- $idArr = array() means

make the function have a default value of array otherwise if something else is passed you'll get an error in your query.

edited Nov 3, 2020 at 9:29

answered Nov 3, 2020 at 6:54

KUMAR

2,0952 gold badges14 silver badges27 bronze badges

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

7 Comments

CodeGirl Over a year ago

Still an error is thrown. Call to undefined method CI_DB_mysqli_driver::result_array().

KUMAR Over a year ago

ids are in comma seperated values in one column??

CodeGirl Over a year ago

ids are in an array. The array structure is shown at the top of the question

KUMAR Over a year ago

now try with my updated answer & let me know what happens??.

CodeGirl Over a year ago

Thank you so much. I'm getting the data array now

|

mail2bapi · Accepted Answer · 2020-11-03 05:52:15Z

0

You need to make your SQL query with WHERE IN().

In Codeignitor you can use $this->db->where_in($tableName, $arrayOfVales). Learn more here

Code Example

function find_topping(array $ids)
{
    $query = $this->db->where_in('Topping', $ids);
    return $query->result_array(); 
}

edited Nov 3, 2020 at 5:52

answered Nov 3, 2020 at 5:45

mail2bapi

1,6171 gold badge15 silver badges19 bronze badges

3 Comments

CodeGirl Over a year ago

How should i pass the id from the controller. I tried using db->where_in but now a type error is thrown saying Message: Argument 1 passed to toppingmodel::find_topping() must be of the type array, string given,

KUMAR Over a year ago

@Dilki Sasikala what you get in id or 'array` $toppings = $this->input->get('topping');

mail2bapi Over a year ago

You need to send an array of Ids to function find_topping();

Collectives™ on Stack Overflow

How to get data from database by using an array of ids in codeigniter?

2 Answers 2

7 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related