How to get out put parameters of a mysql function in Codeigniter framework?

Question

I have a MySQL procedure GET_JOB_ID, output parameter is job_id. Then I call it from codeigniter

$data = $this->db->query("CALL GET_JOB_ID()");

Then how can I get the output parameter job_id from codeigniter?

VISHNU NEELANCHERI · Accepted Answer · 2018-03-04 07:46:14Z

1

I got the answer.

$job_id = 0;
    $this->load->database();   
    $job_data = $this->db->query("CALL GET_JOB_ID(@job_id)");
    $out_param_query = $this->db->query('select @job_id as job_id;'); 
    foreach ($out_param_query->result() as $key) {
        $job_id = $key->job_id;
    }
    $this->db->close();

answered Mar 4, 2018 at 7:46

VISHNU NEELANCHERI

871 silver badge11 bronze badges

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

Collectives™ on Stack Overflow

How to get out put parameters of a mysql function in Codeigniter framework?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related