Several methods for php to connect to mssql database_PHP tutorial

First of all, in the php.ini file, remove the semicolon in front of;extension=php_pdo_mssql.dll;extension=php_pdo_odbc.dll, which method should be used to connect to mssql. Note that you need to restart the service to make it take effect.

1. Establish connection

1. odbc

First, set up odbc on the server where the php program is located. There is a difference between 32-bit and 64-bit operating systems here. For 32-bit, just create the data source (odbc) directly from the management tool in the control panel. For 64-bit, run C:WindowsSysWOW64odbcad32.exe

Set up from here. Note: The above is only for the case where the database server is 32-bit and the data source setting server is 32-bit or 64-bit. As long as the number of data sources established by the two servers is the same.

The following is the odbc connection establishment code.

Copy code The code is as follows:

$con = odbc_connect('odbc name','username','password' );

2. Connect mssql2000

Copy code The code is as follows:

$con = mssql_connect('database address','username','password' );

3. Connect mssql2008

Copy code The code is as follows:

$connectionInfo = array("UID"=> Username,"PWD"=>Password,"Database"=>"Database name");
$con = sqlsrv_connect(Database address,$connectionInfo);

2. Enter the query code

This is the same, you can write it directly, or you can copy it from mssql after verification. To put it simply, it is to assign a SQL statement to a variable.

Similar to the following code

Copy the code The code is as follows:

$query = "SELECT top 12 * database name order by id desc";

3. Create a query and retrieve the data

1. odbc

Copy code The code is as follows:

$result = odbc_do($con,$query);
while(odbc_fetch_row($result))
{
$Variable name = odbc_result($result, "field name");
}

2. Connect mssql2000

Copy code The code is as follows:

$result = mssql_query($con, $query);
while($ row =mssql_fetch_array($result))
{
$Variable name = $row["field name"];
}

3. Connect mssql2008

Copy code The code is as follows:

$result = sqlsrv_query($con, $query);
while($row = sqlsrv_fetch_array($ result))
{
$Variable name = $row["field name"];
}

The sqlsrv library is not included in php5.3 and later versions. . So download it from Microsoft.

4. Close the connection

There is no difference between this, they are odbc_close(); and mssql_close() and sqlsrv_close();

Final experience: PHP has fewer functions to connect to mssql than connecting to mssql, but it is enough. For specific functions, please refer to the official PHP manual

http://www.bkjia.com/PHPjc/326589.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/326589.htmlTechArticleFirst, remove the semicolon in front of;extension=php_pdo_mssql.dll;extension=php_pdo_odbc.dll in the php.ini file , corresponding to which method to connect to mssql. Note that you need to restart the service to make it take effect. ...