MongoDB PHP auto Increment self-increment

MongoDB's self-increasing implementation of root oracle,postgresql is almost, all through the counter to achieve.

Oracle Self-increment implementation: example illustrates Oracle sequence usage

PostgreSQL self-increment implementation: PostgreSQL Auto_increment implements a common approach

1,MONGODB command-line implementation of Auto_increment

View copy print?

2. > Db.counters.insert ( //Counter table
4. {
6. _id: "userid",
8. seq:0
10. }
12. );
14. Writeresult ({ "ninserted": 1})
18. > Db.counters.find ();
20. { "_id": "userid", "seq": 0}
24. > function getnextsequence (name) { //Remove ID functions
26. var ret = db.counters.findAndModify (
28. {
30. Query: {_id:name},
32. Update: { $inc: {seq:1}}, //here seq is the SEQ field in the Counters table above
34. New:true,
36. Upsert:true
38. }
40. );
44. return ret.seq;
46. };
50. > Db.users.insert ( //Insert Data
52. {
54. _id:getnextsequence ("userid"),
56. Name: "Tank"
58. }
60. );
62. Writeresult ({ "ninserted": 1})
66. > Db.users.find (); //View
68. { "_id": 1, "name": "Tank"}
72. > Db.users.insert (
74. {
76. _id:getnextsequence ("userid"),
78. Name: "Test"
80. }
82. );
84. Writeresult ({ "ninserted": 1})
88. > Db.users.find ();
90. { "_id": 1, "name": "Tank"}
92. { "_id": 2, "name": "Test"}

2,php Implementation Auto_increment

View copy print?

2. function Getnextid ($mongo,$name,$param =Array ()) {
6. $param + = Array ( //default ID starting from 1, interval is 1
8. ' init ' = 1,
10. ' Step ' = 1,
12. );
16. $update = Array ('$inc ' = =Array (' id ' = ' = '$param [' Step ']); //Set interval
18. $query = Array (' name ' = =$name);
20. $command = Array (
22. ' findandmodify ' = ' IDs ',
24. ' Update ' = $update,
26. ' query ' = $query,
28. ' new ' = True
30. );
34. $id = $mongo->db->command ($command);
36. if (isset ($id [' value '] [' ID '])) {
38. return $id [' value '] [' id '];
40. }else{
42. $mongo->insert (array (
44. ' name ' = $name,
46. ' id ' = = $param [' init '], //Set ID start value
48. ));
50. return $param [' init '];
52. }
54. }
58. $mongo = new MONGO ();
60. $curDB = $mongo->selectcollection (' test ', ' IDs '); IDs tables in the//test library
62. $user = $mongo->selectcollection (' test ', ' users '); users table in the//test library
66. $id = Getnextid ($curDB,' userid ',array (' init ' =>10000,' Step ' =>2)); //Get the ID of the next piece of data
70. $obj = Array ("_id" and "=" =$id,"name" = "Tankzhang");
72. $user->insert ($obj); //Insert Data

MongoDB PHP auto Increment self-increment