CodeIgniter Select Query

Question

I have a simple CodeIgniter Active record query to select an ID    q    this - gt  db            - gt  select  id              - gt  where  email    email             - gt  limit 1             - gt  get  users      How can I assign the above ID to a variable  eg   id   For example    echo  ID is     id    Thanks

User · Answer

one short way would be    id    this - gt  db        - gt  select  id          - gt  where  email    email         - gt  limit 1         - gt  get  users          - gt  row          - gt id  echo  ID is    id

User · Answer

This is your code   q    this - gt  db        - gt  select  id          - gt  where  email    email         - gt  limit 1         - gt  get  users      Try this   id    q- gt result   0 - gt id    or this one  it s simpler   id    q- gt row  - gt id

User · Answer

function news get by id    news id           this- gt db- gt select            this- gt db- gt select  DATE FORMAT  date    d  m  Y    as date human    FALSE         this- gt db- gt select  DATE FORMAT  date    H  i   as time human        FALSE           this- gt db- gt from  news          this- gt db- gt where  news id    news id           query    this- gt db- gt get         if    query- gt num rows    gt  0                  row    query- gt row array            return  row              This

User · Answer

query   this- gt m general- gt get  users    array  id   gt   id     echo  query        is ok

User · Answer

public function getSalary                  this- gt db- gt select  tbl salary   tbl employee empFirstName             this- gt db- gt from  tbl salary             this- gt db- gt join  tbl employee   tbl employee empID   strong texttbl salary salEmpID             this- gt db- gt where  tbl salary status  0            query    this- gt db- gt get            return  query- gt result

User · Answer

Thats quite simple  For example  here is a random code of mine     function news get by id    news id           this- gt db- gt select            this- gt db- gt select  DATE FORMAT  date    d  m  Y    as date human    FALSE         this- gt db- gt select  DATE FORMAT  date    H  i   as time human        FALSE           this- gt db- gt from  news          this- gt db- gt where  news id    news id           query    this- gt db- gt get         if    query- gt num rows    gt  0                  row    query- gt row array            return  row                This will return the  row  you selected as an array so you can access it like      array   news get by id   1    echo  array  date human      I also would strongly advise  not to chain the query like you do  Always have them separately like in my code  which is clearly a lot easier to read     Please also note that if you specify the table name in from    you call the get   function without a parameter     If you did not understand  feel free to ask

User · Answer

When use codeIgniter Framework then refer this active records link  how the data interact with structure and more   The following functions allow you to build SQL SELECT statements    Selecting Data   this- db- get     Runs the selection query and returns the result  Can be used by itself to retrieve all records from a table    query    this- gt db- gt get  mytable      With access to each row   query    this- gt db- gt get  mytable     foreach   query- gt result   as  row        echo  row- gt title      Where clues   this- gt db- gt get where      EG     query    this- gt db- gt get where  mytable   array  id    gt   id    limit   offset     Select field   this- gt db- gt select  title  content  date      query    this- gt db- gt get  mytable        Produces  SELECT title  content  date FROM mytable   E G   this- gt db- gt select   SELECT SUM payments amount  FROM payments WHERE payments invoice id 4   AS amount paid   FALSE     query    this- gt db- gt get  mytable

User · Answer

use Result Rows  row   method returns a single result row    id    this      - gt  db     - gt  select  id       - gt  where  email    email      - gt  limit 1      - gt  get  users       - gt  row      then  you can simply use as you want      echo  ID is     id

User · Answer

echo  this- db- select  title  content  date  - get compiled select

User · Answer

Here is the example of the code   public function getItemName          this- gt db- gt select  Id Name         this- gt db- gt from  item         this- gt db- gt where array  Active    gt  1        return  this- gt db- gt get  - gt result

[php] CodeIgniter Select Query

Examples related to php

Examples related to mysql

Examples related to codeigniter

Examples related to variables

Examples related to select