How to connect tp5 to sqlserver database

If you use php to develop a website, everyone will think of using the database mysql, paired with php, there are many online The source code is developed using php mysql. Recently, there happened to be a need to use sqlserver as a database to develop a website. Here is a brief introduction on how to connect to the sqlserver database and some simple database operation methods. After reading this article, you will know that no matter where it is, In fact, the principles of developing various databases are very similar. As long as you master one, you can quickly get started with the others. But deployment issues are not involved here. Deployment requires additional considerations

Here is wampserver sqlserver as an example

1. sqlserver

is also called MSSQL, which is A relational database management system (DBMS) developed and promoted by Microsoft. The operating software can use "sqlserver"

2. How to connect php to sqlserver? First of all, it is clear that wampserver does not support connecting to sqlserver, so you have to download the driver to connect to sqlserver yourself. There are also PHP versions that are 5.3 or above, excluding 5.3

1) Download the Microsoft SQL Server PHP driver.

With the Microsoft SQL Server PHP driver, PHP developers can access SQL Server databases. This type of driver relies on the Microsoft SQL Server ODBC driver to handle low-level communication with SQL Server.

Download URL: https://msdn.microsoft.com/zh-cn/library/mt683517.aspx

The version selection is:

2) The downloaded file is an exe file, but it does not actually need to be installed. It will release some dll files for you. Open the exe file:

Reminder] If you find it troublesome, you can also directly download the decompression package compressed by others. The principle is the same. I will upload the driver package later

3) Choose the driver file that is suitable for your PHP version Named: See screenshot

php_pdo_sqlsrv_54_ts.dll
php_sqlsrv_54_ts.dll[object Object]

[My php version is 5.4, so I chose 54], copy the tower to the /ext folder in the wampserver installation directory. Screenshot

4) Open the extension:

Configure the php.ini file:

Note for this step: php needs to be configured at the same time The php.ini files in the two directories of and apache, the paths are

D:\wamp\bin\php\php5.5.12 and D:\wamp\bin\apache\apache2.4.9\bin:

Search extensions until you find Windows Extensions, add two lines of code:. . You can open php.ini and search for

extension=php_pdo_sqlsrv_55_ts.dll
extension=php_sqlsrv_55_ts.dll

Remember to also configure the driver file in D:\wamp\bin\apache\apache2.4.9\bin. Search for extension and find many extensions and add them.

5) Restart apache and that’s it.

3. Upload the test code

<?php  
$serverName = "localhost"; //数据库服务器地址
$uid = "sa";     //数据库用户名
$pwd = "123456"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"test");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if( $conn == false)
{
    echo "连接失败！";
    var_dump(sqlsrv_errors());
    exit;
}else{
    echo "链接成功";
}

4. When connecting to sqlserver for the first time, it may prompt that there is a problem with odbc.

There are many solutions on the Internet, just search on Baidu. The easiest way is to download a sqlserver odbc driver source and install it. There is no way to demonstrate here, I can only solve it by myself. I uploaded the sqlserver odbc driver source software

5. Here you can Let me introduce, when some people use Baidu to connect to sqlserver, some people suggest loading the mssql driver

1) PHP connection mssql settings (previous version of php5.3)

2) Briefly explain how to connect !

(1) Open php.ini, remove the semicolon (;) in front of

;extension=php_mssql.dll, and then restart Apache. If that doesn't work, proceed to step 2.

(2) Check if php_mssql.dll exists under ext in your php installation directory. If not, search for a download from Baidu online

If there is already one in the ext directory php_mssql.dll, then you need to open php.ini and find

extension_dir = “./ext”

This sentence (or similar, not necessarily "./ext" is the ext in your installation environment php/, just look for "extension_dir") and then restart Apache again. If that still doesn't work, step 3 may be needed.

(3) Copy ntwdblib.dll and php_mssql.dll in the php directory to the system directory of system32, and then restart Apache.

(4) Then you can connect to MSSQL and perform some operations.

For more ThinkPHP related technical articles, please visit the ThinkPHP Tutorial column to learn!

The above is the detailed content of How to connect tp5 to sqlserver database. For more information, please follow other related articles on the PHP Chinese website!