How can PHP be used to append new date and time values to existing ones in a database entry?

When appending new date and time values to existing ones in a database entry using PHP, you can retrieve the existing values from the database, concatenate the new values to them, and then update the database entry with the combined string. 

// Connect to the database
$connection = new mysqli("localhost", "username", "password", "database");

// Retrieve existing date and time values from the database
$query = "SELECT date_time_column FROM table_name WHERE id = 1";
$result = $connection->query($query);
$row = $result->fetch_assoc();
$existingDateTime = $row['date_time_column'];

// Append new date and time values
$newDateTime = $existingDateTime . ", " . date("Y-m-d H:i:s");

// Update the database entry with the combined string
$updateQuery = "UPDATE table_name SET date_time_column = '$newDateTime' WHERE id = 1";
$connection->query($updateQuery);

// Close the database connection
$connection->close();

Keywords

PHP database append date time

Related Questions