public static function getAllCommentsByBeverage($beverage_id)
{
$conn = mysqli_connect(getenv('DB_HOST'), getenv('DB_USERNAME'), getenv('DB_PASSWORD'), getenv('DB_DATABASE'));
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT beverage_comments.comment_id, beverage_comments.beverage_id, beverages.beverage_name, users.user_fname, beverage_comments.comment_descrip, beverage_comments.rating\n FROM beverage_comments\n LEFT JOIN users\n ON beverage_comments.user_id=users.user_id\n LEFT JOIN beverages\n ON beverage_comments.beverage_id=beverages.beverage_id\n WHERE beverage_comments.beverage_id=" . $beverage_id . ";";
$result = mysqli_query($conn, $sql);
$s = "[";
$numRows = mysqli_num_rows($result);
if ($numRows > 0) {
for ($i = 0; $i < $numRows; $i++) {
$row = mysqli_fetch_assoc($result);
$comment = new Comment($row["comment_id"], $row["beverage_id"], $row["beverage_name"], $row["user_fname"], $row["comment_descrip"], $row["rating"]);
$temp = $comment->convertJson();
$s .= $temp;
if ($i < $numRows - 1) {
$s .= ", ";
}
}
}
$s .= "]";
mysqli_close($conn);
return $s;
}
