Welcome Guest, Not a member yet? Register   Sign In
how to cal store procedure in codeginter 2.x
#1

[eluser]teddy[/eluser]
I read some topics and confuse way to call mysql store procedure, I don't know where is my wrong if I did like below

1. change to $db['default']['dbdriver'] = 'mysqli';
2. $db['default']['pconnect'] = TRUE; ???? exactly set is FALSE or TRUE, current I set FALSE

after make it all I get error when call a second store procedure, first store procedure is ok

Fatal error: Call to a member function result() on a non-object in ....


Model

Code:
return $this->db->query('call get_loai_deal()')->result();


Other question I want, can I get result_array when call $this->db->query('call store procedure')->result_array()


Messages In This Thread
how to cal store procedure in codeginter 2.x - by El Forum - 01-27-2013, 02:18 AM
how to cal store procedure in codeginter 2.x - by El Forum - 01-27-2013, 10:08 AM
how to cal store procedure in codeginter 2.x - by El Forum - 02-21-2013, 11:31 AM



Theme © iAndrew 2016 - Forum software by © MyBB