Getting Set Up to Run PHP With MongoDB
Rate this quickstart
Welcome to this quickstart guide for MongoDB with PHP. I know you're probably excited to get started writing code and building applications using PHP with MongoDB. We'll get there, I promise. Let's go through some necessary set-up first, however.
This guide is organized into a few sections over a few articles. This first article addresses the installation and configuration of your development environment. PHP is an integrated web development language. There are several components you typically use in conjunction with the PHP programming language. If you already have PHP installed and you simply want to get started with PHP and MongoDB, feel free to skip to the next article in this series.
Let's start with an overview of what we'll cover in this series.
A brief note on PHP and Apache: Because PHP is primarily a web language — that is to say that it's built to work with a web server — we will spend some time at the beginning of this article ensuring that you have PHP and the Apache web server installed and configured properly. There are alternatives, but we're going to focus on PHP and Apache.
PHP was developed and first released in 1994 by Rasmus Lerdorf. While it has roots in the C language, PHP syntax looked much like Perl early on. One of the major reasons for its massive popularity was its simplicity and the dynamic, interpreted nature of its implementation.
You'll need the following installed on your computer to follow along with this tutorial:
- MacOS Catalina or later: You can run PHP on earlier versions but I'll be keeping to MacOS for this tutorial.
- Homebrew Package Manager: The missing package manager for MacOS.
- PECL: The repository for PHP Extensions.
First, let's install the command line tools as these will be used by Homebrew:
1 xcode-select --install
Next, we're going to use a package manager to install things. This ensures that our dependencies will be met. I prefer
Homebrew
, or brew
for short. To begin using brew
, open your terminal app
and type:1 /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
This leverages
curl
to pull down the latest installation scripts and binaries for brew
.The installation prompts are fairly straightforward. Enter your password where required to assume root privileges for the install. When it's complete, simply type the following to verify that
brew
is installed correctly:1 brew --version
If you experience trouble at this point and are unable to get
brew
running, visit the Homebrew installation docs.You can also verify your homebrew installation using
brew doctor
. Confirm that any issues or error messages are resolved prior to moving forward. You may find warnings, and those can usually be safely ignored.To use MongoDB with PHP, we must install Apache.
The latest macOS 11.0 Big Sur comes with Apache 2.4 pre-installed but Apple removed some critical scripts, which makes it difficult to use.
So, to be sure we're all on the same page, let's install Apache 2.4 via Homebrew and then have it to run on the standard ports (80/443).
When I was writing this tutorial, I wasted a lot of time trying to figure out what was happening with the pre-installed version. So, I think it's best if we install from scratch using Homebrew.
1 sudo apachectl stop # stop the existing apache just to be safe 2 sudo launchtl unload -w /System/Library/LaunchDaemons/org.apache.httpd.plist # Remove the configuration to run httpd daemons
Now, let's install the latest version of Apache:
1 brew install httpd
Once installed, let's start up the service.
1 brew services start httpd
You should now be able to open a web browser and visit
http://localhost:8080
and see something similar to the following:The standard Apache web server doesn't have support for PHP built in. Therefore, we need to install PHP and the PHP Extension to recognize and interpret PHP files.
If you've installed previous versions of PHP, I highly recommend that you clean things up by removing older versions. If you have previous projects that depend on these versions, you'll need to be careful, and back up your configurations and project files.
Homebrew is a good way for MacOS users to install PHP.
1 brew install php
Once this completes, you can test whether it's been installed properly by issuing the following command from your command-line prompt in the terminal.
1 php --version
You should see something similar to this:
1 $ php --version 2 PHP 8.0.0 (cli) (built: Nov 30 2020 13:47:29) ( NTS ) 3 Copyright (c) The PHP Group 4 Zend Engine v4.0.0-dev, Copyright (c) Zend Technologies 5 with Zend OPcache v8.0.0, Copyright (c), by Zend Technologies
Now that we have
php
installed, we can configure Apache to use PHP
to interpret our web content, translating our php
commands instead of displaying the source code.PECL (PHP Extension Community Library) is a repository for PHP Extensions, providing a directory of all known extensions and hosting facilities or the downloading and development of PHP extensions.
pecl
is the binary or command-line tool (installed by default with PHP) you can use to install and manage PHP extensions. We'll do that in this next section.Install the PHP MongoDB extension before installing the PHP Library for MongoDB. It's worth noting that full MongoDB driver experience is provided by installing both the low-level extension (which integrates with our C driver) and high-level library, which is written in PHP.
You can install the extension using PECL on the command line:
1 pecl install mongodb
Next, we need to modify the main
php.ini
file to include the MongoDB extension. To locate your php.ini
file, use the following command:1 $ php --ini 2 Configuration File (php.ini) Path: /usr/local/etc/php/8.3
To install the extension, copy the following line and place it at the end of your
php.ini
file.1 extension=mongodb.so
After saving php.ini, restart the Apache service and to verify installation, you can use the following command.
1 brew services restart httpd 2 3 php -i | grep mongo
You should see output similar to the following:
1 $ php -i | grep mongo 2 mongodb 3 libmongoc bundled version => 1.25.2 4 libmongoc SSL => enabled 5 libmongoc SSL library => OpenSSL 6 libmongoc crypto => enabled 7 libmongoc crypto library => libcrypto 8 libmongoc crypto system profile => disabled 9 libmongoc SASL => enabled 10 libmongoc SRV => enabled 11 libmongoc compression => enabled 12 libmongoc compression snappy => enabled 13 libmongoc compression zlib => enabled 14 libmongoc compression zstd => enabled 15 libmongocrypt bundled version => 1.8.2 16 libmongocrypt crypto => enabled 17 libmongocrypt crypto library => libcrypto 18 mongodb.debug => no value => no value
You are now ready to begin using PHP to manipulate and manage data in your MongoDB databases. Next, we'll focus on getting your MongoDB cluster prepared.
If you are experiencing issues with installing the MongoDB extension, there are some tips to help you verify that everything is properly installed.
First, you can check that Apache and PHP have been successfully installed by creating an info.php file at the root of your web directory. To locate the root web directory, use the following command:
1 $ brew info httpd 2 ==> httpd: stable 2.4.58 (bottled) 3 Apache HTTP server 4 https://httpd.apache.org/ 5 /usr/local/Cellar/httpd/2.4.58 (1,663 files, 31.8MB) * 6 Poured from bottle using the formulae.brew.sh API on 2023-11-09 at 18:19:19 7 From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/h/httpd.rb 8 License: Apache-2.0 9 ==> Dependencies 10 Required: apr ✔, apr-util ✔, brotli ✔, libnghttp2 ✔, openssl@3 ✔, pcre2 ✔ 11 ==> Caveats 12 DocumentRoot is /usr/local/var/www
In the file, add the following content:
1 <?php 2 echo("Hello World"); 3 ?>
Next, let's talk about how to run a PHP program in localhost. Navigate to http://localhost:8080/info.php and you should see a blank page with just the Hello World text.
Next, edit the info.php file content to:
1 <?php 2 phpinfo(); 3 ?>
Save, and then refresh the info.php page. You should see a page with a large table of PHP information like this:
IMPORTANT: In production servers, it’s unsafe to expose information displayed by phpinfo() on a publicly accessible page
The information that we’re interested could be in these places:
- “Configuration File (php.ini) Path” property shows where your PHP runtime is getting its php.ini file from. It can happen that the mongodb.so extension was added in the wrong php.ini file as there may be more than one.
- “Additional .ini files parsed” shows potential extra PHP configuration files that may impact your specific configuration. These files are in the directory listed by the “Scan this dir for additional .ini files” section in the table.
There’s also a whole “mongodb” table that looks like this:
Its presence indicates that the MongoDB extension has been properly loaded and is functioning. You can also see its version number to make sure that’s the one you intended to use.
If you don’t see this section, it’s likely the MongoDB extension failed to load. If that’s the case, look for the “error_log” property in the table to see where the PHP error log file is, as it may contain crucial clues. Make sure that “log_errors” is set to ON. Both are located in the “Core” PHP section.
If you are upgrading to a newer version of PHP, or have multiple versions installed, keep in mind that each version needs to have its own MongoDB extension and php.ini files.
Now that you've got your local environment set up, it's time to create a MongoDB database to work with, and to load in some sample data you can explore and modify.
Get started with an M0 cluster on Atlas today. It's free forever, and it's the easiest way to try out the steps in this blog series.
It will take a couple of minutes for your cluster to be provisioned, so while you're waiting, you can move on to the next step.
Hopefully, your MongoDB cluster should have finished starting up now and has probably been running for a few minutes.
The following instructions were correct at the time of writing but may change, as we're always improving the Atlas user interface:
In the Atlas web interface, you should see a green button at the bottom-left of the screen, saying "Get Started." If you click on it, it'll bring up a checklist of steps for getting your database set up. Click on each of the items in the list (including the "Load Sample Data" item—we'll use this later to test the PHP library), and it'll help you through the steps to get set up.
The fastest way to get access to data is to load the sample datasets into your cluster right in the Atlas console. If you're brand new, the new user wizard will actually walk you through the process and prompt you to load these.
If you already created your cluster and want to go back to load the sample datasets, click the ellipsis (three dots) next to your cluster connection buttons (see below image) and then select
Load Sample Dataset
.Now, let's move on to setting the configuration necessary to access your data in the MongoDB Cluster. You will need to create a database user and configure your IP Address Access List.
Following the "Get Started" steps, create a user with "Read and write access to any database." You can give it the username and password of your choice. Make a copy of them, because you'll need them in a minute. Use the "autogenerate secure password" button to ensure you have a long, random password which is also safe to paste into your connection string later.
When deploying an app with sensitive data, you should only whitelist the IP address of the servers which need to connect to your database. To whitelist the IP address of your development machine, select "Network Access," click the "Add IP Address" button, and then click "Add Current IP Address" and hit "Confirm."
The last step of the "Get Started" checklist is "Connect to your Cluster." Select "Connect your application" and select "PHP" with a version of "PHPLIB 1.8."
Click the "Copy" button to copy the URL to your paste buffer. Save it to the same place you stored your username and password. Note that the URL has
<password>
as a placeholder for your password. You should paste your password in here, replacing the whole placeholder, including the <
and >
characters.Now it's time to actually write some PHP code to connect to your MongoDB database! Up until now, we've only installed the supporting system components. Before we begin to connect to our database and use PHP to manipulate data, we need to install the MongoDB PHP Library.
Composer is the recommended installation tool for the MongoDB library. Composer is a tool for dependency management in PHP. It allows you to declare the libraries your project depends on and it will manage (install/update) them for you.
To install
composer
, we can use Homebrew.1 brew install composer
Once you have
composer
installed, you can move forward to installing the MongoDB Library.Installation of the library should take place in the root directory of your project. Composer is not a package manager in the same sense as Yum or Apt are. Composer installs packages in a directory inside your project. By default, it does not install anything globally.
1 $ composer require mongodb/mongodb 2 Using version ^1.8 for mongodb/mongodb 3 ./composer.json has been created 4 Running composer update mongodb/mongodb 5 Loading composer repositories with package information 6 Updating dependencies 7 Lock file operations: 4 installs, 0 updates, 0 removals 8 - Locking composer/package-versions-deprecated (1.11.99.1) 9 - Locking jean85/pretty-package-versions (1.6.0) 10 - Locking mongodb/mongodb (1.8.0) 11 - Locking symfony/polyfill-php80 (v1.22.0) 12 Writing lock file 13 Installing dependencies from lock file (including require-dev) 14 Package operations: 4 installs, 0 updates, 0 removals 15 - Installing composer/package-versions-deprecated (1.11.99.1): Extracting archive 16 - Installing symfony/polyfill-php80 (v1.22.0): Extracting archive 17 - Installing jean85/pretty-package-versions (1.6.0): Extracting archive 18 - Installing mongodb/mongodb (1.8.0): Extracting archive 19 Generating autoload files 20 composer/package-versions-deprecated: Generating version class... 21 composer/package-versions-deprecated: ...done generating version class 22 2 packages you are using are looking for funding.
Make sure you're in the same directory as you were when you used
composer
above to install the library.In your code editor, create a PHP file in your project directory called quickstart.php. If you're referencing the example, enter in the following code:
1 2 3 require_once __DIR__ . '/vendor/autoload.php'; 4 5 $client = new MongoDB\Client( 6 'mongodb+srv://<username><password>@myfirstcluster.zbcul.mongodb.net/dbname?retryWrites=true&w=majority'); 7 8 $customers = $client->selectCollection('sample_analytics', 'customers'); 9 $document = $customers->findOne(['username' => 'wesley20']); 10 11 var_dump($document); 12 13
<username>
and <password>
are the username and password you created in Atlas, and the cluster address is specific to the cluster you launched in Atlas.Save and close your
quickstart.php
program and run it from the command line:1 $ php quickstart.php
If all goes well, you should see something similar to the following:
1 $ php quickstart.php 2 object(MongoDB\Model\BSONDocument)#12 (1) { 3 ["storage":"ArrayObject":private]=> 4 array(8) { 5 ["_id"]=> 6 object(MongoDB\BSON\ObjectId)#16 (1) { 7 ["oid"]=> 8 string(24) "5ca4bbcea2dd94ee58162a72" 9 } 10 ["username"]=> 11 string(8) "wesley20" 12 ["name"]=> 13 string(13) "James Sanchez" 14 ["address"]=> 15 string(45) "8681 Karen Roads Apt. 096 Lowehaven, IA 19798" 16 ["birthdate"]=> 17 object(MongoDB\BSON\UTCDateTime)#15 (1) { 18 ["milliseconds"]=> 19 string(11) "95789846000" 20 } 21 ["email"]=> 22 string(24) "josephmacias@hotmail.com" 23 ["accounts"]=> 24 object(MongoDB\Model\BSONArray)#14 (1) { 25 ["storage":"ArrayObject":private]=> 26 array(1) { 27 [0]=> 28 int(987709) 29 } 30 } 31 ["tier_and_details"]=> 32 object(MongoDB\Model\BSONDocument)#13 (1) { 33 ["storage":"ArrayObject":private]=> 34 array(0) { 35 } 36 } 37 } 38 }
You just connected your PHP program to MongoDB and queried a single document from the
sample_analytics
database in your cluster! If you don't see this data, then you may not have successfully loaded sample data into your cluster. You may want to go back a couple of steps until running this command shows the document above.Storing usernames and passwords in your code is never a good idea. So, let's take one more step to secure those a bit better. It's general practice to put these types of sensitive values into an environment file such as
.env
. The trick, then, will be to get your PHP code to read those values in. Fortunately, Vance Lucas came up with a great solution called phpdotenv
. To begin using Vance's solution, let's leverage composer
.1 $ composer require vlucas/phpdotenv
Now that we have the library installed, let's create our
.env
file which contains our sensitive values. Open your favorite editor and create a file called .env
, placing the following values in it. Be sure to replace your user name
and your password
with the actual values you created when you added a database user in Atlas.1 MDB_USER="your user name" 2 MDB_PASS="your password"
Next, we need to modify our quickstart.php program to pull in the values using
phpdotenv
. Let's add a call to the library and modify our quickstart program to look like the following. Notice the changes on lines 5, 6, and 9.1 2 3 require_once __DIR__ . '/vendor/autoload.php'; 4 $dotenv = Dotenv\Dotenv::createImmutable(__DIR__); 5 $dotenv->load(); 6 7 $client = new MongoDB\Client( 8 'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@tasktracker.zbcul.mongodb.net/sample_analytics?retryWrites=true&w=majority' 9 ); 10 11 $customers = $client->selectCollection('sample_analytics', 'customers'); 12 $document = $customers->findOne(['username' => 'wesley20']); 13 14 var_dump($document);
Next, to ensure that you're not publishing your credentials into
git
or whatever source code repository you're using, be certain to add a .gitignore (or equivalent) to prevent storing this file in your repo. Here's my .gitignore
file:1 composer.phar 2 /vendor/ 3 .env
My
.gitignore
includes files that are leveraged as part of our libraries—these should not be stored in our project.Should you want to leverage my project files, please feel free to visit my github repository, clone, fork, and share your feedback in the Community.
This quick start was intended to get you set up to use PHP with MongoDB. You should now be ready to move onto the next article in this series. Please feel free to contact me in the Community should you have any questions about this article, or anything related to MongoDB.
- MongoDB PHP Driver Documentation provides thorough documentation describing how to use PHP with your MongoDB cluster.
- MongoDB Query Document documentation details the full power available for querying MongoDB collections.