如何从CentOS 7上安装的PHP 7，Plesk 12.5连接MSSQL [英] How to connect MSSQL from PHP 7, Plesk 12.5 installed on CentOS 7

问题描述

我的Plesk 12.5安装在CentOS 7上，并同时支持多个php版本.我已经为5.4.16版的PHP成功安装了pdo_dblib驱动程序.有谁知道如何为php 7安装类似的驱动程序. 我在php7上启用了PDO，并支持PDO驱动程序mysql，odbc，pgsql，sqlite. 我如何添加mssql. 我找到了这个链接 库我需要php70w-pdo_dblib ，但如何安装? 在plesk网站上的问题

My Plesk 12.5 installed on CentOS 7 and supporting multiple php versions in same time. I have successfully installed pdo_dblib driver for php version 5.4.16. Does anybody knows how to install similar driver for php 7. I have PDO enabled on php7 and support PDO drivers mysql, odbc, pgsql, sqlite. How I can add mssql. I found this links library I need php70w-pdo_dblib but how I can installed? question on the plesk site

推荐答案

感谢大家的帮助. 我已经解决了我的问题，只需将MSSQL与ODBC diver(与PHP7一起提供)连接 您需要确保拥有

Thanks everybody for the help. I have resolved my problem by simply connect MSSQL with ODBC diver, which is come together with PHP7 You need to make sure you have

/etc/odbc.ini

/ etc/odbc.ini

[SomeName]
Description = " SomeName "
Driver = FreeTDS
Trace = No
Servername = TestServer
Database = dbname
UserName = username
Password = pass

[Default]
Driver = /usr/lib64/libtdsS.so.1

/etc/freetds.conf

/etc/freetds.conf

[TestServer]
host =dbhostname
port = 1433
client charset = UTF-8
tds version = 8.0

然后在php

     $db = new PDO("odbc: SomeName ", " username ", " pass");
$sql = " select *……."
$stmt = $db->prepare($sql);
        $stmt->execute();

这篇关于如何从CentOS 7上安装的PHP 7，Plesk 12.5连接MSSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！