Insert JSON into MongoDb directly from PHP

Question

I have an Android application which sends json data to PHP script. The PHP script have to save the data into MongoDB.

When I insert the data, MongoDB treat this data as a string.

$conn = new Mongo('mongodb://127.0.0.1:27017');

// access database
$db = $conn->Data;

// access collection
$collection = $db->Collection;
$collection->insert($myjson)

How can I say to MongoDB PHP driver that it is already a json document?

Thanks

Answer 1

The PHP MongDB Driver accepts arrays for inserts and queries (see here: http://www.php.net/manual/en/mongo.queries.php)

So you need to convert your JSON to an array.

Luckily, in general this is quite easy ... here is a snippet from a longer piece of code (see this article) to insert JSON data from the Twitter API into an array, then into MongoDB:

// Convert JSON to a PHP array
$usertimeline = json_decode($usertimeline);

// Loop array and create seperate documents for each tweet
foreach ($usertimeline as $id => $item) {
   $collection->insert($item);
}

Note the json_decode() function can convert to an array by passing true as the second parameter.