Specify Mongo DB and Collection name as variables in PHP

Question

MongoDB's PHP library allows me to connect to a collection like this (from example):

$m = new Mongo(); 
$db = $m->comedy; 
$collection = $db->cartoons;

But how do I specify the database and/or the collection name as a variable? What I want to do is something like this:

$m = new Mongo();
$dbname = "comedy"; 
$collectionname = "cartoons"; 
$db = $m[$dbname]; 
$collection = $db[$collectionname];

I can do this using the Python API, so I find it strange that I am not able to do it using PHP.

UPDATE: This is the error I am getting when I use the above method, which leads me to believe there's no built-in way to address MongoDB collections using variable names?

Fatal error: Cannot use object of type Mongo as array

ANSWER: As per accepted answer below, this will work:

$db = $m->$dbname; 
$collection = $db->$collectionname;

Evan Teran · Accepted Answer · 2013-01-26 18:53:45Z

3

You can still get it by a variable using -> ie $m->$dbname via http://php.net/manual/en/mongo.tutorial.php

edited Jan 26, 2013 at 18:53

Evan Teran

90.9k33 gold badges188 silver badges246 bronze badges

answered Apr 30, 2012 at 21:44

dweiss

8324 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Suman Over a year ago

Thanks, just edited it. But that didn't fix it - this is the error I get: "Fatal error: Cannot use object of type Mongo as array"

dweiss Over a year ago

You can still get it by a variable using -> ie $m->$dbname via php.net/manual/en/mongo.tutorial.php

Suman Over a year ago

Ah, that did work! Thanks, can you edit/update your answer? Marking this as right?

Ohad Cohen · Accepted Answer · 2020-07-22 10:25:59Z

0

Updated code for mongodb library:

$dbname = "comedy";
$collectionname = "cartoons";
$collection = (new MongoDB\Client("mongodb://".$config["MONGO_USER"].":".$config["MONGO_PASS"]."@".$config["MONGO_SERVER"]."/".$dbname))
        ->{$dbname}->{$collectionname};

$insertOneResult = $collection->insertOne([
    'data'=>"my data"
]);

answered Jul 22, 2020 at 10:25

Ohad Cohen

6,2023 gold badges42 silver badges38 bronze badges

Comments

Kindaian · Accepted Answer · 2013-02-15 12:24:44Z

-1

That will work with the provision that the "names" used are valid var names in PHP (ex. if you use a space on the "collection" name, it will fail).

answered Feb 15, 2013 at 12:24

Kindaian

1

Collectives™ on Stack Overflow

Specify Mongo DB and Collection name as variables in PHP

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related