asked on 6/14/2021

PHP 7.4 and using PDO instead of sqlsrv

I am converting a program from PHP 5.6 to use PHP 7.4. And I am confused about PDO.
I thought in using PHP 7.4, I would need to change all of my SQL statements to use PDO syntax.
But I am finding out, that doesn't seem to be the case. I understand PDO is probably the better
approach of the two.
Could someone be as so kind to clarify for me ??
Thank you in advance.

PHP

Last Comment

Marthaj

6/14/2021

Dave Baldwin

6/14/2021

You need the SQLSRV driver to get the PDO version. All PDO drivers require a database specific driver to go with the main PDO extension. extension=php_sqlsrv.dll and/or extension=php_pdo_sqlsrv.dll
https://github.com/microsoft/msphpsql

ASKER CERTIFIED SOLUTION

Chris Stanyon

6/14/2021

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Marthaj

6/14/2021

ASKER

Thank you both for responding. Clears the air for me ! They have always used MS SQL Server and I can not at this point, see them changing it. Upgrading - yes .....changing to another Database type - nope...but now you watch...after writing this I may end up with egg on my face .LOL.