How to execute store procedure in loop.

Question

amolra Jul '16

Created Jul '16	Last Reply Jul '16	Replies 1	Views 457	Votes 0

amolra 7.7k

Hi Team,

I am facing one issue. Please have a look on below code.

// $data having 1000 entries

foreach($data as $key=>$value) {

$resultStore = $this->db->query("call get_parents(" . $value['id'] . ")");

$dataStore = $resultStore->fetchAll(PDO::FETCH_ASSOC);

}

But this loop execute only one time.

Please let me know if anyone have solution for this.

Thanks, Amol

le51 · Answer 1 · 2016-07-30T06:18:29-07:00

Hi,

on each loop step $resultStore and $resultStore are overwriten by te new db queries. So, you have only one result in them.