If you’re used to MySQL then making the move to MongoDB may be daunting. Here’s a simple walkthrough with examples to get you started.<\/p>\n
Firstly, connect to your server and select the database with which you wish to work.<\/p>\n
Access the relevant collection (equivalent to a table in MySQL). In this example I will be using “cars”. If a collection doesn’t already exist, it will be created. Inserting data (called a document) into a collection is pretty straight forward. Then use the “insert” command: Simple. You can also store arrays within the document: If the square brackets are confusing, it’s the same as this: You can also add “fields” to collections in the same way. For example if I wanted to add “top speed” to just the Ferrari F40: If you want to find all Ferraris: If you want to find all cars with 18″ wheels: If you want to find all Ferraris with 18″ wheels: If you’re used to MySQL then making the move to MongoDB may be daunting. Here’s a simple walkthrough with examples to get you started. Setup Firstly, connect to your server and select the database with which you wish to work. $m = new MongoClient(“server.co.uk”); $db = $m->selectDB(“database”); Access the relevant collection (equivalent to a table […]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"class_list":["post-1956","post","type-post","status-publish","format-standard","hentry","category-web-and-ux"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/posts\/1956","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/comments?post=1956"}],"version-history":[{"count":0,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/posts\/1956\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/media?parent=1956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/categories?post=1956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}$m = new MongoClient(\"server.co.uk\");
\n$db = $m->selectDB(\"database\");<\/code><\/p>\n
\n$collection = $db->cars;<\/code><\/p>\nInsert Data<\/h2>\n
\nCreate an array containing the data you want to add:
\n$insert = array('brand'=>'Ferrari', 'model'=>F40')));<\/code><\/p>\n
\n$collection->insert($insert);<\/code><\/p>\n
\n$insert = array('brand'=>'Ferrari', 'model'=>F40', 'wheels'=>array(['number'=>4, 'size'=>18]));<\/code><\/p>\n
\n$insert = array('brand'=>'Ferrari', 'model'=>F40', 'wheels'=>array(array('number'=>4, 'size'=>18)));<\/code><\/p>\nUpdate Data<\/h2>\n
$criteria = array('brand'=>'Ferrari', 'model'=>'F40');
\n$new_data = array('$set'=>array('wheels'=>array('size'=>17)));
\n$collection->update($criteria, $new_data);<\/code>
\nThe above will find any Ferrari F40 and update the wheel size to 17.
\nNote:<\/strong> the dollar ($) doesn’t denote a variable, and must be enclosed in single quotes.<\/p>\n
\n$criteria = array('brand'=>'Ferrari', 'model'=>'F40');
\n$new_data = array('$set'=>array('top speed'=>201));
\n$collection->update($criteria, $new_data);<\/code><\/p>\nSelect Data<\/h2>\n
\n$search = array('brand'=>'Ferrari');
\n$cars = $collection->find($search);<\/code><\/p>\n
\n$search = array('wheels.size'=>18);
\n$cars = $collection->find($search);<\/code><\/p>\n
\n$search = array('brand'=>'Ferrari', 'wheels.size'=>18);
\n$cars = $collection->find($search);<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"