自己负责的统一聊天及推送项目,数据库使用mongodb,一直想整理,今天刚好有时间
注意事项:
1、对于mongodb3.x php的mongo扩展要使用1.6以上,当时因为这个问题调试挺久,发现php的mongo扩展使用的1.4,总是连不上2、mongodb3.x和mongodb2.x的安全认证机制不一样,mongodb3.x创建用户使用db.createUser,mongodb2.x使用db.addUser
3、mongodb的客户端管理工具NoSQL Manager for MongoDB(收费,功能强大)和rockmongo(纯php开发,网页版)
4、杀进程停掉mongodb服务不要用kill -9 ,不然可能会造成数据丢失
一、安装mongodb3.0.1服务端
1、环境准备:
mkdir /usr/local/mongodb //创建mongodb存放目录
mkdir -p /data/mongodata //创建数据存放目录
mkdir -p /data/log/mongolog //创建日志存放目录
2、下载:
curl -O https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-rhel62-3.0.1.tgz
3、安装:
tar xf mongodb-linux-x86_64-rhel62-3.0.1.tgz
cd mongodb-linux-x86_64-rhel62-3.0.1
cp -r * /usr/local/mongodb
4、启动服务 以配置文件启动,先不要加auth参数,下一步安全认证设置好后再开启
vi /usr/local/mongodb/bin/mongodb.conf
dbpath = /data/mongodb/db #数据文件存放目录
logpath = /data/mongodb/logs/mongodb.log #日志文件存放目录
bind_ip = 127.0.0.1,192.168.10.111
port = 27017 #端口
fork = true #以守护程序的方式启用,即在后台运行
#auth=true
nohttpinterface = true
:wq!
/usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf &
5、开启安全认证,默认安装不需用户名和密码就可以连接,很不安全
/usr/local/mongodb/bin/mongo
use admin
db.createUser({user: "root", pwd: "123456",roles: [ { role: "root", db: "admin" } ]})#创建超级管理员
db.auth("root","123456"); #认证帐号
db.system.users.find(); #查看当前已有的用户信息
use testdb #需认证的库
db.createUser({user: "testdb", pwd: "123456",roles: [ { role: "readWrite", db: "testdb" } ]}) #库管理员
use testdb #测试
db.auth("testdb","123456");
> db.auth("testdb","123456");
1
6、关闭mongodb,这里使用杀进程方式,也可用db.shutdownServer()进行
ps -ef|grep mongo
root 1761 1 1 09:48 ? 00:03:27 /usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf
kill 1761
7、以安全认证方式启动mongodb服务
vi /usr/local/mongodb/bin/mongodb.conf
dbpath = /data/mongodb/db #数据文件存放目录
logpath = /data/mongodb/logs/mongodb.log #日志文件存放目录
bind_ip = 127.0.0.1,192.168.10.111
port = 27017 #端口
fork = true #以守护程序的方式启用,即在后台运行
auth=true #注意这里要开启
nohttpinterface = true
:wq!
/usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf &
8、设置开机启动
vi /etc/rc.d/rc.local
在文件中加入:
/usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf
二、安装php mongo扩展
1、安装mongo扩展
wget http://pecl.php.net/get/mongo-1.6.11.tgz
tar zxvf mongo-1.6.11.tgz
cd mongo-1.6.11
/usr/bin/phpize
./configure --with-php-config=/usr/bin/php-config
make && make install
<pre name="code" class="php"><span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">32位系统在 Installing shared extensions: /usr/lib/php/modules/</span>
64位系统在 Installing shared extensions: /usr/lib64/php/modules/
2、php加载扩展vi /etc/php.ini
extension_dir = "/usr/lib64/php/modules"
extension="mongo.so"
:wq! 保存退出
3、重新加载php-fpm
service php-fpm reload
4、测试,查看phpinfo信息,如下图所示:
三、php代码测试操作mongodb
test.php
<?php
include 'HMongodb.class.php';//自己简单封装了下 mongodb的单例 增删改查统计 增时返回主键_id
$mongo =new HMongodb('mongodb://open:mongo123@localhost:27017/onechat');
echo '<pre>';print_r($mongo);
$mongo->insert("user", array("id"=>1, "name"=>"黑"));
$mongo->update("user", array("id"=>1),array("id"=>1,"title"=>"白"));
$data=$mongo->findOne("user", array("id"=>1));
echo '<pre>';print_r($data);exit;
?>
测试结果:
HMongodb.class.php
<?php
/*** Mongodb类**
使用:
* $mongo = new HMongodb("127.0.0.1:11223");
* $mongo->selectDb("test_db");
* 创建索引
* $mongo->ensureIndex("user", array("id"=>1), array('unique'=>true));
* 获取表的记录
* $mongo->count("user");
* 插入记录
* $mongo->insert("user", array("id"=>2, "title"=>"asdqw"));
* 更新记录 array('$set'=>$newdata) 只修改指定字段
* $mongo->update("user", array("id"=>1),array("id"=>1,"title"=>"bbb"));
* 更新记录-存在时更新,不存在时添加-相当于set
* $mongo->update("user", array("id"=>1),array("id"=>1,"title"=>"bbb"),array("upsert"=>1));
* 查找记录
* $mongo->find("user", array("title"=>"asdqw"), array("start"=>2,"limit"=>2,"sort"=>array("id"=>1)))
* 查找一条记录
* $mongo->findOne("user", array("id"=>1));
* 删除记录
* $mongo->remove("user", array("title"=>"bbb"));
* 仅删除一条记录
* $mongo->remove("user", array("title"=>"bbb"), array("justOne"=>1));
* 获取Mongo操作的错误信息
* $mongo->getError();
*/
class HMongodb {
public $_idType=1;//主键类型 1 string 0 obj
//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 = trim($mongo_server);
//$config_arr=explode('/',$mongo_server);
//$this->curr_db_name = array_pop($config_arr);
$last_index=strrpos($mongo_server_str,'/');
$db_name=substr($mongo_server_str,$last_index+1,strlen($mongo_server_str));
$this->curr_db_name = $db_name;//获取dbname
//print_r($db_name);exit;
}
try {
$this->mongo = new MongoClient($mongo_server, array('connect'=>$connect));
}
catch (MongoConnectionException $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 (MongoConnectionException $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 (MongoCursorException $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 (MongoCursorException $e)
{
$this->error = $e->getMessage();
return false;
}
}
/**
* 查询表的记录数
*
* 参数:
* $table_name:表名
*
* 返回值:表的记录数
*/
function count($table_name,$query_condition=array())
{
$dbname = $this->curr_db_name;
return $this->mongo->$dbname->$table_name->find($query_condition)->count();
}
//$newdata存在有_id则更新 不存在则插入
function save($table_name, $newdata) {
$dbname = $this->curr_db_name;
if($this->_idType && $newdata['_id']){
$newdata['_id']=new MongoId($newdata['_id']);
}
return $this->mongo->$dbname->$table_name->save($newdata);
}
/**
* 更新记录
*
* 参数:
* $table_name:表名
* $condition:更新条件
* $newdata:新的数据记录
* $options:更新选择-upsert/multiple
*
* 返回值:
* 成功:true
* 失败:false
*/
function update($table_name, $condition, $newdata, $options=array())
{ if($this->_idType && $condition['_id']){
$condition['_id']=new MongoId($condition['_id']);
}
$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 (MongoCursorException $e)
{
$this->error = $e->getMessage();
return false;
} }
/**
* 删除记录
*
* 参数:
* $table_name:表名
* $condition:删除条件
* $options:删除选择-justOne
*
* 返回值:
* 成功:true
* 失败:false
*/
function remove($table_name, $condition, $options=array())
{
if($this->_idType && $condition['_id']){
$condition['_id']=new MongoId($condition['_id']);
}
$dbname = $this->curr_db_name;
$options['safe'] = 1;
try {
$this->mongo->$dbname->$table_name->remove($condition, $options);
return true;
}
catch (MongoCursorException $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())
{
$dbname = $this->curr_db_name;
$cursor = $this->mongo->$dbname->$table_name->find($query_condition, $fields);
if (!empty($result_condition['start']))
{
$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())
{
$row= $cursor->getNext();
//print_r($cursor->getNext());exit;
if($this->_idType && is_object($row['_id'])){
$row['_id']=$row['_id']->__toString();//转换字符串
}
$result[] =$row;
}
}
catch (MongoConnectionException $e)
{
$this->error = $e->getMessage();
return false;
}
catch (MongoCursorTimeoutException $e)
{
$this->error = $e->getMessage();
return false;
}
return $result;
}
/**
* 查找一条记录
*
* 参数:
* $table_name:表名
* $condition:查找条件
* $fields:获取字段
*
* 返回值:
* 成功:一条记录
* 失败:false
*/
function findOne($table_name, $condition, $fields=array())
{
if($this->_idType && $condition['_id']){
$condition['_id']=new MongoId($condition['_id']);
}
$dbname = $this->curr_db_name;
$row=$this->mongo->$dbname->$table_name->findOne($condition, $fields);
if($this->_idType && is_object($row['_id'])){
$row['_id']=$row['_id']->__toString();//转换字符串
}
return $row;
}
/**
* 获取当前错误信息
*
* 参数:无
*
* 返回值:当前错误信息
*/
function getError()
{
return $this->error;
}
//返回原生mongodb collection集合对象
function getCollection($table_name){
$dbname = $this->curr_db_name;
return $this->mongo->$dbname->$table_name;
}
//分组统计
function group($table_name,$keys,$initial,$reduce,$condition){
$dbname = $this->curr_db_name;
$g = $this->mongo->$dbname->$table_name->group($keys, $initial, $reduce,$condition);
return $g;
}
}