如何在循环中执行存储过程

Question

I am facing an issue. Please have a look at the 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);    
}

The problem is that the loop only executes a single time. Note that I am using the Phalcon framework.

Answer 1

Your index is id but this does not make sense and therefore you call the stored procedure with the same - undefined - value. Fix the parameter of the stored procedure.