本文实例讲述了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);
希望本文所述对大家的php程序设计有所帮助。
本文地址:https://www.stayed.cn/item/6152
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我