PHP gives us the ability to work with MongoDB, highlighting the importance of CRUD (Create, Read, Update, Delete) operations for database management.
Here are some requirements to start using MongoDB with PHP:
- Installing MongoDB
- Installing PHP MongoDB Driver
- Setting Up a Development Environment ( XAMPP, Docker, or direct Apache/Nginx configurations )
Let us move on to the following section to understand what CRUD means and how to use it to access a MongoDB database.
What does Mean CRUD in MongoDB?
In MongoDB, the term CRUD refers to the four primary operations used to manage data: Create, Read, Update, and Delete:
- The Create operation allows you to insert new documents into a collection. For example, you can add user data or any other type of information to the database.
- Read operation which used to query and retrieve data from a database. You can filter, sort, and project the data as needed.
- Update operation which helps us to modify existing documents in a collection. You can update specific fields or replace entire documents.
- Delete operation to remove documents from a collection. You can specify criteria to delete specific documents or remove all documents in a collection.
Let’s see an example for each one.
Examples of CRUD in MongoDB and PHP
Create
The “Create” operation is all about adding new data to your database. Here is how you can add a document:
$collection = $database->selectCollection('users');
$result = $collection->insertOne(['name' => 'John Doe', 'email' => '[email protected]']);
echo "Inserted document with ID: " . $result->getInsertedId();
Before insert a new document to database, you need to select the users collection. Adding a document with the name and email fields, and the database automatically generates a unique _id for it. The getInsertedId() method then gives you that ID.
Read
The ‘Read’ operation is used to retrieve data from the database. Let’s see how to do it:
$collection = $database->selectCollection('users');
$result = $collection->findOne(['name' => 'John Doe']);
echo "Found User: " . $result['email'];
Here, you are asking the database to find the first document where the name is “John Doe.” The findOne method brings it back as an associative array, and you can access specific fields, like email.
Update
Updating means modifying an existing entry. Say you want to change John’s email. Here is how you do it:
$collection = $database->selectCollection('users');
$updateResult = $collection->updateOne(
['name' => 'John Doe'],
['$set' => ['email' => '[email protected]']]
);
echo "Updated " . $updateResult->getModifiedCount() . " document(s)";
This code searches for a document with the name “John Doe” and updates the email field to the new value. The getModifiedCount() method tells you how many documents were successfully updated.
Delete
The ‘Delete’ operation is responsible for removing data from the database. If John no longer needs to be in your collection, you can remove him like this:
$collection = $database->selectCollection('users');
$deleteResult = $collection->deleteOne(['name' => 'John Doe']);
echo "Deleted " . $deleteResult->getDeletedCount() . " document(s)";
Here, you are specifying the criteria (name: 'John Doe') for deletion, and the getDeletedCount() method confirms how many documents were removed.
Let’s summarize it.
Wrapping Up
That is the essence of CRUD operations in MongoDB: Create, Read, Update, and Delete. These four operations form the basis of how you interact with your database.
Here is a quick recap:
- Create: Add new documents to your collection using methods like
insertOne()orinsertMany(). - Read: Retrieve documents from the database with methods like
findOne()orfind()for more complex queries. - Update: Modify existing documents using methods like
updateOne()orupdateMany()with operators like$setor$inc. - Delete: Remove documents from your collection using methods like
deleteOne()ordeleteMany().
Each operation is a critical piece of database management, giving you full control over your data.
Similar Reads
The PHP associative array is a structured collection wherein data elements are organized into lists or groups. Each element is…
The variable scope in PHP refers to the variables, functions, and classes that can be accessed within different parts of…
The PHP switch statement is multiple conditions to only execute one block if its condition generating a true boolean value.…
The array_key_last gives you the last key in an array and works with numeric and associative arrays in PHP. It…
File Handling in PHP is an important tool especially when you need to manage files such as reading, writing, or…
User input can be risky. Hackers exploit weak validation to inject malicious data. PHP filter_input() helps you sanitize and validate…
Deleting records in MongoDB is a common task. You might need to clear old data, remove outdated entries, or handle…
You can assign the boolean data type to PHP variables or use it as a direct value. This enables you…
PHP and MySQL have become an inseparable pair for web developers. One handles the logic, while the other stores the…
The PHP operator precedence refers to when doing a calculation for three or more numbers, they are calculating its values…