无法回显查询结果

Question

I have a class, where i have a function with the following query.

public function count_weight() {
    $id = $_SESSION['id'];
    $query = $this->db->prepare("SELECT sum( weight ) FROM `fish` WHERE `user_id` = '".$_SESSION['id']."'");

    try {
        $query->execute();
    } catch(PDOException $e) {
        die($e->getMessage());
    }

    return $query->fetchAll();
}

I want to echo out this result on my index-page. Right now it looks like this:

$weight = $users->count_weight();

echo $weight;

Which obviously doesn't work, it only prints out "arraykg".

Any suggestions?

Answer 1

You can't print an array like that. e.g.

$arr = array(1,2,3);
echo $arr;

is going output the literal text Array, because you're using the array in a string context. If you want to print the CONTENTS of the array, you'll need to do something with it, e.g.

echo implode(',', $arr); // prints: 1,2,3

or

print_r($array); // debug dump out of the array