php给mongodb添加索引

概述<?php/***mongo字段加索引*CreatedbyPhpStorm.*User:Administrator*Date:2021/6/11*Time:15:02*/$mongoDB='deyibao';//mongo数据库名$mongoClient=newMongoClient();//mongo连接$db=$mongoClient->selectDB($mongoDB);//选择数据库$colle

<?PHP/** * mongo字段加索引 * Created by PHPStorm. * User: administrator * Date: 2021/6/11 * Time: 15:02 */$mongoDB = 'deyibao';//mongo数据库名$mongoClIEnt = new MongoClIEnt();//mongo连接$db = $mongoClIEnt->selectDB($mongoDB);//选择数据库$collectionnames = $db->getCollectionnames();//获取所有的集合名$rule1 = '/task_record_.*/';//正则表达式$rule2 = '/turn_.+_record_.*/';foreach ($collectionnames as $k=>$v){    $index = $db->$v->getIndexInfo();//获取索引    if (preg_match_all($rule1,$v)){        foreach ($index as $key=>$val){            if (!strstr('date',$val['name'])) $collection = $db->$v->ensureIndex(['date' => 1],['background'=>true]);            if (!strstr('userID',$val['name'])) $collection = $db->$v->ensureIndex(['userID' => 1],['background'=>true]);        }    }    if (preg_match_all($rule2,$v) || strstr($v,'turn_luck_money')){        foreach ($index as $key=>$val){            if (!strstr('date',$val['name'])) $collection = $db->$v->ensureIndex(['date' => 1],['background'=>true]);            if (!strstr('userID',$val['name'])) $collection = $db->$v->ensureIndex(['userID' => 1],['background'=>true]);            if (!strstr('type',$val['name'])) $collection = $db->$v->ensureIndex(['type' => 1],['background'=>true]);            if (!strstr('createTime',$val['name'])) $collection = $db->$v->ensureIndex(['createTime' => 1],['background'=>true]);        }    }    if (strstr($v,'turn_user_sign') || strstr($v,'turn_message') || strstr($v,'turn_group_rankList_log')) {        foreach ($index as $key=>$val){            if (!strstr('userID',$val['name'])) $collection = $db->$v->ensureIndex(['userID' => 1],['background'=>true]);        }    }    if (strstr($v,'turn_group_rankList')) {        foreach ($index as $key=>$val){            if (!strstr('date',$val['name'])) $collection = $db->$v->ensureIndex(['date' => 1],['background'=>true]);            if (!strstr('groupID',$val['name'])) $collection = $db->$v->ensureIndex(['groupID' => 1],['background'=>true]);        }    }    if (strstr($v,'turn_contribution')) {        foreach ($index as $key=>$val){            if (!strstr('userID',$val['name'])) $collection = $db->$v->ensureIndex(['userID' => 1],['background'=>true]);            if (!strstr('ctbUserID',$val['name'])) $collection = $db->$v->ensureIndex(['ctbUserID' => 1],['background'=>true]);            if (!strstr('date',$val['name'])) $collection = $db->$v->ensureIndex(['date' => 1],['background'=>true]);            if (!strstr('tIErNum',$val['name'])) $collection = $db->$v->ensureIndex(['tIErNum' => 1],['background'=>true]);        }    }    if (strstr($v,'turn_exchange')) {        foreach ($index as $key=>$val){            if (!strstr('date',$val['name'])) $collection = $db->$v->ensureIndex(['date' => 1],['background'=>true]);            if (!strstr('configID',$val['name'])) $collection = $db->$v->ensureIndex(['configID' => 1],['background'=>true]);            if (!strstr('userID',$val['name'])) $collection = $db->$v->ensureIndex(['userID' => 1],['background'=>true]);            if (!strstr('type',$val['name'])) $collection = $db->$v->ensureIndex(['type' => 1],['background'=>true]);        }    }}

根据自己需求更改，此文章只为记录 总结

以上是内存溢出为你收集整理的php给mongodb添加索引全部内容，希望文章能够帮你解决php给mongodb添加索引所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。