Stored Procedure not working |
I have issue in call stored procedure with null value in Codeigniter 3.
I'm trying this in Model Code: $foo_sql = $this->db->query('call getFooData(' . $foo_id . ', "' . $fooname . '")'); Also I tried with Quote:call getFooData(2152, NULL) Code: DELIMITER $$ some time $fooname is null at that time CI3 return below error Quote:Call to a member function fetch_assoc() on boolean Please help me how to fix it.
Try it like this and see if it works, not tested.
PHP Code: $foo_sql = $this->db->query("call getFooData('{$foo_id}', '{$fooname}');"); What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
Did some more researching on this and found this article on it.
Stored procedure in codeigniter Hope that helps, What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
I have tried this Url but did not get solution. I think we need send this to CI's Developer.
I know in the older versions that they had to hack the core database and add a mysql_fetch_next method.
But I do not believe in hacking the core! What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
|
Welcome Guest, Not a member yet? Register Sign In |