title: codeigniter insert current time in database by controller
body: <p>here is my controller code to insert data into database</p>
  
  <pre><code>$datau = array(
      'reg_no' =&gt; $firstname,
      'fee_type' =&gt; $productinfo,
      'transaction_id' =&gt; $txnid,
      'status' =&gt; '0'
  );
  $this-&gt;db-&gt;insert('payment_status', $datau);
  $this-&gt;load-&gt;view('fail', $data);
  </code></pre>
  
  <p>this was working perfectly but when I try to add time like this:</p>
  
  <pre><code>$datau = array(
      'reg_no' =&gt; $firstname,
      'fee_type' =&gt; $productinfo,
      'transaction_id' =&gt; $txnid,
      'status' =&gt; '0',
      'time' =&gt; NOW()
  );
  $this-&gt;db-&gt;insert('payment_status', $datau);
  $this-&gt;load-&gt;view('fail', $data);
  </code></pre>
  
  <p>it returns an error like</p>
  
  <blockquote>
    <p>Fatal error: Call to undefined function NOW() in
    D:\xampp\htdocs\iiht\application\controllers\Status.php on line 47</p>
  </blockquote>