MS Sql Connection using PHP in Linux

Question

I am tring to access MS Sql Server from linux os I am successfuly connect MS Sql Server I alredy set DSN by configure files odbcinst.ini and odbc.ini in odbcinst.ini file [FreeTDS] Description = Freetds v 0.95 Driver=/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so in odbc.ini [MSSQLServer] Driver = FreeTDS Trace = No Server = IP Address Port = 1433 Database = Data Base Name User = login Password = password on command prompt of linux I can connect MS SQl Server and fetch data succesfuly. but when I try connect in php I tried both way to connect MS Sql Server 1> $conn = sqlsrv_connect( $serverName $connectionOptions ) 2> $conn = odbc_connect($dsn$user$password); both time nothing get (error or message).

Rajkiran Swain · Answer

$server = 'localhost' ; $user = 'someUser' ; $pass = 'somePassword' ; $database = 'theDatabaseName' ; try { $pdo = new \PDO( sprintf( dblib:host=%s;dbname=%s  $server $database ) $user $pass ); $pdo->setAttribute(PDO::ATTR_ERRMODE PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo There was a problem connecting.  . $e->getMessage(); } $query = SELECT * FROM TestSchema.Employees ; $statement = $pdo->prepare($query); $statement->execute(); $results = $statement->fetchAll(PDO::FETCH_ASSOC); var_dump($results);