CodeIgniter - return only one row

Question

At the moment if I am doing a query on the database that should only return one row  using      query stuff     query    this- gt db- gt get     ret    query- gt result    return  ret 0 - gt campaign id    Is there a CodeIgniter function to return the first row  something like  query- gt row     Or even better would be the ability to  if there was only one row  to just use the query object directly   e g   query- gt campaign id

User · Answer

Change only in two line and you are getting actually what you want    query    this- gt db- gt get     ret    query- gt row    return  ret- gt campaign id    try it

User · Answer

class receipt model extends CI Model       public function index            this- gt db- gt select               this- gt db- gt from  donor details            this- gt db- gt order by  donor id   desc            query  this- gt db- gt get            row  query- gt row           return  row

User · Answer

You can do like this  q     this- gt db- gt get  - gt row     return  q- gt campaign id   Documentation   http   www codeigniter com user guide database results html

User · Answer

this- gt db- gt get  - gt row  - gt campaign id

User · Answer

This is better way as it gives you result in a single line    this- gt db- gt query  Your query  - gt row  - gt campaign id

User · Answer

To make the code clear that you are intending to get the first row  CodeIgniter now allows you to use   if   query- gt num rows    gt  0        return  query- gt first row        To retrieve the first row

User · Answer

You ve just answered your own question    You can do something like this    query    this- gt db- gt get     ret    query- gt row    return  ret- gt campaign id    You can read more about it here  http   www codeigniter com user guide database results html

User · Answer

We can get a single using limit in query   x000D   x000D   query    this- gt db- gt get where  mytable   array  id    gt   id    limit   offset   x000D   x000D   x000D      query    this- gt db- gt get where  mytable   array  id    gt   id    limit   offset

User · Answer

If you require to get only one record from database table using codeigniter query then you can do it using row    we can easily return one row from database in codeigniter    data    this- gt db- gt get  items  - gt row

User · Answer

To add on to what Alisson said you could check to see if a row is returned      Query stuff      query    this- gt db- gt get     if   query- gt num rows    gt  0         row    query- gt row         return  row- gt campaign id     return null     or whatever value you want to return for no rows found

[database] CodeIgniter - return only one row?

Examples related to database

Examples related to codeigniter