How can PHP and MySQL be used together to efficiently order and display comments from different tables based on date?

To efficiently order and display comments from different tables based on date using PHP and MySQL, you can first retrieve the comments from each table using SQL queries, then combine the results and sort them by date before displaying them on the webpage. 

<?php
// Establish connection to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve comments from different tables
$sql1 = "SELECT id, comment, date FROM table1";
$result1 = $conn->query($sql1);

$sql2 = "SELECT id, comment, date FROM table2";
$result2 = $conn->query($sql2);

// Combine results and sort by date
$comments = array();
while($row = $result1->fetch_assoc()) {
    $comments[] = $row;
}
while($row = $result2->fetch_assoc()) {
    $comments[] = $row;
}

usort($comments, function($a, $b) {
    return strtotime($a['date']) - strtotime($b['date']);
});

// Display comments
foreach($comments as $comment) {
    echo $comment['comment'] . "<br>";
}

// Close connection
$conn->close();
?>

Keywords

PHP MySQL ordering display comments

Related Questions