How to work from PHP with MS SQL?

Question

PHP

Previously, when I needed to work from PHP with MS SQL (FreeBSD), I used the php_mssql package and did not know grief. Now in php 7.X this module is no longer supported. I'm reading sites now and I can't understand what is the working link? Someone writes about PHP+FreeTDS. Others are about PHP+ODBC. In the third manual PHP+FreeTDS+PDO_ODBC+ODBC+FreeTDS. What set of tools will make PHP work with MS SQL on FreeBSD 12?

Answer 1

I don't think there is any reason not to believe the official php documentation:

There are the following alternatives:
PDO_SQLSRV (Windows only)
PDO_ODBC
SQLSRV (Windows only)
Unified ODBC API

https://docs.microsoft.com/en-us/sql/connect/php/m...