What are the different ways to insert the current date and time into a field in PHP and MySQL?

To insert the current date and time into a field in PHP and MySQL, you can use the NOW() function in MySQL or the date() function in PHP to get the current date and time. You can then insert this value into the desired field in your MySQL database using an SQL query in your PHP code. 

// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Get the current date and time
$currentDateTime = date('Y-m-d H:i:s');

// Insert the current date and time into a field in MySQL
$query = "INSERT INTO table_name (date_time_column) VALUES ('$currentDateTime')";
mysqli_query($connection, $query);

// Close the database connection
mysqli_close($connection);

Keywords

PHP MySQL current date current time insert data

Related Questions