如何在CodeIgniter中调用存储过程？ [英] How to call a stored procedure in CodeIgniter?

问题描述

我无法在CodeIgniter中调用存储过程。但是，当我直接在MySQL中调用过程，它的工作原理。为什么我在CodeIgniter中调用它时不工作？

I can't call a stored procedure in CodeIgniter. However, when I call the procedure directly in MySQL, it works. Why isn't it working when I call it in CodeIgniter?

CREATE DEFINER=`root`@`localhost` PROCEDURE `test_proc`()
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
  declare name1 TEXT;
  declare id1 TEXT;
  select name,id into name1,id1 from my_tbl WHERE name='sam';
  select * from my_tbl;
  select name1,id1;
END

推荐答案

以下调用过程。

$this->db->call_function('test_proc');

错了。只能使用此方法调用默认过程。
要调用你定义的过程，你必须使用

Its wrong. Only default procedures can be called using this method. To call procedures defined by you, you have to go with

$this->db->query("call test_proc()");

这篇关于如何在CodeIgniter中调用存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！