What is the best way to store and retrieve Unix Timestamps in a MySQL table for news articles in PHP?

To store and retrieve Unix Timestamps in a MySQL table for news articles in PHP, you can use the INT data type in MySQL to store the timestamps. When inserting a new article, convert the current timestamp to a Unix Timestamp using the PHP time() function. When retrieving the timestamp from the database, convert it back to a human-readable date format using the PHP date() function. 

// Storing Unix Timestamp in MySQL table
$currentTimestamp = time();
$query = "INSERT INTO news_articles (title, content, timestamp) VALUES ('Article Title', 'Article Content', $currentTimestamp)";
$result = mysqli_query($connection, $query);

// Retrieving Unix Timestamp from MySQL table
$query = "SELECT title, content, timestamp FROM news_articles WHERE id = 1";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$timestamp = date('Y-m-d H:i:s', $row['timestamp']);
echo "Article Title: " . $row['title'] . "<br>";
echo "Article Content: " . $row['content'] . "<br>";
echo "Published on: " . $timestamp;

Keywords

Unix Timestamps MySQL table news articles PHP store and retrieve

Related Questions