Inserting NOW into Database with CodeIgniter s Active Record

Question

I want to insert current time in database using mySQL function NOW   in Codeigniter s active record  The following query won t work    data   array           name    gt   name            email    gt   email           time    gt  NOW                       this- gt db- gt insert  mytable    data     This is because CodeIgniter   s ActiveRecord class automatically escapes the input   The following works fine  by calling set   and passing peratmeter FALSE  so that it doesn t escape the NOW      data   array           name    gt   name            email    gt   email                      this- gt db- gt set  time    NOW     FALSE            this- gt db- gt insert  mytable    data     However  my question is that is there any other way than this  For example  if i can use somehow use by adding everything in the data array only   For example  something like    data   array               name    gt   name                email    gt   email               time    gt  NOW    FALSE

User · Answer

I typically use triggers to handle timestamps but I think this may work    data   array       name    gt   name       email    gt   email      this- gt db- gt set  time    NOW     FALSE    this- gt db- gt insert  mytable    data

User · Answer

this- gt db- gt query  update table name set ts   now   where 1 1   also works for current time stamp

User · Answer

Using the date helper worked for me   this- gt load- gt helper  date      You can find documentation for date helper here    data   array     created    gt  now       modified    gt  now        this- gt db- gt insert  TABLENAME    data

User · Answer

According to the source code of codeigniter  the function set is defined as   public function set  key   value        escape   TRUE         key    this- gt  object to array  key        if     is array  key                  key   array  key   gt   value              foreach   key as  k   gt   v                if   escape     FALSE                         this- gt ar set  this- gt  protect identifiers  k      v                    else                        this- gt ar set  this- gt  protect identifiers  k  FALSE  TRUE      this- gt escape  v                        return  this      Apparently  if  key is an array  codeigniter will simply ignore the second parameter  value  but the third parameter  escape will still work throughout the iteration of  key  so in this situation  the following codes work  using the chain method     this- gt db- gt set array       name    gt   name        email    gt   email       time    gt   NOW          FALSE - gt insert  mytable      However  this will unescape all the data  so you can break your data into two parts    this- gt db- gt set array       name    gt   name        email    gt   email  - gt set array  time    gt   NOW          FALSE - gt insert  mytable

User · Answer

you can load the date helper and use the codeigniter interal now   if you want to reference the users GMT time offset  it woulk look somewhat like this   data   array   created on    gt  date  Y-m-d H i s  now         If you don t use the GTM master settings and let your users set their own offsets there is no advantage over using php s time   function

User · Answer

Unless I am greatly mistaken  the answer is   No  there is no way    The basic problem in situations like that is the fact that you are calling a MySQL function and you re not actually setting a value  CI escapes values so that you can do a clean insert but it does not test to see if those values happen to be calling functions like aes encrypt  md5  or  in this case  now    While in most situations this is wonderful  for those situations raw sql is the only recourse   On a side  date  Y-m-d    should work as a PHP version of NOW   for MySQL   It won t work for all versions of SQL though

User · Answer

data   array               name    gt   name                email    gt   email               time    gt date  Y-m-d H i s                               this- gt db- gt insert  mytable    data

User · Answer

run query to get now   from mysql i e select now   as nowinmysql   then use codeigniter to get this and put in    data  created on      row- gt noinmyssql   this- gt db- gt insert  data

User · Answer

putting NOW   in quotes won t work as Active Records will put escape the NOW   into a string and tries to push it into the db as a string of  NOW       you will need to use    this- gt db- gt set  time    NOW     FALSE      to set it correctly   you can always check your sql afterward with   this- gt db- gt last query

User · Answer

This is the easy way to handle timestamp insertion     data   array  created on    gt  date  Y-m-d H i s

User · Answer

aspirinemaga  just replace    this- gt db- gt set  time    NOW     FALSE    this- gt db- gt insert  mytable    data     for it    this- gt db- gt set  time    NOW     INTERVAL 1 DAY   FALSE    this- gt db- gt insert  mytable    data

[php] Inserting NOW() into Database with CodeIgniter's Active Record

Examples related to php

Examples related to mysql

Examples related to codeigniter