php各版本(5.2-7)连接sqlserver的dll资源-CSDN下载

共34个文件

dll：28个

rtf：3个

htm：1个

需积分: 50 137 浏览量 2017-12-28 10:42:58 上传评论收藏 2.62MB RAR 举报

在PHP开发中，有时我们需要连接到SQL Server数据库以进行数据操作。本文将详细介绍如何使用PHP的各个版本（从5.2到7）连接到SQL Server，以及提供的dll动态链接库的作用。 PHP连接SQL Server通常依赖于两个扩展：`sqlsrv`和`pdo_sqlsrv`。这些扩展提供了与SQL Server交互的接口。`sqlsrv`主要用于非预处理语句，而`pdo_sqlsrv`是用于PDO（PHP Data Objects）接口，提供预处理语句支持，增强安全性和性能。在标题中提到的"php各版本(5.2-7)连接sqlserver的dll"，是指为不同PHP版本提供的特定dll文件。dll文件是Windows操作系统中的动态链接库，包含可由多个程序同时使用的代码和数据。在PHP中，这些dll文件是扩展的实现，使得PHP能够调用SQL Server的API进行通信。 1. `php_sqlsrv_53_nts.dll` 和 `php_sqlsrv_53_ts.dll`：这是针对PHP 5.3版本的`sqlsrv`扩展，`nts`表示Non Thread Safe（非线程安全），适合在Apache等Web服务器环境中使用，而`ts`表示Thread Safe（线程安全），适用于IIS等Web服务器。 2. `php_pdo_sqlsrv_7_ts_x64.dll` 和 `php_sqlsrv_7_nts_x86.dll`：这些是针对PHP 7版本的`pdo_sqlsrv`扩展，`ts`和`nts`的含义同上，`x64`表示64位系统，`x86`则表示32位系统。 3. `php_sqlsrv_53_nts_vc6.dll`：这是一个针对PHP 5.3且编译器为Visual C++ 6的`sqlsrv`扩展，可能用于兼容较旧的系统或软件环境。 4. `php_sqlsrv_52_nts_vc6.dll`：这个是针对PHP 5.2版本的`sqlsrv`扩展，同样使用了Visual C++ 6编译器。 5. `PHP Drivers License Terms.rtf`：这是一个包含PHP驱动程序许可条款的文件，阅读并遵守其中的条款是使用这些dll文件的前提。 6. `SQLSRV_Readme.htm`：这是SQL Server驱动程序的readme文件，可能包含安装指南、已知问题和解决方法等信息。 7. `release.txt`：可能包含dll文件的发布信息，如版本号、发布日期等。要使用这些dll文件，开发者需要将它们添加到PHP的`ext`目录，并在php.ini配置文件中启用对应的扩展。例如，添加以下行： ``` extension=php_sqlsrv_53_nts.dll extension=php_pdo_sqlsrv_7_ts_x64.dll ``` 然后重启Web服务器，使配置生效。在实际应用中，使用这些扩展可以编写如下的PHP代码来连接SQL Server数据库： ```php <?php $serverName = "localhost\SQLEXPRESS"; // SQL Server实例名 $connectionInfo = array("Database" => "myDB", "UID" => "username", "PWD" => "password"); $conn = sqlsrv_connect($serverName, $connectionInfo); if ($conn === false) { die(print_r(sqlsrv_errors(), true)); } else { echo "连接成功！"; } ?> ``` 这些dll文件是PHP连接SQL Server所必需的组件，通过选择合适的版本和类型，可以确保PHP在不同环境下正确地与SQL Server数据库进行通信。正确安装和配置这些扩展，将极大地提升PHP应用程序处理SQL Server数据的能力。

资源详情

资源评论

资源推荐

收起资源包目录

php各版本链接mssql的dll.rar （34个子文件）

php_sqlsrv_53_nts.dll 196KB

php_pdo_sqlsrv_7_ts_x64.dll 381KB

php_sqlsrv_53_ts.dll 200KB

php_sqlsrv_7_nts_x86.dll 323KB

PHP Drivers License Terms.rtf 67KB

php_sqlsrv_53_nts_vc6.dll 255KB

SQLSRV_Readme.htm 13KB

php_sqlsrv_52_nts_vc6.dll 251KB

release.txt 3KB

php_pdo_sqlsrv_53_nts_vc6.dll 175KB

php_sqlsrv_53_ts_vc6.dll 255KB

php_sqlsrv_53_nts_vc9.dll 255KB

php_pdo_sqlsrv_52_nts_vc6.dll 175KB

php_sqlsrv_7_ts_x86.dll 327KB

php_pdo_sqlsrv_52_ts_vc6.dll 179KB

php_pdo_sqlsrv_54_ts.dll 182KB

php_pdo_sqlsrv_54_nts.dll 180KB

php_sqlsrv_53_ts_vc9.dll 255KB

php_pdo_sqlsrv_7_nts_x64.dll 380KB

php_pdo_sqlsrv_53_ts.dll 182KB

SQLSRV_ThirdPartyNotices.rtf 53KB

SQLSRV_Help.chm 377KB

php_sqlsrv_7_nts_x64.dll 396KB

php_pdo_sqlsrv_7_ts_x86.dll 314KB

php_pdo_sqlsrv_53_nts.dll 180KB

php_sqlsrv_52_ts_vc6.dll 255KB

php_pdo_sqlsrv_53_nts_vc9.dll 175KB

php_sqlsrv_54_ts.dll 200KB

php_pdo_sqlsrv_53_ts_vc9.dll 179KB

php_pdo_sqlsrv_7_nts_x86.dll 313KB

php_pdo_sqlsrv_53_ts_vc6.dll 179KB

php_sqlsrv_54_nts.dll 196KB

php_sqlsrv_7_ts_x64.dll 400KB

SQLSRV_License.rtf 47KB

Release Information Microsoft Drivers 4.0 for PHP for SQL Server June 2016 INTRODUCTION ------------ This file contains late-breaking or other important information that supplements the Microsoft Drivers for PHP for SQL Server documentation. You should read this file completely before installing the PHP driver. Your feedback is very important to us and we will strive to respond to your feedback in a timely manner. For information about providing feedback by using the PHP driver blogs and online forums, see the Microsoft Drivers for PHP for SQL Server page at http://msdn.microsoft.com/sqlserver/cc299381.aspx. INSTALLATION ------------ Instructions for installing the PHP driver are located in SQLSRV_Readme.htm. Refer to that file for information about installing the PHP driver. SUPPORTED OPERATING SYSTEMS --------------------------- The Microsoft Drivers for PHP for SQL Server supports the following operating systems: o Windows Server 2008 SP2 o Windows Server 2008 R2 SP1 o Windows Server 2012 o Windows Server 2012 R2 o Windows Vista SP2 o Windows 7 SP1 o Windows 8 o Windows 8.1 o Windows 10 The list above is an example of some of the supported operating systems. RELEASE CONTENTS ---------------- The Microsoft Drivers for PHP for SQL Server executable zip file unpacks the following files in the specified locations, relative to the selected installation directory: <installation directory>\PHP Drivers License Terms.rtf <installation directory>\release.txt <installation directory>\SQLSRV_Readme.htm <installation directory>\SQLSRV_ThirdPartyNotices.rtf <installation directory>\php_pdo_sqlsrv_7_nts_x86.dll <installation directory>\php_pdo_sqlsrv_7_nts_x64.dll <installation directory>\php_pdo_sqlsrv_7_ts_x86.dll <installation directory>\php_pdo_sqlsrv_7_ts_x64.dll <installation directory>\php_sqlsrv_7_nts_x86.dll <installation directory>\php_sqlsrv_7_nts_x64.dll <installation directory>\php_sqlsrv_7_ts_x86.dll <installation directory>\php_sqlsrv_7_ts_x64.dll CHANGE LIST ----------- Changes from 3.2 to 4.0: Upgraded PHP Driver to work with PHP 7.0 and added full 64-bit support on Windows. KNOWN ISSUES ------------ Please visit the project on Github to view outstanding issues and report new ones: https://github.com/Azure/msphpsql/issues 3513544: Performance degradation when using Microsoft Drivers 3.1 for PHP for SQL Server (and later) with Windows 7/Windows Server 2008 R2 and previous versions. Clients connecting to supported versions of Microsoft SQL Server may notice decreased performance when opening and closing connections in a Windows 7/Windows Server 2008 R2 environment. The recommended course of action is to upgrade to Windows 8/Windows Server 2012 or later.