Several methods for connecting php to the mssql database

Database query involves four steps: 1. establish a connection. 2. enter the query code. 3. create a query and retrieve data. 4. close the connection. Php has several considerations for connecting to the mssql database, especially when multiple versions, 32-bit and 64-bit of mssql are different. First, remove the semicolon in the php. ini file; extension = php_pdo_mssql.dll; extension = php_pdo_odbc.dll. which method is used to connect to mssql. Restart the service to make it take effect.

1. establish a connection

1. odbc

First, set odbc on the server where the php program is located. The 32-bit and 64-bit operating systems are different here. You can directly create a 32-bit data source (odbc) from the management tool in the control panel, and run C: \ Windows \ SysWOW64 \ odbcad32.exe in 64-bit mode.

Set from here. Note: The above is only the case where the database server is 32 characters and the data source is set to 32-bit or 64-bit. As long as the two servers have the same data source bits.

The following is the odbc Connection creation code.

The code is as follows:
$ Con = odbc_connect ('odbc name', 'username', 'password ');

2. connect to mssql2000

The code is as follows:
$ Con = mssql_connect ('database address', 'username', 'password ');

3. connect to mssql2008
The code is as follows:
$ ConnectionInfo = array ("UID" => username, "PWD" => password, "Database" => "Database name ");
$ Con = sqlsrv_connect (database address, $ connectionInfo );

II. enter the query code

This is the same. you can write data directly or copy it from mssql. Simply put, an SQL statement is assigned to a variable.

Code similar to the following
The code is as follows:
$ Query = "SELECT top 12 * database name order by id desc ";

3. create a query and retrieve data

1. odbc
The code is as follows:
$ Result = odbc_do ($ con, $ query );
While (odbc_fetch_row ($ result ))
{
$ Variable name = odbc_result ($ result, "Field name ");
}

2. connect to mssql2000
The code is as follows:
$ Result = mssql_query ($ con, $ query );
While ($ row = mssql_fetch_array ($ result ))
{
$ Variable name = $ row ["field name"];
}

3. connect to mssql2008
The code is as follows:
$ Result = sqlsrv_query ($ con, $ query );
While ($ row = sqlsrv_fetch_array ($ result ))
{
$ Variable name = $ row ["field name"];
}

Sqlsrv library is not included in php5.3 and later versions. So we need to download it from Microsoft.

4. close the connection

There is no difference in this: odbc_close (); and mssql_close () and sqlsrv_close ();

Finally, I learned that php is less connected to mssql than to mssql, but it is enough. For specific functions, refer to the official php Manual.