分析php中的mongodb操作類

2020-03-22 18:14:07

字體：大中小

來源：轉載

供稿：網友

這篇文章主要介紹了php實現的mongodb操作類,較為詳細的分析了php針對mongodb數據庫操作的各種常用技巧,并將其封裝進一個完整的類文件中以便于調用,非常具有實用價值,需要的朋友可以參考下

本文實例講述了php實現的mongodb操作類。分享給大家供大家參考。具體如下：

 ?php  * To change this template, choose Tools | Templates * and open the template in the editor.html' target='_blank'>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);

總結：以上就是本篇文的全部內容，希望能對大家的學習有所幫助。