Using MySQL NOW() in Codeigniter

gistfile1.aw

<?php
// Using MySQL NOW() in Codeigniter
// by daveganley
// There are two easy ways to do this

// With NOW()

$data = array(
    'field_name' => 'some_data'
);
$this->db->set('date_field_name', 'NOW()', FALSE);
$this->db->insert('table_name', $data);
// The FALSE in the set method prevents the NOW() being escaped

// Without NOW()

$now = date('Y-m-d H:i:s');
$data = array(
    'field_name' => 'some_data',
    'date_field_name' => $now
);
$this->db->insert('table_name', $data);

field_name

Commented 5 minutes ago