PHP connection to MSSQL2008/2005 database (SQLSRV) configuration example, mssql2008sqlsrv_PHP tutorial

PHP connects to MSSQL2008/2005 database (SQLSRV) configuration instance, mssql2008sqlsrv

The example in this article describes the configuration method of PHP connecting to MSSQL2008/2005 database (SQLSRV) and is shared with everyone for your reference. The specific method is as follows:

PHP connecting to MSSQL2008/2005 database is different from the previous connection to mssql2000. To connect to mssql2008/2005, you need to add PHP driver extension for MSSQL connection, and we commonly use extension=php_mssql.dll in hp.ini The extension is only suitable for connecting to MSSQL2000. Let’s take a look at the solution to this

1. Download the extension

(1) Go to the official website to download an expansion package for SQL Server Driver for PHP. I downloaded it here http://www.microsoft.com/en-us/download/details.aspx?id=20098 [Remember After downloading, it seems that you need to install it first and then unzip it】

(2) You can also download it directly from this site (I downloaded it before, from Microsoft official) [Click here to download directly]
After unzipping the downloaded rar file, you will get a bunch of .dll files

Download the driver and install the release program after downloading, which contains the following files:
php_pdo_sqlsrv_52_nts.dll
php_pdo_sqlsrv_52_ts.dll
php_pdo_sqlsrv_53_nts_vc6.dll
php_pdo_sqlsrv_53_nts_vc9.dll
php_pdo_sqlsrv_53_ts_vc6.dll
php_pdo_sqlsrv_53_ts_vc9.dll
php_sqlsrv_52_nts.dll
php_sqlsrv_52_ts.dll
php_sqlsrv_53_nts_vc6.dll
php_sqlsrv_53_nts_vc9.dll
php_sqlsrv_53_ts_vc6.dll
php_sqlsrv_53_ts_vc9.dll
SQLServerDriverForPHP.chm (manual, if your English is good enough, you can read it, hehe)
SQLServerDriverForPHP_License.rtf
SQLServerDriverForPHP_Readme.htm (readme)

2. Add extensions

Choose extensions according to (vc6/vc9) needs. My environment is WAMP (php5.2.6/apache2.2.8). I chose the two files php_sqlsrv_52_ts_vc6.dll and php_pdo_sqlsrv_52_ts_vc6.dll, and copied them to the wamp installation directory. Under the ext directory, my ext directory is in wamp/bin/php/php5.2.6/ext/

3. Configure php.ini

(1) Add the following two extensions to Dynamic Extensions in php.ini:
extension=php_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll
(2) Remove the “;” in front of “extension=php_pdo.dll” and enable the pdo connection extension
(3) Restart apache

4. Connect to database (pdo connection)

Copy code The code is as follows:

$servern="SFKFK27EL8FJ＼SQLTRY";
$coninfo=array("Database"=>"try2","UID"=>"sa","PWD"=>"123");
$conn=sqlsrv_connect($servern,$coninfo) or die ("Connection failed!");
$val=sqlsrv_query($conn,"select * from usertable");
while($row=sqlsrv_fetch_array($val)){
echo $row[1]."
";
}
sqlsrv_close($conn);
?>

5. Example

Link example:
The mssql_lib.php file is as follows:

Copy code The code is as follows:

class DB {
    var $con = null;
    function __construct($dbhost,$dbuser,$dbpass,$dbname) {
        $connectionInfo =  array("UID"=>$dbuser,"PWD"=>$dbpass,"Database"=>$dbname);
        $this->con = sqlsrv_connect($dbhost,$connectionInfo);
    }
    function query($sql){
        $result = sqlsrv_query($this->con, $sql);
    }
    function getRow($sql){
        $result = sqlsrv_query($this->con, $sql);
        $arr = array();
        while($row = sqlsrv_fetch_array($result))
        {
            $arr[] = $row;
        }
        return $arr[0];
    }
    function getAll($sql){
        $result = sqlsrv_query($this->con, $sql);
        $arr = array();
        while($row = sqlsrv_fetch_array($result))
        {
            $arr[] = $row;
        }
        return $arr;
    }
    function __destruct() {
        unset($con);
    }
}

test.php页面如下：

复制代码 代码如下:

//简单调用
$db = new DB(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$sql = "select * from crm_order_batch where (status=0 or status is null) and lock_id is not null  ";
$orders_add_list = $db->getAll($sql);

希望本文所述对大家的PHP数据库程序设计有所帮助。

php连接mssql数据库的几种方法_php实例

注意要重启服务使其生效。一、建立连接1、odbc首先，在php程序所在的服务器设置odbc。这里32位和64位操作系统有区别。32位的从控制面板中管理工具中的数据源（odbc）直接建立就可以了，64位的要运行C:WindowsSysWOW64odbcad32.exe从这里面设置。注意：上面只的是数据库服务器为32为的，数据源设置服务器为32位和64位两种的情况。只要两个服务器建立的数据源位数一致就好。下面是odbc建立连接代码。复制代码代码如下:$con = odbc_connect('odbc名称','用户名','密码');2、连接mssql2000复制代码代码如下:$con = mssql_connect('数据库地址','用户名','密码');3、连接mssql2008复制代码代码如下:$connectionInfo = array("UID"=用户名,"PWD"=密码,"Database"="数据库名称");$con = sqlsrv_connect( 数据库地址,$connectionInfo);二、输入查询代码这个都一样，可以直接写入，也可以从mssql中验证好后复制过来。简单点说就是把一个sql语句赋值给一个变量。类似下面代码复制代码代码如下:$query = "SELECT top 12 * 数据库名称 order by id desc";三、建立查询并取出数据1、odbc复制代码代码如下:$result = odbc_do($con,$query);while(odbc_fetch_row($result)){$变量名称 = odbc_result($result, "字段名称");}2、连接mssql2000复制代码代码如下:$result = mssql_query($con, $query);while($row =mssql_fetch_array($result)){$变量名称 = $row["字段名称"];}3、连接mssql2008复制代码代码如下:$result = sqlsrv_query($con, $query);while($row = sqlsrv_fetch_array($result)){$变量名称 = $row["字段名称"];}在php5.3及以后的版本中不附带sqlsrv库了。所以要从微软这里下载。四、关闭连接
 

php + ms sql server 2005 数据库连接

Unable to connect to server says it cannot connect to the server

Add a port number and try
mssql_connect('localhost,1433′, USERNAME, PASSWORD);

If still If not, take a look at the reference article

http://www.bkjia.com/PHPjc/897687.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/897687.htmlTechArticlePHP connection to MSSQL2008/2005 database (SQLSRV) configuration example, mssql2008sqlsrv This article describes the example of PHP connection to MSSQL2008/2005 database ( SQLSRV) configuration method is shared with everyone for your reference. Tool...