php封装的mongodb操作类代码
网络编程 2021-07-05 08:24www.168986.cn编程入门
这篇文章主要分享一个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 ments 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 oured 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 oured 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);
这篇文章就到这结束了,大家可以多学习一下
编程语言
- 如何快速学会编程 如何快速学会ug编程
- 免费学编程的app 推荐12个免费学编程的好网站
- 电脑怎么编程:电脑怎么编程网咯游戏菜单图标
- 如何写代码新手教学 如何写代码新手教学手机
- 基础编程入门教程视频 基础编程入门教程视频华
- 编程演示:编程演示浦丰投针过程
- 乐高编程加盟 乐高积木编程加盟
- 跟我学plc编程 plc编程自学入门视频教程
- ug编程成航林总 ug编程实战视频
- 孩子学编程的好处和坏处
- 初学者学编程该从哪里开始 新手学编程从哪里入
- 慢走丝编程 慢走丝编程难学吗
- 国内十强少儿编程机构 中国少儿编程机构十强有
- 成人计算机速成培训班 成人计算机速成培训班办
- 孩子学编程网上课程哪家好 儿童学编程比较好的
- 代码编程教学入门软件 代码编程教程