Codeigniter this- db- get how do I return values for a specific row

Question

Say I have a database table with three columns  ID  Name  and Age  I need to find the user with a specific  unique  ID  and then return the age  Currently  I am using the following code   this- gt db- gt where  id    3     q    this- gt db- gt get  my users table      How do I go about getting the age for this user  I think I have to use   q- gt result     But not sure how to use it with one row

User · Answer

Accessing a single row     Result as an Object  result    this- gt db- gt select  age  - gt from  my users table  - gt where  id    3  - gt limit 1 - gt get  - gt row    echo  result- gt age     Result as an Array  result    this- gt db- gt select  age  - gt from  my users table  - gt where  id    3  - gt limit 1 - gt get  - gt row array    echo  result  age

User · Answer

SOLUTION ONE   this- gt db- gt where  id    3       here we select every column of the table  q    this- gt db- gt get  my users table     data    q- gt result array     echo  data 0   age       SOLUTION TWO     here we select just the age column  this- gt db- gt select  age     this- gt db- gt where  id    3     q    this- gt db- gt get  my users table     data    q- gt result array     echo  data 0   age       SOLUTION THREE   this- gt db- gt select  age     this- gt db- gt where  id    3     q    this- gt db- gt get  my users table       if id is unique  we want to return just one row  data   array shift  q- gt result array      echo  data  age       SOLUTION FOUR  NO ACTIVE RECORD    q    this- gt db- gt query  SELECT age FROM my users table WHERE id      array 3     data   array shift  q- gt result array     echo  data  age

User · Answer

You simply use this in one row    query    this- gt db- gt get where  mytable  array  id   gt  3

User · Answer

Incase you are dynamically getting your data e g When you need data based on the user logged in by their id use consider the following code example for a No Active Record     this- gt db- gt query  SELECT   FROM my users table WHERE id        this- gt session- gt userdata  id       return  query- gt row array      This will return a specific row based on your the set session data of user

User · Answer

you can use row   instead of result      this- gt db- gt where  id    3     q    this- gt db- gt get  my users table  - gt row

[php] Codeigniter $this->db->get(), how do I return values for a specific row?

Examples related to php

Examples related to sql

Examples related to codeigniter