MSSQL driver for PHP7

Scott_Huang · February 27, 2016, 7:21am

In PHP5, I download driver from microsoft and set it up in php.ini

extension=php_sqlsrv_56_ts.dll

extension=php_pdo_sqlsrv_56_ts.dll

It help me working fine to fetch data from MSSQL database both for Yii1 and Yii2.

Yii1:

‘dbAUSASLDATA’ => array(

        //'connectionString' =&gt; 'mssql:host=localhost;dbname=testdrive',


        'class' =&gt; 'CDbConnection',


        'connectionString' =&gt; 'sqlsrv:Server=ThatDBServerName;Database=ThatDatabaseName',


        //'emulatePrepare' =&gt; true,


        'username' =&gt; '',


        'password' =&gt; '',


        'charset' =&gt; 'utf8',


        'tablePrefix' =&gt; 'DBO.',


    ),

yii2:

return [

'class' =&gt; 'yii&#092;db&#092;Connection',


'dsn' =&gt; 'sqlsrv:Server=ThatDBServerName;Database=ThatDatabaseName',


'username' =&gt; '',


'password' =&gt; '',


'charset' =&gt; 'utf8',


'tablePrefix' =&gt; 'DBO.',

];

However, I did not find latest sql dirver for PHP7 from microsoft website.

Do any one can give a hint of it?

Thanks.

Scott_Huang · February 27, 2016, 7:44am

Btw, It will be work by using ODBC.odbc:Driver={SQL Server};

I just wonder do sqlrv driver ready for PHP7?

samdark · February 27, 2016, 9:51pm

PDO is in the works: https://github.com/Azure/msphpsql/issues/58

Scott_Huang · February 28, 2016, 12:39am

Ok, then I use ODBC firstly and wait until PDO ready in case want upgrade to PHP7 immediately.