Thinkphp5 使用PDO-odbc连接到sqlserver
<?php
namespace app\index\controller;
use PDO;//导入PDO
class Index
{
public function index()
{
$mssqldriver = '{SQL Server Native Client 11.0}';
$hostname='192.168.1.77';
$dbname='his999';
$username='sa';
$password='9999';
$dbDB = new PDO("odbc:Driver=$mssqldriver;Server=$hostname;Database=$dbname", $username, $password);
$sql = "SELECT xm,gh,MM FROM zd_qyzg";
$sth =$dbDB ->query($sql);
$result = $sth->fetchAll();
echo $result[0][1];
dump($result);
}
}