Calling a stored procedure via PHP in MongoDB

Question

Dear everybody who can help,

I have this PHP > MongoDB problem, I want to call a stored procedure (stored in db.system.js collection) via PHP.

I have no parameters, only a returning JSON object which looks like this:

{"archived":[the number of the archived messages]}

It works good in the shell on the database server, but when I try to call it via the PHP driver it just doesn't "say" anything...

My code looks like this:

$DB->execute(
    new MongoCode(
        "function () { return archiveMessages(); }"
    )
);

I have also tried to use somehow like this:

$DB->execute("archiveMessages()");

Please help, I've got stuck on this one... I only want to call that sh*t after updating the collection...

Thank you in advance, B

kristina · Accepted Answer · 2012-03-29 16:02:37Z

4

Are you sure you're using the same database? Try simplifying it to a basic example, e.g.,

$m = new Mongo();
$db = $m->foo;

$db->system->js->save(array("_id"=>"archiveMessages", 
   "value"=>new MongoCode("function() { return 3; }")));

print_r($db->execute("archiveMessages()"));

Results in:

Array
(   
    [retval] => 3
    [ok] => 1
)

answered Mar 29, 2012 at 16:02

kristina

23.8k10 gold badges73 silver badges86 bronze badges

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

4 Comments

benqus Over a year ago

I am using the same DB, it's a constant. Just like almost anything else. This is the only thing I can't do now.

kristina Over a year ago

Can you print_r the result you're getting? [retval] => null?

benqus Over a year ago

I get an "Error 500: Internal Server Error". My PHP driver seems to work okay, does everything I ask from it.

kristina Over a year ago

That's from your app server, not MongoDB. Can you write a test script and just run it through PHP cli?

A. Jesse Jiryu Davis · Accepted Answer · 2012-03-15 15:43:17Z

1

Check the documentation:

http://php.net/manual/en/mongodb.execute.php

Are you assigning the return value of execute() to a variable?

answered Mar 15, 2012 at 15:43

A. Jesse Jiryu Davis

24.1k5 gold badges60 silver badges72 bronze badges

1 Comment

benqus Over a year ago

Yes, I have been even checking the returning values... I needed that number I have mentioned above for displaying...

Collectives™ on Stack Overflow

Calling a stored procedure via PHP in MongoDB

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related