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; }