cari

Rumah >pembangunan bahagian belakang >tutorial php >php封装的mongodb操作类

php封装的mongodb操作类

WBOY
WBOYasal
2016-07-25 08:43:17847semak imbas
  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 {
  47. $n = $this->key + $i;
  48. $key = $n >= $num ? $n - $num : $n;
  49. $this->config = $configs['connect'][$key];
  50. $status = $this->connect();
  51. if($status!=false)
  52. {
  53. $keys['mongo_db'] = $key ;
  54. $this->key = $key;
  55. $data = "";
  56. file_put_contents(WHTY_PATH.'configs/double.php', $data, LOCK_EX);
  57. break;
  58. }
  59. }
  60. }
  61. if($status==false)
  62. {
  63. die('mongoDB not connect');
  64. }
  65. }
  67. function __destruct() {
  68. if((IS_NOSQL != 1)){
  69. return;
  70. }
  71. if($this->connection)
  72. {
  73. $this->connection->close();
  74. }
  75. }
  77. /** * -------------------------------------------------------------------------------- * 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. */
  78. private function connect() {
  79. $this->connection_string();
  80. $options = array('connect'=>true,'timeout'=>$this->timeout);
  81. try {
  82. $this->connection = new Mongo($this->connection_string, $options);
  83. $this->db = $this->connection->{$this->dbname};
  84. return($this);
  85. } catch (MongoConnectionException $e) {
  86. return false;
  87. }
  89. }
  90. /** * -------------------------------------------------------------------------------- * BUILD CONNECTION STRING * -------------------------------------------------------------------------------- * * Build the connection string from the config file. */
  91. private function connection_string() {
  92. $this->host = trim($this->config['hostname']);
  93. $this->port = trim($this->config['port']);
  94. $this->user = trim($this->config['username']);
  95. $this->pass = trim($this->config['password']);
  96. $this->dbname = trim($this->config['database']);
  97. $this->persist = trim($this->config['autoconnect']);
  98. $this->persist_key = trim($this->config['mongo_persist_key']);
  100. $connection_string = "mongodb://";
  101. if (emptyempty($this->host)) {
  102. $this->error("The Host must be set to connect to MongoDB", 500);
  103. } if (emptyempty($this->dbname)) {
  104. $this->error("The Database must be set to connect to MongoDB", 500);
  105. } if (!emptyempty($this->user) && !emptyempty($this->pass)) {
  106. $connection_string .= "{$this->user}:{$this->pass}@";
  107. } if (isset($this->port) && !emptyempty($this->port)) {
  108. $connection_string .= "{$this->host}:{$this->port}";
  109. } else {
  110. $connection_string .= "{$this->host}";
  111. } $this->connection_string = trim($connection_string);
  112. }
  114. /** * -------------------------------------------------------------------------------- * Switch_db * -------------------------------------------------------------------------------- * * Switch from default database to a different db */
  115. public function switch_db($database = '') {
  116. if (emptyempty($database)) {
  117. $this->error("To switch MongoDB databases, a new database name must be specified", 500);
  118. } $this->dbname = $database;
  119. try {
  120. $this->db = $this->connection->{$this->dbname};
  121. return(TRUE);
  122. } catch (Exception $e) {
  123. $this->error("Unable to switch Mongo Databases: {$e->getMessage()}", 500);
  124. }
  125. }
  127. /** * -------------------------------------------------------------------------------- * 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'); */
  128. public function select($includes = array(), $excludes = array()) {
  129. if (!is_array($includes)) {
  130. $includes = array();
  131. }
  132. if (!is_array($excludes)) {
  133. $excludes = array();
  134. }
  135. if (!emptyempty($includes)) {
  136. foreach ($includes as $col) {
  137. $this->selects[$col] = 1;
  138. }
  139. } else {
  140. foreach ($excludes as $col) {
  141. $this->selects[$col] = 0;
  142. }
  143. } return($this);
  144. }
  146. /** * -------------------------------------------------------------------------------- * 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'); */
  147. public function where($wheres = array()) {
  148. foreach ((array)$wheres as $wh => $val) {
  149. $this->wheres[$wh] = $val;
  150. } return($this);
  151. }
  153. /** * -------------------------------------------------------------------------------- * 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'); */
  154. public function where_in($field = "", $in = array()) {
  155. $this->where_init($field);
  156. $this->wheres[$field]['$in'] = $in;
  157. return($this);
  158. }
  160. /** * -------------------------------------------------------------------------------- * 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'); */
  161. public function where_not_in($field = "", $in = array()) {
  162. $this->where_init($field);
  163. $this->wheres[$field]['$nin'] = $in;
  164. return($this);
  165. }
  167. /** * -------------------------------------------------------------------------------- * 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); */
  168. public function where_gt($field = "", $x) {
  169. $this->where_init($field);
  170. $this->wheres[$field]['$gt'] = $x;
  171. return($this);
  172. }
  174. /** * -------------------------------------------------------------------------------- * 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); */
  175. public function where_gte($field = "", $x) {
  176. $this->where_init($field);
  177. $this->wheres[$field]['$gte'] = $x;
  178. return($this);
  179. }
  181. /** * -------------------------------------------------------------------------------- * 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); */
  182. public function where_lt($field = "", $x) {
  183. $this->where_init($field);
  184. $this->wheres[$field]['$lt'] = $x;
  185. return($this);
  186. }
  188. /** * -------------------------------------------------------------------------------- * 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); */
  189. public function where_lte($field = "", $x) {
  190. $this->where_init($field);
  191. $this->wheres[$field]['$lte'] = $x;
  192. return($this);
  193. }
  195. /** * -------------------------------------------------------------------------------- * 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); */
  196. public function where_between($field = "", $x, $y) {
  197. $this->where_init($field);
  198. $this->wheres[$field]['$gte'] = $x;
  199. $this->wheres[$field]['$lte'] = $y;
  200. return($this);
  201. }
  203. /** * -------------------------------------------------------------------------------- * 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); */
  204. public function where_between_ne($field = "", $x, $y) {
  205. $this->where_init($field);
  206. $this->wheres[$field]['$gt'] = $x;
  207. $this->wheres[$field]['$lt'] = $y;
  208. return($this);
  209. }
  211. /** * -------------------------------------------------------------------------------- * 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); */
  212. public function where_ne($field = "", $x) {
  213. $this->where_init($field);
  214. $this->wheres[$field]['$ne'] = $x;
  215. return($this);
  216. }
  218. /** * -------------------------------------------------------------------------------- * 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' ); */
  219. public function where_or($field = "", $values) {
  220. $this->where_init($field);
  221. $this->wheres[$field]['$or'] = $values;
  222. return($this);
  223. }
  225. /** * -------------------------------------------------------------------------------- * WHERE AND * -------------------------------------------------------------------------------- * * Get the documents where the elements match the specified values * * @usage = $this->mongo_db->where_and( array ( 'foo' => 1, 'b' => 'someexample' ); */
  226. public function where_and($elements_values = array()) {
  227. foreach ((array)$elements_values as $element => $val) {
  228. $this->wheres[$element] = $val;
  229. } return($this);
  230. }
  232. /** * -------------------------------------------------------------------------------- * WHERE MOD * -------------------------------------------------------------------------------- * * Get the documents where $field % $mod = $result * * @usage = $this->mongo_db->where_mod( 'foo', 10, 1 ); */
  233. public function where_mod($field, $num, $result) {
  234. $this->where_init($field);
  235. $this->wheres[$field]['$mod'] = array($num, $result);
  236. return($this);
  237. }
  239. /** * -------------------------------------------------------------------------------- * 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'); */
  240. public function where_size($field = "", $size = "") {
  241. $this->_where_init($field);
  242. $this->wheres[$field]['$size'] = $size;
  243. return ($this);
  244. }
  246. /** * -------------------------------------------------------------------------------- * 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); */
  247. public function like($field = "", $value = "", $flags = "i", $enable_start_wildcard = TRUE, $enable_end_wildcard = TRUE) {
  248. $field = (string) trim($field);
  249. $this->where_init($field);
  250. $value = (string) trim($value);
  251. $value = quotemeta($value);
  252. if ($enable_start_wildcard !== TRUE) {
  253. $value = "^" . $value;
  254. } if ($enable_end_wildcard !== TRUE) {
  255. $value .= "$";
  256. } $regex = "/$value/$flags";
  257. $this->wheres[$field] = new MongoRegex($regex);
  258. return($this);
  259. }
  261. public function wheres($where){
  262. $this->wheres = $where;
  263. }
  265. /** * -------------------------------------------------------------------------------- * 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); */
  266. public function order_by($fields = array()) {
  267. if (!is_array($fields) || !count($fields)) return ;
  268. foreach ($fields as $col => $val) {
  269. if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
  270. $this->sorts[$col] = -1;
  271. } else {
  272. $this->sorts[$col] = 1;
  273. }
  274. } return($this);
  275. }
  277. /** * -------------------------------------------------------------------------------- * LIMIT DOCUMENTS * -------------------------------------------------------------------------------- * * Limit the result set to $x number of documents * * @usage = $this->mongo_db->limit($x); */
  278. public function limit($x = 99999) {
  279. if ($x !== NULL && is_numeric($x) && $x >= 1) {
  280. $this->limit = (int) $x;
  281. } return($this);
  282. }
  284. /** * -------------------------------------------------------------------------------- * OFFSET DOCUMENTS * -------------------------------------------------------------------------------- * * Offset the result set to skip $x number of documents * * @usage = $this->mongo_db->offset($x); */
  285. public function offset($x = 0) {
  286. if ($x !== NULL && is_numeric($x) && $x >= 1) {
  287. $this->offset = (int) $x;
  288. } return($this);
  289. }
  291. /** * -------------------------------------------------------------------------------- * GET_WHERE * -------------------------------------------------------------------------------- * * Get the documents based upon the passed parameters * * @usage = $this->mongo_db->get_where('foo', array('bar' => 'something')); */
  292. public function get_where($collection = "", $where = array(), $limit = 99999, $orderby=array()) {
  293. if (is_array($orderby) || !emptyempty($orderby)) {
  294. $order_by = $this->order_by($order_by);
  295. }
  296. return($this->where($where)->limit($limit)->get($collection));
  297. }
  298. public function selectA($collection = "", $limit = 99999, $orderby=array()) {
  299. if(intval($limit) $limit = 999999;
  300. }
  301. $order_by = $this->order_by($orderby);
  302. $re = $this->limit($limit)->get($collection);
  303. $this->clear();
  304. return (array)$re;
  305. }
  307. public function listinfo($collection = "", $orderby=array(), $page=1, $pagesize=12) {
  308. $page = max(intval($page), 1);
  309. $offset = $pagesize * ($page - 1);
  310. $pagesizes = $offset + $pagesize;
  311. $this->offset($offset);
  312. $order_by = $this->order_by($orderby);
  313. $re = $this->limit($pagesize)->get($collection);
  314. $this->limit(999999);
  315. $count = $this->count($collection);
  316. $this->pages = pages($count, $page, $pagesize);
  317. return (array)$re;
  318. }
  320. /** * -------------------------------------------------------------------------------- * GET * -------------------------------------------------------------------------------- * * Get the documents based upon the passed parameters * * @usage = $this->mongo_db->get('foo', array('bar' => 'something')); */
  321. public function get($collection = "") {
  322. if (emptyempty($collection)) {
  323. $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
  324. } $results = array();
  325. $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
  326. $returns = array();
  327. foreach ($documents as $doc): $returns[] = $doc;
  328. endforeach;
  329. return($returns);
  330. }
  332. public function getMy($collection = "") {
  333. if (emptyempty($collection)) {
  334. $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
  335. } $results = array();
  336. $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
  337. $returns = array();
  338. foreach ($documents as $doc): $returns[] = $doc;
  339. endforeach;
  340. $this -> clear();
  341. return($returns);
  342. }
  344. /** * -------------------------------------------------------------------------------- * COUNT * -------------------------------------------------------------------------------- * * Count the documents based upon the passed parameters * * @usage = $this->mongo_db->get('foo'); */
  345. public function count($collection = "") {
  346. if (emptyempty($collection)) {
  347. $this->error("In order to retreive a count of documents from MongoDB, a collection name must be passed", 500);
  348. } $count = $this->db->{$collection}->find($this->wheres)->limit((int) $this->limit)->skip((int) $this->offset)->count();
  349. $this->clear();
  350. return($count);
  351. }
  353. /** * -------------------------------------------------------------------------------- * INSERT * -------------------------------------------------------------------------------- * * Insert a new document into the passed collection * * @usage = $this->mongo_db->insert('foo', $data = array()); */
  354. public function insert($collection = "", $data = array(), $name='ID') {
  355. if (emptyempty($collection)) {
  356. $this->error("No Mongo collection selected to insert into", 500);
  357. } if (count($data) == 0 || !is_array($data)) {
  358. $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
  359. } try {
  360. /**
  361. wxcity_base::load_sys_class('whtysqs','',0);
  362. $mongoseq_class = new whtysqs('creaseidsqs');
  363. $re = $mongoseq_class->query("?name=" . $collection . "&opt=put&data=1");
  364. **/
  365. $re = put_sqs('list_mongo_creaseidsqs','1');
  366. if(is_numeric($re)){
  367. $re++;
  368. $data[$name] = intval($re);
  369. }else{
  370. $data[$name] = intval(time());
  371. //die('mongosqs error');
  372. }
  373. $this->db->{$collection}->insert($data, array('fsync' => TRUE));
  374. $this->clear();
  375. return $data[$name];
  376. } catch (MongoCursorException $e) {
  377. $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
  378. }
  379. }
  381. public function insertWithId($collection = "", $data = array()) {
  382. if (emptyempty($collection)) {
  383. $this->error("No Mongo collection selected to insert into", 500);
  384. } if (count($data) == 0 || !is_array($data)) {
  385. $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
  386. } try {
  387. $this->db->{$collection}->insert($data, array('fsync' => TRUE));
  388. $this->clear();
  389. return 1;
  390. } catch (MongoCursorException $e) {
  391. $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
  392. }
  393. }
  394. /** * -------------------------------------------------------------------------------- * UPDATE * -------------------------------------------------------------------------------- * * Update a document into the passed collection * * @usage = $this->mongo_db->update('foo', $data = array()); */
  395. public function update($collection = "", $data = array()) {
  396. if (emptyempty($collection)) {
  397. $this->error("No Mongo collection selected to update", 500);
  398. } if (count($data) == 0 || !is_array($data)) {
  399. $this->error("Nothing to update in Mongo collection or update is not an array", 500);
  400. } try {
  401. $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => FALSE));
  402. $this->clear();
  403. return(TRUE);
  404. } catch (MongoCursorException $e) {
  405. $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
  406. }
  407. }
  409. /** * -------------------------------------------------------------------------------- * UPDATE_ALL * -------------------------------------------------------------------------------- * * Insert a new document into the passed collection * * @usage = $this->mongo_db->update_all('foo', $data = array()); */
  410. public function update_all($collection = "", $data = array()) {
  411. if (emptyempty($collection)) {
  412. $this->error("No Mongo collection selected to update", 500);
  413. } if (count($data) == 0 || !is_array($data)) {
  414. $this->error("Nothing to update in Mongo collection or update is not an array", 500);
  415. } try {
  416. $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => TRUE));
  417. return(TRUE);
  418. } catch (MongoCursorException $e) {
  419. $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
  420. }
  421. }
  423. /** * -------------------------------------------------------------------------------- * DELETE * -------------------------------------------------------------------------------- * * delete document from the passed collection based upon certain criteria * * @usage = $this->mongo_db->delete('foo', $data = array()); */
  424. public function delete($collection = "") {
  425. if (emptyempty($collection)) {
  426. $this->error("No Mongo collection selected to delete from", 500);
  427. } try {
  428. $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => TRUE));
  429. $this->clear();
  430. return(TRUE);
  431. } catch (MongoCursorException $e) {
  432. $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
  433. }
  434. }
  436. /** * -------------------------------------------------------------------------------- * DELETE_ALL * -------------------------------------------------------------------------------- * * Delete all documents from the passed collection based upon certain criteria * * @usage = $this->mongo_db->delete_all('foo', $data = array()); */
  437. public function delete_all($collection = "") {
  438. if (emptyempty($collection)) {
  439. $this->error("No Mongo collection selected to delete from", 500);
  440. } try {
  441. $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => FALSE));
  442. return(TRUE);
  443. } catch (MongoCursorException $e) {
  444. $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
  445. }
  446. }
  448. /** * -------------------------------------------------------------------------------- * 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)); */
  449. public function add_index($collection = "", $keys = array(), $options = array()) {
  450. if (emptyempty($collection)) {
  451. $this->error("No Mongo collection specified to add index to", 500);
  452. } if (emptyempty($keys) || !is_array($keys)) {
  453. $this->error("Index could not be created to MongoDB Collection because no keys were specified", 500);
  454. } foreach ($keys as $col => $val) {
  455. if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
  456. $keys[$col] = -1;
  457. } else {
  458. $keys[$col] = 1;
  459. }
  460. } if ($this->db->{$collection}->ensureIndex($keys, $options) == TRUE) {
  461. $this->clear();
  462. return($this);
  463. } else {
  464. $this->error("An error occured when trying to add an index to MongoDB Collection", 500);
  465. }
  466. }
  468. /** * -------------------------------------------------------------------------------- * 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)); */
  469. public function remove_index($collection = "", $keys = array()) {
  470. if (emptyempty($collection)) {
  471. $this->error("No Mongo collection specified to remove index from", 500);
  472. } if (emptyempty($keys) || !is_array($keys)) {
  473. $this->error("Index could not be removed from MongoDB Collection because no keys were specified", 500);
  474. } if ($this->db->{$collection}->deleteIndex($keys, $options) == TRUE) {
  475. $this->clear();
  476. return($this);
  477. } else {
  478. $this->error("An error occured when trying to remove an index from MongoDB Collection", 500);
  479. }
  480. }
  482. /** * -------------------------------------------------------------------------------- * REMOVE_ALL_INDEXES * -------------------------------------------------------------------------------- * * Remove all indexes from a collection. * * @usage = $this->mongo_db->remove_all_index($collection); */
  483. public function remove_all_indexes($collection = "") {
  484. if (emptyempty($collection)) {
  485. $this->error("No Mongo collection specified to remove all indexes from", 500);
  486. } $this->db->{$collection}->deleteIndexes();
  487. $this->clear();
  488. return($this);
  489. }
  491. /** * -------------------------------------------------------------------------------- * LIST_INDEXES * -------------------------------------------------------------------------------- * * Lists all indexes in a collection. * * @usage = $this->mongo_db->list_indexes($collection); */
  492. public function list_indexes($collection = "") {
  493. if (emptyempty($collection)) {
  494. $this->error("No Mongo collection specified to remove all indexes from", 500);
  495. } return($this->db->{$collection}->getIndexInfo());
  496. }
  498. /** * -------------------------------------------------------------------------------- * DROP COLLECTION * -------------------------------------------------------------------------------- * * Removes the specified collection from the database. Be careful because this * can have some very large issues in production! */
  499. public function drop_collection($collection = "") {
  500. if (emptyempty($collection)) {
  501. $this->error("No Mongo collection specified to drop from database", 500);
  502. } $this->db->{$collection}->drop();
  503. return TRUE;
  504. }
  506. /** * -------------------------------------------------------------------------------- * CLEAR * -------------------------------------------------------------------------------- * * Resets the class variables to default settings */
  507. private function clear() {
  508. $this->selects = array();
  509. $this->wheres = array();
  510. $this->limit = NULL;
  511. $this->offset = NULL;
  512. $this->sorts = array();
  513. }
  515. /** * -------------------------------------------------------------------------------- * WHERE INITIALIZER * -------------------------------------------------------------------------------- * * Prepares parameters for insertion in $wheres array(). */
  516. private function where_init($param) {
  517. if (!isset($this->wheres[$param])) {
  518. $this->wheres[$param] = array();
  519. }
  520. }
  522. public function error($str, $t) {
  523. echo $str;
  524. exit;
  525. }
  527. }
  529. ?>
复制代码

使用范例
  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


Kenyataan：
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Artikel sebelumnya：php对称加密算法（DES/AES）类代码 Artikel seterusnya：PHP使用DES进行加密和解密

Artikel berkaitan

Lihat lagi