Fatal error: Call to undefined function mssql_connect()解决办法-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Fatal error: Call to undefined function mssql_connect()解决办法

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 am 10:33 AM

mssqlphpsqlundefined

Fatal error: Call to undefined function mssql_connect()
Fatal error: Call to undefined function mssql_connect()
php.ini配置文件里面已经开启
extension=php_mssql.dll

echo phpinfo();
打印phpinfo没有显示mssql模块，证明没有加载，为什么没有加载？

------解决方案--------------------
检查你的extension_dir = "./ext " 路径是否正确.
------解决方案--------------------
1、确认 php_mssql.dll 存在
2、确认 ntwdblib.dll 在系统的搜索路径中
3、确认你修改的 php.ini 是 php 加载的 php.ini

又，php_mssql 扩展自 php 5.3 起已经废止
------解决方案--------------------
不然！
自 php 5.3 起，mssql 的 php 扩展改由微软自己供应，而不是由 php 开发组织提供
------解决方案--------------------
php 5.2.x 通过 php_mssql.dll 连接本地的 SQL SEREVR 2005 是可以的。因为我原单位的网站就是这样的，是我弄的。不过要注意的是 SQL SEREVR 2005 的 XML 列是无法操作的
若需要远程连接，则需要打开 SQL SEREVR 2005 的远程访问功能，默认是关闭的
若是更高版本的 SQL SEREVR 则可能会有问题（我没有，无法检验）
这也就是 php 5.3 开始微软自己提供扩展的原因，毕竟性能比 SQL SEREVR 2000 高出许多，让别人弄有失水准

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How to calculate the total number of elements in a PHP multidimensional array?May 15, 2025 pm 09:00 PM

Calculating the total number of elements in a PHP multidimensional array can be done using recursive or iterative methods. 1. The recursive method counts by traversing the array and recursively processing nested arrays. 2. The iterative method uses the stack to simulate recursion to avoid depth problems. 3. The array_walk_recursive function can also be implemented, but it requires manual counting.

What are the characteristics of do-while loops in PHP?May 15, 2025 pm 08:57 PM

In PHP, the characteristic of a do-while loop is to ensure that the loop body is executed at least once, and then decide whether to continue the loop based on the conditions. 1) It executes the loop body before conditional checking, suitable for scenarios where operations need to be performed at least once, such as user input verification and menu systems. 2) However, the syntax of the do-while loop can cause confusion among newbies and may add unnecessary performance overhead.

How to hash strings in PHP?May 15, 2025 pm 08:54 PM

Efficient hashing strings in PHP can use the following methods: 1. Use the md5 function for fast hashing, but is not suitable for password storage. 2. Use the sha256 function to improve security. 3. Use the password_hash function to process passwords to provide the highest security and convenience.

How to implement array sliding window in PHP?May 15, 2025 pm 08:51 PM

Implementing an array sliding window in PHP can be done by functions slideWindow and slideWindowAverage. 1. Use the slideWindow function to split an array into a fixed-size subarray. 2. Use the slideWindowAverage function to calculate the average value in each window. 3. For real-time data streams, asynchronous processing and outlier detection can be used using ReactPHP.

How to use the __clone method in PHP?May 15, 2025 pm 08:48 PM

The __clone method in PHP is used to perform custom operations when object cloning. When cloning an object using the clone keyword, if the object has a __clone method, the method will be automatically called, allowing customized processing during the cloning process, such as resetting the reference type attribute to ensure the independence of the cloned object.

How to use goto statements in PHP?May 15, 2025 pm 08:45 PM

In PHP, goto statements are used to unconditionally jump to specific tags in the program. 1) It can simplify the processing of complex nested loops or conditional statements, but 2) Using goto may make the code difficult to understand and maintain, and 3) It is recommended to give priority to the use of structured control statements. Overall, goto should be used with caution and best practices are followed to ensure the readability and maintainability of the code.

How to implement data statistics in PHP?May 15, 2025 pm 08:42 PM

In PHP, data statistics can be achieved by using built-in functions, custom functions, and third-party libraries. 1) Use built-in functions such as array_sum() and count() to perform basic statistics. 2) Write custom functions to calculate complex statistics such as medians. 3) Use the PHP-ML library to perform advanced statistical analysis. Through these methods, data statistics can be performed efficiently.

How to use anonymous functions in PHP?May 15, 2025 pm 08:39 PM

Yes, anonymous functions in PHP refer to functions without names. They can be passed as parameters to other functions and as return values of functions, making the code more flexible and efficient. When using anonymous functions, you need to pay attention to scope and performance issues.

See all articles