To install the MSSQL extension for PHP on Ubuntu, you will need to follow these steps:
- Install the necessary dependencies:
Before you can install the MSSQL extension, you will need to install some dependencies that are required by the extension. Run the following command to install these dependencies:
sudo apt-get update sudo apt-get install unixodbc-dev freetds-dev
- Install the MSSQL extension:
Next, you will need to install the MSSQL extension for PHP. You can do this using the pecl (PHP Extension Community Library) command. Run the following command to install the extension:
sudo pecl install sqlsrv
- Enable the MSSQL extension:
After the MSSQL extension is installed, you will need to enable it in your PHP configuration. To do this, open the “php.ini” file in a text editor and add the following line:
- Restart your web server:
After making these changes, you will need to restart your web server in order for the changes to take effect.
- Test the MSSQL extension:
To test that the MSSQL extension has been installed and enabled correctly, you can create a PHP file with the following code:
<?php phpinfo(); ?>
Run this PHP file in your web browser and look for the “sqlsrv” section. If this section is present, the MSSQL extension has been installed and enabled successfully.