php封装的mongodb操作类代码

核心代码

<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

class mongo_db {

  private $config;
  private $connection;
  private $db;
  private $connection_string;
  private $host;
  private $port;
  private $user;
  private $pass;
  private $dbname;
  private $persist;
  private $persist_key;
  private $selects = array();
  private $wheres = array();
  private $sorts = array();
  private $limit = 999999;
  private $offset = 0;
  private $timeout = 200;
  private $key = 0;
  /**   *  --------------------------------------------------------------------------------   * CONSTRUCTOR * --------------------------------------------------------------------------------   *  * Automatically check if the Mongo PECL extension has been installed/enabled. * Generate the connection string and establish a connection to the MongoDB.  */

  public function __construct() {
    if((IS_NOSQL != 1)){
      return;
    }
    if (!class_exists('Mongo')) {
      //$this->error("The MongoDB PECL extension has not been installed or enabled", 500);
    }
    $configs =wxcity_base::load_config("cache","mongo_db");
    $num = count($configs['connect']);
    $this->timeout = trim($configs['timeout']);
    $keys = wxcity_base::load_config('double');
    $this->key = $keys['mongo_db'];
    $this->config = $configs['connect'][$this->key];
    $status = $this->connect();
    if($status == false)
    {
      for($i = 1; $i < $num; $i++)
      {
        $n = $this->key + $i;
        $key = $n >= $num ? $n - $num : $n;
        $this->config = $configs['connect'][$key];
        $status = $this->connect();
        if($status!=false)
        {
          $keys['mongo_db'] = $key ;
          $this->key = $key;
          $data = "<?php\nreturn ".var_export($keys, true).";\n?>";
          file_put_contents(WHTY_PATH.'configs/double.php', $data, LOCK_EX);
          break;
        }
      }
    }
    if($status==false)
    {
      die('mongoDB not connect');
    }
  }

  function __destruct() {
    if((IS_NOSQL != 1)){
      return;
    }
    if($this->connection)
    {
      $this->connection->close();
    }
  }

  /**   *  --------------------------------------------------------------------------------   * 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. */
  private function connect() {
    $this->connection_string();
    $options = array('connect'=>true,'timeout'=>$this->timeout);
    try {
      $this->connection = new Mongo($this->connection_string, $options);
      $this->db = $this->connection->{$this->dbname};
      return($this);
    } catch (MongoConnectionException $e) {
      return false;
    }

  }
  /**   *  --------------------------------------------------------------------------------   * BUILD CONNECTION STRING * --------------------------------------------------------------------------------   *  * Build the connection string from the config file.  */
  private function connection_string() {
    $this->host = trim($this->config['hostname']);
    $this->port = trim($this->config['port']);
    $this->user = trim($this->config['username']);
    $this->pass = trim($this->config['password']);
    $this->dbname = trim($this->config['database']);
    $this->persist = trim($this->config['autoconnect']);
    $this->persist_key = trim($this->config['mongo_persist_key']);

    $connection_string = "mongodb://";
    if (emptyempty($this->host)) {
      $this->error("The Host must be set to connect to MongoDB", 500);
    } if (emptyempty($this->dbname)) {
      $this->error("The Database must be set to connect to MongoDB", 500);
    } if (!emptyempty($this->user) && !emptyempty($this->pass)) {
      $connection_string .= "{$this->user}:{$this->pass}@";
    } if (isset($this->port) && !emptyempty($this->port)) {
      $connection_string .= "{$this->host}:{$this->port}";
    } else {
      $connection_string .= "{$this->host}";
    } $this->connection_string = trim($connection_string);
  }

  /**   *  --------------------------------------------------------------------------------   * Switch_db  * --------------------------------------------------------------------------------   *  * Switch from default database to a different db  */
  public function switch_db($database = '') {
    if (emptyempty($database)) {
      $this->error("To switch MongoDB databases, a new database name must be specified", 500);
    } $this->dbname = $database;
    try {
      $this->db = $this->connection->{$this->dbname};
      return(TRUE);
    } catch (Exception $e) {
      $this->error("Unable to switch Mongo Databases: {$e->getMessage()}", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * 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');  */
  public function select($includes = array(), $excludes = array()) {
    if (!is_array($includes)) {
      $includes = array();
    }
    if (!is_array($excludes)) {
      $excludes = array();
    }
    if (!emptyempty($includes)) {
      foreach ($includes as $col) {
        $this->selects[$col] = 1;
      }
    } else {
      foreach ($excludes as $col) {
        $this->selects[$col] = 0;
      }
    } return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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');  */
  public function where($wheres = array()) {
    foreach ((array)$wheres as $wh => $val) {
      $this->wheres[$wh] = $val;
    } return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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'); */
  public function where_in($field = "", $in = array()) {
    $this->where_init($field);
    $this->wheres[$field]['$in'] = $in;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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'); */
  public function where_not_in($field = "", $in = array()) {
    $this->where_init($field);
    $this->wheres[$field]['$nin'] = $in;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);   */
  public function where_gt($field = "", $x) {
    $this->where_init($field);
    $this->wheres[$field]['$gt'] = $x;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);  */
  public function where_gte($field = "", $x) {
    $this->where_init($field);
    $this->wheres[$field]['$gte'] = $x;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);   */
  public function where_lt($field = "", $x) {
    $this->where_init($field);
    $this->wheres[$field]['$lt'] = $x;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);  */
  public function where_lte($field = "", $x) {
    $this->where_init($field);
    $this->wheres[$field]['$lte'] = $x;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);  */
  public function where_between($field = "", $x, $y) {
    $this->where_init($field);
    $this->wheres[$field]['$gte'] = $x;
    $this->wheres[$field]['$lte'] = $y;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);   */
  public function where_between_ne($field = "", $x, $y) {
    $this->where_init($field);
    $this->wheres[$field]['$gt'] = $x;
    $this->wheres[$field]['$lt'] = $y;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);  */
  public function where_ne($field = "", $x) {
    $this->where_init($field);
    $this->wheres[$field]['$ne'] = $x;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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' ); */
  public function where_or($field = "", $values) {
    $this->where_init($field);
    $this->wheres[$field]['$or'] = $values;
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * WHERE AND  * --------------------------------------------------------------------------------   *  * Get the documents where the elements match the specified values *  * @usage = $this->mongo_db->where_and( array ( 'foo' => 1, 'b' => 'someexample' );   */
  public function where_and($elements_values = array()) {
    foreach ((array)$elements_values as $element => $val) {
      $this->wheres[$element] = $val;
    } return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * WHERE MOD  * --------------------------------------------------------------------------------   *  * Get the documents where $field % $mod = $result *  * @usage = $this->mongo_db->where_mod( 'foo', 10, 1 );  */
  public function where_mod($field, $num, $result) {
    $this->where_init($field);
    $this->wheres[$field]['$mod'] = array($num, $result);
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------  *  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'); */
  public function where_size($field = "", $size = "") {
    $this->_where_init($field);
    $this->wheres[$field]['$size'] = $size;
    return ($this);
  }

  /**   *  --------------------------------------------------------------------------------   * 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);  */
  public function like($field = "", $value = "", $flags = "i", $enable_start_wildcard = TRUE, $enable_end_wildcard = TRUE) {
    $field = (string) trim($field);
    $this->where_init($field);
    $value = (string) trim($value);
    $value = quotemeta($value);
    if ($enable_start_wildcard !== TRUE) {
      $value = "^" . $value;
    } if ($enable_end_wildcard !== TRUE) {
      $value .= "$";
    } $regex = "/$value/$flags";
    $this->wheres[$field] = new MongoRegex($regex);
    return($this);
  }

  public function wheres($where){
    $this->wheres = $where;
  }

  /**   *  --------------------------------------------------------------------------------   * 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);  */
  public function order_by($fields = array()) {
    if (!is_array($fields) || !count($fields)) return ;
    foreach ($fields as $col => $val) {
      if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
        $this->sorts[$col] = -1;
      } else {
        $this->sorts[$col] = 1;
      }
    } return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * LIMIT DOCUMENTS * --------------------------------------------------------------------------------   *  * Limit the result set to $x number of documents  *  * @usage = $this->mongo_db->limit($x);  */
  public function limit($x = 99999) {
    if ($x !== NULL && is_numeric($x) && $x >= 1) {
      $this->limit = (int) $x;
    } return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * OFFSET DOCUMENTS   * --------------------------------------------------------------------------------   *  * Offset the result set to skip $x number of documents   *  * @usage = $this->mongo_db->offset($x); */
  public function offset($x = 0) {
    if ($x !== NULL && is_numeric($x) && $x >= 1) {
      $this->offset = (int) $x;
    } return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * GET_WHERE  * --------------------------------------------------------------------------------   *  * Get the documents based upon the passed parameters  *  * @usage = $this->mongo_db->get_where('foo', array('bar' => 'something'));  */
  public function get_where($collection = "", $where = array(), $limit = 99999, $orderby=array()) {
    if (is_array($orderby) || !emptyempty($orderby)) {
      $order_by = $this->order_by($order_by);
    }
    return($this->where($where)->limit($limit)->get($collection));
  }
  public function selectA($collection = "", $limit = 99999, $orderby=array()) {
    if(intval($limit)<1){
      $limit = 999999;
    }
    $order_by = $this->order_by($orderby);
    $re = $this->limit($limit)->get($collection);
    $this->clear();
    return (array)$re;
  }

  public function listinfo($collection = "", $orderby=array(), $page=1, $pagesize=12) {
    $page = max(intval($page), 1);
    $offset = $pagesize * ($page - 1);
    $pagesizes = $offset + $pagesize;
    $this->offset($offset);
    $order_by = $this->order_by($orderby);
    $re = $this->limit($pagesize)->get($collection);
    $this->limit(999999);
    $count = $this->count($collection);
    $this->pages = pages($count, $page, $pagesize);
    return (array)$re;
  }

  /**   *  --------------------------------------------------------------------------------   * GET * --------------------------------------------------------------------------------   *  * Get the documents based upon the passed parameters  *  * @usage = $this->mongo_db->get('foo', array('bar' => 'something')); */
  public function get($collection = "") {
    if (emptyempty($collection)) {
      $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
    } $results = array();
    $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
    $returns = array();
    foreach ($documents as $doc): $returns[] = $doc;
    endforeach;
    return($returns);
  }

  public function getMy($collection = "") {
    if (emptyempty($collection)) {
      $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
    } $results = array();
    $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
    $returns = array();
    foreach ($documents as $doc): $returns[] = $doc;
    endforeach;
    $this -> clear();
    return($returns);
  }

  /**   *  --------------------------------------------------------------------------------   * COUNT  * --------------------------------------------------------------------------------   *  * Count the documents based upon the passed parameters   *  * @usage = $this->mongo_db->get('foo'); */
  public function count($collection = "") {
    if (emptyempty($collection)) {
      $this->error("In order to retreive a count of documents from MongoDB, a collection name must be passed", 500);
    } $count = $this->db->{$collection}->find($this->wheres)->limit((int) $this->limit)->skip((int) $this->offset)->count();
    $this->clear();
    return($count);
  }

  /**   *  --------------------------------------------------------------------------------   * INSERT  * --------------------------------------------------------------------------------   *  * Insert a new document into the passed collection   *  * @usage = $this->mongo_db->insert('foo', $data = array()); */
  public function insert($collection = "", $data = array(), $name='ID') {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection selected to insert into", 500);
    } if (count($data) == 0 || !is_array($data)) {
      $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
    } try {
      /**
      wxcity_base::load_sys_class('whtysqs','',0);
      $mongoseq_class = new whtysqs('creaseidsqs');
      $re = $mongoseq_class->query("?name=" . $collection . "&opt=put&data=1");
       **/
      $re = put_sqs('list_mongo_creaseidsqs','1');
      if(is_numeric($re)){
        $re++;
        $data[$name] = intval($re);
      }else{
        $data[$name] = intval(time());
        //die('mongosqs error');
      }
      $this->db->{$collection}->insert($data, array('fsync' => TRUE));
      $this->clear();
      return $data[$name];
    } catch (MongoCursorException $e) {
      $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
    }
  }

  public function insertWithId($collection = "", $data = array()) {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection selected to insert into", 500);
    } if (count($data) == 0 || !is_array($data)) {
      $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
    } try {
      $this->db->{$collection}->insert($data, array('fsync' => TRUE));
      $this->clear();
      return 1;
    } catch (MongoCursorException $e) {
      $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
    }
  }
  /**   *  --------------------------------------------------------------------------------   * UPDATE  * --------------------------------------------------------------------------------   *  * Update a document into the passed collection   *  * @usage = $this->mongo_db->update('foo', $data = array()); */
  public function update($collection = "", $data = array()) {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection selected to update", 500);
    } if (count($data) == 0 || !is_array($data)) {
      $this->error("Nothing to update in Mongo collection or update is not an array", 500);
    } try {
      $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => FALSE));
      $this->clear();
      return(TRUE);
    } catch (MongoCursorException $e) {
      $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * UPDATE_ALL  * --------------------------------------------------------------------------------   *  * Insert a new document into the passed collection   *  * @usage = $this->mongo_db->update_all('foo', $data = array()); */
  public function update_all($collection = "", $data = array()) {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection selected to update", 500);
    } if (count($data) == 0 || !is_array($data)) {
      $this->error("Nothing to update in Mongo collection or update is not an array", 500);
    } try {
      $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => TRUE));
      return(TRUE);
    } catch (MongoCursorException $e) {
      $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * DELETE  * --------------------------------------------------------------------------------   *  * delete document from the passed collection based upon certain criteria  *  * @usage = $this->mongo_db->delete('foo', $data = array()); */
  public function delete($collection = "") {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection selected to delete from", 500);
    } try {
      $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => TRUE));
      $this->clear();
      return(TRUE);
    } catch (MongoCursorException $e) {
      $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * DELETE_ALL  * --------------------------------------------------------------------------------   *  * Delete all documents from the passed collection based upon certain criteria *  * @usage = $this->mongo_db->delete_all('foo', $data = array()); */
  public function delete_all($collection = "") {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection selected to delete from", 500);
    } try {
      $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => FALSE));
      return(TRUE);
    } catch (MongoCursorException $e) {
      $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * 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));  */
  public function add_index($collection = "", $keys = array(), $options = array()) {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection specified to add index to", 500);
    } if (emptyempty($keys) || !is_array($keys)) {
      $this->error("Index could not be created to MongoDB Collection because no keys were specified", 500);
    } foreach ($keys as $col => $val) {
      if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
        $keys[$col] = -1;
      } else {
        $keys[$col] = 1;
      }
    } if ($this->db->{$collection}->ensureIndex($keys, $options) == TRUE) {
      $this->clear();
      return($this);
    } else {
      $this->error("An error occured when trying to add an index to MongoDB Collection", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * 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));  */
  public function remove_index($collection = "", $keys = array()) {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection specified to remove index from", 500);
    } if (emptyempty($keys) || !is_array($keys)) {
      $this->error("Index could not be removed from MongoDB Collection because no keys were specified", 500);
    } if ($this->db->{$collection}->deleteIndex($keys, $options) == TRUE) {
      $this->clear();
      return($this);
    } else {
      $this->error("An error occured when trying to remove an index from MongoDB Collection", 500);
    }
  }

  /**   *  --------------------------------------------------------------------------------   * REMOVE_ALL_INDEXES  * --------------------------------------------------------------------------------   *  * Remove all indexes from a collection.  *  * @usage = $this->mongo_db->remove_all_index($collection);  */
  public function remove_all_indexes($collection = "") {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection specified to remove all indexes from", 500);
    } $this->db->{$collection}->deleteIndexes();
    $this->clear();
    return($this);
  }

  /**   *  --------------------------------------------------------------------------------   * LIST_INDEXES   * --------------------------------------------------------------------------------   *  * Lists all indexes in a collection.  *  * @usage = $this->mongo_db->list_indexes($collection);  */
  public function list_indexes($collection = "") {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection specified to remove all indexes from", 500);
    } return($this->db->{$collection}->getIndexInfo());
  }

  /**   *  --------------------------------------------------------------------------------   * DROP COLLECTION * --------------------------------------------------------------------------------   *  * Removes the specified collection from the database. Be careful because this   * can have some very large issues in production!  */
  public function drop_collection($collection = "") {
    if (emptyempty($collection)) {
      $this->error("No Mongo collection specified to drop from database", 500);
    } $this->db->{$collection}->drop();
    return TRUE;
  }

  /**   *  --------------------------------------------------------------------------------   * CLEAR  * --------------------------------------------------------------------------------   *  * Resets the class variables to default settings  */
  private function clear() {
    $this->selects = array();
    $this->wheres = array();
    $this->limit = NULL;
    $this->offset = NULL;
    $this->sorts = array();
  }

  /**   *  --------------------------------------------------------------------------------   * WHERE INITIALIZER  * --------------------------------------------------------------------------------   *  * Prepares parameters for insertion in $wheres array().  */
  private function where_init($param) {
    if (!isset($this->wheres[$param])) {
      $this->wheres[$param] = array();
    }
  }

  public function error($str, $t) {
    echo $str;
    exit;
  }

}

?>

使用范例:

$table_name=trim(strtolower($this->table_name));
$this->mongo_db->where($where);
$order=!emptyempty($order)?array('AID'=>'DESC'):array('AID'=>'ASC');//升序降序
$infos=$this->mongo_db->listinfo($table_name,$order,$page,$pagesize);

这篇文章就到这结束了,大家可以多学习一下

(0)

相关推荐

  • mongodb操作的模块手动封装

    mongodb操作的模块手动封装 [注]:这些代码都是基于nodejs进行的. 在nodejs目录下创建一个模块文件*.js,以便调用, 以下是模块代码: function mongodbModel(dbname,dataform) { var MongoClient; var DB_CONN_STR; this.init = function() { MongoClient = require('mongodb').MongoClient; DB_CONN_STR = 'mongodb://l

  • 详解nodejs操作mongodb数据库封装DB类

    这个DB类也算是我经历了3个实际项目应用的,现分享出来,有需要的请借鉴批评. 上面的注释都挺详细的,我使用到了nodejs的插件mongoose,用mongoose操作mongodb其实蛮方便的. 关于mongoose的安装就是 npm install -g mongoose 这个DB类的数据库配置是基于auth认证的,如果您的数据库没有账号与密码则留空即可. /** * mongoose操作类(封装mongodb) */ var fs = require('fs'); var path = r

  • php封装的mongodb操作类代码

    核心代码 <?php /* * To change this template, choose Tools | Templates * and open the template in the editor. */ class mongo_db { private $config; private $connection; private $db; private $connection_string; private $host; private $port; private $user; p

  • MongoDB操作类封装实例代码

    前言 最近接到一个需求,要做MongoDB打点数据的统计,在学习过MongoDB的操作之后,封装了一个MongoDB的操作类,分为两部分,基本思想是参照了自己写过的mysql的操作类.一个是基本的操作类,包括所有基本操作的静态方法,还有一个是mongoobject,就是具体操作的实现类. 以后再写如何用spring boot写一个简单的统计服务. MongoDB操作类封装 mongobase代码如下: package com.fun.mongodb; import com.fun.frame.S

  • PHP封装的MSSql操作类完整实例

    本文实例讲述了PHP封装的MSSql操作类.分享给大家供大家参考,具体如下: <?php /*MSSql的操作类*/ class MSSql { var $link; var $querynum = 0; /*连接MSSql数据库,参数:dbsn->数据库服务器地址,dbun->登陆用户名,dbpw->登陆密码,dbname->数据库名字*/ function Connect($dbsn, $dbun, $dbpw, $dbname) { if($this->link

  • javascript封装的sqlite操作类实例

    本文实例讲述了javascript封装的sqlite操作类.分享给大家供大家参考.具体如下: function sql(name,v,desc,size,tables){ this.db=null; this.name=name; this.v=v; this.desc=desc; this.size=size; this.tables=tables; this.ini(); } sql.prototype.ini=function(){ var self=this; self.db=openD

  • php实现的mongodb操作类实例

    本文实例讲述了php实现的mongodb操作类.分享给大家供大家参考.具体如下: <?php /* * To change this template, choose Tools | Templates * and open the template in the editor. */ class mongo_db { private $config; private $connection; private $db; private $connection_string; private $h

  • PHP mongodb操作类定义与用法示例【适合mongodb2.x和mongodb3.x】

    本文实例讲述了PHP mongodb操作类定义与用法.分享给大家供大家参考,具体如下: 在别人基础上修改的mongodb操作类,适合mongodb2.x和mongodb3.x <?php /*** Mongodb类** examples: * $mongo = new HMongodb("127.0.0.1:11223"); * $mongo->selectDb("test_db"); * 创建索引 * $mongo->ensureIndex(&q

  • PHP FTP操作类代码( 上传、拷贝、移动、删除文件/创建目录)

    复制代码 代码如下: <?php/*** 作用:FTP操作类( 拷贝.移动.删除文件/创建目录 )* 时间:2006/5/9* 作者:欣然随风* QQ:276624915*/class class_ftp{    public $off; // 返回操作状态(成功/失败)    public $conn_id; // FTP连接    /**     * 方法:FTP连接     * @FTP_HOST -- FTP主机     * @FTP_PORT -- 端口     * @FTP_USER

  • php csv操作类代码

    请点击后面地址下载:csv操作类 使用说明如下: 1.生成csv文件 复制代码 代码如下: require "./include/csvdatafile.php"; set_time_limit(200); header("Content-type: application/RFC822"); header('Content-Disposition: attachment; filename=export.csv'); $arr_export_titles = ar

  • python 日期操作类代码

    完整代码 # -*- coding: utf-8 -*- '''获取当前日期前后N天或N月的日期''' from time import strftime, localtime from datetime import timedelta, date import calendar year = strftime("%Y",localtime()) mon = strftime("%m",localtime()) day = strftime("%d&qu

  • springboot封装JsonUtil,CookieUtil工具类代码实例

    这篇文章主要介绍了springboot封装JsonUtil,CookieUtil工具类过程解析,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下 JsonUtil public class JsonUtil { private static ObjectMapper objectMapper = new ObjectMapper(); public static String objectToString(Object object) throws

随机推荐