Correct use of php to insert data to MySQL datetime type

This article describes how to use php to insert data to the datetime type of MySQL, if you are curious about this technique of using php to insert data into the MySQL datetime type, the following articles will unveil its mystery.

We need to use the datatime type today. The original string format is 03/26/10 18:00:00.

I am used to php's conciseness and directly use strtotime, So I thought mysql would automatically handle it and the result was not.

Then copy a format from the php manual:

 
 

  
  
date("F j, Y, g:i a", strtotime( $srcDataStr ) ) 
 
 

Format, still invalid. It is found that MySQL retrieves and displays DATETIME type in 'yyyy-MM-DD HH: MM: ss' format.

Therefore

 
 

  
  
date("Y-m-d H:i:s" ,strtotime( $srcDataStr )) 
 
 

Insert data smoothly.

The above content is an introduction to using php to insert data to the MySQL datetime type. I hope you will get some gains.
 

The above content describes how to use php to insert data to the MySQL datetime type. I hope it will help you in this regard.

Original article title: Use php to insert data to the datetime type of MySQL

Connection: http://www.cnblogs.com/daihang/archive/2010/03/30/1700184.html