multiple where condition codeigniter

Question

How can I convert this query to active record    UPDATE table user   SET email     email   last ip     last ip    where username     username  and status     status      I tried to convert the query above to    data   array  email    gt   email   last ip    gt   ip    this- gt db- gt where  username   username    this- gt db- gt update  table user   data     How about using the where clausa status     must i write db- gt where two times like this   this- gt db- gt where  username   username    this- gt db- gt where  status   status     I also tried this    this- gt db- gt where  username   username  status   status

User · Accepted Answer

you can use an array and pass the array   Associative array method   array   array  name    gt   name   title    gt   title   status    gt   status     this- gt db- gt where  array        Produces  WHERE name    Joe  AND title    boss  AND status    active    Or if you want to do something other than   comparison   array   array  name       gt   name   id  lt     gt   id   date  gt     gt   date     this- gt db- gt where  array

User · Answer

wherecond          username        username      OR status       status       AND  id       id                      this- gt db- gt where  wherecond       If you want to add AND and OR conditions at a time  this will work

User · Answer

Yes  multiple calls to where   is a perfectly valid way to achieve this    this- gt db- gt where  username   username    this- gt db- gt where  status   status     http   www codeigniter com user guide database query builder html

User · Answer

Try this    data   array                  email    gt  email                  last ip    gt   last ip                  where   array  username     gt   username    status     gt   status    this- gt db- gt where  where    this- gt db- gt update  table user     data

User · Answer

you can try this function for multi-purpose   function ManageData  table name     condition array    udata array    is insert false    resultArr   array     ci    amp  get instance    if  condition  amp  amp  count  condition        ci- gt db- gt where  condition   if  is insert         ci- gt db- gt insert  table name  udata       return 0    else        ci- gt db- gt update  table name  udata       return 1

User · Answer

you can use both use array like     array   array  tlb account crid    gt  value    tlb request sign   gt   FALSE       and direct assign like    this- gt db- gt where  tlb account crid    gt  value    tlb request sign   gt   FALSE      I wish help you

User · Answer

it s late for this answer but i think maybe still can help  i try the both methods above  using two where conditions and the method with the array  none of those work for me i did several test and the condition was never getting executed  so i did a workaround  here is my code   public function validateLogin  email   password            password   md5  password            this- gt db- gt select  userID email password             query    this- gt db- gt get where  users   array  email    gt   email             p    query- gt row array             if  query- gt num rows      1  amp  amp   password     p  password                   return  query- gt row

[codeigniter] multiple where condition codeigniter

Examples related to codeigniter