What to do if php cannot connect to mssql database

Solution to the problem that php cannot connect to mssql database: 1. Open "php.ini" and remove the semicolon in front of ";extension=php_mssql.dll"; 2. Re-download php installation; 3. "ntwdblib" and "php_mssql" are copied to the system directory.

Recommended: "PHP Video Tutorial"

How to connect php to mssql database and error settings

Previously, using php to connect to the mssql database always failed, or prompted an error. The following methods can be tested!

In order to allow PHP to connect to MSSQL, you first need some settings:

1. Open php.ini, remove the semicolon (;) in front of;extension=php_mssql.dll, and then restart Apache .

If not, proceed to step 2:

2. Check whether php_mssql.dll exists under ext in your php installation directory. If not,

Redownload a PHP installation from www.php.net. The compressed package you want to download is the most complete one.

If there is already php_mssql.dll in the ext directory,

Then you need to open php.ini and find extension_dir = "./ext"

This sentence (or similar , not necessarily "./ext", just look for "extension_dir"),

Then change "./ext" to the full path of the ext directory of your PHP installation directory,

For example, "c:/php/ext", or "c:/program files/php/ext". Then restart Apache again.

(If it still doesn’t work, you may need step 3.

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

Then you can connect to MSSQL and perform some operations.

1. Connect to MSSQL$conn=mssql_connect ("instance name or server IP", "user name", "password");

//测试连接if（$conn）
{   echo "连接成功"；}

2. Select the database to connect mssql_select_db (" dbname");

3. Execute query $rs = mssql_query("select top 1 id,username from tbname",$conn);

Or directly execute update, insert and other statements, you can No need to assign a value to the return result

mssql_query（"update tbname set username='niunv' where id=1"）；

4. Get the number of rows in the record set echo mssql_num_rows ($rs);

5. Get the record set if ($row=mssql_fetch_array ($rs))

{
$id = $row[0]；//获取ID字段值
 $username = $row[1]；//获取username字段值
}

6. Get the ID of the new record and set the id field to the IDENTITY field. After executing the insert statement,

will generate an @@IDENTITY global variable value, and the query will be the last new one. The recorded ID.

mssql_query（"insert into tbname（username） values （'nv'）",$conn）；
 $rs = mssql_query（"select @@IDENTITY as id",$conn）；
if（$row=mssql_fetch_array（$rs））
{ 
 echo $row[0]；
}

7. Release the record set mssql_free_result ($rs);

8. Close the connection mssql_close ($conn);

The above is the detailed content of What to do if php cannot connect to mssql database. For more information, please follow other related articles on the PHP Chinese website!