Can PHP integrate with microsoft sql by using mysqli?

[FooKelvin]

Hi,

Is that possible to connect to microsoft sql server by using mysqli?

 

Currently i connected by using sqlsrv.

 

For example,

$serverName = "servername.com"; //serverName\instanceName
$connectionInfo = array("Database" => "DB1", "UID" => "user99", "PWD" => "12345");
$conn = sqlsrv_connect($serverName, $connectionInfo);

i have try quite some time to use mysqli to connect. But I keep getting errors..

 

 

Thank You

[Barand]

No. mysqli_ functions, like mysql_ , are for the MySql database server just as sqlsrv functions are for MS SQL Server.

 

PDO, however, is database independent so you could use that.

[FooKelvin]

Thanks Barand. PDO, a new thing for me. Thanks A lot!

[Barand]

Why do you want to change from sqlsrv if you are still using SQLServer?