/**
* Will return one of the following:
*
* 2-D array of all comments from all users contained the 'Comments' table
* OR
* A string advising there are no comments in the 'Comments' table
*
* @return array|string
*/
public static function getComments()
{
// Get DB Connection
self::$DB = DBConnection::getConnection();
// Query for Read-Only. Order by comment date posted
$result = self::$DB->query("SELECT Comments.comm_Title, Comments.comm_Body, Comments.comm_Date_Posted, Users.user_Username FROM Comments INNER JOIN Users ON Comments.user_ID = Users.user_ID ORDER BY comm_Date_Posted DESC");
// Array to return to view
if ($result->rowCount() === 0) {
$comments = "No comments at this time";
} else {
$comments = [];
// Store the comments to return to the web view
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
// Title, Message, Logged-In Username and Date-Time stamp
$comments[] = $row;
}
}
// Nullify the DB object
$DB = null;
return $comments;
}
