getMessage(). "
"; return; } finally{ mysqli_close($conn); } /*QUERY SE RIS = SPESA echo 'connessione ok
'; $query ='SELECT C.City AS CITTA, SUM(P.Price*OD.Quantity) AS TOT_SPESA FROM Orders O JOIN OrderDetails OD ON O.OrderID = OD.OrderID JOIN Products P ON P.ProductID = OD.ProductID JOIN Customers C ON C.CustomerID = O.CustomerID GROUP BY C.City ' */ /* 2 QUERY SELECT C.City AS CITTA, COUNT(*) AS TOT_ORDINI FROM Orders O JOIN Customers C ON C.CustomerID = O.CustomerID GROUP BY C.City */ ?>