Php query mongo for nested records

Question

I'm new to mongo. I'm working on a small site for managing a food storage database. When I query the database for key:value pairs I'm getting results but when I need to find sub values, e.g. key:{key:value}, I get nothing. Here is my record structure;

> db.foodstore.find().pretty()
{
        "_id" : ObjectId("5f5359676224333f529df761"),
        "shelf" : "1",
        "food" : "green beans",
        "container" : {
                "type" : "can",
                "size" : "#10"
        },
        "dateIn" : "09/20",
        "quantity" : "6"
}

Here is the php page code to query it:

<?php
require '../vendor/autoload.php';
$connection = new MongoDB\Client("mongodb://localhost:27017");
$collection = $connection->everything->foodstore;
echo "<div align='center'>";
$result = $collection->find([]);
echo "<table>";
foreach ($result as $entry){
        echo "<tr><td>",$entry['shelf'],
                "</td><td>",$entry['food'],
                "</td><td>",$entry['dateIn'],
                "</td><td>",$entry['container.size'],
                "</td></tr>";
}
echo "</table></div>";
?>

The values for shelf,food, dateIn display fine but I cannot get container.size to show any value. Can anyone see where I'm screwing this up? Thanks in advance.

Just change $entry['container.size'] to $entry['container']['size'] — Slava Rozhnev
– Slava Rozhnev, Commented Sep 26, 2020 at 14:10

Slava Rozhnev · Accepted Answer · 2020-09-26 19:23:24Z

1

Just change your code like:

<?php
require '../vendor/autoload.php';
$connection = new MongoDB\Client("mongodb://localhost:27017");
$collection = $connection->everything->foodstore;
echo "<div align='center'>";
$result = $collection->find([]);
echo "<table>";
foreach ($result as $entry){
        echo "<tr><td>",$entry['shelf'],
                "</td><td>",$entry['food'],
                "</td><td>",$entry['dateIn'],
                "</td><td>",$entry['container']['size'], //here changed
                "</td></tr>";
}
echo "</table></div>";
?>

answered Sep 26, 2020 at 19:23

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Php query mongo for nested records

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related