无法从mysql查询中获取数据到控制器

时间:2023-01-30 09:43:51

Hello I am using codeigniter framework for a project, I have a controller which is calling the data from a model function. Here is the controller.

您好我正在为项目使用codeigniter框架,我有一个控制器,它从模型函数调用数据。这是控制器。

  public function getThirdPartyRR($token){
    if ($this->input->is_ajax_request()){
        // $data = json_decode(file_get_contents('php://input'), true);
        // Following is loaded automatically in the constructor.
        //$this->load->model('user_profile');
        $userid = $this->myajax->getUserByAuth($token);
        if ($userid){
            $this->load->model("riskrating_page");
            /* If we have an impersonated user in the session, let's use him/her. */
            if (isset($_SESSION['userImpersonated'])) {
                if ($_SESSION['userImpersonated'] > 0) {
                    $userid = $_SESSION['userImpersonated'];
                }
            }
            // $resultList value could be null also.
            $result = $this->riskrating_page->getThirdPartydata($userid);             
            /* Little bit of magic :). */
            $thirdpartylist = json_decode(json_encode($result), true); 
            $this->output->set_content_type('application/json');
            $this->output->set_output(json_encode($thirdpartylist));
        } else {
            return $this->output->set_status_header('401', 'Could not identify the user!');
        }
    } else {
        return $this->output->set_status_header('400', 'Request not understood as an Ajax request!');
    }   
}

And here is the query function in the model where I get the data from.

这里是模型中的查询函数,我从中获取数据。

function getThirdPartydata($id){

      $query = 'SELECT b.text_value as Company, a.third_party_rr_value
                FROM user_thirdparty_rr a 
                inner join text_param_values b
                    on a.third_party_rr_type = b.text_code and
                    b.for_object = \'user_thirdparty_rr\'
                WHERE a.Owner = '.$id. ' and 
                    a.UPDATE_DT is null;';

    }

But when I debug it using netbeans, its shows that in my controller in the $result function I get null meaning I couldnt grab any data from mysql.

但是当我使用netbeans调试它时,它显示在$ result函数的控制器中我得到null意味着我无法从mysql中获取任何数据。

Here is the search result from mysql. 无法从mysql查询中获取数据到控制器

这是mysql的搜索结果。

1 个解决方案

#1


1  

You only write your query not fetch any data from your query result

您只编写查询而不从查询结果中获取任何数据

function getThirdPartydata($id){

      $query = "SELECT b.text_value as Company, a.third_party_rr_value
            FROM user_thirdparty_rr a 
            inner join text_param_values b
                on a.third_party_rr_type = b.text_code and
                b.for_object = 'user_thirdparty_rr'
            WHERE a.Owner = '$id' and 
                a.UPDATE_DT is null";
             $this->db->query($query);// execute your query
             return $query->result_array();// fetch data

    }

#1


1  

You only write your query not fetch any data from your query result

您只编写查询而不从查询结果中获取任何数据

function getThirdPartydata($id){

      $query = "SELECT b.text_value as Company, a.third_party_rr_value
            FROM user_thirdparty_rr a 
            inner join text_param_values b
                on a.third_party_rr_type = b.text_code and
                b.for_object = 'user_thirdparty_rr'
            WHERE a.Owner = '$id' and 
                a.UPDATE_DT is null";
             $this->db->query($query);// execute your query
             return $query->result_array();// fetch data

    }