CodeIgniter Forums
Mysql Procedure get out parameter - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Mysql Procedure get out parameter (/showthread.php?tid=40299)



Mysql Procedure get out parameter - El Forum - 04-05-2011

[eluser]Aspi[/eluser]
Dear Forum Members,

How can I get function outparameter with codeigniter:
Code:
$query = $this->db->query('CALL sp_gen_iktatoszam(@iktatsz_out,@age)');
  $query1 = $this->db->query('SELECT @iktatsz_out');
    foreach ($query1->result_array() as $row){
    $data = $row;
    }
     return $data;

database.php =>
$db[‘default’][‘dbdriver’] = ‘mysqli’;
$db[‘default’][‘pconnect’] = TRUE;

Thank you for your help