execute mysql stored procedures with CodeIgniter

[eluser]xwero[/eluser]
You have to use the mysqli driver but there are no functions added to call stored procedures so you have to add them yourself or use the call_function method. If would be something like this

Code:

$stmt = $this->db->call_function('stmt_init',$this->db->conn_id;);
if ($this->db->call_function('stmt_prepare',$stmt, 'SELECT District FROM City WHERE Name=?')) {

    /* bind parameters for markers */
    $this->db->call_function('stmt_bind_param',$stmt, "s", $city);

    /* execute query */
    $this->db->call_function('stmt_execute',$stmt);

    /* bind result variables */
    $this->db->call_function('stmt_bind_result',$stmt, $district);

    /* fetch value */
    $this->db->call_function('stmt_fetch',$stmt);

    printf("%s is in district %s\n", $city, $district);

    /* close statement */
    $this->db->call_function('stmt_close',$stmt);
}

I took the example from php.net because i never used it but at least you get the idea how it can be done.