public static function getAllBeverages() { $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 throckmorton_finalproject.beverages.beverage_id, throckmorton_finalproject.beverages.beverage_name, throckmorton_finalproject.beverage_type.beverage_name AS beverage_type, AVG(throckmorton_finalproject.beverage_comments.rating) AS average_rating\n FROM throckmorton_finalproject.beverages\n LEFT JOIN throckmorton_finalproject.beverage_comments\n ON throckmorton_finalproject.beverages.beverage_id=throckmorton_finalproject.beverage_comments.beverage_id\n LEFT JOIN throckmorton_finalproject.beverage_type\n ON throckmorton_finalproject.beverages.beverage_type=throckmorton_finalproject.beverage_type.beverage_id\n GROUP BY throckmorton_finalproject.beverage_comments.beverage_id;"; $result = mysqli_query($conn, $sql); $s = "["; //$s = ""; $numRows = mysqli_num_rows($result); if ($numRows > 0) { for ($i = 0; $i < $numRows; $i++) { $row = mysqli_fetch_assoc($result); if (is_null($row["average_rating"])) { $row["average_rating"] = "null"; } $beverage = new Beverage($row["beverage_id"], $row["beverage_name"], $row["beverage_type"], $row["average_rating"]); $temp = $beverage->convertJson(); $s .= $temp; if ($i < $numRows - 1) { $s .= ", "; } } } $s .= "]"; mysqli_close($conn); return $s; }