String datetime insert into mysql database with codeigniter

Question

I am having following MySQL table

EventId     ObjectKey   Title           Description     When        Duration        Where           Status
INT         CHAR(36)    VARCHAR(500)    VARCHAR(8000)   DATETIME    VARCHAR(500)    VARCHAR(500)    TINYINT

and my PHP array is

$data = array(
    'Title' => $title,
    'Description' => $description,
    'When' => $when,
    'Duration' => $duration,
    'Where' => $where
);

The variable $when contains 02/21/2013. When I try to insert to the table with CodeIgniter

public function insert_event($guid, $data)
{
    $CI = & get_instance();
    $CI->load->database('default');
    $CI->db->set($data);
    $CI->db->set('ObjectKey', $guid);
    $CI->db->set('Status', 1);
    $vari = $CI->db->insert('Events');
    return $vari;
}

Everything inserted correctly except date. Can you help me on this?

Madan Sapkota · Accepted Answer · 2013-02-13 10:16:32Z

14

Use the correct MYSQL format for the date YYYY-MM-DD. For example change this in your code:

$data = array(
    'Title' => $title,
    'Description' => $description,
    'When' => date('Y-m-d', strtotime($when)),
    'Duration' => $duration,
    'Where' => $where
);

edited Feb 13, 2013 at 10:16

Madan Sapkota

26.2k11 gold badges116 silver badges118 bronze badges

answered Feb 13, 2013 at 8:29

m4t1t0

5,7313 gold badges25 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Madan Sapkota · Accepted Answer · 2013-02-13 10:14:49Z

4

Dates in mySQL are YYYY-MM-DD

You are inserting a date MM/DD/YYYY

So try this:

$data = array(
    'Title' => $title,
    'Description' => $description,
    'When' => date('Y-m-d', strtotime($when)),
    'Duration' => $duration,
    'Where' => $where
);

edited Feb 13, 2013 at 10:14

Madan Sapkota

26.2k11 gold badges116 silver badges118 bronze badges

answered Feb 13, 2013 at 8:28

Laurence

60.3k22 gold badges178 silver badges215 bronze badges

Comments

Andriy Petrusha · Accepted Answer · 2019-05-29 11:30:32Z

1

Simplest way to store string date in any format in mysql

$srcFormat = "m/d/Y"; //convert string to php date
$destFormat = "Y-m-d" //convert php date to mysql date string

$data = array(
  'Title' => $title,
  'Description' => $description,
  'When' => DateTime::createFromFormat($srcFormat, $when)->format($destFormat),
  'Duration' => $duration,
  'Where' => $where
);

edited May 29, 2019 at 11:30

answered May 29, 2019 at 8:52

Andriy Petrusha

1291 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

String datetime insert into mysql database with codeigniter

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related