CODEWITHSUNDEEP
phpmysqlcodeignitermodel-view-controller
questionable
questionable

Reputation: 37

Get a single value from a result set returned from PHP codeigniter model

I am working on PHPStorm with a codeigniter framework and the MVC architecture. I need a function in my model that would query the sysuser table in my database and return the uid (User Id) when the username is passed.

sysuser Table structure

+---------------+----------------+-----------------+
|   uid         |     name       |     username    |
+---------------+----------------+-----------------+
|      1        |       kim      |    kcdla        |
+---------------+----------------+-----------------+
|      2        |       Sam      |    sammyG       |
+---------------+----------------+-----------------+

In my function, if I pass, for example, the username kcdla I need to retrieve the uid as 1 so that I can store this to a variable as $uid and return it to another function that will use it. But currently the result is an array and when I tried to access only the first cell from the array, I get an Exception.

Code in Context

public function getUserUid($username)
{
    $this->db->select("*");
    $this->db->from('sysuser');
    $this->db->where('username',$username);
    $query = $this->db->get();
    $tableArray = $query->result();
    foreach ($tableArray as $row) {
        $uid = $row->uid;
    }
    return $uid;
}

I need to use the $uid value returned from this method within another method as shown below.

public function getUserDetails($username)
{
    $uid = $this->userModel->getUserUid($username);
    $this->db->select("*");
    $this->db->from('userProfile');
    $this->db->where('uid',$uid);
    $query = $this->db->get();
    return $query->result();

}

Any suggestions in this regard will be highly appreciated.

Upvotes: 3

Views: 2435

Answers (2)

JYoThI
JYoThI

Reputation: 12085

call the function like this 

public function getUserDetails($username)
{
   $uid = $this->getUserUid($username);
            ^^^^^^^^^^^^^^^^^^^^^^^^^^
   $this->db->select("*");
   $this->db->from('userProfile');
   $this->db->where('uid',$uid);
   $query = $this->db->get();
   return $query->result();

}

Return the single row id like this

row(), returns only the first row. It's also an object, and if you need an array, you can use row_array()

public function getUserUid($username)
{
     $this->db->select("*");
     $this->db->from('sysuser');
     $this->db->where('username',$username);
     $query = $this->db->get();
     $row_values  = $query->row_array();
     return $row_values['uid'];
 }

As per your comment try this

        public function getUserDetails($username)
    {
        $uid = $this->userModel->getUserUid($username);
        $this->db->select("*");
        $this->db->from('userProfile');

        $this->db->join('another_table', 'another_table.uid = userProfile.uid');
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        $this->db->where('userProfile.uid',$uid);
        $query = $this->db->get();
        return $query->result();

    }

Upvotes: 0

Rejoanul Alam
Rejoanul Alam

Reputation: 5398

Try this. As you need single row based on username, you have to use row()(returns Object) or row_array() (returns array) instead of result() because result() or result_array() returns result set

public function getUserUid($username)
{
    $this->db->select("*");
    $this->db->from('sysuser');
    $this->db->where('username',$username);
    $query = $this->db->get();
    $row  = $query->row();
    return $row->uid;
}

Upvotes: 1

Related Questions