Insert Current DateTime in Codeigniter 3.0.6

Question

I'm trying to store user signup date and time using codeigniter 3.0.6 and using

NOW()

as

 $this->db->set('user_nicename', $nameVar);
   $this->db->set('user_login', $emailVar);
   $this->db->set('user_pass', $passwordVar);
   $this->db->set('user_registered', 'NOW()');
   $this->db->insert('doc_users');

but it is not storing date time in database

see database image

try this http://stackoverflow.com/questions/6354315/inserting-now-into-database-with-codeigniters-active-record — Abhishek Sharma, Dec 22 '15 at 11:10

Abdulla Nilam · Answer 1 · 2015-12-22T11:11:08.333

15

use date() like this

date('Y-m-d H:i:s'); # output 2015-12-22 16:41:25

Final Code is

date_default_timezone_set('Asia/Karachi'); # add your city to set local time zone
$now = date('Y-m-d H:i:s');

$this->db->set('user_nicename', $nameVar);
$this->db->set('user_login', $emailVar);
$this->db->set('user_pass', $passwordVar);
$this->db->set('user_registered', $now);
$this->db->insert('doc_users');

edited Dec 22 '15 at 11:11

answered Dec 22 '15 at 11:07

Abdulla Nilam

36,589
17
64
85

use `date_default_timezone_set` – Abdulla Nilam Dec 22 '15 at 11:11
returning 0000-00-00 00:00:00 – Kashif Latif Dec 22 '15 at 11:14
1

set your database field to `DATETIME` – Abdulla Nilam Dec 22 '15 at 11:15
i need globally time not for only one country – Kashif Latif Dec 22 '15 at 11:16
UTC time or your local time?/ – Abdulla Nilam Dec 22 '15 at 11:16
UTC is one not depends on each and other – Abdulla Nilam Dec 22 '15 at 11:17
@KashifLatif try with `gmdate` – Abdulla Nilam Dec 22 '15 at 11:18
You have to store all in 1 format. Not separate formats !! – Abdulla Nilam Dec 22 '15 at 11:22
`date_default_timezone_set('Asia/Karachi');` this code is working fine for only pakistan, but i need a globally solution – Kashif Latif Dec 22 '15 at 11:25
what about this `date_default_timezone_set('UTC');` – Abdulla Nilam Dec 22 '15 at 11:26
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/98724/discussion-between-kashif-latif-and-abdulla). – Kashif Latif Dec 22 '15 at 16:42

Kashif Latif · Accepted Answer · 2015-12-22T17:56:01.657

6

this works for me in Codeigniter 3.0.6

$this->db->set('user_registered', 'NOW()', FALSE);

edited Dec 22 '15 at 17:56

answered Dec 22 '15 at 11:43

Kashif Latif

657
3
15
29

score 3 · Answer 3 · answered Dec 22 '15 at 11:09

try this

first load date helper

To follow ci structure you have to use mdate() function otherwise you can also use date function

$this->db->set('user_nicename', $nameVar);
$this->db->set('user_login', $emailVar);
$this->db->set('user_pass', $passwordVar);
$this->db->set('user_registered', mdate("%Y-%m-%d %H:%i:%s"));
$this->db->insert('doc_users');

score 0 · Answer 4 · answered Dec 22 '15 at 22:19

I would recommend using load the date helper.

mdate('%Y-%m-%d %H:%i:%s', now());

There is no need to use multiple sets you could simply put it in a array.

$data = array(
   'user_nicename' => $nameVar,
   'user_login' => $emailVar,
   'user_pass' => $passwordVar,
   'user_registered' => mdate('%Y-%m-%d %H:%i:%s', now())
);

$this->db->set($data);
$this->db->insert('doc_users');

Also make sure your user_registered database type is DATETIME

To set your current date_time_zone

Go to the config.php and add the code below

Example: date_default_timezone_set('Pacific/Auckland');

For your time zone you can find list here http://php.net/manual/en/timezones.php

score 0 · Answer 5 · edited Jan 07 '18 at 15:16

0

$data = [
    'type'=>$this->input->post('txttype')
    //for getting input value of form
];

$this->db->set('column_name', 'NOW()', FALSE);

$this->db->insert('table_name', $data);

edited Jan 07 '18 at 15:16

marc_s

732,580
175
1,330
1,459

answered Jan 25 '17 at 09:31

Abdulrehman

1
1

score 0 · Answer 6 · answered May 23 '18 at 02:56

0

Also you can make a DB query to get current DB date/time:

$this->db->select('NOW() as db_date')->get()->row()->db_date

answered May 23 '18 at 02:56

Cravciuc Andrei

1
1

score 0 · Answer 7 · answered May 23 '18 at 04:36

In Codeigniter, you have to load date helper as $this->load->helper('date');. than after you have to define city for timezone as date_default_timezone_set('Asia/Kolkata');.than after you can set your time zone according your requirnment.

$this->load->helper('date'); // load Helper for Date 

date_default_timezone_set("UTC");
echo $date=gmdate("F j, Y").'<br>'; // ie. May 23, 2018

if (function_exists('date_default_timezone_set'))
{
  date_default_timezone_set('Asia/Kolkata'); // Specify your time zone according to your city
}

date_default_timezone_set('Asia/Kolkata'); // Defined City For Timezone
$currentDate =time();
$datestring = '%Y-%m-%d - %h:%i %a';
$time = time();
$better_date= mdate($datestring, $time).'<br>'; //  i.e : 2018-05-23 - 09:52 am | For AM | PM result
$c_date=date("Y-m-d H:i:s").'<br>'; // 2018-05-23 09:52:36 | For Seconds Result

// Insert Date and Time to the Database

$data=array(
  'name'    =>'Rudra',
  'email' =>'test@me.com',
  'city'    =>'Kolakata',
  'data_time_on'=>$c_date
);

$this->db->insert('tableName',$data);

Insert Current DateTime in Codeigniter 3.0.6

7 Answers7