MongoDB数据库常用操作
<?php$conn = new Mongo();
//可以简写为
//$conn=new Mongo(); #连接本地主机,默认端口.
//$conn=new Mongo(“172.21.15.69″); #连接远程主机
//$conn=new Mongo(“xiaocai.loc:10086″); #连接指定端口远程主机
//$conn=new Mongo(“xiaocai.loc”,array(“replicaSet”=>true)); #负载均衡
//$conn=new Mongo(“xiaocai.loc”,array(“persist”=>”t”)); #持久连接
//$conn=new Mongo(“mongodb://sa:123@localhost”); #带用户名密码
#选择test数据库
$db=$conn->test;
//$db=$conn->selectDB("test"); #第二种写法
#选择集合(选择"表")
$collection=$db->user;
//$collection=$db->selectCollection("user"); #第二种写法
#插入操作
$data=array("uid"=>"zz123","user_name"=>"张三");
$result=$collection->insert($data); #简单插入
echo "插入数据的id".$data["_id"];
exit;
#插入操作 安全插入
$data=array("uid"=>"zz124","user_name"=>"李四");
$result=$collection->insert($data,true); #用于等待MongoDB完成操作,以便确定是否成功.(当有大量记录插入时使用该参数会比较有用)
#修改操作
$where=array("uid"=>"zz123");
$newdata=array("user_name"=>"张三三","tel"=>"123456789");
$result=$collection->update($where,array('$set'=>$newdata));
#替换更新
$where=array("uid"=>"zz124");
$newdata=array("user_age"=>"22","tel"=>"123456789");
$result=$collection->update($where,$newdata);
#批量更新
$where=array("uid"=>'zz');
$newdata=array("user_name"=>"zz","money"=>1000);
$result=$collection->update($where,array('$set'=>$newdata),array('multiple'=>true));
#自动累加
$where=array('money'=>1000);
$newdata=array('user_name'=>'edit');
$result=$collection->update($where,array('$set'=>$newdata,'$inc'=>array('money'=>-5)));
#删除节点
$where=array('uid'=>'zz124');
$result=$collection->update($where,array('$unset'=>'tel'));//删除节点tel
#删除数据
$collection->remove(array('uid'=>'zz124'));
#删除指定MongoId
$id = new MongoId('4d638ea1d549a02801000011');
$collection->remove(array('_id'=>(object)$id));
#查询数据 注:$gt为大于、$gte为大于等于、$lt为小于、$lte为小于等于、$ne为不等于、$exists不存在
echo 'count:'.$collection->count()."<br>"; #全部
echo 'count:'.$collection->count(array('uid'=>'zz123'))."<br>"; #可以加上条件
echo 'count:'.$collection->count(array('age'=>array('$gt'=>10,'$lte'=>30)))."<br>"; #大于50小于等于74
echo 'count:'.$collection->find()->limit(5)->skip(0)->count(true)."<br>"; #获得实际返回的结果数
#集合中所有文档
$cursor = $collection->find()->snapshot();
foreach ($cursor as $id => $value) {
echo "$id: "; var_dump($value);
echo "<br>";
}
#查询一条数据
$cursor = $collection->findOne();
#排除列false为不显示
$cursor = $collection->find()->fields(array("age"=>false,"tel"=>false));
#指定列true为显示
$cursor = $collection->find()->fields(array("user_name"=>true));
#(存在tel,age节点) and age!=0 and age<50
$where=array('tel'=>array('$exists'=>true),'age'=>array('$ne'=>0,'$lt'=>50,'$exists'=>true));
$cursor = $collection->find($where);
#分页获取结果集
$cursor = $collection->find()->limit(5)->skip(0);
#排序
$cursor = $collection->find()->sort(array('age'=>-1,'type'=>1)); #1表示降序 -1表示升序,参数的先后影响排序顺序
#索引
$collection->ensureIndex(array('age' => 1,'money'=>-1)); #1表示降序 -1表示升序
$collection->ensureIndex(array('age' => 1,'money'=>-1),array('background'=>true)); #索引的创建放在后台运行(默认是同步运行)
$collection->ensureIndex(array('age' => 1,'money'=>-1),array('unique'=>true)); #该索引是唯一的
#取得查询结果
$cursor = $collection->find();
$array=array();
foreach ($cursor as $id => $value) {
$array[]=$value;
}
#关闭连接
$conn->close();
?>
一个封装类
<?php
class HMongoDB {
//Mongodb连接
var $mongo;
var $curr_db_name;
var $curr_table_name;
var $error;
/**
* 构造函数
* 支持传入多个mongo_server(1.一个出问题时连接其它的server 2.自动将查询均匀分发到不同server)
*
* 参数：
* $mongo_server:数组或字符串-array("127.0.0.1:1111", "127.0.0.1:2222")-"127.0.0.1:1111"
* $connect:初始化mongo对象时是否连接，默认连接
* $auto_balance:是否自动做负载均衡，默认是
*
* 返回值：
* 成功：mongo object
* 失败：false
*/
function __construct($mongo_server, $connect=true, $auto_balance=true)
{
if (is_array($mongo_server))
{
$mongo_server_num = count($mongo_server);
if ($mongo_server_num > 1 && $auto_balance)
{
$prior_server_num = rand(1, $mongo_server_num);
$rand_keys = array_rand($mongo_server,$mongo_server_num);
$mongo_server_str = $mongo_server[$prior_server_num-1];
foreach ($rand_keys as $key)
{
if ($key != $prior_server_num - 1)
{
$mongo_server_str .= ',' . $mongo_server[$key];
}
}
}
else
{
$mongo_server_str = implode(',', $mongo_server);
} }
else
{
$mongo_server_str = $mongo_server;
}
try {
$this->mongo = new Mongo($mongo_server, array('connect'=>$connect));
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
}
}
function getInstance($mongo_server, $flag=array())
{
static $mongodb_arr;
if (empty($flag['tag']))
{
$flag['tag'] = 'default'; }
if (isset($flag['force']) && $flag['force'] == true)
{
$mongo = new HMongodb($mongo_server);
if (empty($mongodb_arr[$flag['tag']]))
{
$mongodb_arr[$flag['tag']] = $mongo;
}
return $mongo;
}
else if (isset($mongodb_arr[$flag['tag']]) && is_resource($mongodb_arr[$flag['tag']]))
{
return $mongodb_arr[$flag['tag']];
}
else
{
$mongo = new HMongodb($mongo_server);
$mongodb_arr[$flag['tag']] = $mongo;
return $mongo; } }
/**
* 连接mongodb server
*
* 参数：无
*
* 返回值：
* 成功：true
* 失败：false
*/
function connect()
{
try {
$this->mongo->connect();
return true;
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
}
}
/**
* select db
*
* 参数：$dbname
*
* 返回值：无
*/
function selectDb($dbname)
{
$this->curr_db_name = $dbname;
}
/**
* 创建索引：如索引已存在，则返回。
*
* 参数：
* $table_name:表名
* $index:索引-array("id"=>1)-在id字段建立升序索引
* $index_param:其它条件-是否唯一索引等
*
* 返回值：
* 成功：true
* 失败：false
*/
function ensureIndex($table_name, $index, $index_param=array())
{
$dbname = $this->curr_db_name;
$index_param['safe'] = 1;
try {
$this->mongo->$dbname->$table_name->ensureIndex($index, $index_param);
return true;
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
}
}
/**
* 插入记录
*
* 参数：
* $table_name:表名
* $record:记录
*
* 返回值：
* 成功：true
* 失败：false
*/
function insert($table_name, $record)
{
$dbname = $this->curr_db_name;
try {
$this->mongo->$dbname->$table_name->insert($record, array('safe'=>true));
return true;
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
}
}
/**
* 查询表的记录数
*
* 参数：
* $table_name:表名
*
* 返回值：表的记录数
*/
function count($table_name)
{
$dbname = $this->curr_db_name;
return $this->mongo->$dbname->$table_name->count();
}
/**
* 更新记录
*
* 参数：
* $table_name:表名
* $condition:更新条件
* $newdata:新的数据记录
* $options:更新选择-upsert/multiple
*
* 返回值：
* 成功：true
* 失败：false
*/
function update($table_name, $condition, $newdata, $options=array())
{
$dbname = $this->curr_db_name;
$options['safe'] = 1;
if (!isset($options['multiple']))
{
$options['multiple'] = 0; }
try {
$this->mongo->$dbname->$table_name->update($condition, $newdata, $options);
return true;
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
} }
/**
* 删除记录
*
* 参数：
* $table_name:表名
* $condition:删除条件
* $options:删除选择-justOne
*
* 返回值：
* 成功：true
* 失败：false
*/
function remove($table_name, $condition, $options=array())
{
$dbname = $this->curr_db_name;
$options['safe'] = 1;
try {
$this->mongo->$dbname->$table_name->remove($condition, $options);
return true;
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
} }
/**
* 查找记录
*
* 参数：
* $table_name:表名
* $query_condition:字段查找条件
* $result_condition:查询结果限制条件-limit/sort等
* $fields:获取字段
*
* 返回值：
* 成功：记录集
* 失败：false
*/
function find($table_name, $query_condition, $result_condition=array(), $fields=array(),$flag=false)
{
$dbname = $this->curr_db_name;
$cursor = $this->mongo->$dbname->$table_name->find($query_condition, $fields);
if (!empty($result_condition['start'])||$result_condition['start']===0)
{
$cursor->skip($result_condition['start']);
}
if (!empty($result_condition['limit']))
{
$cursor->limit($result_condition['limit']);
}
if (!empty($result_condition['sort']))
{
$cursor->sort($result_condition['sort']);
}
$result = array();
try {
// while ($cursor->hasNext())
// {
// $result[] = $cursor->getNext();
// }
/*
foreach ($cursor as $key=>$value) {
echo $key;
$temp=$value;
foreach ($fields as $fvalue) {
$result[$key][$fvalue]=$temp[$fvalue];
}
}*/
if($flag)//array_search("limit", $result_condition,false)!==false
{
for ($i=0;$i<$cursor->count();$i++)
{
if($cursor->hasNext())
{
$temp=$cursor->getNext();
foreach ($fields as $value) {
$result[$i][$value]=$temp[$value];
}
}
}
}
else
{
while ($cursor->hasNext())
{
$result[] = $cursor->getNext();
}
}
/*
$i=0;
while ($cursor->hasNext())
{
$temp=$cursor->getNext();
foreach ($fields as $value) {
$result[$i][$value]=$temp[$value];
}
$i++;
}
$i=0;
*/
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
}
catch (Exception $e)
{
$this->error = $e->getMessage();
return false;
}
return $result;
}
/**
* 查找一条记录
*
* 参数：
* $table_name:表名
* $condition:查找条件
* $fields:获取字段
*
* 返回值：
* 成功：一条记录
* 失败：false
*/
function findOne($table_name, $condition, $fields=array())
{
$dbname = $this->curr_db_name;
return $this->mongo->$dbname->$table_name->findOne($condition, $fields);
}
/**
* 获取当前错误信息
*
* 参数：无
*
* 返回值：当前错误信息
*/
function getError()
{
return $this->error;
}
}?>
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]