wordpress中如何调用存储过程? [英] How call stored procedure in wordpress?

问题描述

我想调用之前在 wordpress 数据库中创建的 MySql 存储过程.但它总是返回一个空数组.我的代码有问题吗?在 MySql 提示符下运行此代码正确显示行.

I want to call a MySql store procedure which have made in wordpress database before. But It always returns an empty array. Is something wrong with my code? Running this code in MySql prompt show rows correctly.

public static function get_job_list($job_title = '', $qualify = '',$id = ''){
        global $wpdb, $table_prefix;
        $query = "SET @id='{$id}'; SET @job_title='{$job_title}'; SET @qualify='{$qualify}'; 
                        CALL `sp_job_list`(@id, @job_title, @qualify);";
        $result = $wpdb->get_results($query);
        return $result;
    }

推荐答案

问题是当我在调用(或任何其他语句)之前放置一些其他语句时，总是第一个语句是 SET @id='{$id}' 将运行并返回空数组.我应该只在我的查询中输入一个查询！！像这样:

The problem is that when I put some other statement before call(or any other statement) always first statement which is SET @id='{$id}' will run and it return empty array. I should put only one query into my query!! something like this:

query = "CALL 'sp_job_list'('{$id}', '{$job_title}', '{$qualify}');";

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