title: Inserting NOW() into Database with CodeIgniter's Active Record
body: <p>I want to insert current time in database using mySQL function NOW() in Codeigniter's active record. The following query won't work:</p>
  
  <pre><code>$data = array(
          'name' =&gt; $name ,
          'email' =&gt; $email,
          'time' =&gt; NOW()
          );
          $this-&gt;db-&gt;insert('mytable', $data);
  </code></pre>
  
  <p>This is because CodeIgniter’s ActiveRecord class automatically escapes the input.</p>
  
  <p>The following works fine, by calling set() and passing peratmeter FALSE, so that it doesn't escape the NOW().</p>
  
  <pre><code>$data = array(
          'name' =&gt; $name ,
          'email' =&gt; $email,
          );
          $this-&gt;db-&gt;set('time', 'NOW()', FALSE);
          $this-&gt;db-&gt;insert('mytable', $data);
  </code></pre>
  
  <p>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:</p>
  
  <pre><code>$data = array(
              'name' =&gt; $name ,
              'email' =&gt; $email,
              'time' =&gt; NOW(), FALSE
              );
  </code></pre>