Step-by-step tutorial: How to connect to MSSQL database using php extension FREETDS

Step-by-step tutorial: How to use PHP extension FREEETDS to connect to MSSQL database

In the process of website development, we often need to connect to different databases to store and obtain data. Unlike mysql, if you need to use PHP to connect to an MSSQL database, you will need an additional extension tool. One of the commonly used extension tools is FREETDS. Below is a step-by-step tutorial that will take you step by step to understand how to use the FREETDS extension to connect to an MSSQL database.

Step One: Install FREETDS

First, we need to install the FREETDS extension. You can install it through the terminal. The specific command is as follows:

$ sudo apt-get install freetds-dev

Please make sure that PHP and related development tools have been installed in your system. Using the above command, you can install it in Ubuntu system.

Step 2: Configure ODBC

In the process of connecting to the MSSQL database, we need to configure ODBC. Create a file named freetds.conf and save it in the directory /etc/freetds/. The specific configuration content is as follows:

[global]
    tds version = 8.0

Please note that the versions of the MSSQL database may be different, so you may need to make corresponding changes according to your own system version.

Step 3: Configure odbc.ini

Before continuing, we also need to configure odbc.ini. You also need to create a file named odbc.ini and save it in the directory /etc/odbc/. The specific configuration content is as follows:

[ODBC Data Sources]
my_mssql = MSSQL Server

[my_mssql]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Server = your_server_ip
Port = 1433
Database = your_database_name

Please note that your_server_ip and your_database_name in the above configuration need to be changed accordingly according to your own MSSQL database.

Step 4: Test the connection

After the above configuration is completed, we can try to connect to the database. The following is a sample PHP code:

<?php

$serverName = 'my_mssql';
$userName = 'your_username';
$password = 'your_password';

$conn = odbc_connect($serverName, $userName, $password);

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

?>

Please note that your_username and your_password in the above code need to be changed accordingly according to your own MSSQL database.

By executing the above PHP code, you will get a prompt message indicating whether the connection is successful or failed.

At this point, you have successfully used the FREETDS extension to connect to the MSSQL database. I hope this article will be helpful for you to learn and use PHP to connect to MSSQL database. Through these simple steps, you can easily use FREETDS to connect to the MSSQL database and perform corresponding database operations in your own website development. I wish you success!

The above is the detailed content of Step-by-step tutorial: How to connect to MSSQL database using php extension FREETDS. For more information, please follow other related articles on the PHP Chinese website!