How to use findAndModify in php and mongodb

I want to increase id by 1, but I have a problem running php page Error

Fatal error: Call to undefined method MongoCollection::findAndModify() in C:\wamp\www\....

My code:

<?php
 // connect
 $m = new Mongo();
 $db=$m->demo;//selecting database named demo
 $db->authenticate("abc","abc");//authenticate database by its username and  password
 $next =nextValue($db);
 $db->counters.insert(array("_id"=>$next, "name"=>'B'));
 print_r($db->runcommand(array('getlasterror'=>1,'fsync'=>true)));
 function nextValue($db)
 {
      //$next =$db->counters->findAndModify(array('query'=> array("_id"=> "total"),'update'=>array($inc=> array("total"=> 1))));
      //I Used above Code Before this code
      $next =$db->command(array('findAndModify'=>'counters'),array('query'=> array("_id"=> "total"),'update'=>array($inc=> array("total"=> 1))));
      if($next['total']==0)
      {
         $db->counters->insert(array("_id"=> "total", "name" => 'A'));
         $next =$db->counters->findAndModify(array('query'=> array("_id"=> "total"),'update'=>array($inc=> array("total"=> 1))));
      }
      return $next['total'];
 }
?>

      

+3


source to share


1 answer


There is no findAndModify function yet. Instead of findAndModify, you will need to run a generic database command to do this:

$db->command(
  array(
    "findandmodify" => "counters",
    "query" => array("_id"=> "total"),
    "update" => array($inc=> array("total"=> 1)),
  )
);

      



There is an open question at https://jira.mongodb.org/browse/PHP-117 for the findAndModify implementation.

+4


source







All Articles