CodeIgniter query How to move a column value to another column in the same row and save the current time in the original column

Question

In my db table  I have two datetime columns  Last and Current  These column allow me to keep track of when someone last used a valid login to the service I am building up   Using CodeIgniter s active record  is it possible to update a row so that the Last value receives the Current value AND then the Current value is replace with the current datetime

User · Answer

if you want to upgrade only a single column of a table row then you can use as following    this- gt db- gt set  column header    value     value that used to update column    this- gt db- gt where  column id    column id value     which row want to upgrade    this- gt db- gt update  table name       table name

User · Answer

Try like this    data   array  current login    gt  date  Y-m-d H i s      this- gt db- gt set  last login    current login   false    this- gt db- gt where  id    some id     this- gt db- gt update  login table    data     Pay particular attention to the set   call s 3rd parameter   false prevents CodeIgniter from quoting the 2nd parameter -- this allows the value to be treated as a table column and not a string value   For any data that doesn t need to special treatment  you can lump all of those declarations into the  data array   The query generated by above code   UPDATE  login table  SET last login   current login   current login     2018-01-18 15 24 13  WHERE  id     some id

User · Answer

data   array        name         gt    POST  name           groupname    gt    POST  groupname          age          gt    POST  age        this- gt db- gt where  id     POST  id       this- gt db- gt update  tbl user    data

User · Answer

Yes  this is possible and I would like to provide a slight alternative to Rajeev s answer that does not pass a php-generated datetime formatted string to the query   The important distinction about how to declare the values to be SET in the UPDATE query is that they must not be quoted as literal strings   To prevent CodeIgniter from doing this  favor  automatically  use the set   method with a third parameter of false    userId   444   this- gt db- gt set  Last    Current   false    this- gt db- gt set  Current    NOW     false    this- gt db- gt where  Id    userId      return  this- gt db- gt get compiled update  Login        uncomment to see the rendered query  this- gt db- gt update  Login    return  this- gt db- gt affected rows        this is expected to return the integer  1   The generated query  depending on your database adapter  would be like this   UPDATE  Login  SET Last   Current  Current   NOW   WHERE  Id    444   Demonstrated proof that the query works  https   www db-fiddle com f vcc6PfMcYhDD87wZE5gBtw 0  In this case  Last and Current ARE MySQL Keywords  but they are not Reserved Keywords  so they don t need to be backtick-wrapped   If your precise query needs to have properly quoted identifiers  table column names   then there is always protectIdentifiers

[php] CodeIgniter query: How to move a column value to another column in the same row and save the current time in the original column?

Examples related to php

Examples related to mysql

Examples related to codeigniter

Examples related to activerecord

Examples related to sql-update