当前位置：Gxlcms > PHP教程 > php封装的mongodb操作类

php封装的mongodb操作类

时间：2021-07-01 10:21:17 帮助过：20人阅读

  2. /*
  3. * To change this template, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  8. class mongo_db {
  10. private $config;
  11. private $connection;
  12. private $db;
  13. private $connection_string;
  14. private $host;
  15. private $port;
  16. private $user;
  17. private $pass;
  18. private $dbname;
  19. private $persist;
  20. private $persist_key;
  21. private $selects = array();
  22. private $wheres = array();
  23. private $sorts = array();
  24. private $limit = 999999;
  25. private $offset = 0;
  26. private $timeout = 200;
  27. private $key = 0;
  28. /** * -------------------------------------------------------------------------------- * CONSTRUCTOR * -------------------------------------------------------------------------------- * * Automatically check if the Mongo PECL extension has been installed/enabled. * Generate the connection string and establish a connection to the MongoDB. */
  30. public function __construct() {
  31. if((IS_NOSQL != 1)){
  32. return;
  33. }
  34. if (!class_exists('Mongo')) {
  35. //$this->error("The MongoDB PECL extension has not been installed or enabled", 500);
  36. }
  37. $configs =wxcity_base::load_config("cache","mongo_db");
  38. $num = count($configs['connect']);
  39. $this->timeout = trim($configs['timeout']);
  40. $keys = wxcity_base::load_config('double');
  41. $this->key = $keys['mongo_db'];
  42. $this->config = $configs['connect'][$this->key];
  43. $status = $this->connect();
  44. if($status == false)
  45. {
  46. for($i = 1; $i < $num; $i++)
  47. {
  48. $n = $this->key + $i;
  49. $key = $n >= $num ? $n - $num : $n;
  50. $this->config = $configs['connect'][$key];
  51. $status = $this->connect();
  52. if($status!=false)
  53. {
  54. $keys['mongo_db'] = $key ;
  55. $this->key = $key;
  56. $data = "";
  57. file_put_contents(WHTY_PATH.'configs/double.php', $data, LOCK_EX);
  58. break;
  59. }
  60. }
  61. }
  62. if($status==false)
  63. {
  64. die('mongoDB not connect');
  65. }
  66. }
  68. function __destruct() {
  69. if((IS_NOSQL != 1)){
  70. return;
  71. }
  72. if($this->connection)
  73. {
  74. $this->connection->close();
  75. }
  76. }
  78. /** * -------------------------------------------------------------------------------- * CONNECT TO MONGODB * -------------------------------------------------------------------------------- * * Establish a connection to MongoDB using the connection string generated in * the connection_string() method. If 'mongo_persist_key' was set to true in the * config file, establish a persistent connection. We allow for only the 'persist' * option to be set because we want to establish a connection immediately. */
  79. private function connect() {
  80. $this->connection_string();
  81. $options = array('connect'=>true,'timeout'=>$this->timeout);
  82. try {
  83. $this->connection = new Mongo($this->connection_string, $options);
  84. $this->db = $this->connection->{$this->dbname};
  85. return($this);
  86. } catch (MongoConnectionException $e) {
  87. return false;
  88. }
  90. }
  91. /** * -------------------------------------------------------------------------------- * BUILD CONNECTION STRING * -------------------------------------------------------------------------------- * * Build the connection string from the config file. */
  92. private function connection_string() {
  93. $this->host = trim($this->config['hostname']);
  94. $this->port = trim($this->config['port']);
  95. $this->user = trim($this->config['username']);
  96. $this->pass = trim($this->config['password']);
  97. $this->dbname = trim($this->config['database']);
  98. $this->persist = trim($this->config['autoconnect']);
  99. $this->persist_key = trim($this->config['mongo_persist_key']);
  101. $connection_string = "mongodb://";
  102. if (emptyempty($this->host)) {
  103. $this->error("The Host must be set to connect to MongoDB", 500);
  104. } if (emptyempty($this->dbname)) {
  105. $this->error("The Database must be set to connect to MongoDB", 500);
  106. } if (!emptyempty($this->user) && !emptyempty($this->pass)) {
  107. $connection_string .= "{$this->user}:{$this->pass}@";
  108. } if (isset($this->port) && !emptyempty($this->port)) {
  109. $connection_string .= "{$this->host}:{$this->port}";
  110. } else {
  111. $connection_string .= "{$this->host}";
  112. } $this->connection_string = trim($connection_string);
  113. }
  115. /** * -------------------------------------------------------------------------------- * Switch_db * -------------------------------------------------------------------------------- * * Switch from default database to a different db */
  116. public function switch_db($database = '') {
  117. if (emptyempty($database)) {
  118. $this->error("To switch MongoDB databases, a new database name must be specified", 500);
  119. } $this->dbname = $database;
  120. try {
  121. $this->db = $this->connection->{$this->dbname};
  122. return(TRUE);
  123. } catch (Exception $e) {
  124. $this->error("Unable to switch Mongo Databases: {$e->getMessage()}", 500);
  125. }
  126. }
  128. /** * -------------------------------------------------------------------------------- * SELECT FIELDS * -------------------------------------------------------------------------------- * * Determine which fields to include OR which to exclude during the query process. * Currently, including and excluding at the same time is not available, so the * $includes array will take precedence over the $excludes array. If you want to * only choose fields to exclude, leave $includes an empty array(). * * @usage: $this->mongo_db->select(array('foo', 'bar'))->get('foobar'); */
  129. public function select($includes = array(), $excludes = array()) {
  130. if (!is_array($includes)) {
  131. $includes = array();
  132. }
  133. if (!is_array($excludes)) {
  134. $excludes = array();
  135. }
  136. if (!emptyempty($includes)) {
  137. foreach ($includes as $col) {
  138. $this->selects[$col] = 1;
  139. }
  140. } else {
  141. foreach ($excludes as $col) {
  142. $this->selects[$col] = 0;
  143. }
  144. } return($this);
  145. }
  147. /** * -------------------------------------------------------------------------------- * WHERE PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents based on these search parameters. The $wheres array should * be an associative array with the field as the key and the value as the search * criteria. * * @usage = $this->mongo_db->where(array('foo' => 'bar'))->get('foobar'); */
  148. public function where($wheres = array()) {
  149. foreach ((array)$wheres as $wh => $val) {
  150. $this->wheres[$wh] = $val;
  151. } return($this);
  152. }
  154. /** * -------------------------------------------------------------------------------- * WHERE_IN PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is in a given $in array(). * * @usage = $this->mongo_db->where_in('foo', array('bar', 'zoo', 'blah'))->get('foobar'); */
  155. public function where_in($field = "", $in = array()) {
  156. $this->where_init($field);
  157. $this->wheres[$field]['$in'] = $in;
  158. return($this);
  159. }
  161. /** * -------------------------------------------------------------------------------- * WHERE_NOT_IN PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is not in a given $in array(). * * @usage = $this->mongo_db->where_not_in('foo', array('bar', 'zoo', 'blah'))->get('foobar'); */
  162. public function where_not_in($field = "", $in = array()) {
  163. $this->where_init($field);
  164. $this->wheres[$field]['$nin'] = $in;
  165. return($this);
  166. }
  168. /** * -------------------------------------------------------------------------------- * WHERE GREATER THAN PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is greater than $x * * @usage = $this->mongo_db->where_gt('foo', 20); */
  169. public function where_gt($field = "", $x) {
  170. $this->where_init($field);
  171. $this->wheres[$field]['$gt'] = $x;
  172. return($this);
  173. }
  175. /** * -------------------------------------------------------------------------------- * WHERE GREATER THAN OR EQUAL TO PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is greater than or equal to $x * * @usage = $this->mongo_db->where_gte('foo', 20); */
  176. public function where_gte($field = "", $x) {
  177. $this->where_init($field);
  178. $this->wheres[$field]['$gte'] = $x;
  179. return($this);
  180. }
  182. /** * -------------------------------------------------------------------------------- * WHERE LESS THAN PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is less than $x * * @usage = $this->mongo_db->where_lt('foo', 20); */
  183. public function where_lt($field = "", $x) {
  184. $this->where_init($field);
  185. $this->wheres[$field]['$lt'] = $x;
  186. return($this);
  187. }
  189. /** * -------------------------------------------------------------------------------- * WHERE LESS THAN OR EQUAL TO PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is less than or equal to $x * * @usage = $this->mongo_db->where_lte('foo', 20); */
  190. public function where_lte($field = "", $x) {
  191. $this->where_init($field);
  192. $this->wheres[$field]['$lte'] = $x;
  193. return($this);
  194. }
  196. /** * -------------------------------------------------------------------------------- * WHERE BETWEEN PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is between $x and $y * * @usage = $this->mongo_db->where_between('foo', 20, 30); */
  197. public function where_between($field = "", $x, $y) {
  198. $this->where_init($field);
  199. $this->wheres[$field]['$gte'] = $x;
  200. $this->wheres[$field]['$lte'] = $y;
  201. return($this);
  202. }
  204. /** * -------------------------------------------------------------------------------- * WHERE BETWEEN AND NOT EQUAL TO PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is between but not equal to $x and $y * * @usage = $this->mongo_db->where_between_ne('foo', 20, 30); */
  205. public function where_between_ne($field = "", $x, $y) {
  206. $this->where_init($field);
  207. $this->wheres[$field]['$gt'] = $x;
  208. $this->wheres[$field]['$lt'] = $y;
  209. return($this);
  210. }
  212. /** * -------------------------------------------------------------------------------- * WHERE NOT EQUAL TO PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is not equal to $x * * @usage = $this->mongo_db->where_between('foo', 20, 30); */
  213. public function where_ne($field = "", $x) {
  214. $this->where_init($field);
  215. $this->wheres[$field]['$ne'] = $x;
  216. return($this);
  217. }
  219. /** * -------------------------------------------------------------------------------- * WHERE OR * -------------------------------------------------------------------------------- * * Get the documents where the value of a $field is in one or more values * * @usage = $this->mongo_db->where_or('foo', array( 'foo', 'bar', 'blegh' ); */
  220. public function where_or($field = "", $values) {
  221. $this->where_init($field);
  222. $this->wheres[$field]['$or'] = $values;
  223. return($this);
  224. }
  226. /** * -------------------------------------------------------------------------------- * WHERE AND * -------------------------------------------------------------------------------- * * Get the documents where the elements match the specified values * * @usage = $this->mongo_db->where_and( array ( 'foo' => 1, 'b' => 'someexample' ); */
  227. public function where_and($elements_values = array()) {
  228. foreach ((array)$elements_values as $element => $val) {
  229. $this->wheres[$element] = $val;
  230. } return($this);
  231. }
  233. /** * -------------------------------------------------------------------------------- * WHERE MOD * -------------------------------------------------------------------------------- * * Get the documents where $field % $mod = $result * * @usage = $this->mongo_db->where_mod( 'foo', 10, 1 ); */
  234. public function where_mod($field, $num, $result) {
  235. $this->where_init($field);
  236. $this->wheres[$field]['$mod'] = array($num, $result);
  237. return($this);
  238. }
  240. /** * -------------------------------------------------------------------------------- * Where size * -------------------------------------------------------------------------------- * * Get the documents where the size of a field is in a given $size int * * @usage : $this->mongo_db->where_size('foo', 1)->get('foobar'); */
  241. public function where_size($field = "", $size = "") {
  242. $this->_where_init($field);
  243. $this->wheres[$field]['$size'] = $size;
  244. return ($this);
  245. }
  247. /** * -------------------------------------------------------------------------------- * LIKE PARAMETERS * -------------------------------------------------------------------------------- * * Get the documents where the (string) value of a $field is like a value. The defaults * allow for a case-insensitive search. * * @param $flags * Allows for the typical regular expression flags: * i = case insensitive * m = multiline * x = can contain comments * l = locale * s = dotall, "." matches everything, including newlines * u = match unicode * * @param $enable_start_wildcard * If set to anything other than TRUE, a starting line character "^" will be prepended * to the search value, representing only searching for a value at the start of * a new line. * * @param $enable_end_wildcard * If set to anything other than TRUE, an ending line character "$" will be appended * to the search value, representing only searching for a value at the end of * a line. * * @usage = $this->mongo_db->like('foo', 'bar', 'im', FALSE, TRUE); */
  248. public function like($field = "", $value = "", $flags = "i", $enable_start_wildcard = TRUE, $enable_end_wildcard = TRUE) {
  249. $field = (string) trim($field);
  250. $this->where_init($field);
  251. $value = (string) trim($value);
  252. $value = quotemeta($value);
  253. if ($enable_start_wildcard !== TRUE) {
  254. $value = "^" . $value;
  255. } if ($enable_end_wildcard !== TRUE) {
  256. $value .= "$";
  257. } $regex = "/$value/$flags";
  258. $this->wheres[$field] = new MongoRegex($regex);
  259. return($this);
  260. }
  262. public function wheres($where){
  263. $this->wheres = $where;
  264. }
  266. /** * -------------------------------------------------------------------------------- * ORDER BY PARAMETERS * -------------------------------------------------------------------------------- * * Sort the documents based on the parameters passed. To set values to descending order, * you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be * set to 1 (ASC). * * @usage = $this->mongo_db->where_between('foo', 20, 30); */
  267. public function order_by($fields = array()) {
  268. if (!is_array($fields) || !count($fields)) return ;
  269. foreach ($fields as $col => $val) {
  270. if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
  271. $this->sorts[$col] = -1;
  272. } else {
  273. $this->sorts[$col] = 1;
  274. }
  275. } return($this);
  276. }
  278. /** * -------------------------------------------------------------------------------- * LIMIT DOCUMENTS * -------------------------------------------------------------------------------- * * Limit the result set to $x number of documents * * @usage = $this->mongo_db->limit($x); */
  279. public function limit($x = 99999) {
  280. if ($x !== NULL && is_numeric($x) && $x >= 1) {
  281. $this->limit = (int) $x;
  282. } return($this);
  283. }
  285. /** * -------------------------------------------------------------------------------- * OFFSET DOCUMENTS * -------------------------------------------------------------------------------- * * Offset the result set to skip $x number of documents * * @usage = $this->mongo_db->offset($x); */
  286. public function offset($x = 0) {
  287. if ($x !== NULL && is_numeric($x) && $x >= 1) {
  288. $this->offset = (int) $x;
  289. } return($this);
  290. }
  292. /** * -------------------------------------------------------------------------------- * GET_WHERE * -------------------------------------------------------------------------------- * * Get the documents based upon the passed parameters * * @usage = $this->mongo_db->get_where('foo', array('bar' => 'something')); */
  293. public function get_where($collection = "", $where = array(), $limit = 99999, $orderby=array()) {
  294. if (is_array($orderby) || !emptyempty($orderby)) {
  295. $order_by = $this->order_by($order_by);
  296. }
  297. return($this->where($where)->limit($limit)->get($collection));
  298. }
  299. public function selectA($collection = "", $limit = 99999, $orderby=array()) {
  300. if(intval($limit)<1){
  301. $limit = 999999;
  302. }
  303. $order_by = $this->order_by($orderby);
  304. $re = $this->limit($limit)->get($collection);
  305. $this->clear();
  306. return (array)$re;
  307. }
  309. public function listinfo($collection = "", $orderby=array(), $page=1, $pagesize=12) {
  310. $page = max(intval($page), 1);
  311. $offset = $pagesize * ($page - 1);
  312. $pagesizes = $offset + $pagesize;
  313. $this->offset($offset);
  314. $order_by = $this->order_by($orderby);
  315. $re = $this->limit($pagesize)->get($collection);
  316. $this->limit(999999);
  317. $count = $this->count($collection);
  318. $this->pages = pages($count, $page, $pagesize);
  319. return (array)$re;
  320. }
  322. /** * -------------------------------------------------------------------------------- * GET * -------------------------------------------------------------------------------- * * Get the documents based upon the passed parameters * * @usage = $this->mongo_db->get('foo', array('bar' => 'something')); */
  323. public function get($collection = "") {
  324. if (emptyempty($collection)) {
  325. $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
  326. } $results = array();
  327. $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
  328. $returns = array();
  329. foreach ($documents as $doc): $returns[] = $doc;
  330. endforeach;
  331. return($returns);
  332. }
  334. public function getMy($collection = "") {
  335. if (emptyempty($collection)) {
  336. $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
  337. } $results = array();
  338. $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
  339. $returns = array();
  340. foreach ($documents as $doc): $returns[] = $doc;
  341. endforeach;
  342. $this -> clear();
  343. return($returns);
  344. }
  346. /** * -------------------------------------------------------------------------------- * COUNT * -------------------------------------------------------------------------------- * * Count the documents based upon the passed parameters * * @usage = $this->mongo_db->get('foo'); */
  347. public function count($collection = "") {
  348. if (emptyempty($collection)) {
  349. $this->error("In order to retreive a count of documents from MongoDB, a collection name must be passed", 500);
  350. } $count = $this->db->{$collection}->find($this->wheres)->limit((int) $this->limit)->skip((int) $this->offset)->count();
  351. $this->clear();
  352. return($count);
  353. }
  355. /** * -------------------------------------------------------------------------------- * INSERT * -------------------------------------------------------------------------------- * * Insert a new document into the passed collection * * @usage = $this->mongo_db->insert('foo', $data = array()); */
  356. public function insert($collection = "", $data = array(), $name='ID') {
  357. if (emptyempty($collection)) {
  358. $this->error("No Mongo collection selected to insert into", 500);
  359. } if (count($data) == 0 || !is_array($data)) {
  360. $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
  361. } try {
  362. /**
  363. wxcity_base::load_sys_class('whtysqs','',0);
  364. $mongoseq_class = new whtysqs('creaseidsqs');
  365. $re = $mongoseq_class->query("?name=" . $collection . "&opt=put&data=1");
  366. **/
  367. $re = put_sqs('list_mongo_creaseidsqs','1');
  368. if(is_numeric($re)){
  369. $re++;
  370. $data[$name] = intval($re);
  371. }else{
  372. $data[$name] = intval(time());
  373. //die('mongosqs error');
  374. }
  375. $this->db->{$collection}->insert($data, array('fsync' => TRUE));
  376. $this->clear();
  377. return $data[$name];
  378. } catch (MongoCursorException $e) {
  379. $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
  380. }
  381. }
  383. public function insertWithId($collection = "", $data = array()) {
  384. if (emptyempty($collection)) {
  385. $this->error("No Mongo collection selected to insert into", 500);
  386. } if (count($data) == 0 || !is_array($data)) {
  387. $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
  388. } try {
  389. $this->db->{$collection}->insert($data, array('fsync' => TRUE));
  390. $this->clear();
  391. return 1;
  392. } catch (MongoCursorException $e) {
  393. $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
  394. }
  395. }
  396. /** * -------------------------------------------------------------------------------- * UPDATE * -------------------------------------------------------------------------------- * * Update a document into the passed collection * * @usage = $this->mongo_db->update('foo', $data = array()); */
  397. public function update($collection = "", $data = array()) {
  398. if (emptyempty($collection)) {
  399. $this->error("No Mongo collection selected to update", 500);
  400. } if (count($data) == 0 || !is_array($data)) {
  401. $this->error("Nothing to update in Mongo collection or update is not an array", 500);
  402. } try {
  403. $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => FALSE));
  404. $this->clear();
  405. return(TRUE);
  406. } catch (MongoCursorException $e) {
  407. $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
  408. }
  409. }
  411. /** * -------------------------------------------------------------------------------- * UPDATE_ALL * -------------------------------------------------------------------------------- * * Insert a new document into the passed collection * * @usage = $this->mongo_db->update_all('foo', $data = array()); */
  412. public function update_all($collection = "", $data = array()) {
  413. if (emptyempty($collection)) {
  414. $this->error("No Mongo collection selected to update", 500);
  415. } if (count($data) == 0 || !is_array($data)) {
  416. $this->error("Nothing to update in Mongo collection or update is not an array", 500);
  417. } try {
  418. $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => TRUE));
  419. return(TRUE);
  420. } catch (MongoCursorException $e) {
  421. $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
  422. }
  423. }
  425. /** * -------------------------------------------------------------------------------- * DELETE * -------------------------------------------------------------------------------- * * delete document from the passed collection based upon certain criteria * * @usage = $this->mongo_db->delete('foo', $data = array()); */
  426. public function delete($collection = "") {
  427. if (emptyempty($collection)) {
  428. $this->error("No Mongo collection selected to delete from", 500);
  429. } try {
  430. $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => TRUE));
  431. $this->clear();
  432. return(TRUE);
  433. } catch (MongoCursorException $e) {
  434. $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
  435. }
  436. }
  438. /** * -------------------------------------------------------------------------------- * DELETE_ALL * -------------------------------------------------------------------------------- * * Delete all documents from the passed collection based upon certain criteria * * @usage = $this->mongo_db->delete_all('foo', $data = array()); */
  439. public function delete_all($collection = "") {
  440. if (emptyempty($collection)) {
  441. $this->error("No Mongo collection selected to delete from", 500);
  442. } try {
  443. $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => FALSE));
  444. return(TRUE);
  445. } catch (MongoCursorException $e) {
  446. $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
  447. }
  448. }
  450. /** * -------------------------------------------------------------------------------- * ADD_INDEX * -------------------------------------------------------------------------------- * * Ensure an index of the keys in a collection with optional parameters. To set values to descending order, * you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be * set to 1 (ASC). * * @usage = $this->mongo_db->add_index($collection, array('first_name' => 'ASC', 'last_name' => -1), array('unique' => TRUE)); */
  451. public function add_index($collection = "", $keys = array(), $options = array()) {
  452. if (emptyempty($collection)) {
  453. $this->error("No Mongo collection specified to add index to", 500);
  454. } if (emptyempty($keys) || !is_array($keys)) {
  455. $this->error("Index could not be created to MongoDB Collection because no keys were specified", 500);
  456. } foreach ($keys as $col => $val) {
  457. if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
  458. $keys[$col] = -1;
  459. } else {
  460. $keys[$col] = 1;
  461. }
  462. } if ($this->db->{$collection}->ensureIndex($keys, $options) == TRUE) {
  463. $this->clear();
  464. return($this);
  465. } else {
  466. $this->error("An error occured when trying to add an index to MongoDB Collection", 500);
  467. }
  468. }
  470. /** * -------------------------------------------------------------------------------- * REMOVE_INDEX * -------------------------------------------------------------------------------- * * Remove an index of the keys in a collection. To set values to descending order, * you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be * set to 1 (ASC). * * @usage = $this->mongo_db->remove_index($collection, array('first_name' => 'ASC', 'last_name' => -1)); */
  471. public function remove_index($collection = "", $keys = array()) {
  472. if (emptyempty($collection)) {
  473. $this->error("No Mongo collection specified to remove index from", 500);
  474. } if (emptyempty($keys) || !is_array($keys)) {
  475. $this->error("Index could not be removed from MongoDB Collection because no keys were specified", 500);
  476. } if ($this->db->{$collection}->deleteIndex($keys, $options) == TRUE) {
  477. $this->clear();
  478. return($this);
  479. } else {
  480. $this->error("An error occured when trying to remove an index from MongoDB Collection", 500);
  481. }
  482. }
  484. /** * -------------------------------------------------------------------------------- * REMOVE_ALL_INDEXES * -------------------------------------------------------------------------------- * * Remove all indexes from a collection. * * @usage = $this->mongo_db->remove_all_index($collection); */
  485. public function remove_all_indexes($collection = "") {
  486. if (emptyempty($collection)) {
  487. $this->error("No Mongo collection specified to remove all indexes from", 500);
  488. } $this->db->{$collection}->deleteIndexes();
  489. $this->clear();
  490. return($this);
  491. }
  493. /** * -------------------------------------------------------------------------------- * LIST_INDEXES * -------------------------------------------------------------------------------- * * Lists all indexes in a collection. * * @usage = $this->mongo_db->list_indexes($collection); */
  494. public function list_indexes($collection = "") {
  495. if (emptyempty($collection)) {
  496. $this->error("No Mongo collection specified to remove all indexes from", 500);
  497. } return($this->db->{$collection}->getIndexInfo());
  498. }
  500. /** * -------------------------------------------------------------------------------- * DROP COLLECTION * -------------------------------------------------------------------------------- * * Removes the specified collection from the database. Be careful because this * can have some very large issues in production! */
  501. public function drop_collection($collection = "") {
  502. if (emptyempty($collection)) {
  503. $this->error("No Mongo collection specified to drop from database", 500);
  504. } $this->db->{$collection}->drop();
  505. return TRUE;
  506. }
  508. /** * -------------------------------------------------------------------------------- * CLEAR * -------------------------------------------------------------------------------- * * Resets the class variables to default settings */
  509. private function clear() {
  510. $this->selects = array();
  511. $this->wheres = array();
  512. $this->limit = NULL;
  513. $this->offset = NULL;
  514. $this->sorts = array();
  515. }
  517. /** * -------------------------------------------------------------------------------- * WHERE INITIALIZER * -------------------------------------------------------------------------------- * * Prepares parameters for insertion in $wheres array(). */
  518. private function where_init($param) {
  519. if (!isset($this->wheres[$param])) {
  520. $this->wheres[$param] = array();
  521. }
  522. }
  524. public function error($str, $t) {
  525. echo $str;
  526. exit;
  527. }
  529. }
  531. ?>

使用范例
  1. $table_name=trim(strtolower($this->table_name));
  2. $this->mongo_db->where($where);
  3. $order=!emptyempty($order)?array('AID'=>'DESC'):array('AID'=>'ASC');//升序降序
  4. $infos=$this->mongo_db->listinfo($table_name,$order,$page,$pagesize);

php, mongodb

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！