How to get affected number of rows using mongodb ,php driver

Question

I have two problem : How can I get affected rows by php mongodb driver ,and how about the last insert id ? thanks .

Answer 1

You can get number of results right from the cursor using count function:

$collection->find()->count();

You can even get number of all records in collection using:

$collection->count();

Using insert method, _id is added to input array automatically.

$a = array('x' => 1);
$collection->insert($a,array('safe'=>true));
var_dump($a);

array(2) {
  ["x"]=>
    int(1)
  ["_id"]=>
    object(MongoId)#4 (0) {
    }
  }

Answer 2

I don't believe that there is any type of affected_rows() method at your disposal with mongodb. As for the last insert _id You can generate them in your application code and include them in your insert, so there's really no need for any mysql like insert_id() method.

$id = new MongoId();
$collection->insert(array('
    '_id' => $id,
    'username' => 'username',
    'email' => '[email protected]'
'));

Now you can use the object stored in $id however you wish.