How to display single SQL query results in PHP

Question

I have a query about this php code and can't display the results in echo, can I convert to string? //conexion is my function that connects to the database and is completed $costTotal=conexion();$costTotal=$costTotal->query("SELECTSUM(product_cost)FROMproduct");echo$costTotal;For example, the desired result is string

P粉797004644 · Answer

$costTotal contains the result of the database query, it is not a string, but you are using echo. To output the results as a string, you need to get the data from the query results.

$connection = connexion();

$query = "SELECT SUM(product_cost) as total FROM product";
$result = $connection->query($query);
$data = $result->fetch(PDO::FETCH_ASSOC);

$costTotal = $data['total']; 

echo $costTotal;