mysql函数插入当前世界_使用MySQL / PHP在字段中使用now（）插入当前日期/时间

就像Pekka所说的那样，它应该这样工作。 我无法通过以下独立示例重现该问题：

$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly');

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

$pdo->exec('

CREATE TEMPORARY TABLE soFoo (

id int auto_increment,

first int,

last int,

whenadded DATETIME,

primary key(id)

)

');

$pdo->exec('INSERT INTO soFoo (first,last,whenadded) VALUES (0,1,Now())');

$pdo->exec('INSERT INTO soFoo (first,last,whenadded) VALUES (0,2,Now())');

$pdo->exec('INSERT INTO soFoo (first,last,whenadded) VALUES (0,3,Now())');

foreach( $pdo->query('SELECT * FROM soFoo', PDO::FETCH_ASSOC) as $row ) {

echo join(' | ', $row), "\n";

}

(当前)打印

1 | 0 | 1 | 2012-03-23 16:00:18

2 | 0 | 2 | 2012-03-23 16:00:18

3 | 0 | 3 | 2012-03-23 16:00:18

这(几乎)是使用TIMESTAMP字段和DEFAULT CURRENT_TIMESTAMP的相同脚本：

$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly');

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

$pdo->exec('

CREATE TEMPORARY TABLE soFoo (

id int auto_increment,

first int,

last int,

whenadded TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

primary key(id)

)

');

$pdo->exec('INSERT INTO soFoo (first,last) VALUES (0,1)');

$pdo->exec('INSERT INTO soFoo (first,last) VALUES (0,2)');

sleep(1);

$pdo->exec('INSERT INTO soFoo (first,last) VALUES (0,3)');

foreach( $pdo->query('SELECT * FROM soFoo', PDO::FETCH_ASSOC) as $row ) {

echo join(' | ', $row), "\n";

}

方便地，时间戳转换为与第一个示例相同的日期时间字符串表示形式-至少在我的PHP / PDO / mysqlnd版本中。