print mongodb array field values of document using php

Question

Hi I have a mongodb database where i store products and each product doc is like below :

Using php I want to print all instances of "user" from the "comments" array What I tried :

$collection=$db->products;

  $itemID = $_POST['itemID'];

  $cursor = $collection->findOne(["id"=>$itemID]); //find an item 
  //print all user names who commented on item 
  foreach($cursor['comments'] as $c){
          echo "<p> User : ".$c["user"]." </p>";
          }
  ";
  exit();

And I get :

Warning:  Invalid argument supplied for foreach()

This is the first time I do this so I would appreciate your help

R2D2 · Accepted Answer · 2021-01-23 17:27:51Z

1

From the findOne() docs: As opposed to MongoCollection::find(), this method will return only the first result from the result set, and not a MongoCursor that can be iterated over.

( you need to use find().limit(1) to fetch single document if you want to iterate with forEach construction or you must remove the forEach method to be able to use the findOne() )

If you need to iterate over the comments arrray elements and there is nothing found in the database it will be a problem , so you need to check first if the comments exist ...
Before the end line there is ' "; ' that seems to need to be removed ...

edited Jan 23, 2021 at 17:27

answered Jan 23, 2021 at 17:00

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

2 Comments

vasilis 123 Over a year ago

I am returning a single document. I want to iterate over the comments array of just one document and print the results as html

R2D2 Over a year ago

Is the document found? , since it seems the foreach do not see the comments ...

Collectives™ on Stack Overflow

print mongodb array field values of document using php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related