Jump to content
Larry Ullman's Book Forums

Inserting Current Datetime

Recommended Posts

Sorry, I have to ask this but I have not been able to find a solution via Google search for something that should be simple!!

My usertype table has a date_created field similar to your customer table and I want to update this field via PHP.  I searched the code I downloaded and can not seem to find where you updated this field.


Modifying your example, I have created a table, usertype, that has the field modifedDate defined as:

  'modifiedDate' timestamp Not Null Default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP.


In my insert code, I have the following code (in CodeIgniter):

$data = array('userType' => $this->input->post('dusertype'),  'modifiedBy => "Admin', 'modifiedDate => date('d-m-Y H:i:s');


$this->db->insert(usertype, $data);


The MySQL table fields, usertypeID, userType, modifiedBy are all inserted properly.

The data field, modifiedDate, is formatted as 0000-00-00 00:00:00 even if I try Date() or Now().


What am I doing wrong, it seem that it should be so simple?? 



John K

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...