如何在数组中插入当前日期

Question

I'm trying to insert the current date into a database for each entry within an array. I've found documentation for inserting the current date, but nothing that explains how to do it within an array.

<?php

$connect = new PDO("mysql:host=localhost;dbname=testing", 
"root", "");

$query = "
INSERT INTO tbl_test 
(full_name, id_number, email, pin_rank, team_name) 
VALUES (:full_name, :id_number, :email, :pin_rank, :team_name)
";

for($count = 0; $count<count($_POST['hidden_full_name']); $count++)
{
 $data = array(
     ':full_name' => $_POST['hidden_full_name'][$count],
     ':id_number' => $_POST['hidden_id_number'][$count],
     ':email' => $_POST['hidden_email'][$count],
     ':pin_rank' => $_POST['hidden_pin_rank'][$count],
     ':team_name' => $_POST['hidden_team_name']
 );
 $statement = $connect->prepare($query);
 $statement->execute($data);
}

?>

I would like the current date to display in the last column within the table. Any help would be appreciated.

Answer 1

Assuming you've some kind of date column (date, datetime, etc...) and it's named in my example date_time, just do the following:

$query = "
INSERT INTO tbl_test 
 (full_name, id_number, email, pin_rank, team_name, date_time) 
 VALUES (:full_name, :id_number, :email, :pin_rank, :team_name, NOW())
 "

Note, if you've got anything other than a date field, you'll get the time along this as well.