Detailed guide to install PHP and configure MSSQL connection on Ubuntu

Ubuntu is a popular open source operating system commonly used for server operation. Installing PHP and configuring MSSQL connections on Ubuntu is one of the operations that many developers and system administrators often need to do. This article will provide readers with a detailed guide, including the steps to install PHP, set up Apache, install MSSQL Server, etc., and attach specific code examples.

Step One: Install PHP and related extensions

First, we need to install PHP and its related extensions to support PHP connection to MSSQL Server. Execute the following command in the terminal:

sudo apt update
sudo apt install php php-mbstring php-xml php-sybase

This will install PHP and some commonly used extensions, such as mbstring, xml and sybase extensions, for connecting to MSSQL Server.

Step 2: Set up the Apache server

Next, we need to install and configure the Apache server to access our PHP web page in the browser. Execute the following command to install Apache:

sudo apt install apache2

After the installation is complete, start Apache and set it to start automatically at boot:

sudo systemctl start apache2
sudo systemctl enable apache2

Now, you can access the IP address of the server through the browser and see the default web page of Apache .

Step 3: Install MSSQL Server and PHP connection extension

Now, we need to install MSSQL Server and configure PHP connection extension. Execute the following command to install MSSQL Server and related dependencies:

sudo apt-get install mssql-server mssql-tools unixodbc-dev

After the installation is complete, execute the following command to configure MSSQL Server:

sudo /opt/mssql/bin/mssql-conf setup

Follow the prompts to set the SA user password and other information. Next, install the extension for PHP to connect to MSSQL Server:

sudo pecl install sqlsrv pdo_sqlsrv

After the installation is complete, you need to enable these two extensions in the php.ini file. Open the php.ini file:

sudo nano /etc/php/7.4/apache2/php.ini

Add the following content to the file:

extension=sqlsrv.so
extension=pdo_sqlsrv.so

Save and close the file. Restart the Apache server for the changes to take effect:

sudo systemctl restart apache2

Step 4: Test the MSSQL connection

Finally, we can create a simple PHP script to test whether the MSSQL connection is successful . Create a test.php file in the /var/www/html directory:

sudo nano /var/www/html/test.php

Enter the following code in the file:

<?php
$serverName = "localhost";
$connectionOptions = array(
    "Database" => "database_name",
    "Uid" => "username",
    "PWD" => "password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

if($conn) {
    echo "连接成功！";
} else {
    echo "连接失败！";
}
?>

Replace "database_name", "username" and "password" with Actual MSSQL database name, username and password. Save and close the file.

Access the server's IP address/test.php in the browser. If "Connection successful!" is displayed, it means that the connection configuration has been successful.

At this point, we have completed the detailed guide to install PHP and configure MSSQL connection on Ubuntu. Hope this article is helpful to readers.

The above is the detailed content of Detailed guide to install PHP and configure MSSQL connection on Ubuntu. For more information, please follow other related articles on the PHP Chinese website!